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

Database engine

A database and engine technology, applied in the field of database engines, can solve the problems of many dependent packages, low efficiency, error-prone, etc., and achieve the effect of high SQL execution efficiency

Inactive Publication Date: 2017-02-22
贵州云众知乐教育科技有限公司
View PDF10 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] In the development of enterprise projects, in order to improve development efficiency and reduce development costs, we can start from the aspect of database processing. There are two commonly used database processing solutions: one is to use open source ORM, such as Hibernate, which depends on too many packages and is difficult to get started. The second is to use pure JDBC operations. Although this solution has the highest execution efficiency, developers must remember the field names or serial numbers when processing complex data tables. It is easy to make mistakes, and it is difficult to troubleshoot after errors. Moreover, most of the current data processing schemes have a large number of repeated database connections and jdbc operations. Therefore, a set of database operation engines should be developed in combination with actual needs to reduce unnecessary repeated database connections and jdbc processing related operations. Gain time and efficiency for developers

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 engine
  • Database engine
  • Database engine

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0014] Example 1. If figure 1 Shown, a kind of database engine, it comprises load balancing fetcher, database entity bean, it is characterized in that; Through data source configuration file, establish a plurality of data source pools that can be connected with different types of databases, with data source name Get the data connection from the data source pool, put the data connection into the thread data connection pool, the data source pool and the data connection pool are connected with the basic sql execution layer, the persistent object sql conversion layer, and the external operation interface layer in turn, and the thread There is only one connection in the same thread of the data connection pool. In the entity bean, the database table name and table fields are parsed by the reflection mechanism, and the database created by the data source pool is connected back to the data source pool through the load balancer.

[0015] its operation process

[0016] 1. Automatically...

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 engine. The database engine comprises a load balancing data fetching device and a database entity bean, and is characterized in that multiple data source pools which can be connected with databases of different types are established through data source configuration files, data source names are used to obtain data connection from the data source pools, the data connection is put in a thread data connection pool, and the data source pools and the data connection pool are successively connected with a basic sql execution layer, a persistent object sql conversion layer and an external operation interface layer. By adopting the database engine, the higher SQL execution efficiency can be reached, and unnecessary repeated database connection and related operations of jdbc processing can be reduced to gain time and efficiency for developers.

Description

technical field [0001] The invention relates to a database engine and belongs to the technical field of databases. Background technique [0002] In the development of enterprise projects, in order to improve development efficiency and reduce development costs, we can start from the aspect of database processing. There are two commonly used database processing solutions: one is to use open source ORM, such as Hibernate, which depends on too many packages and is difficult to get started. The second is to use pure JDBC operations. Although this solution has the highest execution efficiency, developers must remember the field names or serial numbers when processing complex data tables. It is easy to make mistakes, and it is difficult to troubleshoot after errors. Moreover, most of the current data processing schemes have a large number of repeated database connections and jdbc operations. Therefore, a set of database operation engines should be developed in combination with actu...

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 贵州云众知乐教育科技有限公司
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