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

Generation method of wide table in structured query language database and device thereof

A structured query and database technology, which is used in electrical digital data processing, special data processing applications, instruments, etc., and can solve problems such as low query performance and inability to improve query performance.

Active Publication Date: 2018-06-29
亿度慧达教育科技(北京)有限公司
View PDF7 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, the performance of the current structured query language database for the associated query of multiple tables is much lower than that of the query for a single table
In order to improve the above problems, the view technology currently supported by structured query language databases can generate views of multiple associated tables for users through customized structured query language statements, but it is still essentially an associated query for multiple tables , does not improve query performance

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
  • Generation method of wide table in structured query language database and device thereof
  • Generation method of wide table in structured query language database and device thereof
  • Generation method of wide table in structured query language database and device thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0063] The embodiment of the present application obtains the log file of the structured query language database, and obtains its change data through the log file. Therefore, according to the change data, the association relationship of the association table corresponding to the log file and the operation to be performed on the data are obtained, a data conversion operation is performed, and the converted data is loaded into the wide table of the target database. Therefore, this application monitors the log files of the structured query language database to obtain the change content of the table data in the structured query language database, and synchronizes the data of multiple related tables in the structured query language database into a wide table in real time, thereby Improve the query performance of the program and simplify the query operation.

[0064] While the present application is capable of embodiments in many different forms, certain embodiments have been shown i...

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 embodiment of the invention provides a generation method of a wide table in a structured query language database and a device thereof. The method comprises the steps that a log file of the structured query language database is obtained, and the changed data in the structured query language database is obtained through the log file; the correlation relationship of a correlation table corresponding to the log file and the to-be-executed operation of the data is obtained according to the changed data, and data conversion operation is executed; the converted data after the data conversion operation is competed is received, and the converted data is loaded into the wide table of the target database. By means of the method, the query performance of the structured query language database canbe improved.

Description

technical field [0001] The application belongs to the technical field of structured query language, and in particular relates to a method and device for generating wide tables in a structured query language database. Background technique [0002] Structured Query Language (Structured Query Language), referred to as SQL, is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems; it is also a database script file extension. [0003] Structured Query Language is a high-level non-procedural programming language that allows users to work on high-level data structures. It does not require the user to specify the data storage method, nor does it require the user to understand the specific data storage method, so different database systems with completely different underlying structures can use the same structured query language as the interface for data input and management. S...

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/2282G06F16/2358G06F16/2433G06F16/24542
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