Mobile Database Access Layer with Binary Metadata and Buffer Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
There is a need for an efficient method to develop and download a database access system to mobile applications, manage databuffers and redundant copies of records, and manage a limited number of database connections in a run-time environment, particularly for business operations requiring up-to-date information across localized and distributed systems.
Innovation Solution
The method involves creating a metadata file defining business objects and queries in a design environment, transforming it into a binary structure for storage on a mobile device, and managing memory by dividing it into blocks for efficient buffer management, while also implementing a data access layer that collapses the Business Object Layer and Transaction Layer to directly access databases, reducing inefficiencies associated with recordset abstraction.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If a metadata file is transformed into a binary structure and stored on the mobile device, then the database access system can be efficiently downloaded and deployed to mobile applications, but the memory management complexity increases due to the need to manage binary structures and buffer pages
Solution Approach 1:
The memory is divided into multiple buffer pages, each capable of holding multiple records. This segmentation allows efficient management of the binary structure by distributing records across multiple pages, enabling the system to handle large datasets without overwhelming memory constraints while maintaining fast access speeds.
Solution Approach 2:
The metadata file is transformed into a binary structure in advance during the development phase, and this pre-compiled binary structure is then stored on the mobile device. This preliminary transformation eliminates the need for runtime compilation, significantly improving database access efficiency and reducing the computational burden during actual operation.
2Productivity
If the Business Object Layer and Transaction Layer are collapsed to directly access databases, then the number of memory buffers required is reduced and access inefficiencies are eliminated, but the programming complexity increases due to the need to manage database connections and buffer pages directly
Solution Approach 1:
The Business Object Layer and Transaction Layer are merged into a single integrated layer that directly accesses the database. This consolidation eliminates the need for separate buffer management in each layer, reducing the total number of memory buffers required and eliminating the translation inefficiencies between layers, thereby improving data access speed.
Solution Approach 2:
The collapsed layer serves multiple functions simultaneously: it acts as both the business object interface and the transaction manager, handling database connections, buffer page management, and data retrieval operations all within a single unified structure. This multi-functionality reduces overall system complexity despite the increased programming challenges.
3Quantity of substance
If buffer pages are dynamically allocated and managed during record retrieval, then memory utilization is optimized, but the time required for buffer management operations increases
Solution Approach 1:
Buffer pages are pre-allocated and prepared in advance during system initialization or idle periods, rather than being dynamically allocated during record retrieval operations. This preliminary preparation eliminates the need for time-consuming dynamic allocation and management operations during actual data access, significantly reducing buffer management time while maintaining efficient memory utilization.
Data Source
AI summary
A method for accessing a database is provided. The method includes creating in a design environment a file that defines a metadata. The metadata relates at least one business object and at least one query. The method also includes communicating the file to a mobile device, storing the file on the mobile device, and transforming the file into a binary structure at an initial run of a computer application running on the mobile device. The binary structure is adapted to be read by the computer application. The method also includes recording the binary structure in a memory of the mobile device. A method for providing database access for a plurality of files with a limited number of database access channels is provided. A method for is provided for accessing a database in a computing environment for a plurality of recordsets. Each of the plurality of recordsets is associated with a database access channel for fetching records of the plurality of recordsets from the database upon occurrence of a preselected event. A method of fetching data for a plurality of active file from a database having a limited number of database connections is provided. A computer readable medium is provided which stores instructions executable by a computer. The instructions include a method for providing database access for a plurality of files with a limited number of database access channels. A device for accessing a database is provided. A system for updating a database access program is provided.