CN110968653A - Tree-shaped data dictionary maintenance system and method - Google Patents
Tree-shaped data dictionary maintenance system and method Download PDFInfo
- Publication number
- CN110968653A CN110968653A CN201911240261.XA CN201911240261A CN110968653A CN 110968653 A CN110968653 A CN 110968653A CN 201911240261 A CN201911240261 A CN 201911240261A CN 110968653 A CN110968653 A CN 110968653A
- Authority
- CN
- China
- Prior art keywords
- data
- dictionary
- field
- data dictionary
- information
- 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.)
- Granted
Links
- 238000012423 maintenance Methods 0.000 title claims abstract description 60
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000013475 authorization Methods 0.000 claims abstract description 12
- 230000008859 change Effects 0.000 claims description 6
- 238000013479 data entry Methods 0.000 claims description 6
- 230000004048 modification Effects 0.000 claims description 5
- 238000012986 modification Methods 0.000 claims description 5
- 239000003607 modifier Substances 0.000 claims description 3
- 238000011161 development Methods 0.000 description 10
- 230000010354 integration Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 5
- 238000010276 construction Methods 0.000 description 4
- 230000004913 activation Effects 0.000 description 3
- 230000009849 deactivation Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000013523 data management Methods 0.000 description 2
- 238000012827 research and development Methods 0.000 description 2
- 230000004888 barrier function Effects 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 239000006185 dispersion Substances 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000004904 shortening Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a tree-shaped data dictionary maintenance system and method, belongs to the field of data dictionary maintenance, and aims to solve the technical problem of how to flexibly and efficiently manage basic data. The system comprises: the data dictionary category definition module is used for creating a data dictionary and configuring category information, authorization information and maintenance rules of the data dictionary; the data dictionary definition module is used for acquiring service data and calling the data dictionary type definition module to maintain the data; and the data interface is used for providing the maintained data to the service system. The method is to maintain the service data through the maintenance system and provide the maintained service data to each service system.
Description
Technical Field
The invention relates to the field of data dictionary maintenance, in particular to a tree-shaped data dictionary maintenance system and a tree-shaped data dictionary maintenance method.
Background
With the continuous development of enterprises, the requirements of information technology in enterprise management are continuously improved, some requirements for flexibly expanding system data attributes and main data synchronization during multi-system integration are frequently met in the information project of modern enterprises, most management software in the market mainly adopts solutions for developing forms or functions aiming at different personalized requirements when meeting the requirements, and the solutions bring the following problems to the information construction of the enterprises:
1. repeated development wastes limited development resources
The form styles or functional characteristics in the requirements are almost the same, but the operational service data are different, so the form or function developed separately according to each requirement is actually a repeated development, which is contrary to the reusable principle of software engineering, the research and development investment of software manufacturers is increased, the research and development period is undoubtedly prolonged by consuming limited development resources on repeated work, and the informatization investment of enterprises is increased.
2. Poor expansibility and need of capital investment again for development when subsequent business changes
The operation environment of the enterprise changes all the time at present, the corresponding requirements for the information system also change all the time, and forms or functions developed independently for each service cannot adapt to the changing requirements due to special limitations, so that development resources are modified and re-invested to modify the original functions when the requirements change, which can increase the information construction cost of the enterprise and increase the burden of the enterprise.
3. Form or function dispersion is inconvenient for classification and unified management
The forms or functions developed independently are generally dispersed in each function module of the information system in the form of independent menus, so that business personnel are required to accurately remember the positions of the menus, classification and unified management of the business personnel are not facilitated, and the problem that business personnel cannot find a certain menu to influence business operation often occurs.
4. Lack of integrated interface with heterogeneous system and increase of cost of enterprise cross-system service integration
If the independent development form or the independent development function does not have special requirements, the data access interface is not provided, so that a barrier is caused to cross-system business integration which may occur in the subsequent enterprise informatization process, when the system integration requirement occurs, enterprises need to invest again to develop the relevant data access interface, the enterprise cost is increased, and meanwhile, the period of enterprise business system integration is delayed.
How to manage the basic data flexibly and efficiently is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a tree-shaped data dictionary maintenance system and method aiming at the defects, so as to solve the problem of how to flexibly and efficiently manage basic data.
In a first aspect, the present invention provides a tree data dictionary maintenance system, including:
the data dictionary category definition module is used for creating a data dictionary and configuring category information, authorization information and maintenance rules of the data dictionary;
the data dictionary definition module is used for acquiring service data and calling the data dictionary type definition module to maintain the data;
and the data interface is used for providing the maintained data to the service system.
Preferably, the data dictionary definition module includes:
the category configuration submodule is used for configuring category information of the data dictionary through a category configuration interface, and the category information comprises but is not limited to dictionary type numbers, dictionary type names and states of the data dictionary;
the field attribute configuration submodule is used for configuring and selecting a data acquisition mode and configuring parameters required by the data acquisition mode through a field attribute configuration interface, and the data acquisition mode comprises manual input and acquisition in a data table;
the expansion field configuration submodule is used for configuring expansion field information of the data word table through an expansion field configuration interface, setting usable expansion attributes of each data item in the data dictionary and specifying data entry modes of different expansion attributes, and the expansion field information comprises but is not limited to field numbers, field names, field types, modifiers and modification time;
the authorized user maintenance sub-module is used for configuring authorized information and maintenance rules through an authorized user maintenance interface, wherein the authorized information comprises authorized user information and authorized post information;
the storage submodule stores a data dictionary type definition table and a data dictionary expansion field table, the data dictionary type definition table is used for storing dictionary type numbers, dictionary type names, states and data acquisition modes of the data dictionary, and the data dictionary expansion dictionary table is used for storing expansion field information of the data dictionary.
Preferably, the dictionary category number is a unique identifier of the data dictionary and serves as a mark field for acquiring data of the data dictionary.
Preferably, the parameters required by the data acquisition mode include, but are not limited to, a source table name, an ID field, a number field, a name field, whether the source table is hierarchical, a hierarchical code field, a parent intra-code field, whether the source table is detailed, a level field, and a hierarchical code hierarchical field;
the source table name, the ID field, the number field and the name field are matched to define key information of a data dictionary, which needs to acquire a data item from a database;
the ID field is a field which is never allowed to change in the original data, and the data dictionary definition module is used for automatically acquiring the latest original data from the database when calling the data dictionary type definition module to maintain the data.
Preferably, the expansion field configuration sub-module sets the expansion attribute which can be used by each data item in the data dictionary in a mode of text box, enumerated value drop-down box selection and list help selection box, and specifies the data entry mode of different expansion attributes.
Preferably, the data dictionary definition module includes:
the information configuration submodule is used for configuring basic information of the data item, the basic information of the data item comprises but is not limited to a data serial number, a custom number, a data name, remarks, a current state, an operation date, an operator and a registration date, and the current state is enabled or disabled;
the query submodule is used for setting query conditions and searching a data dictionary and a data item which need to be maintained according to the query conditions, the data dictionary which needs to be maintained is an authorized data dictionary, and the query conditions include but are not limited to data serial numbers, custom numbers, data names and current states;
the first data item acquisition submodule acts on a data dictionary with a data acquisition mode of manual addition, is used for adding the same-level or lower-level data items for the current data item, and is used for selecting and deleting the current data item;
and the second data item acquisition submodule acts on the data dictionary acquired from the data table in the data acquisition mode and is used for selecting the data dictionary and acquiring the data items required by the current data dictionary from the external data table.
The data item configuration submodule is used for sequentially adjusting the data items, modifying the content and the expansion attribute values of the data items and modifying the state of the data items in the service function, wherein the state of the data items in the service function is enabled or disabled;
and the storage submodule is used for storing a data item table and a data dictionary extension table, the data item table is used for storing basic information of the data item, and the data dictionary extension table is used for storing an extended attribute value.
Preferably, the data interface comprises a WebService interface and/or an interface module supporting public methods.
Preferably, the maintenance system is deployed in a server or added as a tool to a service platform.
In a second aspect, the present invention provides a method for maintaining a tree-shaped data dictionary, which maintains service data through a tree-shaped data dictionary maintenance system according to any one of the first aspects, and provides the maintained service data to each service system, and the method includes the following steps:
creating a data dictionary through a data dictionary category definition module, and managing category information, authorization information and maintenance rules of the data dictionary;
and acquiring service data through the data dictionary definition module, calling the data dictionary type definition module to maintain the data, and sending the maintained service data to the service system through the data interface.
The tree-shaped data dictionary maintenance system and method have the following advantages that:
1. on the basis of combining enterprise practical application, the creation and maintenance of a simple data dictionary are supported, meanwhile, the extension attributes can be customized according to different data items, and the connotation of enterprise basic data is enriched, such as: the enterprise headquarters need to divide industries for the subsidiaries and provide data reports according to different industries, so that the actual application of various business application scenes is well supported by adding attributes of the industries to the subsidiary data dictionary and deeply analyzing the logical relationship among data in each application scene;
2. the data acquisition mode supports manual input and import from an external data table, and can automatically acquire a data dictionary from other data tables by configuring relevant information of acquired data, so that the characteristic provides possibility for enriching and expanding existing business data for enterprises;
3. the data are displayed in a tree-like mode, and a list data dictionary and a multi-level data dictionary with an upper-level and lower-level relation can be displayed in a good compatibility manner;
4. different service data are divided into different types through user authorization, and the different types of data are authorized to different roles, users and posts for special maintenance, so that the standardization and the safety of data management are improved;
5. a unified and various WebService interfaces and public methods are provided for the outside, asymmetric encryption and integration with ESB are supported, access of different software platforms to basic data in the invention is standardized and simplified, and powerful support is formed for building of basic information platforms and cross-system functional service integration in an enterprise informatization process.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a functional block diagram of a tree data dictionary maintenance system according to embodiment 1;
fig. 2 is a schematic diagram of field attribute configuration performed by a data dictionary type definition module in a tree-like data dictionary maintenance system according to embodiment 1;
fig. 3 is a schematic diagram of field expansion configuration performed by a data dictionary type definition module in a tree-like data dictionary maintenance system according to embodiment 1;
fig. 4 is a schematic diagram of authorized user maintenance performed by a data dictionary category definition module in a tree-like data dictionary maintenance system according to embodiment 1;
fig. 5 is a schematic diagram of data item maintenance by a data dictionary definition module in a tree-like data dictionary maintenance system according to embodiment 1.
Detailed Description
The present invention is further described in the following with reference to the drawings and the specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not to be construed as limiting the present invention, and the embodiments and the technical features of the embodiments can be combined with each other without conflict.
It is to be understood that the terms first, second, and the like in the description of the embodiments of the invention are used for distinguishing between the descriptions and not necessarily for describing a sequential or chronological order. The "plurality" in the embodiment of the present invention means two or more.
The term "and/or" in the embodiment of the present invention is only an association relationship describing an associated object, and indicates that three relationships may exist, for example, a and/or B may indicate: a exists alone, B exists alone, and A and B exist at the same time. In addition, the character "/" herein generally indicates that the former and latter associated objects are in an "or" relationship.
The embodiment of the invention provides a tree data dictionary maintenance system and method, which are used for solving the technical problem of how to flexibly and efficiently manage basic data.
Example 1:
the invention relates to a tree-shaped data dictionary maintenance system, which comprises a data dictionary category definition module, a data dictionary definition module and a data interface which are sequentially connected, wherein the data dictionary category definition module is used for creating a data dictionary and configuring category information, authorization information and maintenance rules of the data dictionary; the data dictionary definition module is used for acquiring service data and calling the data dictionary type definition module to maintain the data; and the data interface is used for providing the maintained data to the service system.
The data dictionary definition module comprises a category configuration submodule, a field attribute configuration submodule, an expansion field configuration submodule, an authorized user maintenance submodule and a storage submodule. The category configuration submodule, the field attribute configuration submodule, the expanded field configuration submodule and the authorized user maintenance submodule are all provided with corresponding configuration interfaces, menu selection is supported in the configuration interfaces, at least one of a text box, an enumeration value pull-down selection box and a list help selection box is formed, and a control button is formed.
The category configuration submodule is used for configuring category information of the data dictionary through a category configuration interface, and the category information of the data dictionary comprises dictionary type numbers, dictionary type names and states of the data dictionary. The number and the name of the data dictionary are defined by setting two fields of a dictionary type number and a dictionary type name, wherein the dictionary type number is the unique identifier of the data dictionary and is used as a mark field for acquiring dictionary data.
And the field attribute configuration submodule is used for configuring and selecting a data acquisition mode and configuring parameters required by the data acquisition mode through a field attribute configuration interface. The parameters required by the data acquisition mode include, but are not limited to, the name of the source table, the ID field, the number field, the name field, whether the source table is hierarchical, the hierarchical code field, the code field in the parent level, whether the detail field is present, the number field, and the hierarchical code field.
The data acquisition mode used by the data dictionary can be defined by setting the data acquisition mode, and the data acquisition mode in this embodiment includes: manually entered, obtained from a data sheet.
After the appropriate data acquisition mode is selected, the setting of the parameters required by the specific data acquisition mode can be completed through the field attribute setting (as shown in fig. 2).
Defining this data dictionary by fields such as source table name, ID field, number field, name field, etc. requires obtaining key information for the data item from the database table. The ID field is a field which is never allowed to change in the original data and is used for automatically acquiring the latest original data from the database each time the data is maintained.
The expansion field configuration submodule is used for configuring expansion field information of the data word table through an expansion field configuration interface, setting usable expansion attributes of each data item in the data dictionary and specifying data entry modes of different expansion attributes, and the expansion field information includes but is not limited to field numbers, field names, field types, modifiers and modification time.
Setting usable extended attributes of each data item in the data dictionary through an extended field (see fig. 3), and specifying data entry modes of different extended attributes, where the specific modes of this embodiment include: text boxes, enumerated value drop-down selections, list help selection boxes. The present embodiment supports the addition of multiple extension fields for each data item.
After a proper data acquisition mode is selected, the setting of parameters required by the help control or the pull-down control can be completed through a [ control setting ] functional area in the interface.
And the authorized user maintenance sub-module is used for configuring authorization information and maintenance rules through an authorized user maintenance interface, wherein the authorization information comprises authorized user information and authorized post information.
The maintenance authority of the specific data dictionary is granted to a specific user or a specific post through the authority assignment (shown in figure 2) menu to open an authority user maintenance interface (shown in figure 5). Only authorized users can subsequently maintain the data dictionary.
The storage submodule stores a data dictionary type definition table and a data dictionary expansion field table, the data dictionary type definition table is used for storing dictionary type numbers, dictionary type names, states and data acquisition modes of the data dictionary, and the data dictionary expansion dictionary table is used for storing expansion field information of the data dictionary.
In this embodiment, information defined by the data dictionary category definition table is shown in table 1.
TABLE 1 basic data-data dictionary Category definitions (RZSJZDLB)
In this embodiment, the information defined by the data dictionary extension field table is shown in table 2.
TABLE 2 basic data-data dictionary expansion field Table (RZSJZDZZD)
| Field numbering | Name of field | Type of field |
| RZSJZDTZZD_ID | ID | VARchar2(36) |
| RZSJZDTZZD_DLID | Dictionary category internal code | VARchar2(36) |
| RZSJZDTZZD_ZDBH | Field numbering | VARchar2(36) |
| RZSJZDTZZD_ZDMC | Name of field | VARchar2(36) |
| RZSJZDTZZD_ZDLX | Type of field | VARchar2(2) |
| RZSJZDTZZD_H_SJY | Help _ data Source tagging | VARchar2(30) |
| RZSJZDTZZD_H_NM | Help _ inner code field | VARchar2(30) |
| RZSJZDTZZD_H_BH | Help _ Number field | VARchar2(30) |
| RZSJZDTZZD_H_MC | Help _ name field | VARchar2(30) |
| RZSJZDTZZD_H_BZTJ | Help _ Help Condition | VARchar2(1000) |
| RZSJZDTZZD_H_DCTJ | Help _ Belt-out Condition | VARchar2(1000) |
| RZSJZDTZZD_H_SFDC | Help _ if automatically brings out a name | VARchar2(2) |
| RZSJZDTZZD_D_JZD | Pull-down _ key value pair | VARchar2(1000) |
| RZSJZDTZZD_XGRBH | Reviser number | VARchar2(100) |
| RZSJZDTZZD_XGRMC | Modifying a person name | VARchar2(200) |
| RZSJZDTZZD_XGSJ | Modifying time | VARchar2(20) |
| RZSJZDTZZD_CJRBH | Creator number | VARchar2(100) |
| RZSJZDTZZD_CJRMC | Creating a person name | VARchar2(200) |
| RZSJZDTZZD_CJSJ | Creation time | VARchar2(20) |
The data dictionary definition module comprises an information configuration sub-module, a query sub-module, a first data item acquisition sub-module, a second data item acquisition sub-module and a data item configuration sub-module. The information configuration sub-module, the query sub-module, the first data item acquisition sub-module, the second data item acquisition sub-module and the data item configuration sub-module face users through a configuration interface, menu selection is supported in the configuration interface, at least one of a text box, an enumerated value pull-down selection and a list help selection box is formed, and a control button is formed.
The information configuration submodule is used for configuring basic information of the data item, the basic information of the data item comprises but is not limited to a data serial number, a custom number, a data name, remarks, a current state, an operation date, an operator and a registration date, and the current state is activation or deactivation.
The query submodule is used for setting query conditions and searching a data dictionary and data items which need to be maintained according to the query conditions.
The filtering conditions can be set in the functional area to query the data dictionary and data items to be maintained, and the data dictionary must be authorized in advance to be maintained. The query conditions comprise a data sequence number, a user-defined number, a data name and a current state, and the current state is activation or deactivation.
The first data item acquisition submodule acts on a data dictionary which is manually added in a data acquisition mode, is used for adding the same level or lower level data items for the current data item, and is used for selecting and deleting the current data item.
Adding the same-level or lower-level data items to the current data item through the (same-level adding) and (lower-level adding) buttons of the (data dictionary definition) (see the attached figure 5); and deleting the currently selected data item through a [ delete ] button.
The method for implementing the same level is added as follows: acquiring the hierarchy and the hierarchical code of the current data item (used for determining the hierarchy and the sequence of the data item in the data dictionary), and generating the hierarchy and the hierarchical code of a new data item according to the hierarchy and the hierarchical code of the current data item, wherein the hierarchy of the new data item is the same as the hierarchy of the current data item, and the hierarchical code of the new data item is the hierarchical code of the data item plus 1.
The method for realizing the same level is added as follows: acquiring the hierarchy and the hierarchical code of the current data item (used for determining the hierarchy and the sequence of the data item in the data dictionary), and generating the hierarchy and the hierarchical code of a new data item according to the hierarchy and the hierarchical code of the current data item, wherein the hierarchy of the new data item is the hierarchy of the current data item plus one, the hierarchical code of the new data item is the hierarchical code of the data item plus a 4-bit serial number, and the 4-bit serial number is generated from 0001 according to the newly added sequence of the data item
Only when the data acquisition mode of the data dictionary is manually increased, buttons of 'sibling increase', 'subordinate increase' and 'delete' can be used.
And the second data item acquisition submodule acts on the data dictionary acquired from the data table in the data acquisition mode and is used for selecting the data dictionary and acquiring the data items required by the current data dictionary from the external data table.
The required data items of the current data dictionary are manually retrieved from the external data table via the [ sync data ] button of the [ data dictionary definition ] (see fig. 5). The [ synchronize data ] button is only available if the data dictionary has data to be retrieved from the data table.
The data item configuration submodule is used for adjusting the sequence of the data items, modifying the content of the data items and the expansion attribute values, and modifying the state of the data items in the business function, wherein the state of the data items in the business function is enabled or disabled.
Through the buttons of [ order adjustment ], [ modification ], [ activation ], [ deactivation ], and the like of [ data dictionary definition ] (see fig. 5), adjustment of the hierarchy structure of the data items, modification of item contents and expansion of attribute values, and control of whether the data items are available in the service function can be realized.
Wherein, the [ order adjustment ] function is used to adjust the front-back order of different data items in the same level to ensure that the order of the data items conforms to the requirements of the actual service scene.
Automatic updating of the original data is supported. Each time the [ data dictionary definition ] is opened (see fig. 5) for the query data, the latest original data can be automatically acquired from the database and displayed in the data list, and the data items maintained before are not lost due to the updating of the original data.
And the storage submodule is used for storing a data item table and a data dictionary extension table, the data item table is used for storing basic information of the data item, and the data dictionary extension table is used for storing an extended attribute value.
The information defined in the data item table in this embodiment is shown in table 3.
TABLE 3 basic data-data dictionary-data item Table (RZSJZD)
The information defined by the data dictionary extension table is shown in table 4.
TABLE 4 basic data-data dictionary expansion Table (RZSJZDKZ)
| Field numbering | Name of field | Type of field |
| RZSJZDKZ_NM | Inner code | VARchar2(36) |
| RZSJZDKZ_ZBNM | Main table internal code | VARchar2(36) |
| RZSJZDKZ_CODE | Expanding field numbering | VARchar2(100) |
| RZSJZDKZ_NAME | Extended field name | VARchar2(200) |
| RZSJZDKZ_VALUE | Extended field value | VARchar2(800) |
| RZSJZDKZ_STATE | Custom state | VARchar2(2) |
| RZSJZDKZ_NOTE | Self-defining remarks | VARchar2(1024) |
The data interface supports standard WebService interfaces and public methods, and the method supports querying data items through specific conditions and acquiring extension field values through the data items.
Querying data items by a particular condition is defined as follows:
obtaining an extension field value through a data item
The tree-shaped data dictionary maintenance system can be deployed in a server or added to a service platform as a tool (such as a Langchao GSP platform), and provides a method for realizing a multipurpose tree-shaped data dictionary maintenance tool, which comprises contents such as data dictionary categories, data dictionary definitions, data dictionary authorization maintenance, data standard query methods or interfaces and the like. The data dictionary type is responsible for uniformly managing data dictionary type information, authorization information and maintenance rules, is a creator of the data dictionary, and the data dictionary definition function calls the definition and acquires service data to complete the data maintenance function, and finally provides the maintained data for each service system through a data acquisition interface or method.
The expansion field characteristics can be suitable for various scenes such as main data mapping and expansion maintenance of specific data service attributes during software system integration, repeated development work of enterprise informatization construction is greatly reduced, and subsequent service expansion and system upgrading of enterprises are facilitated; the data source can be customized as required, and the data source can be manually input or obtained from an external data table, so that a data dictionary can be added and an original data dictionary can be expanded conveniently; the invention uniformly adopts a tree-shaped mode to display data, and can well compatibly display a list data dictionary and a multi-level data dictionary with an upper-level and lower-level relation; by dividing different service data into different types and authorizing the different types of data to different roles, users and posts for special maintenance, the standardization and the safety of data management are improved; the method provides a whole set of data access interface and a public access method, provides a good expansion mode for cross-system service integration in enterprise informatization construction, and is greatly helpful for saving enterprise informatization cost and shortening informatization period.
Example 2:
the specific method for maintaining the tree data dictionary and providing the maintained service data to each service system by the tree data dictionary maintenance system disclosed in the embodiment 1 of the invention is as follows: the method comprises the steps of establishing a data dictionary through a data dictionary category definition module, managing category information, authorization information and maintenance rules of the data dictionary, obtaining service data through the data dictionary definition module, calling the data dictionary category definition module to maintain the data, and sending the maintained service data to a service system through a data interface.
The process is as follows:
(1) the tree-shaped data dictionary maintenance disclosed in the embodiment 1 is separately deployed to a server or directly added to a service platform as a tool;
(2) defining a data dictionary, defining a data acquisition mode and defining an expansion field by a data dictionary type definition module;
(3) maintaining data items through a data dictionary definition module, and inputting an expansion field value;
(4) and each service system calls a data interface to acquire the data item.
The above-mentioned embodiments are merely preferred embodiments for fully illustrating the present invention, and the scope of the present invention is not limited thereto. The equivalent substitution or change made by the technical personnel in the technical field on the basis of the invention is all within the protection scope of the invention. The protection scope of the invention is subject to the claims.
Claims (9)
1. A tree data dictionary maintenance system, comprising:
the data dictionary category definition module is used for creating a data dictionary and configuring category information, authorization information and maintenance rules of the data dictionary;
the data dictionary definition module is used for acquiring service data and calling the data dictionary type definition module to maintain the data;
and the data interface is used for providing the maintained data to the service system.
2. The tree data dictionary maintenance system of claim 1, wherein said data dictionary definition module comprises:
the category configuration submodule is used for configuring category information of the data dictionary through a category configuration interface, and the category information comprises but is not limited to dictionary type numbers, dictionary type names and states of the data dictionary;
the field attribute configuration submodule is used for configuring and selecting a data acquisition mode and configuring parameters required by the data acquisition mode through a field attribute configuration interface, and the data acquisition mode comprises manual input and acquisition in a data table;
the expansion field configuration submodule is used for configuring expansion field information of the data word table through an expansion field configuration interface, setting usable expansion attributes of each data item in the data dictionary and specifying data entry modes of different expansion attributes, and the expansion field information comprises but is not limited to field numbers, field names, field types, modifiers and modification time;
the authorized user maintenance sub-module is used for configuring authorized information and maintenance rules through an authorized user maintenance interface, wherein the authorized information comprises authorized user information and authorized post information;
the storage submodule stores a data dictionary type definition table and a data dictionary expansion field table, the data dictionary type definition table is used for storing dictionary type numbers, dictionary type names, states and data acquisition modes of the data dictionary, and the data dictionary expansion dictionary table is used for storing expansion field information of the data dictionary.
3. The system of claim 2, wherein the dictionary class number is a unique identifier of the data dictionary and is used as a tag field for retrieving data from the data dictionary.
4. The system of claim 2, wherein the parameters required for the data acquisition mode include, but are not limited to, source table name, ID field, number field, name field, whether the source table is hierarchical, hierarchical code field, internal code field of parent level, detailed field, level field, and hierarchical code field;
the source table name, the ID field, the number field and the name field are matched to define key information of a data dictionary, which needs to acquire a data item from a database;
the ID field is a field which is never allowed to change in the original data, and the data dictionary definition module is used for automatically acquiring the latest original data from the database when calling the data dictionary type definition module to maintain the data.
5. The system for maintaining a tree-like data dictionary as claimed in claim 2, wherein the extended field configuration sub-module sets the extended attributes available for each data item in the data dictionary and specifies the data entry modes of different extended attributes by means of text box, enumerated value drop-down box selection and list help selection box.
6. The tree data dictionary maintenance system according to claim 1, 2, 3, 4 or 5, wherein said data dictionary definition module comprises:
the information configuration submodule is used for configuring basic information of the data item, the basic information of the data item comprises but is not limited to a data serial number, a custom number, a data name, remarks, a current state, an operation date, an operator and a registration date, and the current state is enabled or disabled;
the query submodule is used for setting query conditions and searching a data dictionary and a data item which need to be maintained according to the query conditions, the data dictionary which needs to be maintained is an authorized data dictionary, and the query conditions include but are not limited to data serial numbers, custom numbers, data names and current states;
the first data item acquisition submodule acts on a data dictionary with a data acquisition mode of manual addition, is used for adding the same-level or lower-level data items for the current data item, and is used for selecting and deleting the current data item;
and the second data item acquisition submodule acts on the data dictionary acquired from the data table in the data acquisition mode and is used for selecting the data dictionary and acquiring the data items required by the current data dictionary from the external data table.
The data item configuration submodule is used for sequentially adjusting the data items, modifying the content and the expansion attribute values of the data items and modifying the state of the data items in the service function, wherein the state of the data items in the service function is enabled or disabled;
and the storage submodule is used for storing a data item table and a data dictionary extension table, the data item table is used for storing basic information of the data item, and the data dictionary extension table is used for storing an extended attribute value.
7. The system according to claim 1, 2, 3, 4 or 5, wherein the data interface comprises a WebService interface and/or an interface module supporting public methods.
8. A tree data dictionary maintenance system according to claim 1, 2, 3, 4 or 5 characterized in that said maintenance system is deployed in a server or added as a tool to a service platform.
9. A tree data dictionary maintenance method, wherein service data is maintained by a tree data dictionary maintenance system according to any one of claims 1 to 7, and the maintained service data is provided to each service system, the method comprising the steps of:
creating a data dictionary through a data dictionary category definition module, and managing category information, authorization information and maintenance rules of the data dictionary;
and acquiring service data through the data dictionary definition module, calling the data dictionary type definition module to maintain the data, and sending the maintained service data to the service system through the data interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240261.XA CN110968653B (en) | 2019-12-06 | 2019-12-06 | Tree-shaped data dictionary maintenance system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911240261.XA CN110968653B (en) | 2019-12-06 | 2019-12-06 | Tree-shaped data dictionary maintenance system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110968653A true CN110968653A (en) | 2020-04-07 |
| CN110968653B CN110968653B (en) | 2024-03-29 |
Family
ID=70033211
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911240261.XA Active CN110968653B (en) | 2019-12-06 | 2019-12-06 | Tree-shaped data dictionary maintenance system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110968653B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111723077A (en) * | 2020-06-24 | 2020-09-29 | 中国平安财产保险股份有限公司 | Data dictionary maintenance method and device and computer equipment |
| CN112307097A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Data asset management method and device |
| CN112506944A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Data standard conversion access method, device, equipment and medium between service systems |
| CN113282278A (en) * | 2021-05-17 | 2021-08-20 | 山东浪潮通软信息科技有限公司 | Basic data participant matrix design method, device and medium |
| CN113360666A (en) * | 2021-05-31 | 2021-09-07 | 珠海大横琴科技发展有限公司 | Data dictionary management method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2665556A1 (en) * | 2006-10-04 | 2008-04-17 | Welch Allyn, Inc. | Dynamic medical object information base |
| CN101930443A (en) * | 2009-06-22 | 2010-12-29 | 金蝶软件（中国）有限公司 | Data service system and data service realization method |
| EP2942731A1 (en) * | 2014-05-10 | 2015-11-11 | Informatica Corporation | Identifying and securing sensitive data at its source |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
-
2019
- 2019-12-06 CN CN201911240261.XA patent/CN110968653B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2665556A1 (en) * | 2006-10-04 | 2008-04-17 | Welch Allyn, Inc. | Dynamic medical object information base |
| CN101930443A (en) * | 2009-06-22 | 2010-12-29 | 金蝶软件（中国）有限公司 | Data service system and data service realization method |
| EP2942731A1 (en) * | 2014-05-10 | 2015-11-11 | Informatica Corporation | Identifying and securing sensitive data at its source |
| CN105868202A (en) * | 2015-01-21 | 2016-08-17 | 镇江雅迅软件有限责任公司 | Multi-platform access data management system |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
Non-Patent Citations (1)
| Title |
|---|
| 王德广;张军卒;李文;: "基于数据字典的通用查询平台的设计" * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111723077A (en) * | 2020-06-24 | 2020-09-29 | 中国平安财产保险股份有限公司 | Data dictionary maintenance method and device and computer equipment |
| CN112307097A (en) * | 2020-10-13 | 2021-02-02 | 武汉中科通达高新技术股份有限公司 | Data asset management method and device |
| CN112506944A (en) * | 2020-10-30 | 2021-03-16 | 福建亿能达信息技术股份有限公司 | Data standard conversion access method, device, equipment and medium between service systems |
| CN112506944B (en) * | 2020-10-30 | 2022-08-05 | 福建亿能达信息技术股份有限公司 | Data standard conversion access method, device, equipment and medium between service systems |
| CN113282278A (en) * | 2021-05-17 | 2021-08-20 | 山东浪潮通软信息科技有限公司 | Basic data participant matrix design method, device and medium |
| CN113282278B (en) * | 2021-05-17 | 2024-03-22 | 浪潮通用软件有限公司 | Basic data participant matrix design method, device and medium |
| CN113360666A (en) * | 2021-05-31 | 2021-09-07 | 珠海大横琴科技发展有限公司 | Data dictionary management method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110968653B (en) | 2024-03-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110968653B (en) | Tree-shaped data dictionary maintenance system and method | |
| CN109669983B (en) | Visual multi-data-source ETL tool | |
| US7194480B2 (en) | System and method for invoking methods on place objects in a distributed environment | |
| US7418666B2 (en) | System, method and computer program product for managing CAD data | |
| US6058391A (en) | Enhanced user view/update capability for managing data from relational tables | |
| US5937402A (en) | System for enabling access to a relational database from an object oriented program | |
| US7373351B2 (en) | Generic search engine framework | |
| US20080115104A1 (en) | Software development system and method for intelligent document output based on user-defined rules | |
| CN102810094A (en) | Report generation method and device | |
| JPH1115867A (en) | Design information management system, design information access device and program storing medium | |
| CN104035772A (en) | Static analysis based source code multi-versionfunction call relation difference identification method | |
| US6470343B1 (en) | Method, computer program product, system, and data structure for database data model extension | |
| CA2330305A1 (en) | Geographic based information technology management system | |
| CN102081662A (en) | Method and apparatus for modifying process control data | |
| KR19980702170A (en) | Communication network database construction method and device | |
| US6484160B1 (en) | Process for optimizing accesses to a database | |
| CN114327458A (en) | Method and system for quickly building enterprise informatization system | |
| JP2006524376A (en) | Generic database schema | |
| US20010004402A1 (en) | Information comparison display apparatus using colors and a method thereof | |
| US7461078B2 (en) | Interface system for accessing data in a database | |
| CN108830540B (en) | Method, device and system for processing engineering project archive | |
| WO1998047057A2 (en) | Registry management system | |
| CN114115837A (en) | MIS self-adaptive generator based on object information and use method | |
| CN111045718B (en) | Software suitable for airworthiness management of civil airborne equipment | |
| US20160125001A1 (en) | Automatic screen generation device, automatic screen generation program, and automatic screen generation method |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20240229 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Country or region after: China Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. Country or region before: China |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |