New trends in information integration

ABSTRACT

The growth of organizations invariably leads to creation of multiple isolated data sources which are totally disconnected from each other. This leads to reduced efficiency and lack of complete knowledge of the enterprise and its customers while making critical business decisions. This is the classical Information integration problem which has become the biggest pain point for enterprises today. Information Integration has received considerable attention from researchers in academia as well as industry in the recent past. Information integration refers to the category of middleware which lets applications access data as though there were in a single database. It enables the integration of data and content sources so as to provide real-time read and write access, transform data for business analysis and data interchange, and data placement for performance, currency and availability. The integration problem arises mainly due to the complex and heterogeneous environments in the enterprise. Typical example applications of information integration include: integrating the transcribed calls records with the data warehouse, integrating the patient reports with the relational data about the patients, integrating mobile phone call description records made from different regions, integrating inventory and store information from different warehouses etc.

REFERENCES

• 1: Corporate Act-Net Consortium, The active database management system manifesto: a rulebase of ADBMS features, ACM SIGMOD Record, v.25 n.3, p.40-49, Sept. 1996 [doi>10.1145/234889.234896]
• 2: Brian Babcock , Shivnath Babu , Mayur Datar , Rajeev Motwani , Jennifer Widom, Models and issues in data stream systems, Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, June 03-05, 2002, Madison, Wisconsin [doi>10.1145/543613.543615]
• 3: Shivnath Babu , Jennifer Widom, Continuous queries over data streams, ACM SIGMOD Record, v.30 n.3, September 2001 [doi>10.1145/603867.603884]
• 4: Manish Bhide , Pavan Deolasee , Amol Katkar , Ankur Panchbudhe , Krithi Ramamritham , Prashant Shenoy, Adaptive Push-Pull: Disseminating Dynamic Web Data, IEEE Transactions on Computers, v.51 n.6, p.652-668, June 2002 [doi>10.1109/TC.2002.1009150]
• 5: Bultzingsloewen, G., Koschel, A., Lockemann P. and Walter, H. 1999. ECA Functionality in a Distributed Environment, Proceeding of International Conference on Active Rules in Database Systems, Springer Verlag, 1999.
• 6: Calvanese, D., Giacomo, G. D. 2001. Integration in Data Warehousing, International Journal of Cooperative Information Systems, 10(3): 237--271, 2001.
• 7: Carzaniga, A. 1998. Architectures for an Event Notification Service Scalable to Wide-Area Network. Ph.D. thesis, Politecnico di Milano, Italy, 1998.
• 8: Venkatesan T. Chakaravarthy , Himanshu Gupta , Prasan Roy , Mukesh Mohania, Efficiently linking text documents with relevant structured information, Proceedings of the 32nd international conference on Very large data bases, September 12-15, 2006, Seoul, Korea
• 9: Moses Charikar , Kevin Chen , Martin Farach-Colton, Finding frequent items in data streams, Theoretical Computer Science, v.312 n.1, p.3-15, 26 January 2004 [doi>10.1016/S0304-3975(03)00400-6]
• 10: Samuel DeFazio , Amjad Daoud , Lisa Ann Smith , Jagannathan Srinivasan, Integrating IR and RDBMS using cooperative indexing, Proceedings of the 18th annual international ACM SIGIR conference on Research and development in information retrieval, p.84-92, July 09-13, 1995, Seattle, Washington, United States [doi>10.1145/215206.215335]
• 11: Dixon, P. 2001. Basics of Oracle Text Retrieval. IEEE Data Engg Bull. 24, 4 (2001).
• 12: Duschka O. M., and Genesereth, M. 1997. Infomaster-An Information Integration Tool. Workshop on Intelligent Information Integration, 1997.
• 13: Norbert Fuhr, A probabilistic relational model for the integration of IR and databases, Proceedings of the 16th annual international ACM SIGIR conference on Research and development in information retrieval, p.309-317, June 27-July 01, 1993, Pittsburgh, Pennsylvania, United States [doi>10.1145/160688.160754]
• 14: L. M. Haas , E. T. Lin , M. A. Roth, Data integration through database federation, IBM Systems Journal, v.41 n.4, p.578-596, October 2002
• 15: Haas, L., Miller, R. J., Niswonger, B., Roth, M., Schwarz, P. M., and Wimmers, E. L. 1997. Transforming Heterogeneous Data with Database Middleware: Beyond Integration. IEEE Data Engineering Bulletin, 1997.
• 16: Hamilton, J., and Nayak, T. 2001. Microsoft SQL Server Full-Text Search. IEEE Data Engg Bull. 24, 4 (2001).
• 17: IBM Websphere Business Integration Toolset, http://www306.ibm.com/software/integration/wbitools/
• 18: IBM Websphere MQ Software. http://www306.ibm.com/software/integration/wmq/
• 19: A. D. Jhingran , N. Mattos , H. Pirahesh, Information integration: A research agenda, IBM Systems Journal, v.41 n.4, p.555-562, October 2002
• 20: Louise Lane , Kalpdrum Passi , Sanjay Madria , Mukesh Mohania, XML schema integration to facilitate E-commerce, Web-enabled systems integration: practices and challenges, IGI Publishing, Hershey, PA, 2003
• 21: Sachin Kulkarni , Mukesh Mohania, Concurrent Maintenance of Views Using Multiple Versions, Proceedings of the 1999 International Symposium on Database Engineering & Applications, p.254, August 02-04, 1999
• 22: Maier, A., and Simmen, D. 2001. DB2 Optimization in Support of Full Text Search. IEEE Data Engg Bull. 24, 4 (2001).
• 23: Mohania, M. K., and Dong, G. 1996. Algorithms for Adapting Materialised Views in Data Warehouses. CODAS 1996.
• 24: Mukesh K. Mohania , Shin'ichi Konomi , Yahiko Kambayashi, Incremental Maintenance of Materialized Views, Proceedings of the 8th International Conference on Database and Expert Systems Applications, p.551-560, September 01-05, 1997
• 25: Norman W. Paton , Oscar Díaz, Active database systems, ACM Computing Surveys (CSUR), v.31 n.1, p.63-103, March 1999 [doi>10.1145/311531.311623]
• 26: Raghu Ramakrishnan , Kenneth A. Ross , Divesh Srivastava , S. Sudarshan, Efficient incremental evaluation of queries with aggregation, Proceedings of the 1994 International Symposium on Logic programming, p.204-218, November 1994, Symposia, Melbourne
• 27: Kenneth A. Ross , Divesh Srivastava , S. Sudarshan, Materialized view maintenance and integrity constraint checking: trading space for time, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, p.447-458, June 04-06, 1996, Montreal, Quebec, Canada
• 28: Prasan Roy , Mukesh Mohania , Bhuvan Bamba , Shree Raman, Towards automatic association of relevant unstructured content with structured query results, Proceedings of the 14th ACM international conference on Information and knowledge management, October 31-November 05, 2005, Bremen, Germany [doi>10.1145/1099554.1099676]
• 29: Eric Simon , Angelika Kotz Dittrich, Promises and Realities of Active Database Systems, Proceedings of the 21th International Conference on Very Large Data Bases, p.642-653, September 11-15, 1995
• 30: Subrahmanian, V. S., Adali, S., Brink, A., Emery, R., Lu, J., Rajput, A., Rogers, T., Ross R., and Ward, C. 1995. HERMES: Heterogeneous Reasoning and Mediator System. Technical Report, University of Maryland, 1995.
• 31: Thomas Thalhammer , Michael Schrefl , Mukesh Mohania, Active data warehouses: complementing OLAP with analysis rules, Data & Knowledge Engineering, v.39 n.3, p.241-269, December 2001 [doi>10.1016/S0169-023X(01)00042-8]
• 32: Jeffrey D. Ullman, Information integration using logical views, Theoretical Computer Science, v.239 n.2, p.189-210, May 28, 2000 [doi>10.1016/S0304-3975(99)00219-4]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.5 Heterogeneous Databases

Additional Classification:
  H. Information Systems
  H.1 MODELS AND PRINCIPLES
      H.1.1 Systems and Information Theory
  H.2 DATABASE MANAGEMENT
      H.2.2 Physical Design
      H.2.7 Database Administration

General Terms:
Design, Management, Theory