System and method for loading objects for object-relational mapping
View Patent ↗Disclosed are systems and methods for creating data objects, which includes querying a database to locate a first table associated with a first data type to be created, loading a plurality of rows from the first table during the query associated with the first table, creating a first set of data objects associated with the first data type, wherein each data object of the first set is created from data stored in each of the rows loaded from the first table. The systems and methods also include querying the database to locate a second data type to be created, wherein the second data type depends from the first data type, wherein the data objects of the second set depend from the data objects of the first set, and associating each data object of the second set to an associated parent object of the first set.
1. A method for creating data objects, the method comprising:
performing a first query of a database to locate a first table associated with a first data type to be created;
loading a plurality of rows from only the first table during the query associated with the first table;
creating a first set of data objects associated with the first data type, wherein each data object of the first set is created from only data stored in each of the rows loaded from the first table;
performing a second query of the database to locate a second table associated with a second data type to be created, wherein the second data type depends from the first data type;
loading a plurality of rows from only the second table during the query associated with the second table;
creating a second set of data objects associated with the second data type, wherein each data object of the second set is created from only data stored in each of the rows loaded from the second table, wherein the data objects of the second set depend from the data objects of the first set; and
associating each data object of the second set to an associated parent object of the first set,
wherein the database is queried only once for the first table and the database is queried only once for the second table.
2. The method of claim 1 , wherein the method further comprises:
querying the database to locate a third table associated with a third data type to be created, wherein the third data type depends from the second data type;
loading a plurality of rows from the third table during the query associated with the third table;
creating a third set of data objects associated with the third data type, wherein each data object of the third set is created from data stored in each of the rows loaded from the third table, wherein the data objects of the third set depend from the data objects of the second set; and
associating each data object of the third set to an associated parent object of the second set.
3. The method of claim 2 , wherein the three sets of objects having a dependent relationship with one another are created based on three queries to the database.
4. The method of claim 1 , wherein the two sets of objects having a dependent relationship with one another are created based on two queries to the database.
5. The method of claim 1 , wherein the first table and the second table are the same table.
6. The method of claim 1 , wherein a portion of the database having the second table is located on a different machine than another portion of the database having the first table.
7. The method of claim 1 , wherein the data objects are associated with classes of an object oriented programming language.
8. A system for creating data objects, the system comprising:
a machine comprising a processor, wherein the machine is operable to:
perform a first query of a database to locate a first table associated with a first data type to be created;
load a plurality of rows from only the first table during the query associated with the first table;
create a first set of data objects associated with the first data type, wherein each data object of the first set is created from only data stored in each of the rows loaded from the first table;
perform a second query of the database to locate a second table associated with a second data type to be created, wherein the second data type depends from the first data type;
load a plurality of rows from only the second table during the query associated with the second table;
create a second set of data objects associated with the second data type, wherein each data object of the second set is created from only data stored in each of the rows loaded from the second table, wherein the data objects of the second set depend from the data objects of the first set; and
associate each data object of the second set to an associated parent object of the first set,
wherein the database is queried only once for the first table and the database is queried only once for the second table.
9. The system of claim 8 , wherein the machine is further operable to:
query the database to locate a third table associated with a third data type to be created, wherein the third data type depends from the second data type;
load a plurality of rows from the third table during the query associated with the third table;
create a third set of data objects associated with the third data type, wherein each data object of the third set is created from data stored in each of the rows loaded from the third table, wherein the data objects of the third set depend from the data objects of the second set; and
associate each data object of the third set to an associated parent object of the second set.
10. The system of claim 8 , wherein the three sets of objects having a dependent relationship with one another are created based on three queries to the database.
11. The system of claim 8 , wherein the two sets of objects having a dependent relationship with one another are created based on two queries to the database.
12. The system of claim 8 , wherein the first table and the second table are the same table.
13. The system of claim 8 , wherein a portion of the database having the second table is located on a different machine than another portion of the database having the first table.
14. The system of claim 8 , wherein the data objects are associated with classes of an object oriented programming language.
15. Logic for creating data objects, the logic being embodied in a non-transitory computer-readable medium and when executed operable to:
performing a first query of a database to locate a first table associated with a first data type to be created;
load a plurality of rows from only the first table during the query associated with the first table;
create a first set of data objects associated with the first data type, wherein each data object of the first set is created from only data stored in each of the rows loaded from the first table;
performing a second query of the database to locate a second table associated with a second data type to be created, wherein the second data type depends from the first data type;
load a plurality of rows from only the second table during the query associated with the second table;
create a second set of data objects associated with the second data type, wherein each data object of the second set is created only from data stored in each of the rows loaded from the second table, wherein the data objects of the second set depend from the data objects of the first set; and
associate each data object of the second set to an associated parent object of the first set,
wherein the database is queried only once for the first table and the database is queried only once for the second table.
16. The logic of claim 15 , wherein the logic is further operable to:
query the database to locate a third table associated with a third data type to be created, wherein the third data type depends from the second data type;
load a plurality of rows from the third table during the query associated with the third table;
create a third set of data objects associated with the third data type, wherein each data object of the third set is created from data stored in each of the rows loaded from the third table, wherein the data objects of the third set depend from the data objects of the second set; and
associate each data object of the third set to an associated parent object of the second set.
17. The logic of claim 15 , wherein the three sets of objects having a dependent relationship with one another are created based on three queries to the database.
18. The logic of claim 15 , wherein the two sets of objects having a dependent relationship with one another are created based on two queries to the database.
19. The logic of claim 15 , wherein the first table and the second table are the same table.
20. The logic of claim 15 , wherein a portion of the database having the second table is located on a different machine than another portion of the database having the first table.
21. The logic of claim 15 , wherein the data objects are associated with classes of an object oriented programming language.