CN107315771A - A kind of data collection system customization method based on expanding library table data dictionary - Google Patents
A kind of data collection system customization method based on expanding library table data dictionary Download PDFInfo
- Publication number
- CN107315771A CN107315771A CN201710368274.XA CN201710368274A CN107315771A CN 107315771 A CN107315771 A CN 107315771A CN 201710368274 A CN201710368274 A CN 201710368274A CN 107315771 A CN107315771 A CN 107315771A
- Authority
- CN
- China
- Prior art keywords
- data
- dictionary
- data dictionary
- junction
- collection system
- 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
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 present invention relates to a kind of data collection system customization method based on expanding library table data dictionary.This method includes:1) data dictionary is extended, the data dictionary after extension includes the one or more in following configuration information:The display of data, the verification of data, the function control of data, the default value and data correlation of data;2) data dictionary based on extension generates corresponding data dictionary template;3) to each information table for treating junction, according to the requirement typing related data of data dictionary template;4) data in data dictionary template are carried out with verification inspection, and batch is imported in the database of data collection system, then the structure placement information in data dictionary is automatically performed the foundation of physical database junction information table;5) data collection driving engine and data collection system are built, the online junction function of all types of junction tables of data is completed.The present invention can be become more meticulous for the function of data collection management system, customize control.
Description
Technical field
The invention belongs to information technology, data collection technical field, it is related to and customizes pipe in the realization of data collection system
A kind of method of reason, and in particular to data collection system customization method based on expanding library table data dictionary.
Background technology
At present, data collection is one of major way of data resource centralization standardization collection management, with informationization
With the development of Network Society, data resource centralization is open, shared, service construction demand is more and more universal.Various levels
Arisen at the historic moment with the online data junction system of type.
By data collection system, can will be distributed over the lower local data's resource progress fast convergence in different pieces of information source,
Tissue, examination & verification, storage form complete data resource pond, Resource TOC.This is centralized data sharing and service, has established money
The basis in source.Current data collection system has following four feature:
1st, system framework aspect:The online junction pattern based on Web is generally used, system uses B/S frameworks.
2nd, functional plane:Management mode and function comparative basis and uniformly, generally all provide the online increasing of data, delete, change,
Functions such as (CURD) is looked into, part system provides batch data import feature;There is certain quality of data verification and examination & verification simultaneously
Function.
3rd, data type aspect:Most of data collection systems need all to realize diversiform data resource according to business
(such as:Data, device data, intellectual property data etc.) concentration junction management.
4th, from storage aspect:Because the usual structure of junction system is unified, generally using the relational database (RDB) of structuring
Carry out the storage of data.Each type data resource can generally complete the management of total data content with a tables of data.
Based on above feature, when junction system is realized, if the junction function for every kind of data type is carried out specially
Exploitation, will have significant limitation and repeatability, on the one hand can not meet future services data resource type dynamic expansion
Demand, while adding the redundancy and complexity of system development.Therefore current data collection system largely all take into account
Support the dynamic expansion of data type and the multiplexing of assurance function.
Wherein, the exploitation for carrying out data collection system based on database table dictionary is current support junction data type dynamic
Extension, and realize the common schema of multiplexing functions.Junction can dynamically be set up in system initialization by database table dictionary
The physical storage table of data, it is ensured that every kind of junction data type can according to its data content correspondence one effective physics
Table.The unified realization for the online increasing of data can be realized based on database table dictionary simultaneously, deleting, change, look into (CURD) function, i.e., it is real
Show application development to separate with database table structure.Online editing control type is such as determined according to data type, according to word
Segment length bound control form and typing scope, by Chinese display field title etc., and can be realized based on dictionary
The full word section query composition function of tables of data.So as to lift the efficiency of software development, shorten the construction cycle of software, realize simultaneously
Multiplexing (Xu Yonglong, Li Bin, the Guo Haipeng, Geological data collecting systematic design idea [J] for waiting data dictionaries to drive of software
Surveying Engineering, 2014,23 (10):41-44. Wang De are wide, Zhang Junzu, and universal developing platforms of the Wang Chao based on data dictionary is ground
Study carefully [J] microcomputer applications, 2010,26 (5):5+25-28.).
But current data collection system customizes management aspect in data collection that is general and becoming more meticulous also to be present very
Big deficiency, is embodied in:
1st, data display:Do not support the customization management of data display, data content, the customization of form are not supported
Display management.
2nd, data check:Do not support data inputting, the verification management of data area customized.
3rd, data function control range:Do not support such as the customization of data item scope in editor, inquiry, importing, export function
Change control management.
4th, data default value:Do not support the customization of data default value that management is set automatically.
5th, data correlation:Do not support data item enumerate dictionary customization association, and data taxonomic hierarchies customization
Change association.
The content of the invention
The problem of management aspect is present is customized in data collection that is general and becoming more meticulous for current data junction system,
The present invention proposes a kind of data collection system customization method based on expanding library table data dictionary, the method achieve and is directed to
The function of data collection management system is become more meticulous, customizes control.
The technical solution adopted by the present invention is as follows:
A kind of data collection system customization method based on expanding library table data dictionary, its step includes:
1) data dictionary in data collection system is extended, the data dictionary after extension includes following configuration information
One or more in:The display of data, the verification of data, the function control of data, the default value and data correlation of data;
2) data dictionary based on extension, generates corresponding data dictionary template;
3) to each information table for treating junction, according to the requirement typing related data item by item of data dictionary template;
4) data in data dictionary template are carried out with verification inspection, and batch imports the database of data collection system
In, then the structure placement information in data dictionary is automatically performed the foundation of physical database junction information table;
5) the data collection driving engine and data collection system of the data dictionary based on extension are built, and then is completed all kinds of
The online junction function of the junction tables of data of type.
Further, step 1) in extend after data dictionary include three tables, be respectively:
A) table 1- literary name sections set table:The configuration information of whole fields in emphasis configuration data table, including traditional table knot
One or more application configuration informations in structure information, and the displays of data, verification, function control, default value, association.
B) table 2- table sorts set table:Emphasis configures the tree-shaped classification relation for realizing table information, for realizing based on table point
The control of tables of data lists navigation and displaying of class tree;
C) table 3- literary name sections enumerate setting table:The display of enumerated field and storage information in table 1 are realized in emphasis configuration;
Wherein table 1 is associated with table 2 by table code row, and table 1 and table 3 are associated by enumerating mark.
Further, the table 1 includes following field:Required item, entry item sequence number, list display sequence number, carefully look at
Item sequence number, query term sequence number, order item sequence number, automatic input, range check, single choice are enumerated, character string display form.
Further, the table 2 includes following field:Table code, table name, Sort Code, specific name, parent category
Code, parent category title.
Further, the table 3 includes following field:Mark is enumerated, Chinese, enumerated value sequence number is enumerated, enumerates
Show value, enumerate storage value, enumerated value implication explanation.
Further, step 2) generation data dictionary template method be:Three different sheet are generated by Excel,
Respectively correspond to it is corresponding with three tables, in each sheet by field Chinese name, field English name, whether must fill out, formation data word
Allusion quotation template.
Further, step 3) data dictionary template is not used, and directly enter the data of three tables of data dictionary.
Further, step 4) the driving engine of data dictionary is realized using MVC design pattern.
Further, when realizing the related repertoire control of junction in the controller with verification, related expand is read respectively
The setting data of data dictionary are opened up, dynamic encapsulation and the setting of data model is completed, and are finally transferred to different views and are shown
Show output.
Beneficial effects of the present invention are as follows:
Further refinement of the invention realizes the decoupling that software system function is set with control parameter, so as to improve energetically
The efficiency of polymorphic type large-scale data junction system design exploitation, shortens the construction cycle of software, enhances the customizable of system
Property and high durability.The decoupling refers to code is realized into the control logic phase point with customizable in software system development
From, rather than both are mixed, cause the single not reusable of code function, it is impossible to realize and customize control.Pass through decoupling
Design, can form independent general control logic with abstract refinement and customize setting, realize the versatile customizationization control of system.
Brief description of the drawings
Fig. 1 is the inventive method overall procedure and data flow graph of a relation.
Fig. 2 is three table stencil design figures based on Excel.
Fig. 3 is the part table template design sample figure based on Excel.
Fig. 4 is the MVC Frame Design pattern diagrams of application program.
Fig. 5 is the schematic diagram for the display that data are realized in embodiment.
Fig. 6 is the schematic diagram for the verification that data are realized in embodiment.
Fig. 7 is the schematic diagram for the function control that data are realized in embodiment.
Fig. 8 is the schematic diagram for the default value filling that data are realized in embodiment.
Fig. 9 is that one of schematic diagram that the enumerated value of data is set is realized in embodiment.
Figure 10 is two that the schematic diagram that the enumerated value of data is set is realized in embodiment.
Figure 11 is the schematic diagram for the classification associated control that data are realized in embodiment.
Embodiment
Below by specific embodiments and the drawings, the present invention is described in further details.
The data collection system customization method based on expanding library table data dictionary of the present invention, its overall procedure and data
Flow relation is as shown in figure 1, comprise the following steps:
1. data dictionary template generation:System manager designs according to data dictionary, generates corresponding data dictionary mould
Plate.
1) design of data dictionary
The data dictionary design of the present invention includes following three tables, is respectively:
A) table 1- literary name sections set table:The configuration information of whole fields in emphasis configuration data table.The part is except tradition
Table structural information outside, extend application configuration informations such as the function control based on table, display, verification, association.
B) table 2- table sorts set table:Emphasis configures the tree-shaped classification relation for realizing table information, is generally used for realization and is based on
The control of tables of data lists navigation and displaying of table sort tree.The tables of data lists navigation based on table sort tree, i.e. user's point
Some node in table sort tree is hit, the list for the total data table that can be checked under respective nodes.
C) table 3- literary name sections enumerate setting table:The display of enumerated field and storage information in table 1 are realized in emphasis configuration.
Wherein:11-20 in table 1, table 2 and table 3 be expansion to traditional data dictionary;Table 1 passes through table generation with table 2
Code row are associated, and table 1 and table 3 are associated by single choice enumeration column (enumerating mark).
The setting of specific table data item and explanation are as shown in 1-table of table 3.
The literary name section of table 1 sets table
The table sort of table 2 sets table
The literary name section of table 3 enumerates setting table
2) data dictionary stencil design
Based on data above dictionary, the corresponding data dictionary template of design generation, normal method such as generates three by Excel
Individual different sheet, it is corresponding corresponding with three tables respectively, as shown in Figure 2.Field Chinese name, field English are pressed in each sheet
Literary fame, whether must fill out (and to the explanation for the content inserted), form template as shown in Figure 3.
2. data dictionary template typing
System designer is according to the requirement of data dictionary template, to each information table for treating junction respectively by three table templates
It is required that, related data is inserted item by item.
3. data dictionary is put in storage and data library initialization
After system checks data dictionary template data through verification in batch import system database, while according to data word
Structure placement information in allusion quotation, is automatically performed the foundation of system physical database junction information table.
The verification is checked (to be said primarily directed to each data row rule setting of data dictionary template referring to data dictionary
It is bright) special verification.Checking routine reads each row of template and judges whether the data of wherein each column typing meet the requirements automatically.Tool
Body includes, such as must list whether there is assigning null data, whether specific verification column data with requiring consistent, such as automatic input row,
When user inserts non vacuum data, can only be in typing cyear, cdate, ctime, cuser tetra- one;Order item sequence number
Row, when user's typing non vacuum data, can be only filled with the integer number more than 0 and can not be with the presence of repetition sequence number etc..
The physical database junction information table refers to, based on the data of data dictionary table 1, is set up in Database Systems
Physical table, use prior art, can be built by being automatically converted into after SQL create table sentences automatic perform
It is vertical.
4. data dictionary drives engine implementation
At present in terms of web application exploitation, generally using MVC (Model View Controller) design mould
Formula, as shown in Figure 4.Wherein database part is corresponding with data dictionary, and model (Model) is that be used in application program handling should
With the part of routine data logic, controller (Controller) is the part of processing user mutual in application program, view
(View) it is processing data is shown in application program part.
Due to including in data dictionary using the display of related data, the verification of data, the function control of data, number
According to default value and data correlation set, therefore realize in key-course (controller) the related increasing of junction, delete, change, looking into
(CURD) when, the control of the repertoire such as batch importing, export, data check is with verification, related expanding data can be read respectively
The setting data of dictionary, complete dynamic encapsulation and the setting of data model, and be finally transferred to edit page, it is original list, thin
The different views such as the page of looking at carry out display output.
5. data collection system service
End user logs in the online junction function that junction system completes all types of junction information tables, such as increases, deletes, changes, looks into
(CURD), batch importing, export, data check etc., the convergence after junction complete online data into each junction information table
Junction.
Illustrate how to realize the display of data, the verification of data, the function control of data, data below by instantiation
Default value and data correlation these customize control and management.
[1] display of data:
1) as shown in being set Fig. 5 experimental data, user is provided with " entry item/template of table 1 (literary name section setting table)
Sequence number (templetIn) is arranged " after, then in junction system in the online data typing and edit page of B11 tables, it can be set by the row
Put sequence number order from small to large show successively the typing control of relevant field (wherein band enumerates the use drop-down list of association,
The special control of Time of Day, more than the character types multiline text of 100 length, other use single file text, and required item is referred to *
Show).Same user sets " list display sequence number (listShow) row " of table 1, then the list of B11 tables shows in junction system
Show in the page, total data can be shown by the order of display name, academic title, job overall, functional classification;User is provided with table 1
" sequence number (detailShow) of carefully looking at row ", then show that the details of certain data of B11 tables are shown in junction system
In the page, it will show the data value of relevant field successively by the order from small to large of sequence number is set.
2) user is provided with " character string display form (strFormat) " row of table 1, when the column data is shown, sets
Then normally shown for text;Be set to URL be then shown as can hyperlink URL string;It is set to HTML and is then shown as HTML parsings
Display text afterwards;It is set to file and then shows the icon can with download function;Being set to picture, then direct-on-line shows phase
Close picture file;Audio is set to, video etc. is then opened with audio or video player online, provides the user related video display frequency
Online broadcasting.
[2] verification of data:
1) as shown in being set Fig. 6 experimental data, user is provided with the " field type of table 1 (literary name section setting table)
(attrType) after row " and " field length (attrLength) row ", B11 tables are in online data typing, editor in junction system
And can verify the form and length of corresponding column data respectively according to the setting during template data importing and whether meet setting requirements;
2) user is provided with after " required item (mustIn) row " of table 1, in junction system B11 tables online data typing,
Whether the data for the row that editor and template data can be 1 according to the setting inspection correspondence required item when importing are empty;
3) user is provided with after " verification scope (chkRange) row " of table 1, and B11 tables are recorded in online data in junction system
Enter, edit and template data importing when can according to the setting check respective column data whether meet setting data area advise
Then.
[3] function control of data:
Shown in experimental data such as Fig. 7 is set, user is provided with " the query term sequence number of table 1 (literary name section setting table)
(queryShow) arrange " after, in data collection system in the query page of B11 tables, can automatically form by station code and by
The function of personnel's name lookup.Equally after user is provided with " order item sequence number (orderNo) row " of table 1, in data collection
In system in the data list page of B11 tables, automatically form by registration date, name, the default sort of date of birth order.
[4] default value is filled:
1) as shown in being set the experimental data of table 1 (literary name section setting table) in Fig. 8, user is provided with B11 table GUID fields
" major key (PK) row " be 2 after, in data collection system B11 tables increase newly data submit when, system automatically forms Major key stream
Water number;
2) user is provided with after " automatic input (autoIn) row " of table 1, and B11 tables are newly-increased in data collection system or compile
When collecting data submission, system fills the data of relevant field automatically according to setting.When being set to cyear, automatic filling is current
Time;When being set to cdate, current date is filled automatically;When being set to ctime, current time is filled automatically;Work as setting
During for cuser, current personal code work is filled automatically.
[5] enumerated value is set:
Shown in experimental data such as table 1 (literary name section setting table) in Fig. 9 is set, user is provided with B11 tables sex, Zhi Chenghe
" single choice enumerate (singEnum) row " of functional classification field enumerates mark, when data collection system reads and enumerates data general
Data are enumerated (see the experiment number of table in Figure 10 3 automatically according to the corresponding of mark reading table 3 (literary name section enumerates setting table) of setting
According to setting).
[6] classification associated control:
Be during table sort sets the table experimental data of table 2 (in see Figure 11 set) in table 2, there is provided table code and classification and
The mapping relations of the code of parent category.Then in data collection system, it can support to realize that classification tree navigates to related junction information
Table set, is refined by classification tree and checks corresponding tables of data and carry out various operations step by step for user, such as list, increase, delete,
Change, look into.
Template in above example be for the ease of three dictionary table data can batch import operation and examine and set
Meter.User can not also use template in implementing, and directly enter the data of three dictionary tables.But be noted that by
In without automatic Verification of the process program to dictionary data, every dictionary data validity needs to ask user's self-checking otherwise to enter
Data behind storehouse will be unable to use, therefore not recommend to directly enter the pattern of dictionary data.Directly enter the number of three dictionary tables
Include according to method, such as use database client ending tool, directly transported after directly writing the batch insertion SQL statement for three tables
OK;Directly operate three table logging datas one by one;Directly using the batch import function of database client ending tool, pass through tissue
The forms such as good excle, csv, xml, SQL, txt import data etc..
The above embodiments are merely illustrative of the technical solutions of the present invention rather than is limited, the ordinary skill of this area
Personnel can modify or equivalent substitution to technical scheme, without departing from the spirit and scope of the present invention, this
The protection domain of invention should be to be defined described in claims.
Claims (9)
1. a kind of data collection system customization method based on expanding library table data dictionary, its step includes:
1) data dictionary in data collection system is extended, the data dictionary after extension is included in following configuration information
One or more:The display of data, the verification of data, the function control of data, the default value and data correlation of data;
2) data dictionary based on extension, generates corresponding data dictionary template;
3) to each information table for treating junction, according to the requirement typing related data item by item of data dictionary template;
4) data in data dictionary template are carried out with verification inspection, and batch is imported in the database of data collection system, so
The structure placement information in data dictionary is automatically performed the foundation of physical database junction information table afterwards;
5) the data collection driving engine and data collection system of the data dictionary based on extension are built, and then is completed all types of
The online junction function of junction tables of data.
2. the method as described in claim 1, it is characterised in that step 1) in extend after data dictionary include three tables, point
It is not:
A) table 1- literary name sections set table:The configuration information of whole fields in emphasis configuration data table, including traditional table structure letter
One or more application configuration informations in breath, and the displays of data, verification, function control, default value, association.
B) table 2- table sorts set table:Emphasis configures the tree-shaped classification relation for realizing table information, and table sort tree is based on for realizing
Tables of data lists navigation control and show;
C) table 3- literary name sections enumerate setting table:The display of enumerated field and storage information in table 1 are realized in emphasis configuration;
Wherein table 1 is associated with table 2 by table code row, and table 1 and table 3 are associated by enumerating mark.
3. method as claimed in claim 2, it is characterised in that the table 1 includes following field:Required item, entry item sequence
Number, list display sequence number, a thin sequence number, query term sequence number, order item sequence number, automatic input, range check, the single choice piece of looking at
Act, character string display form.
4. method as claimed in claim 2, it is characterised in that the table 2 includes following field:Table code, table name, point
Category code, specific name, parent category code, parent category title.
5. method as claimed in claim 2, it is characterised in that the table 3 includes following field:In enumerating mark, enumerating
Literary fame claims, enumerated value sequence number, enumerates show value, enumerate storage value, enumerated value implication explanation.
6. method as claimed in claim 2, it is characterised in that step 2) method of generation data dictionary template is:Pass through
Excel generates three different sheet, corresponding corresponding with three tables respectively, and field Chinese name, field are pressed in each sheet
English name, whether must fill out, form data dictionary template.
7. method as claimed in claim 2, it is characterised in that step 3) data dictionary template is not used, and directly enter number
According to the data of three tables of dictionary.
8. the method as described in claim 1, it is characterised in that step 4) drive of data dictionary is realized using MVC design pattern
Dynamic engine.
9. method as claimed in claim 8, it is characterised in that realize in the controller the related repertoire control of junction with
During verification, the setting data of related expanding data dictionary are read respectively, complete dynamic encapsulation and the setting of data model, and finally
It is transferred to different views and carries out display 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 true CN107315771A (en) | 2017-11-03 |
CN107315771B 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) |
Cited By (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 |
CN108920638A (en) * | 2018-07-02 | 2018-11-30 | 山东浪潮商用***有限公司 | Web terminal data collector file method and device based on data dictionary configuration |
CN109344306A (en) * | 2018-07-27 | 2019-02-15 | 中国科学院计算机网络信息中心 | A kind of online junction of field multi-standard meta data customizingization and method of servicing and system |
CN109408792A (en) * | 2018-10-19 | 2019-03-01 | 中国银行股份有限公司 | A kind of customer information amended record method and device |
CN109472007A (en) * | 2018-11-09 | 2019-03-15 | 贵州医渡云技术有限公司 | Medical questionnaire builds topic method, apparatus, electronic equipment, storage medium automatically |
CN109783779A (en) * | 2018-12-27 | 2019-05-21 | 北京航天福道高技术股份有限公司 | A kind of data EXCEL imports and exports the tool of conversion |
CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
CN110309175A (en) * | 2018-03-02 | 2019-10-08 | 北大方正集团有限公司 | Reference book method of calibration and reference book calibration equipment |
CN110674136A (en) * | 2019-09-19 | 2020-01-10 | 山东浪潮通软信息科技有限公司 | Method and system for dynamically organizing data columns according to data in database |
CN110858367A (en) * | 2018-08-24 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Sales information storage method and device |
CN111598535A (en) * | 2020-05-09 | 2020-08-28 | 西安精雕软件科技有限公司 | Basic material importing method and system and computer equipment |
CN113536041A (en) * | 2021-06-08 | 2021-10-22 | 中国铁路设计集团有限公司 | Method for rapidly acquiring railway engineering geographic information metadata in batches |
CN114329107A (en) * | 2021-12-31 | 2022-04-12 | 浙江力石科技股份有限公司 | Multi-data-source joint query method based on global data dictionary |
Citations (3)
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 |
US20170060878A1 (en) * | 2015-09-01 | 2017-03-02 | Sap Se | Field Extension in Database System |
-
2017
- 2017-05-23 CN CN201710368274.XA patent/CN107315771B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170060878A1 (en) * | 2015-09-01 | 2017-03-02 | Sap Se | Field Extension in Database System |
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 |
Cited By (22)
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 |
CN110309175A (en) * | 2018-03-02 | 2019-10-08 | 北大方正集团有限公司 | Reference book method of calibration and reference book calibration equipment |
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 |
CN109344306A (en) * | 2018-07-27 | 2019-02-15 | 中国科学院计算机网络信息中心 | A kind of online junction of field multi-standard meta data customizingization and method of servicing and system |
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 |
CN109408792A (en) * | 2018-10-19 | 2019-03-01 | 中国银行股份有限公司 | A kind of customer information amended record method and device |
CN109408792B (en) * | 2018-10-19 | 2023-07-04 | 中国银行股份有限公司 | Customer information complement method and device |
CN109472007A (en) * | 2018-11-09 | 2019-03-15 | 贵州医渡云技术有限公司 | Medical questionnaire builds topic method, apparatus, electronic equipment, storage medium automatically |
CN109783779A (en) * | 2018-12-27 | 2019-05-21 | 北京航天福道高技术股份有限公司 | A kind of data EXCEL imports and exports the tool of conversion |
CN109783779B (en) * | 2018-12-27 | 2023-12-22 | 北京航天福道高技术股份有限公司 | Tool for importing, exporting and converting data EXCEL |
CN110059078A (en) * | 2019-04-19 | 2019-07-26 | 中国航空无线电电子研究所 | A kind of dynamic configuration and method of calibration of navigational route database customization data |
CN110059078B (en) * | 2019-04-19 | 2022-11-15 | 中国航空无线电电子研究所 | Dynamic configuration and verification method for customized data of navigation database |
CN110674136A (en) * | 2019-09-19 | 2020-01-10 | 山东浪潮通软信息科技有限公司 | Method and system for dynamically organizing data columns according to data in database |
CN110674136B (en) * | 2019-09-19 | 2023-04-28 | 浪潮通用软件有限公司 | Method and system for dynamically organizing data columns according to data in database |
CN111598535A (en) * | 2020-05-09 | 2020-08-28 | 西安精雕软件科技有限公司 | Basic material importing method and system and computer equipment |
CN111598535B (en) * | 2020-05-09 | 2023-06-13 | 西安精雕软件科技有限公司 | Basic material importing method, system and computer equipment |
CN113536041A (en) * | 2021-06-08 | 2021-10-22 | 中国铁路设计集团有限公司 | Method for rapidly acquiring railway engineering geographic information metadata in batches |
CN113536041B (en) * | 2021-06-08 | 2022-07-12 | 中国铁路设计集团有限公司 | Method for rapidly acquiring railway engineering geographic information metadata in batches |
CN114329107A (en) * | 2021-12-31 | 2022-04-12 | 浙江力石科技股份有限公司 | Multi-data-source joint query method based on global data dictionary |
Also Published As
Publication number | Publication date |
---|---|
CN107315771B (en) | 2021-03-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107315771A (en) | A kind of data collection system customization method based on expanding library table data dictionary | |
US7673282B2 (en) | Enterprise information unification | |
CN105849726B (en) | For efficiently supporting the general index of the extemporaneous inquiry by demixing marking data | |
US8954479B2 (en) | End-to-end interoperability and workflows from building architecture design to one or more simulations | |
CN101452503A (en) | Isomerization clinical medical information shared system and method | |
CN104881285B (en) | Code snippet mark and reuse system based on body | |
Firat | Information integration using contextual knowledge and ontology merging | |
CN103902439B (en) | The management method of a kind of test case, Apparatus and system | |
EP2300938A1 (en) | Method for representation of objects and relationships in databases, directories, and applications as sentences | |
CN103593335A (en) | Chinese semantic proofreading method based on ontology consistency verification and reasoning | |
CN108563431A (en) | Software development methodology, device, computer readable storage medium and electronic equipment | |
US20140280026A1 (en) | Method and Structure for Managing Multiple Electronic Forms and Their Records Using a Static Database | |
Di Iorio et al. | Dealing with structural patterns of XML documents | |
CN115408399A (en) | Blood relationship analysis method, device, equipment and storage medium based on SQL script | |
CN107944723A (en) | A kind of " Tujia " picture weaving in silk cultural resource classification annotation method and system based on body | |
CN104133680A (en) | Fast building method of ERP form module | |
US11010140B2 (en) | Integration of workflow and logical data objects using visual programming | |
Chakraborty et al. | Applying the grounded theory method to derive enterprise system requirements | |
CN103970900B (en) | Multi-dimensional cross data flexible management method and system based on industrial field | |
Tari et al. | Designing the reengineering service for the DOK federated database system | |
Lolong et al. | Domain Specific Language (DSL) development for desktop-based database application generator | |
CN103488639B (en) | A kind of querying method of XML data | |
Zhao et al. | A spreadsheet system based on data semantic object | |
Mou et al. | Visual orchestration and autonomous execution of distributed and heterogeneous computational biology pipelines | |
Patrascoiu et al. | Tableaux for diagrammatic reasoning |
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 |