Database access intermediate system, method, device and storage medium

An intermediate system and access method technology, applied in the field of database access intermediate systems, can solve problems such as application restart, and achieve the effect of avoiding restart

Active Publication Date: 2020-12-15
携程旅游信息技术(上海)有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the problems in the prior art, the object of the present invention is to provide a database access intermediate system, method, device and storage medium, which solves the problem of application restart caused by query logic changes
At the same time, it also solves the problem of writing quality of SQL statements

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 intermediate system, method, device and storage medium
  • Database access intermediate system, method, device and storage medium
  • Database access intermediate system, method, device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.

[0048] Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus repeated descriptions thereof will be omitted. Some of the block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities ...

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 present invention provides a database access intermediate system, method and device and a storage medium. The system comprises a configuration module for configuring a SQL statement for accessinga database, a storage module for storing the configured SQL statement for accessing the database, a calling interface for data interaction with an application, and an execution module for acquiring adatabase access request of the application through the calling interface, invoking the corresponding SQL statement to access the database according to the database access request, and returning the execution data of the database to the application through the calling interface. By adopting the scheme of the invention, the connection string and the SQL statement are extracted from a source code, and unified management and automatic auditing are performed, thereby completely avoiding restart of the application due to the query logic change, and the system performance problem caused due to nonstandard writing of the SQL statement.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a database access intermediate system, method, device and storage medium. Background technique [0002] In the prior art, when developing applications, methods such as JDBC, odbc, etc. are generally used to obtain DB (Database, database) connections, and directly write SQL (Structured Query Language, structured query language) statements in the source code to implement the application. The program adds, deletes, modifies and checks the database. Among them, JDBC (Java DataBaseConnectivity, java database connection) is a Java API for executing SQL statements, which can provide unified access to various relational databases, and it consists of a set of classes and interfaces written in Java language. ODBC (Open Database Connectivity, open database connection) is a database connection method for solving data sharing between heterogeneous databases. [0003] However, ther...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2455G06F16/2453
Inventor 李艳秋赵冷奇陈奎周才菊陈凯
Owner 携程旅游信息技术(上海)有限公司
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