Generating database schemas for multiple types of databases

Patent metadata

Field	Value
Publication number	US-9477697-B2
Application number	US-82800110-A
Country	US
Kind code	B2
Filing date	Jun 30, 2010
Priority date	Jun 30, 2010
Publication date	Oct 25, 2016
Grant date	Oct 25, 2016

Abstract

A computer system receives data defining a database schema in a common representation, creates a data model based on the input file, identifies one or more database types of a plurality of database types for which a schema is to be generated, and causes a database specific schema file to be generated for each of the one or more database types based on the data model.

First claim

What is claimed is:

1. A method comprising:
receiving, by a processor, an input file defining a database schema written in a data dictionary language common to a plurality of different database types;
creating, by the processor, a data model by parsing the input file;
identifying a first database type of the plurality of different database types for which a first database specific schema file is to be generated;
identifying a first plugin of a plurality of plugins, wherein the first plugin is associated with the first database type; and
generating, by the first plugin, the first database specific schema file for the first database type and the data model.

2. The method of claim 1 , wherein the input file comprises a text file created by a user.

3. The method of claim 1 , wherein the plurality of database types comprises Oracle® database types and PostGres database types.

4. The method of claim 1 , wherein each of the plurality of different database types is associated with a single plugin.

5. The method of claim 4 , wherein causing the first database specific schema file to be generated comprises:
rendering, by the first plugin, the data model as a first database specific schema text.

6. The method of claim 4 , further comprising:
adding a second plugin associated with a second database type different from those in the plurality of different database types; and
allowing a second database specific schema to be generated for the second database type by the second plugin.

7. The method of claim 1 , wherein the plurality of different database types comprises a plurality of different database products.

8. The method of claim 1 , wherein the plurality of different database types comprises different versions of a same database product.

9. A non-transitory computer readable storage medium comprising instructions that, when executed by a processor, cause the processor to:
receive, by the processor, an input file defining a database schema written in a data dictionary language common to a plurality of different database types;
create, by the processor, a data model by parsing the input file;
identify a first database type of the plurality of different database types for which a first database specific schema file is to be generated;
identify a first plugin of a plurality of plugins, wherein the first plugin is associated with the first database type; and
generate, by the first plugin, the first database specific schema file for the first database type and the data model.

10. The non-transitory computer readable storage medium of claim 9 , wherein the input file comprises a text file created by a user.

11. The non-transitory computer readable storage medium of claim 9 , wherein each of the plurality of different database types is associated with a single plugin.

12. The non-transitory computer readable storage medium of claim 11 , wherein to generate the first database specific schema file comprises:
rendering, by the first plugin, the data model as a first database specific schema text.

13. The non-transitory computer readable storage medium of claim 11 , the processor to execute instructions to:
add a second plugin associated with a second database type different from those in the plurality of different database types; and
allow a second database specific schema to be generated for the second database type by the second plugin.

14. A system comprising:
a memory to store instructions; and
a processor coupled to the memory, the processor executes the instructions to:
receive an input file defining a database schema written in a data dictionary language common to a plurality of different database types;
create a data model in view of the input file;
identify a first database type of the plurality of different database types for which a first database specific schema file is to be generated;
identify a first plugin of a plurality of plugins, wherein the first plugin is associated with the first database type; and
generate, by the first plugin, the first database specific schema file for the first database type and the data model.

15. The system of claim 14 , wherein the input file comprises a text file created by a user.

16. The system of claim 14 , wherein each of the plurality of different database types is associated with a single plugin.

17. The system of claim 16 , wherein the processor causes the first database specific schema file to be generated by:
rendering, by the first plugin, the data model as a first database specific schema text.

18. The system of claim 16 , the processor to execute instructions to:
add a second plugin associated with a second database type different from those in the plurality of different database types; and
allow a second database specific schema to be generated for the second database type by the second plugin.

Assignees

• Ortel Jeffrey R
• Red Hat Inc

Inventors

• Ortel Jeffrey R

Classifications

• G06F16/212 Primary

  with details for data modelling support · CPC title

• G06F16/211

  Schema design and management · CPC title

• G06F16/258

  Data format conversion from or to a database · CPC title

• G06F17/30294 Primary

  Physics · mapped topic

• G06F17/30569

  Physics · mapped topic