Data access method and database system based on cloud computing

A data access and database technology, applied in the field of cloud computing, can solve the problems of data format conversion, increase the complexity and repetition of management automation program development, achieve broad application prospects, achieve platform independence, and enhance portability.

Inactive Publication Date: 2012-06-20
INSPUR BEIJING ELECTRONICS INFORMATION IND
View PDF0 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This interactive method will force users to solve data access and integration problems within the application system, and make managers or management organizations fall

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 and database system based on cloud computing
  • Data access method and database system based on cloud computing

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] Embodiment 1, a data access method based on cloud computing, comprising:

[0034] When a cloud user's database access instruction is received, the database metadata carried in the instruction is matched with the metadata of each database in the cloud system to confirm the database to be accessed by the instruction; the SQL (Structured Query Language, structured query language) instruction;

[0035] Generate a database connection string and locate it in the confirmed database; then execute the SQL command to obtain an execution result;

[0036] The execution result is converted into the data format adopted by the cloud user and fed back to the cloud user.

[0037] In this embodiment, the structure of the underlying database entity can be ignored, whether it is SQLServer, Orcal, MySQL can be distinguished in the above logic layer, and then the data is accessed at the data link layer, and the service interface provided externally is unified .

[0038] In this embodiment...

Embodiment 2

[0049] Embodiment two, a database system based on cloud computing, such as figure 1 shown, including:

[0050] service layer module;

[0051] The logic layer module is used to match the database metadata carried in the instruction with the metadata of each database in the cloud system when the service layer module receives the cloud user's database access instruction, and confirm the database to be accessed by the instruction ; Analyzing the database access command to obtain the SQL command;

[0052] The data link layer module is used to generate a database connection string and locate it in the confirmed database; then execute the SQL command to obtain an execution result;

[0053] The logic layer module is also used to convert the execution result into the data format adopted by the cloud user and then feed it back to the cloud user through the service layer module.

[0054] In this embodiment, if the database access instruction is for querying data, the execution result ...

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 data access method and a database system based on cloud computing. The method comprises the following steps of: when receiving a database access instruction from a cloud user, matching the database metadata carried in the instruction with the metadata of each database in a cloud system, and determining the target database of the instruction; parsing the database access instruction to obtain a SQL (Structured Query Language) instruction; generating a database connection string, and locating in the determined database; then, executing the SQL instruction to obtain the execution result; converting the execution result into a data format used by the cloud user, and feeding back the converted result to the cloud user. With the method and the system, the tight coupling between the application and the database in the cloud computing environment can be broken, so that data access can be expanded on a wider platform.

Description

technical field [0001] The invention relates to the field of cloud computing, in particular to a data access method and database system based on cloud computing. Background technique [0002] Cloud computing is an emerging business computing model, which distributes computing tasks on a resource pool composed of a large number of computers, enabling various application systems to obtain computing power, storage space and various software services as needed. At present, most of the data access and integration in the network environment use the visitor to directly interact with the DBS (Database System, database system) service interface. This kind of interaction will force users to solve data access and integration problems within the application system, and make managers or management organizations fall into technical problems such as database connection and data format conversion, which increases the complexity and repetition of management automation program development . ...

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 INSPUR BEIJING ELECTRONICS INFORMATION IND
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