Method and system for managing a database having a plurality of tables

• US 9,128,986 B2
• Filed: 09/27/2011
• Issued: 09/08/2015
• Est. Priority Date: 06/29/2011
• Status: Active Grant

• Current Assignee: Infosys Limited
• Original Assignee: Infosys Limited
• Inventors: Dhake, Dhiraj, Mohata, Abhay
• Primary Examiner(s): Obisesan, Augustine K
• Assistant Examiner(s): Brooks, David T
• Application Number:
  US13/246,747
• Publication Number:
  US 20130007047A1
• Time in Patent Office: 1,442 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

The present disclosure describes methods and systems for managing a database having a plurality of tables. The tables represent master data of a business application. In one example, a method includes receiving an input command from a user for maintaining a table of the plurality of tables. After receiving the command, an Extensible Markup Language (XML) file corresponding to the table is identified. Thereafter, a screen suitable for enabling the user to perform one or more functionalities corresponding to the input command is prepared. The screen is prepared by using a screen object corresponding to the XML file. Various examples of the functionalities can include, but are not limited to, View, Add, Update, and Delete. Subsequently, a query corresponding to the input command is executed for maintaining the table based on the functionalities.

Claims

1. A method for managing a database having one or more tables, the method comprising:

generating for a database table comprising business data, an Extensible Markup Language (XML) file corresponding to the database table, wherein the XML file;

identifies fields within the database table; and

includes queries that are performable on the database table in response to user input;

parsing the generated XML file and generating one or more data objects based on information parsed from the generated XML file, wherein each of the generated one or more data objects are associated with the generated XML file, at least one of the generated one or more data objects are implementable for preparing a user interface screen for the database table corresponding to the XML file, and at least one of the generated one or more data objects includes;

the included queries that are performable on the database table in response to user input; and

instructions for executing data operations on the database table corresponding to the XML file;

receiving an input command from a user for executing a data operation on the database table;

identifying from among a plurality of XML files, the generated XML file corresponding to the database table as identified in the input command;

preparing a user interface screen suitable for enabling the user to perform the data operation identified in the input command, wherein the user interface screen is prepared by utilizing data within one or more selected data objects associated with the XML file and selection of the one or more selected objects is based on the data operation identified in the input command; and

responsive to the data operation identified in the input command, executing a query corresponding to the input command for maintaining the database table, wherein the executed query is generated based on query information within the XML file corresponding to the database table identified in the input command.

2. The method of claim 1, wherein the input command corresponds to at least one or more selected from the group consisting of the following operations on data present in the table:

viewing, adding, deleting, and updating.

3. The method of claim 1, wherein the XML file is developed in a pre-defined XML structure, the pre-defined XML structure comprising one or more header messages, one or more messages, one or more queries, one or more variables, one or more field columns, one or more footer messages, and one or more input commands.

4. The method of claim 3, further comprising creating one or more classes corresponding to data present in the XML file, wherein the one or more classes are created in a pre-defined programming language.

5. The method of claim 4, wherein the generated one or more data objects correspond to each of the one or more classes.

6. The method of claim 1, wherein the XML file is identified based on a table identifier corresponding to the table.

7. The method of claim 1, wherein the data operation identified in the input command comprises at least one or more selected from the group consisting of the following operations on data in the table:

viewing, adding, updating, and deleting.

8. The method of claim 1, further comprising caching a plurality of objects corresponding to data present in the XML file, wherein the data corresponds to one or more commands associated with the table.

9. The method of claim 8, further comprising retrieving a table object from the plurality of objects, the table object comprising a screen object and one or more parameters corresponding to the table.

10. The method of claim 9, wherein the table object comprises other screen objects corresponding to one or more input commands for maintaining the table.

11. The method of claim 1, further comprising generating a query prior to the executing the query, the query being generated by utilizing the XML file.

12. The method of claim 1, further comprising updating the XML file based on the data operation identified in the input command.

36. The method of claim 1, wherein the database comprises a plurality of tables, each having an XML file corresponding thereto.

37. The method of claim 36, wherein each XML file includes rules for at least one of data persistence or user interface design for the corresponding table.

13. A system comprising:

one or more processors;

a database having one or more tables;

an Extensible Markup Language (XML) file corresponding to a database table comprising business data within the database, wherein the XML file;

identifies fields within the database table; and

includes queries that are performable on the database table in response to user input;

one or more data objects generated by parsing the XML file and basing the one or more data objects on information parsed from the XML file, wherein each of the generated one or more data objects are associated with the XML file, at least one of the generated one or more data objects are implementable for preparing a user interface screen for the database datable corresponding to the XML file, and at least one of the generated one or more data objects includes;

the included queries that are performable on the database table in response to user input; and

instructions for executing data operations on the database table corresponding to the XML file;

one or more non-transitory computer-readable storage media storing computer readable instructions that when executed by the processors cause the processors to manage the database using;

a receiving module configured to receive an input command from a user for executing a data operation on the database table; and

a function module configured for processing the input command for maintaining the database table, the function module comprising;

an identification module configured for identifying from among a plurality of XML files, the XML file corresponding to the database table as identified in the input command,

