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

Real-time library foreign key reference and display method

A display method and real-time library technology, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of increased data redundancy, difficult maintenance, poor readability, etc., to save memory space, can The effect of high portability, easy maintenance and search

Active Publication Date: 2012-05-23
NARI TECH CO LTD +1
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But this brings a problem, the foreign key field of the record is a number in the memory storage, which is poor readability
If the description information describing the foreign key is also added to the table, this will not only increase data redundancy, but also fail to meet the requirements of the second normal form of the database, which will bring difficulties to subsequent maintenance and even cause mismatching descriptions Case

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
  • Real-time library foreign key reference and display method
  • Real-time library foreign key reference and display method
  • Real-time library foreign key reference and display method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0019] The present invention firstly provides an attribute of "whether reference display" for each field of each table. For each table in the real-time library, in addition to the key field, there must be multiple non-key fields. Some of these fields are description fields such as Chinese names and English names, and some are foreign key fields such as the region and type. , and some are value domains such as actual value, maximum value, and minimum value. Users can select some fields that can describe the general content of the record from these fields in advance, and select "Yes" for the "whether reference display" attribute of these fields, which means that given a keyword in the table, it will Get the description information of this record according to the values ​​of these "reference display domains".

[0020] Assuming that there is a region table in t...

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 real-time library foreign key reference and display method, which is characterized by comprising the following steps: 1) providing an attribute of whether to carry out reference and display or not for each domain of each table in a real-time database, and selecting yes or no for the attribute of whether to carry out the reference and the display or not of each domain; 2)providing an interface for converting numeric type keywords to character string description information of a corresponding record: taking out all values in the reference and display domain of the record according to the given keywords and splicing into a character string; and 3) leading foreign key data to automatically call the interface and displaying the character string description information on a man-machine interface of the real-time library. The utilization of the method can lead a user to select which domains need to carry out the reference and the display according to different roles of different tables, and a foreign key domain is displayed as the description character string during the display, thereby facilitating the maintenance and the finding of the user.

Description

technical field [0001] The invention relates to a method for converting numerical keywords or foreign keys in a real-time database into character strings according to part of the field values ​​of corresponding records, and belongs to the technical application field of real-time databases. Background technique [0002] Foreign key is an indispensable domain attribute in relational real-time database, which can be used to describe the hierarchical relationship between different tables. The real-time library usually runs in the memory environment, and the keywords are usually integer values ​​or long integer values, which can save memory space. But doing so brings a problem. The foreign key field of the record is a number in memory storage, which is poor in readability. If the description information describing the foreign key is also added to the table, this will not only increase data redundancy, but also fail to meet the requirements of the second normal form of the databa...

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
Inventor 王瑾侯勇彭晖孙云枫刘孟觉杨志宏
Owner NARI TECH CO LTD