Database object script generation method and system
View Patent ↗An automatic scripting of objects of various complexities in a relational database includes creating a hierarchical object tree from a single or multiple reference object reference passed into the system. Duplicate object references are eliminated in the formation of the hierarchical tree. A dependency list is generated from the hierarchical tree. The dependency list represents a linear list of objects sequenced in the manner they should be created to satisfy dependency constraints. A script is generated from the dependency list which permits the deployment of varying complexity objects onto a target database. Script is generated by instantiating each object in the dependency list and calling a pre-constructed script method on the object. Each phase may be operated independently.
1. A method of generating a SQL script for a plurality of object references in a relational database, the method comprising:
receiving at least one object reference to be scripted for the relational database;
detecting relational dependencies of the at least one object reference;
constructing a hierarchical object tree comprising the at least one object reference;
deriving a dependency list from the hierarchal object tree based on the detected relational dependencies, wherein the dependency list is editable via a user program and comprises a linear list expressing an order in which objects will be created; and
generating the SQL script responsive to the dependency list, wherein the SQL script deploys relational database objects in a target database.
2. The method of claim 1 , wherein the constructing comprises eliminating duplicate object references and entering non-duplicated object references and associated metadata into a hierarchical object tree.
3. The method of claim 1 , wherein the constructing comprises triggering events indicating progress and providing for optional object manipulation.
4. The method of claim 3 , wherein the optional object manipulation comprises filtering of the at least one object references wherein an object reference selected by one or more of a user and a program may be deleted.
5. The method of claim 4 , wherein the optional object manipulation comprises removal of the selected object reference and all subsequent references dependent on the selected object reference.
6. The method of claim 1 , wherein the dependency list comprises a linear list expressed as an object generation order to satisfy dependency constraints.
7. The method of claim 1 , wherein the deriving recursively steps through lower tier dependencies of object references and provides optional object manipulation wherein the lower tier dependencies may be deleted.
8. The method of claim 1 , wherein the generating comprises allowing scripting options to modify the relational database script.
9. The method of claim 1 , wherein the relational database is a SQL database.
10. The method of claim 1 , wherein the relational dependencies are one or more of parent-child, child-grandchild, and grandchild-great grandchild.
11. The method of claim 1 , wherein the at least one object reference comprises a uniform resource name using a format comprising server/database/table.
12. The method of claim 1 , further comprising triggering one or more events permitting at least one of progress monitoring and object manipulation.
13. The method of claim 12 , wherein object manipulation comprises at least one of adding, modifying and deleting an object reference.
14. A computer-readable storage medium, having computer-executable instructions, for performing a method of generating a SQL script for one or more objects in a relational database, the method comprising:
receiving at least one object reference to be scripted for the relational database;
detecting relational dependencies of the at least one object reference;
constructing a hierarchical object tree comprising the at least one object reference;
deriving a dependency list from the hierarchal object tree based on the detected relational dependencies, wherein the dependency list is editable via user program and comprises a linear list expressing an order in which the objects will be created; and
generating the SQL script responsive to the dependency list, wherein the SQL script deploys relational database objects in a target database.
15. The computer-readable storage medium of claim 14 , wherein the constructing comprises eliminating duplicate object references and entering non-duplicated object references and associated metadata into a hierarchical object tree.
16. The computer-readable storage medium of claim 14 , wherein the constructing comprises triggering events indicating progress and providing for optional object manipulation.
17. The computer-readable storage medium of claim 16 , wherein the optional object manipulation comprises filtering of the at least one object references wherein objects references may be deleted.
18. The computer-readable storage medium of claim 17 , wherein the optional object manipulation comprises removal of object references and all subsequent references dependent on the removed object reference.
19. The computer-readable storage medium of claim 14 , wherein the dependency list comprises a linear list expressed in the order in which the at least one object reference are generated to satisfy dependency constraints.
20. The computer-readable storage medium of claim 14 , wherein the deriving recursively steps through lower tier dependencies of object references and provides optional object manipulation wherein the lower tier dependencies may be deleted.
21. The computer-readable storage medium of claim 14 , wherein the generating comprises allowing scripting options to modify the relational database script.
22. The computer-readable storage medium of claim 14 , wherein the at least one object reference comprises a uniform resource name using a format comprising server/database/table.
23. A computer system for generating a SQL script for object references in a relational database, the system comprising:
an input device for receiving the object references to be scripted for the relational database;
a processor wherein computer instructions for generating the script are executed to perform the acts of:
detecting relational dependencies of the object references;
constructing a hierarchical object tree comprising the object references;
deriving a dependency list from the hierarchal object tree based on the detected relational dependencies, wherein the dependency list is editable via a user program and comprises a linear list expressing an order in which objects will be created; and
generating the SQL script responsive to the dependency list; and
a communication port for passing the script to one or more of a display device, a subsequent computer program, and a storage device.
24. The computer system of claim 23 , wherein the at least one object reference comprises a uniform resource name having a format comprising server/database/table.