CN103544153A - Data updating method and system based on database - Google Patents
Data updating method and system based on database Download PDFInfo
- Publication number
- CN103544153A CN103544153A CN201210237777.0A CN201210237777A CN103544153A CN 103544153 A CN103544153 A CN 103544153A CN 201210237777 A CN201210237777 A CN 201210237777A CN 103544153 A CN103544153 A CN 103544153A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- data volume
- withholding
- internal memory
- 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
Images
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/23—Updating
- G06F16/2308—Concurrency control
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data updating method and system based on a database. The data updating method based on the database comprises the steps that when a data updating request containing a data size, to be deleted, requested to be deleted is received, whether a pre-deleted data size is stored in a local memory is judged, wherein the pre-deleted data size is equal to or larger than the data size to be deleted; if the pre-deleted data size is stored in the local memory, then the data size to be deleted is deleted from the pre-deleted data size in the local memory; only when no pre-deleted data size is stored in the local memory or the stored pre-deleted data size is smaller than the data size to be deleted, the predicted remaining size of data is acquired from the database, the database deleting amount is determined at the same time and is used as the pre-deleted data size in the local memory to be stored, and then the data size to be deleted is deleted from the pre-deleted data size in the local memory. The data updating method based on the database has the advantages that the number of times of database access can be reduced, time for lock wait is then reduced, and the number of processed data updating requests within a unit time of the system is increased.
Description
Technical field
The application relates to database technical field, particularly a kind of data-updating method and system based on database.
Background technology
Database is a shared resource, can use for a plurality of users.In order to make full use of the feature of database resource, performance database shared resource, allow a plurality of users access database concurrently.But when the same data of a plurality of user concurrent access, in database, will produce a plurality of affairs and same data be carried out the situation of accessing operation simultaneously, if concurrent operations is not added to control, just may there are not reading and storing incorrect data, destroy the consistance of database.
With the ticket booking in plane ticket seat reservation system, be operating as example, the air ticket surplus of supposing certain flight is 16, the second ticket seller of the first ticket seller of first ticket counter and second ticket counter reads this flight residue air ticket and is 16, if first ticket seller and second ticket seller respectively sell an air ticket at synchronization, will to revise air ticket surplus be that 16-1=15 opens to first ticket counter, and write back database; It is that 16-1=15 opens that while second ticket counter also can be revised air ticket surplus, and writes back database.Like this, when although seat reservation system is sold altogether two tickets, in database, the surplus of air ticket only reduces one, and the air ticket surplus in database is updated to 16-1=15 and opens, thereby the problems such as lost update due to concurrent operations, have been caused, the problem of inconsistency that database is occurred.
The inconsistency that causes database for fear of the concurrent operations due to user, generally by database being added to exclusive lock to realize concurrent control, be a certain affairs to certain table in database maybe a certain record of this table lock, to guarantee that the same time only has these affairs to modify to this table or this record, only have after these affairs have discharged its lock, other affairs just can be modified to this table or this record.Like this, when compared with multi-user simultaneously in accessing database during a certain data object (producing the concurrent operations of a plurality of affairs), if certain affairs is blocked this data object, other affairs must be waited for, thereby because producing a large amount of locks, waits for lock inadequate resource, even failure operation.
Therefore, need at present the urgent technical matters solving of those skilled in the art to be exactly: how to realize the concurrent control to the Database Systems of resource-constrained, the stand-by period of waiting for to reduce lock.
Summary of the invention
The application provides a kind of data-updating method based on database, in order to solve the problem of the waits for too long that in prior art, in Concurrency Access process, existing lock is waited for.
The application also provides a kind of data update system based on database, in order to guarantee said method implementation and application in practice.
In order to address the above problem, the application discloses a kind of data-updating method based on database, comprising:
A, the request of reception Data Update, described Data Update request comprises the data volume to be detained of request deduction;
B, judge in local internal memory, whether to store the data volume of withholding, and described in withhold data volume be not less than described in data volume to be detained, if so, execution step E; If not, perform step C;
C, obtain the budget surplus amount of the described data that record in database, and according to data volume described to be detained and described budget surplus amount specified data storehouse tare;
D, from the budget surplus amount of described data-base recording, deduct described database tare, and the data volume of withholding in local internal memory is stored using described database tare;
Data volume to be detained described in deduction in E, the data volume of withholding of storing from described local internal memory, to upgrade the data volume of withholding in local internal memory.
The invention also discloses a kind of data update system based on database, comprising:
Request reception unit, for receiving Data Update request, described Data Update request comprises the data volume to be detained of request deduction;
Judging unit, be used for judging whether local internal memory stores the data volume of withholding, and described in withhold data volume be not less than described in data volume to be detained, and store when judging in local internal memory the data volume of withholding, and described in withhold data volume be not less than described in when detaining data volume, trigger to carry out the operation of local data deduction unit; In judging local internal memory, do not store withhold data volume or described in withhold data volume be less than described in when detaining data volume, trigger to carry out the operation of the first data-reading unit;
The first data-reading unit, for obtaining the budget surplus amount of the described data that database records;
Tare determining unit, for data volume to be detained described in basis and described budget surplus amount specified data storehouse tare, and the operation of executing data updating block;
Database update unit, deducts described database tare for the budget surplus amount from described data-base recording, and the data volume of withholding in local internal memory is stored using described database tare, and carries out the operation of described local data updating block;
Local data updating block, for data volume to be detained described in deduction the data volume of withholding of storing from described local internal memory, to upgrade the data volume of withholding in local internal memory.
Compared with prior art, the application comprises following advantage:
In this application, in the application when system receives Data Update request, can't directly from database, obtain data so that database is carried out to write operation, the data volume of withholding of only storing in local internal memory be less than that this Data Update request asks when detaining data volume, just can be from carrying out the operation of obtaining data from database, thereby the access times to database have been reduced, reduced the write operation number of times to database, and then reduced the stand-by period that lock is waited for, and improved the quantity of deal with data update request in the system unit time, improved the handling capacity of system.
Certainly, arbitrary product of enforcement the application might not need to reach above-described all advantages simultaneously.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present application, below the accompanying drawing of required use during embodiment is described is briefly described, apparently, accompanying drawing in the following describes is only some embodiment of the application, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the schematic flow sheet of embodiment 1 of a kind of data-updating method based on database of the application;
Fig. 2 is the schematic flow sheet of embodiment 2 of a kind of data-updating method based on database of the application;
Fig. 3 is the schematic flow sheet of the embodiment 3 of a kind of data-updating method based on database of the application;
Fig. 4 is the structural representation of the embodiment 1 of a kind of data update system based on database of the application;
Fig. 5 is the structural representation of the embodiment 2 of a kind of data update system based on database of the application.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present application, the technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only the application's part embodiment, rather than whole embodiment.Embodiment based in the application, those of ordinary skills are not making the every other embodiment obtaining under creative work prerequisite, all belong to the scope of the application's protection.
The application can be used in numerous general or special purpose calculation element environment or configuration.For example: personal computer, server computer, handheld device or portable set, plate equipment, multi-processor device, comprise distributed computing environment of above any device or equipment etc.
The application can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises the routine carrying out particular task or realize particular abstract data type, program, object, assembly, data structure etc.Also can in distributed computing environment, put into practice the application, in these distributed computing environment, by the teleprocessing equipment being connected by communication network, be executed the task.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium that comprises memory device.
One of main thought of the application can comprise, when system receives Data Update request, if store the data volume of withholding in local internal memory, and this data volume of withholding be not less than in this Data Update request when detaining data volume, in the data volume of withholding of directly storing, deduct this data volume to be detained from local internal memory; Only have and in local internal memory, do not store the data volume of withholding of storing in withhold data volume or local internal memory and be less than when detaining data volume, from database, obtain the budget surplus amount of the corresponding data of this Data Update request, and according to this budget surplus amount and data volume specified data to be detained storehouse tare, from budget surplus amount, deduct this database surplus, and the data volume of withholding using database surplus as local internal memory stores, and then deduct data volume to be detained in the data volume of withholding of local internal memory.Like this, when system receives Data Update request, only have the data volume of withholding of storing in local internal memory can not meet in this Data Update request request deduction when detaining data volume, just can from database, obtain corresponding data database is carried out to read-write operation, thereby greatly reduced the read-write number of times to data in database, reduced the latching operation number of times of database, and then reduced the lock stand-by period, and improved deal with data update request number of times in the system unit time, increase throughput of system, promoted system treatment effeciency.
Referring to Fig. 1, show the process flow diagram of a kind of data-updating method embodiment 1 based on database of the application, the present embodiment can comprise the following steps:
Step 101: receive Data Update request, this Data Update request comprises the data volume to be detained of request deduction.
Data Update request comprises the information such as data volume to be detained of data message to be updated and request deduction.This Data Update request can be understood as the request of obtaining the data resource of storing in database, when system receives this Data Update request, can determine data resource to be updated, and the data volume that needs deduction.
Be understandable that, this Data Update request can be the Data Update request that other-end outside native system or client send to native system, can be also the Data Update request generating in the server of system, at this, does not limit.
For example, with plane ticket seat reservation system, server system can receive user and send air ticket subscription request from client; Certainly, the ticket seller of ticket counter also can be according to user's request to server input air ticket subscription request, and then make application program receive this air ticket subscription request, in this air ticket subscription request, can comprise air ticket kind and ticket booking quantity that request is ordered, this air ticket subscription request is exactly a kind of Data Update request.
Step 102: judge whether store the data volume of withholding in local internal memory, and the data volume of withholding of storing in local internal memory is not less than this data volume to be detained, if so, performs step 105; If not, perform step 103.
Wherein, local internal memory also can be called local internal storage.
When receiving Data Update request, system can't directly be obtained corresponding data volume from database, but first judge in local internal memory, whether to store the corresponding data volume of withholding of data of asking with this Data Update request, and whether this data volume of withholding can meet the data resource amount that Data Update request is asked, and according to judged result, determine whether from database, to obtain data and upgrade the data volume of withholding in local internal memory, the data volume of being asked to meet Data Update request.
Step 103: obtain the budget surplus amount of these data that record in database, and according to this data volume to be detained and budget surplus amount specified data storehouse tare.
When local internal memory stores, do not meet the withholding during data volume of Data Update request, the data resource type of asking according to Data Update request is obtained the budget surplus amount of these data of record from database.
Wherein, budget surplus amount is the surplus of these data of current storage in database.Total amount of data pre-stored in general database can be called budget total amount, and deduct a certain amount of data volume from budget total amount after, in database, the surplus of these data is called budget surplus amount.In database, can safeguard a budget summary table, in this budget summary table, record this budget total amount and budget surplus amount.Take air ticket order system as example, establish the fly to air ticket in Xi'an of Beijing and add up to 150, the budget total amount of this air ticket of storing in database is 150, and when deducted 50 Zhang Fei's air tickets in database after, in database, current budget surplus amount is 100.
According to the budget surplus amount of these data in database and data volume to be detained, determine a database tare, can be by built-in data deduction rule in system, the preset data deduction rule of certain difference according to actual needs may be different.For example, can carry out specified data storehouse tare according to the proportionate relationship of budget surplus amount and data volume to be detained, default deduction rule can be: budget surplus amount is greater than when detaining 50 times of data volume, and specified data storehouse tare is this data volume to be detained 10 times; When budget data amount is less than or equal to when detaining 50 times of data volumes, relatively 10 of this data volume to be detained with the magnitude relationship of this budget surplus amount, when when being less than budget surplus amount for 10 times that detain surplus, will data volume be detained as database tare, otherwise, using 5 times of data volume to be detained as database tare.
No matter adopt which kind of mode specified data storehouse tare, all should guarantee that the database tare of determining should be more than or equal to the data volume to be detained in this Data Update request and be less than the budget surplus amount of database.This database tare is the data volume that need to deduct from the budget surplus amount of this data-base recording of determining.
Step 104: deduct this database tare from the budget surplus amount of data-base recording, and the data volume of withholding in local internal memory is stored using this database tare.
In the budget surplus amount recording, deduct this database tare from database, when deduction result is written back in database to the budget surplus amount to record in new database more, the data volume of withholding using database tare in local internal memory is stored.
Wherein using the data tare in this database, the data volume of withholding in local internal memory is stored the two kinds of situations that comprise:
Be wherein: the data volume of withholding in local internal memory is updated to a database tare, and the data volume of withholding of storing in the local internal memory of current time should be identical with the quantitative value of this database tare.For example, from the database tare of determining, be 1000, the data volume of withholding in the local internal memory of current time is updated to 1000.
Another kind of mode is: this database tare is deposited in local internal memory to the data volume sum of withholding that the total data value of the data volume of withholding in the local internal memory of current time has been stored in local internal memory before should be for data tare and current time as the data volume of withholding to local internal memory to be deposited.For example, when the data volume of withholding in local internal memory is 50, and data volume to be detained is 60 in the Data Update request receiving, the data volume of withholding in local internal memory can not meet the data volume to be detained that deduction is asked in this Data Update request, need to from database, obtain the budget surplus amount of these data, and specified data storehouse tare, suppose that the database tare of determining is 1000, this database tare is joined to withholding in data volume of local internal memory, the data volume of withholding in the local internal memory of current time is 1050.
Step 105: deduct data volume to be detained in the data volume of withholding of storing from local internal memory, to upgrade the data volume of withholding in local internal memory.
In step 102, judge the data volume of withholding of storing in local internal memory and can meet the data volume that this Data Update request is asked, or through the as above operation of step 103 to 104 data volume to be detained that the database tare getting from database is stored in local internal memory, while making the data volume of withholding in local internal memory can meet the data volume that this Data Update request asks, from local internal memory, deduct the data volume to be detained that deduction is asked in this Data Update request.
After having deducted this secondary data update request asked the data volume to be detained of deduction from local internal memory, if again receive the data volume to be detained that Data Update request and this Data Update request ask, be less than the data volume of withholding of storing in the local internal memory of current time, can directly from the data volume of withholding of local internal memory, deduct data volume accordingly to be detained.
It will be appreciated by those skilled in the art that, when local internal memory carries out speed that data read much larger than carry out the speed of data access at database, therefore, the application does not need from database, to obtain data with the processing of complete paired data update request at every turn, can greatly improve the processing speed of Data Update request, and then improved the number of times of deal with data update request in the unit interval, improved throughput of system.
In the application, be not all can carry out accessing operation to database when receiving Data Update request at every turn, only have when judging the data volume of withholding of storing in local internal memory and can not meet in the situation of this Data Update request, just can carry out and from database, obtain data, specified data storehouse tare the operation to the budget surplus amount in change database, thereby the access times to database have been reduced, and then reduced Database lock number of operations, reduced the time span of lock stand-by period; Simultaneously, the data volume of withholding of storing in local internal memory can meet that Data Update request asks when detaining data volume, directly in the data volume of withholding of local internal memory, deduct this data volume to be detained, improved the processing speed to data update request, and then improved the number of times of deal with data update request in the unit interval, improve throughput of system, promoted system treatment effeciency.
The data-updating method based on database in this application can be applied in any server system, as the method can be applied in database server, also can be applied to carry out in the server system of data interaction with database server.Be understandable that, when the application's method is applied to carry out in the server of data interaction with database server, when system judge in local internal memory, do not store withhold data volume or described in withhold data volume can not meet deduction that described Data Update request asks when detaining data volume, obtaining the budget surplus amount recording in database can be understood as: to Database Server System data read request, comprise the budget data amount corresponding with data volume described to be detained that read in this data read request; Database server receives described data read request and request of data result is returned to the server system that this sends data read request; This server system is according to budget data amount with wait detaining data volume while determining database tare, to database server, send the request of this database tare of deduction, database server receives this request and from the data redundancy amount of data-base recording, deducts this database tare.
In actual applications, generally can exist a plurality of servers that are distributed in diverse geographic location from database server, to obtain the situation of same data, therefore just may exist the data volume of withholding in the local internal memory that is assigned to this system excessive, and make other servers or application program cannot from database, get the situation of enough data volumes.For example, still take air ticket ticket sale system as example, if ticket counter has ticket counter A, ticket counter B and ticket counter C, if the server of ticket counter C is after database gets budget air ticket surplus, that determines treats that deduction poll amount is larger, although can not exert an influence to the ticket sale process of ticket counter A server, but may make air ticket surplus and actual the differing greatly of in database, storing, and then may cause the server of ticket counter B or C cannot from database, get the air ticket quantity that meets its air ticket order demand.Appearance for fear of this kind of situation, need more reasonably to determine data volume to be detained, therefore, when system gets budget surplus amount from database, also need to obtain the budget total amount of data-base recording, and carry out specified data storehouse tare according to the data volume to be detained in budget total amount, budget surplus amount and Data Update request.
According to the specific implementation of budget total amount, budget surplus amount and data volume specified data to be detained storehouse tare, also can set as required, general can carry out specified data storehouse tare according to the proportionate relationship of budget total amount, budget surplus amount and data volume to be detained.According to the difference of the deduction rule of setting, the data volume to be detained of asking for same budget total amount, budget surplus amount and Data Update request, the database tare of determining also may all differences.
For the ease of understanding, the integration deduction business of take is example, describes the process that budget total amount, budget surplus amount and data volume to be detained are carried out specified data storehouse tare:
The total mark of storing in database in integration deduction business is certain, i.e. budget total amount is definite value, supposes that default deduction rule is:
1) if budget surplus amount is less than or equal to 1/30 o'clock of budget total amount, database tare equals this data volume to be detained;
2) if budget surplus amount is greater than 1/30 o'clock of budget total amount, choose 30 times of this data volume to be deducted with budget total amount 1/100 in compared with small data as selected data amount not, by this, selected data amount and data volume to be detained are not made comparisons, if this not selected data amount be greater than this data volume to be detained, using this not selected data amount as database data amount; If this not selected data amount be less than this data volume to be detained, using this data volume to be detained as database tare.
The budget total amount of supposing integration is 12000 integrations, and current budget surplus amount is 8000 integrations.According to above default deduction rule, budget surplus amount is greater than 1/30 of budget total amount, meets 2) condition.If the data volume to be detained comprising in the Data Update request that system receives is 50 integrations, 30 times of this data volume to be detained is 1500 integrations, and budget total amount 1/100 is 120 integrations, select data less in the two 120 integrations as selected data amount not, this not selected data amount 120 integrations be greater than data volume 50 integrations to be detained, therefore database tare is decided to be to 120 integrations, from the budget surplus amount of database, deduct this 120 integration, and the data volume of withholding in local internal memory is stored using this 120 integration.
Above example is only a kind of deduction rule of also enumerating in order clearly to understand the solution of the present invention, but in actual applications, for the deduction system of finite data resource, the deduction of setting rule may be different, and the application is not specifically limited deducting rule.
Referring to Fig. 2, show the schematic flow sheet of the embodiment 2 of a kind of data-updating method based on data of the application, the present embodiment comprises the steps:
Step 201: receive Data Update request, this Data Update request comprises the data volume to be detained of request deduction.
Step 202: judge whether store the data volume of withholding in local internal memory, and the data volume of withholding of storing in local internal memory is not less than this data volume to be detained, if so, performs step 206; If not, perform step 203.
Step 203: obtain the budget surplus amount of these data that record in database, and according to this data volume to be detained and budget surplus amount specified data storehouse tare.
Step 201 to the operating process of step 203 and embodiment illustrated in fig. 1 in step 101 similar to the operating process of step 103, do not repeat them here.
Step 204: deduct this database tare from the budget surplus amount of data-base recording, and the information of database tare deducted in record from budget surplus amount in database.
In the present embodiment in order to carry out record to the deduction situation of these data that record in database, so that Database Systems are carried out data maintenance, while deducting this database tare the budget surplus amount from data-base recording, also need in database, record the information of deducting database tare from this budget surplus amount.
The information that database tare deducted in record from budget surplus amount in data can, for generate a record in database, record the database tare that current time is deducted from budget surplus amount in this record.
Concrete, can in database, safeguard the record sheet of withholding, when deducting database tare from budget surplus amount, in withholding record sheet, this inserts the record of withholding, in this record of withholding, record the database tare of current time deduction.As, the integration deduction business of still take is example, when deducting database tare be 1000 integration from budget surplus amount, in the record sheet of withholding, inserts the record of withholding, and in this withholds record, records the information that current time is deducted 1000 integrations.
Step 205: the data volume of withholding using this database tare in local internal memory is stored.
Step 206: deduct data volume to be detained in the data volume of withholding of storing from local internal memory, to upgrade the data volume of withholding in local internal memory, and record the information of deducting this data volume to be detained from this this locality internal memory in the data volume of withholding of storing in database.
When deducting data volume to be detained in the data volume of withholding of local internal memory, also need in database, record the information of deducting this data volume to be detained from this withholds data volume, as by generate a record in database table, in this record, record the information of this data volume to be detained of deducting from this withholds data volume.
In actual applications, can in same tables of data, record and from budget surplus amount, deduct database tare, and the information of deducting this data volume to be detained from local internal memory in the data volume of withholding of storing.As being also recorded in withholding in record sheet of database maintenance by deducting data volume to be detained the data volume of withholding from local internal memory.But for the ease of carrying out data maintenance, in database, can also safeguard a use bill, in the data volume of withholding of storing from local internal memory, deduct when detaining data volume, in this use bill, generate a record, with record, deduct the information of data volume to be detained from the data volume of withholding, this information can comprise the removal time of this data volume to be detained and the data of concrete data volume to be detained etc.
Deduct database tare when the budget surplus amount from database after, employing is deposited into this database tare in local internal memory as the data volume of withholding to local internal memory to be deposited, and during the mode of the total data value of the withhold data volume of data volume sum in the local internal memory of current time of withholding of having stored in local internal memory before this data tare and current time, the information of the database tare that record is deducted in budget surplus amount at every turn from database in database, and the information of the data volume to be detained of deducting in the data volume of at every turn withholding from local internal memory, can determine actual data deduction request, obtain budget surplus amount actual in current database.
Deduct database tare when the budget surplus amount from database after, employing is updated to the data volume of withholding in local internal memory the mode of database tare, in the situation that the data volume of withholding of storing in the local internal memory of current time should be identical with the quantitative value of this database tare, owing to may record the information of deducting database tare from database in many different data volumes of withholding in database, and the database tare at every turn storing in local internal memory might not be deducted completely.
For example, the integration deduction system of take is example, the database tare of deducting from the budget surplus amount of database when 10:00 is 100 integrations, and using this 100 integration the data volume of withholding in local internal memory, in the time of should at least recording 10:00 in database, the database tare of deduction is 100 integrations.According to the Data Update request receiving, withholding from local internal memory deducted data volume except continuous in data volume 100, and the data volume that record is deducted from this withholds data volume in database is detailed simultaneously.The data volume of withholding in local internal memory can not meet Data Update request, system can just be obtained a database tare again from database, suppose when at 10:05, the data volume of withholding of storing in local internal memory is 5, can not meet the data volume to be detained in Data Update request, when 10:05, system is deducted another database tare 200 integrations from the budget surplus amount of database, and when inserting a record being recorded in 10:05 in database, the data volume of deducting from database is 200 integrations.In database, at least two information of deducting database tare from database will be recorded like this, and during for 10:00,100 integrations of deducting from database, in fact by deduction not completely, remaining data amount 5 integrations still, yet after 10:05 divides, system receives Data Update request again, to deduct from data volume 200 integrations of withholding of local internal memory, be actually in database tare 200 integrations and deduct, and be no longer to deduct from original database tare 100 integrations.Therefore, need to distinguish the information of the database tare not recording in the same time, to determine that the database tare of record in which bar record still exists surplus, and then the untapped surplus of reality reclaimed.
For the operation information not recording is in the same time distinguished, when the information of database tare deducted in record in database, can also generate the identification information of the record operation corresponding with this recorded information, to distinguish not the database tare of deduction in the same time.
Corresponding, in the data volume of withholding from local internal memory, deduct when detaining data volume, in order to determine the corresponding operation note of the data volume of withholding in the local internal memory of current time, when using this database tare, the data volume of withholding in local internal memory is stored, also comprise:
The identification information of stored record operation in local internal memory, and set up the corresponding relation of the identification information that withhold data volume and described record in local internal memory operate.
Accordingly, the information of data volume to be detained described in deduction in the data volume of withholding of storing from described local internal memory described in record in described database table, specifically comprises:
According to the corresponding relation of the identification information of withhold data volume and the operation of described record in local internal memory, determine current record operation corresponding to the data volume of withholding in local internal memory;
The use of recording described current record operation in database table is detailed, represents the deduction information each time of the data volume of withholding of described current record operational correspondence in described use detail.
The integration deduction system of still take above describes as example, and system is deducted database 100 integrations from database at 10:00, while generating this record operation, generates the identification information with this record operation, as the record 1 of withholding, and time: 10:00, deducts 100 integrations; Can certainly generate the temporal information of this record as the identification information of this record operation, also can only using " record 1 of withholding " as identification information and without at recording time information.
Accordingly, when 10:05, while deducting 200 integration from database budget surplus amount, in database, generate record operation and corresponding identification information, as, the record 2 of withholding, time: 10:05, deducts 200 integrations.
In order to distinguish, currently store the data volume of withholding in local internal memory into for storing based on above any bar record operation, and in local internal memory, also need to store the identification information of corresponding record operation, as when at 10:00, in budget surplus amount from database, deduct 100 integrations, and using this 100 integration withholding during data volume in local internal memory, in local internal memory, the identification information of storage operation record is " record 1 of withholding ", and the data volume of now withholding in local internal memory is corresponding with the database tare recording in the record 1 of withholding in database.In each data volume of withholding from local internal memory, deduct when detaining data volume, also can in database, be recorded in the database tare of this record 1 record of withholding and deduct data volume to be detained.When deducted 20 integration in the data volume of withholding from local internal memory, in database, also can be recorded in the database tare of this record 1 of withholding and deduct 20 integrations in 100 integrations.
When at 10:05, from database budget surplus amount, deduct database tare 200 integration time, when the data volume of withholding using this 200 integration in local internal memory is stored, also can in local internal memory, store the identification information of corresponding record operation and " withhold and record 2 ".And by the follow-up data volume to be detained of deducting in local internal memory, during as 10 integration, in database, record is deducted data volume 10 integrations to be detained from 200 integrations of record 2 records of withholding.
Certainly, the mode of the identification information recording at generating run is not limited to the mode described in this example, can also have other implementations.In addition, in database in the data amount information to be detained deducted from local internal memory of record, also can generate the record that records this data amount information to be deducted and operate corresponding identification information.
Referring to Fig. 3, show the schematic flow sheet of a kind of data-updating method embodiment 3 based on database of the present invention, the present embodiment comprises the following steps:
Step 301: receive Data Update request, this Data Update request comprises the data volume to be detained of request deduction.
Step 302: judge whether store the data volume of withholding in local internal memory, and the data volume of withholding of storing in local internal memory is not less than this data volume to be detained, if so, performs step 206; If not, perform step 203.
Step 303: obtain the budget surplus amount of these data that record in database, and according to this data volume to be detained and budget surplus amount specified data storehouse tare.
Step 301 to the operating process of step 303 and embodiment illustrated in fig. 1 in step 101 similar to the operating process of step 103, do not repeat them here.
Step 304: deduct this database tare from the budget surplus amount of data-base recording, and the information of database tare deducted in record from budget surplus amount in database.
Step 305: the data volume of withholding using this database tare in local internal memory is stored.
Step 306: deduct data volume to be detained in the data volume of withholding of storing from local internal memory, to upgrade the data volume of withholding in local internal memory, deduct the information of this data volume to be detained in the data volume of withholding that record is stored from this this locality internal memory in database.
Above step can, referring to the description of Fig. 1 and corresponding steps embodiment illustrated in fig. 2, not repeat them here.
Step 307: judge current time be whether default data record constantly, if so, from database, obtain the surplus of the data volume of withholding of record, and this surplus added in the budget surplus amount of database, with the budget surplus amount of new database more.
Due to the database tare of deducting from database, only to be kept in local internal memory, the actual deducted data total amount of database not, and because system is not being deducted repeatedly different database tares in the same time from database, therefore the data that need to store in to database every Preset Time are upgraded, less to guarantee the deviation of the real surplus amount of budget surplus amount and data in database.Concrete, at current time, be default data record constantly time, need to from database, obtain the surplus of all data volumes of withholding of record, and surplus be added in the budget surplus amount of database, and then new database surplus more.
Determine that whether current time is that default data record mode constantly has multiple, as can preliminary setting data return period, and then according to the default data record cycle determine current time be whether data record constantly.
Embodiment as shown in Figure 2 can find out, in database, can record the information of many deduction database tares simultaneously, therefore, arrive default data record during the moment, can the surplus of the data volume of withholding recording in database all be added in the budget surplus amount of database being, can be also only the surplus of other data volumes of withholding outside the data volume of withholding in the local internal memory of current time to be added in the budget surplus amount of data-base recording.
For example, integration deduction system above records in database: the record 1 of withholding, and the time: during 10:00, database tare 100; And the surplus to the data volume of should database tare 100 integrations withholding is 5 integrations.And the data volume of withholding of storing in the local internal memory of current time is corresponding with tare 200 integrations of withholding in record 2 of data-base recording, therefore, when carrying out data record, can be only detailed according to the use corresponding with the record 1 of withholding, the surplus of determining these database tare 100 integrations is 5 integrations, and this 5 integration is added back in the budget surplus amount of data-base recording; For with withhold record 2 in database tare 200 real surplus amount and can not be added back in the budget surplus amount of database.
In actual applications, the budget surplus amount from database, deduct database tare, and during the database tare information of record deduction, also can set accordingly effective duration of the recorded information of this database tare in database.If arrive default data record during the moment, the recorded information that records certain database tare in database has exceeded default effective duration, the surplus of the data volume of withholding corresponding to the database tare recording in this recorded information is added back in the budget surplus amount of data-base recording.
Corresponding with the method that a kind of data-updating method embodiment 1 based on database of above-mentioned the application provides, referring to Fig. 4, the application also provides a kind of data update system embodiment 1 based on database, in the present embodiment, this system can comprise: request reception unit 410, judging unit 420, the first data-reading unit 430, tare determining unit 440, data updating unit 450 and local data updating block 460.Wherein, request reception unit 410, for receiving Data Update request, described Data Update request comprises the data volume to be detained of request deduction.
Judging unit 420, be used for judging whether local internal memory stores the data volume of withholding, and described in withhold data volume be not less than described in data volume to be detained, and store when judging in local internal memory the data volume of withholding, and described in withhold data volume be not less than described in when detaining data volume, trigger to carry out the operation of local data deduction unit; In judging local internal memory, do not store withhold data volume or described in withhold data volume be less than described in when detaining data volume, trigger the operation of executing data reading unit;
The first data-reading unit 430, for obtaining the budget surplus amount of the described data that database records;
Local data updating block 460, for data volume to be detained described in deduction the data volume of withholding of storing from described local internal memory, to upgrade the data volume of withholding in local internal memory.
Wherein, tare determining unit is when determining the database tare of deducting from the budget surplus amount of database, can also be with reference to other data factor, accordingly, the system of the present embodiment can also comprise: the second data-reading unit, and for obtaining the budget total amount of the described data of described data-base recording.
Accordingly, tare determining unit is specially: for according to the proportionate relationship between described budget total amount, budget surplus amount and data volume to be detained, and specified data storehouse tare.
The application's the data update system based on database can be integrated any one can be carried out in the server of data interaction with database server, also can be used as an entity and is connected with server.
System in the application is not all can carry out accessing operation to database when receiving Data Update request at every turn, only have when judging the data volume of withholding of storing in local internal memory and can not meet in the situation of this Data Update request, just can carry out and from database, obtain data, specified data storehouse tare the operation to the budget surplus amount in change database, thereby the access times to database have been reduced, and then reduced Database lock number of operations, reduced the time span of lock stand-by period; Simultaneously, the data volume of withholding of storing in local internal memory can meet that Data Update request asks when detaining data volume, directly in the data volume of withholding of local internal memory, deduct this data volume to be detained, improved the processing speed to data update request, and then improved the number of times of deal with data update request in the unit interval, improve throughput of system, promoted system treatment effeciency.
Referring to Fig. 5, show the structural representation of a kind of data update system embodiment 2 based on database of the application, the present embodiment and difference embodiment illustrated in fig. 4 are:
In the present embodiment, also comprise: first information record cell 470, for when data updating unit is deducted database tare from the budget surplus amount of data-base recording, in database, described in record, from described budget surplus amount, deduct the information of described database tare.
The second information recording unit 480, described in deduct the data volume of withholding of storing from described local internal memory for described data updating unit when detaining data volume, the information of data volume to be detained described in deducting in the data volume of withholding of storing from described local internal memory described in record in database.
Further, in order to distinguish the database tare of deducting of each record from database, this system also comprises:
Sign storage unit, for the identification information in local internal memory stored record operation, and sets up the corresponding relation of the identification information that withhold data volume and described record in local internal memory operate;
Accordingly, this second information recording unit 480, specifically comprises: operation note determining unit and the second information recording subelement.
Wherein, operation note determining unit, for according to the corresponding relation of the identification information of withhold data volume and the operation of described record of local internal memory, determines current record operation corresponding to the data volume of withholding in local internal memory.
The second information recording subelement, for record the use detail of described current record operation at database table, represents the deduction information each time of the data volume of withholding of described current record operational correspondence in described use detail.
Further, in order to guarantee that the budget surplus amount of database and the real surplus amount of these data do not have relatively large deviation, also need the surplus of the data volume of withholding to recording in database to reclaim.Corresponding, the system of the present embodiment also comprises:
Reclaim judging unit constantly, for judging whether current time is the default data record moment, if, from database, obtain the surplus of the data volume of withholding of record, and described surplus is added in the budget surplus amount of described data-base recording, with the budget surplus amount in new database more.
Device described in the present embodiment can be integrated on the server of Data Update processing, also the server that can process with Data Update as an entity is separately connected, in addition, it should be noted that, when the method described in the application adopts software to realize, can be used as the newly-increased function of server that Data Update is processed, can write separately corresponding program yet, the application does not limit the implementation of described method or device.
It should be noted that, each embodiment in this instructions all adopts the mode of going forward one by one to describe, and each embodiment stresses is the difference with other embodiment, between each embodiment identical similar part mutually referring to.For device class embodiment, because it is substantially similar to embodiment of the method, so description is fairly simple, relevant part is referring to the part explanation of embodiment of the method.
Finally, also it should be noted that, in this article, relational terms such as the first and second grades is only used for an entity or operation to separate with another entity or operational zone, and not necessarily requires or imply and between these entities or operation, have the relation of any this reality or sequentially.And, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thereby the process, method, article or the equipment that make to comprise a series of key elements not only comprise those key elements, but also comprise other key elements of clearly not listing, or be also included as the intrinsic key element of this process, method, article or equipment.The in the situation that of more restrictions not, the key element being limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment that comprises described key element and also have other identical element.
While for convenience of description, describing above device, with function, being divided into various unit describes respectively.Certainly, when implementing the application, the function of each unit can be realized in same or a plurality of software and/or hardware.
As seen through the above description of the embodiments, those skilled in the art can be well understood to the mode that the application can add essential general hardware platform by software and realizes.Understanding based on such, the part that the application's technical scheme contributes to prior art in essence in other words can embody with the form of software product, this computer software product can be stored in storage medium, as ROM/RAM, magnetic disc, CD etc., comprise that some instructions are with so that a computer equipment (can be personal computer, server, or the network equipment etc.) carry out the method described in some part of each embodiment of the application or embodiment.
A kind of data-updating method and the system based on database above the application being provided is described in detail, applied specific case herein the application's principle and embodiment are set forth, the explanation of above embodiment is just for helping to understand the application's method and core concept thereof; Meanwhile, for one of ordinary skill in the art, the thought according to the application, all will change in specific embodiments and applications, and in sum, this description should not be construed as the restriction to the application.
Claims (12)
1. the data-updating method based on database, is characterized in that, comprising:
A, the request of reception Data Update, described Data Update request comprises the data volume to be detained of request deduction;
B, judge in local internal memory, whether to store the data volume of withholding, and described in withhold data volume be not less than described in data volume to be detained, if so, execution step E; If not, perform step C;
C, obtain the budget surplus amount of the described data that record in database, and according to data volume described to be detained and described budget surplus amount specified data storehouse tare;
D, from the budget surplus amount of described data-base recording, deduct described database tare, and the data volume of withholding in local internal memory is stored using described database tare;
Data volume to be detained described in deduction in E, the data volume of withholding of storing from described local internal memory, to upgrade the data volume of withholding in local internal memory.
2. method according to claim 1, is characterized in that, before data volume to be detained described in described basis and described budget surplus amount specified data storehouse tare, also comprises:
Obtain the budget total amount recording in described database;
Accordingly, data volume to be detained and described budget surplus amount specified data storehouse tare described in described basis, be specially:
According to the proportionate relationship between described budget total amount, budget surplus amount and data volume to be detained, specified data storehouse tare.
3. method according to claim 1, is characterized in that, after deducting described database tare, also comprises from described budget surplus amount:
In database, described in record, from described budget surplus amount, deduct the information of described database tare.
4. method according to claim 3, is characterized in that, described in deducting, after data volume to be detained, also comprises in the data volume of withholding of storing from described local internal memory:
The information of data volume to be detained described in deduction in the data volume of withholding of storing from described local internal memory described in record in database.
5. method according to claim 4, is characterized in that, after using described database tare, the data volume of withholding in local internal memory is stored, also comprises:
The identification information of stored record operation in local internal memory, and set up the corresponding relation of the identification information that withhold data volume and described record in local internal memory operate;
The information of data volume to be detained described in deducting in the described data volume of withholding of storing from described local internal memory described in record in described database table, specifically comprises:
According to the corresponding relation of the identification information of withhold data volume and the operation of described record in local internal memory, determine current record operation corresponding to the data volume of withholding in local internal memory;
The use of recording described current record operation in database table is detailed, represents the deduction information each time of the data volume of withholding of described current record operational correspondence in described use detail.
6. method according to claim 4, is characterized in that, also comprises: judge that whether current time is the default data record moment, if so, obtains the surplus of the data volume of withholding of record from database;
Described surplus is added in the budget surplus amount of described data-base recording, to upgrade the budget surplus amount recording in described database.
7. the data update system based on database, is characterized in that, comprising:
Request reception unit, for receiving Data Update request, described Data Update request comprises the data volume to be detained of request deduction;
Judging unit, be used for judging whether local internal memory stores the data volume of withholding, and described in withhold data volume be not less than described in data volume to be detained, and store when judging in local internal memory the data volume of withholding, and described in withhold data volume be not less than described in when detaining data volume, trigger to carry out the operation of local data deduction unit; In judging local internal memory, do not store withhold data volume or described in withhold data volume be less than described in when detaining data volume, trigger to carry out the operation of the first data-reading unit;
The first data-reading unit, for obtaining the budget surplus amount of the described data that database records;
Tare determining unit, for data volume to be detained described in basis and described budget surplus amount specified data storehouse tare, and the operation of executing data updating block;
Database update unit, deducts described database tare for the budget surplus amount from described data-base recording, and the data volume of withholding in local internal memory is stored using described database tare, and carries out the operation of described local data updating block;
Local data updating block, for data volume to be detained described in deduction the data volume of withholding of storing from described local internal memory, to upgrade the data volume of withholding in local internal memory.
8. system according to claim 7, is characterized in that, also comprises the second data-reading unit, for obtaining the budget total amount of the described data of described data-base recording;
Accordingly, described tare determining unit is specially: for according to the proportionate relationship between described budget total amount, budget surplus amount and data volume to be detained, and specified data storehouse tare.
9. system according to claim 8, is characterized in that, also comprises:
First information record cell while deducting described database tare for described data updating unit from the budget surplus amount of described data-base recording, is deducted the information of described database tare described in record in database from described budget surplus amount.
10. system according to claim 9, is characterized in that, also comprises:
The second information recording unit, for described in deduct the data volume of withholding of storing from described local internal memory in described data updating unit when detaining data volume, the information of data volume to be detained described in deducting in the data volume of withholding of storing from described local internal memory described in record in database.
11. systems according to claim 10, is characterized in that, also comprise:
Sign storage unit, for the identification information in local internal memory stored record operation, and sets up the corresponding relation of the identification information that withhold data volume and described record in local internal memory operate;
Described the second information recording unit, specifically comprises:
Operation note determining unit, for according to the corresponding relation of the identification information of withhold data volume and the operation of described record of local internal memory, determines current record operation corresponding to the data volume of withholding in local internal memory;
The second information recording subelement, for record the use detail of described current record operation at database table, represents the deduction information each time of the data volume of withholding of described current record operational correspondence in described use detail.
12. systems according to claim 10, is characterized in that, also comprise:
Reclaim judging unit constantly, for judging that whether current time is the default data record moment, if so, obtains the surplus of the data volume of withholding of record from database;
Described surplus is added in the budget surplus amount of described data-base recording, to upgrade the budget surplus amount recording in described database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210237777.0A CN103544153B (en) | 2012-07-10 | 2012-07-10 | A kind of data-updating method based on data base and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210237777.0A CN103544153B (en) | 2012-07-10 | 2012-07-10 | A kind of data-updating method based on data base and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103544153A true CN103544153A (en) | 2014-01-29 |
| CN103544153B CN103544153B (en) | 2016-07-27 |
Family
ID=49967618
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210237777.0A Active CN103544153B (en) | 2012-07-10 | 2012-07-10 | A kind of data-updating method based on data base and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103544153B (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317749A (en) * | 2014-10-31 | 2015-01-28 | 小米科技有限责任公司 | Information writing method and device |
| WO2016019803A1 (en) * | 2014-08-06 | 2016-02-11 | 阿里巴巴集团控股有限公司 | Data processing method, apparatus and system based on distributed memories and databases |
| CN105550366A (en) * | 2016-01-20 | 2016-05-04 | 百度在线网络技术（北京）有限公司 | Inventory information processing method and device |
| CN105701130A (en) * | 2014-11-28 | 2016-06-22 | 阿里巴巴集团控股有限公司 | Numerical value deduction method and system of database |
| CN106302608A (en) * | 2015-06-08 | 2017-01-04 | 阿里巴巴集团控股有限公司 | A kind of information processing method and device |
| CN106469166A (en) * | 2015-08-18 | 2017-03-01 | 阿里巴巴集团控股有限公司 | A kind of information processing method and device |
| CN106469391A (en) * | 2015-08-18 | 2017-03-01 | 阿里巴巴集团控股有限公司 | The method and apparatus reducing inventory data |
| CN109033379A (en) * | 2018-07-27 | 2018-12-18 | 四川爱创科技有限公司 | Material Information Management System method and system suitable for coffee machine |
| CN109271398A (en) * | 2018-10-29 | 2019-01-25 | 东软集团股份有限公司 | Db transaction processing method, device, equipment and computer readable storage medium |
| CN109377120A (en) * | 2018-08-21 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Inventory management method, device and electronic equipment based on cloud service |
| CN109544072A (en) * | 2018-11-21 | 2019-03-29 | 北京京东尚科信息技术有限公司 | Method, system, equipment and medium are reduced in hot spot inventory localization |
| CN109614388A (en) * | 2018-11-14 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Method and apparatus are reduced in a kind of budget |
| CN110728799A (en) * | 2019-10-15 | 2020-01-24 | 恩亿科(北京)数据科技有限公司 | Margin updating method and device |
| CN112015745A (en) * | 2020-08-19 | 2020-12-01 | 北京达佳互联信息技术有限公司 | Data management method and device |
| CN112541780A (en) * | 2020-11-27 | 2021-03-23 | 上海铼锶信息技术有限公司 | Integral data recording system, recording method, storage medium and terminal |
| CN113450171A (en) * | 2020-03-27 | 2021-09-28 | 北京沃东天骏信息技术有限公司 | Order processing method and device |
| CN117271546A (en) * | 2023-11-23 | 2023-12-22 | 卓望数码技术（深圳）有限公司 | Method, device, equipment and storage medium for processing concurrent access of resources |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1538324A (en) * | 2003-04-16 | 2004-10-20 | ��Ϊ��������˾ | Method of raising officiency of data processing |
| US20060074872A1 (en) * | 2004-09-30 | 2006-04-06 | International Business Machines Corporation | Adaptive database buffer memory management using dynamic SQL statement cache statistics |
| CN101364230A (en) * | 2008-09-24 | 2009-02-11 | 金蝶软件（中国）有限公司 | Concurrent access control method and device |
-
2012
- 2012-07-10 CN CN201210237777.0A patent/CN103544153B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1538324A (en) * | 2003-04-16 | 2004-10-20 | ��Ϊ��������˾ | Method of raising officiency of data processing |
| US20060074872A1 (en) * | 2004-09-30 | 2006-04-06 | International Business Machines Corporation | Adaptive database buffer memory management using dynamic SQL statement cache statistics |
| CN101364230A (en) * | 2008-09-24 | 2009-02-11 | 金蝶软件（中国）有限公司 | Concurrent access control method and device |
Non-Patent Citations (2)
| Title |
|---|
| ASHTIANI B,ET AL: "Extension of fuzzy TOPSIS method based on interval-valued fuzzy sets", 《APPLIED SOFT COMPUTING》 * |
| 彭宏 等: "基于并行数据库的海量商务数据管理系统研究", 《计算机应用研究》 * |
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016019803A1 (en) * | 2014-08-06 | 2016-02-11 | 阿里巴巴集团控股有限公司 | Data processing method, apparatus and system based on distributed memories and databases |
| CN105335297A (en) * | 2014-08-06 | 2016-02-17 | 阿里巴巴集团控股有限公司 | Distributed memory and database based data processing method, apparatus and system |
| CN105335297B (en) * | 2014-08-06 | 2018-05-08 | 阿里巴巴集团控股有限公司 | Data processing method, device and system based on distributed memory and database |
| CN104317749B (en) * | 2014-10-31 | 2017-12-05 | 小米科技有限责任公司 | Information write-in method and device |
| CN104317749A (en) * | 2014-10-31 | 2015-01-28 | 小米科技有限责任公司 | Information writing method and device |
| CN105701130A (en) * | 2014-11-28 | 2016-06-22 | 阿里巴巴集团控股有限公司 | Numerical value deduction method and system of database |
| CN105701130B (en) * | 2014-11-28 | 2019-02-01 | 阿里巴巴集团控股有限公司 | Database numerical value reduces method and system |
| CN106302608A (en) * | 2015-06-08 | 2017-01-04 | 阿里巴巴集团控股有限公司 | A kind of information processing method and device |
| US10491707B2 (en) | 2015-06-08 | 2019-11-26 | Alibaba Group Holding Limited | Information processing using a server group |
| CN106302608B (en) * | 2015-06-08 | 2020-02-04 | 阿里巴巴集团控股有限公司 | Information processing method and device |
| CN106469166A (en) * | 2015-08-18 | 2017-03-01 | 阿里巴巴集团控股有限公司 | A kind of information processing method and device |
| CN106469391A (en) * | 2015-08-18 | 2017-03-01 | 阿里巴巴集团控股有限公司 | The method and apparatus reducing inventory data |
| CN106469166B (en) * | 2015-08-18 | 2019-09-06 | 阿里巴巴集团控股有限公司 | A kind of information processing method and device |
| CN105550366A (en) * | 2016-01-20 | 2016-05-04 | 百度在线网络技术（北京）有限公司 | Inventory information processing method and device |
| CN105550366B (en) * | 2016-01-20 | 2019-10-18 | 百度在线网络技术（北京）有限公司 | Inventory information treating method and apparatus |
| CN109033379A (en) * | 2018-07-27 | 2018-12-18 | 四川爱创科技有限公司 | Material Information Management System method and system suitable for coffee machine |
| CN109033379B (en) * | 2018-07-27 | 2022-05-31 | 四川爱创科技有限公司 | Raw material information management method and system suitable for coffee machine |
| CN109377120A (en) * | 2018-08-21 | 2019-02-22 | 中国平安人寿保险股份有限公司 | Inventory management method, device and electronic equipment based on cloud service |
| CN109271398B (en) * | 2018-10-29 | 2020-06-23 | 东软集团股份有限公司 | Database transaction processing method, device, equipment and computer readable storage medium |
| CN109271398A (en) * | 2018-10-29 | 2019-01-25 | 东软集团股份有限公司 | Db transaction processing method, device, equipment and computer readable storage medium |
| CN109614388A (en) * | 2018-11-14 | 2019-04-12 | 阿里巴巴集团控股有限公司 | Method and apparatus are reduced in a kind of budget |
| CN109544072A (en) * | 2018-11-21 | 2019-03-29 | 北京京东尚科信息技术有限公司 | Method, system, equipment and medium are reduced in hot spot inventory localization |
| CN110728799A (en) * | 2019-10-15 | 2020-01-24 | 恩亿科(北京)数据科技有限公司 | Margin updating method and device |
| CN113450171A (en) * | 2020-03-27 | 2021-09-28 | 北京沃东天骏信息技术有限公司 | Order processing method and device |
| CN112015745A (en) * | 2020-08-19 | 2020-12-01 | 北京达佳互联信息技术有限公司 | Data management method and device |
| CN112015745B (en) * | 2020-08-19 | 2024-05-17 | 北京达佳互联信息技术有限公司 | Data management method and device |
| CN112541780A (en) * | 2020-11-27 | 2021-03-23 | 上海铼锶信息技术有限公司 | Integral data recording system, recording method, storage medium and terminal |
| CN117271546A (en) * | 2023-11-23 | 2023-12-22 | 卓望数码技术（深圳）有限公司 | Method, device, equipment and storage medium for processing concurrent access of resources |
| CN117271546B (en) * | 2023-11-23 | 2024-03-01 | 卓望数码技术（深圳）有限公司 | Method, device, equipment and storage medium for processing concurrent access of resources |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103544153B (en) | 2016-07-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103544153A (en) | Data updating method and system based on database | |
| US10255108B2 (en) | Parallel execution of blockchain transactions | |
| CN108388604A (en) | User right data administrator, method and computer readable storage medium | |
| US20140324917A1 (en) | Reclamation of empty pages in database tables | |
| WO2018169429A1 (en) | Framework for the deployment of event-based applications | |
| CN111427971B (en) | Business modeling method, device, system and medium for computer system | |
| CN102682069A (en) | Managing database recovery time | |
| CN110188110B (en) | Method and device for constructing distributed lock | |
| US9501313B2 (en) | Resource management and allocation using history information stored in application's commit signature log | |
| US9697042B2 (en) | Extensibility of business process and application logic | |
| CN105550270B (en) | Data base query method and device | |
| CN103514298A (en) | Method for achieving file lock and metadata server | |
| CN111784318B (en) | Data processing method, device, electronic equipment and storage medium | |
| US20120224482A1 (en) | Credit feedback system for parallel data flow control | |
| CN112306993A (en) | Data reading method, device and equipment based on Redis and readable storage medium | |
| CN108280134B (en) | Data circulation system and method based on account limit control, storage medium and terminal | |
| CN103140850A (en) | Sharing data on mobile devices | |
| CN109684270A (en) | Database filing method, apparatus, system, equipment and readable storage medium storing program for executing | |
| CN106874343B (en) | Data deletion method and system for time sequence database | |
| CN111736975A (en) | Request control method and device, computer equipment and computer readable storage medium | |
| CN102932416A (en) | Intermediate data storage method, processing method and device in information flow task | |
| CN107391539A (en) | Transaction methods, server and storage medium | |
| US11429311B1 (en) | Method and system for managing requests in a distributed system | |
| CN112364021B (en) | Service data processing method, device and storage medium | |
| US20190050266A1 (en) | Software application runtime having dynamic evaluation functions and parameters |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20191216 Address after: P.O. Box 31119, grand exhibition hall, hibiscus street, 802 West Bay Road, Grand Cayman, British Cayman Islands Patentee after: Innovative advanced technology Co., Ltd Address before: Cayman Islands Grand Cayman capital building, a four storey No. 847 mailbox Patentee before: Alibaba Group Holding Co., Ltd. |
|
| TR01 | Transfer of patent right |