Database access platform and access method thereof

A database and platform technology, applied in the database field, can solve problems such as high requirements for technical personnel and difficult to understand codes, so as to reduce technical requirements, simplify the learning and use process, and realize the effect of database operation.

Inactive Publication Date: 2008-06-11
CHINA CONSTRUCTION BANK
View PDF0 Cites 49 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention is to provide a database access platform and its access method to solve a series

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
  • Database access platform and access method thereof
  • Database access platform and access method thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0038] The embodiment of the present invention provides a database access platform, which encapsulates the database structure well, shields direct SQL operations, and centrally manages database operation SQL statements. Developers can use the platform to implement access operations to the database without paying too much attention to specific SQL operations. The platform is suitable for different application platforms and has good scalability.

[0039] The implementation of the platform mainly includes two parts: data source acquisition and database operation, which will be described in detail below. Wherein, the data source refers to a database to be accessed by an application system outside the platform.

[0040] Referring to ...

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 discloses a database access platform and access method, which solves problems of high requirements on technician, impalpable code and safety of traditional database operation mode. The platform mainly comprises an application access interface for supplying setting of database configuration information and feeding back database operation result; a data source acquisition unit for connecting corresponding database according to the database names in the configuration information; a database single table operation unit for calling corresponding table structure information according to the access parameters in the configuration information and executing corresponding SQL operation in combination with generation of SQL sentence; a database complex operation unit for calling corresponding SQL template according to the access parameter in the configuration information and executing corresponding SQL operation in combination with generation of SQL sentence. Because of shielding direct SQL operation, the platform facilitates developers unnecessary to concern detailed SQL sentence spelling and database operation and greatly reduces the technical requirements on developers.

Description

technical field [0001] The invention relates to database technology, in particular to a database access platform and an access method thereof. Background technique [0002] In the development process of various business application systems, it is necessary to visit the database many times. Traditional database processing mainly completes database operations through programmers spelling complex and cumbersome SQL statements. SQL is the abbreviation of Structured Quevy Language (Structured Query Language). It is a set of operation commands specially established for databases, and it is a full-featured database language. [0003] The disadvantage of this traditional method is: if the SQL statement is written irregularly or incompletely, it is easy to cause a bottleneck in the actual running process. Therefore, the traditional database operation method has high requirements for technicians, and it is difficult to debug the program. The generated code is lengthy and difficult t...

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
Inventor 杨芬吴炜斯王迎春李志钧
Owner CHINA CONSTRUCTION BANK
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