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

Data processing method for realizing data base multitable inguiry

A multi-table query and data processing technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of high development cost and slow database multi-table query speed, saving development costs and improving efficiency. Effect

Inactive Publication Date: 2004-12-22
ZTE CORP
View PDF0 Cites 58 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to overcome the shortcomings of slow database multi-table query and high development cost in the prior art, and provide a data processing method for realizing database multi-table query. On the one hand, it can complete multi-table and Complicated database query, and can realize general query at the same time, that is, through configuration information, complex database query can be completed without writing a program

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
  • Data processing method for realizing data base multitable inguiry
  • Data processing method for realizing data base multitable inguiry
  • Data processing method for realizing data base multitable inguiry

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] Below in conjunction with the accompanying drawings, the implementation of the technical solution is described in further detail basically in the order of the accompanying drawings:

[0051] exist figure 1 In the present invention, the processing flow of configuring query parameters is disclosed. Among them, configuring query parameters includes steps to configure query information in five parts: general query information, data source information, subquery information, query element information, and query parameter information. The main configuration items and descriptions of each part of query information are as follows:

[0052] Step 11, configure the query total information, including:

[0053] Inquiry number One unique number per inquiry

[0054] Query Name A textual description of the query

[0055] Query result type There are two types of query result rows: fixed and non-fixed

[0056] template file name query output template file (optional)

[0057] Output 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 relates to a data processing method used for implementing a multilist inquiry of a database and used in a computer database inquiring and processing module, including: configuring the relative information to data inquiry, decomposing the data inquiry into many sub-inquiries; as inquiring database, first reading parameter information in the inquiry configuration information; reading the relative information to the inquiry from the configuration information; composing SQL sentences according to the inquiry sentences and the parameter information, connecting the databases the sub-inquiries are related to, then executing the SQL sentences; write the inquiry result in a corresponding memory data region in a form prescribed by a configuration file, and arranging data records according to key words; according to collected attributes of inquiry elements, generating a total record; writing the data column description information in an inquiry memory data region. On the other side, it can complete the multilist and complex database inquiries at a high speed and implement universal inquiries, i.e. it need not compose programs so as to complete complex database inquiry by configuring information.

Description

technical field [0001] The invention relates to a computer data processing method, in particular to a data processing method for realizing database multi-table query. Background technique [0002] In computer database query, it is very common that a query involves multiple tables, and the general solution is to associate multiple tables in a SQL (Structured Query Language) statement for query. In this method, when there are more associated tables and more data table records to be queried, the computer query processing speed will decrease several times or even dozens of times, and the data query time will reach ten minutes or even several hours. Generally, when the query data When there are many table records, the query speed of database data associated with two or three tables has dropped significantly. In addition, when the data query is very complicated, a single SQL statement is difficult to implement or a query involves multiple databases, or even different types of dat...

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 ZTE CORP
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