Database transition system and program storage medium

• US 6,892,197 B2
• Filed: 06/13/2001
• Issued: 05/10/2005
• Est. Priority Date: 01/20/1999
• Status: Expired due to Fees

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Furujyou, Kumiko, Nagano, Naomi, Shiraishi, Toshinori, Yuda, Kouji, Kohama, Ikuya, Kurino, Takahiro, Kubo, Kazuhisa, Maemoto, Katsutoshi, Koufuku, Yasushi, Eda, Shinichirou
• Primary Examiner(s): Rones, Charles
• Application Number:
  US09/879,133
• Publication Number:
  US 20010047367A1
• Time in Patent Office: 1,427 Days
• Field of Search: 707/4, 707/10, 707/103.R
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

An object of the present invention is to provide a database transition system capable of promptly and surely performing a transition from the relational database to the object database, and a program storage medium storing the associated processing program. The database transition system comprises RDB definition information extracting means 11 for extracting RDB definition information from an RDB repository 21 describing therein definition information of the relational database 20 which is a transition object to the object database 30, and repository creating means 12 for creating an ODB repository 31 describing therein definition information of the object database associated with the RDB definition information in accordance with the RDB definition information extracted by the RDB definition information extracting means 11 and for creating correlation information repository 15 defining mutual relationship between the RDB definition information and ODB definition information.

Claims

1. An automated method for changing over an existing relational database to a new and separate persistent object database where the relational database persistently stores a set of data as relational data and where the object database persistently stores objects as database entities corresponding to the relational data without using the relational database, said method comprising:

automatically extracting RDB definition information from an RDB repository describing therein definition information of the relational database, the definition information describing at least tables in the relational database, which is a transition object from which the object database is to be created; and

automatically creating an ODB repository describing therein definition information of the object database associated with the RDB definition information in accordance with the extracted RDB definition information and creating a correlation information repository defining mutual relationship between the RDB definition information and ODB definition information.

2. A database transition system for using an existing persistent relational database to create a persistent object database, where the relational database persistently stores a set of data as relational data and where the object database persistently stores objects as database entities corresponding to the relational data without using the relational database, said database transition system comprising:

a relational database (RDB) definition information extracting unit extracting RDB definition information from an RDB repository storing the relational database and describing therein definition information of the relational database, the definition information describing at least tables in the relational database, where the relational database is a transition object from which the object database is to be created; and

a repository creating unit creating an object database (ODB) repository describing therein definition information of the object database associated with the RDB definition information in accordance with the RDB definition information extracted by said RDB definition information extracting unit and creating a correlation information repository defining mutual relationship between the RDB definition information and ODB definition information.

3. A database transition system according to claim 2, wherein said database transition system further comprises data transition unit converting data of the relational database into the object database in accordance with the correlation information repository created by said repository creating unit.

4. A database transition system according to claims 2, wherein said database transition system further comprises an application program conversion unit converting an application program described in a relational database based language into an application program described in an object database based language in accordance with the correlation information repository created by said repository creating unit.

5. A program storage medium storing a database transition processing program for using an existing persistent relational database to create a persistent object database, where the relational database persistently stores a set of data as relational data and where the object database persistently stores objects as database entities corresponding to the relational data without using the relational database,

wherein said database transition processing program comprises:

an RDB definition information extracting unit extracting RDB definition information from an RDB repository storing the relational database and describing therein definition information of the relational database, the definition information describing at least tables in the relational database, where the relation database is a transition object from which the object database is to be created; and

a repository creating unit creating an ODB repository describing therein definition information of the object database associated with the RDB definition information in accordance with the RDB definition information extracted by said RDB definition information extracting unit and for creating correlation information repository defining mutual relationship between the RDB definition information and ODB definition information.

6. A program storage medium according to claim 5, wherein said database transition processing program further comprises a data transition unit converting data of the relational database into the object database in accordance with the correlation information repository created by said repository creating unit.

7. A program storage medium according to claims 5, wherein said database transition processing program further comprises an application program conversion unit converting an application program described in a relational database based language into an application program described in an object database based language in accordance with the correlation information repository created by said repository creating unit.