Finding an application-appropriate model for XML data warehouses

Information Systems

Volumn 35, Issue 6, 2010, Pages 662-687

  Ravat, Franck ^a   Teste, Olivier ^a   Tournier, Ronan ^a   Zurfluh, Gilles ^a  

^a UNIVERSITÉ DE TOULOUSE   (France)

Author keywords

Data warehouse; Decision support system; Document warehouse; OLAP; XML

Indexed keywords

APPROPRIATE MODELS; COMPLEX DATA; CORPORATE DATA; DATA WAREHOUSING; DECISION MAKING PROCESS; DOCUMENT STORAGE; DOCUMENT WAREHOUSE; OLAP; ON-LINE ANALYTICAL PROCESSING; TEXT FORMAT; XML (EXTENSIBLE MARKUP LANGUAGE); XML DATA; XML DATA SOURCES; XML TECHNOLOGY; XML WAREHOUSING;

ARTIFICIAL INTELLIGENCE; DATA PROCESSING; DECISION MAKING; DECISION SUPPORT SYSTEMS; DECISION THEORY; HYPERTEXT SYSTEMS; MARKUP LANGUAGES; QUERY LANGUAGES; XML;

DATA WAREHOUSES;

EID: 77955231678     PISSN: 03064379     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.is.2009.12.002     Document Type: Article

References (100)

