Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

General method for automatic object adapting in database access

A data object and database technology, applied in database management systems, electronic digital data processing, structured data retrieval, etc., can solve problems such as large dependence on database structure, low software scalability and versatility, and huge maintenance projects , to achieve the effect of high reusability, easy development and high scalability

Active Publication Date: 2015-09-16
THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP
View PDF5 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The traditional query data access method is implemented by writing a structured query language (Structured Query Language, SQL for short) by calling the database-specific interface. The query field writes the query statement, and then assigns the query result to the application object of the programming language. When inserting, updating, and deleting records, it is also necessary to organize SQL statements according to the application object of the programming language to write the database, which makes the programming language The object and the database are tightly coupled, and the database application program is too dependent on the specific database structure. When the application object changes, it needs to expand or add new queries, and the scalability and versatility of the software are not high.
[0003] At present, scholars at home and abroad have proposed a general-purpose database access technology based on data dictionaries through research on database data catalogs, but they have not realized the object-based association of database objects and programming language application objects through data dictionaries. In addition, the industry has also passed The serialization method is a successful case of realizing the objectification of database table and programming language application object data structure. However, although the serialization method solves the problem of automatic objectification of database table and application object, it must design a separate set for each table. The access interface requires a huge post-maintenance project, especially in application scenarios where the database system is relatively large or changes frequently

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • General method for automatic object adapting in database access
  • General method for automatic object adapting in database access
  • General method for automatic object adapting in database access

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0055] The application of the present invention will be described in detail below in conjunction with the accompanying drawings.

[0056] figure 1 , figure 2 and image 3 Shows the objectification process of database tables and programming language data structures, figure 1 Describes the relationship between user data dictionary, table or view data dictionary and field data dictionary, according to figure 1 It can be seen that the specified table or view data dictionary and field data dictionary under the user can be obtained through the user name, table name or view name, and the data dictionary can be obtained according to these data dictionaries figure 2 and image 3 ; figure 2 Describes the object-oriented mapping relationship between the fields in the database table structure and the data members of the programming language data structure (the object-oriented mapping relationship between the fields of the view and the data members of the programming language data ...

Embodiment 2

[0066] Figure 4 Shows the process of automatically adapting objects for database access requests. Assume that the accessed database table is table T (the operation of the view is the same as that of the table, so I won’t repeat it here), and the programming language data structure corresponding to table T is S. The details are as follows :

[0067] Step 2-1, constructing a database access request according to the programming language data object;

[0068] Step Description: According to figure 2Create the programming language data object of the programming language data structure S corresponding to the table T, and assign values ​​to the object members corresponding to S in the database table field that needs to be operated, and provide access instructions to the table T, such as the database user name where the table T is located , table name (that is, table T), operation type (insert, query, delete, and modify), field operation type of table T (such as input field, output...

Embodiment 3

[0083] Figure 5 Shows the flowchart of the automatic adaptation object of the database query result. When the database access request is a query operation, the automatic adaptation object of the database query result is the subsequent process of the automatic adaptation object of the database access request, namely Figure 5 for Figure 4 As a continuation of , it is assumed that the accessed database table is table T (the operation of the view is the same as that of the table, which will not be repeated here), and the programming language data structure corresponding to the table T is S. The specific instructions are as follows:

[0084] Step 3-1, querying the data dictionary;

[0085] Step Description: Query the data dictionary loaded by the system according to the currently queried database user name and table name (the data dictionary is generated by "Example 1").

[0086] Step 3-2, obtain the data dictionary;

[0087] Step description: Obtain the table data dictionar...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a general method for automatic object adapting in database access. The method comprises the steps that a data dictionary and a programming language data structure are automatically generated through a database data directory; according to the data dictionary technology, automatic adapting between a database table and a programming language application object can be achieved; a database access interface achieved by the method can provide the database access without an SQL statement for a user, the objectification of the database table and the programming language data structure is achieved, the automatic object adapting of a database access request and the automatic object adapting of a database requesting result are achieved, a 'dynamic coupling' relation is established between a database and the application object according to the objectification, after the database is designed and changed, re-objectification can be carried out on the database through the automatic method in a mode that the data dictionary and the programming language data structure are re-generated, and the problems that the dependency of a database application program on the specific database structure is too large, the software expendability is poor, and the universality is low are solved.

Description

technical field [0001] The invention belongs to the field of computer applications and relates to a method for automatically adapting objects in general database access, in particular to a method for automatically matching the table structure of the database system with the application objects of application software in the application of the database system. Background technique [0002] The database system is an indispensable and important part in the design of the electronic information system, and the data access function is the most basic function of the database system. The traditional query data access method is implemented by writing a structured query language (Structured Query Language, SQL for short) by calling the database-specific interface. The query field writes the query statement, and then assigns the query result to the application object of the programming language. When inserting, updating, and deleting records, it is also necessary to organize SQL statem...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 雷明涛田少鹏何赟薛松郭灵波印小冬李怡谦
Owner THE 28TH RES INST OF CHINA ELECTRONICS TECH GROUP CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com