OLAP Operators for a Complex Object-oriented Multidimensional Model

• Autorzy: Doulkifli Boukraa , Omar Boussaid , Fadila Bentayeb , Sabine Loudcher

Warianty tytułu

Operatory OLAP dla złożonych obiektowo zorientowanych wielowymiarowych modeli danych

• Języki publikacji: EN

Abstrakty

EN

The data warehousing process should be adapted in response to complex data. Only few works address the issues of managing and analyzing complex data. Warehousing complex data involves different issues regarding their structure, storage, processing and analysis. Dimensional modeling must be adapted to complex data to take into account their specificities. In this paper, we propose an Object-Oriented (O-O) Data Warehouse Model capable to efficiently manage and analyze complex data. We also define a set of O-O OLAP operators in order to construct data cubes. In this context, semantic richness of O-O models will not only facilitate integration, but will also help analysts to understand the real meaning of data. Our O-O model has the main advantage of integrating various aspects of data complexity and thus of providing different points of view of the same data for a better decision making.(original abstract)

W artykule przedstawiono proces zarządzania i analizy złożonych obiektów w hurtowniach danych. Specyfika złożonych obiektów w hurtowniach dotyczy ich struktury, pamięci, procesów przetwarzania i analizy. Autorzy artykułu zaproponowali obiektowo-zorientowany model hurtowni danych umożliwiający efektywne zarządzanie złożonymi strukturami danych i ich analizę. Zostały też zdefiniowane obiektowo zorientowane operatory OLAP działające na kostkach (ang. data cube) danych. Semantyczne walory modelu obiektowego nie tylko ułatwiają integrację danych, lecz także pozwalają lepiej zrozumieć rzeczywiste znaczenie danych.(abstrakt oryginalny)

Słowa kluczowe

EN

Data warehouse; Online analytical processing (OLAP) systems; Databases management

PL

Hurtownie danych; Systemy OLAP; Zarządzanie bazami danych

• Czasopismo: Prace Naukowe Uniwersytetu Ekonomicznego we Wrocławiu. Informatyka Ekonomiczna
• Rocznik: 2010
• Tom: 16
• Numer: nr 104 Data Mining and Business Intelligence
• Strony: 34--46

Twórcy

autor

Doulkifli Boukraa

• National High School of Computer Science, Oued Smar, Algieria

autor

Omar Boussaid

• ERIC Laboratory, University of Lyon, LumiereLyon 2, Bron, Francja

autor

Fadila Bentayeb

• ERIC Laboratory, University of Lyon, LumiereLyon 2, Bron, Francja

autor

Sabine Loudcher

• ERIC Laboratory, University of Lyon, LumiereLyon 2, Bron, Francja

Bibliografia

