Advanced Information Management (AIM): Advanced Database Technology for Integrated Applications

The Advanced Information Management (AIM) project is currently one of the main activities at the IBM Scientific Center in Heidelberg. The main purpose of the project is to understand the database requirements and respective solutions for advanced integrated applications such as computer-integrated manufacturing and computer-integrated office. These application areas require an advanced database technology which is able to manage a large variety of data of various types in a consistent and efficient way. The underlying database technology should support not only simple numbers and simple tables used in business administration, but also large complex structured objects, including text, image, and voice data, in a uniform way. This paper describes the background, goals, and accomplishments of the AIM project. It also provides an overview of the design goals, the implementation, and the underlying concepts of AIM-P, an experimental database management system under development in the AIM project.

[1]  Gunter Schlageter,et al.  A General Model for Version Management in Databases , 1986, VLDB.

[2]  Peter Dadam,et al.  Design of an integrated DBMS to support advanced Applications , 1985, BTW.

[3]  Michael Stonebraker,et al.  The POSTGRES Data Model , 1987, Research Foundations in Object-Oriented and Semantic Database Systems.

[4]  Uwe Deppisch,et al.  Tight Database Cooperation in a Server-Workstation Environment , 1987, ICDCS.

[5]  Peter Dadam,et al.  Designing DBMS support for the temporal dimension , 1984, SIGMOD '84.

[6]  Gunter Saake,et al.  Sorting, Grouping and Duplicate Elimination in the Advanced Information Management Prototype , 1989, VLDB.

[7]  Klaus R. Dittrich.  Object-oriented database systems (extended abstract): the notions and the issues , 1986 .

[8]  Volker Linnemann.  Non first normal form relations and recursive queries: An SQL-based approach , 1987, 1987 IEEE Third International Conference on Data Engineering.

[9]  Michael Stonebraker,et al.  Inclusion of new types in relational data base systems , 1986, 1986 IEEE Second International Conference on Data Engineering.

[10]  Hamid Pirahesh,et al.  A data management extension architecture , 1987, SIGMOD '87.

[11]  Peter Dadam,et al.  A Lock Technique for Disjoint and Non-Disjoint Complex Objects , 1990, EDBT.

[12]  P Pistor,et al.  A database language for sets, lists and tables , 1986, Inf. Syst..

[13]  Peter Dadam,et al.  A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies , 1986, SIGMOD '86.

[14]  Hans-Jörg Schek,et al.  Architecture and implementation of the Darmstadt database kernel system , 1987, SIGMOD '87.

[15]  Alfons Kemper,et al.  An analysis of geometric modeling in database systems , 1987, CSUR.

[16]  Irving L. Traiger,et al.  System R: relational approach to database management , 1976, TODS.

[17]  Michel Scholl,et al.  On Line Processing of Compacted Relations , 1982, VLDB.

[18]  Gunter Saake,et al.  Duplicate Detection and Deletion in the Extended NF² Data Model , 1989, FODO.

[19]  Gultekin Özsoyoglu,et al.  Extending relational algebra and relational calculus with set-valued attributes and aggregate functions , 1987, TODS.

[20]  Michael Stonebraker,et al.  The design of POSTGRES , 1986, SIGMOD '86.

[21]  Michael Stonebraker,et al.  QUEL as a data type , 1984, SIGMOD '84.

[22]  Alejandro P. Buchmann,et al.  Molecular Objects, Abstract Data Types, and Data Models: A Framework , 1984, VLDB.

[23]  Klaus Meyer-Wegener,et al.  PRIMA - a DBMS Prototype Supporting Engineering Applications , 1987, VLDB.

[24]  Peter Dadam,et al.  Integration of Time Versions into a Relational Database System , 1984, VLDB.

[25]  Hans-Jörg Schek,et al.  The reference string indexing method , 1978, ECI.

[26]  Peter C. Lockemann,et al.  An object-oriented system for engineering applications , 1987, SIGMOD '87.

[27]  Serge Abiteboul,et al.  Nested Relations and Complex Objects in Databases , 1989, Lecture Notes in Computer Science.

[28]  Renzo Orsini,et al.  GALILEO: a strongly-typed, interactive conceptual language , 1985, TODS.

[29]  Norbert Südkamp,et al.  An Application Program Interface for a Complex Object Database , 1988, JCDKB.

[30]  Patricia G. Selinger,et al.  Support for repetitive transactions and ad hoc queries in System R , 1981, TODS.

[31]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[32]  Roger L. Haskin,et al.  On extending the functions of a relational database system , 1982, SIGMOD '82.

[33]  Hans-Jörg Schek,et al.  Remarks on the algebra of non first normal form relations , 1982, PODS.

[34]  Hamid Pirahesh,et al.  Extensibility in the Starburst Database System , 1986, OODBS.

[35]  Peter Dadam,et al.  The recovery manager of the advanced information management prototype , 1990 .

[36]  Wil Plouffe,et al.  Complex Objects and Their Use in Design Transactions , 1983, Engineering Design Applications.

[37]  Michael Stonebraker,et al.  Extending a database system with procedures , 1987, TODS.

[38]  Hans-Jörg Schek,et al.  Data Structures for an Integrated Data Base Management and Information Retrieval System , 1982, VLDB.

[39]  John Mylopoulos,et al.  A language facility for designing database-intensive applications , 1980, TODS.

[40]  Umeshwar Dayal,et al.  Simplifying Complex Objects: The PROBE Approach to Modelling and Querying Them , 1987, BTW.

[41]  Peter Pistor,et al.  Designing A Generalized NF2 Model with an SQL-Type Language Interface , 1986, VLDB.

[42]  Peter Dadam,et al.  Cooperative Object Buffer Management in the Advanced Information Management Prototype , 1987, VLDB.

[43]  Stephen Todd,et al.  The Peterlee Relational Test Vehicle - A System Overview , 1976, IBM Syst. J..

[44]  Setrag Khoshafian.  Object orientation , 1990 .

[45]  Georg Walch,et al.  A graph structured text field index based on word fragments , 1981, Inf. Process. Manag..