Supercharge Your Innovation With Domain-Expert AI Agents!

Display method for change situation of data table structure, and terminal

A display method and table structure technology, applied in the database field, can solve the problems of poor display effect and increase the storage pressure of the database, and achieve the effect of intuitive display.

Active Publication Date: 2018-07-06
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF12 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a method for displaying the change of the database table structure and its terminal, to solve the existing display technology of the change of the database table structure, it is necessary to obtain the code files corresponding to the two versions, and manually Collect the attribute parameters of each field in each data table to obtain the table structure that needs to be compared, and then compare the differences between the two table structures by switching between two pages. The display effect is poor, and the database needs to store the The code files of all versions of the data table also increase the storage pressure of the database

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
  • Display method for change situation of data table structure, and terminal
  • Display method for change situation of data table structure, and terminal
  • Display method for change situation of data table structure, and terminal

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0039] In order to make the objectives, technical solutions and advantages of the present invention clearer, the following further describes the present invention in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

[0040] The embodiment of the present invention records the current table structure when the preset collection trigger condition is met, and matches the table structure with the table structure obtained in the previous collection, so as to obtain the content of the difference between the two table structures, and obtain The table structure table is updated, and the table structure change record is stored in the change record library, so that the table structure can be restored to the corresponding version through the change record library in the future and the changes contained between the two ...

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 is suitable for the technical field of databases and provides a display method for a change situation of a database table structure, and a terminal. The method comprises the steps of obtaining a current table structure of a target data table in a database; matching the table structure with a reference table structure obtained at a previous collection moment by the target data table to generate a table structure change record; receiving a structure change query request; extracting a version comparison change record at a collection time in a change time interval from a change record library; and performing highlighted display on change contents comprised in the version comparison change record in a table structure preview page. The problems that the display effect is relativelypoor and the storage pressure of the database is increased because the database needs to store code files of all versions of the data table in an existing database table structure change situation display technology are solved.

Description

Technical field [0001] The invention belongs to the field of database technology, and in particular relates to a method and terminal for displaying data table structure changes. Background technique [0002] With the rapid development of informatization, more and more information is transformed from physical files into digital files, so the data contained in the database continues to increase, and the update speed of the data tables contained in the database is also getting faster. When troubleshooting or updating a data table, it is often necessary to display the table structure of the target data table in the database so that the user can obtain the attribute parameters corresponding to each field in the data table according to the table structure, so as to specify the corresponding change strategy. [0003] However, the existing display technology of data table structure changes requires obtaining the code files corresponding to the two versions, and manually collecting the attr...

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/248
Inventor 巫绍堂
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More