Abstract
Data warehouse is now widely used in business analysis and decision making processes. To adapt the rapidly changing business environment, we develop a tool to make data warehouses more business-friendly by using Semantic Web technologies. The main idea is to make business semantics explicit by uniformly representing the business metadata (i.e. conceptual enterprise data model and multidimensional model) with an extended OWL language. Then a mapping from the business metadata to the schema of the data warehouse is built. When an analysis request is raised, a customized data mart with data populated from the data warehouse can be automatically generated with the help of this built-in knowledge. This tool, called Enterprise Information Asset Workbench (EIAW), is deployed at the Taikang Life Insurance Company, one of the top five insurance companies of China. User feedback shows that OWL provides an excellent basis for the representation of business semantics in data warehouse, but many necessary extensions are also needed in the real application. The user also deemed this tool very helpful because of its flexibility and speeding up data mart deployment in face of business changes.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Baader, F., Sattler, U.: Description logics with concrete domains and aggregation. In: ECAI 1998. Proceeding of the 13th European Conference on Artificial Intelligence, pp. 336–340 (1998)
Berners-Lee, T., Handler, J., Lassila, O.: The Semantic Web. Scientific American 184(5), 34–43 (2001)
Cabbibo, L., Torlone, R.: A Logical Approach to Multidimensional Databases. In: Proceeding of the 6th International Conference on Extending Database Technology, pp. 183–197 (1998)
Franconi, E., Sattler, U.: A Data Warehouse Conceptual Data Model for Multidimensional Aggregation. In: DMDW 1999. Proceeding of Workshop on Design and Management of Data Warehouses, Heidelberg, Germany (1999)
Golfarelli, M., Maio, D., Rizzi, S.: The Dimensional Fact Model: a Conceptual Model for Data Warehouses. International Journal of Cooperative Information Systems 7(2,3), 215–247 (1998)
McComb, D.: Semantics in Business Systems: The Savvy Manager’s Guide. Morgan Kaufmann, San Francisco (2003)
Moody, D.L., Kortink, M.A.R.: From enterprise models to dimensional models: A methodology for data warehouse and data mart design. In: DMDW 2000. Proceeding of the 2nd International Workshop on Design and Management of Data Warehouses (2000)
Muller, R., Stohr, T., Rahm, E.: An Integrative and Uniform Model for Metadata Management in Data Warehousing Environments. In: Proceeding of International Workshop on Design and Management of Data Warehouses, pp. 12–28 (1999)
O’Neil, B.: Semantics and business metadata. The Data Administration Newsletter(TDAN.com) (2007)
Patel-Schneider, P.F., Hayes, P., Horrocks, I.: OWL Web Ontology Language Reference, W3C Recommendation (February 10, 2004) (2004), http://www.w3.org/TR/owl-ref/
Sapia, C., Blaschka, M., Höfling, G., et al.: Extending the E/R Model for the Multidimensional Paradigm. In: Kambayashi, Y., Lee, D.-L., Lim, E.-p., Mohania, M.K., Masunaga, Y. (eds.) Advances in Database Technologies. LNCS, vol. 1552, Springer, Heidelberg (1999)
Sell, D., Cabral, L., Motta, E., et al.: A Semantic Web based Architecture for Analytical Tools. In: CEC 2005. Proceeding of the Seventh IEEE International Conference on E-Commerce Technology, pp. 347–354 (2005)
Skoutas, D., Simitsis, A.: Designing ETL processes using semantic web technologies. In: Proceeding of the 9th ACM international workshop on Data warehousing and OLAP, pp. 67–74 (2006)
Stam, A.: A Successful Enterprise Data Warehouse? The Four Biggest Reasons for Failure. BI Review Newsletter (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Xie, G., Yang, Y., Liu, S., Qiu, Z., Pan, Y., Zhou, X. (2007). EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies. In: Aberer, K., et al. The Semantic Web. ISWC ASWC 2007 2007. Lecture Notes in Computer Science, vol 4825. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-76298-0_62
Download citation
DOI: https://doi.org/10.1007/978-3-540-76298-0_62
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-76297-3
Online ISBN: 978-3-540-76298-0
eBook Packages: Computer ScienceComputer Science (R0)