MONIL Language, an Alternative for Data Integration

Data integration is a process of retrieving, merging and storing of data originated in heterogeneous sources of data. The main problem facing the data integration is the structural and semantic heterogeneity of participating data. A concern of research communities in computer sciences is the development of semi-automatic tools to assist the user in an effective way in the data integration processes. This paper introduces a programming language called MONIL, as an alternative to integrate data by means of design, storage and program execution. MONIL is based on the use of meta-data, conversion functions, a meta-model of integration and a scheme of integration suggestions. MONIL offers to the user a dedicated work environment with built-in semi-automatic tools supporting the integration process in three stages.

[1]  Jennifer Widom,et al.  The TSIMMIS Project: Integration of Heterogeneous Information Sources , 1994, IPSJ.

[2]  Gershon Elber,et al.  WebSuite: A Tool Suite for Harnessing Web Data , 1998, WebDB.

[3]  Karl Aberer,et al.  Integrating relational and object-oriented database systems using a metaclass concept , 1994, J. Syst. Integr..

[4]  M. W. Shields.  An Introduction to Automata Theory , 1988 .

[5]  Stuart E. Madnick,et al.  From VLDB to VMLDB (Very MANY Large Data Bases): Dealing with Large-Scale Semantic Heterogenity , 1995, VLDB.

[6]  Jeffrey D. Ullman,et al.  Information integration using logical views , 1997, Theor. Comput. Sci..

[7]  Diego Calvanese,et al.  View-based query processing and constraint satisfaction , 2000, Proceedings Fifteenth Annual IEEE Symposium on Logic in Computer Science (Cat. No.99CB36332).

[8]  Mary Roth,et al.  Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources , 1997, VLDB.

[9]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[10]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[11]  Nick Roussopoulos,et al.  Interoperability of multiple autonomous databases , 1990, CSUR.

[12]  SÓCRATES TORRES,et al.  A String Representation Methodology to Generate Syntactically Valid Genetic Programs , .

[13]  William W. Cohen.  Integration of heterogeneous databases without common domains using queries based on textual similarity , 1998, SIGMOD '98.

[14]  Craig A. Knoblock,et al.  Retrieving and Integrating Data from Multiple Information Sources , 1993, Int. J. Cooperative Inf. Syst..

[15]  Alon Y. Halevy,et al.  An adaptive query execution system for data integration , 1999, SIGMOD '99.

[16]  Hector Garcia-Molina,et al.  Template-based wrappers in the TSIMMIS system , 1997, SIGMOD '97.

[17]  Alon Y. Halevy,et al.  Recursive Query Plans for Data Integration , 2000, J. Log. Program..

[18]  Jeffrey D. Ullman,et al.  Introduction to Automata Theory, Languages and Computation , 1979 .

[19]  Timos K. Sellis,et al.  Designing the Global Data Warehouse with SPJ Views , 1999, CAiSE.

[20]  Vipul Kashyap,et al.  Schema Correspondences between Objects with Semantic Proximity , 1993 .

[21]  Marc Friedman,et al.  Efficient execution of information gatheriug plans , 1997, IJCAI 1997.

[22]  Gang Zhou,et al.  Towards the Study of Performance Trade-offs Between Materialized and Virtual Integrated Views , 1996, VIEWS.

[23]  Nicholas Kushmerick,et al.  Wrapper Induction for Information Extraction , 1997, IJCAI.

[24]  Ling Liu,et al.  Accessing heterogeneous data through homogenization and integration mediators , 1997, Proceedings of CoopIS 97: 2nd IFCIS Conference on Cooperative Information Systems.

[25]  D UllmanJeffrey,et al.  Introduction to automata theory, languages, and computation, 2nd edition , 2001 .

[26]  Maurizio Vincini,et al.  The MOMIS Approach to Information Integration , 2001, International Conference on Enterprise Information Systems.

[27]  Stuart E. Madnick,et al.  Working Paper Alfred P. Sloan School of Management Database Systems in a Dynamic Environment Database Systems in a Dynamic Environment Received Context Interchange: Overcoming the Challenges of Large-scale Interoperable Database Systems in a Dynamic Environment* , 2022 .

[28]  Theo Härder,et al.  The intrinsic problems of structural heterogeneity and an approach to their solution , 1999, The VLDB Journal.

[29]  Richard Hull,et al.  Managing semantic heterogeneity in databases: a theoretical prospective , 1997, PODS.

[30]  Balwant Rai.  A Principled Approach to Data Integration And Reconciliation in Data Warehousing , 2005 .

[31]  Andrea Calì,et al.  Accessing Data Integration Systems through Conceptual Schemas , 2001, ER.

[32]  Gio Wiederhold,et al.  Mediators in the architecture of future information systems , 1992, Computer.

[33]  Gang Zhou,et al.  A framework for supporting data integration using the materialized and virtual approaches , 1996, SIGMOD '96.

[34]  Franco Zambonelli,et al.  Supporting Information Integration with Autonomous Agents , 2001, CIA.

[35]  Alexandros Labrinidis,et al.  Reduction of Materialized View Staleness Using Online Updates , 1998 .

[36]  José Torres-Jiménez,et al.  Data Integration Using the MONIL Language , 2002, ICEIS.

[37]  Alon Y. Halevy,et al.  MiniCon: A scalable algorithm for answering queries using views , 2000, The VLDB Journal.

[38]  Fèlix Saltor,et al.  On Intelligent Access to Heterogeneous Information , 1997, KRDB.

[39]  Silvana Castano,et al.  Semantic integration of heterogeneous information sources , 2001, Data Knowl. Eng..

[40]  Won Kim,et al.  On resolving schematic heterogeneity in multidatabase systems , 1995, Distributed and Parallel Databases.

[41]  Craig A. Knoblock,et al.  Modeling Web Sources for Information Integration , 1998, AAAI/IAAI.

[42]  Laura M. Haas,et al.  Optimizing Queries Across Diverse Data Sources , 1997, VLDB.

[43]  Matthias Jarke,et al.  Concept based design of data warehouses: the DWQ demonstrators , 2000, SIGMOD '00.

[44]  W. H. Inmon,et al.  Building the data warehouse (2nd ed.) , 1996 .

[45]  M. Melchiori,et al.  Towards a Comprehensive Methodological Framework for Semantic Integration of Heterogeneous Data Sources ∗ , 2001 .

[46]  Joann J. Ordille,et al.  Query-Answering Algorithms for Information Agents , 1996, AAAI/IAAI, Vol. 1.

[47]  Roger King,et al.  Generating data integration mediators that use materialization , 1996, Journal of Intelligent Information Systems.

[48]  K. Selçuk Candan,et al.  Query caching and optimization in distributed mediator systems , 1996, SIGMOD '96.

[49]  Jennifer Widom,et al.  The TSIMMIS Approach to Mediation: Data Models and Languages , 1997, Journal of Intelligent Information Systems.

[50]  Ali R. Hurson,et al.  Automated resolution of semantic heterogeneity in multidatabases , 1994, TODS.

[51]  E. Morales,et al.  MONIL , the Metadata and Object Integration Language , 2022 .

[52]  Thomas Kyte.  Expert one-on-one Oracle , 2001 .

[53]  Guy Harrison.  Oracle SQL High-Performance Tuning , 1997 .

[54]  Domenico Beneventano,et al.  Extensional Knowledge for semantic query optimization in a mediator based system , 2001 .