Logical Schema Accessing Derivative Properties via Base Object Identifier
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional systems require users to know and include identifiers of derivative classes to access derivative properties, making it time-consuming and laborious, and processor-intensive, as they cannot utilize a base class identifier to access derivative properties efficiently.
Innovation Solution
A processor module analyzes logical schema instructions for a predefined keyword, allowing it to execute an extract function at runtime to access derivative properties using a base class identifier, eliminating the need for meta queries and reducing processing resources.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If conventional systems require users to know and include identifiers of derivative classes to access derivative properties, then the system can accurately retrieve the requested data, but the operation becomes time-consuming and laborious for users
Solution Approach 1:
The patent introduces a logical schema layer as an intermediary between the user and the database. This logical schema maps intuitive base class identifiers to the actual derivative class identifiers in the database, allowing users to access derivative properties through the base class identifier without needing to know the specific derivative class identifiers. The system automatically resolves the mapping, reducing user effort and time while maintaining accurate data retrieval.
2Loss of information
If conventional systems require meta queries to find derivative class identifiers, then the system can locate the required data, but the processing becomes processor-intensive
Solution Approach 1:
The patent performs preliminary action by pre-establishing the logical schema mapping between base class identifiers and derivative class identifiers during system setup or compilation. This mapping is stored and reused during runtime, eliminating the need for processor-intensive meta queries when accessing derivative properties. The system has already prepared the identifier relationships in advance, so runtime operations are much more efficient.
3Productivity
If the database schema uses auto-generated column identifiers unrelated to data types, then the database achieves optimal performance and file size, but the schema becomes complex and non-intuitive for users
Solution Approach 1:
The logical schema acts as an intermediary layer between the user-friendly conceptual model and the performance-optimized physical database schema. Users interact with the logical schema using intuitive base class identifiers and property names, while the system automatically translates these into the auto-generated column identifiers used in the underlying database. This preserves database performance while dramatically improving ease of operation.
Solution Approach 2:
The patent creates a logical schema that is a conceptual copy or abstraction of the physical database schema. This logical copy uses meaningful identifiers and structures that mirror the real-world domain model, making it intuitive for users. The physical database schema retains its auto-generated identifiers for performance optimization, and the system maps between the two schemas, allowing users to work with the intuitive copy without affecting the performance of the original.
Data Source
AI summary
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.