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

Massive distributed relational database-oriented cursor creation method

A distributed and database technology, applied in relational databases, database models, database distribution/replication, etc., can solve the problems of inability to support cursors, lack of cursors, etc., and achieve the effect of excellent query performance and fast query speed

Active Publication Date: 2015-04-08
广东绵亘科技发展有限公司
View PDF3 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, at present, the syntax tree, logical plan, and physical plan in Oceanbase lack the construction of cursor functions, which makes it unable to support cursors. Cursors are commonly used functions in financial applications, providing batch processing of data sets, especially in large-scale banks. Data sets are widely used in business, which is a very big limitation for the traditional financial industry

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
  • Massive distributed relational database-oriented cursor creation method
  • Massive distributed relational database-oriented cursor creation method
  • Massive distributed relational database-oriented cursor creation method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] refer to Figure 1-4 . The specific steps of the cursor construction method of the present invention facing massive distributed relational databases are as follows:

[0077] For the following cursor Declare statement SQL:

[0078] Declare Cursor cs1 for select c1,c2 from test;

[0079] Cursors can be implemented in the following steps.

[0080] 1) Construct a syntax tree: construct a syntax tree of the Declare keyword. The construction process is as follows:

[0081] 1. Input: Declare keyword

[0082] 2. Generate the root node (Declare) node;

[0083] 3. Generate a child node children_[0] to store the cursor definition name cs1;

[0084] 4. Because (cursor keyword type = Declare)

[0085] {Generate child nodes children_[1];

[0086] children_[1] = (select) node;}

[0087] 5. The syntax tree is generated

[0088] 2) Construct a logical plan: construct a logical plan for the cursor Declare. The construction process is as follows:

...

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 massive distributed relational database-oriented cursor creation method which is used for solving the technical problem of cursor function structure deficiency of SQL (Structured Query Language) process flow in an existing OceanBase. According to the technical scheme, a complete cursorcreation method is designed based on a massive distributed relational database structure according to SQL92 standard syntax, unified syntax tree, logic plan and physical plan are created according to a common key word of a cursor, and anSQL execution process of a cursor is designed. The method can finishthe cursor function of the distributed database and has relatively good query performance during mass data query; compared with the cursor execution performance of a commercial database DB2 in one million data sets, the query speed of the cursor created by the method is higher than that of the DB2 by about 70 times.

Description

technical field [0001] The invention relates to a cursor construction method, in particular to a cursor construction method for massive distributed relational databases. Background technique [0002] The document "OceanBase. Massive Structured Data Storage Management System. Yang Zhenkun, Yang Chuanhui, Li Zhen. Scientific Research Information Technology and Application, 2013, 4(1):41–48" discloses a combination of NOSQL database architecture and relational database The characteristic new database architecture - OceanBase, not only supports the strong consistency of transactions across rows and tables, but also supports the scalability of data nodes. The database is an open source distributed database based on the MySQL database. It supports the general SQL query language. By performing lexical analysis, syntax analysis, logical plan generation and physical plan generation on the input SQL statement, the data is divided into static Data and dynamic data, providing real-time...

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
CPCG06F16/27G06F16/284
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