Structured View from Non-Relational Database
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database management systems face challenges in accessing and presenting unstructured data in a structured form without altering the underlying data, particularly in non-relational databases.
Innovation Solution
A business object configuration file is used to define how data is retrieved and presented from a database, allowing users to specify field names, data types, and post-processing operations, enabling the creation of a structured view of unstructured data through a data engine that registers, retrieves, and formats data based on user-defined specifications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If unstructured data is stored in a non-relational database, then data storage flexibility and optimization are improved, but data retrieval and presentation in structured form becomes more difficult
Solution Approach 1:
The patent introduces a view definition mechanism that acts as an intermediary layer between the non-relational database and the user. This view definition contains structured field definitions that map to unstructured data fields, enabling structured access to unstructured data without altering the underlying storage format. The view definition serves as a mediator that translates unstructured data into structured presentations.
2Adaptability or versatility
If data is retrieved and formatted based on user-defined specifications, then data presentation flexibility is improved, but processing complexity increases
Solution Approach 1:
The patent implements view definitions that are pre-configured with field mappings, data types, and formatting specifications. These view definitions are registered and stored beforehand, allowing the system to quickly retrieve and format data according to pre-established rules without complex processing at query time. The preliminary configuration of view definitions reduces processing complexity during actual data retrieval operations.
Data Source
AI summary
In an approach for retrieving and presenting data in a structured view from a database, a processor receives a request from a user for accessing data in the database based on a business object. The business object may be a configuration file that defines the data and how the data is to be retrieved from the database. A processor retrieves the business object. A processor determines, based on the business object, a location in the database to get the data. A processor retrieves the data from the database based on the business object. A processor formats the data based on the business object. A processor performs a post process on the data based on the business object. A processor returns the data to the user.