CN103793400B - The batch regulation method and device of tables of data - Google Patents
The batch regulation method and device of tables of data Download PDFInfo
- Publication number
- CN103793400B CN103793400B CN201210424235.4A CN201210424235A CN103793400B CN 103793400 B CN103793400 B CN 103793400B CN 201210424235 A CN201210424235 A CN 201210424235A CN 103793400 B CN103793400 B CN 103793400B
- Authority
- CN
- China
- Prior art keywords
- data
- adjustment
- tables
- field
- adjusted
- 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.)
- Active
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses the batch regulation method and device of a kind of tables of data, including：According to data source mirror image, data to be adjusted in tables of data are filtered, obtains recording the data field of different extent block data, and generates corresponding section critical field；Select the data field that need to be adjusted and the corresponding adjustment form of data field；According to data field and adjustment form, section critical field is matched with the storage critical field in adjustment result table, according to matching result, adjustment in batches adjustment result table；Meanwhile manual setting data input by user are preserved to adjustment result table；According to user to the operation that comes into force after adjustment result table examination ＆ verification, by the method for the corresponding extent block data of section critical field and manual setting data update to tables of data, with using a variety of adjustment modes, the advantageous effect by the disposable adjustment in batches tables of data of carrier, avoid operating process cumbersome when tables of data is more and data point reuse amount is big, system performance is improved, improves user experience.
Description
Technical field
The present invention relates to the batch regulation methods and device of technical field of data processing more particularly to a kind of tables of data.
Background technology
Traditional ERP（Enterprise Resource Planning, Enterprise Resources Plan）Product or EXCEL（Microsoft
Corporate office software）Form is typically adjustment of directly modifying in original tables of data, and user selects to need to be adjusted
Multiple record rows after, pass through default or establishment formula carry out adjustment in batches manually.Partial ERP products are by using other tables
Nonoculture is carrier, and former tables of data is adjusted.When carrying out adjustment in batches to tables of data using the prior art, it can only carry out by several times
It adjusts and adjustment mode is unique every time；Because during adjustment in batches, the adjustment result for the multiple record rows chosen is same value.
The content of the invention
The main object of the present invention is to provide the batch regulation method and device of a kind of tables of data, it is intended to can be by a variety of
Adjustment mode, disposable adjustment in batches tables of data.
The invention discloses a kind of batch regulation methods of tables of data, comprise the following steps：
According to data source mirror image, data to be adjusted in tables of data are filtered, obtain recording the data of different extent block data
Field, and generate corresponding section critical field；Select the data field that need to be adjusted and the corresponding tune of the data field
Shaping type；
It is according to the data field and adjustment form, the section critical field and the storage in adjustment result table is crucial
Field is matched, and result table is adjusted described in adjustment in batches；Meanwhile manual setting data input by user are preserved to the tune
Whole result table；
According to user to the operation that comes into force after the adjustment result table examination ＆ verification, by the corresponding section of the section critical field
Block number according to and the manual setting data update to the tables of data.
Preferably, it is described by the corresponding extent block data of the section critical field and the manual setting data update extremely
The tables of data specifically includes：
According to the adjustment form, the corresponding extent block batch data of the section critical field is updated to the data
Table；
Meanwhile to the newly-increased data row of tables of data insertion, by the manual setting data update to described newly-increased
Data row.
Preferably, the data row newly-increased to tables of data insertion includes：
Using the last item record of the tables of data as benchmark, a newly-increased data row is inserted into the tables of data.
Preferably, the adjustment form can be one or more；And each described adjustment form includes adjustment type
And adjustment mode；
The adjustment type includes may specify some specific data adjusted in the tables of data；
The adjustment mode includes formula that can be built-in.
Preferably, data to be adjusted in the tables of data are a plurality of continuous or discrete data interval.
Invention additionally discloses a kind of adjustment in batches device of tables of data, including：
Setup module is adjusted, for according to data source mirror image, filtering data to be adjusted in tables of data, it is different obtaining record
The data field of extent block data, and generate corresponding section critical field；Select the data field that need to adjust and described
The corresponding adjustment form of data field；
Adjust result previewing module, for according to the data field and adjustment form, by the section critical field with
Storage critical field in adjustment result table is matched, and result table is adjusted described in adjustment in batches；Meanwhile by hand input by user
Work adjustment data are preserved to the adjustment result table；
Data point reuse module, for adjusting the operation that comes into force after result table is audited to described according to user, by the section
The corresponding extent block data of critical field and the manual setting data update are to the tables of data.
Preferably, the data point reuse module is specifically used for：
According to the adjustment form, the corresponding extent block batch data of the section critical field is updated to the data
Table；
Meanwhile to the newly-increased data row of tables of data insertion, by the manual setting data update to described newly-increased
Data row.
Preferably, the data point reuse module includes to the newly-increased data row of tables of data insertion：
Using the last item record of the tables of data as benchmark, a newly-increased data row is inserted into the tables of data.
Preferably, the adjustment form that the adjustment setup module selects can be one or more；And each described adjustment
Form includes adjustment type and adjustment mode；
The adjustment type includes may specify some specific data adjusted in the tables of data；
The adjustment mode includes formula that can be built-in.
Preferably, entire data to be adjusted in the tables of data is a plurality of continuous or discrete data interval.
The present invention obtains recording different section block numbers by filtering data to be adjusted in tables of data according to data source mirror image
According to data field, and generate corresponding section critical field；Select the data field that need to be adjusted and corresponding adjustment form；Root
According to data field and adjustment form, section critical field is matched with the storage critical field in adjustment result table, according to
Matching result, adjustment in batches adjustment result table；Meanwhile manual setting data input by user are preserved to adjustment result table；Root
According to user to the operation that comes into force after adjustment result table examination ＆ verification, by the corresponding extent block data of section critical field and manual setting number
According to the method for being updated to tables of data, have using a variety of adjustment modes, pass through the beneficial of the disposable adjustment in batches tables of data of carrier
Effect and data point reuse are not allowed error-prone, avoid operating process cumbersome when tables of data is more and data point reuse amount is big, improve
System performance reduces error rate during data point reuse, improves user experience.
Description of the drawings
Fig. 1 is the one embodiment flow diagram of batch regulation method of tables of data of the present invention；
Fig. 2 be tables of data of the present invention batch regulation method in tables of data regulating object interaction sequence diagram；
Fig. 3 is the batch regulation method specific embodiment flow diagram of tables of data of the present invention；
Fig. 4 is one example structure schematic diagram of adjustment in batches device of tables of data of the present invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
The technical solution further illustrated the present invention below in conjunction with Figure of description and specific embodiment.It should be appreciated that this
Locate described specific embodiment to be only used to explain the present invention, be not intended to limit the present invention.
In the batch regulation method and device of tables of data of the present invention, the adjustment result table carries out data batch for source data table
Measure the process table of adjustment；The adjustment result table saves the adjustment time of the tables of data, authorizes adjustment user, specific tune
The relevant informations such as entire data；The relevant information of the adjustment result table is the complete of the related adjustment information of the corresponding tables of data
Portion records.
With reference to Fig. 1, Fig. 1 is the one embodiment flow diagram of batch regulation method of tables of data of the present invention；As shown in Figure 1,
The batch regulation method of tables of data of the present invention specifically includes following steps：
Step S01, according to data source mirror image, data to be adjusted in tables of data is filtered, obtain recording different section block numbers
According to data field, and generate corresponding section critical field；Select the data field that need to be adjusted and the data field
Corresponding adjustment form；
After the Mirror Coding of client input data source, specify which specific data source is data to be adjusted specifically come from.
System batch selects data to be adjusted, and data to be adjusted in tables of data are filtered according to the data source mirror image, and return is each not
With the batch data row in section, obtain recording the data field of different extent block data, and it is crucial to automatically generate corresponding section
Field；The section critical field, data interval and data row form are recorded in simultaneously in adjustment result table.Specifically, institute
It can be the arbitrary a plurality of continuous or discrete data interval of selection to state data to be adjusted；And the data in different sections are by difference
Critical field recorded, critical field is generated by program automatic dynamic；The section that can be returned is 1 ~ extent block of extent block
N, N are the positive integer more than 1.
Data source mirror image, that is, the data source identification, storage is data source code rather than specific data table data；
It is filtered when adjusting setting by the data source mirror image, different interval censored datas can be selected, subsequently tables of data is being adjusted
It is whole when coming into force, the specific tables of data that the data source mirror image corresponds to storage can be found by the data source mirror image, and then is carried out
Update the operation of corresponding data table.
Determine to need the data field of adjustment in batches, which can be in source data table in 1 ~ field of field n
Either field or multiple fields.According to the data field that need to be adjusted, corresponding adjustment form is selected and determined.Adjustment form
Including adjustment type and adjustment mode；Generally, determine adjustment form i.e., determine to need the batch data in each section adjusted
Row is adjusted by what adjustment mode.Adjustment type can be assigned to some specific data of the data row of extent block, you can
To carry out adjustment in batches to multiple specific datas of data row；Adjustment mode is formula that can be built-in, can be adjustment in batches
10% or batch adjust and reduce the modes such as certain numerical value.When being adjusted to tables of data, adjustment form can be adjustment form 1 ~ adjustment
One or more in form n.
Step S02, according to the data field and adjustment form, by the section critical field with adjusting in result table
Storage critical field is matched, and result table is adjusted described in adjustment in batches；Meanwhile manual setting data input by user are preserved
To the adjustment result table；
When carrying out adjustment in batches to tables of data, by the section critical field automatically generated in step S01 and adjustment result table
In storage critical field carry out Auto-matching；If the section critical field matches correctly with storage critical field, basis
The adjustment form, the corresponding extent block data of section critical field described in adjustment in batches, the i.e. section in result table is adjusted
Data row perform this section adjustment form carry out adjustment in batches；At this point, user can also open up according in the adjustment result table
The data shown carry out the adjustment of tables of data by manually entering data, i.e., are interacted with the adjustment result table.If user needs
Manually input data adjusts tables of data, then the adjustment data that user manually enters are stored in the adjustment result table by system
In, for user's preview and license confirmation.
Step S03, according to user to the operation that comes into force after the adjustment result table examination ＆ verification, by the section critical field pair
The extent block data and the manual setting data update answered are to the tables of data.
After user confirms that data shown in the adjustment result table are accurate, the behaviour of coming into force of tables of data adjustment is performed
Make, the disposable batch updating of all data in result table will be adjusted to tables of data.Specifically, by section in adjustment result table
The corresponding disposable batch updating of extent block data of critical field is to the tables of data；For user manually enter data, by
Then the manual operation of user, therefore, the partial data will be without corresponding critical fielies；At this point, system is defeated by hand by user
The adjustment data entered are by way of being inserted into newly-increased data row into the tables of data, adjustment number that the user is manually entered
According to being updated in the newly-increased data row.
While aforesaid operations enable the batch regulation method of tables of data of the present invention to be updated automatically, it has been compatible with manually
The adjustment data of input.
With reference to Fig. 2, Fig. 2 be tables of data of the present invention batch regulation method in tables of data regulating object interaction sequence diagram；Fig. 2
When shown sequence diagram shows that tables of data is adjusted, the interaction between each object；These objects shown in Fig. 2 are according to number
What time sequencing when being adjusted according to table was arranged, it is shown that participating in the suitable of interacting message between interactive object and each object
Sequence.The batch regulation method of tables of data of the present invention carries out adjustment in batches, the carrier bag by carrier to the data of source data table
It is set containing adjustment, adjustment result part, the carrier can be list.Under conditions of explicit data table source data, system exists
Adjustment selects the data of batch and returns to the batch data row of corresponding data interval in setting；System records batch data automatically
Section, and according to setting of the user to each section, select different adjustment forms.When carrying out adjustment in batches to tables of data, no
Data with extent block perform the adjustment of respective section difference adjustment form, allow data interaction in adjustment result.And in number
The operation part that comes into force after being adjusted according to table disposably updates source data table.By aforesaid operations, reach to different section lot numbers
According to the effect for the disposable adjustment in batches for carrying out polymorphic type, more adjustment forms.
The batch regulation method specific implementation process of tables of data of the present invention is described in detail with specific example below.
With reference to Fig. 3, Fig. 3 is the batch regulation method specific embodiment flow diagram of tables of data of the present invention；Such as Fig. 3 institutes
Show, it is assumed that batch regulation method is percentage, and the extent block that amplitude modulation is 10% is QJK001；Batch regulation method is number, amplitude modulation
50 extent block is QJK002；The extent block that new price is inserted into order is QJK003；The material of extent block QJK001 adjustment in batches is
A, B, C, H, the material of extent block QJK002 adjustment in batches is that E, G, K, N extent block QJK003 are then record Z, the Z valencys being newly inserted into
Lattice are 80 yuan；Critical field is generated by program automatic dynamic, and the critical field of the extent block QJK001 of Program Generating is
The critical field of TJFN001, extent block QJK002 are TJFN002；It, will not since extent block QJK003 is new insertion record
Automatically generate critical field.
According to user setting, the adjustment in batches form of tables of data is selected, more new demand servicing and batch is called to carry out critical field
Matching, the interaction of corresponding object in sequence diagram as shown in Figure 2.Critical field TJFN001 in extent block QJK001
With correct, therefore material A, B, C, H batch updating price in entire extent block QJK001, method of adjustment is percentage, and amplitude modulation is
10%；Critical field TJFN002 matchings are also correct in extent block QJK002, therefore material E, G, K, N in entire extent block QJK002
Batch updating price, method of adjustment are number, amplitude modulation 50；Since extent block QJK003 is the adjustment that user manually manually enters
Data, therefore the corresponding critical fielies of extent block QJK003 are sky；Execution come into force operation batch updating tables of data when, it is necessary to
Newly-increased record row, specially：Using the last item record in source data table as benchmark, it is inserted into one to source data table and increases newly
Data row Z, Z price be 80 yuan.
The present embodiment obtains recording different extent blocks by filtering data to be adjusted in tables of data according to data source mirror image
The data field of data, and generate corresponding section critical field；Select the data field that need to be adjusted and corresponding adjustment form；
According to data field and adjustment form, section critical field is matched with the storage critical field in adjustment result table, root
According to matching result, adjustment in batches adjustment result table；Meanwhile manual setting data input by user are preserved to adjustment result table；
According to user to the operation that comes into force after adjustment result table examination ＆ verification, by the corresponding extent block data of section critical field and manual setting
Data update has to the method for tables of data using a variety of adjustment modes, having by the disposable adjustment in batches tables of data of carrier
Beneficial effect and data point reuse are not allowed error-prone, avoid operating process cumbersome when tables of data is more and data point reuse amount is big, improve
System performance, reduces error rate during data point reuse, improves user experience.
With reference to Fig. 4, Fig. 4 is one example structure schematic diagram of adjustment in batches device of tables of data of the present invention.As shown in figure 4,
The adjustment in batches device of tables of data of the present invention specifically includes：Adjust setup module 01, adjustment result previewing module 02 and data tune
Mould preparation block 03.
Setup module 01 is adjusted, for according to data source mirror image, filtering data to be adjusted in tables of data, obtaining recording not
With the data field of section block number evidence, and generate corresponding section critical field；Select the data field that need to be adjusted and institute
State the corresponding adjustment form of data field；
After the Mirror Coding of client input data source, which the adjustment data clearly to be adjusted of setup module 01 specifically come from
A specific data source.Adjustment setup module 01 selects data to be adjusted in batches, is filtered according to the data source mirror image in tables of data
Data to be adjusted return to the batch data row in each different sections, obtain recording the data field of different extent block data, and
Automatically generate corresponding section critical field；Meanwhile setup module 01 is adjusted by section critical field, data interval and the number
It is recorded in simultaneously according to row form in adjustment result table.Specifically, the data to be adjusted can be that arbitrary selection is a plurality of continuous
Or discontinuous data interval；And the data in different sections are recorded by different critical fielies, critical field by program from
Dynamic dynamic generation；The section that can be returned is 1 ~ extent block of extent block N, and N is the positive integer more than 1.
Data source mirror image, that is, the data source identification, storage is data source code rather than specific data table data；
It adjusts setup module 01 to filter by the data source mirror image when adjusting setting, different interval censored datas can be selected, follow-up
Tables of data is adjusted when coming into force, the specific number that the data source mirror image corresponds to storage can be found by the data source mirror image
According to table, and then it is updated the operation of corresponding data table.Adjustment setup module 01 is determined to need the data field of adjustment in batches, is somebody's turn to do
Data field can be either field or the multiple fields in source data table in 1 ~ field of field n.According to the number that need to be adjusted
According to field, adjustment setup module 01 selects and determines corresponding adjustment form.Adjustment form includes adjustment type and adjustment mode；
Generally, adjustment setup module 01 determines adjustment form i.e., and the batch data row for determining to need each section adjusted is by what
Adjustment mode is adjusted.Adjustment type can be assigned to some specific data of the data row of extent block, i.e. adjustment sets mould
Block 01 can carry out adjustment in batches to multiple specific datas of data row；Adjustment mode is formula that can be built-in, can be batch
Adjust certain 10% or batch adjust and reduce the modes such as certain numerical value.When adjustment setup module 01 is adjusted tables of data, form is adjusted
Can be the one or more in adjustment form 1 ~ adjustment form n.
Result previewing module 02 is adjusted, for according to the data field and adjustment form, by the section critical field
It is matched with the storage critical field in adjustment result table, result table is adjusted described in adjustment in batches；It meanwhile will be input by user
Manual setting data are preserved to the adjustment result table；
When adjusting result previewing module 02 to tables of data progress adjustment in batches, it will adjust what is automatically generated in setup module 01
Section critical field carries out Auto-matching with the storage critical field in adjustment result table；If the section critical field and storage
Critical field matching is correct, and adjustment result previewing module 02 is according to the adjustment form, the adjustment in batches institute in result table is adjusted
The corresponding extent block data of section critical field are stated, i.e. the data row in the section performs the adjustment form progress batch tune in this section
It is whole；At this point, user can also according to shown in the adjustment result table data, by manually enter data carry out tables of data tune
It is whole, i.e., it is interacted with the adjustment result table.If user needs manually input data adjustment tables of data, it is pre- to adjust result
The adjustment data that user manually enters are stored in the adjustment result table by module 02 of looking at, for user's preview and license confirmation.
Data point reuse module 03, for adjusting the operation that comes into force after result table is audited to described according to user, by the area
Between the corresponding extent block data of critical field and the manual setting data update to the tables of data.
After user confirms that data shown in the adjustment result table are accurate, data point reuse module 03 performs tables of data
The operation that comes into force of adjustment will adjust the disposable batch updating of all data in result table to tables of data.Specifically, data tune
Mould preparation block 03 will adjust in result table the corresponding disposable batch updating of extent block data of section critical field to the tables of data；
For the data that user manually enters, due to being the manual operation of user, which will be without corresponding keyword
Section；At this point, the adjustment data that data point reuse module 03 manually enters user are by being inserted into newly-increased data into the tables of data
Capable mode, by the adjustment data update that the user manually enters into the newly-increased data row.Aforesaid operations make the present invention
While the batch regulation method of tables of data can be updated automatically, the adjustment data being manually entered have been compatible with.
When the adjustment in batches device of tables of data of the present invention carries out adjustment in batches to tables of data, when tables of data regulating object interacts
The specific descriptions of sequence refer to the specific descriptions of embodiment described in Fig. 2, and details are not described herein.
The description of the specific embodiment of adjustment in batches is carried out to tables of data to the adjustment in batches device of tables of data of the present invention,
The specific descriptions of embodiment described in Fig. 3 are refer to, details are not described herein.
The present embodiment obtains recording different extent blocks by filtering data to be adjusted in tables of data according to data source mirror image
The data field of data, and generate corresponding section critical field；Select the data field that need to be adjusted and corresponding adjustment form；
According to data field and adjustment form, section critical field is matched with the storage critical field in adjustment result table, root
According to matching result, adjustment in batches adjustment result table；Meanwhile manual setting data input by user are preserved to adjustment result table；
According to user to the operation that comes into force after adjustment result table examination ＆ verification, by the corresponding extent block data of section critical field and manual setting
Data update has to tables of data using a variety of adjustment modes, the advantageous effect by the disposable adjustment in batches tables of data of carrier
And data point reuse is not allowed error-prone, avoids operating process cumbersome when tables of data is more and data point reuse amount is big, improves system
Performance reduces error rate during data point reuse, improves user experience.
The foregoing is merely the preferred embodiment of the present invention, not thereby limit its scope of the claims, every to utilize the present invention
The equivalent structure or equivalent flow shift that specification and accompanying drawing content are made directly or indirectly is used in other relevant technology necks
Domain is included within the scope of the present invention.
Claims (10)
1. a kind of batch regulation method of tables of data, which is characterized in that comprise the following steps：
According to data source mirror image, data to be adjusted in tables of data are filtered, obtain recording the data field of different extent block data,
And corresponding section critical field is generated, the data in different sections are recorded by different critical fielies, and the keyword
Section is generated by program automatic dynamic；Select the data field that need to be adjusted and the corresponding adjustment form of the data field, institute
State data source mirrored storage is data source code；
According to the data field and adjustment form, by the section critical field and the storage critical field in adjustment result table
It is matched, result table is adjusted described in adjustment in batches；Meanwhile manual setting data input by user are preserved to the adjustment and are tied
Fruit table, the data manually entered for user do not have corresponding critical field；
According to user to the operation that comes into force after the adjustment result table examination ＆ verification, by the corresponding section block number of the section critical field
According to and the manual setting data update to the tables of data.
2. batch regulation method as described in claim 1, which is characterized in that described by the corresponding area of the section critical field
Between block number according to and the manual setting data update to the tables of data specifically include：
According to the adjustment form, the corresponding extent block batch data of the section critical field is updated to the tables of data；
Meanwhile to the newly-increased data row of tables of data insertion, by the manual setting data update to the newly-increased data
Row.
3. batch regulation method as claimed in claim 2, which is characterized in that the data newly-increased to tables of data insertion
Row includes：
Using the last item record of the tables of data as benchmark, a newly-increased data row is inserted into the tables of data.
4. batch regulation method as claimed in claim 1 or 2, which is characterized in that the adjustment form can be a kind of or more
Kind；And each described adjustment form includes adjustment type and adjustment mode；
The adjustment type includes may specify some specific data adjusted in the tables of data；
The adjustment mode includes formula that can be built-in.
5. batch regulation method as described in claim 1, which is characterized in that data to be adjusted are a plurality of in the tables of data
Continuous or discrete data interval.
6. a kind of adjustment in batches device of tables of data, which is characterized in that including：
Setup module is adjusted, for according to data source mirror image, filtering data to be adjusted in tables of data, obtaining recording different sections
The data field of block number evidence, and corresponding section critical field is generated, the data in different sections are carried out by different critical fielies
Record, and the critical field is generated by program automatic dynamic；Select the data field that need to be adjusted and the data field
Corresponding adjustment form, the data source mirrored storage is data source code；
Result previewing module is adjusted, for according to the data field and adjustment form, by the section critical field and adjusting
As a result the storage critical field in table is matched, and result table is adjusted described in adjustment in batches；Meanwhile it is adjusted input by user by hand
Entire data is preserved to the adjustment result table, and the data manually entered for user do not have corresponding critical field；
Data point reuse module, for adjusting the operation that comes into force after result table is audited to described according to user, by section key
The corresponding extent block data of field and the manual setting data update are to the tables of data.
7. adjustment in batches device as claimed in claim 6, which is characterized in that the data point reuse module is specifically used for：
According to the adjustment form, the corresponding extent block batch data of the section critical field is updated to the tables of data；
Meanwhile to the newly-increased data row of tables of data insertion, by the manual setting data update to the newly-increased data
Row.
8. adjustment in batches device as claimed in claim 7, which is characterized in that the data point reuse module is inserted to the tables of data
Entering newly-increased data row includes：
Using the last item record of the tables of data as benchmark, a newly-increased data row is inserted into the tables of data.
9. adjustment in batches device as claimed in claims 6 or 7, which is characterized in that the adjustment of the adjustment setup module selection
Form can be one or more；And each described adjustment form includes adjustment type and adjustment mode；
The adjustment type includes may specify some specific data adjusted in the tables of data；
The adjustment mode includes formula that can be built-in.
10. adjustment in batches device as claimed in claim 6, which is characterized in that entire data to be adjusted is more in the tables of data
The continuous or discrete data interval of item.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210424235.4A CN103793400B (en) | 2012-10-30 | 2012-10-30 | The batch regulation method and device of tables of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210424235.4A CN103793400B (en) | 2012-10-30 | 2012-10-30 | The batch regulation method and device of tables of data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103793400A CN103793400A (en) | 2014-05-14 |
| CN103793400B true CN103793400B (en) | 2018-06-01 |
Family
ID=50669083
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210424235.4A Active CN103793400B (en) | 2012-10-30 | 2012-10-30 | The batch regulation method and device of tables of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103793400B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104572105B (en) * | 2015-01-07 | 2017-10-20 | 广东欧珀移动通信有限公司 | Data-updating method and device |
| CN118095206A (en) * | 2024-04-26 | 2024-05-28 | 山东捷瑞数字科技股份有限公司 | Batch updating method, device, equipment and medium for text layer formats in video |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101187934A (en) * | 2006-11-21 | 2008-05-28 | 国际商业机器公司 | Method and system for providing high performance data modification of relational database tables |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101064630B (en) * | 2006-04-24 | 2011-09-21 | 华为技术有限公司 | Data synchronization method and system |
| CN100566234C (en) * | 2007-07-16 | 2009-12-02 | 腾讯科技（深圳）有限公司 | Method of data synchronization and processing method, client device, server |
| CN101763261B (en) * | 2009-12-28 | 2013-01-23 | 山东中创软件商用中间件股份有限公司 | Method and system for extracting, converting and loading data |
| US20110289450A1 (en) * | 2010-05-21 | 2011-11-24 | Yokogawa Electric Corporation | Method and apparatus for displaying batch execution data of an industrial plant |
| CN102486785A (en) * | 2010-12-06 | 2012-06-06 | 金蝶软件（中国）有限公司 | Data synchronization method, device and system |
| CN102437920B (en) * | 2011-09-05 | 2017-06-16 | 南京中兴新软件有限责任公司 | The processing method of configuration data, device and wireless telecommunications system |
-
2012
- 2012-10-30 CN CN201210424235.4A patent/CN103793400B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101187934A (en) * | 2006-11-21 | 2008-05-28 | 国际商业机器公司 | Method and system for providing high performance data modification of relational database tables |
Non-Patent Citations (1)
| Title |
|---|
| "论ERP系统成批更改数据时的条件界定";石雪玲;《电脑与信息技术》;20110228;第19卷(第1期);第60-62页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103793400A (en) | 2014-05-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107066272B (en) | Page updating method and device | |
| US10133452B2 (en) | Facilitating data science operations | |
| CN105824698A (en) | Task priority correcting method and device | |
| CN107357825A (en) | A kind of project document management system based on database | |
| CN108090198A (en) | Chart database creates and data load method, equipment and medium | |
| CN109871382A (en) | A kind of implementation method and device of tables of data access java standard library | |
| CN105761028A (en) | Material storage information recording method and system based on two-dimensional code | |
| CN103793400B (en) | The batch regulation method and device of tables of data | |
| CN106354641A (en) | Testing method and device for process engine | |
| CN106897808A (en) | A kind of workflow creation method and apparatus | |
| CN108197207A (en) | Batch data matches introduction method | |
| CN106250110A (en) | Set up the method and device of model | |
| CN104123401A (en) | CAE intelligent system | |
| CN108334451A (en) | page compatibility test method and device | |
| CN112206529A (en) | Data processing method and device | |
| CN111083567B (en) | Live client home page configuration system, storage medium, electronic device and method | |
| CN112055018A (en) | Message analysis method and device | |
| CN110531968A (en) | A method of detaching web front-end function code generates independent template automatically | |
| US9003985B2 (en) | Device and non-transitory computer-readable medium | |
| CN106358085A (en) | Method for managing tasks under television standby state and television | |
| CN110490447B (en) | Pull type production task regulation and control method, device and equipment | |
| CN116628509B (en) | Model training method, device, equipment and storage medium | |
| CN113160356B (en) | Clothing picture template batch processing display system based on Python | |
| CN110457064A (en) | The generation method and device of network cutover script | |
| CN109558195B (en) | Font special effect adjusting method, medium, computer equipment and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |