e-CRM 향상을 위한 MLS 관계 데이터 모델의 구현에 관한 연구

Abstract

MLS(Multi Level Security), which is access control technology based on classification by designating a security grade on each element of a system, has been used for information management under a situation that requires a traditionally strict security system. MLS data model refer to data model applying MLS to database, and MLS relational data model refer to data model applying MLS to relational database.

Currently, major active application fields of MLS include 1) the area presenting security model for multi-inherited object-oriented data model, 2) the area of access control mechanisms at the level of operating system, 3) ML-RBBAC(Multi Level-Role Behavior Based Access Control), and 4) MISSI(Multilevel Information System Security Initiative), a project being implemented by the NSA(National Security Agency) in order to provide a security solution for the US Department of Defense network.

When CRM(Customer Relationship Management) is included in e-Business solutions, it is called e-CRM solution and e-CRM solutions provide information services to both customers and companies. The general purpose of the e-CRM solutions is to ensure consistent information delivery, installation costs, and expandability for integration and flexibility. MLS relational data model can be effectively applied to the process of achieving this general purpose.

This paper presents the way by which MLS can be used to achieve the general purpose of e-CRM solutions for e-business. This study proposes changing the normal three-layer database structure which generally consists of external schema, conceptual schema, and internal schema by appending MLS schema layer to configuration of the relational database system. By introducing this four-layer structure into e-CRM, this study shows the implementation of the MLS relational data model in commercial relational database system without the use of any additional systems.

This paper, first analyzes e-CRM using the MLS relational data model in a field of application programs by applying components at the business logic layer, and then implements e-CRM using the MLS relational data model in the environment of the MS-SQL Server which is a kind of RDBMS.

It is expected that e-CRM extending relational data model to MLS relational data model will be helpful because it will provide suitable information to various customers and business partners in a more effective way.