CN109726204A - A kind of data information management method and device based on self-defining data table - Google Patents

A kind of data information management method and device based on self-defining data table Download PDF

Info

Publication number
CN109726204A
CN109726204A CN201811582126.9A CN201811582126A CN109726204A CN 109726204 A CN109726204 A CN 109726204A CN 201811582126 A CN201811582126 A CN 201811582126A CN 109726204 A CN109726204 A CN 109726204A
Authority
CN
China
Prior art keywords
data
data information
module
self
defining
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
Application number
CN201811582126.9A
Other languages
Chinese (zh)
Other versions
CN109726204B (en
Inventor
于冬青
曾燕东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Fenyuan Technology Co Ltd
Original Assignee
Shenzhen Fenyuan Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Shenzhen Fenyuan Technology Co Ltd filed Critical Shenzhen Fenyuan Technology Co Ltd
Priority to CN201811582126.9A priority Critical patent/CN109726204B/en
Priority to CN202211477527.4A priority patent/CN115827627A/en
Publication of CN109726204A publication Critical patent/CN109726204A/en
Application granted granted Critical
Publication of CN109726204B publication Critical patent/CN109726204B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a kind of data information management methods and device based on self-defining data table, and wherein method includes: to establish self-defining data table;Corresponding self-defining data table construction feature collection is chosen according to data information type;Data information is created according to feature set.A kind of data information management method and device based on self-defining data table of the present invention can customize tables of data and its contents in table, the data information feature request of different industries can flexibly be met, the regulatory requirement of the different classes of data of enterprises can also be met, and each tables of data is cited when creating data information, may specify must fill out constraint, whether unique constraint, the optional range of contents in table, certain particular entry content have the diversified constraint configuration such as subcharacter tables of data, and then operator's fault is effectively avoided, there is the case where more records, few record, wrong record.In addition, the information such as standardization, the Material Name of formatting, coding can be automatically generated according to the list item pieced together, the communication efficiency of enterprise is improved.

Description

A kind of data information management method and device based on self-defining data table
Technical field
The present invention relates to data information management, more specifically a kind of data information management based on self-defining data table Method and device.
Background technique
With the fast development of software technology and internet economy, software technology industry is also increasingly acute on manufacturing influence Increase, and as the development of business scale expands, also there is an urgent need to the various resources of production of therein, human resources for manufacturing enterprise It is effectively managed, it, by information system management means, is enterprise development that maximally efficient method, which is exactly by software management system, It escorts.
More widespread practice is exactly by all kinds of software management systems at present, and similar ERP, CRM etc. will produce number under line According to, the manual input system by way of document, from line under go on line, to realize electronization, information system management, improve number It is believed that the circulation of breath and shared, is finally reached and improves production efficiency purpose.Such as: the product information management module of ERP system, CRM The client information management module etc. of system, system default provide every profession and trade to some general data moulds of data data management Type can satisfy the most basic data management demand of enterprise, while also provide the customized mode of user, supplement some new numbers According to field, the personal management demand of different enterprises is solved.
Manual entry is taken in current system data input, and system lacks all kinds of effective verification means, and then leads The case where causing wrong record, recording less often occurs.And different operation personnel input habit is different, it is also possible to lead to data information format Multiplicity brings inconvenience to enterprises information communication aspect.In addition, data deficiency cognition degree of the management system to typing, Existing ERP commonly limits the discrimination of data uniqueness using encoding uniquely, but in practical applications, often due to operator Member's fault is easy two different codings of the same article typing, so all can band to subsequent production ordering, stock control Carry out serious influence.
Summary of the invention
It is an object of the invention to overcome the deficiencies of the prior art and provide a kind of data informations based on self-defining data table Management method and device.
To achieve the above object, the invention adopts the following technical scheme: a kind of data information based on self-defining data table Management method, which comprises
Establish self-defining data table;
Corresponding self-defining data table construction feature collection is chosen according to data information type;
Data information is created according to feature set.
Its further technical solution are as follows: described the step of establishing self-defining data table, specifically includes the following steps:
Define data table name;
Judge that table name whether there is, if so, the step of returning to the definition data table name, if it is not, then into described fixed The step of adopted data sheet field type;
Define data sheet field type;
Determine that whether contents in table is by customized mode typing in tables of data;
If so, the step of into the customized contents in table;
If it is not, then entering the step of configuration list item content-data obtains script;
Customized contents in table;
Judge whether contents in table repeats in tables of data;
If it is not, then saving contents in table;
It configures list item content-data and obtains script;
Whether legal verify script;
If so, saving script.
Its further technical solution are as follows: described that corresponding self-defining data table construction feature is chosen according to data information type The step of collection, specifically includes the following steps:
Multiple tables of data are chosen as a feature set;
To every section of characterizing definition constraint condition in feature set;
Naming rule is defined to feature set;
Whether judging characteristic concentration has repeated data table, if it is not, the step of then entering the preservation feature set;
Save feature set.
Its further technical solution are as follows: described the step of data information is created according to feature set, specifically includes the following steps:
Obtain the characteristic table in feature set;
Optional content in characteristic table is initialized;
Choosing value is carried out to every section of feature in characteristic table as needed after initialization;
The data information constituted after choosing value is verified and saved.
Its further technical solution are as follows: the step of data information constituted after described pair of choosing value is verified and is saved, Specifically includes the following steps:
Judge the feature field that must be filled out in data information whether all assignment, if it is not, assignment prompt is then provided, if so, into The step of extraction uniqueness characteristic field generates data information unique KEY according to setting format;
It extracts uniqueness characteristic field and generates the unique KEY of data information according to setting format;
Whether existing the unique KEY of data information is inquired, if it is not, then saving data information and corresponding data information only One KEY.
A kind of data information managing device based on self-defining data table, described device include establishing unit, selection unit And creating unit;
It is described to establish unit, for establishing self-defining data table;
The selection unit, for choosing corresponding self-defining data table construction feature collection according to data information type;
The creating unit, for creating data information according to feature set.
Its further technical solution are as follows: the unit of establishing includes the first definition module, first judgment module, the second definition Module, the second judgment module, custom block, third judgment module, configuration module, correction verification module and the first preserving module;
First definition module, for defining data table name;
The first judgment module, for judging that table name whether there is;
Second definition module, for defining data sheet field type;
Second judgment module, for determining that whether contents in table is by customized mode typing in tables of data;
The custom block is used for customized contents in table;
The third judgment module, for judging whether contents in table repeats in tables of data;
The configuration module obtains script for configuring list item content-data;
The correction verification module, it is whether legal for verifying script;
First preserving module, for saving script and contents in table.
Its further technical solution are as follows: the selection unit includes choosing module, third definition module, the 4th definition mould Block, the 4th judgment module and the second preserving module;
The selection module, for choosing multiple tables of data as a feature set;
The third definition module, for every section of characterizing definition constraint condition in feature set;
4th definition module, for defining naming rule to feature set;
Whether the 4th judgment module has repeated data table for judging characteristic concentration;
Second preserving module, for saving feature set.
Its further technical solution are as follows: the creating unit includes obtaining module, initialization module, choosing value module and school Test preserving module;
The acquisition module, for obtaining the characteristic table in feature set;
The initialization module, for being initialized to optional content in characteristic table;
The choosing value module, for carrying out choosing value to every section of feature in characteristic table as needed after initializing;
The verification preserving module, for the data information constituted after choosing value to be verified and saved.
Its further technical solution are as follows: the verification preserving module includes judging submodule, extracting sub-module, inquiry submodule Block and preservation submodule;
The judging submodule, feature field for judging to fill out in data information whether all assignment;
The extracting sub-module generates the unique KEY of data information according to setting format for extracting uniqueness characteristic field;
The inquiry submodule, it is whether existing for inquiring the unique KEY of data information;
The preservation submodule, for saving data information and the unique KEY of corresponding data information.
Compared with the prior art, the invention has the advantages that: a kind of data information based on self-defining data table of the present invention Management method and device can customize tables of data and its contents in table, can flexibly meet the data information feature of different industries It is required that the regulatory requirement of the different classes of data of enterprises can also be met, and each data are cited when creating data information, May specify must fill out constraint, whether unique constraint, the optional range of contents in table, certain particular entry content have subcharacter tables of data etc. Diversified constraint configuration, and then operator's fault is effectively avoided, there is the case where more records, few record, wrong record.It can also be to submission Data information list item verified, it is ensured that same data information be all always it is unique, effectively evaded repeated data Occur.In addition, can customize naming rule, standardization, the Material Name of formatting, volume can be automatically generated according to the list item pieced together The information such as code, improve the communication efficiency of enterprise.
The above description is only an overview of the technical scheme of the present invention, can in order to better understand technical measure It is implemented in accordance with the contents of the specification, and in order to make above and other objects of the present invention, feature and advantage brighter Show understandable, special below to lift preferred embodiment, detailed description are as follows.
Detailed description of the invention
Fig. 1 is a kind of flow chart of the data information management method specific embodiment based on self-defining data table of the present invention;
Fig. 2 is customized number in a kind of data information management method specific embodiment based on self-defining data table of the present invention According to the flow chart of table;
Fig. 3 is construction feature in a kind of data information management method specific embodiment based on self-defining data table of the present invention The flow chart of collection;
Fig. 4 is to create data in a kind of data information management method specific embodiment based on self-defining data table of the present invention The flow chart of data;
Fig. 5 is to provide in a kind of data information management method specific embodiment based on self-defining data table of the present invention to data Expect the flow chart for being verified and being saved;
Fig. 6 is a kind of structural frames of the data information managing device specific embodiment based on self-defining data table of the present invention Figure;
Fig. 7 is to establish unit in a kind of data information managing device specific embodiment based on self-defining data table of the present invention Structural block diagram;
Fig. 8 is selection unit in a kind of data information managing device specific embodiment based on self-defining data table of the present invention Structural block diagram;
Fig. 9 is creating unit in a kind of data information managing device specific embodiment based on self-defining data table of the present invention Structural block diagram;
Figure 10 is to verify to protect in a kind of data information managing device specific embodiment based on self-defining data table of the present invention The structural block diagram of storing module;
Figure 11 is the table one in the specific embodiment of the invention;Figure 12 is the table two in the specific embodiment of the invention;Figure 13 be the table three in the specific embodiment of the invention;Figure 14 is the table four in the specific embodiment of the invention;Figure 15 is the present invention Table five in specific embodiment;Figure 16 is the table six in the specific embodiment of the invention;Figure 17 is the specific embodiment of the invention In table seven;Figure 18 is the table eight in the specific embodiment of the invention;Figure 19 is the table nine in the specific embodiment of the invention; Figure 20 is the table ten in the specific embodiment of the invention;Figure 21 is the table 11 in the specific embodiment of the invention.
Specific embodiment
In order to more fully understand technology contents of the invention, combined with specific embodiments below to technical solution of the present invention into One step introduction and explanation, but not limited to this.
As shown in Figs. 1-5, the present invention provides a kind of data information management method based on self-defining data table, this method The following steps are included:
S10, self-defining data table is established;
S20, corresponding self-defining data table construction feature collection is chosen according to data information type;
S30, data information is created according to feature set;
Specifically, tables of data can be defined according to different industries or different classes of data, degree of flexibility is high, using wide It is general.In addition, can effectively avoid repeated data by verifying to data information, the accuracy of data information is improved.
Further, step S10 specifically includes the following steps:
S101, data table name is defined;
S102, judge that table name whether there is, if so, return step S101, if it is not, then entering step S103;
S103, data sheet field type is defined;
S104, determine that whether contents in table is by customized mode typing in tables of data;
If so, entering step S1041;
If it is not, then entering step S1042;
S1041, customized contents in table;
S105, judge whether contents in table repeats in tables of data;If it is not, S107, then saving contents in table;If so, mentioning Show illegal;
S1042, configuration list item content-data obtain script;
Whether S106, verification script are legal;If so, S108, script is then saved, if it is not, then prompt is illegal.
Specifically, as shown in figure 11, the tables of data coding newly defined and data table name are inputted, to constitute data table name, Such as: TABLE1, model table.Judge that tables of data coding TABLE1 whether there is, prompt cannot create if it exists.If tables of data encodes TABLE1 is not previously used, and into setting data sheet field type page, tables of data is fixed with: list item coding, list item title, list item Referred to as, the fields such as list item description, state, wherein can list item title, list item the two fields are described can be specified specific by user A variety of typical numbers such as data type, including negative, positive number, integer, decimal (accurate digit), date, generic text, English character According to type.
After specific field type, continue the contents in table source for specifying the tables of data, there is customized, script to configure two kinds of sides Formula.
Customized mode: user is voluntarily added the contents in table of such tables of data, modifies, deletes, disables, enables Deng operation.
Script configuration mode: it can be configured from existing other system database tables by SQL query script mode, example Such as there is a system table A: warehouse compartment information table has field: warehouse compartment coding, warehouse compartment title, warehouse compartment address, warehouse compartment remarks, warehouse Personnel, contact method, warehouse compartment state, in order to reduce Data duplication definition, typing maintenance etc. work, can define one it is customized Tables of data B: data source is arranged as script configuration in warehouse compartment table, and script is as follows: SELECT warehouse compartment encodes AS ' list item coding ', library Position title AS ' list item title ', the description of warehouse compartment remarks AS ' list item ', " effective " AS ' state ' FROM A WHERE warehouse compartment state= " effective ".
Judge content for script legitimacy when submitting configuration script: whether script meets SQL syntax first, and whether script can be held Row;Secondly whether query result field corresponds with self-defining data literary name section;The fields such as third list item title, list item description Whether the data type of query result is consistent with the data type specified in self-defining data table;In 4th query result, list item Whether coding and list item title have repetition, it is necessary to meet list item and encode unique, the unique principle of list item title;
Assuming that defining TABLE1, and specify its list item name field for plain text type, and data source are as follows: It is customized, then can be with for the specific contents in table of the data table definitions, such as: list item be encoded: 001, list item brevity code: nothing, table Item title: A model, list item abbreviation: nothing.After having above-mentioned input, list item can be encoded and title branch looks into TABLE1 table Weight, if existing, this content cannot submit preservation, it is ensured that encode and title is all unique in same tables of data.
In addition, for data source are as follows: script configuration, contents in table user not can be carried out the maintenance that additions and deletions change, can only It checks, this partial data is acquired by the direct inquiry system table of script.
As shown in figs. 12-14, the present embodiment also defines other three tables, respectively TABLE2, data table name: color Table, name field input type are plain text.TABLE3, data table name: list processing technique, name field input type are general Logical text.TABLE4, data table name: plating color, name field input type are plain text:
Further, step S20 specifically includes the following steps:
S201, multiple tables of data are chosen as a feature set;
S202, to every section of characterizing definition constraint condition in feature set;
S203, naming rule is defined to feature set;
Whether S204, judging characteristic concentration have repeated data table, if so, do not save, and return step S201, if it is not, Then enter step S205;
S205, feature set is saved.
By tables of data defined above and contents in table, achievable data information management.Specifically, for a certain classification Data takes out for feature needed for describing such data, and these characteristic attributes are all by self-defining data table (if tables of data No, tables of data and contents in table are first defined) or the composition such as text input type, and in the same feature set, a number Can only occur once according to table.Such as: data classification A defines a feature set, forms by TABLE1, TABLE2, TABLE3
It can be every section of characterizing definition constraint after feature set is clear, including constraint, cascade nature, list item range, only must be filled out One property feature, purposes constraint etc., and the naming rules such as coding, title and specification.
Specifically, constraint must be filled out: specific characteristic concentrate which feature must fill out, which it is non-must fill out, for the constraint that must be filled out, after When continuous reference this feature collection creation data information, this feature must have value.
Setting cascade nature: it is self-defining data Table A that such as feature, which is concentrated with 1 input type of feature, may specify this feature When choosing certain particular entry contents in tables of data A, cascade feature may occur in which, which is all data Table, therefore a self-defining data table is selected for the cascade nature, such as: feature is concentrated with a technology characteristics, and list item has: electricity Plating, antifog, when selecting plating, settable cascade nature " plating color " simultaneously occurs color number table is electroplated selective, and works as When selecting antifog, simultaneously there is antifog process data table in settable cascade nature " antifog requirement ", for specified specific antifog work Skill requirement.
Feature list item range of choice is set: when there are many contents in table of certain tables of data, and being suitable for different types of number When according to data, selectable list item range can be specified for different types of data information, reduces range of choice, it is general to reduce error Rate is arranged optional range and provides the modes such as fixation table item set, the configuration of SQL script.
Uniqueness characteristic: which feature specific characteristic concentrates participate in uniqueness verification, is arranged to the word of uniqueness characteristic Duan Bixu is that must fill out constraint simultaneously, and when subsequent creation data information, contents in table selected by uniqueness characteristic is used in data only The verification of one property.
Purposes constraint: specific characteristic concentrates the purposes of each feature, includes: engineering, business, production, technique, working hour, at The various uses such as sheet, market, can not also specified use.
Wherein, naming rule is the necessary attribute of feature set, can specify data creation after data coding, Material Name, How the information such as specification generate, and list item coding, the name group of certain features can be automatically extracted by configuring specification from feature set It closes, may be alternatively provided as customized (user makes input name information by oneself when customized i.e. creation data).
Specifically, coding rule: when needing to generate encoded information after data information creation, input class can be selected from feature set Type is that the feature of tables of data combines for automatically generating coding, can be encoded by the list item of self-defining data table, list item title And various separators are formed by combining.
Title rule: when needing to generate name information after data information creation, each feature group can be selected from feature set Material Name is automatically generated altogether, it can be by the text of the list item of self-defining data table coding, list item title and input type Information and various separators are composed.
Specification rule: when needing to generate specification after data information creation, each feature group can be selected to close from feature set Material Name is automatically generated, can be encoded by the list item of self-defining data table, the text information of list item title and input type And various separators are composed.
When generating corresponding coding, title, specification, if contents in table has corresponding brevity code or abbreviation in naming rule, So in extraction list item coding or list item title, brevity code or abbreviation are preferentially used, no is just encoded and list item title with list item.
It is that must fill out feature that TABLE1, TABLE2, TABLE3 are defined in Figure 15 table all;TABLE3 has cascade nature, and When the condition for cascade nature occur is that TABLLE3 selects list item coding=01, there is TABLE4 feature;TABLE1,TABLE2, TABLE3 is uniqueness characteristic;TABLE2 is provided with selectable list item range, only red;Data coding rule: by providing Expect classification A, the list item coding of model table, list processing technique list item encode composition, and have 2 serial numbers, "-" is as separating Symbol;Material Name rule: by the list item title of model table, the list item title of list processing technique, color table list item title and plating Color table item title forms, "/" is as separator;Specification rule: it is customized, it is voluntarily inputted by user.
Further, step S30 specifically includes the following steps:
Characteristic table in S301, acquisition feature set;
S302, optional content in characteristic table is initialized;
Choosing value is carried out to every section of feature in characteristic table as needed after S303, initialization;
S304, the data information constituted after choosing value is verified and is saved.
Specifically, when referenced characteristics collection creates data information, it can be by the corresponding customized number of the feature for including in feature set It shows, and the optional content of each tables of data is initialized, but the tables of data of cascade nature is not initialized according to table.Such as draw When the feature set defined with above-mentioned step creates data information, as shown in figure 16, then TABLE1 model table can be listed, at TABLE3 table Science and engineering skill, TABLE2 color table (red can only be selected).
In addition, user can according to actual needs carry out every section of feature after each characteristic table of feature set has initialized Choosing value carries out data information creation by the gradually specific mode of choosing value, and system judges whether eigen is provided with after choosing value Cascade nature, if there is then judging whether to meet cascade nature condition of drawing, in feature set as defined above, list processing technique Feature is provided with cascade nature, then then there is plating face when selecting list item coding=01 when user is to this feature choosing value Color characteristic, and user is required to select plating color, if the list item coding of list processing process choice is not 01, do not occur plating face This cascade nature of color.
Further, step S304 specifically includes the following steps:
S3401, the feature field that must be filled out in data information whether all assignment is judged, if it is not, S3042, then providing assignment and mentioning Show, if so, entering step S3043;
S3043, uniqueness characteristic field is extracted according to the setting format generation unique KEY of data information;
Whether S3044, the inquiry unique KEY of data information are existing, if it is not, S3045, then saving data information and correspondence The unique KEY of data information.If so, not saving.
Specifically, user is one by one after feature choosing value, when submitting data information, according to feature set setting must to fill out constraint special Sign, uniqueness characteristic etc. input information and carry out preliminary check, all characteristics fields that must fill out constraint, uniqueness, it is necessary to have choosing Value, otherwise provides prompt.
After legitimacy verifies, system can verify the uniqueness of this creation data, first will be in feature set It is defined as the field of uniqueness characteristic, the content selected by this is all extracted, and presses tables of data: the format of list item coding Complete character string foremost is spliced into plus data information classification, as unique KEY of the data, respectively after carrying out ascending sort Use " | " as separator when merging features.
It is as shown in figure 17 in created content selected by each feature of data information, then the unique KEY of the data generated are as follows: data class Other A | model table: 001 | list processing technique: 02 | color table: RED.
After generating the unique KEY of data information, unique KEY with available data data is compared, if repeating, illustrates this Data is existing, cannot repeat to create, otherwise can create, carry out data information storage.
After being verified by uniqueness, the naming rule defined according to feature set, automatically generated data data coding, title, The information such as specification for user's preview, if naming rule be it is customized, this can be such as above-mentioned with user's voluntarily typing information The feature set of definition, the rule of specification are customized, then being editable text box in preview page specification, user can record Enter specification content.But for the information of rule generation, should be noted data encoding repeat, without cascade nature, using brevity code The generating mode of situations such as abbreviation,
Wherein, data encoding repeats: when configuration feature collection constrains in feature set, uniqueness characteristic does not participate in coding rule Then, the case where data information coding for not repeating, but being automatically generated then uniqueness KEY may occur repeats, then needing It is distinguished by serial number.As shown in Figure 18,19, two kinds of data be all it is legal, the unique KEY of data information is not repeated, but number It can be repeated according to coding, so being distinguished by serial number.
No cascade nature: naming rule can quote cascade nature tables of data in feature set definition, but in some cases should Cascade nature table may not occur, then the segment information is substituted with null value in naming rule, if there is separator in front, simultaneously Remove separator.As shown in figure 20, antifog process data data is created, cascade nature does not occur: plating color, then generating When data information title, it is sky that color, which is electroplated, in final stage, and there is separator/also remove in front.
Using brevity code referred to as: according to naming rule extract corresponding eigenvalue be named when, if characteristic value it is corresponding from It defines in tables of data there are brevity code or abbreviation, it need to be by brevity code/referred to as substitute list item coding/list item title.As shown in figure 21, Electroplating technology data information is created, the value of list item coding 03 has been selected, which has abbreviation MR in list processing process data table, So in automatically generated data title, second segment: list processing technique [title] need to be with referred to as being substituted, and which is for table When item coding, list item title are lengthy, carry out comparison simplification to generate the coding of data information, title, by brevity code, letter Title mode can be very good to be evaded.
After data information preview page is submitted, preservation processing can be carried out to the data information of this creation.Specifically, The corresponding data table name of every section of characteristic value, list item coding are all stored, convenient for combining subsequently through feature to data information Fast and accurately retrieved;The information such as storing data data coding, title, specification;The unique KEY information of storing data data, It is directly used when verifying uniqueness KEY for follow-up system, if data information has altered, new unique KEY can be regenerated Carry out duplicate checking.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit It is fixed.
Corresponding to a kind of data information management method based on self-defining data table described in above-described embodiment, the present invention is also Provide a kind of data information managing device based on self-defining data table.As illustrated in figures 6-10, which includes establishing unit 1, selection unit 2, creating unit 3, wherein unit 1 is established, for establishing self-defining data table;Selection unit 2 is used for basis Data information type chooses corresponding self-defining data table construction feature collection;Creating unit 3, for creating data according to feature set Data.
Specifically, tables of data can be defined according to different industries or different classes of data, degree of flexibility is high, using wide It is general.In addition, can effectively avoid repeated data by verifying to data information, the accuracy of data information is improved.
Further, establishing unit 1 includes the first definition module 11, first judgment module 12, the second definition module 13, the Two judgment modules 14, custom block 15, third judgment module 16, configuration module 17, correction verification module 18 and first save mould Block 19.
Wherein, the first definition module 11, for defining data table name;
First judgment module 12, for judging that table name whether there is;
Second definition module 13, for defining data sheet field type;
Second judgment module 14, for determining that whether contents in table is by customized mode typing in tables of data;
Custom block 15 is used for customized contents in table;
Third judgment module 16, for judging whether contents in table repeats in tables of data;
Configuration module 17 obtains script for configuring list item content-data;
Correction verification module 18, it is whether legal for verifying script;
First preserving module 19, for saving script and contents in table.
Specifically, as shown in figure 11, the tables of data coding newly defined and data table name are inputted, to constitute data table name, Such as: TABLE1, model table.Judge that tables of data coding TABLE1 whether there is, prompt cannot create if it exists.If tables of data encodes TABLE1 is not previously used, and into setting data sheet field type page, tables of data is fixed with: list item coding, list item title, list item Referred to as, the fields such as list item description, state, wherein can list item title, list item the two fields are described can be specified specific by user A variety of typical numbers such as data type, including negative, positive number, integer, decimal (accurate digit), date, generic text, English character According to type.
After specific field type, continue the contents in table source for specifying the tables of data, there is customized, script to configure two kinds of sides Formula.
Customized mode: user is voluntarily added the contents in table of such tables of data, modifies, deletes, disables, enables Deng operation.
Script configuration mode: it can be configured from existing other system database tables by SQL query script mode, example Such as there is a system table A: warehouse compartment information table has field: warehouse compartment coding, warehouse compartment title, warehouse compartment address, warehouse compartment remarks, warehouse Personnel, contact method, warehouse compartment state, in order to reduce Data duplication definition, typing maintenance etc. work, can define one it is customized Tables of data B: data source is arranged as script configuration in warehouse compartment table, and script is as follows: SELECT warehouse compartment encodes AS ' list item coding ', library Position title AS ' list item title ', the description of warehouse compartment remarks AS ' list item ', " effective " AS ' state ' FROM A WHERE warehouse compartment state= " effective ".
Judge content for script legitimacy when submitting configuration script: whether script meets SQL syntax first, and whether script can be held Row;Secondly whether query result field corresponds with self-defining data literary name section;The fields such as third list item title, list item description Whether the data type of query result is consistent with the data type specified in self-defining data table;In 4th query result, list item Whether coding and list item title have repetition, it is necessary to meet list item and encode unique, the unique principle of list item title;
Assuming that defining TABLE1, and specify its list item name field for plain text type, and data source are as follows: It is customized, then can be with for the specific contents in table of the data table definitions, such as: list item be encoded: 001, list item brevity code: nothing, table Item title: A model, list item abbreviation: nothing.After having above-mentioned input, list item can be encoded and title branch looks into TABLE1 table Weight, if existing, this content cannot submit preservation, it is ensured that encode and title is all unique in same tables of data.
In addition, for data source are as follows: script configuration, contents in table user not can be carried out the maintenance that additions and deletions change, can only It checks, this partial data is acquired by the direct inquiry system table of script.
Further, selection unit 2 includes choosing module 21, third definition module 22, the 4th definition module the 23, the 4th to sentence Disconnected module 24, the second preserving module 25.
Module 21 is chosen, for choosing multiple tables of data as a feature set;
Third definition module 22, for every section of characterizing definition constraint condition in feature set;
4th definition module 23, for defining naming rule to feature set;
Whether the 4th judgment module 24 has repeated data table for judging characteristic concentration;
Second preserving module 25, for saving feature set.
By tables of data defined above and contents in table, achievable data information management.Specifically, for a certain classification Data takes out for feature needed for describing such data, and these characteristic attributes are all by self-defining data table (if tables of data No, tables of data and contents in table are first defined) or the composition such as text input type, and in the same feature set, a number Can only occur once according to table.Such as: data classification A defines a feature set, forms by TABLE1, TABLE2, TABLE3
It can be every section of characterizing definition constraint after feature set is clear, including constraint, cascade nature, list item range, only must be filled out One property feature, purposes constraint etc., and the naming rules such as coding, title and specification.
Specifically, constraint must be filled out: specific characteristic concentrate which feature must fill out, which it is non-must fill out, for the constraint that must be filled out, after When continuous reference this feature collection creation data information, this feature must have value.
Setting cascade nature: it is self-defining data Table A that such as feature, which is concentrated with 1 input type of feature, may specify this feature When choosing certain particular entry contents in tables of data A, cascade feature may occur in which, which is all data Table, therefore a self-defining data table is selected for the cascade nature, such as: feature is concentrated with a technology characteristics, and list item has: electricity Plating, antifog, when selecting plating, settable cascade nature " plating color " simultaneously occurs color number table is electroplated selective, and works as When selecting antifog, simultaneously there is antifog process data table in settable cascade nature " antifog requirement ", for specified specific antifog work Skill requirement.
Feature list item range of choice is set: when there are many contents in table of certain tables of data, and being suitable for different types of number When according to data, selectable list item range can be specified for different types of data information, reduces range of choice, it is general to reduce error Rate is arranged optional range and provides the modes such as fixation table item set, the configuration of SQL script.
Uniqueness characteristic: which feature specific characteristic concentrates participate in uniqueness verification, is arranged to the word of uniqueness characteristic Duan Bixu is that must fill out constraint simultaneously, and when subsequent creation data information, contents in table selected by uniqueness characteristic is used in data only The verification of one property.
Purposes constraint: specific characteristic concentrates the purposes of each feature, includes: engineering, business, production, technique, working hour, at The various uses such as sheet, market, can not also specified use.
Wherein, naming rule is the necessary attribute of feature set, can specify data creation after data coding, Material Name, How the information such as specification generate, and list item coding, the name group of certain features can be automatically extracted by configuring specification from feature set It closes, may be alternatively provided as customized (user makes input name information by oneself when customized i.e. creation data).
Specifically, coding rule: when needing to generate encoded information after data information creation, input class can be selected from feature set Type is that the feature of tables of data combines for automatically generating coding, can be encoded by the list item of self-defining data table, list item title And various separators are formed by combining.
Title rule: when needing to generate name information after data information creation, each feature group can be selected from feature set Material Name is automatically generated altogether, it can be by the text of the list item of self-defining data table coding, list item title and input type Information and various separators are composed.
Specification rule: when needing to generate specification after data information creation, each feature group can be selected to close from feature set Material Name is automatically generated, can be encoded by the list item of self-defining data table, the text information of list item title and input type And various separators are composed.
When generating corresponding coding, title, specification, if contents in table has corresponding brevity code or abbreviation in naming rule, So in extraction list item coding or list item title, brevity code or abbreviation are preferentially used, no is just encoded and list item title with list item.
It is that must fill out feature that TABLE1, TABLE2, TABLE3 are defined in Figure 15 table all;TABLE3 has cascade nature, and When the condition for cascade nature occur is that TABLLE3 selects list item coding=01, there is TABLE4 feature;TABLE1,TABLE2, TABLE3 is uniqueness characteristic;TABLE2 is provided with selectable list item range, only red;Data coding rule: by providing Expect classification A, the list item coding of model table, list processing technique list item encode composition, and have 2 serial numbers, "-" is as separating Symbol;Material Name rule: by the list item title of model table, the list item title of list processing technique, color table list item title and plating Color table item title forms, "/" is as separator;Specification rule: it is customized, it is voluntarily inputted by user.
Further, creating unit 3 includes obtaining module 31, initialization module 32, choosing value module 33 and verification to save Module 34.
Wherein, module 31 is obtained, for obtaining the characteristic table in feature set;
Initialization module 32, for being initialized to optional content in characteristic table;
Choosing value module 33, for carrying out choosing value to every section of feature in characteristic table as needed after initializing;
Preserving module 34 is verified, for the data information constituted after choosing value to be verified and saved.
Specifically, when referenced characteristics collection creates data information, it can be by the corresponding customized number of the feature for including in feature set It shows, and the optional content of each tables of data is initialized, but the tables of data of cascade nature is not initialized according to table.Such as draw When the feature set defined with above-mentioned step creates data information, as shown in figure 16, then TABLE1 model table can be listed, at TABLE3 table Science and engineering skill, TABLE2 color table (red can only be selected).
In addition, user can according to actual needs carry out every section of feature after each characteristic table of feature set has initialized Choosing value carries out data information creation by the gradually specific mode of choosing value, and system judges whether eigen is provided with after choosing value Cascade nature, if there is then judging whether to meet cascade nature condition of drawing, in feature set as defined above, list processing technique Feature is provided with cascade nature, then then there is plating face when selecting list item coding=01 when user is to this feature choosing value Color characteristic, and user is required to select plating color, if the list item coding of list processing process choice is not 01, do not occur plating face This cascade nature of color.
Further, verification preserving module 34 includes judging submodule 341, extracting sub-module 342, inquiry submodule 343 And save submodule 344;
Wherein, judging submodule 341, feature field for judging to fill out in data information whether all assignment;
Extracting sub-module 342 generates the unique KEY of data information according to setting format for extracting uniqueness characteristic field;
Submodule 343 is inquired, it is whether existing for inquiring the unique KEY of data information;
Submodule 344 is saved, for saving data information and the unique KEY of corresponding data information.
Specifically, user is one by one after feature choosing value, when submitting data information, according to feature set setting must to fill out constraint special Sign, uniqueness characteristic etc. input information and carry out preliminary check, all characteristics fields that must fill out constraint, uniqueness, it is necessary to have choosing Value, otherwise provides prompt.
After legitimacy verifies, system can verify the uniqueness of this creation data, first will be in feature set It is defined as the field of uniqueness characteristic, the content selected by this is all extracted, and presses tables of data: the format of list item coding Complete character string foremost is spliced into plus data information classification, as unique KEY of the data, respectively after carrying out ascending sort Use " | " as separator when merging features.
It is as shown in figure 17 in created content selected by each feature of data information, then the unique KEY of the data generated are as follows: data class Other A | model table: 001 | list processing technique: 02 | color table: RED.
After generating the unique KEY of data information, unique KEY with available data data is compared, if repeating, illustrates this Data is existing, cannot repeat to create, otherwise can create, carry out data information storage.
After being verified by uniqueness, the naming rule defined according to feature set, automatically generated data data coding, title, The information such as specification for user's preview, if naming rule be it is customized, this can be such as above-mentioned with user's voluntarily typing information The feature set of definition, the rule of specification are customized, then being editable text box in preview page specification, user can record Enter specification content.But for the information of rule generation, should be noted data encoding repeat, without cascade nature, using brevity code The generating mode of situations such as abbreviation,
Wherein, data encoding repeats: when configuration feature collection constrains in feature set, uniqueness characteristic does not participate in coding rule Then, the case where data information coding for not repeating, but being automatically generated then uniqueness KEY may occur repeats, then needing It is distinguished by serial number.As shown in Figure 18,19, two kinds of data be all it is legal, the unique KEY of data information is not repeated, but number It can be repeated according to coding, so being distinguished by serial number.
No cascade nature: naming rule can quote cascade nature tables of data in feature set definition, but in some cases should Cascade nature table may not occur, then the segment information is substituted with null value in naming rule, if there is separator in front, simultaneously Remove separator.As shown in figure 20, antifog process data data is created, cascade nature does not occur: plating color, then generating When data information title, it is sky that color, which is electroplated, in final stage, and there is separator/also remove in front.
Using brevity code referred to as: according to naming rule extract corresponding eigenvalue be named when, if characteristic value it is corresponding from It defines in tables of data there are brevity code or abbreviation, it need to be by brevity code/referred to as substitute list item coding/list item title.As shown in figure 21, Electroplating technology data information is created, the value of list item coding 03 has been selected, which has abbreviation MR in list processing process data table, So in automatically generated data title, second segment: list processing technique [title] need to be with referred to as being substituted, and which is for table When item coding, list item title are lengthy, carry out comparison simplification to generate the coding of data information, title, by brevity code, letter Title mode can be very good to be evaded.
After data information preview page is submitted, preservation processing can be carried out to the data information of this creation.Specifically, The corresponding data table name of every section of characteristic value, list item coding are all stored, convenient for combining subsequently through feature to data information Fast and accurately retrieved;The information such as storing data data coding, title, specification;The unique KEY information of storing data data, It is directly used when verifying uniqueness KEY for follow-up system, if data information has altered, new unique KEY can be regenerated Carry out duplicate checking.
It is above-mentioned that technology contents of the invention are only further illustrated with embodiment, in order to which reader is easier to understand, but not It represents embodiments of the present invention and is only limitted to this, any technology done according to the present invention extends or recreation, by of the invention Protection.Protection scope of the present invention is subject to claims.

Claims (10)

1. a kind of data information management method based on self-defining data table, which is characterized in that the described method includes:
Establish self-defining data table;
Corresponding self-defining data table construction feature collection is chosen according to data information type;
Data information is created according to feature set.
2. a kind of data information management method based on self-defining data table according to claim 1, which is characterized in that institute The step of establishing self-defining data table is stated, specifically includes the following steps:
Define data table name;
Judge that table name whether there is, if so, the step of returning to the definition data table name, if it is not, then entering the definition number The step of according to literary name segment type;
Define data sheet field type;
Determine that whether contents in table is by customized mode typing in tables of data;
If so, the step of into the customized contents in table;
If it is not, then entering the step of configuration list item content-data obtains script;
Customized contents in table;
Judge whether contents in table repeats in tables of data;
If it is not, then saving contents in table;
It configures list item content-data and obtains script;
Whether legal verify script;
If so, saving script.
3. a kind of data information management method based on self-defining data table according to claim 1, which is characterized in that institute The step of corresponding self-defining data table construction feature collection is chosen according to data information type is stated, specifically includes the following steps:
Multiple tables of data are chosen as a feature set;
To every section of characterizing definition constraint condition in feature set;
Naming rule is defined to feature set;
Whether judging characteristic concentration has repeated data table, if it is not, the step of then entering the preservation feature set;
Save feature set.
4. a kind of data information management method based on self-defining data table according to claim 1, which is characterized in that institute The step of data information is created according to feature set is stated, specifically includes the following steps:
Obtain the characteristic table in feature set;
Optional content in characteristic table is initialized;
Choosing value is carried out to every section of feature in characteristic table as needed after initialization;
The data information constituted after choosing value is verified and saved.
5. a kind of data information management method based on self-defining data table according to claim 4, which is characterized in that institute The step of data information constituted after choosing value is verified and saved is stated, specifically includes the following steps:
The feature field that must be filled out in data information whether all assignment is judged, if it is not, assignment prompt is then provided, if so, described in Extract the step of uniqueness characteristic field generates data information unique KEY according to setting format;
It extracts uniqueness characteristic field and generates the unique KEY of data information according to setting format;
Whether existing the unique KEY of data information is inquired, if it is not, then saving data information and corresponding data information is unique KEY。
6. a kind of data information managing device based on self-defining data table, which is characterized in that described device include establish unit, Selection unit and creating unit;
It is described to establish unit, for establishing self-defining data table;
The selection unit, for choosing corresponding self-defining data table construction feature collection according to data information type;
The creating unit, for creating data information according to feature set.
7. a kind of data information managing device based on self-defining data table according to claim 6, which is characterized in that institute State establish unit include the first definition module, first judgment module, the second definition module, the second judgment module, custom block, Third judgment module, configuration module, correction verification module and the first preserving module;
First definition module, for defining data table name;
The first judgment module, for judging that table name whether there is;
Second definition module, for defining data sheet field type;
Second judgment module, for determining that whether contents in table is by customized mode typing in tables of data;
The custom block is used for customized contents in table;
The third judgment module, for judging whether contents in table repeats in tables of data;
The configuration module obtains script for configuring list item content-data;
The correction verification module, it is whether legal for verifying script;
First preserving module, for saving script and contents in table.
8. a kind of data information managing device based on self-defining data table according to claim 6, which is characterized in that institute Stating selection unit includes choosing module, third definition module, the 4th definition module, the 4th judgment module and the second preservation mould Block;
The selection module, for choosing multiple tables of data as a feature set;
The third definition module, for every section of characterizing definition constraint condition in feature set;
4th definition module, for defining naming rule to feature set;
Whether the 4th judgment module has repeated data table for judging characteristic concentration;
Second preserving module, for saving feature set.
9. a kind of data information managing device based on self-defining data table according to claim 6, which is characterized in that institute Stating creating unit includes obtaining module, initialization module, choosing value module and verification preserving module;
The acquisition module, for obtaining the characteristic table in feature set;
The initialization module, for being initialized to optional content in characteristic table;
The choosing value module, for carrying out choosing value to every section of feature in characteristic table as needed after initializing;
The verification preserving module, for the data information constituted after choosing value to be verified and saved.
10. a kind of data information managing device based on self-defining data table according to claim 9, which is characterized in that The verification preserving module includes judging submodule, extracting sub-module, inquiry submodule and saves submodule;
The judging submodule, feature field for judging to fill out in data information whether all assignment;
The extracting sub-module generates the unique KEY of data information according to setting format for extracting uniqueness characteristic field;
The inquiry submodule, it is whether existing for inquiring the unique KEY of data information;
The preservation submodule, for saving data information and the unique KEY of corresponding data information.
CN201811582126.9A 2018-12-24 2018-12-24 Data management method and device based on user-defined data table Active CN109726204B (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201811582126.9A CN109726204B (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table
CN202211477527.4A CN115827627A (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811582126.9A CN109726204B (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CN202211477527.4A Division CN115827627A (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table

Publications (2)

Publication Number Publication Date
CN109726204A true CN109726204A (en) 2019-05-07
CN109726204B CN109726204B (en) 2023-01-31

Family

ID=66296404

Family Applications (2)

Application Number Title Priority Date Filing Date
CN202211477527.4A Pending CN115827627A (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table
CN201811582126.9A Active CN109726204B (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table

Family Applications Before (1)

Application Number Title Priority Date Filing Date
CN202211477527.4A Pending CN115827627A (en) 2018-12-24 2018-12-24 Data management method and device based on user-defined data table

Country Status (1)

Country Link
CN (2) CN115827627A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110210253A (en) * 2019-05-08 2019-09-06 北京机电工程总体设计部 EBOM method of calibration between a kind of enterprise based on PDM system
CN113722335A (en) * 2021-09-16 2021-11-30 宇宙世代信息技术(深圳)有限公司 Triggering display method, device and equipment for geographic position and content management

Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6154753A (en) * 1995-09-15 2000-11-28 Cable & Wireless, Inc. Document management system and method for business quality modeling
CN101241434A (en) * 2008-03-04 2008-08-13 浪潮集团山东通用软件有限公司 Form self-defining method
CN101425060A (en) * 2007-11-02 2009-05-06 英业达股份有限公司 Database data table generating method
CN102346785A (en) * 2011-11-15 2012-02-08 北京创腾科技有限公司 Method and device for directly self-defining field of database
CN102467704A (en) * 2010-11-10 2012-05-23 金蝶软件(中国)有限公司 Method and system for generating data table of just-in-time inventory management
CN103631570A (en) * 2012-08-21 2014-03-12 镇江雅迅软件有限责任公司 Form self-definition method
CN104156348A (en) * 2014-08-11 2014-11-19 中国人民解放军军械工程学院 IETM process data entry device and method based on templates
CN104268272A (en) * 2014-10-14 2015-01-07 青岛海尔软件有限公司 Method and device for checking uniqueness of data
CN104346377A (en) * 2013-07-31 2015-02-11 克拉玛依红有软件有限责任公司 Method for integrating and exchanging data on basis of unique identification
CN105653732A (en) * 2016-02-02 2016-06-08 优品财富管理有限公司 Automatic table establishment method and system based on metadata
US20180075077A1 (en) * 2015-05-31 2018-03-15 Huawei Technologies Co., Ltd. Method and Device for Partitioning Association Table in Distributed Database
CN108229921A (en) * 2017-09-05 2018-06-29 杭州孚嘉科技有限公司 National tax land tax combines data collecting system and its operating method
CN108776702A (en) * 2018-06-11 2018-11-09 浪潮软件股份有限公司 A kind of data make a report on page user-defined visual configuration method
CN108932268A (en) * 2017-05-26 2018-12-04 华为软件技术有限公司 Data processing method and device

Patent Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6154753A (en) * 1995-09-15 2000-11-28 Cable & Wireless, Inc. Document management system and method for business quality modeling
CN101425060A (en) * 2007-11-02 2009-05-06 英业达股份有限公司 Database data table generating method
CN101241434A (en) * 2008-03-04 2008-08-13 浪潮集团山东通用软件有限公司 Form self-defining method
CN102467704A (en) * 2010-11-10 2012-05-23 金蝶软件(中国)有限公司 Method and system for generating data table of just-in-time inventory management
CN102346785A (en) * 2011-11-15 2012-02-08 北京创腾科技有限公司 Method and device for directly self-defining field of database
CN103631570A (en) * 2012-08-21 2014-03-12 镇江雅迅软件有限责任公司 Form self-definition method
CN104346377A (en) * 2013-07-31 2015-02-11 克拉玛依红有软件有限责任公司 Method for integrating and exchanging data on basis of unique identification
CN104156348A (en) * 2014-08-11 2014-11-19 中国人民解放军军械工程学院 IETM process data entry device and method based on templates
CN104268272A (en) * 2014-10-14 2015-01-07 青岛海尔软件有限公司 Method and device for checking uniqueness of data
US20180075077A1 (en) * 2015-05-31 2018-03-15 Huawei Technologies Co., Ltd. Method and Device for Partitioning Association Table in Distributed Database
CN105653732A (en) * 2016-02-02 2016-06-08 优品财富管理有限公司 Automatic table establishment method and system based on metadata
CN108932268A (en) * 2017-05-26 2018-12-04 华为软件技术有限公司 Data processing method and device
CN108229921A (en) * 2017-09-05 2018-06-29 杭州孚嘉科技有限公司 National tax land tax combines data collecting system and its operating method
CN108776702A (en) * 2018-06-11 2018-11-09 浪潮软件股份有限公司 A kind of data make a report on page user-defined visual configuration method

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110210253A (en) * 2019-05-08 2019-09-06 北京机电工程总体设计部 EBOM method of calibration between a kind of enterprise based on PDM system
CN113722335A (en) * 2021-09-16 2021-11-30 宇宙世代信息技术(深圳)有限公司 Triggering display method, device and equipment for geographic position and content management
CN113722335B (en) * 2021-09-16 2023-07-21 宇宙世代信息技术(深圳)有限公司 Trigger display method, device and equipment for geographic position and content management

Also Published As

Publication number Publication date
CN115827627A (en) 2023-03-21
CN109726204B (en) 2023-01-31

Similar Documents

Publication Publication Date Title
CN101686146B (en) Method and equipment for fuzzy query, query result processing and filtering condition processing
CN104572597A (en) Automatic word analysis report generation method and device
CN106682096A (en) Method and device for log data management
CN105868171A (en) Checking method and device of Excel file
CN104991975A (en) Data query method and system of electric power business systems
CN110543303A (en) Visual business platform
CN113672230B (en) Industrial element identification coding method
CN103631966A (en) Configurable multiple-valued matching field analysis method
CN109726204A (en) A kind of data information management method and device based on self-defining data table
CN106815366A (en) A kind of method and system of Mass production data
CN112199302A (en) Test data generation method and system, corresponding equipment and storage medium
CN102426612A (en) Condition object query method and system
CN109299074A (en) A kind of data verification method and system based on templating data base view
CN104536998A (en) Data import method and device
CN116451665A (en) Method for intelligently generating design BOM based on drawing
CN106126224A (en) Tool, system and method for generating program object
CN112668292A (en) Method for automatically extracting tracking matrix from system configuration rule and application thereof
CN106933844B (en) Construction method of reachability query index facing large-scale RDF data
CN103020189A (en) Data processing device and method
CN115269638A (en) Method for automatically associating members in BIM (building information modeling) model by dynamic data set
CN110147396A (en) A kind of mapping relations generation method and device
CN106445923A (en) Stack-framework-based enquiry system and enquiry method
CN112650754A (en) Method for importing total data of relational database into Hive
CN111198879A (en) Intelligent community-based business data storage method and system
CN114691722B (en) Method and system for rapidly selecting package detection standard

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