CN110019111A - Data processing method, device, storage medium and processor - Google Patents

Data processing method, device, storage medium and processor Download PDF

Info

Publication number
CN110019111A
CN110019111A CN201710697072.XA CN201710697072A CN110019111A CN 110019111 A CN110019111 A CN 110019111A CN 201710697072 A CN201710697072 A CN 201710697072A CN 110019111 A CN110019111 A CN 110019111A
Authority
CN
China
Prior art keywords
name
data
pending data
name set
interim
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
CN201710697072.XA
Other languages
Chinese (zh)
Other versions
CN110019111B (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.)
Beijing Gridsum Technology Co Ltd
Original Assignee
Beijing Gridsum 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 Beijing Gridsum Technology Co Ltd filed Critical Beijing Gridsum Technology Co Ltd
Priority to CN201710697072.XA priority Critical patent/CN110019111B/en
Publication of CN110019111A publication Critical patent/CN110019111A/en
Application granted granted Critical
Publication of CN110019111B publication Critical patent/CN110019111B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating

Abstract

The invention discloses a kind of data processing method, device, storage medium and processors, the data processing method by being determined as target configuration attribute at least one pre-set configuration attribute of user one by one, data source will be belonged to and belong to the field name of pending data table, is added to the second name set;Interim table is created according to the second name set and data source;According to the interim table and first name set, the pending data table is updated and/or is inserted into.In the whole process, user can only need that one or more configuration attributes are arranged when initial, the content that extended meeting includes according to configuration attribute afterwards is updated and/or is inserted into tables of data to be processed, does not need to write update sentence and insertion sentence for each pending data table.Therefore the operation of user is simplified.

Description

