CN107103035A - This earth's surface data-updating method and device - Google Patents

This earth's surface data-updating method and device Download PDF

Info

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
Application number
CN201710173048.6A
Other languages
Chinese (zh)
Other versions
CN107103035B (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.)
FUJIAN RONGJI SOFTWARE Co Ltd
Original Assignee
FUJIAN RONGJI SOFTWARE 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 FUJIAN RONGJI SOFTWARE Co Ltd filed Critical FUJIAN RONGJI SOFTWARE Co Ltd
Priority to CN201710173048.6A priority Critical patent/CN107103035B/en
Publication of CN107103035A publication Critical patent/CN107103035A/en
Application granted granted Critical
Publication of CN107103035B publication Critical patent/CN107103035B/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/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • G06F16/24534Query rewriting; Transformation
    • G06F16/24549Run-time optimisation
    • 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
    • G06F16/2358Change 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

This earth's surface data-updating method and device
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.
CN201710173048.6A 2017-03-22 2017-03-22 Local table data updating method and device Active CN107103035B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (4)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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&#39;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