Database operation method and device

An operation method and database technology, which are applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of difficult SQL editing and query requests, difficult to expand, and difficult to maintain Presto, so as to simplify the data query process and improve the speed. , the effect of easy maintenance

Active Publication Date: 2016-02-17
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When Presto configures the MySQL data source, only one connection address can be configured. If you want to combine all the sub-tables for query and calculation in the sub-database and sub-table mode, Presto can only configure all the MySQL sub-tables as Presto’s MySQL. However, when there are many tables in this way, thousands of MySQL data sources need to be defined. When querying the database, it is difficult to use SQL to edit query requests, and it is not easy to expand. At the same time, Presto Difficult to maintain

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 operation method and device
  • Database operation method and device
  • Database operation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] figure 2 It is a flowchart of a database operation method provided in Embodiment 1 of the present invention. This embodiment is applicable to sub-database and sub-table of big data, and the method can be executed by a database operating device, which is configured in a management node and can be realized by means of hardware and / or software. The device specifically includes the following steps:

[0027] Step 110, the management node acquires a database operation request, and extracts virtual data information from the operation request;

[0028] Database operation requests generally include but are not limited to creating tables, deleting tables, querying, and changing table names. In this embodiment, the database operation is a database query, and correspondingly, the database operation request is a database query request. When users query the database, they first need to submit a query request on the client side. The query request is written in SQL and can be edite...

Embodiment 2

[0045] Figure 4 It is a flowchart of a database operation method provided in Embodiment 2 of the present invention. This embodiment is optimized based on the above embodiments. In this embodiment, after the management node determines one or more actual data addresses corresponding to the virtual data information according to the mapping rules, a step is added: the The management determines the access port, user name and user password corresponding to the virtual data information according to the mapping rule. Correspondingly, the generating the database operation task by the management node according to the actual data address includes: generating the database operation task by the management node according to the actual data address, access port, user name and user password.

[0046] Correspondingly, the method of this embodiment includes the following steps:

[0047] S210. The management node acquires a database operation request, and extracts virtual data information fro...

Embodiment 3

[0055] Figure 5 It is a flowchart of a database operation method provided in Embodiment 3 of the present invention. This embodiment is optimized based on the above embodiments. In this embodiment, after the management node determines one or more actual data addresses corresponding to the virtual data information according to the mapping rules, a step is added: the The management node determines the identifier of the computing node corresponding to the virtual data information according to the mapping rule. Correspondingly, the management node dispatching the database operation task to the computing node for processing includes: the management node dispatching the database operation task to the corresponding computing node for processing according to the computing node identifier.

[0056] Correspondingly, the method of this embodiment includes the following steps:

[0057] S310. The management node acquires a database operation request, and extracts virtual data information...

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 operation method and device; the method comprises the following steps: a manage node obtains a database operation request, and extracts virtual data information from the operation request; the manage node determines one or more real data addresses matched with the virtual data information according to mapping rules; the manage node generates a database operation task according to the real data address; the manage node calls the database operation task to a calculating node for processing. The self-defined virtual data information is matched with the real data address in the mapping rules; when a user use a check engine to query the database according to the virtual data information, a corresponding database table can be automatically connected, thus conveniently maintaining the search engine, simplifying a data query process, and improving data query speed.

Description

technical field [0001] Embodiments of the present invention relate to the field of big data distributed computing, and in particular to a method and device for operating a database. Background technique [0002] MySQL is an open source relational database, which has the characteristics of small size, high speed and low cost, and occupies an important position in database applications. [0003] Presto is a big data distributed query engine. To configure a MySQL data source, you need to provide a java database connection (JavaDataBaseConnectivity, JDBC) connection string, connection user name and connection password. Among them, only one JDBC connection information can be defined, that is, It is said that each data source can only connect to one MySQL database. figure 1 It is a schematic diagram of the process of connecting to a MySQL data source through Presto in the prior art. Such as figure 1 As shown, the management node receives a query request from the client, and the...

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): G06F17/30
Inventor 郭李明
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
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