IP Library Granted Patent US 9,477,697
Granted Patent B2
US 9,477,697 · App. 12/828,001 · Granted Oct 25, 2016

Generating database schemas for multiple types of databases

Inventor: Jeffrey R. Ortel (Raleigh, NC)
Assignee: Red Hat, Inc.
G06F17/30294G06F17/30292G06F17/30569
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,477,697
App. No.
12/828,001
Granted
Oct 25, 2016
Kind
B2
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.

Claims (44)

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.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 30, 2010
From: ORTEL, JEFFREY R.
To: RED HAT, INC.
Reel/Frame 024620/0224 →
Continuity (1)
Related Publication 20120005241A1 · Jan 5, 2012