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

Backtracking data query method and system based on relational database

A data query and database technology, applied in the field of retrospective data query methods and systems based on relational databases, can solve problems such as increased program complexity, and achieve the effects of simple development, easy maintenance, and high readability

Active Publication Date: 2020-07-28
谭凌
View PDF9 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the query involves multiple original data tables, the complexity of the program will further increase

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
  • Backtracking data query method and system based on relational database
  • Backtracking data query method and system based on relational database
  • Backtracking data query method and system based on relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049] The technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present invention.

[0050] Please refer to figure 1 with figure 2 A preferred embodiment of the present invention provides a method for querying backtracking data based on a relational database, including:

[0051] S1. In the data table that the database needs to support backtracking query, two additional "date and time" type fields are added to represent the "start time" and "end time" of a tuple. At the same time, a special value is defined to represent th...

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 backtracking data query method based on a relational database. A program developer of the business logic does not need to support the requirement of backtracking query when developing and writing a business program; a large number of additional service codes are added or modified; for example, when the backtracking query does not need to be supported, only the tuple statement needs to be updated once in the code. Under the condition that backtracking query is supported when the method is used, tuple statements only need to be updated in program codes once in a similarmode, no extra service logic occurs, and therefore the codes are easy to maintain, high in readability and simpler to develop; extra conversion, execution and other work generated by supporting' backtracking query 'are automatically completed by the method and a system provided by the invention, and a large number of business logic codes do not need to be changed.

Description

Technical field [0001] The present invention relates to the technical field of data processing, in particular to a method and system for querying backtracking data based on a relational database. Background technique [0002] When developing data information systems, relational databases (such as MySQL, SQL Server, etc.) are almost always used. Relational databases store the current latest data status, and the data status at the past time cannot be queried. In many cases, it is necessary to retrospectively query the past data status. At present, the existing technology is to separately create a log table of certain fields in the database. When the data is updated, it is necessary to update the main table used by the business logic, and send the corresponding field Insert a record in the log table to record that a certain field is updated from a certain value to a certain value at a certain time. When a retrospective query is required, first query the main table, and at the same ...

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): G06F16/2458G06F16/22G06F16/23G06F16/2455G06F16/28
CPCG06F16/2474G06F16/22G06F16/2358G06F16/2379G06F16/2456G06F16/284Y02D10/00
Inventor 谭凌
Owner 谭凌