A relational-XML data warehouse for data aggregation with SQL and XQuery

Software - Practice and Experience

Volumn 38, Issue 11, 2008, Pages 1183-1213

  Fong, Joseph ^a   Shiu, Herbert ^a   Cheung, Davy ^a  

^a CITY UNIVERSITY OF HONG KONG   (Hong Kong)

Author keywords

Aggregation data; Data integration; Data warehouse; Metadata; Relational data cube; Schema integration; SQL; XML data cube; XQuery

Indexed keywords

ADMINISTRATIVE DATA PROCESSING; AGGLOMERATION; COMPUTER SOFTWARE; DATA WAREHOUSES; DATABASE SYSTEMS; ELECTRONIC COMMERCE; HYPERTEXT SYSTEMS; INDUSTRIAL MANAGEMENT; INFORMATION MANAGEMENT; MARKUP LANGUAGES; MIDDLEWARE; QUERY LANGUAGES; STANDARDS; WAREHOUSES; XML;

AGGREGATION DATA; BUSINESS APPLICATIONS; BUSINESS INTELLIGENCE; DATA AGGREGATION; DATA CUBES; DATA INTEGRATION; DATA REPRESENTATIONS; DATA WAREHOUSE; E-COMMERCE; EXTENSIBLE MARKUP LANGUAGE; HETEROGENEOUS DATABASE SYSTEMS; INTEGRATING INFORMATION; MATERIALIZED VIEWS; METADATA; MULTIPLE DATA SOURCES; ON-LINE-ANALYTICAL PROCESSING; PRODUCTION DATA; RELATIONAL DATA CUBE; RELATIONAL TABLES; SCHEMA INTEGRATION; SQL; STANDARD SOLUTIONS; XML DATA; XML DATA CUBE; XQUERY;

DATA PROCESSING;

EID: 52749093996     PISSN: 00380644     EISSN: 1097024X     Source Type: Journal    
DOI: 10.1002/spe.868     Document Type: Article

References (25)

1. Katz H, Chamberlin D, Draper D, Fernandez M, Kay M, Robie J, Rys M, Simeon J, Tivy J, Wadler P. XQuery from the Experts: A Guide to the W3C XML Query Languages, Katz H (ed.). Addison-Wesley: Reading, MA, 2004; 187-234, 355.
2. Zhu H, Siegel MD, Madnick SE. Information aggregation-A value-added E-service. http://ebusiness.mit.edu/research/papers/106%20SMadnick, %20Siegel%20Information%20Aggregation.pdf, Working Paper #106, 2001 [1 June 2001].
3. Madnick SE, Siegel MD. Seizing the opportunity: Exploiting web aggregation, http://ebusiness.mit.edu/research/papers/144%20Madnick, Aggregator.pdf, Working Paper #144, 2001 [7 December 2001].
4. High-Performance Information Aggregation Using XML-Based Operational Data Servers. http://www.zapfhink.com/report.html?id=WP-0114 [1 May 2003].
5. Madnick S, Zhu H. Improving data quality through effective use of data semantics. Data & Knowledge Engineering 2006; 59:460-475.
6. Building XQuery Based Web Service Aggregation and Reporting Applications, http://www.stylusstudio.com/xquery.tutorial.html [1 January 2004].
7. Mid Tier XML Market Opportunities, Strategies, and Forecasts, 2004 to 2009. http://www.giichinese.com.tw/chinese/wg17637_XML_market_toc.html [1 January 2004].
8. Chaudhri AB, Rashid A, Zicari R. XML Data Management: Native XML and XML-Enabled Database Systems (1st edn). Addison-Wesley: Reading, MA, 2003.
9. Xyleme L. Xyleme, a dynamic warehouse for XML data of the web. International Symposium on Database Engineering and Applications, Grenoble, France, 2001; 3-8.
10. Pedersen D, Riis K, Pedersen TB. XML-extended OLAP querying. Proceedings of the 14th International Conference on Scientific and Statistical Database Management (SSDBM'02), Edinburgh, Scotland, 2002.
11. Park B, Han H, Song I. XML-OLAP: A multidimensional analysis framework for XML warehouses. Proceedings of DAWAKV'05 (Lecture Notes in Computer Science, vol. 3589). Springer: Berlin, 2005; 32-42.
12. Kimball R, Caserta J. The Data Warehouse ETL Toolkit. Wiley: New York, 2004, ISBN: 0-764-56757-8.
13. Fong J, Li Q, Huang SM. Universal data warehousing based on a meta-data modeling approach. International Journal of Cooperative Information System 2003; 12(3):325-363.
14. IEEE Society Distinguish the Type of Middleware. http://dsonline. computer.org/portal/site/dsonline/menuitem.20d6846e1c7ed783f1a516106bbe36ec/ index.jsp?&pName=dso_level1_home&path=dsonline/topics/ middleware&file=index.XML&xsl=generic.xsl& [1 January 2004].
15. Aggregate Data with Xquery from Oracle Technical Network, http://www.oracle.com/technology/oramag/oracle/05-mar/o25XML.html [1 March 2005].
16. Han J, Kamber M. Data Mining: Concepts and Techniques. Morgan Kaufmann: Los Altos, CA, 2001; 58-70.
17. Fong J. Information Systems Reengineering and Integration. Springer: Berlin, 2006; 21-22, 160-198.
18. Lee D, Chu WW. CPI: Constraints-preserving inlining algorithm for mapping XML DTD to relational schema. Data & Knowledge Engineering 2001; 39(1):3-25.
19. Deitel HM, Deitel PJ, Nieto TR, Lin T, Sadhy P. XML How to Program. Prentice-Hall: Englewood Cliffs, NJ, 2001; 297-318.
20. Kwan I, Fong J. Schema integration methodology and its verification by use of information capacity. Information Systems 1999; 24(5):355-376.
21. Poe V, Klanuer P, Brost S. Building a Data Warehouse for Decision Support (2nd edn), ch. 9. Designing the database for a data warehouse. Prentice-Hall: Englewood Cliffs, NJ, 1998.
22. Han J, Kamber M. Data Mining: Concepts and Techniques, ch. 2. Morgan Kaufmann: Los Altos, CA, 2001; 39-103.
23. Chase N. XML Primer Plus. SAMS: Indianapolis, Indiana, 2003; 47-113, 291-373.
24. Morgenthal JP, La Forge B. Enterprise Application Integration with XML and Java. Prentice-Hall PTR, 2001; 131-146, 291-373, 719-853.
25. http://www.w3org/2003/Talks/1211-XML2003-wssoa [11 December 2003].