Modeling enumeration tables for relational databases

• US 20070130195A1
• Filed: 12/06/2005
• Published: 06/07/2007
• Est. Priority Date: 12/06/2005
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Li, Xiang, Dunnell, Lawrence, Yu, Hong-Lee, Yi, Gao
• Application Number:
  US11/295,942
• Publication Number:
  US 20070130195A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Provided are method, system, and article of manufacture, wherein a table is determined to be an enumeration table, in response to an indication provided to an application. Metadata corresponding to rows and columns of the enumeration table is generated. A model that logically represents the enumeration table by storing the generated metadata is maintained.

Claims

1. A method, comprising:

determining a table to be an enumeration table, in response to an indication provided to an application;

generating metadata corresponding to rows and columns of the enumeration table; and

maintaining a model that logically represents the enumeration table by storing the generated metadata.

2. The method of claim 1, wherein the rows of the enumeration table are fixed in number.

3. The method of claim 1, wherein the application is a visual database modeling tool, and wherein the determining of the table, the generating of the metadata, and the maintaining of the model, are performed by the visual database modeling tool.

4. The method of claim 3, wherein the indication is provided by a user to the visual database modeling tool by selecting an indicator that indicates a type of the table.

5. The method of claim 3, wherein the rows of the enumeration table correspond to instances and wherein the columns of the enumeration table are predetermined in number.

6. The method of claim 3, further comprising:

providing an indicator in the visual database modeling tool, wherein the indicator is selected to insert additional rows into the modeled enumeration table.

7. The method of claim 3, further comprising:

providing an indicator in the visual database modeling tool, wherein the indicator is selected to generate instances of the enumeration table from the modeled rows and columns of the enumeration table.

8. The method of claim 3, further comprising:

comparing the model of the enumeration table stored in the visual database modeling tool to an instance of the enumeration table stored in a database; and

synchronizing the model with the instance, in response to a change in the instance of the enumeration table that has been modeled by the visual database modeling tool.

9. An article of manufacture, wherein the article of manufacture stores instructions, and wherein the article of manufacture is operable to:

determine a table to be an enumeration table, in response to an indication provided to an application;

generate metadata corresponding to rows and columns of the enumeration table; and

maintain a model that logically represents the enumeration table by storing the generated metadata.

10. The article of manufacture of claim 9, wherein the rows of the enumeration table are fixed in number.

11. The article of manufacture of claim 9, wherein the application is a visual database modeling tool, and wherein the visual database modeling tool determines the table to be the enumeration table, generates the metadata, and maintains the model.

12. The article of manufacture of claim 11, wherein the indication is provided by a user to the visual database modeling tool by selecting an indicator that indicates a type of the table.

13. The article of manufacture of claim 11, wherein the rows of the enumeration table correspond to instances and wherein the columns of the enumeration table are predetermined in number.

14. The article of manufacture of claim 11, wherein the article of manufacture is further operable to:

provide an indicator in the visual database modeling tool, wherein the indicator is selected to insert additional rows into the modeled enumeration table.

15. The article of manufacture of claim 11, wherein the article of manufacture is further operable to:

provide an indicator in the visual database modeling tool, wherein the indicator is selected to generate instances of the enumeration table from the modeled rows and columns of the enumeration table.

16. The article of manufacture of claim 11, wherein the article of manufacture is further operable to:

compare the model of the enumeration table stored in the visual database modeling tool to an instance of the enumeration table stored in a database; and

synchronize the model with the instance, in response to a change in the instance of the enumeration table that has been modeled by the visual database modeling tool.

17. A system, comprising:

memory; and

logic coupled to the memory, wherein the logic is capable of causing operations to be performed, the operations comprising;

(i) determining a table to be an enumeration table, in response to an indication provided to an application;

(ii) generating metadata corresponding to rows and columns of the enumeration table; and

(iii) maintaining a model that logically represents the enumeration table by storing the generated metadata.

18. The system of claim 17, wherein the rows of the enumeration table are fixed in number.

19. The system of claim 17, wherein the application is a visual database modeling tool, and wherein the determining of the table, the generating of the metadata, and the maintaining of the model, are performed by the visual database modeling tool.

20. The system of claim 19, wherein the indication is provided by a user to the visual database modeling tool by selecting an indicator that indicates a type of the table.

21. The system of claim 19, wherein the rows of the enumeration table correspond to instances and wherein the columns of the enumeration table are predetermined in number.

22. The system of claim 19, the operations further comprising:

providing an indicator in the visual database modeling tool, wherein the indicator is selected to insert additional rows into the modeled enumeration table.

23. The system of claim 19, the operations further comprising:

providing an indicator in the visual database modeling tool, wherein the indicator is selected to generate instances of the enumeration table from the modeled rows and columns of the enumeration table.

24. The system of claim 19, the operations further comprising:

comparing the model of the enumeration table stored in the visual database modeling tool to an instance of the enumeration table stored in a database; and

synchronizing the model with the instance, in response to a change in the instance of the enumeration table that has been modeled by the visual database modeling tool.