CN107103035A - This earth's surface data-updating method and device - Google Patents
This earth's surface data-updating method and device Download PDFInfo
- Publication number
- CN107103035A CN107103035A CN201710173048.6A CN201710173048A CN107103035A CN 107103035 A CN107103035 A CN 107103035A CN 201710173048 A CN201710173048 A CN 201710173048A CN 107103035 A CN107103035 A CN 107103035A
- Authority
- CN
- China
- Prior art keywords
- data
- script
- updated
- new
- earth
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24549—Run-time optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
Abstract
The present invention discloses a kind of this earth's surface data-updating method and device, comprise the following steps, receive the data to be updated of user's input, configuration object is updated according to the mapping for updating dictionary lookup data to be updated is corresponding, Format Objectization data to be updated is configured according to updating, forms tables of data to be updated, according to treating that new data table creates the more new script of this earth's surface, the more new script includes newly-increased script, forces script or single script, performs more new script, updates this surface data.Script in this method is automatically generated by local computer according to repository with reference to the already present data of this earth's surface, therefore, it is possible to improve the execution efficiency for safeguarding that the efficiency and script of data to be updated update.
Description
Technical field
The present invention relates to data processing field, more particularly to a kind of this surface data of software renewal side based on C/S frameworks
Method and device.
Background technology
In the enterprises end software of traditional C/S frameworks, to support the individual cultivation of local user, typically matched somebody with somebody using this earth's surface
The mode put realizes that the business configuration record of i.e. standard or acquiescence is stored in a standard scale, and local user is when in use
Directly replicate a set of partial or complete record from standard scale for the user to be stored in this earth's surface, the later user is all
The read-write operation of business configuration is carried out from this earth's surface.
In software running process, the configuration record in the change standard scale of business constantly can also be increased or repaiied
Change, while the record in corresponding earth's surface synchronous must be also updated, be to ensure that the individual cultivation of user is recorded
It is whole reliable.At present, the renewal for this earth's surface is performed using special script mostly, i.e., be per anticipatory remark according to business demand
Earth's surface is individually write script and then performed again.
Shortcoming 1
Because the record in this earth's surface is the dynamic generation in running software, write update sentence when consider it is a variety of not
Same usage scenario, the technical requirements to script sentence writer are higher.
Shortcoming 2:
Sex-limited with database bureau, because may relate to the renewal of special script sentence, each data update APMB package only
Suitable for the renewal of a type of Service Database, the workload and complexity of later stage software maintenance are added.
Shortcoming 3:
Do not possess versatility, defined because this different earth's surfaces is to be directed to different business demands, when writing script
Must be to write more new script again per anticipatory remark earth's surface
The content of the invention
For this reason, it may be necessary to provide a kind of completeness higher this earth's surface data-updating method, data are improved in local computer
On renewal efficiency.
To achieve the above object, a kind of this earth's surface data-updating method is inventor provided, is comprised the following steps, receives and uses
The data to be updated of family input, update configuration object, according to more according to the mapping for updating dictionary lookup data to be updated is corresponding
New configuration Format Objectization data to be updated, form tables of data to be updated, according to treating that new data table creates the renewal pin of this earth's surface
This, the more new script includes newly-increased script, forces script or single script, performs more new script, updates this surface data.
Further, in addition to step, dictionary is updated according to updating repository generation.
Specifically, the data to be updated include Major key, update recording status, more new version number, force to update symbol.
Inventor additionally provides a kind of this earth's surface data update apparatus, including input module, searching modul, formatting mould
Block, script creation module, performing module;
The input module is used for the data to be updated for receiving user's input;
The searching modul is used to update configuration object according to the mapping for updating dictionary lookup data to be updated is corresponding;
The formatting module is used to, according to configuration Format Objectization data to be updated are updated, form tables of data to be updated;
The script creation module is used for basis and treats that new data table creates the more new script of this earth's surface, the more new script bag
Include newly-increased script, force script or single script;
The performing module is used to perform more new script, updates this surface data.
Further, in addition to update dictionary module, the renewal dictionary module be used for according to update repository generation more
New dictionary.
Further, the tables of data to be updated includes Major key, updates recording status, more new version number, forces to update
Symbol.
Prior art is different from, above-mentioned technical proposal is using renewal repository definition mode, it is convenient to different for each
The standard scale of business demand and its dynamic creation of this earth's surface update sentence and perform data renewal.
Business datum form based on data to be updated, can carry out Function Extension according to different business demands, and conveniently
The making of updated data package
Support to force to update simultaneously and single updates, be applicable to different business scenario demands, you can realize to local
The synchronization of business datum, can also avoid resulting in when updating the data user every time is locally configured loss of data.
Script in this method is automatically generated by local computer according to repository with reference to the already present data of this earth's surface, because
This can improve efficiency in terms of two, including:
Safeguard【Data to be updated】Efficiency.A set of basic business data only need to be safeguarded, that is, safeguard to be released every time【Treat
Update the data】In each record value and its more new identifier and version number etc. (pin need not be updated for various scene creations
This), can release quickly renewal bag
The execution efficiency that script updates.Because create update sentence when, dynamically generated, given birth to according to operation flow
Into script sentence it is general it is fairly simple be not related to Complicated Flow (resolution into a plurality of sentence), therefore script sentence is held
Line efficiency is higher.If (complete realized by script may be just more complicated, even relates to the literary styles such as vernier, property during execution
Can be poor, it is more obvious when this earth's surface data volume is bigger.
Brief description of the drawings
Fig. 1 is this earth's surface data-updating method flow chart described in the specific embodiment of the invention;
Fig. 2 is this earth's surface data update apparatus module map described in the specific embodiment of the invention.
Description of reference numerals:
21- input modules
22- searching moduls
23- formatting modules
24- script creation modules
25- performing modules
26- updates dictionary module
Embodiment
To describe the technology contents of technical scheme in detail, feature, the objects and the effects being constructed, below in conjunction with specific reality
Apply example and coordinate accompanying drawing to be explained in detail.
Referring to Fig. 1, being a kind of this earth's surface data-updating method of the present invention, comprise the following steps, it is defeated that S100 receives user
The data to be updated entered, S102 updates configuration object, S104 roots according to the mapping for updating dictionary lookup data to be updated is corresponding
Format Objectization data to be updated are configured according to updating, tables of data to be updated is formed, S106 is according to treating that new data table creates this earth's surface
More new script, the more new script includes newly-increased script, forces script or single script, and S108 performs more new script, updates
This surface data.
Wherein, this earth's surface can be the configured list of software program, in conventional architectures, can be peeled off from standard scale,
Configuration that can be personalized by changing the configuration information presentation user in this earth's surface;Just include needing to update in data to be updated
Configuration categories and update the data, it is described update dictionary at least include aforementioned arrangements classification with configuration object corresponding informance, lead to
Cross and data format to be updated is turned into tables of data to be updated, preferably can extract useful data from form is formatted, improve
The efficiency of script is created, at some other aspect, more new script is created according to tables of data to be updated, on the local computer
Perform, improve the operation efficiency of application program, more quickly complete the data configuration work of this earth's surface.
1 prepares:The renewal repository of tables of data.Each normal data table of the repository main definitions and its associate this earth's surface and match somebody with somebody
Confidence breath etc., parameter and the control parameter of more new technological process etc. are created as subsequently more new script.
1.1 standard scales define information:Standard scale table name, major key field name, Module field name, record version number field name,
Each data to be updated is corresponding【Tables of data to be updated】Table structure.
1.2 earth's surfaces define information:This earth's surface table name, this earth's surface major key name and standard scale associate field name, local user
Field name etc.
2 update dictionary according to repository generation is updated, and in certain embodiments, step can also be carried out in advance:According to more
New repository generation updates dictionary.The renewal configuration object set for updating dictionary for tables of data, it is convenient to carry out specifying object
Quick lookup and positioning.Each object one normal data table of correspondence gather simultaneously in, table defined in object updates
Shi Suoxu association attributes and renewal Row control parameter etc..
3 input data to be updated.The data are this standard scale data to be updated, according to the Map Names of the data
Claim to update and corresponding renewal configuration object O is searched in dictionary1, it is used as follow-up renewal and Row control parameter.Therefore in tool
In the embodiment of body, the data to be updated include Major key, update recording status, more new version number, force to update symbol.Treat more
New data need to only meet the one of which form for updating and arranging in configuration object, while every record need to configure following field
3.1 new record state N:For defining whether the record is that newly-increased record (is issued relative to notebook data heading time
When), 1 is new record, and 0 is common record
3.2 record more new version number V:The version number after change every time is recorded for this
3.3 force to update symbol F:For defining whether to force the record to update corresponding field value, 1 into this earth's surface
To force to update, 0 is optional more new record
4, according to configuration Format Objectization data to be updated are updated, form tables of data T to be updated.Table T is according to incoming number
According to combined standard table defines information to generate, and each incoming data is defined in standard scale defines information corresponding【Treat more
New data table】Table structure
5 create the more new script S1 of standard scale according to tables of data T to be updated
5.1 establishment standard scale records empty sentence
5.2 records of circulation every, generation record addition script set
6 according to renewal configuration object O1, judge currently whether need to create this earth's surface renewal script.If updating configuration object
O1Attribute this earth's surface information be defined be carried out update, otherwise do not perform.
If desired 6.1 create and perform subsequent step in order
6.2 if need not if leap to step 8 and perform
7 create this earth's surface according to tables of data T to be updated updates script S2 sub-processes
7.1 record in tables of data T to be updated, creates and updates set of records ends object R, the attribute R_N tables of the object
Show new record set, attribute R_F represents to force to update set of records ends, and attribute R_O indicates to record the set of records ends of version number
Record in 7.2 pairs of this earth's surfaces is filtered, and is obtained in this earth's surface in already present user object set C, set C
Each object C_U define Customs Assigned Number C_U_C and its used module numbering set C_U_M etc.
7.3 create the newly-increased record script S2_1 sub-processes of this earth's surface
7.3.1 R_N is circulated, wherein one record R_N_1 is obtained
7.3.2 R_N_1 Major key P is obtained1And module value M1
7.3.3 C is circulated, one of user object C_U is obtained
7.3.4 according to Customs Assigned Number C_U_C and M1Judge whether the user of this in this earth's surface has generated M1The record of module, if
It has been generated that, continue follow-up process, otherwise directly judged to return to the script generation that step 7.3.3 performs next user
7.3.5 according to P1And C_U_C values search record into this earth's surface, one record of establishment adds if record is not found
Plus script, otherwise do not create script
7.3.6 repeat step 7.3.3 is completed until all local users record script under record R_N_1 is created, and is chased after
It is added in local script set
7.3.7 repeat step 7.3.1 is completed until all new record scripts are created
7.4 create the pressure more new script S2_2 sub-processes of this earth's surface
7.4.1 circulation is forced to update set of records ends R_F, obtains wherein one record R_F_1
7.4.2 record R_F_1 Major key P is obtained2
7.4.3 user object set C is circulated, one of user C_U is obtained
7.4.4 according to P2And C_U_C searches the record Major key LP under the user into this earth's surface2
If 7.4.5 judging LP2Value is not the empty record more new script for then creating this earth's surface, is not otherwise created
7.4.6 repeat step 7.4.3 has been created until the script of all local users, and is appended to local script set
In
7.4.7 repeat step 7.4.1 is until all records for forcing to update, and the local record script corresponding to it is all created
It is complete
7.5 create the single more new script S2_3 sub-processes of this earth's surface
7.5.1 circulation has the set of records ends R_O of record version number, obtains wherein one record R_O_1
7.5.2 record R_O_1 Major key P is obtained3, record version number V3
7.5.3 C is circulated, one of user C_U is obtained
7.5.4 according to P3And C_U_C searches the record Major key LP under the user into this earth's surface3
7.5.5 according to P3And V3Create the renewal sentence of a local record.(version number of local record is not equal to V3When
Update)
7.5.6 repeat step 7.5.3 has been created until the script of all local users, and is appended in script set
7.5.7 repeat step 7.5.1 has been created until the more new script of all records
More new script after 8 all establishments of assembling forms total script set S
Batch performs all script S, and the record for completing current radix table and its this earth's surface updates
In following embodiments, we introduce the inventive method by taking specific tables of data to be updated as an example;
【Benchmark service switch list】And its this surface data needs to update
The first step:
Prepare the renewal repository of base data table, it is defined as follows:
Base data table table name:SYS_C_BIZ_SWITCH;
Major key field name:SWITCH_ID
Module field name:MODULE_ID
Record version number field name:UPDATE_SIGN
This earth's surface table name:SYS_L_BIZ_SWITCH
This earth's surface major key field name:RECORD_ID
With the associate field name of standard scale:SWITCH_ID
Local user's field name:USER_ID
In business library【Benchmark service switch list】Stored record it is as follows
Switch number | Switch names | Value | Module is numbered | Record version number |
C_001 | Business switch 1 | 1 | 0101 | 1000 |
C_002 | Business switch 2 | 1 | 0101 | 1000 |
C_003 | Business switch 3 | 0 | 0101 | 1000 |
C_004 | Business switch 4 | 0 | 0102 | 1000 |
C_005 | Business switch 5 | 1 | 0102 | 1000 |
C_006 | Business switch 6 | 1 | 0103 | 1000 |
Table 1.2
In business library【Local user's switch list】Data storage be
Table 1.3
Table 1.3, is represented【Local user's switch list】In be created that three sets of control datas for three local users, wherein
● user User01, possess module 0101 and 0,103 two groups of data, and be R_002 and R_004 to wherein numbering
Local record Configuration Values carried out modification
● user User02, possess module 0102 and 0,103 two groups of data, and to wherein numbering the local note for being R_006
Record Configuration Values carried out modification
● user User03, possess 0,103 1 groups of data of module, while not changing the Configuration Values of local record
Note:Red packet part represents the data changed after being contrasted with Current standards table
Second step:
Dictionary is updated according to according to renewal repository generation
3rd step:
Input data (the benchmark service switch list data to be updated) to be updated, its data is as follows
Table 1.6
Table 1.6, represents that basic data updates bag【Benchmark service switch list】Record in relative business storehouse has following
Change:
● newly-increased two records C_007 and C_008
● the record C_002 that modification one commonly updates
● the record C_005 and C_006 updated is forced in modification two
4th step:
By data format to be updated into specified tables of data T to be updated, convenient follow-up establishment more new script.
5th step:
Create【Benchmark service switch list】More new script
1. creating record empties script:DELETE FROM SYS_C_BIZ_SWITCH
2. all records in T are read in circulation, and are every record dynamic creation insertion sentence,
Such as:
INSERT INTO SYS_C_BIZ_SWITCH(SWITCH_ID,SWITCH_NAME,SWITCH_VALUE,
MODULE_ID, VERSION_NO) VALUES (' C_001', ' business switch ', 1, ' 0101', ' 1000')
6th step:
According to【Benchmark service switch list】Configuration object, acquisition be currently needed for create this earth's surface update script, therefore continue
The execution of follow-up process.
7th step:
Start to create【Local service switch list】More new script sub-process
7.1 according to tables of data T to be updated, creates and updates set of records ends object R1, wherein
New record R_N:C_007、C_008
Force more new record R_F:C_005、C_006
Single more new record R_O:C_002, C_007, C_008 (C_005, C_006 because being to force to update, therefore direct mistake
Filter)
7.2 obtain the user object set C of this earth's surface
User 1 (C_U1):User01, module:0101、0103
User 2 (C_U2):User02, module:0102、0103
User 3 (C_U3):User03, module:0103
7.3 create【Local service switch list】Newly-increased record script, according to newly-increased following 4 records of flow
User's switch number | Switch number | Switch names | Switch value | Module is numbered | Customs Assigned Number | Record version number |
R_009 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User01 | 1001 |
R_010 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User02 | 1001 |
R_011 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User03 | 1001 |
R_012 | C_008 | Business switch 8_ is increased newly | 0 | 0102 | User02 | 1001 |
Its script sentence is as follows:
INSERT INTO SYS_L_BIZ_SWITCH(RECORD_ID,SWITCH_ID,SWITCH_NAME,SWITCH_
VALUE, MODULE_ID, USER_ID, VERSION_NO) VALUES (' R_009', ' C_007', ' business switch 7_ newly-increased ',
1,'0103','User01','1001')
…
7.4 create【Local service switch list】Pressure more new script, according to flow need to update it is following several record
User's switch number | Switch number | Close title | Switch value | Module is numbered | Customs Assigned Number | Record version number |
R_004 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User01 | 1001 |
R_006 | C_005 | Business switch 5_ changes by force | 1 | 0102 | User02 | 1001 |
R_007 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User02 | 1001 |
R_008 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User03 | 1001 |
Its script sentence is as follows:
UPDATE SYS_L_BIZ_SWITCH SET SWITCH_ID=' C_006 ', SWITCH_NAME=' business are switched
6_ changes by force ', SWITCH_VALUE=' 0 ', MODULE_ID=' 0103 ', USER_ID=' User01 ', VERSION_NO=
' 1001 ' WHERE RECORD_ID=' R_004 '
…
7.5 create【Local service switch list】Single more new script
User's switch number | Switch number | Switch names | Switch value | Module is numbered | Customs Assigned Number | Record version number |
R_002 | C_002 | Business switch 2 | 1 | 0101 | User01 | 1001 |
R_009 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User01 | 1001 |
R_010 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User02 | 1001 |
R_011 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User03 | 1001 |
R_012 | C_008 | Business switch 8_ is increased newly | 0 | 0102 | User02 | 1001 |
Its script sentence is as follows:
UPDATE SYS_L_BIZ_SWITCH SET SWITCH_ID=' C_002 ', SWITCH_NAME=' business are switched
2 ', SWITCH_VALUE=' 1 ', MODULE_ID=' 0101 ', USER_ID=' User01 ', VERSION_NO=' 1001 '
WHERE RECORD_ID=' R_002 ' AND VERSION_NO<>‘1001’
…
8th step:
Assemble the more new script after all establishments and form total script set.
9th step:
Batch performs all more new scripts, after renewal【Local user traffic switch list】Record is as follows:
User's switch number | Switch number | Switch names | Switch value | Module is numbered | Customs Assigned Number | Record version number |
R_001 | C_001 | Business switch 1 | 1 | 0101 | User01 | 1000 |
R_002 | C_002 | Business switch 2 | 1 | 0101 | User01 | 1001 |
R_003 | C_003 | Business switch 3 | 0 | 0101 | User01 | 1000 |
R_004 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User01 | 1001 |
R_005 | C_004 | Business switch 4 | 0 | 0102 | User02 | 1000 |
R_006 | C_005 | Business switch 5_ changes by force | 1 | 0102 | User02 | 1001 |
R_007 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User02 | 1001 |
R_008 | C_006 | Business switch 6_ changes by force | 0 | 0103 | User03 | 1001 |
R_009 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User01 | 1001 |
R_010 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User02 | 1001 |
R_011 | C_007 | Business switch 7_ is increased newly | 1 | 0103 | User03 | 1001 |
R_012 | C_008 | Business switch 8_ is increased newly | 0 | 0102 | User02 | 1001 |
Table 2 is referred to, is this earth's surface data update apparatus module map described in the specific embodiment of the invention, described device
Including input module 21, searching modul 22, formatting module 23, script creation module 24, performing module 25;
The input module 21 is used for the data to be updated for receiving user's input;
The searching modul 22 is used to update configuration object according to the mapping for updating dictionary lookup data to be updated is corresponding;
The formatting module 23 is used to, according to configuration Format Objectization data to be updated are updated, form data to be updated
Table;
The script creation module 24 is used for basis and treats that new data table creates the more new script of this earth's surface, the more new script
Including newly-increased script, force script or single script;
The performing module 25 is used to perform more new script, updates this surface data.
Wherein, this earth's surface can be the configured list of software program, in conventional architectures, can be peeled off from standard scale,
Configuration that can be personalized by changing the configuration information presentation user in this earth's surface;Just include needing to update in data to be updated
Configuration categories and update the data, it is described update dictionary at least include aforementioned arrangements classification with configuration object corresponding informance, lead to
Cross and data format to be updated is turned into tables of data to be updated, preferably can extract useful data from form is formatted, improve
The efficiency of script is created, at some other aspect, more new script is created according to tables of data to be updated, on the local computer
Perform, improve the operation efficiency of application program, more quickly complete the data configuration work of this earth's surface.
Further, in addition to update dictionary module 26, it is described renewal dictionary module be used for according to update repository generation
Update dictionary.The renewal configuration object set for updating dictionary for tables of data, the convenient quick lookup for carrying out specifying object and
Positioning.Each object one normal data table of correspondence gather simultaneously in, the correlation required when updating of the table defined in object
Attribute and renewal Row control parameter etc..
Further, the tables of data to be updated includes Major key, updates recording status, more new version number, forces to update
Symbol.
It should be noted that herein, such as first and second or the like relational terms are used merely to a reality
Body or operation make a distinction with another entity or operation, and not necessarily require or imply these entities or deposited between operating
In any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Nonexcludability is included, so that process, method, article or terminal device including a series of key elements not only include those
Key element, but also other key elements including being not expressly set out, or also include being this process, method, article or end
The intrinsic key element of end equipment.In the absence of more restrictions, limited by sentence " including ... " or " including ... "
Key element, it is not excluded that also there is other key element in the process including the key element, method, article or terminal device.This
Outside, herein, " being more than ", " being less than ", " exceeding " etc. are interpreted as not including this number;" more than ", " following ", " within " etc. understand
It is to include this number.
It should be understood by those skilled in the art that, the various embodiments described above can be provided as method, device or computer program production
Product.These embodiments can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Form.All or part of step in the method that the various embodiments described above are related to can be instructed by program correlation hardware come
Complete, described program can be stored in the storage medium that computer equipment can be read, for performing the various embodiments described above side
All or part of step described in method.The computer equipment, includes but is not limited to:Personal computer, server, general-purpose computations
Machine, special-purpose computer, the network equipment, embedded device, programmable device, intelligent mobile terminal, intelligent home device, Wearable
Smart machine, vehicle intelligent equipment etc.;Described storage medium, includes but is not limited to:RAM, ROM, magnetic disc, tape, CD, sudden strain of a muscle
Deposit, USB flash disk, mobile hard disk, storage card, memory stick, webserver storage, network cloud storage etc..
The various embodiments described above are with reference to method, equipment (system) and the computer program product according to embodiment
Flow chart and/or block diagram are described.It should be understood that can be by every in computer program instructions implementation process figure and/or block diagram
One flow and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computers can be provided
Programmed instruction is to the processor of computer equipment to produce a machine so that pass through the finger of the computing device of computer equipment
Order, which is produced, to be used to realize what is specified in one flow of flow chart or multiple flows and/or one square frame of block diagram or multiple square frames
The device of function.
These computer program instructions may be alternatively stored in the computer that computer equipment can be guided to work in a specific way and set
In standby readable memory so that the instruction being stored in the computer equipment readable memory, which is produced, includes the manufacture of command device
Product, the command device is realized to be referred in one flow of flow chart or multiple flows and/or one square frame of block diagram or multiple square frames
Fixed function.
These computer program instructions can be also loaded into computer equipment so that performed on a computing device a series of
Operating procedure is to produce computer implemented processing, so that the instruction performed on a computing device is provided for realizing in flow
The step of function of being specified in one flow of figure or multiple flows and/or one square frame of block diagram or multiple square frames.
Although the various embodiments described above are described, those skilled in the art once know basic wound
The property made concept, then can make other change and modification to these embodiments, so embodiments of the invention are the foregoing is only,
Not thereby the scope of patent protection of the present invention, the equivalent structure that every utilization description of the invention and accompanying drawing content are made are limited
Or equivalent flow conversion, or other related technical fields are directly or indirectly used in, similarly it is included in the patent of the present invention
Within protection domain.
Claims (6)
1. a kind of this earth's surface data-updating method, it is characterised in that comprise the following steps, receives the number to be updated of user's input
According to according to the corresponding renewal configuration object of the mapping for updating dictionary lookup data to be updated, according to renewal configuration Format Object
Data to be updated, form tables of data to be updated, according to treating that new data table creates the more new script of this earth's surface, the more new script bag
Include newly-increased script, force script or single script, perform more new script, update this surface data.
2. underlying table data-updating method according to claim 1, it is characterised in that also including step, matched somebody with somebody according to renewal
Put storehouse generation and update dictionary.
3. underlying table data-updating method according to claim 1, it is characterised in that the tables of data to be updated includes master
Key assignments, renewal recording status, more new version number, pressure update symbol.
4. a kind of this earth's surface data update apparatus, it is characterised in that including input module, searching modul, formatting module, script
Creation module, performing module;
The input module is used for the data to be updated for receiving user's input;
The searching modul is used to update configuration object according to the mapping for updating dictionary lookup data to be updated is corresponding;
The formatting module is used to, according to configuration Format Objectization data to be updated are updated, form tables of data to be updated;
The script creation module is used for basis and treats that new data table creates the more new script of this earth's surface, and the more new script includes new
Increase script, force script or single script;
The performing module is used to perform more new script, updates this surface data.
5. underlying table data update apparatus according to claim 4, it is characterised in that also including updating dictionary module, institute
Stating renewal dictionary module is used to update dictionary according to renewal repository generation.
6. underlying table data update apparatus according to claim 4, it is characterised in that the tables of data to be updated includes master
Key assignments, renewal recording status, more new version number, pressure update symbol.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710173048.6A CN107103035B (en) | 2017-03-22 | 2017-03-22 | Local table data updating method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710173048.6A CN107103035B (en) | 2017-03-22 | 2017-03-22 | Local table data updating method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107103035A true CN107103035A (en) | 2017-08-29 |
CN107103035B CN107103035B (en) | 2020-04-10 |
Family
ID=59675600
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710173048.6A Active CN107103035B (en) | 2017-03-22 | 2017-03-22 | Local table data updating method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107103035B (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108566425A (en) * | 2018-04-12 | 2018-09-21 | 苏州工业园区服务外包职业学院 | Block chain node business configuration system and method |
CN109582666A (en) * | 2018-09-29 | 2019-04-05 | 阿里巴巴集团控股有限公司 | Data major key generation method, device, electronic equipment and storage medium |
CN111708759A (en) * | 2020-06-12 | 2020-09-25 | 北京思特奇信息技术股份有限公司 | Optimization method and system for big table data migration |
CN113360213A (en) * | 2021-06-30 | 2021-09-07 | 中国农业银行股份有限公司 | Application program version switching method, device, equipment and system |
CN113704257A (en) * | 2021-08-06 | 2021-11-26 | 网易(杭州)网络有限公司 | Data table updating method and device |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070294307A1 (en) * | 2006-06-07 | 2007-12-20 | Jinfang Chen | Extending configuration management databases using generic datatypes |
US20080183766A1 (en) * | 2007-01-31 | 2008-07-31 | Weston David W | Methods and systems for inductive data transformation |
CN103019795A (en) * | 2012-12-27 | 2013-04-03 | 福建榕基软件股份有限公司 | Method and system for upgrading software basic data |
CN103544323A (en) * | 2013-11-08 | 2014-01-29 | 中国农业银行股份有限公司 | Data updating method and device |
-
2017
- 2017-03-22 CN CN201710173048.6A patent/CN107103035B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070294307A1 (en) * | 2006-06-07 | 2007-12-20 | Jinfang Chen | Extending configuration management databases using generic datatypes |
US20080183766A1 (en) * | 2007-01-31 | 2008-07-31 | Weston David W | Methods and systems for inductive data transformation |
CN103019795A (en) * | 2012-12-27 | 2013-04-03 | 福建榕基软件股份有限公司 | Method and system for upgrading software basic data |
CN103544323A (en) * | 2013-11-08 | 2014-01-29 | 中国农业银行股份有限公司 | Data updating method and device |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108566425A (en) * | 2018-04-12 | 2018-09-21 | 苏州工业园区服务外包职业学院 | Block chain node business configuration system and method |
CN109582666A (en) * | 2018-09-29 | 2019-04-05 | 阿里巴巴集团控股有限公司 | Data major key generation method, device, electronic equipment and storage medium |
CN111708759A (en) * | 2020-06-12 | 2020-09-25 | 北京思特奇信息技术股份有限公司 | Optimization method and system for big table data migration |
CN111708759B (en) * | 2020-06-12 | 2023-07-07 | 北京思特奇信息技术股份有限公司 | Optimization method and system for large-table data migration |
CN113360213A (en) * | 2021-06-30 | 2021-09-07 | 中国农业银行股份有限公司 | Application program version switching method, device, equipment and system |
CN113704257A (en) * | 2021-08-06 | 2021-11-26 | 网易(杭州)网络有限公司 | Data table updating method and device |
CN113704257B (en) * | 2021-08-06 | 2023-09-26 | 网易(杭州)网络有限公司 | Data table updating method and device |
Also Published As
Publication number | Publication date |
---|---|
CN107103035B (en) | 2020-04-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107103035A (en) | This earth's surface data-updating method and device | |
CN105094707B (en) | A kind of data storage, read method and device | |
CN107918666B (en) | Data synchronization method and system on block chain | |
US8935575B2 (en) | Test data generation | |
JP5298117B2 (en) | Data merging in distributed computing | |
CN101504672B (en) | Method and system for dynamically configuring physical data table | |
CN103678339B (en) | Data backflow method and system and data access method and system in relational database | |
CN107958016A (en) | Function pages method for customizing and application server | |
CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
CN102722372A (en) | Method and system for automatically generating codes through classification and configuration | |
CN102103605A (en) | Method and system for intelligently extracting document structure | |
CN107368346A (en) | A kind of code generating method and device based on metadata and script engine | |
CN106557307B (en) | Service data processing method and system | |
CN108280056A (en) | A kind of Excel file analytic method | |
CN103020117A (en) | Service contrast method and service contrast system | |
CN105095436A (en) | Automatic modeling method for data of data sources | |
CN110069248A (en) | Call method, device, equipment and the computer readable storage medium of interface data | |
CN110263021B (en) | Theme library generation method based on personalized label system | |
CN107729330B (en) | Method and apparatus for acquiring data set | |
CN107766519B (en) | Method for visually configuring data structure | |
CN107832374A (en) | Construction method, electronic installation and the storage medium in standard knowledge storehouse | |
CN108647337B (en) | Format processing method and device for simulation analysis data | |
CN113988003A (en) | Method for custom directional analysis of multiple sheet contents of Excel file according to specified configuration | |
CN114565316A (en) | Task issuing method based on micro-service architecture and related equipment | |
CN107943988B (en) | Data splicing 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 | ||
GR01 | Patent grant | ||
GR01 | Patent grant |