Systems, methods, and media for accessing derivative properties from a post relational database utilizing a logical schema instruction that includes a base object identifier
Techniques are provided for accessing derivative properties from a database utilizing a logical schema instruction that includes a base object identifier. A logical schema instruction may be received and analyzed to identify a predefined keyword. A portion of the logical schema instruction, that is located in relation to the predefined keyword, may be identified. The portion may include a base object identifier and a property identifier, e.g., a derivative property identifier. In an embodiment, the identified portion of the logical instruction is not translated to a database schema instruction at prepare time. Instead, an extract function is executed at runtime access and analyze a database table that corresponds to a base object associated with the base class identifier. A property in the database table that corresponds to the property identifier may be identified. Advantageously, a base object identifier may be utilized to access a derivative property.
1. A system comprising:
a processor coupled to a memory, the processor executing a software module of an application, the software module configured to:
receive a logical schema instruction;
determine if the logical schema instruction includes a predefined keyword;
in response to determining the predefined keyword is included in the logical schema instruction, identify a portion of the logical schema instruction that is located at a particular location relative to the predefined keyword,
wherein the portion includes at least a property identifier and a base object identifier; and
execute, instead of performing a translation at prepare time for the portion, an extract function at runtime to access a database table corresponding to a base object identified by the base object identifier, wherein the extract function identifies a property in the database table utilizing the property identifier.
2. The system of claim 1 , wherein the property identifier is a derivative property identifier.
3. The system of claim 1 , wherein the base object has one or more base properties, and a derivative object of the base object has access to the base properties.
4. The system of claim 3 , wherein the derivative object includes one or more derivative properties and the one or more derivative properties include the property.
5. The system of claim 4 , wherein the base object does not contain the one or more derivative properties.
6. The system of claim 1 , wherein the base object represents a category of a plurality of model objects included in a model representing an infrastructure, and wherein the property, associated with the property identifier, is for a particular model object included in the model and that is within the category.
7. The system of claim 1 , wherein the base object is included in a hierarchy of class objects, and the hierarchy includes at least one or more derivative objects.
8. The system of claim 1 , wherein the logical schema instruction is based on a logical schema that is separate from a database schema that is utilized to access the database table at runtime.
9. A method, comprising:
receiving a logical schema instruction;
determining if the logical schema instruction includes a predefined keyword;
in response to determining the predefined keyword is included in the logical schema instruction, identifying, by a processor, a portion of the logical schema instruction that is located at a particular location relative to the predefined keyword,
wherein the portion includes at least a property identifier and a base object identifier; and
executing, instead of performing a translation at prepare time for the portion, an extract function by a software module at runtime to access a database table corresponding to a base object identified by the base object identifier, wherein the extract function identifies a property in the database table utilizing the property identifier.
10. The method of claim 9 , wherein the property identifier is a derivative property identifier.
11. The method of claim 9 , wherein the base object has one or more base properties, and a derivative object of the base object has access to the base properties.
12. The method of claim 11 , wherein the derivative object includes one or more derivative properties and the one or more derivative properties include the property.
13. The method of claim 12 , wherein the base object does not contain the one or more derivative properties.
14. The method of claim 9 , wherein the base object represents a category of a plurality of model objects included in a model representing an infrastructure, and wherein the property, associated with the property identifier, is for a particular model object included in the model and that is within the category.
15. The method of claim 9 , wherein the base object is included in a hierarchy of class objects, and the hierarchy includes at least one or more derivative objects.
16. The method of claim 9 , wherein the logical schema instruction is based on a logical schema that is separate from a database schema that is utilized to access the database table at runtime.
17. A non-transitory computer readable medium having software encoded thereon, the software when executed by one or more computing devices operable to:
receive a logical schema instruction;
determine if the logical schema instruction includes a predefined keyword;
in response to determining the predefined keyword is included in the logical schema instruction, identify a portion of the logical schema instruction that is located at a particular location relative to the predefined keyword,
wherein the portion includes at least a property identifier and a base object identifier; and
execute, instead of performing a translation at prepare time for the portion, an extract function by a software module at runtime to access a database table corresponding to a base object identified by the base object identifier, wherein the extract function identifies a property in the database table utilizing the property identifier.
18. The non-transitory computer readable medium of claim 17 , wherein the property identifier is a derivative property identifier.
19. The non-transitory computer readable medium of claim 17 , wherein the base object has one or more base properties, and a derivative object of the base object has access to the base properties.
20. The non-transitory computer readable medium of claim 19 , wherein the derivative object includes one or more derivative properties and the one or more derivative properties include the property.