CN1334528A - Autocontrol method for processing data in database - Google Patents
Autocontrol method for processing data in database Download PDFInfo
- Publication number
- CN1334528A CN1334528A CN 00121649 CN00121649A CN1334528A CN 1334528 A CN1334528 A CN 1334528A CN 00121649 CN00121649 CN 00121649 CN 00121649 A CN00121649 A CN 00121649A CN 1334528 A CN1334528 A CN 1334528A
- Authority
- CN
- China
- Prior art keywords
- data
- time
- date
- expiration
- database
- 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
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
An automatic control method for processing the data of database features that the "active date and time" and "active data quantity" are used as its control criteria. The system can examine said criteria of data stored in database to automatically and quickly make the data active and correct.
Description
The present invention relates to the method for the automatic control and treatment data of a kind of database, refer to a kind of method that is applicable to publish information on the network data base processing maintenance network especially.
The data processing maintenance work of traditional database, normally being dependent on manual type carries out, but traditional mode of carrying out database processing with manual type, not only because of causing data, artificial carelessness can't effectively handle maintenance easily, and the processing of adopting manpower to carry out database is safeguarded, cost of idleness not only has more shortcomings such as consuming time, effort.
Moreover recently because ecommerce in vogue, the form of database is also by traditional enclosed type database, gradually change into the opening database that can utilize network interworking, so change of form is safeguarded correctly handling fast of database, just becomes very important.
The object of the present invention is to provide a kind of video data on maintenance data base and the webpage of handling, keep the method for the automatic control and treatment data of database of online publish information of correct, the validity of all data.
According to the present invention, the method of the automatic control and treatment data of the database that is provided, it is implemented need use at least database and can enter online server for consumer's mat network, server wherein can be the consumer and shows online publish information, and the control flow of online publish information data be may further comprise the steps:
A. transaction or inspection step are used to conclude the business or quantitative check;
B. the time point determining step in data date of expiration, time whether relatively is used for judging relatively time point whether in data date of expiration, time, if, then carry out next step, if not, then jump move into data invalid;
C. relatively whether quantity adds up to surpass the determining step of effective quantity, is used to judge whether the accumulative total of comparison number of transaction surpasses effective quantity of database, if it is invalid then to be judged as data, then flow process makes this data continuous business if not;
D. delete online publish information and announcement information supplier's step; Be used for judging after " data are invalid ", then directly enter online publish information this data presentation state deletion in flow process, and simultaneously to informant's output information.
In the method for the automatic control and treatment data of above-mentioned database, database and informant's data provide confirms that flow process comprises:
A. the informant sends data to the step of database, is used for providing data by the informant;
B. the step of database built-in " incremental data value " is used for after the informant proposes commodity data, is revised for built-in initial value or according to the quantitative value that the supplier sets by system's judgement " incremental data value ";
C. database built-in " date, time data value " step, be used for after the informant proposes commodity data, judge that by system " date, time data value " make amendment for built-in initial value or the date that sets according to the informant, time value;
D. online publish information step is used for the data publish information demonstration on the net of will set up via above-mentioned steps, consults selection for the user.
In the method for the automatic control and treatment data of above-mentioned database, before entering online publish information step, can add data and rationally confirm step, supply flow process at previous time data value and the incremental data value that increases newly or revise, carry out the rational affirmation of data, if the data rationality is true.Then just enter online publish information, and, then return back to the informant and require to confirm corrective action if the data rationality is wrong.
In the method for the automatic control and treatment data of above-mentioned database, the initial value of " incremental data value " is the maximum value of unlimited amount.
In the method for the automatic control and treatment data of above-mentioned database, the initial value of " date, time data value " is indefinite maximum value.
In the method for the automatic control and treatment data of above-mentioned database, " date, the time data value " of database, " transaction date of expiration, time " reach the judgement of " data date of expiration, time ", with the Internet time (InternetTime) be chronomere.
In the method for the automatic control and treatment data of above-mentioned database, whether " relatively time point the determining step in data date of expiration, time " reach between " relatively quantity whether add up to surpass effective quantity determining step " can increase " relatively whether exchange hour point is above the determining step of conclude the business date of expiration, time ".
In the method for the automatic control and treatment data of above-mentioned database, " concluding the business date of expiration; the time " in should " comparing time point and whether surpass the date of expiration of concluding the business; the determining step of time " be set up on their own by data set provider, and will conclude the business or supervision time point compared with " transaction date of expiration; time " by flow process, if this compares time point in " concluding the business date of expiration; the time ", then flow process enters " relatively whether quantity adds up the determining step above effective quantity ", if relatively time point exceeds " concluding the business date of expiration; the time ", then flow process enters " stopping to provide transaction " program, makes these data shut the book.
In the method for the automatic control and treatment data of above-mentioned database, " relatively whether quantity adds up to surpass the determining step of effective quantity " is before judgment data is invalid, can whether equal earlier " data date of expiration; time " judges " relatively concluding the business date of expiration; the time ", " transaction date of expiration; time " equals " data date of expiration; time " if judge, then flow process enters the invalid program of data, delete online publish information and inform data set provider, " transaction date of expiration; time " is not equal to " data date of expiration; time " if judge, then flow process enters " stopping to provide transaction " program, makes these data shut the book.
The present invention compared with prior art advantage and good effect is very obvious.By above technical scheme as can be known, the present invention provides the judgement important document " date, time and quantity are set " of commodity and " flow process of online publish information is controlled in transaction while or quantitative check " two to detect control models by the informant to database, can make the data in the database of the present invention have quite correct validity, thereby can be automatically, the correctness of fast correct control data, so that it is carried out control and management.
Further specify specific structural features of the present invention and purpose below in conjunction with accompanying drawing.
Brief Description Of Drawings:
Fig. 1 is a preferred embodiment system configuration synoptic diagram of the present invention.
Fig. 2 is that preferred embodiment database of the present invention and informant's data processing is safeguarded decision flow chart.
Fig. 3 is the control flow chart of preferred embodiment database of the present invention with respect to the network publish information.
Fig. 4 is that the present invention is than the control flow chart of another preferred embodiment database with respect to the network publish information.
At first please referring to Fig. 1, the preferable enforcement of the present invention realizes in the mode that network 50 links, its primary structure comprises database 10, a plurality of informants 20 and one can enter online server 30 by network for consumer 40, wherein store each informant's 20 master data (as company's master data and commodity data etc.) in this database 10, server 30 supports that then one is arranged at the normal operation of the online publish information 31 on the network 50 (can be the Internet), wherein this online publish information 31 can be by the heterogeneous networks pattern (as WWW, GOPHER or BBS isotype) form demonstration, and the publish data of online publish information 31 is corresponding to the data of database 10 inside.
Shown in Fig. 2,3, the control and treatment of the demonstration of online publish information 31 wherein of the present invention and database 10 data, be to finish by following two kinds of patterns, at first as shown in Figure 2, the commodity (comprising tangible commodity or invisible service) that 20 pairs of databases 10 of informant are write down, carry out setting and the modification of commodity amount, date of expiration, time, and influence the control flow of server 30, concrete steps are as follows:
Steps A. the informant provides data to database:, by network commodity data is sent to database 10 by informant 20;
Whether the incremental data value in the step B. judgment data storehouse need be revised: after commodity data that informant 20 sends out becomes incremental data value in the database, promptly come determining step C whether to revise this incremental data value by system with this step; Because general informant 20 is when providing business service, if during the no datat condition restriction, be the incremental data value then, and judge comparison through system with unlimited amount initial in the database, when being quantity maximum value as commodity amount, skips steps C and directly carry out flow process to step D then; And when if informant 20 input data limit are arranged, then entering step C again carries out the commodity amount data value and revises;
Step C. revises the incremental data value of database: when system after above-mentioned judgement, then interior initial incremental data value is greatly carried out quantity modification alter operation by this step;
Whether the date in the step D. judgment data storehouse, time data value need to revise: after commodity data that informant 20 proposes is by database date of formation, time data value, promptly come determining step E whether to revise this date, time data value by system with this step; And design date, the meaning of time data value, mainly be applicable to the commodity of intersexuality sometimes, as air ticket, steamer ticket, the commodity of travel party or the food that eats in limited time and the intersexuality restrictions sometimes such as auction goods of prescribing a time limit, so in system design, also with the date, the time data value is as controlling element of the present invention, because general informant 20 is when providing business service, if it is undated, during the time conditions restriction, it is the date then with day in indefinite duration initial in the database, the time data value, then the modification of step e is not made by system, and directly enter the flow process of step F, and if the date is arranged, during the condition restriction of time, then enter step e and carry out the time zone date that the area is carried out in commodity transaction, the modification of time data value;
Step e. revise date, the time data value of database: when system after above-mentioned judgement, with initial indefinite date, time data value, carry out regional time zone date, time at commodity transaction, by this step to it change of making amendment;
Step F. the rational affirmation of data: rational affirmation action is carried out in abovementioned steps judgement and modification data, if the rationality of data is errorless, then enter step G, and if the rationality of data is wrong, then return to steps A and follow flow process again by informant 20 and confirm to revise;
The online publish information of step G.: with the commodity data that above-mentioned steps is built up, directly be shown on the online publish information 31 of server 30, browse reference for the consumer with this.
In addition, and for example shown in Fig. 1,3, be 40 of database 10, server 30 and consumers, conclude the business or the control flow of online publish information is handled in quantitative check, wherein:
Step 1 or step 1-1. conclude the business or quantitative check: select online publish information 31 listed commodity to conclude the business by consumer 40, check comparison voluntarily by system, system's compare operation that also regularly conducts a survey;
Whether step 3. relatively quantity has added up to surpass the quantity setting: whether the systems inspection number of transaction has added up to surpass the effective quantity in the database, if system judges that answer is a "Yes", then carrying out following steps 4, to be controlled to be data invalid, if number of transaction does not surpass effective quantity, it judges that answer is a "No", flow process continues execution in step 1 provides other consumer 40 to conclude the business, and accumulative total judgment mode that wherein should supply quantity can utilize to increase progressively addition or the method for the back-off that successively decreases is reached accumulating function;
Step 4. data are invalid: by above-mentioned steps 2 relatively dates, time whether in data date of expiration, time, and step 3 relatively quantity whether added up to surpass quantity and set two when judging important documents, if step 2 answer is a "No", then the time point of expression transaction has surpassed date of expiration, time, or the commodity amount in step 3 database is when adding up to the quantity of setting, as long as meet above-mentioned both one of, it is invalid and enter step 5 that system all can be judged as data;
And system is after deleting online publish information 31, and can enter step 5-1 announcement information supplier 20 its commodity that provide simultaneously above date of expiration, time or sale fully, informant 20 can be known grasp the business opportunity situation, do to handle the most fast.
In addition, equally as shown in Figure 3, in the system wherein of the present invention, also utilize " quantitative check " step to control the content of online publish information, wherein the quantitative check step shown in the step 1-1 of Fig. 3 was activated by one set time of default, and after the present invention activates step 1-1 " quantitative check " function, then enter as above-mentioned step 2 relatively time point whether in data date of expiration, in time, step 3 relatively quantity whether in the effective quantity of data, and carry out the comparison time point of existing goods and the inspection of comparison quantity successively, make the present invention except can in transaction, checking with this, have more the regularly effect of self-examination, reach and make the present invention announce Transaction Information on the net, normal guarantor automatically controlled, the deletion invalid data, and with correct and active data, announce on the net by network that dynamically it is dynamically correct to make database 10 of the present invention reach normal guarantor, the purpose of validity.
As Fig. 1, shown in 4, the commodity control flow of the online publish information 31 of the present invention wherein, also can adjust different examples according to need, wherein as some specific commodity, as air ticket, professional commodity such as steamer ticket or tourist service, it is concluded the business date of expiration, time must include the pre action time (as producing day after transaction, travelling is set out day, delivery day ... etc. information, the build file date, the date of expiration that time increase and decrease fate calculates, time), directly file the date according to need, time, so the present invention is on practice, need to cooperate detection control type with database 10, except being data date of expiration originally, outside the control important document of time, the control type that adds one " concluding the business date of expiration; the time " in addition, and data date of expiration wherein, time is meant the effective final time of data, and " transaction date of expiration; the time " refer to that then informant 20 is after transaction, designed pre-set time of data manipulation time before including, so its data date of expiration, time must be to be later than or to equal the date of expiration of concluding the business, time, and if data date of expiration, time equals the date of expiration of concluding the business, time, then be equivalent to flow process shown in Figure 3, so desire to make above-mentioned two kinds of situations to exist simultaneously, this flow process adds the date of expiration of concluding the business again, time is not equal to data date of expiration, the control type of time, with more extensive commercialization, and its transaction control flow is as follows:
Step 1 or step 1-1. conclude the business or make regular check on: select online publish information 31 listed commodity to conclude the business by consumer 40, check comparison voluntarily by system, the inspection compare operation is also regularly done by system;
Step 2-1. relatively time point whether in transaction date of expiration, time: the time point of consumer's 40 transaction or systems inspection transaction date of expiration, the time with informant's 20 settings is compared, if this compares time point in conclude the business date of expiration, time, then flow process is carried out step 3 operation, and relatively time point has exceeded date of expiration, the time of concluding the business, then flow process enters step 2-2 and " stops to provide transaction ", but flow process still can be back to step 1 is inquired about these commodity for other consumer 40 by online publish information previous transaction situation.
Whether step 3. relatively quantity has added up to surpass the quantity setting: the systems inspection number of transaction, whether added up to surpass the effective quantity in the database, if system judges that answer is a "Yes", then carry out following steps 3-1 row judgement again, if the accumulated quantity of transaction does not surpass effective quantity, it judges that the formula answer is a "No", flow process continues execution in step 1 provides other consumer 40 to conclude the business, and accumulative total judgment mode that wherein should supply quantity is can utilize to increase progressively addition or the method for the back-off that successively decreases is reached accumulating function;
Step 3-1. relatively concludes the business date of expiration, whether the time equals data date of expiration, time: when the date of expiration of concluding the business is judged by system, time equals data date of expiration, during the time, be illustrated in the setting that there is no the lead time on this commodity process settings, so its result can be identical with the judgement of Fig. 3, make flow process enter the invalid program of step 4 declaration data, and if conclude the business date of expiration, time is not equal to data date of expiration, during the time, represent that then these commodity are set with the pre action time, then flow process enters step 3-2 and stops to provide transaction, but flow process still can return back to step 1 is inquired about these commodity for other consumer 40 by the information of online announcement previous transaction situation.
Step 4. data are invalid: during by above-mentioned steps 2 " relatively whether date, time be in data date of expiration, time " and step 3-1 " whether the date of expiration of relatively concluding the business, time equal data date of expiration, time " two control important documents, if step 2 answer is a "No", represent then that exchange hour point has surpassed and ask data date of expiration, time, or the answer of step 3-1 is when equaling data date of expiration, time for the date of expiration of relatively concluding the business, time, as long as meet above-mentioned both one of situation the time, system all can be judged as step 4 " data are invalid " and enter step 5;
Claims (9)
1. the method for the automatic control and treatment data of database, it is implemented need use at least database and can enter online server for consumer's mat network, server wherein can be the consumer and shows online publish information, it is characterized in that the control flow of online publish information data be may further comprise the steps:
A. transaction or inspection step are used to conclude the business or quantitative check;
B. the time point determining step in data date of expiration, time whether relatively is used for judging relatively time point whether in data date of expiration, time, if, then carry out next step, if not, then jump move into data invalid;
C. relatively whether quantity adds up to surpass the determining step of effective quantity, is used to judge whether the accumulative total of comparison number of transaction surpasses effective quantity of database, if it is invalid then to be judged as data, then flow process makes this data continuous business if not;
D. delete online publish information and announcement information supplier's step; Be used for judging after " data are invalid ", then directly enter online publish information this data presentation state deletion in flow process, and simultaneously to informant's output information.
2. the method for the automatic control and treatment data of database as claimed in claim 1 is characterized in that wherein the data of database and informant provide and confirms that flow process may further comprise the steps
A. the informant sends data to the step of database, is used for providing data by the informant;
B. the step of database built-in " incremental data value " is used for after the informant proposes commodity data, is revised for built-in initial value or according to the quantitative value that the supplier sets by system's judgement " incremental data value ";
C. database built-in " date, time data value " step, be used for after the informant proposes commodity data, judge that by system " date, time data value " make amendment for built-in initial value or the date that sets according to the informant, time value;
D. online publish information step is used for the data publish information demonstration on the net of will set up via above-mentioned steps, consults selection for the user.
3. the method for the automatic control and treatment data of database as claimed in claim 2, it is characterized in that: before entering online publish information step, can add data and rationally confirm step, supply flow process at previous time data value and the incremental data value that increases newly or revise, carry out the rational affirmation of data, if the data rationality is true.Then just enter online publish information, and, then return back to the informant and require to confirm corrective action if the data rationality is wrong.
4. the method for the automatic control and treatment data of database as claimed in claim 2, the initial value that it is characterized in that described " incremental data value " is the maximum value of unlimited amount.
5. the method for the automatic control and treatment data of database as claimed in claim 2 is characterized in that the initial value of described " date, time data value " is indefinite maximum value.
6. the method for the automatic control and treatment data of database as claimed in claim 1 or 2, " date, time data value ", " transaction date of expiration, time " that it is characterized in that database reaches the judgement of " data date of expiration, time ", and (Internet Time) is the time conversion unit with the Internet time.
7. the method for the automatic control and treatment data of database as claimed in claim 1 is characterized in that " relatively time point whether the determining step in data date of expiration, time " reach between " relatively quantity whether add up to surpass effective quantity determining step " and can increase " relatively exchange hour point is whether above the determining step of conclude the business date of expiration, time ".
8. as the method for claim 1 or the automatic control and treatment data of 7 described databases, it is characterized in that " concluding the business date of expiration; the time " in " relatively whether time point surpasses the date of expiration of concluding the business; the determining step of time " set up on their own by data set provider, and will conclude the business or supervision time point compared with " transaction date of expiration; time " by flow process, if this compares time point in " concluding the business date of expiration; the time ", then flow process enters " relatively whether quantity adds up the determining step above effective quantity ", if relatively time point exceeds " concluding the business date of expiration; the time ", then flow process enters " stopping to provide transaction " program, makes these data shut the book.
9. as the method for claim 1 or the automatic control and treatment data of 7 described databases, it is characterized in that " relatively whether quantity adds up the determining step above effective quantity " is before judgment data is invalid, can whether equal earlier " data date of expiration; time " judges " relatively concluding the business date of expiration; the time ", " transaction date of expiration; time " equals " data date of expiration; time " if judge, then flow process enters the invalid program of data, delete online publish information and inform data set provider, " transaction date of expiration; time " is not equal to " data date of expiration; time " if judge, then flow process enters " stopping to provide transaction " program, makes these data shut the book.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 00121649 CN1130655C (en) | 2000-07-21 | 2000-07-21 | Autocontrol method for processing data in database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 00121649 CN1130655C (en) | 2000-07-21 | 2000-07-21 | Autocontrol method for processing data in database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1334528A true CN1334528A (en) | 2002-02-06 |
| CN1130655C CN1130655C (en) | 2003-12-10 |
Family
ID=4588909
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 00121649 Expired - Fee Related CN1130655C (en) | 2000-07-21 | 2000-07-21 | Autocontrol method for processing data in database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1130655C (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100343846C (en) * | 2003-09-28 | 2007-10-17 | 华为技术有限公司 | Analytical comparison method for divergence between data |
-
2000
- 2000-07-21 CN CN 00121649 patent/CN1130655C/en not_active Expired - Fee Related
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100343846C (en) * | 2003-09-28 | 2007-10-17 | 华为技术有限公司 | Analytical comparison method for divergence between data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1130655C (en) | 2003-12-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9152941B2 (en) | Systems and methods for automated parallelization of back-order processing | |
| AU2010202163B2 (en) | System and method for top-down performance optimization using elasticity modeling | |
| US7730022B2 (en) | Data processing system and method for supply chain management | |
| US8032552B2 (en) | Virtual private supply chain | |
| Van Batenburg et al. | PseudoBase: structural information on RNA pseudoknots | |
| US7702615B1 (en) | Creation and aggregation of predicted data | |
| US8140490B2 (en) | Method, system and program for prioritizing maintenance of database tables | |
| US20130246107A1 (en) | Method and Device for Assigning Surplus Slabs in the Slab Yard before Hot Rolling Process | |
| US20100235398A1 (en) | Methods, systems, and software applications for event based data processing | |
| Kornish et al. | Repeated commit-or-defer decisions with a deadline: The influenza vaccine composition | |
| CN101127102A (en) | Contracted life cycle supervision system and method | |
| EP1793334A1 (en) | Re-optimization technique for use with an automated supply chain optimizer | |
| US9292405B2 (en) | HANA based multiple scenario simulation enabling automated decision making for complex business processes | |
| US7289990B2 (en) | Method and apparatus for reducing index sizes and increasing performance of non-relational databases | |
| CN101042750A (en) | Available resource management system and available resource management method | |
| CN112163812A (en) | Warehousing system and management mode based on tree channel inventory management | |
| CN109086339B (en) | Data processing method and device for generating index recombination rate | |
| CN1130655C (en) | Autocontrol method for processing data in database | |
| US8396762B2 (en) | Systems and methods for validating subsititution chains of an order | |
| CN101076027A (en) | Method and system for transporting data between MIME accessory and corresponding database | |
| Wang et al. | Price heuristics for highly efficient profit optimization of service composition | |
| EP2112608A1 (en) | Defragmenting indexes in a relational database | |
| CN115564347A (en) | Purchase list generation method and system, computer equipment and readable storage medium | |
| CN111126899B (en) | Automatic processing method and device for arbitration delay and computer equipment | |
| US7752100B1 (en) | Selector function for life-time value financial processing in a relational database management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C06 | Publication | ||
| PB01 | Publication | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20031210 Termination date: 20150721 |
|
| EXPY | Termination of patent right or utility model |