Data processing method, device, storage medium and processor
Technical field
The present invention relates to database technical field, it is more particularly to a kind of data processing method and device.
Background technique
In informationized society, with the development of information technology and market, substantially effectively management and use various information is provided Source is the precondition for carrying out scientific research and decision-making management.Database technology is the core of various information system.Data Update be then database technology key component.
Data in database are stored in a manner of tables of data, and the update and insertion to data in database are For the update and insertion to tables of data.When tables of data each in database is updated or is inserted into, requires user and write number According to the sentences such as sentence or insertion sentence, such as Update, Insert, Merge are updated, so that user's operation is cumbersome.
To sum up, those skilled in the art are being dedicated to researching and developing simplified user's operation at present tables of data updates and insertion Method.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind State the data processing method and device of problem.
A kind of data processing method, comprising:
At least one pre-set configuration attribute is determined as target configuration attribute one by one;Wherein, the target configuration Attribute includes: the title of pending data table;For characterizing the data source of the data more new sources of the pending data table Title;The company of the pending data table and the data source is connected when comprising the pending data table is arranged for being characterized in First name set of narrow bars part, first name set include while belonging to the data source and the pending data table At least one field name;
The data source will be belonged to and belong to the field name of the pending data table, is added to the second name set;
Interim table is created according to second name set and the data source, the field name of the interim table includes All field names that second name set includes, the record in the interim table include belong to the data source and with institute All field names that the second name set includes are stated to record accordingly;
According to the interim table and first name set, the pending data table is updated and/or is inserted Enter.
A kind of data processing equipment, comprising:
Determining module, at least one pre-set configuration attribute to be determined as target configuration attribute one by one;Wherein, The target configuration attribute includes: the title of pending data table;Data for characterizing the pending data table are more newly arrived The title of the data source in source;The pending data table and institute are connected when comprising the pending data table is arranged for being characterized in State the first name set of the condition of contact of data source, first name set includes while belonging to the data source and described At least one field name of pending data table;
Adding module is added to for that will belong to the data source and belong to the field name of the pending data table Second name set;
Creation module, for creating interim table, the interim table according to second name set and the data source Field name include all field names that second name set includes, the record in the interim table includes belonging to institute It states data source and corresponding with all field names that second name set includes records;
Setup module, for according to the interim table and first name set, to the pending data table into Row updates.
By above-mentioned technical proposal, in data processing method provided by the invention, by the way that user is pre-set at least One configuration attribute is determined as target configuration attribute one by one, will belong to data source and belongs to the field name of pending data table, It is added to the second name set;Interim table is created according to the second name set and data source;According to the interim table and institute The first name set is stated, the pending data table is updated and/or is inserted into.In the whole process, user can only need One or more configuration attributes are set when initial, and the content that rear extended meeting foundation configuration attribute includes is to pending data Table is updated and/or is inserted into, and does not need to write update sentence and insertion sentence for each pending data table.Therefore simplify The operation of user.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention, And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows the flow diagram of data processing method provided in an embodiment of the present invention;
Fig. 2 shows in data processing method provided in an embodiment of the present invention by least one pre-set configuration attribute It is determined as a kind of method flow schematic diagram of implementation of target configuration attribute one by one;
Fig. 3 show in a kind of data processing method provided in an embodiment of the present invention by it is pre-set at least one match Set the method flow schematic diagram that attribute is determined as the another implementation of target configuration attribute one by one;
Fig. 4 is shown in data processing method provided in an embodiment of the present invention according to the interim table and the first place Claim set, to a kind of method flow diagram for implementation that the pending data table is updated and/or is inserted into;
Fig. 5 shows a kind of structure chart of data processing equipment provided in an embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure It is fully disclosed to those skilled in the art.
The embodiment of the invention provides a kind of data processing method, this method can be applied to the electronics comprising database and set It is standby.Database may include one or more tables of data, and tables of data is one of most important component part of database, by one group of phase The record by rows closed forms, and every a line in tables of data is called one " record ", each record is comprising in this row All " values ".It is called " value " in the data of tables of data ranks infall." column " of tables of data are known as " field ", and the title of " column " claims For field name.
For example, address book data table shown in table 1 includes: " name ", the column of " telephone number " two.
1 address book data table of table
Name Telephone number
Zhang San 133XXXXXXXX
Li Si 173XXXXXXXX
Wherein, tables of data includes two field names, respectively " name ", " telephone number ";This tables of data includes two Item record, is respectively as follows: " Zhang San ", " 133XXXXXXXX ";With " Li Si ", " 173XXXXXXXX ".Wherein, there are two " names " Value, respectively " Zhang San ", " Li Si ";" telephone number " there are two values, respectively " 133XXXXXXXX ", " 173XXXXXXXX ".
When the tables of data to the database purchase in electronic equipment is updated, data can be obtained in tables of data more The data source of new sources.It is compared from accuracy, the data in data source are more more accurate than in tables of data;The phase from integrity degree Than the data in data source are more more comprehensive than in tables of data, therefore can be using data source as the more new sources of data to data Data in table are updated.
Data source can be to be obtained from other electronic equipments, is also possible to be located at same electronic equipment with tables of data In, in this regard, the embodiment of the present invention is not specifically limited.
As shown in Figure 1, be the flow diagram of data processing method provided in an embodiment of the present invention, this method comprises:
Step S101: at least one pre-set configuration attribute is determined as target configuration attribute one by one.
Wherein, the target configuration attribute includes: the title of pending data table;For characterizing the pending data table Data more new sources data source title;Connection is described wait locate when comprising the pending data table being arranged for being characterized in The first name set of the condition of contact of tables of data and the data source is managed, first name set includes while belonging to described At least one field name of data source and the pending data table.
The one or more tables of data stored in database have one's own unique name.It therefore can be by wait locate The title of reason tables of data uniquely determines a tables of data.
" setting " mode that the embodiment of the present invention refers to include: in the database in stored tables of data insertion one or The record being not present in multiple tables of data;And/or has record to one or more of tables of data stored in database It is updated.
Therefore, " connection of the pending data table and the data source is connected when the pending data table is arranged Condition " refers to, is to pass through condition of contact when being configured according to the content in data source to the data in tables of data to be processed To judge which record is the existing record of pending data table in data source, which record is that pending data table is not present Record, to further determine that the mode of setting.
Step S102: will belong to the data source and belong to the field name of the pending data table, be added to second Name set.
Since the field name that the field name that data source includes may include with pending data table is not quite similar, example Such as, the number for the column that data source includes may be more than the number for the column that pending data table includes;Or, one that data source includes Or multiple field names are not present in pending data table.
It, may be because of data source and pending data if direct basis data source is configured tables of data to be processed The number or field name arranged in table mismatches and fails.
It is assumed that data source is as shown in table 2, pending data table is as shown in table 3.Then the second name set includes two fields Title, as " student name " and " overall scores ".
2 data source of table
Student name Mathematics achievement Chinese Achievement Test Overall scores
Zhang San 90 88 178
Li Si 87 81 168
King five 79 100 179
3 pending data table of table
Student name Overall scores
Zhang San 178
Li Si 157
Zhao six 167
Step S103: interim table is created according to second name set and the data source.
The field name of the interim table includes all field names that second name set includes, the interim table In record include belonging to the data source and corresponding with all field names that second name set includes recording.
The field name that includes than pending data table due to data source and record it is more comprehensive, under normal circumstances, second Name set is all field names that pending data table includes.Assuming that pending data table is entitled WechatPerformanceEx_Hourly, the entitled TempTable of interim table, then according to the second name set and number May include following sentence during creating interim table according to source:
SELECT column_name(s)INTO TempTable FROMWechatPerformanceEx_Hourly WHERE 1=0
Above-mentioned sentence is all field names to be obtained from pending data table, but do not obtain in pending data table Any record, then generate interim table according to field names all in pending data table.The field name for including in interim table Field name as in pending data table, i.e., the field name one in field name and the second name set in interim table One is corresponding, and under normal circumstances, the field name in interim table is also corresponded with the field name in pending data table.
Again by the corresponding record of all field names is inserted into interim table in the second name set in data source, to sum up;Foundation Second name set and the data source create interim table
Creation includes the interim table of all field names in second name set;
All field names that second name set described in the data source includes are recorded accordingly and are faced described in insertion When table.
Still by taking table 2 and table 3 as an example, then interim table is as shown in table 4.
The interim table of table 4
Student name Overall scores
Zhang San 178
Li Si 168
King five 179
Step S104: according to the interim table and first name set, the pending data table is carried out more New and/or insertion.
Since the first name set includes to connect the number to be processed when the pending data table is arranged for being characterized in According to the condition of contact of table and the data source, and the first name set includes while belonging to the data source and the number to be processed As belong to simultaneously according at least one field name of table due to belonging to the field name of data source and pending data table simultaneously In the field name of interim table and pending data table, therefore the first name set includes described to be processed for being characterized in setting The condition of contact of the pending data table Yu the interim table is connected when tables of data.
For example, condition of contact can when being updated according to interim table shown in table 4 to pending data table shown in table 3 Think " student name ".Updated table 3 is as follows:
Table 5 be updated after the corresponding tables of data of table 3
Student name Overall scores
Zhang San 178
Li Si 168
Zhao six 167
King five 179
In the embodiment of the present invention, the corresponding configuration attribute of a pending data table, in practical applications, if user needs M (M is more than or equal to 1 positive integer) a tables of data in database is updated, then needs to preset M configuration and belongs to Property, when each configuration attribute is targeted configuration attribute, it is necessary to execute step S102 to step S104;M data Table can recycle and execute M step S101 to step S104, can also respectively executing for each tables of data with parallel distributed Step S101 to step S104.
User can only need that a M configuration attribute is arranged when initial, not need for M pending data Table writes M different update sentences and insertion sentence.Therefore the operation of user is simplified.
In data processing method provided in an embodiment of the present invention, by by least one pre-set configuration attribute of user It is determined as target configuration attribute one by one, data source will be belonged to and belongs to the field name of pending data table, is added to second place Claim set;Interim table is created according to the second name set and data source;According to the interim table and the first title collection It closes, the pending data table is updated and/or is inserted into.In the whole process, user can only need to set when initial Set one or more configuration attributes, rear extended meeting tables of data to be processed is updated according to the content that configuration attribute includes and Insertion does not need to write update sentence and insertion sentence for each pending data table.Therefore the operation of user is simplified.
It is provided in an embodiment of the present invention " at least one pre-set configuration attribute to be determined as target configuration one by one to belong to Property " implementation there are many, the embodiment of the present invention provide but be not limited to following several:
The first, using the form of configuration file.
As shown in Fig. 2, being in data processing method provided in an embodiment of the present invention by least one pre-set configuration Attribute is determined as a kind of method flow schematic diagram of implementation of target configuration attribute one by one, this method comprises:
Step S201: at least one data acquisition system is obtained from pre-set configuration file.
Configuration file in the embodiment of the present invention can be XML (Extensible Markup Language, expansible volume Volume language) format configuration file, in one embodiment, the content of configuration file may include:
<? xmlversion=" 1.0 " encoding=" utf-8 "?>
<processlist>// it is the content that first data acquisition system includes below
<processname="DataMergeProcess1">the title of // data source
<propertyname="ExcludeColumns"value="hour"/>/ * is characterized in the data source and deposits And the field name that is not present in the pending data table, and/or, it is not required to for characterizing in the pending data table ExcludeColumns is known as " excluding to arrange " in the embodiment of the present invention, if this field name by the field name to be set Have it is multiple, then can use comma separate *;If only comprising " being characterized in the data source and existing and in the pending data table In the field name that is not present ", then this line code can have or not have;If comprising " for characterizing the pending data The field name being set is not needed in table " then need this section of code/
Data acquisition system and configuration attribute include data source name, the title of pending data table, exclude the corresponding word of column The information such as name section, the first name set, but data acquisition system may be different from the format of configuration attribute, for example, data acquisition system Belong to XML format, configuration attribute may be an element in array.
Step S202: at least one described data acquisition system is converted into preset format and corresponding to data acquisition system quantity Configuration attribute.
Data acquisition system can be converted into class, in one embodiment, can use following code to each data acquisition system into Row format conversion needs definition and corresponding class after configuration file serializing, optionally can be such that
Above-mentioned code is to define ProcessList class, includes two elements in ProcessList class, i.e. process and PropertyList;Wherein, process is the title of data source, and PropertyList is comprising excluding to arrange corresponding field name Claim, the class of the title of the condition of contact that connects the pending data table and the data source, pending data table.List is The example of PropertyList class.
This section of code is the definition of the format for the content for including to PropertyList, wherein Property is a class, Including the condition of contact for excluding to arrange corresponding field name, connect the pending data table and the data source. Properties is the example of Property class.
This section of code is the definition to Property, wherein " name " in Property refers to ExcludeColumns Or MatchColumns or TargetTableName;By taking first data acquisition system as an example, when " name " is ExcludeColumns When, " value " is hour;When " name " be MatchColumns when, " value " be DateTimeKey, Gsadid, Gender;;When " name " is TargetTableName, " value " is WechatGenderDistribution.
Step S203: array is generated according to all configuration attributes, a configuration attribute is an element in the array.
All configuration attributes can be converted to each element in an array by following code in one embodiment.
XmlSerializer xs=newXmlSerializer (typeof (ProcessList));
FileStream fs=newFileStream (path, FileMode.Open, FileAccess.Read);
ProcessListprocessList=(ProcessList) xs.Deserialize (fs).
Step S204: all elements in the array are determined as target configuration attribute one by one.
The advantages of configuration attribute is arranged using configuration file is: the name of data source of the user in modification configuration file When title, the title of pending data table, exclusion arrange corresponding field name, condition of contact, modification program is not needed, is not needed yet Program is recompilated and is issued, directly modification configuration file.Disadvantage is: needing to define configuration file serializing Corresponding class afterwards, and realize serializing operation.
In order to avoid disadvantages mentioned above, the embodiment of the invention provides second methods.
Second: the information solicitation for including by configuration attribute is in class.
As shown in figure 3, in a kind of data processing method provided in an embodiment of the present invention by pre-set at least one A configuration attribute is determined as the method flow schematic diagram of the another implementation of target configuration attribute one by one, this method comprises:
Step S301: at least one pre-set Attribute class is determined as objective attribute target attribute class one by one.
Step S302: the target configuration attribute is obtained from the objective attribute target attribute class.
In one embodiment, following Attribute class can optionally be defined:
User, can be as follows directly to StoreTable class assignment when presetting configuration attribute:
Wherein, processname refers to the title of data source;TableName refers to the title of pending data table; MatchColumns refers to the condition of contact for connecting the pending data table and the data source;ExcludeColumns is row Except the corresponding field name of column.
If pending data table has multiple, respective number Attribute class StoreTable can be created and assigned corresponding Value.
Second method does not need Additional definitions configuration file and corresponding serializing class etc.;But works as and need to data When the information such as title, the title of pending data table, the corresponding field name of exclusion column in source are updated, need to modify journey Sequence, and need to recompilate program and issued.
What is provided in the embodiment of the present invention " will belong to the data source and belongs to the field name of the pending data table Claim, be added to the second name set " implementation there are many, the embodiment of the present invention provide but be not limited to following several:
The first: will belong to the data source and belong to the field name of the pending data table, be added to second place Claim set method include:
According to the title of the pending data table, obtaining includes the of all field names in the pending data table Four name sets;
According to the title of the data source, the 4th set including all records in the data source is obtained;
The data source will be belonged to and belong to the field name of the pending data table, is added to the second title collection It closes.
Second: target configuration attribute can also include: to exist and described for being characterized in the data source wait locate The field name being not present in reason tables of data, and/or, the field being set is not needed for characterizing in the pending data table The third name set of title.The data source will be belonged to and belong to the field name of the pending data table, is added to The method of two name sets includes:
The data source will be belonged to and be not belonging to the field name of the third name set, is added to effectively column set In ValidColumnsArray;The pending data table will be belonged to and belong to effective field name for arranging set, addition To second name set.
Since the field name that the field name that data source includes may include with pending data table is not quite similar, example Such as, the number for the column that data source includes may be more than the number for the column that pending data table includes;Or, one that data source includes Or multiple field names are not present in pending data table, or, data source and pending data table include a field name Claim B, but does not need to be updated the corresponding value of field name B.
It, may be because of data source and pending data if direct basis data source is configured tables of data to be processed The number or field name arranged in table mismatches and fails, and is worth accordingly or, being provided with the undesirable field name being set, because This, needs to be implemented above-mentioned steps.
If configuration attribute is to be configured in the form of configuration file, and configuration attribute includes excluding to arrange corresponding word Name section then can parse the value value (for example, hour) of ExcludeColumns;When ExcludeColumns has multiple values When, it can respectively be separated with comma between value, so can separate comma when parsing the value value of ExcludeColumns Value successively stores in character string dimension variable ExcludeColumnsArray.If configuration attribute is arranged using Attribute class, Then according to the ExcludeColumns attribute value in the Table example of creation, the value that comma separates successively is stored to character string In aray variable ExcludeColumnsArray.
Data source can be read to DataTable, and (DataTable is in the memory of an interim preservation relation data One table) in, all field names in DataTable are recycled, field name is not present in ExcludeColumnsArray number The field name of group is added in effectively column set ValidColumnsArray.
All field names for inquiring pending data table from database according to TargetTableName will include The set of all field names of pending data table is TargetTableAllColumns, and specific code can be such that
Whether each field name is present in judgement effectively column set ValidColumnsArray ValidColumnsArray, if it is present being added in the second name set Mapping, optional specific code is such as Under:
It is provided in an embodiment of the present invention " according to the interim table and first name set, to the number to be processed It is updated and/or is inserted into according to table " there are many implementations, as shown in figure 4, being data processing side provided in an embodiment of the present invention The pending data table is updated and/or is inserted into according to the interim table and first name set in method one The method flow schematic diagram of kind implementation, this method comprises:
Step S401: all field names for including by the first name set described in the pending data table are corresponding Value, value corresponding with all field names that the first name set described in the interim table includes are matched.
Step S402: all field names that the first name set described in the pending data table includes are corresponding When first value the first value corresponding with all field names that the first name set described in the interim table includes matches, then First value in the pending data table is recorded accordingly and is updated to the corresponding record of the first value in the interim table.
For the interim table shown in the table 4 is configured pending data table shown in table 3, it is assumed that condition of contact is " student name ", Zhang San matches with the Zhang San in table 4 in table 3, at this time according to the corresponding record of Zhang San in interim table (" Three ", " 178 ") record (" Zhang San ", " 178 ") in table 3 is updated;Li Si matches with Li Si in table 4 in table 3, at this time The record (" Li Si ", " 157 ") in table 3 is updated according to the corresponding record (" Li Si ", " 168 ") of Li Si in interim table.
Step S403: all field names that the first name set described in the pending data table includes are corresponding When value second value corresponding with all field names that the first name set described in the interim table includes does not match that, Insertion belongs to the corresponding record of the second value of the interim table in the pending data table.
" king still by taking temporarily table is configured pending data table shown in table 3 shown in table 4 as an example, in interim table Five " any values corresponding with " student name " in table 3 mismatch, by " king five " in interim table it is corresponding record (" king five ", " 179 ") it is inserted into table 3, the table 3 after being set is as shown in table 5.
In one embodiment, according to interim table DataTable and the first name set, tables of data to be processed is updated Code can be such that
In the embodiment of the present invention can by configuration file configure ExcludeColumns, MatchColumns and TargetTableName generates the data insertion for being suitable for all pending data tables and the Merge sentence for updating operation, at It solves to function when data are carried out database purchase and updated, needs all to write every tables of data of database insertion and more The problem of troublesome operation of new sentence.The maintenance for not only reducing code, reduces code bug amount, at the same point of the present invention with Specific business is unrelated, therefore can be adapted for the scene of institute's data insertion and update in need, improves efficiency of research and development.
The example of class can also be arranged by creation attribute and operate relevant attribute to Merge for the embodiment of the present invention assigns Value generates the data insertion for being suitable for all pending data tables and the Merge sentence for updating operation, successfully solves logarithm When according to carrying out database purchase and update, needs all to write every tables of data of database insertion and update the cumbersome behaviour of sentence The problem of making.The maintenance for not only reducing code reduces code bug amount, while point of the present invention is unrelated with specific business, because This can be adapted for data in need insertion and the scene that updates, improve efficiency of research and development.
Preferably, the embodiment of the present invention is updated tables of data to be processed according to interim table and the first name set Afterwards, interim table can be deleted, because deleting interim table not in time, as the tables of data of update is more and more, so that depositing in memory It contains many interim tables and will affect processing speed since data volume stored in memory is increasing.
The embodiment of the invention also provides a kind of data processing equipments corresponding with data processing method, below to data at Reason device is illustrated, as shown in figure 5, being a kind of structure chart of data processing equipment provided in an embodiment of the present invention, the device Include:
Determining module 51, at least one pre-set configuration attribute to be determined as target configuration attribute one by one;Its In, the target configuration attribute includes: the title of pending data table;Data for characterizing the pending data table update The title of the data source in source;Comprising for be characterized in be arranged the pending data table when connect the pending data table with First name set of the condition of contact of the data source, first name set include while belonging to the data source and institute State at least one field name of pending data table;
Adding module 52, for that will belong to the data source and belong to the field name of the pending data table, addition To the second name set;
Creation module 53, it is described interim for creating interim table according to second name set and the data source The field name of table includes all field names that second name set includes, and the record in the interim table includes belonging to It the data source and corresponding with all field names that second name set includes records;
Setup module 54 is used for according to the interim table and first name set, to the pending data table It is updated and/or is inserted into.
It is by determining module 51 that user is pre-set extremely first in data processing equipment provided in an embodiment of the present invention A few configuration attribute is determined as target configuration attribute one by one, then will belong to data source by adding module 52 and belong to be processed The field name of tables of data is added to the second name set;Then by creation module 53 according to the second name set and number Interim table is created according to source;Finally by setup module 54 according to the interim table and first name set, to it is described to Processing tables of data is updated and/or is inserted into.In the whole process, user can only need to be arranged when initial one or more Configuration attribute, rear extended meeting are updated tables of data to be processed according to the content that configuration attribute includes, and do not need for every One pending data table writes update sentence.Therefore the operation of user is simplified.
Optionally, the determining module includes:
First acquisition unit, for obtaining at least one data acquisition system from pre-set configuration file;
Converting unit, for by least one described data acquisition system be converted into preset format and with data acquisition system quantity Corresponding configuration attribute;
Generation unit, for generating array according to all configuration attributes, a configuration attribute is an element in the array;
First determination unit, for all elements in the array to be determined as target configuration attribute one by one.
Optionally, the determining module includes:
Second determination unit, at least one pre-set Attribute class to be determined as objective attribute target attribute class one by one;
Second acquisition unit, for obtaining the target configuration attribute from the objective attribute target attribute class.
Optionally, the target configuration attribute can also include: to exist and for being characterized in the data source described The field name being not present in pending data table, and/or, it does not need to be set in the pending data table for characterizing The third name set of field name, the adding module include:
First adding unit, for that will belong to the data source and be not belonging to the field name of the third name set, It is added in effectively column set;
Second adding unit, for that will belong to the pending data table and belong to effective field name for arranging set Claim, is added to second name set.
Optionally, the creation module includes:
Creating unit, for creating the interim table including all field names in second name set;
First insertion unit, all field names for including by the second name set described in the data source are corresponding Record be inserted into the interim table.
Optionally, setup module includes:
Matching unit, all field name phases for including by the first name set described in the pending data table The value answered, value corresponding with all field names that the first name set described in the interim table includes are matched;
Replacement unit, all field name phases for including for working as the first name set described in the pending data table The first value answered the first value corresponding with all field names that the first name set described in the interim table includes matches When, then the first value in the pending data table is recorded accordingly and is updated to the corresponding record of the first value in the interim table;
Second insertion unit, all field names for including for working as the first name set described in the pending data table Claim corresponding value second value corresponding with all field names that the first name set described in the interim table includes not phase When matching, insertion belongs to the corresponding record of the second value of the interim table in the pending data table.
Optionally, further includes: removing module, for deleting the interim table.
The data processing equipment includes processor and memory, above-mentioned determining module 51, adding module 52, creation module 53 and setup module 54 etc. store in memory as program unit, are executed by processor stored in memory above-mentioned Program unit realizes corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one Or more, configuration attribute is set by adjusting kernel parameter, to realize that only this is simple by user setting configuration attribute The purpose that tables of data to be processed is updated and is inserted into is realized in operation.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/ Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM), memory includes at least one storage Chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor The existing data processing method.
The embodiment of the invention provides a kind of processor, the processor is for running program, wherein described program operation Data processing method described in Shi Zhihang.
The embodiment of the invention provides a kind of equipment, equipment include processor, memory and storage on a memory and can The program run on a processor, processor perform the steps of when executing program
At least one pre-set configuration attribute is determined as target configuration attribute one by one;Wherein, the target configuration Attribute includes: the title of pending data table;For characterizing the data source of the data more new sources of the pending data table Title;The company of the pending data table and the data source is connected when comprising the pending data table is arranged for being characterized in First name set of narrow bars part, first name set include while belonging to the data source and the pending data table At least one field name;
The data source will be belonged to and belong to the field name of the pending data table, is added to the second name set;
Interim table is created according to second name set and the data source, the field name of the interim table includes All field names that second name set includes, the record in the interim table include belong to the data source and with institute All field names that the second name set includes are stated to record accordingly;
According to the interim table and first name set, the pending data table is updated and/or is inserted Enter.
Optionally, at least one pre-set configuration attribute is determined as target configuration attribute in execution by processor one by one When, it is specifically used for:
At least one data acquisition system is obtained from pre-set configuration file;
At least one described data acquisition system is converted into preset format and corresponding with data acquisition system quantity configures category Property;
Array is generated according to all configuration attributes, a configuration attribute is an element in the array;
All elements in the array are determined as target configuration attribute one by one.
Optionally, at least one pre-set configuration attribute is determined as target configuration attribute in execution by processor one by one When, it is specifically used for:
At least one pre-set Attribute class is determined as objective attribute target attribute class one by one;
The target configuration attribute is obtained from the objective attribute target attribute class.
The target configuration attribute can also include: to exist and for being characterized in the data source in the number to be processed According to the field name being not present in table, and/or, the field name being set is not needed for characterizing in the pending data table Third name set, processor will belong to the data source and belongs to the field name of the pending data table executing, When being added to the second name set, it is specifically used for:
The data source will be belonged to and be not belonging to the field name of the third name set, is added to effectively column set In;
The pending data table will be belonged to and belong to effective field name for arranging set, be added to the second place Claim set.
Optionally, processor is when executing according to second name set and the data source interim table of creation, tool Body is used for:
Creation includes the interim table of all field names in second name set;
All field names that second name set described in the data source includes are recorded accordingly and are faced described in insertion When table.
Optionally, processor is being executed according to the interim table and first name set, to the number to be processed When being updated and/or be inserted into according to table, it is specifically used for:
All field names that first name set described in the pending data table includes are worth accordingly, and it is described Value is matched all field names that first name set described in interim table includes accordingly;
Corresponding first value of all field names that the first name set described in the pending data table includes with When corresponding first value of all field names that first name set described in the interim table includes matches, by described wait locate The first value records accordingly in reason tables of data is updated to the corresponding record of the first value in the interim table;
All field names that the first name set described in the pending data table includes accordingly value with it is described When the corresponding second value of all field names that first name set described in interim table includes does not match that, described wait locate Insertion belongs to the corresponding record of the second value of the interim table in reason tables of data.
Optionally, processor can be also used for:
Delete the interim table.
Equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just The program of beginningization there are as below methods step:
At least one pre-set configuration attribute is determined as target configuration attribute one by one;Wherein, the target configuration Attribute includes: the title of pending data table;For characterizing the data source of the data more new sources of the pending data table Title;The company of the pending data table and the data source is connected when comprising the pending data table is arranged for being characterized in First name set of narrow bars part, first name set include while belonging to the data source and the pending data table At least one field name;
The data source will be belonged to and belong to the field name of the pending data table, is added to the second name set;
Interim table is created according to second name set and the data source, the field name of the interim table includes All field names that second name set includes, the record in the interim table include belong to the data source and with institute All field names that the second name set includes are stated to record accordingly;
According to the interim table and first name set, the pending data table is updated and/or is inserted Enter.
Optionally, program " at least one pre-set configuration attribute is determined as target configuration attribute one by one " can wrap Include following procedure:
At least one data acquisition system is obtained from pre-set configuration file;
At least one described data acquisition system is converted into preset format and corresponding with data acquisition system quantity configures category Property;
Array is generated according to all configuration attributes, a configuration attribute is an element in the array;
All elements in the array are determined as target configuration attribute one by one.
Optionally, program " at least one pre-set configuration attribute is determined as target configuration attribute one by one " can wrap Include following procedure:
At least one pre-set Attribute class is determined as objective attribute target attribute class one by one;
The target configuration attribute is obtained from the objective attribute target attribute class.
Optionally, the target configuration attribute can also include: to exist and for being characterized in the data source described The field name being not present in pending data table, and/or, it does not need to be set in the pending data table for characterizing The third name set of field name, program " data source will be belonged to and belongs to the field name of the pending data table, It is added to the second name set " may include following procedure:
The data source will be belonged to and be not belonging to the field name of the third name set, is added to effectively column set In;
The pending data table will be belonged to and belong to effective field name for arranging set, be added to the second place Claim set.
Optionally, program " creating interim table according to second name set and the data source " can also include with Lower program:
Creation includes the interim table of all field names in second name set;
All field names that second name set described in the data source includes are recorded accordingly and are faced described in insertion When table.
Optionally, program " according to the interim table and first name set, carries out the pending data table Update and/or be inserted into " may include following procedure:
All field names that first name set described in the pending data table includes are worth accordingly, and it is described Value is matched all field names that first name set described in interim table includes accordingly;
Corresponding first value of all field names that the first name set described in the pending data table includes with When corresponding first value of all field names that first name set described in the interim table includes matches, by described wait locate The first value records accordingly in reason tables of data is updated to the corresponding record of the first value in the interim table;
All field names that the first name set described in the pending data table includes accordingly value with it is described When the corresponding second value of all field names that first name set described in interim table includes does not match that, described wait locate Insertion belongs to the corresponding record of the second value of the interim table in reason tables of data.
Optionally, can also include following procedure:
Delete the interim table.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more, The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates, Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/ Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM).Memory is computer-readable medium Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data. The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM), Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product. Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art, Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement, Improve etc., it should be included within the scope of the claims of this application.

