CN105677685A - Database system and method for saving and querying data in database system - Google Patents
Database system and method for saving and querying data in database system Download PDFInfo
- Publication number
- CN105677685A CN105677685A CN201410675547.1A CN201410675547A CN105677685A CN 105677685 A CN105677685 A CN 105677685A CN 201410675547 A CN201410675547 A CN 201410675547A CN 105677685 A CN105677685 A CN 105677685A
- Authority
- CN
- China
- Prior art keywords
- data
- filing
- sub
- unit
- data storehouse
- 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.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database system applied to a semiconductor production system comprising a production database and a data recording module. By configuring a filing database comprising multiple sub filing databases, the database system is used for backup of historical data saved in the production database within the pre-set time interval. Data within the above time interval recorded by the data recording module is independently saved in each sub filing database so that maintenance cost of the production database is lowered and performance of the production database is improved. Furthermore, the invention further discloses database system and method for saving and querying data in the database system. By means of a switching module, automatic switch of all sub filing databases can be achieved. Through a switch unit, switch results of the sub filing databases can be timely fed back to a user's unit so that historical data can be conveniently queried out of the filing database by a user. Therefore, waste of manpower resources is reduced.
Description
Technical field
The present invention relates to technical field of manufacturing semiconductors, particularly relate to a kind of Database Systems and the method storing in Database Systems and inquiring about data.
Background technology
The manufacturing of IC chip is an extremely complex process, and every wafer completes from entering factory to final production, will through thousands of procedures up to a hundred, and every one procedure all can produce substantial amounts of data. In process of production, if it find that product has any exception, it is necessary to the historical data in quick search production, mistake in producing is corrected, it is ensured that product quality. After product completes production, historical data still can be inquired about by user according to the requirement of client, if encountered problems in actual production, also may require that enquiry of historical data carries out reference. On the one hand, over time with the growth of yield, the creation data that semiconductor producing system retains will become more and more, and Production database (Database is called for short DB) can reach trillion (Trillionbyte is called for short TB) rank. And data base is more big, user inquires about the performance of data and also can reduce, and the time solving problem will be more long, and user satisfaction will reduce. And the more big maintenance cost of Production database is also more big, storage and resource backup demand are also just more and more.
At present, only user needs to refer to product before historical data is understood and runs goods situation, or just can inquire about the historical data before half a year when client has other to need, so the historical data only retained on semiconductor producing system in half a year, historical data before half a year generally backs up on tape, is stored in the medium-term and long-term preservation of magnetic-tape filing cabinet. So, if user needs enquiry of historical data, it is accomplished by proposing in systems request for recovery data, then the tape of backup can be taken machine room by data base administrator from magnetic-tape filing cabinet, data are recovered, the recovery needing time-consuming 2-3 days just can complete data, it is impossible to meet the demand of user timely and effectively.
Summary of the invention
For above-mentioned Problems existing, a kind of Database Systems of disclosure and the method for storage and inquiry data in Database Systems, safeguard the cost of Production database to reduce, improve the performance of Production database, and facilitate user's inquiry to historical data.
To achieve these goals, this invention describes a kind of Database Systems, be applied to include on the semiconductor producing system of Production database and data recordin module, described Database Systems include filing data storehouse, enquiry module and a server;
All data that semiconductor producing system described in described data recordin module record produces when carrying out production technology in real time, and the data of record sent to described Production database, and this Production database is stored in the data that in current time time data memory section in the past, described data recordin module sends;
Described Production database also every one interval time section all will back up in described filing data storehouse in its stored all data in this section interval time, described enquiry module reads the data of storage in described filing data storehouse and/or described Production database by described server;
Described filing data storehouse includes some sub-filing data storehouses, and in each described sub-filing data storehouse, all storage has the data of described data recordin module record in section interval time described in one;
Wherein, according to process requirements set described time data memory section and described interval time section value.
Above-mentioned Database Systems, wherein, described server includes a handover module;
When described enquiry module needs the data inquiring about storage in described filing data storehouse, described server is switched to corresponding sub-filing data storehouse by data base's switching command that described handover module sends according to described enquiry module, so that described enquiry module can read the data of storage in its required sub-filing data storehouse by described server.
Above-mentioned Database Systems, wherein, described enquiry module includes subscriber unit and converting unit, described subscriber unit sends the handover request in sub-filing data storehouse according to query demand, after described converting unit is received and confirmed by described handover request, described handover request is converted to switching command and sends to described handover module;
Wherein, the switching result information in sub-filing data storehouse is fed back to described subscriber unit also by described converting unit by described handover module.
Above-mentioned Database Systems, wherein, described handover module includes: data base's closing unit, data base select unit and data base to open unit;
When described handover module receives described switching command, if described server there is currently the sub-filing data storehouse just opened, the switching command that described data base's closing unit sends according to described converting unit is closed when, behind the sub-filing data storehouse of front opening, described data base selects unit to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse;
Otherwise, described data base selects unit directly to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse.
Above-mentioned Database Systems, wherein, described handover module also includes a storage the Parameter File unit in path, all sub-filing data storehouses;
Described data base selects unit to transfer the path in the corresponding sub-filing data storehouse of storage in described Parameter File unit according to described switching command, and the path transmission in this sub-filing data storehouse is opened unit to described data base, described data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received.
Above-mentioned Database Systems, wherein, are additionally provided with the security module including ciphering unit and authentication unit in described server;
By described ciphering unit, secured account information and this secured account operating right to every sub-filing data storehouse that the data of storage in described filing data storehouse are operated by described enquiry module is set;
When described enquiry module inputs a secured account information, after described secured account is verified by described authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by described enquiry module according to the authority of this secured account.
Above-mentioned Database Systems, wherein, the database service title in each described sub-filing data storehouse in described filing data storehouse is all identical.
Above-mentioned Database Systems, wherein, the numerical value of described time data memory section is more than or equal to the numerical value of section described interval time.
The application has also stated that a kind of method of storage and inquiry data in Database Systems, is applied to semiconductor producing system, comprises the steps:
The all data produced in real time when described semiconductor producing system is carried out production technology send in a Production database each through a data recordin module, and this Production database is merely stored in the time data memory section before current time the data of data recordin module record;
According to default section interval time, the data stored in section in each interval time in described Production database are all backed up in a filing data storehouse, and the data backing up to described filing data storehouse each interval time in section are all stored separately in a sub-filing data storehouse;
Enquiry module sends the switching command in sub-filing data storehouse to a handover module according to query demand, server is switched to corresponding sub-filing data storehouse according to described switching command by this handover module, to realize the operation that the data of storage in corresponding sub-filing data storehouse are inquired about by described enquiry module;
Wherein, described time data memory section is more than or equal to the value of section described interval time.
Above-mentioned storage in Database Systems and the method for inquiry data, wherein, described enquiry module sends data base's switching command concretely comprising the following steps to a handover module according to query demand:
When needing the data stored in antithetical phrase filing data to carry out query manipulation, sent the handover request in sub-filing data storehouse to converting unit by a subscriber unit according to query demand, after the handover request received is confirmed by this converting unit, this handover request is converted to switching command and sends to described handover module;
Wherein, described subscriber unit and described converting unit may be contained within described enquiry module.
Above-mentioned storage in Database Systems and the method for inquiry data, wherein, switching result information is fed back to described subscriber unit also by described converting unit after carrying out above-mentioned sub-filing data storehouse handover operation by described handover module.
The above-mentioned method of storage and inquiry data in Database Systems, wherein, server is switched to concretely comprising the following steps of corresponding sub-filing data storehouse according to described switching command by described handover module:
When described handover module receives described switching command, if described server there is currently just opening one sub-filing data storehouse, the switching command that one data base's closing unit sends according to described converting unit is closed when, behind the sub-filing data storehouse of front opening, a data base selects unit to open unit according to described switching command by a data base and opens corresponding sub-filing data storehouse;
Otherwise, described data base selects unit directly to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse;
Wherein, described data base's closing unit, described data base select unit and described data base to open unit to may be contained within described handover module.
Above-mentioned storage in Database Systems and the method for inquiry data, wherein, described data base selects unit to transfer the path in the corresponding sub-filing data storehouse of storage in a Parameter File unit according to described switching command, and the path transmission in this sub-filing data storehouse is opened unit to described data base, described data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received;
Wherein, in described Parameter File unit, storage has the path in all sub-filing data storehouses, and described Parameter File unit is arranged in described handover module.
Above-mentioned storage in Database Systems and the method for inquiry data, wherein,
By a ciphering unit, secured account information and this secured account operating right to every sub-filing data storehouse that the data of storage in described filing data storehouse are operated by described enquiry module is set;
When described enquiry module inputs a secured account information, after described secured account is verified by described authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by described enquiry module according to the authority of this secured account;
Wherein, described ciphering unit and authentication unit are arranged in a security module, and described security module is arranged in described server.
Above-mentioned storage in Database Systems and the method for inquiry data, wherein, described enquiry module is to when in described filing data storehouse, the data of storage carry out query manipulation, and the database service title in the sub-filing data storehouse called is all identical.
Foregoing invention has the advantage that or beneficial effect:
In sum, the invention discloses a kind of Database Systems, it is applied to include on the semiconductor producing system of Production database and data recordin module, by arranging the filing data storehouse including some sub-filing data storehouses, for backing up the stored historical data of Production database in default interval time section, in every sub-filing data storehouse, all separate storage has the data of data recordin module record in an above-mentioned interval time section, and above-mentioned Production database is merely stored in the time data memory section before current time the data of data recordin module record, thus reducing the maintenance cost of Production database, improve the performance of Production database simultaneously. in addition, the invention also discloses the method for storage and inquiry data in Database Systems, the automatic switchover in each sub-filing data storehouse is realized by handover module, and by converting unit, the switching result information in sub-filing data storehouse is fed back to subscriber unit in time, thus facilitating user's enquiry of historical data from filing data storehouse, and then decrease the waste of human resources.
Concrete accompanying drawing explanation
By reading detailed description non-limiting example made with reference to the following drawings, the present invention and feature, profile and advantage will become more apparent. The part that labelling instruction identical in whole accompanying drawings is identical. Can not be drawn to scale accompanying drawing, it is preferred that emphasis is the purport of the present invention is shown.
Fig. 1 is the structural representation of Database Systems in the embodiment of the present invention;
Fig. 2 is the principle schematic that in the embodiment of the present invention, handover module carries out the switching of filing data storehouse;
Fig. 3 is the schematic flow sheet of the method storing and inquiring about data in the embodiment of the present invention in Database Systems.
Detailed description of the invention
Below in conjunction with accompanying drawing and specific embodiment, the present invention is further illustrated, but not as limiting to the invention.
Fig. 1 is the structural representation of Database Systems in the embodiment of the present invention, the present embodiment relates to a kind of Database Systems, it is applied to include on the semiconductor producing system of Production database and data recordin module, in above-mentioned semiconductor producing system such as Fig. 1 shown in dotted portion, including Production database and data recordin module, and this data recordin module is for recording all data produced in real time when semiconductor producing system carries out production technology, and the data of record are sent to Production database, the data of this data recordin module record refer to semiconductor producing system such as wafer sort data produced by the operation manufacturing IC chip, product information data and run the various data messages that the production technology such as goods situation is relevant to product, these Database Systems include filing data storehouse, enquiry module and a server, and this server includes handover module and security module.
Production database is stored in current time time data memory section in the past (such as 6 months, 10 months and 1 year etc. meet the value of the time data memory section that process requirements sets) data of interior data recordin module record, and this Production database is also by (such as 6 months in default interval time section, 10 months and 1 year etc. meet that process requirements sets interval time section value) the stored historical data of Production database backs up in filing data storehouse, Production database is only remained in the time data memory section before current time the data of data recordin module record after backup, wherein, the value of time data memory section is more than or equal to the value of section interval time, but according to concrete technology requirements set time data memory section and interval time section value, preferably, time data memory section and interval time section value be 6 months.
Enquiry module transfers, according to the demand of inquiry data, the data stored in filing data storehouse and/or Production database by server, in an embodiment of the present invention, if having only to the data of data recordin module record in the time data memory section before inquiry current time, have only to directly be transferred the data of storage in Production database by server, if desired outside the time data memory section before inquiry current time, the data of data recordin module record then require over server and transfer the historical data of storage in sub-filing data storehouse, in an embodiment of the present invention, enquiry module includes subscriber unit and converting unit (DBswitchwebsite), this subscriber unit sends the handover request in antithetical phrase filing data storehouse according to query demand, after converting unit is received and confirmed by handover request, handover request is converted to switching command and is sent to handover module, server is switched to corresponding sub-filing data storehouse by the switching command in the sub-filing data storehouse that handover module sends according to described enquiry module, so that enquiry module can read the data of storage in its required sub-filing data storehouse by described server, and switching result information is fed back to subscriber unit by above-mentioned converting unit by this handover module after having switched.
Above-mentioned filing data storehouse includes some sub-filing data storehouses, and all storage has the data of data recordin module record in an above-mentioned interval time section in every sub-filing data storehouse, and the mode of setting up in this filing data storehouse be on server/PC that same capacity is relatively big and extensibility is strong every above-mentioned interval time section set up a sub-filing data storehouse, and the data recordin module historical data that interval time records in section before setting up this sub-filing data storehouse is imported this sub-filing data storehouse, the sub-filing data storehouse that these are temporally set up constitutes above-mentioned filing data storehouse.
Preferably, the configuration of unit application program for the convenience of the user, some sub-filing data storehouses externally all use identical database service title (ServiceName), for instance, the database service title that some sub-filing data storehouses externally use is mes7arc.
Additionally, for convenience of the historical data of storage in subsequent calls filing data storehouse, according to naming rule set in advance, for instance some sub-filing data storehouses are named by time sequencing; As shown in Figure 1, to the sub-filing data storehouse 1 of called after, sub-filing data storehouse set up the earliest, the sub-filing data storehouse 2 of called after, sub-filing data storehouse set up afterwards, then the like, the sub-filing data storehouse of called after successively, the sub-filing data storehouse n, sub-filing data storehouse n+1 of follow-up foundation; In another embodiment of the present invention, the relation of title (DBname) with the time setting up this sub-filing data storehouse for showing sub-filing data storehouse more intuitively, can also adopt factory+time+form of sequence number names, such as, by being used for storing the sub-filing data storehouse called after fab704q2 of the historical data in fab7 factory first half of the year in 2004, will be used for storing the sub-filing data storehouse called after fab704q4 of the fab7 factory historical data second half year in 2004; The like, the sub-filing data storehouse called after fab708q2 of the fab7 factory historical data first half of the year in 2008 will be used for storing, the sub-filing data storehouse called after fab708q4 of the fab7 factory historical data second half year in 2008 will be used for storing; Certainly, sub-filing data storehouse can also adopt other naming rule, however it is not limited to above-mentioned naming method, as long as being easy to identify to the name in this sub-filing data storehouse.
Concrete, Fig. 2 is the principle schematic that in the embodiment of the present invention, handover module carries out the switching of filing data storehouse, as shown in Figure 2: above-mentioned handover module includes: data base's closing unit (DBshutdownmodule), Parameter File unit (DBparameterfile), data base select unit (DBswitchmodule) and data base to open unit (DBstartupmodule).
Wherein, when handover module receives the switching command that converting unit sends, if server there is currently the sub-filing data storehouse just opened, the switching command that data base's closing unit sends according to converting unit closes the sub-filing data storehouse (run after fame and be called the sub-filing data storehouse of fab710q2 in current sub-filing data storehouse in the present embodiment) when front opening, data base selects unit to transfer the path in the corresponding sub-filing data storehouse (run after fame and be called the sub-filing data storehouse of fab708q2 in corresponding sub-filing data storehouse in the present embodiment) of storage in above-mentioned parameter file unit according to this switching command afterwards, and the path transmission in this sub-filing data storehouse is opened unit to data base, data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received, in above-mentioned parameter file unit, storage has the parameter path in all sub-filing data storehouses.
After having switched, converting unit feeds back, to subscriber unit, the switching result information that handover module antithetical phrase filing data storehouse switches over, in converting unit, such as directly display switching result information, and/or adopt the mode of mail that switching result information is sent to subscriber unit, wherein, the content of the switching result information of feedback includes: when the IP address of the title in the target of front opening filing data storehouse, handover success or unsuccessful information and converting unit; Such as, by fab713q2; SuccessfullyswitchedMESarchiveDBfromfab710q2tofab713q2, the Mail Contents of operatorIPAddress:10.240.15.134 is sent to subscriber unit and informs to run after fame when the sub-filing data storehouse of front opening and be called the sub-filing data storehouse of fab713q2, from name, handover module success is called that the sub-filing data storehouse of fab710q2 switches to the sub-filing data storehouse that name is called fab713q2, and inform that the IP address operating machine sending mail is 10.240.15.134; If switching unsuccessful, after informing subscriber unit, data base administrator processed accordingly by data base administrator.
Concrete, above-mentioned security module includes ciphering unit and authentication unit; User by ciphering unit arrange enquiry module the data of storage in filing data storehouse are read out, inquire about, the secured account information of the operation such as duplication and this secured account operating right to every sub-filing data storehouse, when enquiry module inputs a secured account information, after this secured account information is verified by authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by enquiry module according to the authority of this secured account. In an embodiment of the present invention, user can pass through ciphering unit as required to every sub-filing data lab setting main account and inquiry account, and it is respectively provided with this main account and the authority of inquiry account, and by this main account of formal verification of login name and password and inquiry account, wherein, the authority of main account is more than the authority of inquiry account, such as, the operations such as all of data in corresponding sub-filing data storehouse can be configured, inquire about by main account, duplication, and inquire about account and only the data in this sub-filing data storehouse can be inquired about; When enquiry module reads the data of storage in arbitrary sub-filing data, all need to utilize authentication unit to be verified, enquiry module need to input corresponding login name and correct password could pass through checking specifically, and after only Authority Verification passes through, the data of storage in corresponding sub-filing data storehouse could be operated by enquiry module according to the authority of this secured account.
In the present embodiment, subscriber unit determines, according to the demand of inquiry data, the sub-filing data storehouse needing to open, send handover request and in converting unit, input login name and the password in this sub-filing data storehouse, and login name and password authentification is carried out by authentication unit, if the account name of input and password are correct, then being verified, the data of storage in this sub-filing data storehouse can be operated by enquiry module according to the authority that this login name is corresponding; Otherwise, if the account name of input and password bad, then checking cannot be passed through, and the data of storage in this sub-filing data storehouse cannot be operated by enquiry module. Preferably, the login name in each sub-filing data storehouse can use the title (DBname) in corresponding sub-filing data storehouse, to facilitate inquiry. And authority is set can increase the safety index in filing data storehouse, naturally it is also possible to set authority according to real needs, however it is not limited to the mode that authority is set of above-mentioned discussion.
In an embodiment of the present invention, concrete, converting unit demonstrates the database service title Mes7arc that each sub-filing data storehouse externally uses, when the sub-filing data storehouse of front opening is fab710q2, by above it will be appreciated that name is called in the sub-filing data storehouse of fab710q2 that the data of storage are the historical data that data recordin module records within the first half of the year in 2010, namely the historical data that semiconductor producing system produces within the first half of the year in 2010, if now subscriber unit needs the historical data in the inquiry first half of the year in 2008, therefore the sub-filing data storehouse opened is switched to the sub-filing data storehouse (now the title in the sub-filing data storehouse of this fab708q2 is the login name of its inquiry account authority) that name is called fab708q2 by request converting unit, then in converting unit, input correct password by (process that namely handover request is received and confirms by this process) after verifying, handover request to be converted to switching command and send to handover module, the handover operation in sub-filing data storehouse is carried out by handover module.
Fig. 3 is the schematic flow sheet of the method storing and inquiring about data in the embodiment of the present invention in Database Systems, and Fig. 2 is the principle schematic that in the embodiment of the present invention, handover module carries out the switching of filing data storehouse; As shown in Figures 2 and 3, the present embodiment relates to a kind of method of storage and inquiry data in Database Systems, is applied to semiconductor producing system, comprises the steps:
Step S1, the all data produced in real time when semiconductor producing system is carried out production technology all store to a Production database, and this Production database be merely stored in time data memory section before current time (such as 6 months, 10 months and 1 year etc. meet that process requirements sets interval time section value) data of interior data recordin module record, wherein, the value of time data memory section sets according to process requirements.
Step S2, according to default section interval time (such as 6 months, 10 months and 1 year etc. meet that process requirements sets interval time section value), the data stored in section in each interval time in Production database are all backed up in a filing data storehouse, and each data backing up to filing data storehouse in section interval time are all stored separately in a sub-filing data storehouse wherein, this, value of section set according to process requirements interval time, and this interval time section value less than or equal to the value of above-mentioned time data memory section, namely the value of above-mentioned time data memory section more than or equal to the value of this of section interval time.
Preferably, the configuration of unit application program for the convenience of the user, enquiry module is to when in filing data, the data of storage carry out query manipulation, the database service title (ServiceName) in the sub-filing data storehouse called is all identical, and namely the database service title externally used in every sub-filing data storehouse in filing data storehouse is all identical.
Step S3, when needing the data stored in antithetical phrase filing data to carry out query manipulation, sent the handover request in sub-filing data storehouse to converting unit (DBswitchwebsite) by a subscriber unit according to query demand, after the handover request received is confirmed by this converting unit, this handover request is converted to switching command and sends to handover module, when this handover module receives above-mentioned switching command, if server there is currently just opening one sub-filing data storehouse, the switching command that one data base's closing unit (DBshutdownmodule) sends according to converting unit is closed when behind the sub-filing data storehouse of front opening, data base selects unit (DBswitchmodule) to transfer the path in the corresponding sub-filing data storehouse of storage in a Parameter File unit (DBparameterfile) according to above-mentioned switching command, and the path transmission in this sub-filing data storehouse is opened unit (DBstartupmodule) to a data base, data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received, otherwise, data base selects unit directly transfer the path in the corresponding sub-filing data storehouse of storage in above-mentioned parameter file unit according to above-mentioned switching command and to above-mentioned data base, the path transmission in this sub-filing data storehouse is opened unit, data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received, to realize the operation that the data of storage in corresponding sub-filing data storehouse are inquired about by enquiry module, after having switched, converting unit feeds back, to subscriber unit, the switching result that handover module antithetical phrase filing data storehouse switches over, in converting unit, such as directly display switching result information and/or adopt the mode of mail that switching result information is sent to subscriber unit.
Wherein, above-mentioned subscriber unit and above-mentioned converting unit may be contained within enquiry module; Above-mentioned data base's closing unit, above-mentioned parameter file unit, above-mentioned data base select unit and above-mentioned data base to open unit to may be contained within handover module, and in above-mentioned parameter file unit, storage has the path in all sub-filing data storehouses.
Additionally, user arranges, by a ciphering unit, secured account information and this secured account operating right to every sub-filing data storehouse that the data of storage in described filing data storehouse are operated by above-mentioned enquiry module; When enquiry module inputs a secured account information, after this secured account information is verified by authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by described enquiry module according to the authority of this secured account; Wherein, ciphering unit and authentication unit are arranged in a security module, and this security module is arranged in described server, are namely provided with a handover module and a security module in this server.
It is seen that, the present embodiment can based on the embodiment of above-mentioned Database Systems, namely the present embodiment can be the method for storage and inquiry data in the Database Systems of above-described embodiment, therefore the relevant technical details that above-mentioned Database Systems are mentioned is still effective in the present embodiment, in order to reduce repetition, repeat no more here. Correspondingly, the relevant technical details mentioned in present embodiment is also applicable in the embodiment of above-mentioned Database Systems.
From above-described embodiment, a kind of Database Systems that the present invention proposes, it is applied to include on the semiconductor producing system of Production database and data recordin module, by arranging the filing data storehouse including some sub-filing data storehouses, for backing up the stored historical data of Production database in default interval time section, in every sub-filing data storehouse, all separate storage has the data of data recordin module record in an above-mentioned interval time section, and above-mentioned Production database is merely stored in the time data memory section before current time the data of data recordin module record, thus reducing the maintenance cost of Production database, improve the performance of Production database simultaneously. additionally, the invention allows for the method for storage and inquiry data in Database Systems, the automatic switchover in each sub-filing data storehouse is realized by handover module, and by converting unit, the switching result information in sub-filing data storehouse is fed back to subscriber unit in time, thus facilitating user's enquiry of historical data from filing data storehouse, and then decrease the waste of human resources.
It should be appreciated by those skilled in the art that those skilled in the art are realizing described change case in conjunction with prior art and above-described embodiment, do not repeat at this. Such change case has no effect on the flesh and blood of the present invention, does not repeat them here.
Above presently preferred embodiments of the present invention is described. It is to be appreciated that the invention is not limited in above-mentioned particular implementation, the equipment and the structure that are not wherein described in detail to the greatest extent are construed as and are practiced with the common mode in this area; Any those of ordinary skill in the art, without departing under technical solution of the present invention ambit, all may utilize the method for the disclosure above and technology contents and technical solution of the present invention is made many possible variations and modification, or it being revised as the Equivalent embodiments of equivalent variations, this has no effect on the flesh and blood of the present invention. Therefore, every content without departing from technical solution of the present invention, the technical spirit of the foundation present invention, to any simple modification made for any of the above embodiments, equivalent variations and modification, all still falls within the scope of technical solution of the present invention protection.
Claims (15)
1. Database Systems, are applied to include on the semiconductor producing system of Production database and data recordin module, it is characterised in that described Database Systems include filing data storehouse, enquiry module and a server;
All data that semiconductor producing system described in described data recordin module record produces when carrying out production technology in real time, and the data of record sent to described Production database, and this Production database is stored in the data that in current time time data memory section in the past, described data recordin module sends;
Described Production database also every one interval time section all will back up in described filing data storehouse in its stored all data in this section interval time, described enquiry module reads the data of storage in described filing data storehouse and/or described Production database by described server;
Described filing data storehouse includes some sub-filing data storehouses, and in each described sub-filing data storehouse, all storage has the data of described data recordin module record in section interval time described in one;
Wherein, according to process requirements set described time data memory section and described interval time section value.
2. Database Systems as claimed in claim 1, it is characterised in that described server includes a handover module;
When described enquiry module needs the data inquiring about storage in described filing data storehouse, described server is switched to corresponding sub-filing data storehouse by the switching command in the sub-filing data storehouse that described handover module sends according to described enquiry module, so that described enquiry module can read the data of storage in its required sub-filing data storehouse by described server.
3. Database Systems as claimed in claim 2, it is characterized in that, described enquiry module includes subscriber unit and converting unit, described subscriber unit sends the handover request in sub-filing data storehouse according to query demand, after described converting unit is received and confirmed by described handover request, described handover request is converted to switching command and sends to described handover module;
Wherein, the switching result information in sub-filing data storehouse is fed back to described subscriber unit also by described converting unit by described handover module.
4. Database Systems as claimed in claim 3, it is characterised in that described handover module includes: data base's closing unit, data base select unit and data base to open unit;
When described handover module receives described switching command, if described server there is currently the sub-filing data storehouse just opened, the switching command that described data base's closing unit sends according to described converting unit is closed when, behind the sub-filing data storehouse of front opening, described data base selects unit to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse;
Otherwise, described data base selects unit directly to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse.
5. Database Systems as claimed in claim 4, it is characterised in that described handover module also includes a storage the Parameter File unit in path, all sub-filing data storehouses;
Described data base selects unit to transfer the path in the corresponding sub-filing data storehouse of storage in described Parameter File unit according to described switching command, and the path transmission in this sub-filing data storehouse is opened unit to described data base, described data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received.
6. Database Systems as claimed in claim 2, it is characterised in that be additionally provided with the security module including ciphering unit and authentication unit in described server;
By described ciphering unit, secured account information and this secured account operating right to every sub-filing data storehouse that the data of storage in described filing data storehouse are operated by described enquiry module is set;
When described enquiry module inputs a secured account information, after described secured account is verified by described authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by described enquiry module according to the authority of this secured account.
7. Database Systems as claimed in claim 1, it is characterised in that the database service title in each described sub-filing data storehouse in described filing data storehouse is all identical.
8. Database Systems as claimed in claim 1, it is characterised in that the numerical value of described time data memory section is more than or equal to the numerical value of section described interval time.
9. a method for storage and inquiry data in Database Systems, is applied in semiconductor producing system, it is characterised in that comprise the steps:
The all data produced in real time when described semiconductor producing system is carried out production technology send in a Production database each through a data recordin module, and this Production database is merely stored in the time data memory section before current time the data of data recordin module record;
According to default section interval time, the data stored in section in each interval time in described Production database are all backed up in a filing data storehouse, and the data backing up to described filing data storehouse each interval time in section are all stored separately in a sub-filing data storehouse;
Enquiry module sends the switching command in sub-filing data storehouse to a handover module according to query demand, server is switched to corresponding sub-filing data storehouse according to described switching command by this handover module, to realize the operation that the data of storage in corresponding sub-filing data storehouse are inquired about by described enquiry module;
Wherein, described time data memory section is more than or equal to the value of section described interval time.
10. the method for storage and inquiry data in Database Systems as claimed in claim 9, it is characterised in that described enquiry module sends data base's switching command concretely comprising the following steps to a handover module according to query demand:
When needing the data stored in antithetical phrase filing data to carry out query manipulation, sent the handover request in sub-filing data storehouse to converting unit by a subscriber unit according to query demand, after the handover request received is confirmed by this converting unit, this handover request is converted to switching command and sends to described handover module;
Wherein, described subscriber unit and described converting unit may be contained within described enquiry module.
11. the method for storage and inquiry data in Database Systems as claimed in claim 10, it is characterized in that, switching result information is fed back to described subscriber unit also by described converting unit after carrying out above-mentioned sub-filing data storehouse handover operation by described handover module.
12. the method for storage and inquiry data in Database Systems as claimed in claim 10, it is characterised in that server is switched to concretely comprising the following steps of corresponding sub-filing data storehouse according to described switching command by described handover module:
When described handover module receives described switching command, if described server there is currently just opening one sub-filing data storehouse, the switching command that one data base's closing unit sends according to described converting unit is closed when, behind the sub-filing data storehouse of front opening, a data base selects unit to open unit according to described switching command by a data base and opens corresponding sub-filing data storehouse;
Otherwise, described data base selects unit directly to open unit according to described switching command by described data base and opens corresponding sub-filing data storehouse;
Wherein, described data base's closing unit, described data base select unit and described data base to open unit to may be contained within described handover module.
13. the method for storage and inquiry data in Database Systems as claimed in claim 12, it is characterized in that, described data base selects unit to transfer the path in the corresponding sub-filing data storehouse of storage in a Parameter File unit according to described switching command, and the path transmission in this sub-filing data storehouse is opened unit to described data base, described data base opens unit and opens corresponding sub-filing data storehouse according to the path, sub-filing data storehouse received;
Wherein, in described Parameter File unit, storage has the path in all sub-filing data storehouses, and described Parameter File unit is arranged in described handover module.
14. the method for storage and inquiry data in Database Systems as claimed in claim 9, it is characterised in that described method also includes:
By a ciphering unit, secured account information and this secured account operating right to every sub-filing data storehouse that the data of storage in described filing data storehouse are operated by described enquiry module is set;
When described enquiry module inputs a secured account information, after described secured account is verified by an authentication unit, the data of storage in corresponding sub-filing data storehouse could be operated by described enquiry module according to the authority of this secured account;
Wherein, described ciphering unit and authentication unit are arranged in a security module, and described security module is arranged in described server.
15. the method for storage and inquiry data in Database Systems as claimed in claim 9, it is characterized in that, described enquiry module is to when in described filing data storehouse, the data of storage carry out query manipulation, and the database service title in the sub-filing data storehouse called is all identical.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410675547.1A CN105677685A (en) | 2014-11-21 | 2014-11-21 | Database system and method for saving and querying data in database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410675547.1A CN105677685A (en) | 2014-11-21 | 2014-11-21 | Database system and method for saving and querying data in database system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105677685A true CN105677685A (en) | 2016-06-15 |
Family
ID=56958144
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410675547.1A Pending CN105677685A (en) | 2014-11-21 | 2014-11-21 | Database system and method for saving and querying data in database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105677685A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239369A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of database filing standby system and method |
| CN107609038A (en) * | 2017-08-14 | 2018-01-19 | 华为技术有限公司 | Data clearing method and device |
| CN109271400A (en) * | 2018-09-13 | 2019-01-25 | 江苏站企动网络科技有限公司 | A kind of corporation information query tracing system |
| CN109522314A (en) * | 2018-10-16 | 2019-03-26 | 平安科技（深圳）有限公司 | Data archiving method and terminal device based on block chain |
| CN113505142A (en) * | 2021-07-08 | 2021-10-15 | 中电金信软件有限公司 | Data query method and device and server |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1783063A (en) * | 2004-11-29 | 2006-06-07 | 中兴通讯股份有限公司 | Device and method for archiving and inquiry historical data |
| CN1904881A (en) * | 2005-07-26 | 2007-01-31 | 北京九州汇宝软件有限公司 | Method for searching database filing data |
| CN102200972A (en) * | 2010-03-24 | 2011-09-28 | 腾讯科技（北京）有限公司 | Database maintenance method and database maintenance equipment |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
-
2014
- 2014-11-21 CN CN201410675547.1A patent/CN105677685A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1783063A (en) * | 2004-11-29 | 2006-06-07 | 中兴通讯股份有限公司 | Device and method for archiving and inquiry historical data |
| CN1904881A (en) * | 2005-07-26 | 2007-01-31 | 北京九州汇宝软件有限公司 | Method for searching database filing data |
| CN102200972A (en) * | 2010-03-24 | 2011-09-28 | 腾讯科技（北京）有限公司 | Database maintenance method and database maintenance equipment |
| CN103617161A (en) * | 2013-09-26 | 2014-03-05 | 金蝶软件（中国）有限公司 | Data storing method and device for SAAS mode |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239369A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of database filing standby system and method |
| CN107609038A (en) * | 2017-08-14 | 2018-01-19 | 华为技术有限公司 | Data clearing method and device |
| CN107609038B (en) * | 2017-08-14 | 2020-08-07 | 华为技术有限公司 | Data cleaning method and device |
| CN109271400A (en) * | 2018-09-13 | 2019-01-25 | 江苏站企动网络科技有限公司 | A kind of corporation information query tracing system |
| CN109522314A (en) * | 2018-10-16 | 2019-03-26 | 平安科技（深圳）有限公司 | Data archiving method and terminal device based on block chain |
| CN109522314B (en) * | 2018-10-16 | 2023-04-14 | 平安科技（深圳）有限公司 | Block chain-based data archiving method and terminal equipment |
| CN113505142A (en) * | 2021-07-08 | 2021-10-15 | 中电金信软件有限公司 | Data query method and device and server |
| CN113505142B (en) * | 2021-07-08 | 2022-06-24 | 中电金信软件有限公司 | Data query method and device and server |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105677685A (en) | Database system and method for saving and querying data in database system | |
| CN103516591B (en) | The implementation method of enterprise's address list and device in immediate communication platform | |
| CN103067463B (en) | user root authority centralized management system and management method | |
| CN111680199A (en) | File management system and operation process | |
| US9135454B2 (en) | Systems and methods for enabling searchable encryption | |
| EP3306897B1 (en) | Access method and apparatus | |
| CN105991565B (en) | Method, system and the database proxy server of read and write abruption | |
| CN107566520A (en) | A kind of business data information management system based on cloud management platform | |
| CN102752294B (en) | Method and system for synchronizing data of multiple terminals on basis of equipment capacity | |
| CN108156030B (en) | Method and device for synchronizing configuration strategies | |
| CN103702319A (en) | SIM (subscriber identity module) card, individualized card writing system and method as well as SIM card obtained according to method | |
| CN105487556A (en) | Flight control method and flight control device of unmanned aircraft | |
| CN104767756A (en) | Equipment information processing method, client side device and server side device | |
| CN104951481A (en) | Method and device for managing database connection | |
| CN105049631B (en) | Enter the method and mobile terminal of row information transmission in address list program | |
| CN103984309A (en) | Cigarette production system with disaster tolerance function and disaster tolerance exercise method thereof | |
| CN109460252A (en) | Configuration file processing method, device and computer equipment based on git | |
| CN109766316A (en) | File acquisition method, device, computer equipment and storage medium | |
| CN113052529A (en) | Plane library management method and device, storage medium and electronic equipment | |
| CN106803836B (en) | Multi-center file forwarding processing method and device | |
| US8688624B2 (en) | Seed data automation | |
| CN102194169A (en) | Unified communication management method and system | |
| CN104702421A (en) | Web-based configuration management system | |
| CN103051449A (en) | Access right managing and controlling system and access right managing and controlling method | |
| US10432465B2 (en) | Automatic provisioning of a network access point |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160615 |
|
| RJ01 | Rejection of invention patent application after publication |