CN110851420B - Method for dynamically configuring data of general database model - Google Patents
Method for dynamically configuring data of general database model Download PDFInfo
- Publication number
- CN110851420B CN110851420B CN201911054555.3A CN201911054555A CN110851420B CN 110851420 B CN110851420 B CN 110851420B CN 201911054555 A CN201911054555 A CN 201911054555A CN 110851420 B CN110851420 B CN 110851420B
- Authority
- CN
- China
- Prior art keywords
- field
- general
- column
- editing
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method for dynamically configuring data of a database general model, which designs a general data configuration model for constructing a general dynamic table to configure and manage a metadata dictionary, general model data and parameter data; and configuring a dynamic interface part and a general table dynamic function part of the management software based on the general data configuration model. Compared with the prior art, the invention solves the problems of static interface, incapability of grouping modules and incapability of dynamically displaying in the prior art.
Description
Technical Field
The invention relates to a large-scale real-time comprehensive monitoring system for rail transit, in particular to a method for dynamically configuring data of a general database model.
Background
The comprehensive monitoring system has wide application in various fields, in particular to a rail transit comprehensive monitoring system. Such systems typically have numerous devices that require real-time monitoring of the status. Configuring data in the face of numerous devices often requires an efficient way to configure management data.
Many device data are initially aggregated in excel. Although data can be stored in a database using conventional database management tools, it is obviously inconvenient to modify the database. Many tools are available for a single type of database operation.
Meanwhile, it is difficult for a viewer to clearly see the original metadata dictionary for the result of data display. This often requires that the data configuration administrator not only have professional basic knowledge of the data, but also need to query the metadata dictionary from time to time, and after all, it is not easy for the data configuration administrator to remember the metadata dictionary completely.
Moreover, no special expertise is required at the data configuration administrator, but the configuration data efficiency requirements must be high. The conventional data configuration method is certainly difficult to apply, and a universal data model is urgently needed to be designed to customize a dynamic table to configure and manage the data.
Disclosure of Invention
The present invention is directed to a method for dynamically configuring data of a universal database model, which overcomes the above-mentioned drawbacks of the prior art.
The purpose of the invention can be realized by the following technical scheme:
a method for dynamically configuring data of a database universal model designs a universal data configuration model for constructing a universal dynamic table to configure and manage a metadata dictionary, universal model data and parameter data; and configuring a dynamic interface part and a general table dynamic function part of the management software based on the general data configuration model.
Preferably, the key tables of the general data configuration model include parameter library table rules, parameter library column rules, parameter library table dictionaries and number library column dictionaries.
Preferably, each of the key tables has an essential field, which is specifically defined as follows:
1) the general model definition field of the parameter library table rule comprises fields of a table name, a table type, an identification record domain name, a classification retrieval, a retrieval domain name, a retrieved table name, a retrieved domain parent domain name, a display domain name, a secondary retrieval retrieved table name, a secondary retrieval display domain name, a tertiary retrieval retrieved table name and a tertiary retrieval display domain name;
2) the general model definition field of the parameter setting library column rule should have fields of field description, the table name, data type, data length, decimal number, editing mode, data adding principle, initialized data type, initialized data source, retrieval field name, information field name, whether a selection field exists or not, selection field name, initial value of the selection field, termination value of the selection field, association type, association field name, threshold value, display attribute, foreground color, background color, font name, font size, font form, column width, column group name, whether a fixed column exists or not, display attribute of the fixed column, background color of the fixed column, foreground color of the fixed column and the fixed column width;
3) the general model definition field of the parameter library table dictionary has fields of table codes, table descriptions, table types and table spaces;
4) the general model definition field of the parameter library column dictionary comprises fields of field index, field code, field description, table code, field type, field length and display type.
Preferably, the dynamic interface part of the software for configuration management based on the generic data configuration model includes the following contents:
1) generating a general dynamic grouping module of configuration management software, wherein an interface of the general dynamic grouping module dynamically displays some grouping table modules or dynamically encrypts and accesses the displayed grouping table according to a general data configuration model;
2) generating a tree structure of a table list of a universal dynamic grouping module of configuration management software, wherein the tree structure of the table list of the universal dynamic grouping module comprises list contents of trees and grouping hierarchical contents of the trees;
3) generating a management interface for configuring a field list of a management software universal dynamic grouping module, wherein the management interface for the field list of the universal dynamic grouping module comprises the field list content of a table and the modification of any field description in the field list of the table;
4) and generating a management interface for configuring the data content of the management software general dynamic grouping module, wherein the management interface for the data content of the general dynamic grouping module is a management interface in a tab mode or an interface in a multi-form mode.
Preferably, the dynamic functions of the universal table comprise selectable functions, and the functions are freely configurable and selectable according to the universal data configuration model.
Preferably, the optional functions include:
generating a visual editing mode of the generic dynamic form, the visual editing mode providing various editing agent controls,
generating a column dynamic grouping of a dynamic table, the column dynamic grouping constraining a group name and a group column list according to configuration model data;
and generating a frozen column mode of the dynamic table, and constraining the frozen column items through the general configuration model data.
Preferably, the proxy control includes:
1) the read-only proxy control is used for configuring a general data model of an editing field into field content of a read-only editing mode, and the column can not be edited in a general dynamic table;
2) the text editing agent control is used for configuring a general data model of an editing field into field content of a read-only editing mode, and displaying that the column is edited in a text editing box mode in a general dynamic table;
3) the single-choice editing proxy control is used for configuring a general data model of an editing field into field content of a single-choice editing mode, and displaying that the column is edited in a single-choice selection frame mode in a general dynamic table;
4) the check editing agent control is used for configuring a general data model of an editing field into field contents of a check editing mode, and displaying that the column is edited in a mode of a multi-item selection box in a general dynamic table;
5) the password editing agent control is used for configuring a general data model of an editing field into the field content of a password editing mode, and displaying that the column is edited in a mode of a password editing frame in a general dynamic table;
6) the expression editing proxy control is used for configuring a general data model of an editing field into the field content of an expression editing mode, and displaying that the column is edited in a mode of an expression dialog box in a general dynamic table;
7) the date editing agent control is used for configuring a general data model of an editing field into the field content of a date editing mode, and displaying that the column is edited in a date editing frame mode in a general dynamic table;
8) the time editing agent control is used for configuring a general data model of an editing field into field content of a time editing mode, and displaying that the column is edited in a time editing frame mode in a general dynamic table;
9) the color editing agent control is used for editing the field content of the field configured by the general data model of the field as the color editing mode, displaying that the column has various colors in a selective pull-down frame in a general dynamic table, and marking the column as a selection item of the color and the color name so as to be freely selected by a data configuration manager;
10) the point code editing proxy control is used for configuring a general data model for editing fields into field contents of a point code editing mode, and displaying that the column is edited in a point code dialog box mode in a general dynamic table;
11) the editing system comprises an editable single-choice agent control, a general data model for editing fields is configured to be the field content of an editable single-choice editing mode, the column is displayed in a general dynamic table as an option with fuzzy matching of input content, and the option can appear in a pop-up drop-down box and can be freely selected by a data configuration manager;
12) the general data model used for editing the fields is configured to logically select the field contents of the editing mode, and the columns are displayed in a general dynamic table to be edited in a checkable check box mode.
Preferably, the dynamic functions of the general form further include a mandatory option function, which is an auxiliary function for facilitating clear display of an interface or facilitating editing of configuration data.
Preferably, the mandatory option function includes:
the general table has odd lines and even lines with different background colors;
the universal table supports the function of a shortcut key;
the general table has a row adding function, and the row adding comprises adding a single row of records and adding a plurality of rows of records;
the universal table has a copy, copy and add line function and supports an auxiliary key to select a plurality of lines for recording copy, copy and add lines;
the general table has a row deleting function and supports the auxiliary keys to select a plurality of rows of record deleting rows;
the universal table has a copy same column filling function, any cell is selected, copy same column filling is selected, and then the current column is completely filled with the content in the current cell;
the general table has a copy first-choice filling function, any cell is selected, copy first-choice filling is selected, and all the cells behind the current cell in the current column are filled as the content in the current cell;
the general table has an increasing and same-column filling function, any cell is selected, increasing and same-column filling is selected, and then all current columns are filled, and on the basis of the last digit in the current cell, contents are filled, sequentially increased and formatted;
the general table has an increasing preferred filling function, any cell is selected, increasing preferred filling is selected, and then all filling after the current cell in the current column is performed, and filling is sequentially increased and formatted on the basis of the last number in the current cell;
the general table has a copy selection row function;
the general table has a function of pasting the selection line, and the pasting selection line and the copying selection line operate basically simultaneously;
the general table has a cross-table copy row function,
the universal table has a cross-table paste line function, the paste select line and the cross-table copy line operate substantially simultaneously.
Compared with the prior art, the invention has the following advantages:
1. the invention designs a general configuration model and a general configuration management tool generated according to the model, which are used for editing configuration parameter database data, and solves the problems that the interface is static, the modules can not be grouped and can not be dynamically displayed in the prior art;
2. the invention defines a general configuration model, generates a general dynamic table according to the model, is used for grouping fields of a multi-field table, enriches the operation function, freezes the column display, dynamically customizes the column attribute and the like, and solves the problems of rigid interface, inflexible operation and the like of the table in a configuration management tool in the prior art;
3. the invention defines a general configuration model, generates a plurality of agent editing mode controls according to the model, is used for editing unit data of a general dynamic table, and greatly improves configuration data of a configuration manager;
4. the present invention is not only applicable to currently supporting multiple database types, such as: oracle, MySQL, greenplus, SQLite3, etc., and allows parameter libraries and generic libraries not to be deployed on the same type of database server.
Drawings
FIG. 1 is a diagram of a generic library and a parameter library in the same database;
FIG. 2 is a diagram of a generic library and a parameter library in different databases;
FIG. 3 is a schematic diagram of a dynamic portion of a generic matching model;
FIG. 4 is a diagram of a portion of a generic table dynamic;
FIG. 5 is a diagram illustrating a dynamic configuration editing mode of a common table;
FIG. 6 is a diagram of database configuration management software.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, shall fall within the scope of protection of the present invention.
The invention relates to a large-scale real-time comprehensive monitoring system for rail transit, in particular to a distributed real-time system for the rail transit comprehensive monitoring system. The technology provides a universal data configuration model, and a universal dynamic table is constructed to configure and manage a metadata dictionary, universal model data and parameter data.
The invention designs a general data configuration model which is used for a dynamic interface part and a general form dynamic function part of configuration management software based on the technology. The key tables of the general data configuration model comprise parameter database table rules, parameter database column rules, parameter database table dictionaries and number database column dictionaries. Each key table has the requisite fields, which are specifically defined as follows:
1) the general model definition fields of the parameter library table rule should have fields such as a table name, a table type, an identification record field name, a classification retrieval, a retrieval field name, a retrieved table name, a retrieved field parent field name, a display field name, a secondary retrieval domain name, a secondary retrieval retrieved table name, a secondary retrieval retrieved field name, a secondary retrieval display field name, a tertiary retrieval retrieved table name, a tertiary retrieval retrieved field name, a tertiary retrieval displayed field name and the like.
2) The general model definition field of the parameter setting library column rule should have fields such as field description, the table name, data type, data length, decimal number, editing mode, data adding principle, initialized data type, initialized data source, retrieval field name, information field name, presence or absence of a selection field, selection field name, initial value of a selection field, termination value of a selection field, association type, association field name, threshold value, display attribute, foreground color, background color, font name, font size, font form, column width, column group name, presence or absence of a fixed column, display attribute of a fixed column, background color of a fixed column, foreground color of a fixed column, width of a fixed column and the like.
3) The general model definition field of the parameter table dictionary should have fields such as table code, table description, table type, table space, etc.
4) The general model definition field of the parameter library column dictionary comprises fields such as field index, field code, field description, table code, field type, field length and display type.
According to the general data configuration model, the dynamic interface part of the configuration management software based on the technology comprises the following contents:
1) and generating a configuration management software general dynamic grouping module. The universal dynamic grouping module interface can dynamically display some grouping table modules according to a configuration model or dynamically encrypt and access the displayed grouping table.
2) And generating a tree structure of a table list of the universal dynamic grouping module of the configuration management software. The tree structure of the table list of the general dynamic grouping module not only comprises the list content of the tree, but also comprises the grouping hierarchical content of the tree. Table code and classification field code translations in the module tree.
3) And generating a management interface for configuring a field list of the universal dynamic grouping module of the management software. The management interface of the field list of the general dynamic grouping module not only comprises the field list content (comprising field names, data types, constraints and the like) of the table, but also comprises the modification of any field description in the field list of the table.
4) And generating a management interface for configuring the data content of the management software universal dynamic grouping module. The management interface of the data content of the general dynamic grouping module can be a management interface of a tab mode; or may be a multi-frame mode interface.
The generic table dynamic functionality of the configuration management software based on this technique is many optional functions according to the generic data configuration model. These functions are freely configurable and selectable according to a common data configuration model. These functions are mainly as follows:
optionally, a visual editing mode of the general dynamic table is generated. The visual edit mode provides various edit proxy controls. For proxy controls that require initialization data, the source of initialization is configurable. The metadata dictionary can be a metadata dictionary of a local file, or can be a metadata dictionary of a general library or a parameter library. The initialization data source configured with the selection fields is a subset satisfying the minimum and maximum values of the selection fields as the initialization data source. These management controls may be in any of the following forms:
1) and the read-only proxy control is used for configuring the general data model of the editing field into the field content of a read-only editing mode. In the general dynamic table, it is shown that the column cannot edit the status.
2) And the text editing proxy control is used for configuring the general data model of the editing field into the field content of a read-only editing mode. In a generic dynamic table, the way the column is displayed is edited as a text edit box.
3) And the single-selection editing agent control is used for configuring the general data model for editing the field into the field content in the single-selection editing mode. In the general dynamic table, it is shown that the column is edited in a single-item selection box manner.
4) And the check editing agent control is used for configuring the general data model for editing the field into the field content of the check editing mode. In the generic dynamic table, it is shown that the column is a way edit of the multiple choice box.
5) And the password editing proxy control is used for configuring the general data model of the editing field into the field content of the password editing mode. In the universal dynamic table, it is shown that the column is edited in the manner of a password edit box.
6) And the expression editing proxy control is used for configuring the general data model for editing the field into the field content of the expression editing mode. In the generic dynamic table, the display of this column is a way edit of the expression dialog.
7) And the date editing proxy control is used for configuring the general data model of the editing field into the field content of the date editing mode. In the general dynamic table, it is shown that the column is edited in the manner of a date edit box.
8) And the time editing proxy control is used for configuring the general data model of the editing field into the field content of the time editing mode. In the general dynamic table, the column is shown as being edited in a manner of a time edit box.
9) And the color editing agent control is used for configuring the general data model of the editing field into the field content of the color editing mode. In the general dynamic table, the column is displayed with various colors of the selective drop-down box, marked as options of color and color name, and freely selected by a data configuration administrator.
10) And the point code editing proxy control is used for configuring the general data model for editing the field into the field content of the point code editing mode. In the generic dynamic table, the display of this column is a edit in the manner of a point code dialog.
11) The editable radio selection agent control is used for editing the field, and the general data model of the field is configured to be the field content of the editable radio selection editing mode. In the general dynamic form, the column is displayed with options of fuzzy matching of input contents, and can appear in a pop-up drop-down box for free selection of a data configuration administrator.
12) And the logic selection editing agent control is used for editing the field, and the general data model of the field is configured to logically select the field content of the editing mode. In the general dynamic table, the column is displayed to be edited in a checkable check box manner.
Optionally, a column dynamic grouping of the dynamic table is generated. The columns are dynamically grouped, with grouping names and grouping column lists being constrained according to configuration model data. Column grouping exhibits special effects in that the contents of grouped columns to be displayed are freely switched. And, the width of all columns can be freely and dynamically configured. Some columns allow dynamic configuration to hide column display. Also, the columns may be configured to display attributes such as font name, font size, foreground color, background color, and the like.
Optionally, a frozen column pattern of the dynamic table is generated. The frozen column, the common configuration model data, constrains the frozen column entries. The appearance effect of the frozen column is that the horizontal scroll bar scrolls in an attempt to keep the frozen column unchanged in the displayed position in the view. At the same time, the column width of the frozen column can be dynamically configured. The properties of the frozen column, such as font name, font size, foreground color, background color, etc., are also configurable. When configured as a frozen column, its frozen column attribute is in effect.
In addition, the general table also has the necessary option function. These functions either assist in facilitating a clear display of the interface or facilitate editing of the configuration data. These optional functions are as follows:
the general table has a display with odd and even rows of different background colors. The specific display color can be freely selected and configured for use.
The general table supports shortcut functions such as: ctrl + s (save), ctrl + z (undo), and the like.
The general table has an add row function. Adding a row includes adding a single row of records and adding multiple rows of records.
The common table has a copy-copy add-row function. The auxiliary key is supported to select a plurality of rows to record copy-add rows.
The general table has a delete row function. The auxiliary key is supported to select a plurality of rows of record deletion rows.
The general table has a copy-column fill function. And selecting any cell, and selecting copy same column filling, so that the current column is completely filled with the content in the current cell.
The general table has a copy preferred fill function. And selecting any cell, selecting copy preferred filling, and filling all the cells behind the current cell in the current column as the content in the current cell.
The general table has an incremental column fill function. And selecting any cell, and selecting incremental same-column filling, wherein the filling is sequentially incremental and formats the content on the basis of the last number in the current cell when all the current columns are filled.
The general table has an incremental preferred fill function. And selecting any cell, and selecting the incremental preferred filling, wherein all the fillings behind the current cell of the current column are filled with the contents which are sequentially and incrementally increased and formatted on the basis of the last digit in the current cell.
The general table has a copy select line function.
The general table has a paste select line function. The paste select line and the copy select line operate substantially simultaneously. For example, first, select any row, select copy select row; and selecting an empty line, and selecting a paste selection line, wherein the content of the copy selection line is pasted on the selected empty line.
The general table has a cross-table copy row function.
The general table has a cross-table paste-row function. The paste select line and the cross-table copy line operate substantially simultaneously. For example, first select any row, select cross-table copy row; and selecting any row, selecting a cross-table pasting row, and pasting the content of the copy selection row on the selected any row.
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
Referring to fig. 1-6, the technical solution of the present invention is illustrated.
The technical scheme in the implementation of the invention is clearly and completely described by combining the attached drawings in the embodiment examples of the invention. It is to be understood that the embodiments described are only a few embodiments of the present invention, and not all embodiments. All other embodiments, which can be obtained without inventive step in the art, based on the embodiments of the present invention, shall fall within the scope of the present invention.
As shown in fig. 6, a distributed parameter base based configuration management architecture derives from the management thinking of clustered databases. The general parameter library may be any database type. And the general parameter library comprises a public parameter library table based on TIDAS distributed real-time library association. In addition, the general configuration data table can be placed in a general parameter library, and can also be placed in a parameter library in a respective domain. Depending on the formulated type of the private general configuration model data sheet of the respective domain, if the private, using the configuration model data of the general configuration model data sheet in the parameter library of the domain; if the configuration model is public, the configuration model data of the general configuration model data table in the general library is used.
The method comprises the steps that a database type score is used in a related parameter base in a TIDAS-based distributed real-time base system under different scenes, and an Oracle database is adopted as the parameter base in a control center domain; the database in the station domain adopts a MySQL database as a parameter database; the database in the FEP domain adopts an SQLite3 database as a parameter database; and the database in the large data platform domain adopts a business version GreenPlum database based on PostgreSQL as a parameter database.
For scenarios where the generic configuration data table is in a generic library, the parameter library and the generic library are separate. Different separation schemes are possible in different embodiment scenarios.
As shown in FIG. 1, an embodiment of a generic library and a parameter library in a homogenous database is illustrated, which may be isolated using a tablespace. For example, a parameter table base space uses PARA, while a generic base uses ECL, a distinguishing table space. Such an embodiment, the lack of server resources in laboratory and production scenarios may be deployed as an implementation.
FIG. 2 shows an embodiment of a generic library and a parameter library in different databases. Such databases may be the same database on different hosts, or different databases on different hosts, or different database instances on the same host.
FIG. 3 is a schematic diagram of a dynamic part of a generic matching model. The general model configuration data in the figure is in a general library, and the database configuration management software based on the technology reads the general configuration model data in the general library according to a database access configuration list. These generic configuration model data are defined in constraint in parameter library table rules. The key fields in the table include table type, category search, search domain name, searched table name, searched domain name, searched parent domain name, display domain name, etc.
And generating a dynamically grouped module interface according to the table type field in the parameter table library rule. Password access can be set for part of the modules, and unauthorized persons without permission can be prevented from modifying the data in the table below the modules. The hidden partial grouping module can also be configured and is not displayed in the dynamic module list.
And determining whether the left table tree of the module has a classification subtree hierarchical structure or not according to the classification retrieval field in the parameter table library rule. And for the table with the retrieved parent domain name not being empty, the tree structure of the parent domain is preferably inherited. And then constructing the own retrieval domain. Besides the first-level retrieval, the name of a second-level retrieval domain, the name of a second-level retrieved table, the name of a second-level retrieved domain and the name of a second-level display domain; three-level retrieval domain names, three-level retrieved table names, three-level retrieved domain names and three-level display domain names.
The structural hierarchy of the left table tree of the three groups of classification retrieval field constraint modules is also dynamically configurable to generate. It should be noted that the tree levels represent the classification cases, respectively. For example, the numerical table is grouped into a first layer according to stations and grouped into a second layer according to specialties, and then two layers of subtree node structures exist below the table. Each grouping switches the module table list and classification tree structure hierarchy displayed in the module table tree structure of fig. 3 through the tool button control.
The description of the table tree and the sub-tree node description of the classification retrieval mainly depend on a parameter library table dictionary and a parameter library column dictionary, and the data in the two general configuration models are mapped. In addition, the parameter table repository stores the owner in a table dictionary indicating whether the parameter table is from a general purpose repository or a local domain.
The dynamic part of the general table is shown in figure 4. The dynamic part of the dynamic table interface in the figure depends on fields such as column group name, existence of frozen columns, frozen column foreground color, frozen column background color, frozen column width, whether columns are displayed, column font name, font size, column foreground color, column background color, column width and the like in the parameter setting library column rule. These generic configuration data models are used to constrain the dynamic portion of the generic dynamic table.
In the dynamic part of the dynamic table interface, the field value of the column group name of the parameter setting library column rule restricts the dynamic effect of column grouping. And opening the corresponding dynamic table, and dynamically generating the general table according to the general configuration model data. Model data for a generic dynamic table generated for a table with fewer columns may be configured to be ungrouped. However, it is preferable that the model data of the general dynamic table generated for the table having a large number of columns is also arranged in a column group. The grouping column facilitates information viewing and grouping of some related column information. This will greatly improve data configuration and inspection.
The frozen column of the parameter library setting column rule has a frozen column field value constraint dynamic table. For the horizontal scroll bars appearing on the list comparison multi-interface, it is urgently needed to freeze and display a certain column to move along with the horizontal scroll bars. In this case, freezing the column plays a very critical role. In addition, the frozen column foreground color, the frozen column background color and the frozen column width field value of the parameter setting library column rule restrict the frozen column display attribute.
Similar to freezing a column, whether a column of the parameter library column rule shows a field value constrains whether the column shows that sometimes a column needs to be hidden. The parameter sets column font name, font size, column foreground color and column background color field value of the column rule to restrict the display attribute of the column. If the field is configured as the frozen column, the field attribute in the dynamic table is based on the configuration of the frozen column.
And according to the common model data, the control of the common dynamic table provides a suitable editing mode for each column. The dynamic configuration editing mode diagram of the general table is shown in fig. 5. The agent control in various editing modes in the figure places fields such as editing modes, initialized data sources, retrieval domain names, information domain names, selection domains, initial values of the selection domains, termination values of the selection domains and the like in the library rule depending on parameters. The editing mode field value of the parameter setting library column rule determines the type of an editing mode and the style of the proxy control.
The initialized data source field value of the parameter library rule is a local file, which indicates that the data is sourced by a local static metadata dictionary. The value of the retrieval domain name field of the parameter database column rule is the label name of the local XML file, and the sub-label of the parameter database column rule is a metadata dictionary. The source is configured to be a system element dictionary in other initialized data sources, such as a dynamic metadata dictionary, a parameter library or a general library.
The initialized data source is of a dynamic metadata dictionary, and the table and the field of the data source are determined by the retrieval domain name and the information domain name field value of the parameter setting library column rule. And if the configuration of the selection field of the parameter setting library column rule is yes, the selected subset is used as an initialization data source according to the initial value and the termination value of the selection field. The subgraph in fig. 5 lists the effect graphs for only a portion of the edit mode.
Fig. 5 (1) is an editing effect diagram of a text editing mode column generated from a general configuration model.
Fig. 5 (2) is an editing effect diagram of a logic selection editing mode column generated from the general configuration model.
Fig. 5 (3) is an editing effect diagram of a cipher box editing mode column generated according to the general configuration model.
Fig. 5 (4) is an editing effect diagram of a time editing pattern sequence generated from the general configuration model.
Fig. 5 (5) is an editing effect diagram of a date editing mode sequence generated by the general configuration model.
Fig. 5 (6) is an edit effect diagram of a single edit mode column generated from the general configuration model.
Fig. 5 (7) is an edit effect diagram of an editable radio edit mode column generated based on the common configuration model.
Fig. 5 (8) is an editing effect diagram of a check edit pattern column generated from the general configuration model.
Fig. 5 (9) is an editing effect diagram of a color editing mode column generated by the general configuration model.
And mapping the field description of the general dynamic table according to the general configuration model data of the parameter library column dictionary. This part does the translation function of the parameter table fields.
The data configuration administrator configures the management parameter library data, including the generic model configuration data, through these editing agent controls. Through the implementation example, the configuration manager can conveniently and efficiently understand the data in the configuration parameter library.
While the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (7)
1. A method for dynamically configuring data by a database universal model is characterized in that the method designs a universal data configuration model for constructing a universal dynamic table to configure and manage a metadata dictionary, universal model data and parameter data; configuring a dynamic interface part and a general table dynamic function part of management software based on the general data configuration model;
the key tables of the general data configuration model comprise parameter database table placing rules, parameter database column placing rules, a parameter database table dictionary and a digital database column dictionary;
each key table has the following essential fields:
1) the general model definition field of the parameter library table rule should have fields of a table name, a table type, an identification record field name, a classified retrieval, a retrieval field name, a retrieved table name, a retrieved field parent field name, a display field name, a secondary retrieval domain name, a secondary retrieval retrieved table name, a secondary retrieval retrieved field name, a secondary retrieval display field name, a tertiary retrieval retrieved table name, a tertiary retrieval retrieved field name and a tertiary retrieval display field name;
2) the general model definition field of the parameter setting library column rule should have fields of field description, the table name, data type, data length, decimal number, editing mode, data adding principle, initialized data type, initialized data source, retrieval field name, information field name, whether a selection field exists or not, selection field name, initial value of the selection field, termination value of the selection field, association type, association field name, threshold value, display attribute, foreground color, background color, font name, font size, font form, column width, column group name, whether a fixed column exists or not, display attribute of the fixed column, background color of the fixed column, foreground color of the fixed column and the fixed column width;
3) the general model definition field of the parameter library table dictionary is provided with fields of table codes, table descriptions, table types and table spaces;
4) the general model definition field of the parameter setting library column dictionary comprises fields of field index, field code, field description, table code, field type, field length and display type.
2. The method of claim 1, wherein the dynamic interface portion of the software for configuration management based on the generic data configuration model comprises the following components:
1) generating a general dynamic grouping module of configuration management software, wherein an interface of the general dynamic grouping module dynamically displays some grouping table modules or dynamically encrypts and accesses the displayed grouping table according to a general data configuration model;
2) generating a tree structure of a table list of a general dynamic grouping module of configuration management software, wherein the tree structure of the table list of the general dynamic grouping module comprises list contents of a tree and grouping hierarchical contents of the tree;
3) generating a management interface for configuring a field list of a management software universal dynamic grouping module, wherein the management interface for the field list of the universal dynamic grouping module comprises the field list content of a table and the modification of any field description in the field list of the table;
4) and generating a management interface for configuring the data content of the management software general dynamic grouping module, wherein the management interface of the data content of the general dynamic grouping module is a management interface in a tab mode or an interface in a multi-window mode.
3. The method of claim 1, wherein the common table dynamic function comprises selectable functions, which are freely configurable and selectable according to the common data configuration model.
4. The method of claim 3, wherein the optional functions comprise:
generating a visual editing mode of the generic dynamic form, the visual editing mode providing various editing agent controls,
generating a column dynamic grouping of a dynamic table, the column dynamic grouping constraining a group name and a group column list according to configuration model data;
and generating a frozen column mode of the dynamic table, and constraining frozen column items through the general configuration model data.
5. The method of claim 4, wherein the proxy control comprises:
1) the read-only proxy control is used for configuring a general data model of an editing field into field content of a read-only editing mode, and the column can not be edited in a general dynamic table;
2) the text editing agent control is used for configuring a general data model of an editing field into field content of a read-only editing mode, and displaying that the column is edited in a text editing box mode in a general dynamic table;
3) the single-choice editing proxy control is used for configuring a general data model of an editing field into field content of a single-choice editing mode, and displaying that the column is edited in a single-choice selection frame mode in a general dynamic table;
4) the check editing agent control is used for configuring a general data model of an editing field into field contents of a check editing mode, and displaying that the column is edited in a mode of a multi-item selection box in a general dynamic table;
5) the password editing agent control is used for configuring a general data model of an editing field into the field content of a password editing mode, and displaying that the column is edited in a mode of a password editing frame in a general dynamic table;
6) the expression editing proxy control is used for configuring a general data model of an editing field into the field content of an expression editing mode, and displaying that the column is edited in a mode of an expression dialog box in a general dynamic table;
7) the date editing agent control is used for configuring a general data model of an editing field into the field content of a date editing mode, and displaying that the column is edited in a date editing frame mode in a general dynamic table;
8) the time editing agent control is used for configuring a general data model of an editing field into field content of a time editing mode, and displaying that the column is edited in a time editing frame mode in a general dynamic table;
9) the color editing agent control is used for editing the field content of the field configured by the general data model of the field as the color editing mode, displaying that the column has various colors in a selective pull-down frame in a general dynamic table, and marking the column as a selection item of the color and the color name so as to be freely selected by a data configuration manager;
10) the point code editing proxy control is used for configuring a general data model of an editing field into the field content of a point code editing mode, and displaying that the column is edited in a point code dialog box mode in a general dynamic table;
11) the editable menu selection agent control is used for configuring the general data model of the editing field into the field content of an editable menu editing mode, displaying the column as an option with fuzzy matching of input content in a general dynamic table, appearing in a pop-up drop-down box and freely selecting for a data configuration manager;
12) the general data model used for editing the field is configured to the field content of the logic selection editing mode, and the column is displayed in the general dynamic table and edited in a checkable check box mode.
6. The method as claimed in claim 3, wherein the dynamic configuration function of the common form further includes a must-choose function, which is an auxiliary function for facilitating a clear display of the interface or editing the configuration data.
7. The method of claim 6, wherein the mandatory functions comprise:
the general table has odd lines and even lines with different background colors;
the universal table supports a shortcut key function;
the general table has a row adding function, and the row adding comprises adding a single row of records and adding a plurality of rows of records;
the universal table has a copy, copy and add line function and supports an auxiliary key to select a plurality of lines for recording copy, copy and add lines;
the general table has a row deleting function and supports the auxiliary keys to select a plurality of rows of record deleting rows;
the universal table has a copy same column filling function, any cell is selected, copy same column filling is selected, and then the current column is completely filled as the content in the current cell;
the general table has a copy first-choice filling function, any cell is selected, copy first-choice filling is selected, and all the cells behind the current cell in the current column are filled as the content in the current cell;
the general table has an increasing and same-column filling function, any cell is selected, increasing and same-column filling is selected, and then all current columns are filled, and on the basis of the last digit in the current cell, contents are filled, sequentially increased and formatted;
the general table has an increasing preferred filling function, any cell is selected, increasing preferred filling is selected, and then all filling after the current cell in the current column is performed, and filling is sequentially increased and formatted on the basis of the last number in the current cell;
the general table has a copy selection line function;
the general table has a function of pasting the selection line, and the pasting selection line and the copying selection line operate basically simultaneously;
the general table has a cross-table copy row function,
the common table has a cross-table paste row function, the paste select row and the cross-table copy row operate substantially simultaneously.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911054555.3A CN110851420B (en) | 2019-10-31 | 2019-10-31 | Method for dynamically configuring data of general database model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911054555.3A CN110851420B (en) | 2019-10-31 | 2019-10-31 | Method for dynamically configuring data of general database model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110851420A CN110851420A (en) | 2020-02-28 |
| CN110851420B true CN110851420B (en) | 2022-08-30 |
Family
ID=69599591
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911054555.3A Active CN110851420B (en) | 2019-10-31 | 2019-10-31 | Method for dynamically configuring data of general database model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110851420B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116402480B (en) * | 2023-06-07 | 2023-09-19 | 成都普朗克科技有限公司 | Method and system for outputting inventory based on association rule self-built model |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108446327A (en) * | 2018-02-12 | 2018-08-24 | 平安科技（深圳）有限公司 | Operation system dynamic creation method, device, computer equipment and storage medium |
| CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8473519B1 (en) * | 2008-02-25 | 2013-06-25 | Cisco Technology, Inc. | Unified communication audit tool |
-
2019
- 2019-10-31 CN CN201911054555.3A patent/CN110851420B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108446327A (en) * | 2018-02-12 | 2018-08-24 | 平安科技（深圳）有限公司 | Operation system dynamic creation method, device, computer equipment and storage medium |
| CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
Non-Patent Citations (2)
| Title |
|---|
| A framework-based model of software construction;Wang-Dong Yang et al.;《2011 IEEE 2nd International Conference on Software Engineering and Service Science》;20110812;全文 * |
| 基于NETCONF的通用设备配置管理系统的设计与实现;陈春霖;《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》;20190515;第2019年卷(第5期);第I138-654页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110851420A (en) | 2020-02-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6859805B1 (en) | Method and apparatus for generating page-level security in a computer generated report | |
| CN102722519B (en) | Techniques to create structured document templates using enhanced content controls | |
| JP6002159B2 (en) | Electronic document search method and electronic document search graphical display method | |
| CN114035773B (en) | Configuration-based low-code form development method, system and device | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| US11907203B2 (en) | Path encoded tree structures for operations | |
| US8255368B2 (en) | Apparatus and method for positioning user-created data in OLAP data sources | |
| CN106933837A (en) | A kind of database table model and creation method | |
| US20150331928A1 (en) | User-created members positioning for olap databases | |
| JP2017097845A (en) | Organization and visualization of content from multiple media sources | |
| US20150199346A1 (en) | Hierarchical database report generation with automated query generation for placeholders | |
| CN114090653A (en) | Resource data statistical method and device, meta-platform equipment and storage medium | |
| CN110851420B (en) | Method for dynamically configuring data of general database model | |
| CN110083664B (en) | Method for automatically constructing topological model based on CMDB model | |
| US20170344634A1 (en) | Computer implemented and computer controlled method, computer program product and platform for arranging data for processing and storage at a data storage engine | |
| CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
| CN112270628A (en) | Intellectual property theme library management method and system | |
| JP2003006242A (en) | Product data management system, program to run the system, recording medium recorded with the program, and product data management method | |
| EP2118763A2 (en) | Method and apparatus for managing system specifications | |
| CN112488642A (en) | Cloud file management method based on structured tags and taking object as core | |
| JP2004046650A (en) | Data management method and database structure | |
| US20170270187A1 (en) | Information processing device, information processing method, and program | |
| EP0466878B1 (en) | Method and apparatus for graphical interrogation of a database | |
| CN108536685A (en) | Information processing unit | |
| US11921797B2 (en) | Computer service for indexing threaded comments with pagination support |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |