Supercharge Your Innovation With Domain-Expert AI Agents!

Data access method, device and system based on virtual database, equipment and medium

A data access and database technology, applied in the database field, can solve problems such as large amount of code writing, difficult maintenance, and complex business logic on the request side

Pending Publication Date: 2021-11-23
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

A large amount of code is written, the business logic of the request side is complex, and maintenance is difficult

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
  • Data access method, device and system based on virtual database, equipment and medium
  • Data access method, device and system based on virtual database, equipment and medium
  • Data access method, device and system based on virtual database, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] Hereinafter, embodiments of the present disclosure will be described with reference to the drawings. It should be understood, however, that these descriptions are exemplary only, and are not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the present disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Also, in the following description, descriptions of well-known structures and techniques are omitted to avoid unnecessarily obscuring the concepts of the present disclosure.

[0030] The terminology used herein is for the purpose of describing particular embodiments only, and is not intended to be limiting of the present disclosure. The terms "comprising", "comprising", etc. used herein indicate the presence of stated features,...

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 data access method, device, system and equipment based on a virtual database, a medium and a program product, and relates to the technical field of databases. The method comprises the following steps: receiving an SQL query request of a user layer; performing statement analysis on the SQL query request, calling a preset rule in a rule base based on a statement analysis result to decompose the SQL query request into a plurality of local query statements, and routing and distributing the local query statements to corresponding databases to obtain corresponding query data; and assembling the query data and then outputting a query result to the user layer. According to the data access method based on the virtual database, the problems that in the prior art, due to the fact that different code logics are written for different databases to complete corresponding connection and access operation, the code writing amount is large, the request end service logic is complex, and maintenance is difficult are solved.

Description

technical field [0001] The present disclosure relates to the technical field of databases, and more specifically relates to a virtual database-based data access method, device, system, equipment, medium and program product. Background technique [0002] At present, the internal logic of mainstream large-scale enterprise-level applications is becoming increasingly complex, and there are many types of databases used due to historical or upgrading reasons, such as mysql, oracle, informix, etc. If the data requester wants to implement connection and access to heterogeneous databases, it needs to write different code logic for different databases in the application to complete the corresponding connection and access operations. The amount of code writing is large, the business logic of the request side is complex, and maintenance is difficult. Contents of the invention [0003] In view of the above problems, the present disclosure provides a data access method, device, system,...

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): G06F16/242G06F16/2455G06F16/248G06F16/25
Inventor 姚文猛高园刘意马蕾
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More