Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-10-13
2004-03-09
Corrielus, Jean M. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06704747
ABSTRACT:
FIELD OF INVENTION
The present invention is related to database structure and conversion. More specifically, the present invention is related to a method and system which utilizes a universal frame model database schema and a method and system for translating the structure, contents, and functionality of legacy databases into the frame model to provide interoperability between various databases and, in particular, relational databases and object-oriented databases.
BACKGROUND OF THE INVENTION
Over the last two decades, various database systems have been developed utilizing three predominant data models: hierarchical, network and relational. As the performance of Relational Database (“RDB”) systems improved, companies have abandoned older technology in favor of applications based on RDB. This shift results in the need to convert a companies' older “legacy” hierarchical or network databases to a form usable by a RDB. The basic process utilized for this database reengineering consists of three major steps: schema translation, data conversion, and program translation.
Schema translation from one data model to another involves the transformation of the database structure and preservation of the data semantics. There are various levels of schema translation. A direct schema translation is a translation from one schema to another. An indirect schema translation is a two-step process where the source schema is translated to a conceptual schema, which is then translated into a target schema. The conceptual schema is designed with richer semantics than the source schema so that the semantics of the source schema can be recovered in the indirect translation without loss of information. However, user supervision is required to recapture the original database design because many semantics are lost from the source schema during the mapping into the conceptual schema. To assist users in the recovery of the missing semantics, data querying is used to recapture the original conceptual schema design.
Data conversion involves converting the actual data stored in the legacy database into a new database according to the translated target schema. The primary goal for a data conversion system is complete process automation. However, problems arise when the semantics of the source database are not fully recovered. User supervision is then required and the data conversion must be deferred until after the schema translation is complete.
Finally, in program translation, the functions performed by the source database program are converted into forms recognized by the target database program. There are inherent problems in converting legacy database program functionality because the original application requirements may not match those of the new application. Methods exist to recapture the programs intention manually and many indirect solutions which provide a relational database interface to hierarchical databases (“HDB”) and network databases (“NDB”) have been proposed. However, they are expensive to maintain and require the interface to co-exist with the HDB and NDB database management systems.
As databases proliferate companies, heterogeneous database system become common and even necessary. However, conventional processes for reengineering legacy databases into new database technologies are also risky and time consuming. In addition, due to the implied constraints of the various data models, it is difficult for organizations to support and manage heterogeneous database systems.
Further, in order to meet users' requirements, various data models must be supported by a single platform. Often, companies strive to utilize proprietary database gateways to facilitate connectivity among different database management systems. However, these gateways require complex programming for passing data from one platform to another because there is no single system architecture. However, implementing a proprietary database gateway solution in a heterogeneous database system requires the use of n(n−1) different gateways to connect n different database management systems. A substantial improvement would be achieved through the use of an open database gateway such that only n database gateways would be needed to provide interoperability between n database management systems in a heterogeneous database system.
An additional problem with current efforts to integrate and utilize various legacy databases is the lack of a global view of all the data that is being managed by the organization. Such a global schema should support the coexistence and integration of the various legacy database systems of an organization into an integrated decision support system. In particular, and as discussed, the relational database has been accepted as an industry standard. More recently, however, the object-oriented database model is being recognized as the successor to the relational database structure because of its improved ability to manage inheritance, encapsulation and polymorphism. As various databases proliferate within companies and organizations, it is thus increasingly common to be faced with a heterogeneous database systems while wanting to access the various database models using the most current and powerful techniques.
The problem of interoperability between database management system is increased by the tendency of companies to rely upon prior legacy database systems in which the database and the data applications are tightly coupled. This makes the process of migration or reengineering difficult. As the object oriented database model is increasingly recognized as the successor to the relational database systems, it is important to provide a method and system to provide interoperability between relational and object oriented database system.
The importance of providing object oriented database interoperability is further magnified by the increasing use of database-driven Internet applications. In many systems, rich data resources are available in relational database models. However, database via the Internet is more often driven using object-oriented SQL or similar object-oriented access tools. It would therefore be advantageous to provide a system and method to access a relational database in a manner which makes the database appear to the user to be object-oriented database model, thus permitting the use of object-oriented functions, such as processing of object-oriented SQL queries to the relational database.
SUMMARY OF THE INVENTION
These and other objects are achieved by utilizing a new universal database architecture for heterogeneous database systems. The architecture utilizes a frame model relational database system as a kernel system to store the underlying structure of legacy databases, i.e., the static data and dynamic data behavior of hierarchical, network and relational databases. The schema stored in the frame model can be translated into a target frame model database, such as a relational database. The legacy data programs and data can then be translated and transferred into the frame model relational database to provide a frame model universal database system that embodies the structure, data, and functionality of the legacy database. In addition, the frame models from several legacy databases can be merged to produce an integrated universal frame model database.
The frame model schema includes of four classes of meta data: the static classes of header and attribute, and the active classes of method, and constraint. Static classes represent the factual data entities of a database structure while active classes represent the rule entities. An active class is event driven, obtaining data from the database when invoked by a certain event. The static class stores data in its own database. The classes are arranged in relational tables using the same general structure and are managed by a relational database system. Combining these two types of objects within an inheritance based hierarchy structure enables the frame model to represent heterogeneous knowledge in a manner which makes it very suitable f
Corrielus Jean M.
Darby & Darby
Fong Joseph Shi-Piu
LandOfFree
Method and system for providing internet-based database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for providing internet-based database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for providing internet-based database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3274361