Claims (10)

1. a kind of data processing method characterized by comprising
At least one pre-set configuration attribute is determined as target configuration attribute one by one;Wherein, the target configuration attribute It include: the title of pending data table;For characterizing the title of the data source of the data more new sources of the pending data table; The connection strap of the pending data table and the data source is connected when comprising the pending data table is arranged for being characterized in First name set of part, first name set include belonging to the data source and the pending data table simultaneously extremely A few field name;
The data source will be belonged to and belong to the field name of the pending data table, is added to the second name set;
Interim table is created according to second name set and the data source, the field name of the interim table includes described All field names that second name set includes, the record in the interim table include belonging to the data source and with described the All field names that two name sets include record accordingly;
According to the interim table and first name set, the pending data table is updated and/or is inserted into.
2. data processing method according to claim 1, which is characterized in that described to belong at least one pre-set configuration Property is determined as target configuration attribute one by one
At least one data acquisition system is obtained from pre-set configuration file;
At least one described data acquisition system is converted into preset format and configuration attribute corresponding with data acquisition system quantity;
Array is generated according to all configuration attributes, a configuration attribute is an element in the array;
All elements in the array are determined as target configuration attribute one by one.
3. data processing method according to claim 1, which is characterized in that described to belong at least one pre-set configuration Property is determined as target configuration attribute one by one
At least one pre-set Attribute class is determined as objective attribute target attribute class one by one;
The target configuration attribute is obtained from the objective attribute target attribute class.
4. according to claim 1 to 3 any data processing methods, which is characterized in that the target configuration attribute can be with Include: for being characterized in the field name for existing in the data source and being not present in the pending data table, and/or, For characterizing the third name set for not needing the field name being set in the pending data table, it is described will belong to it is described Data source and the field name for belonging to the pending data table, being added to the second name set includes:
The data source will be belonged to and be not belonging to the field name of the third name set, is added in effectively column set;
The pending data table will be belonged to and belong to effective field name for arranging set, be added to the second title collection It closes.
5. according to claim 1 to 3 any data processing methods, which is characterized in that described according to the second title collection It closes and the interim table of data source creation includes:
Creation includes the interim table of all field names in second name set;
All field names that second name set described in the data source includes are recorded into the insertion interim table accordingly.
6. according to claim 1 to 3 any data processing methods, which is characterized in that it is described according to the interim table and First name set, is updated and/or is inserted into the pending data table and include:
All field names that first name set described in the pending data table includes are worth accordingly, and it is described interim Value is matched all field names that first name set described in table includes accordingly;
Corresponding first value of all field names that the first name set described in the pending data table includes with it is described When corresponding first value of all field names that first name set described in interim table includes matches, by the number to be processed It is recorded accordingly according to the first value in table and is updated to the corresponding record of the first value in the interim table;
All field names that the first name set described in the pending data table includes value and described interim accordingly When the corresponding second value of all field names that first name set described in table includes does not match that, in the number to be processed Belong to the corresponding record of the second value of the interim table according to insertion in table.
7. data processing method according to claim 1, which is characterized in that further include:
Delete the interim table.
8. a kind of data processing equipment characterized by comprising
Determining module, at least one pre-set configuration attribute to be determined as target configuration attribute one by one;Wherein, described Target configuration attribute includes: the title of pending data table;For characterizing the data more new sources of the pending data table The title of data source;The pending data table and the number are connected when comprising the pending data table is arranged for being characterized in According to the first name set of the condition of contact in source, first name set includes while belonging to the data source and described wait locate Manage at least one field name of tables of data;
Adding module is added to second for that will belong to the data source and belong to the field name of the pending data table Name set;
Creation module, for creating interim table, the word of the interim table according to second name set and the data source Name section includes all field names that second name set includes, and the record in the interim table includes belonging to the number According to source and corresponding with all field names that second name set includes record;
Setup module, for being carried out more to the pending data table according to the interim table and first name set New and/or insertion.
9. a kind of storage medium, is stored thereon with program, which is characterized in that realize such as right when described program is executed by processor It is required that 1 to 7 described in any item data processing methods.
10. a kind of processor, the processor is for running program, which is characterized in that execute such as right when described program is run It is required that 1 to 7 described in any item data processing methods.
CN201710697072.XA 2017-08-15 2017-08-15 Data processing method, data processing device, storage medium and processor Active CN110019111B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710697072.XA CN110019111B (en) 2017-08-15 2017-08-15 Data processing method, data processing device, storage medium and processor

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710697072.XA CN110019111B (en) 2017-08-15 2017-08-15 Data processing method, data processing device, storage medium and processor

