Enabling policy-based access control in BI applications

Data and Knowledge Engineering

Volumn 66, Issue 2, 2008, Pages 199-222

  Bhatti, Rafae ^a   Gao, Dengfeng ^a   Li, Wen Syan ^a  

^a IBM ALMADEN RESEARCH CENTER   (United States)

Author keywords

Access control; Business intelligence; Security

Indexed keywords

ADMINISTRATIVE DATA PROCESSING; BISMUTH; BISMUTH PLATING; CONTROL SYSTEMS; DATA WAREHOUSES; DATABASE SYSTEMS; INDUSTRIAL MANAGEMENT; INDUSTRY; MANAGEMENT INFORMATION SYSTEMS; MIDDLEWARE; REGULATORY COMPLIANCE; SECURITY SYSTEMS; WAREHOUSES;

(R ,S ,S) POLICY; APPLIED (CO); BASE TABLE; BUSINESS INTELLIGENCE (BI); CONTROL FEATURES; ELSEVIER (CO); EMPIRICAL EVALUATIONS; MATERIALIZED VIEWS; POLICY-BASED FRAMEWORK; PRIVACY PROTECTION; SENSITIVE INFORMATIONS;

ACCESS CONTROL;

EID: 45249101563     PISSN: 0169023X     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.datak.2008.03.003     Document Type: Article

References (29)

1. Oracle Database Data Warehousing Guide 10g Release 1 (10.1), Oracle Technical Documentation. .
2. DB2 Label-Based Access Control Overview, IBM Technical Article. .
3. TPC-H benchmark. .
4. S. Jajodia, R. Sandhu, Toward a multilevel secure relational data model, in: Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data, Denver, CO, USA, May 2001.
5. Q. Li, B. Moon, Indexing and Querying xml Data for Regular Path Expressions, in: International Conference on Very Large Data Bases, September 2001, pp. 361-370.
6. Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy M. Lohman, Alan Skelley, DB2 Advisor: an optimizer smart enough to recommend its own indexes, in: International Conference on Data Engineering, 2000.
7. Daniel C. Zilio, Jun Rao, Sam Lightstone, Guy M. Lohman, Adam Storm, Christian Garcia-Arellano, Scott Fadden, DB2 Design Advisor: integrated automatic physical database design, in: International Conference on Very Large Data Bases, 2004.
8. Daniel C. Zilio, Calisto Zuzarte, Sam Lightstone, Wenbin Ma, Roberta Cochrane, Guy M. Lohman, Hamid Pirahesh, Latha S. Colby, Jarek Gryz, Eric Alton, Dongming Liang, Gary Valentin, Recommending materialized views and indexes with IBM DB2 design advisor, in: International Conference on Autonomic Computing, 2004.
9. Rundensteiner E.A., Koeller A., and Zhang X. Maintaining data warehouses over changing information sources. Communications of the ACM 43 6 (2000) 57-62
10. D. Agrawal, A. El Abbadi, A. Singh, T. Yurek, Efficient view maintenance in data warehouses, in: Proceedings of the 1997 ACM International Conference on Management of Data, May 1997, pp. 417-427.
11. K. Salem, K.S. Beyer, R. Cochrane, B.G. Lindsay, How to roll a join: asynchronous incremental view maintenance, in: Proceedings of the 2000 ACM International Conference on Management of Data, May 2000, pp. 129-140.
12. S. Agrawal, S. Chaudhuri, V. Narasayya, Automated selection of materialized views and indexes for SQL database, in: International Conference on Very Large Data Bases, 2000.
13. B. Dagerville, D. Das, K. Dias, K. Yagoub, M. Zait, M. Ziauddin, Automatic SQL tuning in Oracle 10g, in: International Conference on Very Large Data Bases, 2004, pp. 1098-1109.
14. Mehmet Altinel, Christof Bornhövd, Sailesh Krishnamurthy, C. Mohan, Hamid Pirahesh, Berthold Reinwald, Cache tables: paving the way for an adaptive database cache, in Proceedings of the 29th International Conference on Very Large Data Bases, Berlin, Germany, September 2003, pp. 718-729.
15. Paul Larson, Jonathan Goldstein, Jingren Zhou. MTCache: transparent mid-tier database caching in SQL server. in: International Conference on Data Engineering, 2004.
16. S. Agrawal, E. Chu, V. Narasayya, Automatic physical design tuning: workload as a sequence, in: ACM SIGMOD International Conference on Management of Data, 2006.
17. Jingren Zhou, Paul Larson, Jonathan Goldstein, Luping Ding, Dynamic materialized views, in: International Conference on Data Engineering, 2007.
18. Griffiths P.P., and Wade B.W. An authorization mechanism for a relational database system. ACM Transactions on Database Systems 1 3 (1976) 242-255
19. M. Stonebraker, E. Wong, Access control in a relational data base management system by query modification, In Proceedings of the 1974, January 1974.
20. Ullman J.D. Principles of Database Systems (2001), Galgotia Publications
21. Data classification with Oracle label security, Oracle White Paper. .
22. DB2 Label-Based Access Control: A Practical Guide, IBM Technical Documentation. .
23. W. Rjaibi, P. Bird, A multi-purpose implementation of mandatory access control in relational database management systems, in: Proceedings of the 2004 International Conference on Very Large Data Bases, Toronto, Canada, 2004.
24. A. Rosenthal, E. Sciore, View security as the basis for data warehouse security, in: Proceedings of the 2000 International Workshop on Design and Management of Data Warehouses, Stockholm, Sweden, June 2000.
25. A. Motro, An access authorization model for relational databases based on algebraic manipulation of view definitions, in: Proceedings of the 1989 International Conference on Data Engineering, Los Angeles, CA, USA, February 1989.
26. S. Rizvi, A. Mendelzon, S. Sudarshan, P. Roy, Extending query rewriting techniques for fine-grained access control, in: Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data, Paris, France, June 2004.
27. R. Agrawal, J. Kiernan, R. Shrikant, Y. Xu, Hippocratic databases, in: Proceedings of the 2002 International Conference on Very Large Data Bases, Hong Kong, China, June 2002.
28. Oracle Virtual Private Database, Oracle White Paper. .
29. C. Choi, J.X. Yu, H. Lu, Dynamic materialized view management based on predicates, in: Proceedings of the 2003 Asia-Pacific Web Conference, Xian, China, April 2003.