• Boussaїd O., Ben Messaoud R., Choquet R., Anthoard S. (2006), X-warehousing: An ML-based approach for warehousing complex data, [in:] 10th East-European Conference on Advances in Data-bases and Information Systems (ADBIS 2006), Eds. Y. Manolopoulos, J. Pokorny, T.K. Sellis, Lecture Notes in Computer Science, Vol. 4152, Springer, 2006, pp. 39-54.
• Boussaїd O., Tanasescu A, Bentayeb R, Darmont J. (2007), Integration and dimensional modelling approaches for complex data warehousing, Journal of Global Optimization, Vol. 37, No. 4, pp. 571-591.
• Bhowmick S.S., Madria S.K., Ng W.K. (2003), Web Data Management: A Warehouse Approach, Springer Verlag,. New York.
• Chaudhuri S., Dayal U. (1997), An overview of data warehousing and OLAP technology, SIGMOD Record, Vol. 26, No. l, ACM, pp. 65-74.
• Darmont J., Boussaїd O., Ralaivao J.C., Aouiche K. (2005), An architecture framework for complex data warehouses, [in:] 7"1 International Conference on Enterprise Information Systems (ICEIS 2005), Computing Research Repository, Vol. abs/0707.1534.
• Golfarelli M., Rizzi S., Vrdoljak B. (2001), Data warehouse design from XML sources, [in:] Proceed-ings ofthe 4"1 International Workshop on Data Warehousing and OLAP (DOLAP 2001), ACM, pp. 40-47.
• Gómez L.I., Kuijpers B., Moelans B., Vaisman A.A. (2009), A survey of spatio-temporal OLAP, International Journal of Data Warehousing and Mining, Vol. 5, No. 3, pp. 28-55.
• Inokuchi A., Takeda K. (2007), A method for online analytical processing of text data, [in:] Proceedings of the I6'h Conference on Information and Knowledge Management (CIKM2007), Eds. M.J. Silva, A.H.F. Laender, R.A. Baeza-Yates, D.L. McGuinness, B. Olstad, 0.H. Olsen, A.O. Falcão, ACM, 2007, pp. 455-464.
• Keith S., Kaser O., Lemire D. (2006), Analyzing large collections of electronic text using OLAP, Computing Research Repository, Vol. abs/cs/0605127.
• Kimball R., Ross M. (2002), The Data Warehouse Toolkit, John Wiley and Sons, New York.
• Li Y, An A. (2005), Representing UML snowflake diagram from integrating XML data using XML schema, [in:] Proceedings of the ICDE International Workshop on Data Engineering Issues in E-Commerce (DEEC 2005), IEEE Computer Society, pp. 103-111.
• Lujan-Mora S. (2002), Multidimensional modeling using UML and XML, [in:] 12th Workshop for PhD Students in Object-Oriented Systems (PhDOOS 2002), I6th European Conference on Object-Oriented Programming (ECOOP 2002), Ed. B. Magnusson, Lecture Notes in Computer Science, Vol. 2548, Springer, pp. 48-49.
• Mothe J., Chrisment C., Dousset B., Alaux J. (2003), DocCube: Multi-dimensional visualisation and exploration of large document sets, Journal of the American Society for Information Science and Technology, Special topic section: Web Retrieval and Mining, Guest Editor H. Chen, Vol. 54, No. 7, pp. 650-659.
• Nassis V., Rajugan R., Dillon T.S., Rahayu W. (2004), Conceptual design of XML document ware-houses, [in:] Proceedings of 6th International Conference on Data Warehousing and Knowledge Discovery (Dawak 2004), Eds. Y. Kambayashi, M.K. Mohania, W. Wöß, Lecture Notes in Computer Science, Vol. 3181, Springer, pp. 1-14.
• Park B.K., Han H., Song L-Y. (2005), XML-OLAP: A multidimensional analysis framework for XML warehouses, [in:] Proceedings of 7th International Conference on Data Warehousing and Knowledge Discovery (Dawak 2005), Eds. A.M. Tjoa, J. Trujillo, Lecture Notes in Computer Science, Vol. 3589, Springer, pp. 32-42.
• Pedersen T.B., Jensen C.S. (1999), Multidimensional data modeling for complex data, [in:] Proceedings of the I5th International Conference on Data Engineering (ICDE 1999), IEEE Computer Society, pp. 336-345.
• Rafanelli M. (2003), Multidimensional Databases: Problems and Solutions, Idea Group Publishing, Hershey, PA,.
• Ravat F., Teste O. (2000), Object-oriented decision support system, [in:] Proceedings of the 2nd International Conference on Enterprise Information Systems (ICEIS 2000), Eds. B. Sharp, J. Cordeiro, J. Filipe, Stafford, pp. 79-84.
• Trujillo J., Palomar M. (1998), An object-oriented approach to multidimensional database conceptual modeling, [in:] Proceedings of the 1st International Workshop on Data Warehousing and OLAP (DOLAP 1998), ACM, pp. 16-21.
• Vrdoljak B., Banek M., Rizzi S. (2003), Designing Web warehouses from XML schemas, [in:] Proceedings of the 5th International Conference on Data Warehousing and Knowledge Discovery (Dawak 2003), Eds. Y. Kambayashi, M.K. Mohania, W. Wöß, Lecture Notes in Computer Science, Vol. 2737, Springer, pp. 89-98.
• Wong S.T.C., Hoo K.S. Jr, Knowlton R.C., Laxer K.D., Cao X., Hawkins R.A., Dillon W.P., Arenson R.L. (2001), Design and applications of a multimodality image data warehouse framework, The Journal of the American Medical Informatics Association, Vol. 9, No. 3, pp. 239-254.
• Wong R.K., Lam F., Orgun M.A. (2001), Modelling and manipulating multidimensional data in semi-structured databases, World Wide Web, Vol. 4, No. 1-2, pp. 79-99.