1. S. Abiteboul, S. Cluet, G. Ferran, and M.-C. Rousset The Xyleme project J. Comput. Networks 39 3 2002 225 238
2. R. Agrawal, A. Gupta, and S. Sarawagi Modeling Multidimensional Databases 13th International Conference on Data Engineering (ICDE) 1997 IEEE Computer Society 232 243
3. S. Amer-Yahia, S. Cho, and D. Srivastava Tree pattern relaxation Proceedings of the eighth International Conference on Extending Database Technology (EDBT), LNCS 2287 2002 Springer 496 513
4. A. Arion, V. Benzaken, I. Manolescu, and Y. Papakonstantinou Structured materialized views for XML queries 33rd International Conference on Very Large Data Bases (VLDB) 2007 ACM 87 98
5. N. Aussenac-Gilles, and J. Mothe Ontologies as background knowledge to explore document collections RIAO 2004 Conference Proceedings: Coupling Approaches, Coupling Media and Coupling Languages for Information Retrieval 2004 129 142
6. X. Baril, and Z. Bellahsne Designing and managing an XML warehouse A.B. Chaudhri, A. Rashid, R. Zicari, XML Data Management: Native XML and XML-Enabled Database Systems 2004 Addison Wesley 455 474
7. P.A. Bernstein, H. Ho, Model management and schema mappings: theory and practice, in: Tutorial of the 33rd International Conference on Very Large Data Bases (VLDB), 2007, pp. 14391440.
8. K.S. Beyer, D.D. Chamberlin, L.S. Colby, F. Ozcan, H. Pirahesh, and Y. Xu Extending XQuery for analytics Proceedings of the ACM International Conference on Management of Data (SIGMOD) 2005 ACM Press 503 514
9. S.S. Bhowmick, W.K. Ng, and S.K. Madria Web schemas in WHOMEDA Third ACM International Workshop on Data Warehousing and OLAP (DOLAP) 2000 ACM Press 17 24
10. S.S. Bhowmick, S.K. Madria, and W.K. Ng Detecting and representing relevant web deltas in WHOWEDA IEEE Transactions on Knowledge and Data Engineering (TKDE) 15 2 2003 423 441 IEEE Computer Society
11. J. Bleiholder, and F. Naumann Data fusion ACM Computing Surveys 41 1 2008 ACM Press
12. R. Bordawekar, and C.A. Lang Analytical processing of XML documents: opportunities and challenges SIGMOD Record 34 2 2005 27 32 ACM Press
13. O. Boussaid, R.B. Messaoud, R. Choquet, and S. Anthoard X-warehousing: an XML-based approach for warehousing complex data 10th East European Conference on Advances in Databases and Information Systems (ADBIS), LNCS 4152 2006 Springer 39 54
14. G. Colliat OLAP, relational, and multidimensional database systems ACM SIGMOD Record 25 3 1996 64 69
15. Dublin Core Metadata Initiative (DCMI): Dublin Core Metadata Element Set, Version 1.1, ISO Standard 15836, from 〈 http://dublincore.org/documents/ dces/ 〉 (September 2008).
16. F.-X. Dudouet, I. Manolescu, B. Nguyen, and P. Senellart XML warehousing meets sociology IADIS International Conference on WWW/Internet (ICWI) 2005 IADIS Press
17. M. Fang, N. Shivakumar, H. Garcia-Molina, R. Motwani, and J.D. Ullman Computing iceberg queries efficiently 24th International Conference on Very Large Data Bases (VLDB) 1998 Morgan Kaufmann 299 310
18. P. Fankhauser, and T. Klement XML for data warehousing chances and challenges, (extended abstract) Fifth International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 2737 2003 Springer 1 3
19. L. Findlater, and H.J. Hamilton Iceberg-cube algorithms: an empirical evaluation on synthetic and real data Journal of Intelligent Data Analysis 7 2 2003 77 97 IOS Press
20. N. Fuhr, and K. Großjohann XIRQL: a query language for information retrieval in XML documents 24th International ACM Conference on Research and Development in Information Retrieval (SIGIR) 2001 ACM Press 172 180
21. M. Golfarelli, D. Maio, and S. Rizzi The dimensional fact model: a conceptual model for data warehouses, invited paper International Journal of Cooperative Information Systems (ijCIS) 7 2&3 1998 215 247
22. M. Golfarelli, S. Rizzi, B. Vrdoljak, Data warehouse design from XML sources, in: Fourth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2001, pp. 4047.
23. J. Gray, A. Bosworth, A. Layman, H. Pirahesh, Data cube: a relational aggregation operator generalizing group-by, cross-tab, and sub-total, in: 12th International Conference on Data Engineering (ICDE), IEEE Computer Society, 1996, pp. 152159.
24. M. Gyssens, L.V.S. Lakshmanan, A foundation for multi-dimensional databases, in: 23rd International Conference on Very Large Data Bases (VLDB), Morgan Kaufmann, 1997, pp. 106115.
25. M. Hachicha, H. Mahboubi, J. Darmont, Expressing OLAP operators with the TAX XML algebra, in: Third International Workshop on Database Technologies for handling XML Information on the Web (DataX), ACM, 2008, pp. 6166.
26. V. Harinarayan, A. Rajaraman, J.D. Ullman, Implementing data cubes efficiently, in: ACM International Conference on Management of Data (SIGMOD), ACM Press, 1996, pp. 205216.
27. S.-M. Huang, C.-H. Su, The development of an XML-based data warehouse system, in: Third International Conference on Intelligent Data Engineering and Automated Learning (IDEAL), LNCS 2412, Springer, 2002, pp. 206212.
28. W. Hmmer, A. Bauer, G. Harde, XCube: XML for data warehouses, in: Sixth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2003, pp. 3340.
29. H.V. Jagadish, L.V.S. Lakshmanan, D. Srivastava, K. Thompson, TAX: a tree algebra for XML, in: Eighth International Workshop on Database Programming Languages (DBPL), LNCS 2397, Springer, 2001, pp. 149164.
30. H.V. Jagadish, L.V.S. Lakshmanan, M. Scannapieco, D. Srivastava, N. Wiwatwattana, Colorful XML: one hierarchy isn't enough, in: Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD), ACM, 2004, pp. 251262.
31. M.R. Jensen, T.H. Møller, T.B. Pedersen, Specifying OLAP cubes on XML data, in: 13th International Conference on Scientific and Statistical Database Management (SSDBM), IEEE Computer Society, 2001, pp.101112.
32. M.R. Jensen, T.H. Møller, and T.B. Pedersen Specifying OLAP cubes on XML data Journal of Intelligent Information Systems 17 2-3 2001 255 280 Springer, Netherlands
33. J. Kamps, M. Marx, M. de Rijke, B. Sigurbjrnsson, Best-match querying from document-centric XML, in: Proceedings of the Seventh International Workshop the Web and Databases (WebDB '04), 2004, pp. 5560.
34. S. Keith, O. Kaser, D. Lemire, Analyzing large collections of electronic text using OLAP, in: APICS 29th Conference in Mathematics, Statistics and Computer Science, Acadia University, 2005, pp. 1726.
35. K. Khrouf, and C. Soul-Dupuy A Textual Warehouse Approach: A Web Data Repository M. Mohammadian, Intelligent Agents for Data Mining and Information Retrieval 2004 Idea Publishing Group 101 124
36. R. Kimball, The Data Warehouse Toolkit. John Wiley, 1996; 2nd edition: R. Kimball, M. Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, Wiley and Sons, Chichester, 2003.
37. Y. Li, A. An, Representing UML snowflake diagram from integrating XML data using XML schema, in: International Workshop on Data Engineering Issues in E-Commerce (DEEC), IEEE Computer Society, 2005, pp. 103111.
38. E. Malinowski, and E. Zimnyi Hierarchies in a multidimensional model: from conceptual modeling to logical representation International Journal of Data & Knowledge Engineering (DKE) 59 2 2006 348 377 Elsevier
39. J.-N. Mazn, and J. Trujillo An MDA approach for the development of data warehouses Decision Support Systems (DSS) 45 1 2008 41 58 Elsevier
40. J.-N. Mazn, J. Lechtenbrger, J. Trujillo, A survey on summarizability issues in multidimensional modelling, in: Data & Knowledge Engineering, Elsevier, 2009 (accepted manuscript), doi:10.1016/j.datak.2009.07.010.
41. C. McCabe, J. Lee, A. Chowdhury, D.A. Grossman, O. Frieder, On the design and evaluation of a multi-dimensional approach to information retrieval, in: 23rd International ACM Conference on Research and Development in Information Retrieval (SIGIR), ACM Press, 2000, pp. 363365.
42. J. Melton, and S. Buxton Querying XML, XQuery, XPath, and SQL/XML in Context 2006 Elsevier Inc.
43. R.B. Messaoud, O. Boussaid, S. Rabasda, A new OLAP aggregation based on the AHC technique, in: Seventh ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2004, pp. 6572.
44. J. Mothe, C. Chrisment, B. Dousset, and J. Alau DocCube: multi-dimensional visualisation and exploration of large document sets Journal of the American Society for Information Science and Technology (JASIST) 54 7 2003 650 659 Wiley Periodicals
45. V. Nassis, R. Rajugan, T.S. Dillon, J.W. Rahayu, Conceptual design of XML document warehouses, in: Sixth International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 3181, Springer, 2004, pp. 114.
46. V. Nassis, R. Rajagopalapillai, T.S. Dillon, and J.W. Rahayu Conceptual and systematic design approach for XML document warehouses International Journal of Data Warehousing & Mining (ijDWM) 1 3 2005 63 87 Idea Group Publishing
47. V. Nassis, T.S. Dillon, R. Rajagopalapillai, J.W. Rahayu, An XML document warehouse model, in: 11th International Conference on Database Systems for Advanced Applications (DASFAA), LNCS 3882, Springer, 2006, pp. 513529.
48. T.B. Nguyen, A.M. Tjoa, O. Mangisengi, Meta cube-X: an XML metadata foundation for interoperability search among web data warehouses, in: Third International. Workshop on Design and Management of Data Warehouses (DMDW), CEUR Workshop Proceedings 39, CEUR-WS.org, 2001, p. 8.
49. T.B. Nguyen, A.M. Tjoa, O. Mangisengi, MetaCube XTM: a multidimensional metadata approach for semantic web warehousing systems, in: Fifth International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 2737, Springer, 2003, pp.7688.
50. T. Niemi, M. Niinimki, J. Nummenmaa, P. Thanisch, Constructing an OLAP cube from distributed XML data, in: Fifth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2002, pp.2227.
51. N.F. Noy Semantic integration: a survey of ontology-based approaches SIGMOD Record 33 4 2004 65 70 ACM
52. B.-K. Park, H. Han, I.-Y. Song, XML-OLAP: A multidimensional analysis framework for XML warehouses, in: Seventh International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 3589, Springer, 2005, pp. 3242.
53. D. Pedersen, K. Riis, T.B. Pedersen, XML-extended OLAP querying, in: 14th International Conference on Scientific and Statistical Database Management (SSDBM), IEEE Computer Society, 2002, pp. 195206.
54. D. Pedersen, T.B. Pedersen, Achieving adaptivity for OLAP-XML federations, in: Proceedings of the Sixth ACM International Workshop on Data warehousing and OLAP (DOLAP), ACM, 2003, pp. 2532.
55. D. Pedersen, J. Pedersen, T.B. Pedersen, Integrating XML data in the TARGITOLAP system, industrial paper, in: 20th International Conference on Data Engineering (ICDE), IEEE Computer Society, 2004, pp. 778781.
56. J.M. Prez, R. Berlanga Llavori, M.J. Aramburu, T.B. Pedersen, A relevance-extended multi-dimensional model for a data warehouse contextualized with documents, in: Eighth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2005, pp. 1928.
57. J.M. Prez, R. Berlanga Llavori, M.J. Aramburu, and T.B. Pedersen Contextualizing data warehouses with documents Decision Support Systems (DSS) 45 1 2008 77 94 Elsevier
58. J.M. Prez, R. Berlanga, M.J. Aramburu, and T.B. Pedersen Integrating data warehouses with web data: a survey IEEE Transactions on Knowledge and Data Engineering (TKDE) 20 7 2008 940 955
59. J. Pokorn, Modelling stars using XML, in: Fourth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2001, pp. 2431.
60. J. Pokorn, XML data warehouse: modelling and querying, in: Fifth International Baltic Conference on Databases and Information Systems (BalticDB&IS), vol. 1, Institute of Cybernetics (Tallin Technical University), 2002, pp. 267280.
61. J.M. Ponte, W.B. Croft, A language modeling approach to information retrieval, in: 21st International Conference on Research and Development in Information Retrieval (SIGIR), ACM Press, 1998, pp. 275281.
62. Y. Qi, K.S. Candan, J. Tatemura, S. Chen, F. Liao, Supporting OLAP operations over imperfectly integrated taxonomies, in: Proceedings of the ACM International Conference on Management of Data (SIGMOD), ACM, 2008, pp. 875888.
63. E. Rahm, and P.A. Bernstein A survey of approaches to automatic schema matching VLDB Journal 10 4 2001 334 350 Springer-Verlag
64. M. Rafanelli Operators for Multidimensional Aggregate Data M. Rafanelli, Multidimensional databases: Problems and solutions 2003 Idea Group Publishing 116 165
65. F. Ravat, O. Teste, R. Tournier, OLAP aggregation function for textual data warehouse, in: Ninth International Conference on Enterprise Information Systems (ICEIS), vol. DISI, INSTICC Press, 2007, pp. 151156.
66. F. Ravat, O. Teste, R. Tournier, Z. Zurfluh, A conceptual model for multidimensional analysis of documents, in: 26th International Conference on Conceptual Modeling (ER), LNCS 4801, Springer, 2007, pp. 550565.
67. F. Ravat, O. Teste, R. Tournier, Z. Zurfluh, Top-Keyword: an aggregation function for textual document OLAP, in: 10th International Conference on Data Warehousing and Knowledge Discovery (DaWak), LNCS 5182, Springer, 2008, pp. 5564.
68. F. Ravat, O. Teste, R. Tournier, Z. Zurfluh, Designing and implementing OLAP systems from XML documents, in: Kozielski, Stanislaw; Wrembel, Robert (Eds.), Annals of Information Systems vol. 3, special issues on New Trends in Data Warehousing and Data Analysis, Springer, 2008, pp. 295315.
69. S. Rizzi, A. Abell, J. Lechtenbrger, J. Trujillo, Research in data warehouse modeling and design: dead or alive? in: Ninth ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2006, pp.310.
70. C. Rolland, Towards engineering purposeful systems: a requirements engineering perspective, in: 19th International Confernce on Database and Expert Systems Applications (DEXA), LNCS 5181, Springer, 2008, pp. 14.
71. L.I. Rusu, J.W. Rahayu, D. Taniar, On building XML data warehouses, in: Fifth International Conference on Intelligent Data Engineering and Automated Learning (IDEAL), LNCS 3177, Springer, 2004, pp. 293299.
72. L.I. Rusu, J.W. Rahayu, and D. Taniar A Methodology for Building XML Data Warehouses International Journal of Data Warehousing & Mining (ijDWM) 1 2 2005 23 48 Idea Group Publishing
73. L.I. Rusu, J.W. Rahayu, D. Taniar, Warehousing dynamic XML documents, in: Eighth International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 4081, Springer, 2006, pp.175184.
74. L.I. Rusu, J.W. Rahayu, D. Taniar, Storage techniques for multi-versioned XML documents, in: 13th International Conference on Database Systems for Advanced Applications (DASFAA), LNCS 4947, Springer, 2008, pp. 538545.
75. A. Stavrianou, P. Andritsos, and N. Nicoloyannis Overview and semantic issues of text mining SIGMOD Record 36 3 2007 23 34 ACM Press
76. D. Sullivan Document Warehousing and Text Mining 2001 Wiley John & Sons New York
77. X. Tan, D.C. Yen, and X. Fang Web warehousing: web technology meets data warehousing Technology in Society (TechSoc) 25 1 2003 131 148 Elsevier
78. R. Torlone Conceptual Multidimensional Models Maurizio Rafanelli, Multidimensional databases: Problems and solutions 2003 Idea Group Publishing 69 90
79. F.S.C Tseng, XML-based heterogeneous database integration for data warehouse creation, in: Ninth Pacific Asia Conference on Information Systems (PACIS), 2005, pp. 590603.
80. F.S.C. Tseng, and A.Y.H. Chou The concept of document warehousing for multi-dimensional modeling of textual-based business intelligence Journal of Decision Support Systems (DSS) 42 2 2006 727 744 Elsevier
81. P. Vassiliadis, A. Simitsis, P. Georgantas, M. Terrovitis, and S. Skiadopoulos A generic and customizable framework for the design of ETL scenarios Journal of Information Systems (IS) 30 7 2005 492 525
82. B. Vrdoljak, M. Banek, S. Rizzi, Designing web warehouses from XML schemas, in: Fifth International Confernce on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 2737, Springer, 2003, pp.8998.
83. B. Vrdoljak, M. Banek, Z. Skocir, Integrating XML sources into a data warehouse, in: Second International Workshop on Data Engineering Issues in E-Commerce and Services (DEECS), LNCS 4055, Springer, 2006, pp. 133142.
84. H. Wang, J. Li, Z. He, H. Gao, Xaggregation: flexible aggregation of XML data, in: Fourth International Confernce on Advances in Web-Age Information Management (WAIM), LNCS 2762, Springer, 2003, pp.104115.
85. H. Wang, J. Li, Z. He, H. Gao, OLAP for XML data, in: Fifth International Conference on Computer and Information Technology (CIT), IEEE Computer Society, 2005, pp.233237.
86. WhoWeDa (WareHouse Of WEb Data), from the Web Warehousing & Mining Group 〈 http://mandolin.cais.ntu.edu.sg/∼whoweda/index.htm 〉, June 2009.
87. N. Wiwatwattana, H.V. Jagadish, L.V.S. Lakshmanan, D. Srivastava, X3: a cube operator for XML OLAP, in: IEEE 23rd International Conference on Data Engineering (ICDE), IEEE Computer Society, 2007, pp. 916925.
88. N. Wiwatwattana, H.V. Jagadish, A query processing architecture for an XML data warehouse, in: Proceedings of the 24th International Confernce on Data Engineering (ICDE), IEEE Computer Society, 2008, pp. 15131515.
89. N. Wiwatwattana XML Data Warehousing: Modeling, Design and Analysis 2008 VDM Verlag
90. World Wide Web Consortium (W3C) XML, eXtensible Markup Language 1.0 (4th Edition), W3C Recommendation 16 August 2006 from 〈 http://www.w3.org/TR/ xml/ 〉.
91. World Wide Web Consortium (W3C) XQuery 1.0, XML Query Language, W3C Recommendation 23 January 2007 (current working draft: XQuery 1.1 July 2008), from 〈 http://www.w3.org/TR/xquery/
92. World Wide Web Consortium (W3C), XML Path Language (XPath) 2.0, W3C Recommendation 23 January 2007 from 〈 http://www.w3.org/TR/xpath20/ 〉.
93. World Wide Web Consortium (W3C), W3C XML Schema Definition Language (XSD) 1.1 Part 1: Structures, W3C Candidate Recommendation 30 April 2009.
94. World Wide Web Consortium (W3C), W3C XML Schema Definition Language (XSD) 1.1 Part 2: Datatypes, W3C Candidate Recommendation 30 April 2009.
95. World Wide Web Consortium (W3C), XML Transformations (XSLT) version 2.0, W3C Recommendation 23 january 2007 from 〈 http://www.w3.org/TR/xslt20/ 〉.
96. R. Wrembel A survey on managing the evolution of data warehouses International Journal of Data Warehousing and Mining (ijDWM), IGI Publishing 5 2 2009 24 56 IGI Publishing
97. Xyleme server from 〈 http://www.xyleme.com 〉.
98. X. Yin, T.B. Pedersen, Evaluating XML-extended OLAP queries based on a physical algebra, in: Seventh ACM International Workshop on Data Warehousing and OLAP (DOLAP), ACM Press, 2004, pp. 7382.
99. J. Zhang, T.W. Ling, R.M. Bruckner, A.M. Tjoa, Building XML data warehouse based on frequent patterns in user queries, in: Fifth International Conference on Data Warehousing and Knowledge Discovery (DaWaK), LNCS 2737, Springer, 2003, pp. 99108.
100. Y. Zhuge, H. Garcia-Molina, Graph structured views and their incremental maintenance, in: Proceedings of the 14th International Conferenc on Data Engineering (ICDE), IEEE Computer Society, 1998, pp. 116125.