Philip A. Bernstein
Laura M. Haas
Abstract
A guide to the tools and core technologies for merging information from disparate sources.
- Alonso, G., Casati, F., Kuno, H.A., and Machiraju, V. Web Services---Concepts, Architectures and Applications. Springer, 2004. Google Scholar
Digital Library
- Altinel, M., Brown, P., Cline, S., Kartha, R., Louie, E., Markl, V., Mau, L., Ng, Y-H, Simmen, D.E., and Singh, A. DAMIA---A data mashup fabric for intranet applications. VLDB Conference (2007), 1370--1373. Google ScholarDigital Library
- Babcock, C. XML plays big integration role InformationWeek(May 24, 2004); www.informationweek.com/story/showArticle.jhtml?articleID=20900153.Google Scholar
- Bernstein, P.A. and Melnik, S. Model management 2.0: Manipulating richer mappings. In Proceedings of the ACMSIGM0D Conference, 2007,1--12. Google ScholarDigital Library
- Brin, S. and Page, L. The anatomy of a large-scale hypertextual Web search engine. Computer Networks 30, 1--7 (1998), 107--117 Google ScholarDigital Library
- Carey, M.J. Data delivery in a service-oriented world. The BEA AquaLogic data services platform. In Proceedings of the ACM SIGMOD Conference (2006). 695--705. Google ScholarDigital Library
- Chaudhuri, S. and Dayal, U. An overview of data warehousing and OLAP technology. ACM SIGMOD Record 26,1(1997), 65--74. Google ScholarDigital Library
- Chiticariu, L. and Tan, W.C. Debugging schema mappings with routes. VLDB Conference (2006), 79--90 Google ScholarDigital Library
- Chomicki, J. Consistent query answering: Five easy pieces. In Proceedings of the International Conference on Database Theory (2007), 1--17 Google ScholarDigital Library
- Dasu, T., and Johnson, T. Exploratory Data Mining and Data Cleaning, John Wiley, 2003. Google ScholarDigital Library
- Firestone, J.M. Enterprise Information Portals and Knowledge Management, Butterworth-Heinemann (Elsevier Science, KMCI Press), 2003. Google ScholarDigital Library
- Foundational Model of Anatomy, Structural Informatics Group, University of Washington; http://sig.biostr.washington.edu/projects/fm/Google Scholar
- Gene Ontology; http://www.geneontology.org/Google Scholar
- Haas, L.M. Beauty and the beast: The theory and practice of information integration. International Conference on Database Theory (2007), 28--43. Google ScholarDigital Library
- Haas, L.M., Hernández, M.A., Ho, H., Popa, L., and Roth, M. Clio grows up: From research prototype to industrial tool. In Proceedings of the ACM SIGMOD Conference (2005), 805--810. Google ScholarDigital Library
- Halevy, A.Y., Ashish, N., Bitton, D., Carey, M.J., Draper D., Pollock, J., Rosenthal, A., and Sikka, V. Enterprise information integration: Successes, challenges, and controversies. In Proceedings of the ACM SIGMOD Conference (2005), 778--787 Google ScholarDigital Library
- Halevy, A.Y., Franklin, M.J., and Maier, D. Principles of dataspace systems. ACM Symposium on Principles of Database Systems (2006), 1--9. Google ScholarDigital Library
- Health Level Seven; http://www.hl7.org/Google Scholar
- Hepp, M., De Leenheer, P., de Moor, A., and Sure Y. (Eds.). Ontology management: Semantic web, semantic web services, and business applications. Vol. 7 of series Semantic Web And Beyond. Springer, 2008. Google ScholarDigital Library
- IDC. Worldwide Data Integration and Access Software 2008-2012 Forecast, Doc No. 211636 (Apr. 2008).Google Scholar
- Kimball, R. and Caserta, J. The Data Warehouse ETL Toolkit, Wiley and Sons, 2004.Google Scholar
- Ludascher, B., Papakonstantinou, Y., and Velikhov, P. Navigation-driven evaluation of virtual mediated views. Extending Database Technology (2000), 150--165. Google ScholarDigital Library
- Melnik, S., Adya, A., and Bernstein, P.A. Compiling mappings to bridge applications and databases. In Proceedings of the ACM SIGMOD Conference (2007), 461--472. Google ScholarDigital Library
- Meng, W., Yu, C, and Liu, K. Building efficient and effective metasearch engines. ACM Computing Surveys 34,1(2002), 48--89. Google ScholarDigital Library
- McCallum, A. Information extraction: Distilling structured data from unstructured text. ACM Queue 3, 9 (Nov. 2005). Google ScholarDigital Library
- Miller, R.J., Haas, L.M., and Hernández, M.A. Schema mapping as query discovery. VLDB Conference (2000), 77--88. Google ScholarDigital Library
- Morgenthal, J.P. Enterprise Information Integration: A Pragmatic Approach, Lulu.com, 2005.Google Scholar
- OASIS standards; www.oasis-open.org/specs/.Google Scholar
- OMG Specifications; www.omg.org/technology/documents/modeling_spec_catalog.htm.Google Scholar
- Popa, L., Velegrakis, Y., Miller, R.J., Hernández, M.A., and Fagin, R. Translating Web data. VLDB Conference (2002),598--609. Google ScholarDigital Library
- Rahm, E. and Bernstein, P.A. A survey of approaches to automatic schema matching. VLDB Journal 10, 4 (2001), 334--350. Google ScholarDigital Library
- Roddick, J.F. and de Vries, D. Reduce, reuse, recycle Practical approaches to schema integration, evolution and versioning. Advances in Conceptual Modeling---Theory and Practice, Lecture Notes in Computer Science, 4231. Springer, 2006. Google ScholarDigital Library
- Smith, M. Toward enterprise information integration Softwaremag.com (Mar. 2007); www.softwaremag.com/L.cfm?Doc=1022-3/2007.Google Scholar
- Tan, W-C. Provenance in databases: past, current, and future. IEEE Data Eng, Bulletin 30, 4 (2007), 3--12.Google Scholar
- Wiederhold, G. Mediators in the architecture of future information systems. IEEE Computer 25, 3 (1992) 38--49. Google ScholarDigital Library
- Workshop on Information Integration, October 2006; http://db.cis.upenn.edu/iiworkshop/postworkshop/ndex.htm.Google Scholar
Index Terms
- Information integration in the enterprise
Recommendations
Enterprise Application Integration: A Manager's Perspective
To remain competitive, organizations must operate efficiently and be flexible enough to rapidly respond to—and even preempt—changing market conditions. IT managers must therefore continually seek ways to support more effective and accurate business ...
Reviews
Alan M Arnfeld
Aligning the information model across an enterprise is complex. Held across many applications across an enterprise, providing the information in a business-usable form is tough?and getting tougher due to the ease with which new systems can be created. Bernstein (of Microsoft) and Haas (of IBM) provide a sophisticated, yet very accessible, overview of the different techniques available to bring together information across the enterprise. The paper provides a practical, worked example that illustrates the challenges of information integration for a car dealership. This example really brought the paper to life and made the content accessible to a much wider audience. Many tools are considered in the paper, such as data warehouse loading, virtual data integration, message mapping, object-to-relational mappers, and document management. They also refer to core technologies such as Extensible Markup Language (XML), schema standards, data cleansing, schema mapping, information extraction, and dynamic Web technologies including mashups. Finally, the authors consider some future trends. The proliferation of new information repositories across organizations, emerging both monthly and daily, creates new challenges. The importance of understanding and achieving information integration for business use across the enterprise has never been more important. Online Computing Reviews Service
Access critical reviews of Computing literature here
Become a reviewer for Computing Reviews.
Comments