Publications (2)

Publication Number Publication Date
CN110019111A true CN110019111A (en) 2019-07-16
CN110019111B CN110019111B (en) 2021-11-23

Family

ID=67186078

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710697072.XA Active CN110019111B (en) 2017-08-15 2017-08-15 Data processing method, data processing device, storage medium and processor

Country Status (1)

Country Link
CN (1) CN110019111B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110532273A (en) * 2019-08-30 2019-12-03 北京明略软件系统有限公司 The processing method and processing device of tables of data, storage medium, electronic device
CN110555071A (en) * 2019-09-03 2019-12-10 北京明略软件系统有限公司 Data fusion processing method and device, storage medium and electronic device
CN111046642A (en) * 2019-11-11 2020-04-21 中国建设银行股份有限公司 Method and device for improving generation efficiency of combined identification of subject code
CN111125067A (en) * 2019-12-31 2020-05-08 中国银行股份有限公司 Data maintenance method and device
CN112765188A (en) * 2020-12-31 2021-05-07 北京奇艺世纪科技有限公司 Configuration information processing method, configuration management system, electronic device, and storage medium

Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102065413A (en) * 2010-11-17 2011-05-18 北京北方烽火科技有限公司 Database updating method and system, and base station self-starting method and system
CN102096684A (en) * 2009-12-11 2011-06-15 华大天元(北京)电力科技有限公司 Grid real-time data integrating and sharing platform
CN103544323A (en) * 2013-11-08 2014-01-29 中国农业银行股份有限公司 Data updating method and device
CN103605776A (en) * 2013-11-28 2014-02-26 北京国双科技有限公司 Method and device for processing data of information database
US20140279830A1 (en) * 2013-03-15 2014-09-18 International Business Machines Corporation Data integration using automated data processing based on target metadata
CN104317974A (en) * 2014-11-21 2015-01-28 武汉理工大学 Reconfigurable multi-source data importing method in ERP system
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
CN105589874A (en) * 2014-10-22 2016-05-18 阿里巴巴集团控股有限公司 ETL task dependence relationship detecting method and device and ETL tool
CN106126753A (en) * 2016-08-23 2016-11-16 易联众信息技术股份有限公司 The method of increment extractions based on big data
CN106325933A (en) * 2016-08-24 2017-01-11 明算科技(北京)股份有限公司 Method and device for synchronizing batch data
CN106611062A (en) * 2016-12-29 2017-05-03 北京奇虎科技有限公司 Database updating method and device
US20170206208A1 (en) * 2016-01-20 2017-07-20 Oracle International Corporation System and method for merging a mainframe data file to a database table for use by a mainframe rehosting platform

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102096684A (en) * 2009-12-11 2011-06-15 华大天元(北京)电力科技有限公司 Grid real-time data integrating and sharing platform
CN102065413A (en) * 2010-11-17 2011-05-18 北京北方烽火科技有限公司 Database updating method and system, and base station self-starting method and system
US20140279830A1 (en) * 2013-03-15 2014-09-18 International Business Machines Corporation Data integration using automated data processing based on target metadata
CN103544323A (en) * 2013-11-08 2014-01-29 中国农业银行股份有限公司 Data updating method and device
CN103605776A (en) * 2013-11-28 2014-02-26 北京国双科技有限公司 Method and device for processing data of information database
CN105589874A (en) * 2014-10-22 2016-05-18 阿里巴巴集团控股有限公司 ETL task dependence relationship detecting method and device and ETL tool
CN104317974A (en) * 2014-11-21 2015-01-28 武汉理工大学 Reconfigurable multi-source data importing method in ERP system
CN105447122A (en) * 2015-11-16 2016-03-30 中国人民解放军理工大学 Implementation method for autonomously creating file system based on multi-table association
US20170206208A1 (en) * 2016-01-20 2017-07-20 Oracle International Corporation System and method for merging a mainframe data file to a database table for use by a mainframe rehosting platform
CN106126753A (en) * 2016-08-23 2016-11-16 易联众信息技术股份有限公司 The method of increment extractions based on big data
CN106325933A (en) * 2016-08-24 2017-01-11 明算科技(北京)股份有限公司 Method and device for synchronizing batch data
CN106611062A (en) * 2016-12-29 2017-05-03 北京奇虎科技有限公司 Database updating method and device

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
ZHENYOU ZHANG 等: "Research and implementation for data synchronization of heterogeneous databases", 《2010 INTERNATIONAL CONFERENCE ON COMPUTER AND COMMUNICATION TECHNOLOGIES IN AGRICULTURE ENGINEERING》 *

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110532273A (en) * 2019-08-30 2019-12-03 北京明略软件系统有限公司 The processing method and processing device of tables of data, storage medium, electronic device
CN110555071A (en) * 2019-09-03 2019-12-10 北京明略软件系统有限公司 Data fusion processing method and device, storage medium and electronic device
CN111046642A (en) * 2019-11-11 2020-04-21 中国建设银行股份有限公司 Method and device for improving generation efficiency of combined identification of subject code
CN111125067A (en) * 2019-12-31 2020-05-08 中国银行股份有限公司 Data maintenance method and device
CN111125067B (en) * 2019-12-31 2024-02-23 中国银行股份有限公司 Data maintenance method and device
CN112765188A (en) * 2020-12-31 2021-05-07 北京奇艺世纪科技有限公司 Configuration information processing method, configuration management system, electronic device, and storage medium
CN112765188B (en) * 2020-12-31 2023-09-08 北京奇艺世纪科技有限公司 Configuration information processing method, configuration management system, electronic device and storage medium

