Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-02-19
2001-02-20
Alam, Hosain T. (Department: 2771)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06192366
ABSTRACT:
BACKGROUND OF THE INVENTION
This invention relates to a database wherein each record is made up of a record part of a relational database and a record part of a nonrelational database, and to a computer-readable recording medium recorded with a program for managing this database structure.
Conventionally, relational database systems and nonrelational database systems have been constructed as separate systems. Here, a relational database is a database made up only of data satisfying a normal form, and a nonrelational database is a database which is not limited to a normal form and is made up of either parent record parts only or parent record parts having one or more child record parts linked thereto. In systems having both a relational database system and a nonrelational database system of the configurations described above, data is converted in both directions between the relational database and the nonrelational database when data of the two systems is exchanged.
For example systems of financial institutions such as banks, life insurers, insurers and stockbrokerage companies have an off-line system using a relational database system and an on-line system using a nonrelational database system. In the on-line system, for example payment and receipt transactions inputted from terminals at branches are transmitted to a central facility and on the basis of these transactions data manipulation such as reference to and updating of the nonrelational database is carried out. The off-line system is operated for example from when the on-line business finishes, and on-line data is converted into off-line data to incorporate log information accumulated in the on-line system into the off-line relational database. Then, by performing relational operation and data manipulation processing on the off-line relational database, for example daily and monthly various statistical tables and documents are outputted and distributed to branches and return of information is thereby carried out. Also, by connecting this off-line relational database to a network, highly flexible non-fixed-form querying from branches and head office departments is made possible.
In a conventional normalized relational database, records are made up of relational lines only. That is, actual relational database systems have been developed with only the concept of ‘relational line’=‘record’. Therefore, with respect to data for which this relational database structure is not ideal, for example in terms of processing efficiency or in terms of business processing, in practice inevitably a separate database system like the on-line system of a financial institution described above has had to be built and operated.
However, with the conventional configuration wherein a relational database and a nonrelational database are constructed as separate systems, because the database is made up of two systems there has been the problem that the work of development, operation and maintenance and the like is complex. Also, because costs of development, operation and maintenance and so on are duplicated, there has been the problem that the system is expensive.
In the financial institution system described above, great expenditure is required for the development of the on-line system and for the development of the off-line system. Also, the operating hours of the on-line system and the off-line system are different and there is the problem that because the off-line business is started after the on-line business ends the overall operating time of the financial institution system is long.
Also, sometimes, when data manipulation such as updating and deleting is to be carried out on a predetermined data set of a nonrelational database constructed as a separate system, a relational operation is carried out on the relational database system to extract a predetermined record set from the relational database and then a data set is extracted from the nonrelational database on the basis of for example matching of keys with the extracted relational database records and the data manipulation of updating and deleting or the like is then carried out on the data set thus extracted from the nonrelational database. In this case, both the relational database and the nonrelational database must be read. Because the relational database and the nonrelational database constructed as separate systems are held in physically or logically separate drives, in a database system using a virtual space system, when both databases are read, paging occurs. Consequently, when both databases are read, paging occurs frequently and the throughput of the system falls.
From the point of view of the reliability of the database system also, non-matching of data between the databases readily occurs, and because there is generally a time lag between the two systems such non-matching of data is liable to go unnoticed, and this causes serious problems in business execution.
A data system disclosed in Unexamined Published Japanese Application No. S.62-209615 uses a non-normal form relational system including repeat items, but this system still presupposes a relational database and does not have the object of integrating a relational database and a nonrelational database.
SUMMARY OF THE INVENTION
It is therefore an object of the present invention to provide an integrated database system and a computer-readable recording medium recorded with a program for managing the database structure thereof which reduce work load and work cost by integrating a relational database and a nonrelational database into a single system.
In an integrated database system and a computer-readable recording medium recorded with a program for managing the database structure thereof provided by the invention to achieve this object and other objects, each record is made up of a record part of a relational database and a record part of a nonrelational database, and relational operation and data manipulation are carried out on these records and as a result it is possible to provide a relational database and a nonrelational database as a single database. Therefore, the database system can be made a single system.
Also, the record part of the nonrelational database is made up of either a parent record part only or a parent record part and one or more child record parts linked to the parent record part. Therefore, in a database which for business processing reasons requires a parent record part and a child record part, it is not necessary to provide the two as separate tables.
In another integrated database system and computerreadable recording medium recorded with a program for managing the database structure thereof provided by the invention it is possible to process a relational operation on the record part of the relational database to extract a predetermined set of records and a data manipulation carried out on the extracted record set with a single command, and thus a relational operation and a data manipulation can be performed with a single reading.
With respect to data manipulation, raw data resulting from an execution in the nonrelational database part can be used in real time along with a relational database manipulation, and the reverse is also possible.
REFERENCES:
patent: 4769772 (1988-09-01), Dwyer
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5381470 (1995-01-01), Cambray et al.
patent: 5455926 (1995-10-01), Keele et al.
patent: 5581756 (1996-12-01), Nakabayashi
patent: 5603025 (1997-02-01), Tabb et al.
patent: 5729730 (1998-03-01), Wlaschin et al.
patent: 5758337 (1998-05-01), Hammond
patent: 5797136 (1998-08-01), Boyer et al.
patent: 5826076 (1998-10-01), Bradley et al.
patent: 5878426 (1999-03-01), Plasek et al.
patent: 5893075 (1999-04-01), Plainfield et al.
patent: 5893087 (1999-04-01), Wlaschin et al.
patent: 0 490 465A2 (1992-06-01), None
patent: 62-209615 (1987-09-01), None
patent: 3-41532 (1991-02-01), None
Alam Hosain T.
Alam Shahid
Arent Fox Kintner & Plotkin & Kahn, PLLC
LandOfFree
Integrated database system and computer-readable recording... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Integrated database system and computer-readable recording..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Integrated database system and computer-readable recording... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2610363