a screen preparation module configured to prepare a user interface screen suitable for enabling the user to perform the data operation identified in the input command, wherein the user interface screen is prepared by utilizing data within one or more selected data objects associated with the XML file, and selection of the one or more selected objects is based on the data operation identified in the input command; and

a query processing module configured to respond to the data operation identified in the input command by executing a query for maintaining the database table wherein the executed query is generated based on query information within the XML file corresponding to the database table identified within the input command.

14. The system of claim 13, wherein the input command corresponds to at least one or more selected from the group consisting of the following operations on data present in the table:

viewing, adding, deleting, and updating.

15. The system of claim 13, wherein the XML file is developed in a pre-defined XML structure, the pre-defined XML structure comprising one or more header messages, one or more messages, one or more queries, one or more variables, one or more field columns, one or more footer messages, and one or more input commands.

16. The system of claim 13, wherein one or more classes are created corresponding to data present in the XML file, wherein the one or more classes are created in a pre-defined programming language.

17. The system of claim 16, wherein the generated one or more objects correspond to each of the one or more classes.

18. The system of claim 13, wherein the identification module identifies the XML file based on a table Identifier corresponding to the table.

19. The system of claim 13, further comprising a caching module configured for caching a plurality of objects corresponding to data present in the XML file, wherein the data corresponds to one or more commands associated with the table.

20. The system of claim 13, further comprising an object retrieving module configured for retrieving a table object from the plurality of objects, the table object comprising a screen object and one or more parameters corresponding to the table.

21. The system of claim 20, wherein the table object comprises other screen objects corresponding to one or more input commands for maintaining the table.

22. The system of claim 13, further comprising a query generation module, the query generation module configured for generating the query prior to executing the query, the query being generated by utilizing the XML file.

23. The system of claim 13, wherein the XML file is updated based on the data operation identified in the input command.

24. The system of claim 13, further comprising a display module configured for displaying the screen to the user for enabling the user to perform the data operation identified in the input command.

25. The system of claim 24, wherein the display module enables the user to view data, add data, update data and delete data corresponding to the table.

38. The system of claim 13, wherein the database comprises a plurality of tables, each having an XML file corresponding thereto.

39. The system of claim 38, wherein each XML file includes rules for at least one of data persistence or user interface design for the corresponding table.

26. A computer program product for use with a computer, the computer program product comprising a non-transitory computer readable storage medium having computer executable program code embodied therein for managing a database having one or more tables, the computer executable program code comprising:

program instructions for generating for a database table comprising business data, an Extensible Markup Language (XML) file corresponding to the table, wherein the XML file;

identifies fields within the database table; and

includes queries that are performable on the database table in response to user input;

program instructions for parsing the generated XML file and generating one or more data objects based on information parsed from the generated XML file, wherein each of the generated one or more data objects are associated with the generated XML file, at least one of the generated one or more data objects are implementable for preparing a user interface screen for the database table corresponding to the XML file, and at least one of the generated one or more data objects includes;

the included queries that are performable on the database table in response to user input; and

instructions for executing data operations on the database table corresponding to the XML file;

program instructions for receiving an input command from a user for executing a data operation on the database table;

program instructions for identifying from among a plurality of XML files, the generated XML file corresponding to the database table as identified in the input command;

program instructions for preparing a user interface screen suitable for enabling the user to perform the data operation identified in the input command, wherein the user interface screen is prepared by utilizing data within one or more selected data objects associated with the XML file and selection of the one or more selected objects is based on the data operation identified in the input command; and

program instructions for responding to the data operation identified in the input command by executing a query corresponding to the input command for maintaining the database table wherein the executed query is generated based on query information within the XML file corresponding to the database table identified in the input command.

27. The computer program product of claim 26, wherein the input command corresponds to at least one or more selected from the group consisting of the following operations performed on data present in the table:

viewing, adding, deleting, and updating.

28. The computer program product of claim 26, wherein the XML file is identified based on a table identifier corresponding to the table.

29. The computer program product of claim 26, wherein the data operation identified in the input command comprises at least one or more selected from the group consisting of the following operations on data in the table:

viewing, adding, updating, and deleting.

30. The computer program product of claim 26, wherein the computer program code further comprises program instructions for caching a plurality of objects corresponding to data present in the XML file, wherein the data corresponds to one or more commands associated with the table.

31. The computer program product of claim 30, wherein the computer program code further comprises program instructions for retrieving a table object from the plurality of objects, the table object comprising a screen object and one or more parameters corresponding to the table.

32. The computer program product of claim 31, wherein the table object comprises other screen objects corresponding to one or more input commands for maintaining the table.

33. The computer program product of claim 26, wherein the computer program code further comprises program instructions for generating the query prior to executing the query, the query being generated by utilizing the XML file.

34. The computer program product of claim 26, wherein the XML file is updated based on the data operation identified in the input command.

35. The computer program product of claim 26, wherein the computer program code further comprises program instructions for enabling the user to view data, add data, update data and delete data corresponding to the table.

40. The computer program product of claim 26, wherein the database comprises a plurality of tables, each having an XML file corresponding thereto.

41. The computer program product of claim 40, wherein each XML file includes rules for at least one of data persistence or user interface design for the corresponding table.