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

Virtual database system and query method

A query method and database technology, applied in database management systems, database distribution/replication, transmission systems, etc., can solve problems such as rapid delivery of results, data collection and maintenance costs and time loss, and frequent business changes of data developers. The effect of reducing the cost of learning

Inactive Publication Date: 2021-01-01
浙江百应科技有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The current mainstream method is to build a data warehouse / data lake with Hadoop as the core, which solves the problem of heterogeneous data systems and data dispersion to some extent, but there are still maintenance costs and timeliness losses caused by data collection.
In addition, data developers are also faced with the problems of frequent business changes and rapid delivery of results

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
  • Virtual database system and query method
  • Virtual database system and query method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0034]Referencefigure 1 withfigure 2As shown, this embodiment relates to a virtual database system, which includes a client layer for submitting SQL codes to achieve business requirements, an access layer for receiving and authenticating SQL codes, a distributed service layer for parsing SQL codes, and executing SQL codes. The requested reservoir computing layer and the metadata database used to store actual physical data, the client layer is connected to the access layer, the access layer is connected to the distributed service layer, the distributed service layer is connected to the storage computing layer, and the metadata Database Connectivity.

[0035]The client layer includes rest api, jdbc and cli. jdbc means Java database connection, cli means command line interface.

[0036]The access protocols of the access layer include http protocol, tcp protocol and thrift protocol.

[0037]The distributed service layer includes a master module, a slave module and an app module. The master modul...

Embodiment 2

[0039]Referencefigure 1 withfigure 2As shown, this embodiment relates to a query method of a virtual database system, which includes the following steps:

[0040](1) End users submit SQL codes to realize business requests through the client layer;

[0041](2) The access layer receives the SQL code submitted by the client layer and submits it to the distributed service layer after user login authentication and permission verification;

[0042](3) The distributed service layer receives the request of the access layer, and extracts the SQL meta-information from the meta-database by parsing the SQL, and finds the actual physical database corresponding to the SQL;

[0043](4) The request is dispatched to the storage computing layer, and the actual execution of SQL is found on the physical database.

[0044]Preferably, the SQL code submission in step (1) can be done in one of the following ways:

[0045](1.1) Provide SQL code submission in the form of restful api;

[0046](1.2) Provide jdbc driver, use jdbc p...

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 virtual database system and a query method, and the system comprises a client layer which is used for submitting an SQL code to achieve a business demand, an access layer which receives and authenticates the SQL code, a distributed service layer which analyzes the SQL code, a storage layer calculation layer which executes an SQL code request, and a meta-database which isused for storing actual physical data. The client layer is connected with the access layer, the access layer is connected with the distributed service layer, and the distributed service layer is connected with the reservoir calculation layer and the meta-database. According to the invention, the bottom layer use of the physical database is shielded, the heterogeneous cross-database query and mixedcalculation can be carried out as long as the unified SQL is written, developers can concentrate on the business logic development, and various bottom layer use methods of the database do not need tobe concerned.

Description

Technical field[0001]The invention belongs to the technical field of virtual databases, and specifically relates to a pseudo-database system and a query method.Background technique[0002]Virtual database means that the details of the actual physical database can be shielded. Users only need to use a unified SQL language to realize cross-heterogeneous database query and mixed calculation. On the one hand, it can greatly reduce the difficulty of technology development. On the other hand, it can also provide basic support such as data services, data management, data tools, and data development, which can support a more agile and flexible data application architecture and logical data warehouse architecture.[0003]With the increasing application of big data technology in enterprises, and the emergence of more and more database systems to solve various different scenarios, rapid query calculation based on panoramic data has become an urgent need and challenge. The current mainstream method...

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 Applications(China)
IPC IPC(8): G06F16/25G06F16/27G06F21/31G06F16/2457H04L29/08
CPCG06F16/256G06F16/27G06F16/252G06F16/2457G06F21/31H04L67/02
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