Also Published As

Publication number Publication date
CN110019111B (en) 2021-11-23

Similar Documents

Publication Publication Date Title
CN110019111A (en) Data processing method, device, storage medium and processor
CN105094707B (en) A kind of data storage, read method and device
CN107644286A (en) Workflow processing method and device
CN106557486A (en) A kind of storage method and device of data
CN107122368A (en) A kind of data verification method, device and electronic equipment
CN103810275A (en) Method and device for data interaction between non-relation type database and relation type database
EP2965492B1 (en) Selection of data storage settings for an application
CN105868421A (en) Data management method and data management device
CN110008743A (en) Data attribute identification method, device and equipment in a kind of piece of chain type account book
CN106897342A (en) A kind of data verification method and equipment
CN106844288A (en) A kind of random string generation method and device
CN104714957A (en) List structure changing method and device
CN105373376A (en) Method and apparatus for configuring a software application
CN105468623A (en) Data processing method and apparatus
CN108427736A (en) A method of for inquiring data
CN108073595A (en) It is a kind of to realize data update and the method and device of snapshot in olap database
CN107609011A (en) The maintaining method and device of a kind of data-base recording
CN106547658A (en) A kind of automated testing method and device
CN110059088A (en) Data attribute identification method, device and equipment in a kind of piece of chain type account book
US9639538B2 (en) Embedding archived data in a data source
CN106294423A (en) Data base divides wiring method and the device of table
CN106294700A (en) The storage of a kind of daily record and read method and device
CN102567544A (en) Database query method and database query device
CN110059087A (en) Data attribute identification method, device and equipment in a kind of piece of chain type account book
CN109977317A (en) Data query method and device

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
CB02 Change of applicant information

Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing

Applicant after: Beijing Guoshuang Technology Co.,Ltd.

Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A

Applicant before: Beijing Guoshuang Technology Co.,Ltd.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant