CN107315771B - Data exchange system customization method based on database table data dictionary - Google Patents
Data exchange system customization method based on database table data dictionary Download PDFInfo
- Publication number
- CN107315771B CN107315771B CN201710368274.XA CN201710368274A CN107315771B CN 107315771 B CN107315771 B CN 107315771B CN 201710368274 A CN201710368274 A CN 201710368274A CN 107315771 B CN107315771 B CN 107315771B
- Authority
- CN
- China
- Prior art keywords
- data
- dictionary
- item
- field
- display
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
- G06F16/212—Schema design and management with details for data modelling support
-
- 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
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a customization method of a data exchange system based on an extension base table data dictionary. The method comprises the following steps: 1) and expanding the data dictionary, wherein the expanded data dictionary comprises one or more of the following configuration information items: displaying data, verifying data, controlling functions of the data, and associating default values and data of the data; 2) generating a corresponding data dictionary template based on the expanded data dictionary; 3) for each information table to be submitted, inputting relevant data according to the requirements of the data dictionary template; 4) checking the data in the data dictionary template, importing the data into a database of a data exchange system in batches, and automatically completing the establishment of an exchange information table of a physical database according to the structure setting information in the data dictionary; 5) and constructing a data interchange driving engine and a data interchange system, and completing the online interchange function of various types of interchange data tables. The invention can perform refined and customized control aiming at the functions of the data collection and management system.
Description
Technical Field
The invention belongs to the technical field of information technology and data interchange, relates to a method for customizing management in the implementation of a data interchange system, and particularly relates to a method for customizing a data interchange system based on an expansion base table data dictionary.
Background
At present, data exchange is one of the main ways of centralized standardized collection and management of data resources, and with the development of informatization and networked society, the construction requirements of centralized opening, sharing and service of data resources are more and more common. Various levels and types of data are produced by online delivery systems.
Through the data collection system, local data resources distributed under different data sources can be quickly collected, organized, audited and stored to form a complete data resource pool and a resource catalog. This lays the foundation of resources for centralized data sharing and service. The current data collection system has the following four characteristics:
1. system framework layer: a Web-based online transaction mode is generally adopted, and a B/S framework is used in the system.
2. And (4) functional layer: the management mode and the functions are relatively basic and unified, the functions of online data addition, deletion, modification, Checking (CURD) and the like are generally provided, and partial systems provide a batch data import function; meanwhile, the system has a certain data quality checking and auditing function.
3. And (3) data type level: most data collection systems realize centralized collection management of multi-type data resources (such as research data, equipment data, intellectual property data and the like) according to business needs.
4. From the storage level: since the exchange system is generally uniform in structure, a structured Relational Database (RDB) is generally used for storing data. Each type of data resource can generally complete the management of the whole data content by using one data table.
Based on the characteristics, when the convergence system is implemented, if the convergence function of each data type is specially developed, the method has great limitation and repeatability, cannot meet the requirement of dynamic expansion of future service data resource types on one hand, and increases the redundancy and complexity of system development. Most of the current data exchange systems thus allow for supporting dynamic extensions of data types and ensuring multiplexing of functions.
The development of a data exchange system based on a database table dictionary is a common mode which supports dynamic expansion of exchange data types and realizes function multiplexing at present. The physical storage table of the exchange data can be dynamically established during system initialization through the database table dictionary, and each exchange data type can be ensured to correspond to an effective physical table according to the data content. Meanwhile, the unified realization of online addition, deletion, modification and Check (CURD) functions of data can be realized based on the database table dictionary, namely the separation of the application program development and the database table structure is realized. The online editing control type is determined according to the data type, the control format and the input range are constrained according to the field length, the field name and the like are displayed through the Chinese name, and the full-field combined query function of the data table can be realized based on the dictionary. Therefore, the efficiency of software development is improved, the development cycle of software is shortened, and the software is multiplexed (Xuyonglong, lie, Guo Happon, and the like.) meanwhile, the design and development of a geological data acquisition system driven by a data dictionary [ J ]. mapping engineering, 2014,23(10):41-44. Wangduang, Zhang armonian, Wangsuper, and the research of a general development platform based on the data dictionary [ J ]. microcomputer application, 2010,26(5):5+25-28 ].
However, the current data exchange system has great defects in the aspects of general and refined data exchange customized management, which are specifically represented as follows:
1. and (3) displaying data: the customized management of data display items is not supported, and the customized display management of data contents and formats is not supported.
2. Data verification: and the verification management of customized data entry items and data ranges is not supported.
3. Data function control range: customized control management of data item ranges in functions such as editing, querying, importing, exporting is not supported.
4. Data default values: customized automatic setting management of data defaults is not supported.
5. Data association: customized association of enumeration dictionaries for data items and customized association of data taxonomies are not supported.
Disclosure of Invention
Aiming at the problems of the conventional data exchange system in the aspects of universal and refined data exchange customized management, the invention provides a data exchange system customized method based on an extension base table data dictionary, and the method realizes the refined and customized control of the functions of the data exchange management system.
The technical scheme adopted by the invention is as follows:
a customization method of a data exchange system based on an expander table data dictionary comprises the following steps:
1) expanding a data dictionary in the data exchange system, wherein the expanded data dictionary comprises one or more of the following configuration information items: displaying data, verifying data, controlling functions of the data, and associating default values and data of the data;
2) generating a corresponding data dictionary template based on the expanded data dictionary;
3) for each information table to be submitted, inputting relevant data item by item according to the requirements of the data dictionary template;
4) checking the data in the data dictionary template, importing the data into a database of a data exchange system in batches, and automatically completing the establishment of an exchange information table of a physical database according to the structure setting information in the data dictionary;
5) and constructing a data interchange driving engine and a data interchange system based on the expanded data dictionary, and further completing the online interchange function of various types of interchange data tables.
Further, the expanded data dictionary in step 1) includes three tables, which are:
a) table 1-table field setting table: setting information of all fields in the key configuration data table comprises traditional table structure information and one or more application configuration information items of data display, verification, function control, default values and association.
b) Table 2-table classification settings table: the method mainly configures tree classification relation of the implementation table information for realizing data table list navigation control and display based on the table classification tree;
c) table 3-table field enumeration settings table: the key configuration realizes the display and storage information of enumerated fields in the table 1;
where table 1 is associated with table 2 by a table code column and table 1 is associated with table 3 by an enumerated identifier.
Further, the following fields are included in table 1: mandatory item, entry item serial number, list display item serial number, detailed view item serial number, query item serial number, sorting item serial number, automatic entry, range verification, single selection enumeration and character string display format.
Further, the following fields are included in table 2: table code, table name, classification code, classification name, parent classification code, parent classification name.
Further, the following fields are included in table 3: enumerating identification, enumerating Chinese names, enumerating value serial numbers, enumerating display values, enumerating storage values and enumerating value meaning description.
Further, the method for generating the data dictionary template in the step 2) is as follows: and generating three different sheets through Excel, wherein the three different sheets correspond to the three tables respectively, and a data dictionary template is formed in each sheet according to the Chinese name of the field, the English name of the field and whether the filling is necessary.
Further, step 3) directly enters the data of the three tables of the data dictionary without adopting a data dictionary template.
Further, step 4) adopts the MVC design mode to realize a driving engine of the data dictionary.
Further, when all function control and verification related to the intersection are achieved in the controller, the setting data of the related extended data dictionary are read respectively, dynamic packaging and setting of the data model are completed, and finally the data model is transmitted to different views to be displayed and output.
The invention has the following beneficial effects:
the invention further refines and realizes the decoupling of the software system function and the control parameter setting, thereby greatly improving the efficiency of the design and development of the multi-type large-scale data convergence system, shortening the development period of the software and enhancing the customizability and high reusability of the system. The decoupling is to separate the code implementation from the customizable control logic in the software system development, rather than mixing the two together, so that the code function is single and cannot be multiplexed, and the customized control cannot be realized. Through decoupling design, independent general control logic customized setting can be abstracted and abstracted, and general customized control of the system is realized.
Drawings
FIG. 1 is a diagram of the overall process and data flow relationships of the method of the present invention.
FIG. 2 is a diagram of a three table template design based on Excel.
FIG. 3 is a diagram of a sample design of a partial table template item based on Excel.
Fig. 4 is a schematic diagram of an MVC framework design pattern of an application.
Fig. 5 is a schematic diagram of display of implementation data in the embodiment.
FIG. 6 is a schematic diagram of an embodiment of checking data.
Fig. 7 is a schematic diagram of function control for realizing data in the embodiment.
FIG. 8 is a diagram illustrating default value population of implementation data in an embodiment.
Fig. 9 is one of diagrams of enumerated value settings of implementation data in the embodiment.
Fig. 10 is a second schematic diagram of setting an enumeration value of implementation data in the embodiment.
Fig. 11 is a schematic diagram of implementing classification-associated control of data in the embodiment.
Detailed Description
The present invention will be described in further detail below with reference to specific examples and the accompanying drawings.
The invention discloses a customizing method of a data exchange system based on an extension base table data dictionary, which has the general flow and data flow relation shown in figure 1 and comprises the following steps:
1. and (3) generating a data dictionary template: and generating a corresponding data dictionary template by a system manager according to the data dictionary design.
1) Design of data dictionary
The data dictionary design of the invention comprises the following three tables which are respectively:
a) table 1-table field setting table: and setting information of all fields in the data table is configured in a key mode. Besides traditional table structure information, the part expands application configuration information items such as function control, display, verification, association and the like based on the table.
b) Table 2-table classification settings table: the method mainly configures the tree classification relation of the implementation table information, and is usually used for realizing the navigation control and display of the data table list based on the table classification tree. The table classification tree-based data table list navigation means that a user clicks a certain node in the table classification tree and can view all data table lists under the corresponding node.
c) Table 3-table field enumeration settings table: the key configuration implements the display and storage information of the enumerated fields in table 1.
Wherein: items 11-20 in table 1, table 2 and table 3 are extensions to the conventional data dictionary; table 1 and table 2 are associated by a table code column, and table 1 and table 3 are associated by a single-choice enumeration column (enumeration flag).
The arrangement and description of the data items of the specific tables are shown in tables 1 to 3.
Table 1 table field setting table
Table 2 table classification setting table
Table 3 table field enumeration setup table
2) Data dictionary template design
Based on the data dictionary, a corresponding data dictionary template is designed and generated, and three different sheets are generated in a common mode, such as through Excel, and respectively correspond to the three tables, as shown in fig. 2. The template item formed in each sheet by the Chinese name of the field, the English name of the field, and whether padding is necessary (and description of the padded content) is shown in FIG. 3.
2. Data dictionary template entry
And filling relevant data into each information table to be submitted item by item according to the requirements of the data dictionary template and the requirements of the three table templates by system designers.
3. Data dictionary warehousing and database initialization
The system leads template data of the data dictionary into a system database in batch after checking and checking, and simultaneously automatically completes the establishment of an information table of the system physical database according to the structure setting information in the data dictionary.
The checking check is mainly a special check set for each data column rule of the data dictionary template (see data dictionary description). And the checking program automatically reads each column of the template and judges whether the data recorded in each column meets the requirements or not. Specifically, if the necessary column has null data, and if the specific check column data is consistent with the requirement, if the specific check column data is automatically recorded into the column, when the user fills in the non-null data, only one of cyear, cdate, ctime and cuser can be recorded; and sequencing item sequence number columns, when a user inputs non-null data, only integer numbers larger than 0 can be filled in, no repeated sequence numbers exist, and the like.
The physical database collection information table is a physical table established in a database system based on the data in the data dictionary table 1, adopts the prior art, and can be automatically established after being automatically converted into a create table statement of SQL.
4. Data dictionary driven engine implementation
At present, in the aspect of Web application development, the design mode of mvc (model View controller) is commonly adopted, as shown in fig. 4. The database part corresponds to the data dictionary, the Model (Model) is a part for processing application data logic in the application program, the Controller (Controller) is a part for processing user interaction in the application program, and the View (View) is a part for processing data display in the application program.
Because the data dictionary comprises application-related data display, data verification, data function control, data default values and data association setting, when all function control and verification such as addition, deletion, modification, Checking (CURD), batch import, export, data verification and the like related to exchange are realized in a control layer (controller), the setting data of the related extended data dictionary can be read respectively, the dynamic packaging and setting of the data model are completed, and finally the data model is transmitted to different views such as an editing page, a list page, a detail page and the like for display and output.
5. Data rendezvous system service
And (3) logging in the transaction system by the end user to complete the online transaction function of each type of transaction information table, such as addition, deletion, modification, Checking (CURD), batch import, export, data verification and the like, and the transaction data is gathered in each transaction information table to complete the online transaction of the data.
The following describes how to implement customized control and management of data display, data verification, data function control, data default and data association by specific examples.
[1] And (3) displaying data:
1) as shown in the experimental data setup of fig. 5, after the user sets the "entry/template item serial number (templetIn) column" of table 1 (table field setup table), the entry controls of the relevant fields (with a drop-down list for enumeration association, a special control for time and date, a character type more than 100 length, a multi-line text for other text, and a single-line text for mandatory item) are sequentially displayed in the order of the column setup serial number from small to large in the data online entry and edit page of the B11 table in the aggregation system. Similarly, the user sets the "list display item number (listShow) column" in table 1, and then displays all data in the list display page of the B11 table in the delivery system in the order of displaying name, job title, job position, and job category; the user sets the "detailed item sequence number (detail show) column" of table 1, and in the detailed information display page in the delivery system that displays a certain piece of data of the B11 table, the data values of the relevant fields are displayed in order from small to large of the set sequence number.
2) A user sets a 'string display format (strFormat)' column of table 1, and when the column of data is displayed, the column of data is set as a text and then is normally displayed; if the URL is set, the URL is displayed as a hyperlinked URL string; if the HTML is set, the HTML is displayed as a display text after HTML analysis; setting as a file, displaying an icon which can have a downloading function; if the picture is set, the related picture file is directly displayed on line; and if the audio and video are set, the online audio or video player is opened, and online playing of the related video is provided for the user.
[2] And (3) checking the data:
1) as shown in the experimental data setting of fig. 6, after a user sets "field type (attrType) column" and "field length (attrLength) column" of table 1 (table field setting table), the B11 table in the aggregation system will respectively verify whether the format and length of data in corresponding columns meet the setting requirements according to the setting when the data is entered, edited on-line and template data is imported;
2) after a user sets a 'required item (mustIn) column' of the table 1, a B11 table in the convergence system checks whether data of the column corresponding to a required item 1 is empty according to the setting when the data are input and edited on line and template data are input;
3) after the user sets the "check range (chkRange) column" in Table 1, the B11 table in the exchange system checks whether the data in the corresponding column meets the set data range rule according to the setting when the data are entered and edited on line and the template data are imported.
[3] Function control of data:
as shown in the experimental data setting of fig. 7, after the user sets the "query item number (queryShow) column" of table 1 (table field setting table), in the query page of the B11 table in the data interchange system, the function of querying by station code and by person name can be automatically formed. Also after the user sets the "rank order number (orderNo) column" of table 1, a default rank by job date, name, date of birth order is automatically formed in the data list page of table B11 in the data aggregation system.
[4] Default value population:
1) as shown in the experimental data setting of table 1 (table field setting table) in fig. 8, after the user sets "Primary Key (PK) column" of GUID field of B11 table to 2, when new data of B11 table is submitted in the data exchange system, the system automatically forms a primary key value serial number;
2) after the user sets the "automatic entry (automatic in) column" in table 1, when new or edited data is added to the B11 table in the data exchange system, the system automatically fills the data of the relevant fields according to the setting. When set to cyear, automatically fill the current year; when set to cdate, automatically fill in the current date; when the time is set to ctime, the current time is automatically filled; when set to cuser, the current user code is automatically populated.
[5] Setting an enumeration value:
as shown in the experimental data setting of table 1 (table field setting table) in fig. 9, the user sets the enumeration identifier of the "single enumeration (singleton) column" of the B11 table gender, job title, and job category fields, and when the data aggregation system reads the enumeration data, the corresponding enumeration data of table 3 (table field enumeration setting table) will be automatically read according to the set identifier (see the experimental data setting of table 3 in fig. 10).
[6] And (3) classification association control:
in table 2, i.e., the table classification setting table (see the experimental data setting of table 2 in fig. 11), the mapping relationship between the table code and the codes of the classification and parent classification is set. The data interchange system can support the realization of the navigation of the classification tree to the related interchange information table set, so that a user can refine and check the corresponding data table step by step through the classification tree and perform various operations, such as listing, adding, deleting, modifying, checking and the like.
The template in the above embodiment is designed to facilitate the batch import operation and verification of the three dictionary table data. In the concrete implementation, the user can directly input the data of the three dictionary tables without adopting a template. However, it should be noted that since no automatic verification of the dictionary data is performed by the program, the validity of each dictionary data needs to be checked by the user, otherwise, the data after being put in storage cannot be used, and therefore, a mode of directly inputting the dictionary data is not recommended. The data method for directly inputting the three dictionary tables comprises the steps of directly writing the three tables after inserting SQL sentences in batch and directly running if a database client tool is used; directly operating the three tables to input data one by one; and directly utilizing the batch import function of the database client tool to import data and the like through organized formats such as excle, csv, xml, SQL, txt and the like.
The above embodiments are only intended to illustrate the technical solution of the present invention and not to limit the same, and a person skilled in the art can modify the technical solution of the present invention or substitute the same without departing from the spirit and scope of the present invention, and the scope of the present invention should be determined by the claims.
Claims (5)
1. A customization method of a data exchange system based on an expander table data dictionary comprises the following steps:
1) expanding a data dictionary in the data exchange system, wherein the expanded data dictionary comprises one or more of the following configuration information items: displaying data, verifying data, controlling functions of the data, and associating default values and data of the data;
2) generating a corresponding data dictionary template based on the expanded data dictionary;
3) for each information table to be submitted, inputting relevant data item by item according to the requirements of the data dictionary template;
4) checking the data in the data dictionary template, importing the data into a database of a data exchange system in batches, and automatically completing the establishment of an exchange information table of a physical database according to the structure setting information in the data dictionary;
5) constructing a data interchange driving engine and a data interchange system based on the expanded data dictionary, and further completing the online interchange function of various types of interchange data tables;
the data dictionary expanded in the step 1) comprises three tables which are respectively as follows:
a) table 1-table field setting table: setting information of all fields in the key configuration data table comprises traditional table structure information and one or more application configuration information items in data display, verification, function control, default values and association;
b) table 2-table classification settings table: the method mainly configures tree classification relation of the implementation table information for realizing data table list navigation control and display based on the table classification tree; the following fields are included in table 2: table code, table name, classification code, classification name, parent classification code, parent classification name;
c) table 3-table field enumeration settings table: the key configuration realizes the display and storage information of enumerated fields in the table 1; the following fields are included in table 3: enumerating identification, enumerating Chinese names, enumerating value serial numbers, enumerating display values, enumerating storage values and enumerating value meaning description;
wherein, the table 1 and the table 2 are associated through a table code column, and the table 1 and the table 3 are associated through an enumeration identifier;
the following fields are included in table 1: table code, field serial number, field code, field name, field type, field length, field decimal place, metering unit, filling description or remark, main key, indispensable item, entry item/template item serial number, list display item serial number, detailed browsing item serial number, query item serial number, sorting item serial number, automatic entry, range check, single selection enumeration and character string display format; wherein:
field sequence number: the sort order of the data table field outputs;
a main key: default to null, i.e. non-primary key; 1-manual recording; 2-automatic serial number;
the mandatory item: whether it is not empty, 1-yes, 0-no; marking non-empty items in the newly added and edited pages, and checking and prompting item by item according to setting when data are submitted;
entry item/template item sequence number: whether the data entry items are data entry items and the arrangement sequence; filling numbers, namely representing 'yes', to indicate that the data items are imported through an Excel generation template or input data in an online filling mode, wherein the numbers represent display arrangement sequence; list display item number: whether the display items and the arrangement sequence of the overview list page are displayed or not is judged, and if yes, the field and the data are displayed on the overview list page, wherein the numbers represent the display arrangement sequence;
detailed item number: whether the display items and the arrangement sequence of the single data detail page are filled with numbers represents yes, the field and the data are displayed on the detail page, wherein the numbers represent the display arrangement sequence;
the sequence number of the query item: whether the display items and the arrangement sequence of the field query conditions are displayed or not, and if the display items and the arrangement sequence of the field query conditions are filled with numbers, the display items and the arrangement sequence represent yes, and the fact that a user can query data by taking the field as the query conditions is shown, wherein the numbers represent the display arrangement sequence;
sequence number of the sequencing item: whether the items are the sequencing items or not is established, and the priority of the sequencing items is controlled by setting different integers;
automatic recording: i.e., field defaults including cyear-current year, cdate-current date, ctime-current time, cuser-current user identification;
single selection enumeration: corresponding to the enumerated identifications in table 3.
2. The method of claim 1, wherein the step 2) of generating the data dictionary template is by: and generating three different sheets through Excel, wherein the three different sheets correspond to the three tables respectively, and a data dictionary template is formed in each sheet according to the Chinese name of the field, the English name of the field and whether the filling is necessary.
3. The method of claim 1, wherein step 3) directly enters data of three tables of the data dictionary without using a data dictionary template.
4. The method of claim 1, wherein step 4) implements a driver engine of the data dictionary using the MVC design pattern.
5. The method of claim 4, wherein when all function control and verification related to the convergence are implemented in the controller, the setting data of the related extended data dictionary is read respectively, the dynamic packaging and setting of the data model are completed, and finally the data model is transmitted to different views for display and output.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710368274.XA CN107315771B (en) | 2017-05-23 | 2017-05-23 | Data exchange system customization method based on database table data dictionary |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710368274.XA CN107315771B (en) | 2017-05-23 | 2017-05-23 | Data exchange system customization method based on database table data dictionary |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107315771A CN107315771A (en) | 2017-11-03 |
CN107315771B true CN107315771B (en) | 2021-03-30 |
Family
ID=60183873
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710368274.XA Active CN107315771B (en) | 2017-05-23 | 2017-05-23 | Data exchange system customization method based on database table data dictionary |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107315771B (en) |
Families Citing this family (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107908725A (en) * | 2017-11-14 | 2018-04-13 | 中国银行股份有限公司 | A kind of batch data method of calibration, device and system |
CN108280193A (en) * | 2018-01-26 | 2018-07-13 | 北京金雨科创自动化技术股份有限公司 | By importing data come the method and system of Fast Construction product database |
CN110309175B (en) * | 2018-03-02 | 2021-12-03 | 北大方正集团有限公司 | Tool book checking method and tool book checking device |
CN108920638A (en) * | 2018-07-02 | 2018-11-30 | 山东浪潮商用***有限公司 | Web terminal data collector file method and device based on data dictionary configuration |
CN109344306B (en) * | 2018-07-27 | 2021-12-10 | 中国科学院计算机网络信息中心 | Method and system for customized online transaction and service of field multi-standard metadata |
CN110858367A (en) * | 2018-08-24 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Sales information storage method and device |
CN109408792B (en) * | 2018-10-19 | 2023-07-04 | 中国银行股份有限公司 | Customer information complement method and device |
CN109472007B (en) * | 2018-11-09 | 2024-01-19 | 贵州医渡云技术有限公司 | Automatic question creating method and device for medical questionnaire, electronic equipment and storage medium |
CN109783779B (en) * | 2018-12-27 | 2023-12-22 | 北京航天福道高技术股份有限公司 | Tool for importing, exporting and converting data EXCEL |
CN110059078B (en) * | 2019-04-19 | 2022-11-15 | 中国航空无线电电子研究所 | Dynamic configuration and verification method for customized data of navigation database |
CN110674136B (en) * | 2019-09-19 | 2023-04-28 | 浪潮通用软件有限公司 | Method and system for dynamically organizing data columns according to data in database |
CN111598535B (en) * | 2020-05-09 | 2023-06-13 | 西安精雕软件科技有限公司 | Basic material importing method, system and computer equipment |
CN113536041B (en) * | 2021-06-08 | 2022-07-12 | 中国铁路设计集团有限公司 | Method for rapidly acquiring railway engineering geographic information metadata in batches |
CN114329107B (en) * | 2021-12-31 | 2024-07-23 | 浙江力石科技股份有限公司 | Multi-data source joint query method based on global data dictionary |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105512211A (en) * | 2015-11-30 | 2016-04-20 | 河北远东通信***工程有限公司 | Dynamically-extensible database design method |
CN105677346A (en) * | 2016-01-04 | 2016-06-15 | 浪潮软件集团有限公司 | Dynamic expansion method of web interface and server |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10417248B2 (en) * | 2015-09-01 | 2019-09-17 | Sap Se | Field extension in database system |
-
2017
- 2017-05-23 CN CN201710368274.XA patent/CN107315771B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105512211A (en) * | 2015-11-30 | 2016-04-20 | 河北远东通信***工程有限公司 | Dynamically-extensible database design method |
CN105677346A (en) * | 2016-01-04 | 2016-06-15 | 浪潮软件集团有限公司 | Dynamic expansion method of web interface and server |
Also Published As
Publication number | Publication date |
---|---|
CN107315771A (en) | 2017-11-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107315771B (en) | Data exchange system customization method based on database table data dictionary | |
JP3842573B2 (en) | Structured document search method, structured document management apparatus and program | |
US8429519B2 (en) | Presentation generator | |
US8127224B2 (en) | System for creating and editing mark up language forms and documents | |
US7698167B2 (en) | Catalog building method and system | |
US7165073B2 (en) | Dynamic, hierarchical data exchange system | |
CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
US20060064428A1 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
CN101788994A (en) | Method for constructing data display model and method and device for displaying data | |
KR20090005097A (en) | Systems and methods of transforming data for web communities and web applications | |
CN114035773A (en) | Configuration-based low-code form development method, system and device | |
CN106021394A (en) | Website construction method and apparatus | |
KR100522186B1 (en) | Methods for dynamically building the home page and Apparatus embodied on the web therefor | |
JP3842576B2 (en) | Structured document editing method and structured document editing system | |
Belić et al. | Model of a user friendly system for library cataloguing | |
JP3842572B2 (en) | Structured document management method, structured document management apparatus and program | |
Elsheh et al. | Using database metadata and its semantics to generate automatic and dynamic web entry forms in | |
Miles et al. | Drupal's Building Blocks: Quickly Building Web Sites with CCK, Views and Panels | |
CN114281920A (en) | Theme content structured management method and system based on document set | |
Ousterhout | Fiz: A component framework for web applications | |
JP2004038496A (en) | Xml document preparing system | |
Canós | A bibliography manager for microsoft word | |
US20070150523A1 (en) | Method for the creation of a documentary chain and the updating thereof based on a structured model | |
JP2004341770A (en) | Data management system and data management method | |
Roberts et al. | Designing Forms for SharePoint and InfoPath: Using InfoPath Designer 2010 |
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 |