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

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

Example Embodiment

[0054] Example 1

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

[0056] figure 1 , figure 2 with 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 data dictionary and field data dictionary of the specified table or view under the user can be obtained by the user name, table name or view name, and can be obtained according to these data dictionaries figure 2 with image 3 ; figure 2 Describes the object mapping relationship between the fields in the database table structure and the data members of the programming language data structure (the object mapping relationship between the fields of the view and the data members of the programming language data structure is similar to this, and will n...

Example Embodiment

[0065] Example 2

[0066] Figure 4 Shows the process of automatically adapting objects for database access requests. Assuming 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 specific instructions are as follows :

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

[0068] Step description: According to figure 2 Create a programming language data object of the programming language data structure S corresponding to the table T, assign values ​​to the object members of S corresponding to the database table field 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 (ie table T), operation type (insert, query, delete and modify), field operation type of table T (such as input field, outpu...

Example Embodiment

[0082] Example 3

[0083] Figure 5 Shows the flow chart of automatically adapting the database query result to the object. When the database access request is a query operation, the database query result automatically adapts the object to the subsequent process of the database access request automatically adapts the object, namely Figure 5 for Figure 4 Continuation of, suppose 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 table T is S. The specific instructions are as follows:

[0084] Step 3-1, query 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, get the data dictionary;

[0087] Step description: Obtain the table data dictionary of table T and ...

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 Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap