A Model of Authority Management for the Protection of Personal Information in OLAP

OLAP 환경에서 개인정보보호를 위한 개인정보 분리 권한관리 모델

  • 김형규 (숭실대학교 SW특성화대학원) ;
  • 김민호 (숭실대학교 SW특성화대학원) ;
  • 권정숙 (숭실대학교 SW특성화대학원) ;
  • 최용락 (숭실대학교 SW특성화대학원)
  • Received : 2014.04.24
  • Accepted : 2014.06.13
  • Published : 2014.06.30


Personal information has been stolen continuously and it is also affected from development of the Internet. So the government requires that companies spend more effort for protecting customers' personal information. The OLAP server also should meet this requirement, but it is hard to satisfy for the authority management. The OLAP server must use personal information to extract required information from database. This thesis suggests a model of separating between general information and personal information, so this model can help to minimize the leakage of personal information. The model is implemented and tested as a prototype. This prototype can prove that the new model is better than the original one. This study presents that the authority management on the separation between personal information and general information helps protect the personal information of customers.


  1. 서우석, 전문석, "효율적인 계층별 관리자 및 내부 사용자 권한관리 및 접근제어에 관한 연구", 한국전자통신학회학술대회지, 제5권, 제2호(2011), pp.181-185.
  2. 유진호, 지상호, 임종인, "개인정보 유노출 사고로 인한 기업의 손실비용 추정", 정보보호학회논문지, 제19권, 제4호(2009), pp.63-75.
  3. 정보통신망 이용촉진 및 정보보호 등에 관한 법률, 국가법령정보센터, 개정 2012. 2. 17,
  4. 조성규, 전문석, "개인정보보호를 위한 개인정보 유출 모니터링 시스템의 설계", 정보보호학회논문지, 제22권, 제1호(2012), pp.99-106.
  5. 조재희, "OLAP 테크놀로지의 이해", 정보과학회지, 제21권, 제10호(2003), pp.23-30.
  6. Codd, E. F., S. B. Codd, and C. T. Salley, Providing OLAP to User-Analysts : An IT Mandate, White Paper, Codd and Date Inc., 1993.
  7. Chaudhuri, S. and U. Dayal, An Overview of Data Warehousing and OLAP Technology, ACM, 1997.
  8. Sarawagi, S., R. Agrawal, and N. Megiddo, Discovery-Driven Exploration of OLAP Data Cubes, Springer, 1998.
  9. Vassiliadis, P. and T. Sellis, "A Survey of Logical Models for OLAP Databases", ACM Sigmod Record, Vol.28, No.4(1999), pp.64-69.
  10. Zaiane, O. R., M. Xin, and J. Han, Discovering Web Access Patterns and Trends by Applying OLAP and Data Mining Technology on Web Logs, IEEE, 1998.