Summary of the invention
In view of the above problems, the present invention is proposed to provide a kind of overcoming date storage method in the problems referred to above or the electronics bid evaluation system that solves the problem at least in part and device.
According to one aspect of the present invention, provide the date storage method in a kind of electronics bid evaluation system, comprising: receive the bid data uploaded, and be saved in master data base; Judge whether the data volume in master data base reaches preset value; When reaching preset value, create historical data base; Partial data in master data base is moved in historical data base.
Alternatively, described establishment historical data base comprises: in disk, newdata storehouse is as historical data base; Default list structure is imported in described historical data base.
Alternatively, describedly partial data in master data base is moved to historical data base comprise: according to the migration plan in configuration file, the partial data in master data base is moved in historical data base; The title of described migration plan, execution time and fill order is stored in described configuration file.
Alternatively, describedly partial data in master data base is moved to historical data base comprise: judge whether there is transportable historical data base; If there is no, then this data migration operation is terminated; If existed, then in master data base, querying attributes is the bid data that the assessment of bids terminates, and obtains the name identifiers GUID of described bid data; Obtain all tables of data comprising this GUID in master data base, by all data Replicas in described tables of data in described historical data base, and after having copied, delete data corresponding in master data base.
Alternatively, the method comprises further: after the partial data in master data base moves to historical data base, the storage information of corresponding this partial data of amendment in question blank, and obtains the concatenation character string corresponding with this partial data; When performing querying command, if the data of inquiry are stored in described historical data base, according to described concatenation character string amendment querying command.
According to another aspect of the present invention, providing the data storage device in a kind of electronics bid evaluation system, comprising: receiving element, for receiving the bid data uploaded, and being saved in master data base; Historical data base creating unit, for judging whether the data volume in master data base reaches preset value; When reaching preset value, create historical data base; Data migration unit, for moving to the partial data in master data base in historical data base.
Alternatively, described historical data base creating unit, for newdata storehouse in disk as historical data base; Default list structure is imported in described historical data base.
Alternatively, described data migration unit, for according to the migration plan in configuration file, moves in historical data base by the partial data in master data base; The title of described migration plan, execution time and fill order is stored in described configuration file.
Alternatively, there is transportable historical data base for judging whether in described data migration unit; If there is no, then this data migration operation is terminated; If existed, then in master data base, querying attributes is the bid data that the assessment of bids terminates, and obtains the name identifiers GUID of described bid data; Obtain all tables of data comprising this GUID in master data base, by all data Replicas in described tables of data in described historical data base, and after having copied, delete data corresponding in master data base.
Alternatively, this device comprises further: query unit, after moving to historical data base for the partial data in master data base, and the storage information of corresponding this partial data of amendment in question blank, and obtain the concatenation character string corresponding with this partial data; When performing querying command, if the data of inquiry are stored in described historical data base, according to described concatenation character string amendment querying command.
From the above, technical scheme of the present invention, the bid data uploaded received are saved in master data base, and judge whether the data volume in master data base reaches preset value, when reaching preset value, illustrate and continue in master data base, store the performance that data can reduce master data base, therefore create historical data base, the partial data in master data base is moved in historical data base.This technical scheme efficiently solves when storing data volume in master data base and being too much, the operating efficiency of data progressively reduces, even carrying out the problem occurring stuck phenomenon in complicated data handling procedure, there is the integrality that both ensure that bid data, greatly improve again the beneficial effect of electronics bid evaluation system efficiency, provide convenience for judging panel carries out the electronics assessment of bids.
Above-mentioned explanation is only the general introduction of technical solution of the present invention, in order to technological means of the present invention can be better understood, and can be implemented according to the content of instructions, and can become apparent, below especially exemplified by the specific embodiment of the present invention to allow above and other objects of the present invention, feature and advantage.
Embodiment
Below with reference to accompanying drawings exemplary embodiment of the present disclosure is described in more detail.Although show exemplary embodiment of the present disclosure in accompanying drawing, however should be appreciated that can realize the disclosure in a variety of manners and not should limit by the embodiment set forth here.On the contrary, provide these embodiments to be in order to more thoroughly the disclosure can be understood, and complete for the scope of the present disclosure can be conveyed to those skilled in the art.
Fig. 1 shows the process flow diagram of the date storage method in a kind of according to an embodiment of the invention electronics bid evaluation system, and as shown in Figure 1, the method comprises:
Step S110, receives the bid data uploaded, and is saved in master data base.
Step S120, judges whether the data volume in master data base reaches preset value.Such as, due to when the data volume in database reaches about 100G, will cause the operating efficiency of data in database more and more lower, so preset value can be set to 100G.
Step S130, when reaching preset value, creates historical data base.
Step S140, moves to the partial data in master data base in historical data base.
Visible, method shown in Fig. 1, the bid data uploaded received are saved in master data base, and judge whether the data volume in master data base reaches preset value, when reaching preset value, illustrate and continue in master data base, store the performance that data can reduce master data base, therefore create historical data base, the partial data in master data base is moved in historical data base.This technical scheme efficiently solves when storing data volume in master data base and being too much, the operating efficiency of data progressively reduces, even carrying out the problem occurring stuck phenomenon in complicated data handling procedure, there is the integrality that both ensure that bid data, greatly improve again the beneficial effect of electronics bid evaluation system efficiency, provide convenience for judging panel carries out the electronics assessment of bids.
In one embodiment of the invention, in the method shown in Fig. 1, create historical data base and comprise: newdata storehouse is as historical data base in disk; Default list structure is imported in historical data base.Such as, Fig. 2 shows the interface schematic diagram of the establishment historical data base according to a specific embodiment of the present invention.As shown in Figure 2, in the process creating historical data base, not only to perform routine operation as setting data library name, database server address, set up user name, password etc., also need concrete memory location, setting data storehouse, and import list structure in this database.List structure is exactly the basic attribute such as field, type, major key, external key, index of definition one table, because newdata storehouse does not comprise list structure, directly can not import the data of master data base, therefore default list structure is imported in newdata storehouse the data making it directly can import master data base, thus use as historical data base.
In one embodiment of the invention, in the method shown in Fig. 1, the partial data in master data base is moved to historical data base and comprises: according to the migration plan in configuration file, the partial data in master data base is moved in historical data base; The title of migration plan, execution time and fill order is stored in configuration file.Such as, Fig. 3-a, Fig. 3-b, Fig. 3-c and Fig. 3-d respectively illustrate the interface schematic diagram carrying out Data Migration according to the establishment configuration file of a specific embodiment of the present invention.As shown in the figure, maintenance plan (Fig. 3-a) can be set up in conventional database management language is as SQLServer, define the title (Fig. 3-b) of this maintenance plan, the execution time (Fig. 3-c) of this maintenance plan is set, and the order that this maintenance plan will perform (Fig. 3-d).In concrete enforcement, can set as required and regularly or irregularly automatically safeguard at one's leisure, also can be set to manual maintenance.
Fig. 4 shows the process flow diagram of the date storage method in another electronics bid evaluation system according to an embodiment of the invention.As shown in Figure 4, in said method, the partial data in master data base is moved to historical data base and comprises:
Step S410, judges whether there is transportable historical data base.Capacity due to a newly-established historical data base is very large, is not therefore all will set up new historical data base when each execution data migration operation.
Step S420, if there is no, then terminates this data migration operation.Such as, create historical data base failure, or existing historical data base denied access etc.In specific implementation process, the quantitative limitation of storage data can be carried out to historical data base, refuse new Data Migration when the data of existing historical data library storage reach preset value in this historical data base.
Step S430, if existed, then in master data base, querying attributes is the bid data that the assessment of bids terminates, and obtains the name identifiers GUID of bid data.
In electronics bid evaluation system, even the bid data that the assessment of bids terminates still have it to be worth, need to be retained, therefore can not be deleted.And the assessment of bids unclosed bid data also need repeatedly to call in ensuing assessment of bids process, need to be deposited in master data base.Therefore, the data can carrying out Data Migration are preferably the bid data that the assessment of bids terminates.But for a bid section, the bid data produced about this bid section need to carry out unified management to it, and therefore, need the name identifiers GUID obtaining these bid data, namely which bid section is these bid data belong to, thus can continue to perform next step.
Step S440, obtains all tables of data comprising this GUID in master data base, by all data Replicas in tables of data in historical data base, and after having copied, deletes data corresponding in master data base.Like this, just ensure that all bid data of the bid section that assessment of bids can be terminated all move in historical data base.
In concrete enforcement, above-mentioned steps may produce many process datas, and these data need to delete after Data Migration terminates.
In one embodiment of the invention, said method comprises further: after the partial data in master data base moves to historical data base, the storage information of corresponding this partial data of amendment in question blank, and obtains the concatenation character string corresponding with this partial data; When performing querying command, if the data of inquiry are stored in historical data base, according to concatenation character string amendment querying command.
Particularly, the field name of the database that bid data store can be changed in question blank, be namely revised as the historical data base after Data Migration from master data base.Because when carrying out query manipulation, the data of these historical data bases of having moved cannot be inquired from master data base, for solving this problem, the present embodiment have employed the storage information of this partial data of amendment in question blank and obtains the mode of the concatenation character string corresponding with this partial data, this concatenation character string can reorientate the store path of this partial data, thus when performing querying command, if the data of inquiry are stored in historical data base, first inquire about again, in order to avoid there is the non-existent situation of feedback data according to concatenation character string amendment querying command.
Fig. 5 shows the structural representation of the data storage device in a kind of according to an embodiment of the invention electronics bid evaluation system, and as shown in Figure 5, the data storage device 500 in electronics bid evaluation system comprises:
Receiving element 510, for receiving the bid data uploaded, and is saved in master data base.
Historical data base creating unit 520, for judging whether the data volume in master data base reaches preset value; When reaching preset value, create historical data base.
Data migration unit 530, for moving to the partial data in master data base in historical data base.
Visible, device shown in Fig. 5, the bid data uploaded received are saved in master data base, and judge whether the data volume in master data base reaches preset value, when reaching preset value, illustrate and continue in master data base, store the performance that data can reduce master data base, therefore create historical data base, the partial data in master data base is moved in historical data base.This technical scheme efficiently solves when storing data volume in master data base and being too much, the operating efficiency of data progressively reduces, even carrying out the problem occurring stuck phenomenon in complicated data handling procedure, there is the integrality that both ensure that bid data, greatly improve again the beneficial effect of electronics bid evaluation system efficiency, provide convenience for judging panel carries out the electronics assessment of bids.
In one embodiment of the invention, in the device shown in Fig. 5, historical data base creating unit 520, for newdata storehouse in disk as historical data base; Default list structure is imported in historical data base.
In one embodiment of the invention, in the device shown in Fig. 5, data migration unit 530, for according to the migration plan in configuration file, moves in historical data base by the partial data in master data base; The title of migration plan, execution time and fill order is stored in configuration file.
In one embodiment of the invention, in said apparatus, there is transportable historical data base for judging whether in data migration unit 530; If there is no, then this data migration operation is terminated; If existed, then in master data base, querying attributes is the bid section data that the assessment of bids terminates, and determines all bid section titles needing migration; According to bid section title, obtain the name identifiers GUID of bid section, comprise all data Replicas in the tables of data of this GUID in historical data base by all in master data base, and after having copied, delete data corresponding in master data base.
In one embodiment of the invention, said apparatus comprises further: query unit, after moving to historical data base for the partial data in master data base, the storage information of corresponding this partial data of amendment in question blank, and obtain the concatenation character string corresponding with this partial data; When performing querying command, if the data of inquiry are stored in historical data base, according to concatenation character string amendment querying command.
It should be noted that, the embodiment of above-mentioned each device embodiment is identical with the embodiment of aforementioned each corresponding method embodiment, does not repeat them here.
In sum, date storage method in the electronics bid evaluation system that technical solution of the present invention provides and device, the bid data uploaded received are saved in master data base, and judge whether the data volume in master data base reaches preset value, when reaching preset value, illustrate and continue in master data base, store the performance that data can reduce master data base, therefore create historical data base, the partial data in master data base is moved in historical data base.After solving Data Migration, carry out data query possibility produced problem, also for have employed the modes such as the storage information of this partial data of amendment in question blank in order to avoid there is the non-existent situation of feedback data.This technical scheme efficiently solves when storing data volume in master data base and being too much, the operating efficiency of data progressively reduces, even carrying out the problem occurring stuck phenomenon in complicated data handling procedure, there is the integrality that both ensure that bid data, greatly improve again the beneficial effect of electronics bid evaluation system efficiency, provide convenience for judging panel carries out the electronics assessment of bids.Further, this technical scheme for the bid data mining Data Migration program of different bid section, need not have suitability, ensure that the maximization of master data base operational efficiency.
The foregoing is only preferred embodiment of the present invention, be not intended to limit protection scope of the present invention.All any amendments done within the spirit and principles in the present invention, equivalent replacement, improvement etc., be all included in protection scope of the present invention.
It should be noted that:
Intrinsic not relevant to any certain computer, virtual bench or miscellaneous equipment with display at this algorithm provided.Various fexible unit also can with use based on together with this teaching.According to description above, the structure constructed required by this kind of device is apparent.In addition, the present invention is not also for any certain programmed language.It should be understood that and various programming language can be utilized to realize content of the present invention described here, and the description done language-specific is above to disclose preferred forms of the present invention.
In instructions provided herein, describe a large amount of detail.But can understand, embodiments of the invention can be put into practice when not having these details.In some instances, be not shown specifically known method, structure and technology, so that not fuzzy understanding of this description.
Similarly, be to be understood that, in order to simplify the disclosure and to help to understand in each inventive aspect one or more, in the description above to exemplary embodiment of the present invention, each feature of the present invention is grouped together in single embodiment, figure or the description to it sometimes.But, the method for the disclosure should be construed to the following intention of reflection: namely the present invention for required protection requires feature more more than the feature clearly recorded in each claim.Or rather, as claims below reflect, all features of disclosed single embodiment before inventive aspect is to be less than.Therefore, the claims following embodiment are incorporated to this embodiment thus clearly, and wherein each claim itself is as independent embodiment of the present invention.
Those skilled in the art are appreciated that and adaptively can change the module in the equipment in embodiment and they are arranged in one or more equipment different from this embodiment.Module in embodiment or unit or assembly can be combined into a module or unit or assembly, and multiple submodule or subelement or sub-component can be put them in addition.Except at least some in such feature and/or process or unit be mutually repel except, any combination can be adopted to combine all processes of all features disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) and so disclosed any method or equipment or unit.Unless expressly stated otherwise, each feature disclosed in this instructions (comprising adjoint claim, summary and accompanying drawing) can by providing identical, alternative features that is equivalent or similar object replaces.
In addition, those skilled in the art can understand, although embodiments more described herein to comprise in other embodiment some included feature instead of further feature, the combination of the feature of different embodiment means and to be within scope of the present invention and to form different embodiments.Such as, in the following claims, the one of any of embodiment required for protection can use with arbitrary array mode.
All parts embodiment of the present invention with hardware implementing, or can realize with the software module run on one or more processor, or realizes with their combination.It will be understood by those of skill in the art that the some or all functions that microprocessor or digital signal processor (DSP) can be used in practice to realize according to the some or all parts in the data storage device in the electronics bid evaluation system of the embodiment of the present invention.The present invention can also be embodied as part or all equipment for performing method as described herein or device program (such as, computer program and computer program).Realizing program of the present invention and can store on a computer-readable medium like this, or the form of one or more signal can be had.Such signal can be downloaded from internet website and obtain, or provides on carrier signal, or provides with any other form.
The present invention will be described instead of limit the invention to it should be noted above-described embodiment, and those skilled in the art can design alternative embodiment when not departing from the scope of claims.In the claims, any reference symbol between bracket should be configured to limitations on claims.Word " comprises " not to be got rid of existence and does not arrange element in the claims or step.Word "a" or "an" before being positioned at element is not got rid of and be there is multiple such element.The present invention can by means of including the hardware of some different elements and realizing by means of the computing machine of suitably programming.In the unit claim listing some devices, several in these devices can be carry out imbody by same hardware branch.Word first, second and third-class use do not represent any order.Can be title by these word explanations.