Unlock instant, AI-driven research and patent intelligence for your innovation.

Database query and control method

A database and receptor technology, applied in database query, electronic digital data processing, structured data retrieval, etc., can solve problems such as inability to describe multi-dimensional databases, affecting performance and speed, and affecting query speed.

Active Publication Date: 2013-09-25
GUANGZHOU CCM INFORMATION SCI & TECH
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] (1) The traditional RTN only provides sentence descriptions for the decision graph network of the attribute dimension (X dimension) with individual association as the level and the juxtaposed individual dimension (Y dimension) distinguished by individual types in the traditional two-dimensional database. There are associated dimensions (Z dimension) and time dimension (W dimension) between entities in the database, so the traditional RTN method has no way to describe the multidimensional database
[0006] (2) The traditional RTN method can only query the results of "something happened to an individual at a certain time", "remarks"
Performing these operations instead affects performance and speed
[0008] (4) As mentioned in question (3), RTN uses simple and accurate descriptions of various difficulty levels through query statements, and establishes an optimal access plan. RTN needs to analyze the data structure, if the related tables or related keywords are compared For a long time (there are many tables related to the query statement), the analysis time will take a long time, which will affect the query speed

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 query and control method
  • Database query and control method
  • Database query and control method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach

[0067] Since the state table itself is also associated with the entity table, the acceptor in the state table of adding or modifying subject A is similar to the reverse identification step of the entity table, and the identification and reverse identification should also be carried out in the entity table . The difference is that the state table has one more time dimension than the entity table, and the system automatically associates the time of the recipient's state table. In addition, because the state association in the state table is more complicated than the association between entities, in addition to identifying the entity in the reverse identification of the state table, it is necessary to initially define and match the state in the state table to solve the complex state association mode and time dimension. The specific implementation method is as follows:

[0068] In the design, a state storage module is established for the state dimension (X dimension) in the stat...

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 present invention discloses a method for querying and controlling a database, particularly, a method for identifying and anti-identifying in the database, and a method for querying an association model in the database in a recursion manner. The present invention further discloses a method for displaying the query result obtained through the query method.

Description

technical field [0001] The present invention generally relates to a database query and control method, in particular to a method for marking and reverse marking in the database and a method for recursively querying the associated model in the database. Background technique [0002] Traditional Recursive Query Techniques [0003] The current database technology has a lot of technical methods for querying and controlling two-dimensional databases. The traditional two-dimensional database RTN (Recursive transient network, recursive transient network) query and control method is: pre-set for two-dimensional database A given decision graph recursively processes keywords and is described by the total run of self-nesting and self-joining of the entire decision graph, while making a limited selection of keywords after each keyword. [0004] The above method is the method adopted for the traditional two-dimensional database, but if it is aimed at the query and control of the relatio...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/24
Inventor 吴忠辉
Owner GUANGZHOU CCM INFORMATION SCI & TECH