Database Metadata Interface for Dynamic Graphic Display
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data sharing systems face difficulties in correctly displaying data from databases to client devices due to incompatibilities between the data model of the database and the graphic interface, particularly in remote management and control applications using 'Cloud computing' where various data models are employed.
Innovation Solution
A data sharing computer system that communicates between a database and a client device using the Open Data Protocol, where the database sends metadata describing its data model to the client device, allowing dynamic construction of a software graphic interface adapted to the database model, enabling correct visual display of data regardless of the data model used.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If a database uses a specific data model to organize and store data, then data storage and retrieval efficiency is improved, but compatibility with client devices having different graphic interfaces deteriorates
Solution Approach 1:
The patent introduces a metadata layer as an intermediary between the database and client devices. This metadata layer acts as a mediator that translates the database's internal data model into a standardized interface description, allowing client devices to access data without needing to understand the underlying database structure. The metadata serves as a universal language that bridges different data models and graphic interface requirements.
Solution Approach 2:
The patent changes the parameters of data representation by introducing metadata that describes the data model independently from the actual data storage structure. Instead of hardcoding data model specificities into client applications, the system dynamically retrieves metadata parameters that describe the database schema, allowing the same client interface to adapt to different data models by receiving different metadata parameter sets.
2Manufacturing precision
If client applications are designed to work with specific data models, then graphic interface correctness is improved, but ability to display data from databases with different data models deteriorates
Solution Approach 1:
The patent makes the graphic interface dynamic rather than static. Instead of designing applications for specific data models, the interface dynamically retrieves metadata describing the actual database structure and adapts its behavior accordingly. The graphic interface components automatically adjust their properties based on the retrieved metadata, enabling the same application to correctly display data from different databases without manual reconfiguration.
Solution Approach 2:
The system performs preliminary action by retrieving and processing metadata before actually displaying data. The metadata is fetched in advance to describe the database schema, and this information is used to pre-configure the graphic interface components. This preliminary metadata retrieval and processing step ensures that when data is subsequently retrieved and displayed, the interface is already properly configured for that specific data model.
3Adaptability or versatility
If databases are hosted in cloud computing environments, then accessibility and scalability are improved, but data sharing complexity between client devices and remote equipment deteriorates
Solution Approach 1:
The patent implements a universal data sharing interface based on standardized metadata protocols that work across different cloud computing environments and database types. The same metadata-based communication mechanism can interface with various cloud providers and database systems, eliminating the need for separate integration solutions for each platform. This universal approach simplifies data sharing complexity while maintaining scalability.
Data Source
AI summary
A computer system for sharing data in a database, including the database, an Internet network, and a client computer device communicating with a software interface of the database through the network via Open Data Protocol. The software interface sends metadata describing a data model of the database to the client computer device, and the client device makes a software graphic interface by associating the metadata with a graphic interface component graphically displaying the stored data. The computer system further includes electrical equipment that communicates with the software interface through the network via the Open Data Protocol, and one item of following equipment: a programmable logic controller, and input/output module, a speed controller, a switch, a sensor, an actuator, a measurement apparatus.