CN101901269B - Real-time library foreign key reference display method - Google Patents

Abstract

The present invention discloses a real-time database foreign key reference display method, which is characterized by comprising the following steps: 1) providing a "reference display" attribute for each table and each domain in the real-time database, and selecting "yes" or "no" for the "reference display" attribute of each domain; 2) providing an interface to convert a numerical keyword into a string description information of a corresponding record: taking out the values of all "reference display domains" of the record according to a given keyword and composing them into a string; 3) the foreign key data automatically calls the above interface to display the string description information on the real-time database human-computer interface. Using the method of the present invention, users can select which domains need to be referenced and displayed according to domains with different functions in different tables, and the foreign key domain is displayed as a description string when displayed, which is convenient for users to maintain and search.

Description

Real-time library foreign key reference display method

technical field

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

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 database, which will bring difficulties to subsequent maintenance and even cause description mismatches Case.

Contents of the invention

In order to solve the deficiencies of the existing methods, the purpose of the present invention is to provide a method that forms and displays a descriptive information of the keyword according to the content of each field recorded by the numerical keyword, so as to improve its intuitiveness and readability. sex.

In order to solve the above technical problems, the present invention provides a method for displaying real-time database foreign key references, which is characterized in that it includes the following steps:

1) For each field in each table in the real-time database, provide an attribute of "whether to quote and display", and select "yes" or "no" for the "whether to quote and display" attribute of each field;

2) Provide an interface to convert numerical keywords into string description information of the corresponding record: take out all the values of the "reference display field" of the record according to the given keyword and form a string;

3) The foreign key data automatically invokes the above interface, and displays the string description information on the real-time library man-machine interface.

The aforementioned real-time library foreign key reference display method is characterized in that: in the step 2), the interface input parameter is a numerical keyword, that is, a primary key ID or a foreign key ID, and the output parameter is a description string.

The aforementioned real-time library foreign key reference display method is characterized in that: the interface includes multiple overloaded forms:

A single keyword takes a single description string;

Multiple keywords take multiple description strings;

Get the description string from the local real-time library;

Get the description string from the specified network real-time library.

The beneficial effect that the present invention reaches:

1. The user can select which fields need to be referenced and displayed according to the fields with different functions in different tables; 2. The foreign key field is displayed as a description string when displayed, which is convenient for users to maintain and search; 3. The foreign key field is still stored as a numeric value storage, saving memory space; 4. Provide a variety of overloaded interfaces, suitable for various application needs; 5. High portability, suitable for various operating system platforms.

Description of drawings

Figure 1 shows the process of splicing description strings according to the reference display domain;

Figure 2 shows the process flow of the reference display interface.

Detailed ways

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

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 fields".

Assuming that there is a region table in the real-time library, the structure is as follows:

Region ID (primary key), first-level region name (reference display), region type, second-level region name (reference display), ...

The contents of the table are as follows:

Region ID First-level area name Region Type Secondary area name … 201000001 East China 1 Jiangsu … 201000002 East China 1 Zhejiang …

Then given the keyword 201000001, the process of splicing the description string according to the reference display domain is shown in Figure 1, and the resulting description string is:

East China Jiangsu

The present invention provides a type of interface to convert numerical keywords into descriptive information of corresponding records according to the pre-determined "reference display field". The input parameter of this type of interface is a numeric keyword, and the output parameter is a description string. There are multiple overloaded forms. It supports a single keyword to take a single description string, and also supports multiple keywords to take multiple description strings; support Get the description string from the local real-time library, and also support getting the description string from the specified network real-time library. When the interface is working, all the values of the "reference display field" of the record are taken out according to the given keyword and combined into a string.

When the real-time library human-machine interface using this mechanism displays data, the foreign key data will automatically call the above interface, and the description string will be displayed on the interface.

The real-time library foreign key reference display mechanism involved in the present invention is realized on the self-developed real-time library of the application layer in combination with work, does not depend on specific operating systems, and is applicable to various operating systems. The real-time library foreign key reference display mechanism of the present invention guarantees portability, and can run safely and stably on operating system platforms such as IBM AIX, Sun Solaris, Alpha Tru64, HPUX, Linux, and Windows along with the real-time library system; system programming The language adopts ANSI C/C++ and complies with IEEE POSIX.2 standard.

The above embodiments do not limit the present invention in any form, and all technical solutions obtained by means of equivalent replacement or equivalent transformation fall within the protection scope of the present invention.

Claims (3)

1. A method for displaying real-time library foreign key references, comprising the following steps: 1) For each field in each table in the real-time database, provide an attribute of "whether to quote and display", and select "yes" or "no" for the "whether to quote and display" attribute of each field; 2) Provide an interface to convert numerical keywords into string description information of the corresponding record: take out all the values of the "reference display field" of the record according to the given keyword and form a string; 3) The above interface is automatically invoked for the foreign key data, and the string description information is displayed on the real-time library man-machine interface. 2. The real-time library foreign key reference display method according to claim 1, characterized in that: in said step 2), said interface input parameter is a numerical keyword, i.e. primary key ID or foreign key ID, and output parameter is the description string. 3. The real-time library foreign key reference display method according to claim 2, characterized in that: the interface includes multiple overloaded forms: A single keyword takes a single description string; Multiple keywords take multiple description strings.

Images