Method and device for adjusting datasheet connection

A data table and database technology, applied in the database field, can solve problems such as inappropriate connection sequence and low execution efficiency of database statements, and achieve the effect of improving execution efficiency

Active Publication Date: 2017-07-07
BEIJING GRIDSUM TECH CO LTD
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The embodiment of the present invention provides a method and device for adjusting the connection of data tables, so as to at least solve the technical problem of low execution efficiency of database statements caused by improper connection sequence of data tables in the database during the execution of database statements

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
  • Method and device for adjusting datasheet connection
  • Method and device for adjusting datasheet connection
  • Method and device for adjusting datasheet connection

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] According to an embodiment of the present invention, an embodiment of a method for adjusting data table connections is provided. It should be noted that the steps shown in the flowcharts of the drawings can be executed in a computer system such as a set of computer-executable instructions, and , although a logical order is shown in the flowcharts, in some cases the steps shown or described may be performed in an order different from that shown or described herein.

[0027] figure 1 is a flow chart of a method for adjusting data table connections according to an embodiment of the present invention, such as figure 1 As shown, the method includes the following steps:

[0028] Step S102, generating a database statement corresponding to the database command according to the preset database command.

[0029] Specifically, in the above step S102, the preset database instruction may be to search for data that meets a certain condition or multiple conditions, and the database ...

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 method and a device for adjusting datasheet connection. The method comprises the steps of generating a database statement corresponding to a database instruction according to a preset database instruction; acquiring a set of datasheets with association relation from a target database, wherein any datasheet in the set of the datasheets with association relation includes one or more pieces of information employed in the database statement; analyzing a tree structure of the database statement through a database statement analysis tool to acquire the size information of each datasheet in the set of the datasheets with association relation; and adjusting a position of each datasheet in the tree structure according to the acquired size information of each datasheet in the set of the datasheets with association relation, and adjusting the connection relation of the datasheets. The method and the device solve the technical problem of low execution efficiency of the database statement caused by improper connection sequences of the datasheets in the database in an execution process of the database statement.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and device for adjusting data table connections. Background technique [0002] In the environment of On-Line Analytical Processing (OLAP for short), currently commonly used query engines include structured databases with metadata such as Hive and Impala. In these databases, generally, data of various events are recorded in respective fact data tables. For example, in the "Teaching Management System", the teaching management database contains the following fact tables: "Teacher" table, "Course" table, "Grade" table, "Student" table, "Class" table and "Teaching" table etc. Through the above fact table, the information of students, teachers, courses, etc. in the teaching process can be managed. When users need to associate data from multiple angles and across multiple data tables to find index data, the connection order of the tables will have a great impact on the speed of searc...

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
CPCG06F16/2456G06F16/282
Inventor 洪超
Owner BEIJING GRIDSUM 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