CN104063441A - Database operation maintenance system and data operation maintenance method thereof - Google Patents
Database operation maintenance system and data operation maintenance method thereof Download PDFInfo
- Publication number
- CN104063441A CN104063441A CN201410261090.XA CN201410261090A CN104063441A CN 104063441 A CN104063441 A CN 104063441A CN 201410261090 A CN201410261090 A CN 201410261090A CN 104063441 A CN104063441 A CN 104063441A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- timing statistics
- query
- statistics section
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
Abstract
The invention discloses a database operation maintenance system and a data operation maintenance method thereof. The method comprises the steps that after the database operation maintenance system receives periodically recorded data output by a real-time recording system and the timestamp of each data, the statistical time period of the currently received data is determined according to the timestamp of the currently received data, wherein the statistical time period is divided in advance according to a set period; the database operation maintenance system searches whether a database with a file name which contains the identifier of the statistical time period exists or not; if so, the currently received data is stored in the searched database; if not, after a new database with a file name which contains the identifier of the statistical time period is created, the currently received data is stored in the created database. In the technical scheme of the invention, by matching with the statistical time period in the file name of the database through query and update time, the record searching range is reduced and thus the response speed of query and update of the database can be improved.
Description
Technical field
The present invention relates to database field, relate in particular to a kind of database O&M system and the O&M method to data thereof.
Background technology
Microprocessor System for Real Time Record all needs to record a large amount of data common every day, and the data of record are stored in same database.Along with the growth of time, the radix of the record of storing in database is increasing.
Existing database O&M system receives after the query statement that carries querying condition, conventionally, in the mode of each record in traversal accessing database, finds out the record that meets querying condition, and obtain data from the record finding out.Obviously, the radix of increasing record in database, the system resource time more and more, needs cost that easily causes each record in existing database O&M system traversal accessing database to take is more and more longer, thereby the speed that causes searching record is more and more slower, causes existing database O&M system more and more slower to the response of the inquiry of database.
Existing database O&M system receives and carries after the update instruction of update condition, conventionally to travel through the mode of each record in accessing database, find out the record that meets update condition, and the data in the record finding out are modified, replace, increased or operation is upgraded in deletion etc.Because of increasing, record radix can to cause searching record more and more slower, thereby cause existing database O&M system more and more slower to the response of the renewal of database.
To sum up, when existing database O&M system is carried out attended operation (such as the data in inquiry, modification, increase or delete database etc.) to database, there will be the system resource taking more and more, the phenomenon that the time spending is more and more longer; Thereby cause existing database O&M system more and more slower to the response of the attended operation of database.Therefore, be necessary to provide a kind of database O&M system of the service data of being more convenient for.
Summary of the invention
The defect existing for above-mentioned prior art, the invention provides a kind of database O&M system and the O&M method to data thereof, to improve inquiry velocity, improves user's experience.
According to an aspect of the present invention, provide the maintaining method of a kind of database O&M system to data, having comprised:
Database O&M system receives the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception; Wherein, described timing statistics section divides out in advance with setting cycle;
Whether described database O&M system searching has the database of the sign that filename comprises described timing statistics section; If have, the data of current reception are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises described timing statistics section, the data of current reception are deposited in the database of establishment.
Further, the maintaining method of described database O&M system to data, also comprises: described database O&M system receives after the query statement of user's input, therefrom parses querying condition, comprising: query time section and inquiry field;
Described database O&M system is determined after the related timing statistics section of described query time section, and the timing statistics section of determining for each, finds out the database that filename includes the sign of this timing statistics section;
Use described inquiry field to inquire about in the database respectively finding out to obtain Query Result and show.
Preferably, the described inquiry field of described utilization is inquired about and is obtained Query Result in the database respectively finding out, and specifically comprises:
For each database finding out, determine the record of timestamp in described query time section in described database; In the record of determining, use described inquiry field to inquire about and obtain Query Result.
Preferably, describedly in the record of determining, use described inquiry field to inquire about to obtain Query Result, specifically comprise:
If described in the record determined outnumber setting line number, from the record of determining, obtain the record of setting line number at every turn and use described inquiry field to inquire about, using the Query Result obtaining as one page Query Result; And
The described inquiry field of described utilization is inquired about and is obtained Query Result and show in the database respectively finding out, and is specially:
Mode by each page of Query Result with paging shows.
Further, the maintaining method of described database O&M system to data, also comprises: described database O&M system receives after the Data Update instruction of user's input, therefrom parses more newer field, renewal value, and update time;
Described database O&M system is determined after the timing statistics section under described update time, and the timing statistics section for determining, finds out the database that filename includes the sign of this timing statistics section;
In the database finding out, according to described more newer field, determine after data to be updated, use renewal value to upgrade described data to be updated.
According to a further aspect in the invention, also provide a kind of database O&M system, having comprised:
Timing statistics section determination module, for receiving the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception; Wherein, described timing statistics section divides out in advance with setting cycle;
Data memory module, for searching the database that whether has the sign that filename comprises the timing statistics section that described timing statistics section determination module determines; If have, the data of the current reception of described timing statistics section determination module are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises the timing statistics section that described timing statistics section determination module determines, the data of the current reception of described timing statistics section determination module are deposited in the database of establishment.
Further, described database O&M system, also comprises:
Data query module, for receiving after the query statement of user's input, therefrom parses querying condition, comprising: query time section and inquiry field; And determine after the related timing statistics section of described query time section, the timing statistics section of determining for each, the database creating, finds out the database that filename includes the sign of this timing statistics section from described data memory module; The inquiry field of using described querying condition determining unit to export is inquired about and is obtained Query Result and show in the database respectively finding out.
Preferably, described data query module specifically comprises:
Querying condition determining unit, for receiving after the query statement of user's input, therefrom parses querying condition output; Described querying condition comprises: query time section and inquiry field;
Query unit, for determining after the related timing statistics section of the query time section of described querying condition determining unit output, the timing statistics section of determining for each, the database creating from described data memory module, find out the database that filename includes the sign of this timing statistics section; The inquiry field of using described querying condition determining unit to export is inquired about and is obtained Query Result output in the database respectively finding out;
Display unit, for showing the Query Result of described query unit output.
Preferably, described query unit is specifically for each database for finding out, determine the record of timestamp in the query time section of described querying condition determining unit output in described database, and outnumbering of the record of determining in judgement set after line number, each record that obtains setting line number from the record of determining uses the inquiry field of described querying condition determining unit output to inquire about, and using the Query Result obtaining as one page Query Result, exports; And
Described display unit is specifically for by each page of Query Result of described query unit output, the mode with paging shows.
Further, described database O&M system, also comprises:
Data update module, for receiving after the Data Update instruction of user's input, therefrom parses more newer field, renewal value, and update time; Determine after the timing statistics section under described update time, for the timing statistics section of determining, the database creating from described data memory module, find out the database that filename includes the sign of this timing statistics section; In the database finding out, according to described more newer field, determine after data to be updated, use renewal value to upgrade described data to be updated.
In technical scheme of the present invention, the sign that the filename of database comprises timing statistics section, the timestamp that in database, record comprises data; Can filter out the database that timing statistics section meets query time section, and in the database filtering out, further filter out the record of timestamp in query time section and inquire about; Dwindled the scope recording under data to be checked that finds out, that is to say, the same period only takies less system resource overhead for attended operations such as the inquiry of certain or certain several toy data bases or modifications, thereby can improve the response speed to the inquiry of database.
And, can filter out the database that timing statistics section comprises update time, from the database filtering out, carry out Data Update; Dwindled and found out the scope recording under data to be updated, thereby can improve the response speed to the renewal of database.
Accompanying drawing explanation
Fig. 1 is the database O&M system of the embodiment of the present invention process flow diagram to the storage method of data;
Fig. 2 is the database O&M system of the embodiment of the present invention process flow diagram to the querying method of data;
Fig. 3 is the database O&M system of the embodiment of the present invention process flow diagram to the update method of data;
Fig. 4 is the internal truss frame structure schematic diagram of the database O&M system of the embodiment of the present invention;
Fig. 5 is the internal truss frame structure schematic diagram of data query module in the database O&M system of the embodiment of the present invention.
Embodiment
For making object of the present invention, technical scheme and advantage clearer, referring to accompanying drawing and enumerate preferred embodiment, the present invention is described in more detail.Yet, it should be noted that, many details of listing in instructions are only used to make reader to have a thorough understanding to one or more aspects of the present invention, even if do not have these specific details also can realize these aspects of the present invention.
The terms such as " module " used in this application, " system " are intended to comprise the entity relevant to computing machine, such as but not limited to hardware, firmware, combination thereof, software or executory software.For example, module can be, but be not limited in: the thread of the process of moving on processor, processor, object, executable program, execution, program and/or computing machine.For instance, the application program of moving on computing equipment and this computing equipment can be modules.One or more modules can be positioned at an executory process and/or thread, and module also can and/or be distributed on a computing machine between two or more computing machines.
The present inventor considers, periodically the data of record are deposited into respectively in each toy data base, can greatly less system resource overhead for the maintenance of certain or certain several toy data bases in the same period, thereby accelerate the response to attended operations such as the inquiry of database, modification, additions and deletions, the maintenance of managerial personnel to database of being more convenient for.
Below in conjunction with accompanying drawing, specifically introduce the technical scheme of the embodiment of the present invention.
The database O&M system that the embodiment of the present invention provides comprises the maintaining method of data: to the storage of data, inquiry and update method.Database O&M system to the process flow diagram of the storage means of data as shown in Figure 1, comprises the steps:
S101: database O&M system receives the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section described in the data of current reception according to the timestamp of the data of current reception.
Particularly, Microprocessor System for Real Time Record data that user behavior is produced or that monitoring equipment monitors periodically record and export.Data recording and output that Microprocessor System for Real Time Record carries out one-period comprise: for the data within this cycle, carry out record, the data of record are stamped after timestamp, the timestamp of these data and these data is outputed to database O&M system together.Afterwards, Microprocessor System for Real Time Record carries out data recording and the output of next cycle.
Database O&M system receives the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of these data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception.Timing statistics section can be take setting cycle and divided out in advance: the lasting duration of each timing statistics section is all setting cycle; And in adjacent two timing statistics sections, after finish time that is preceding timing statistics section the zero hour of timing statistics section; For example, if setting cycle is sky, timing statistics section can be today, tomorrow, the day after tomorrow etc.
As can be seen here, for each database in the embodiment of the present invention, the corresponding unique timing statistics section of this database; Therefore, can, by identifying the sign of unique timing statistics section that the filename of this database comprises, identify this database.
S102: database O&M system is according to the timing statistics section determined, searches the database that whether has the sign that filename comprises this timing statistics section: if having, the data of current reception are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises this timing statistics section, the data of current reception are deposited in the database of establishment.
Particularly, database O&M system is according to the timing statistics section of determining in step S101, searches the database that whether has the sign that filename comprises this timing statistics section; If have this database, the data of the current reception of database O&M system in step S101 are deposited in the database finding out: in the database finding out, create a record, this record comprises data field and timestamp field; The timestamp of the data of the current reception of database O&M system, these data is stored into respectively in the data field, timestamp field of the record of establishment.
The database of the sign that filename comprises the timing statistics section of determining in step S101 if do not have, creates the database of the sign that a filename comprises this timing statistics section; Afterwards, the data of the current reception of database O&M system in step S101 are deposited in the database of establishment, concrete grammar is identical with the above-mentioned method that data are deposited in the database finding out, and repeats no more herein.Database is specially database file; How to utilize the time to identify filename, for the habitual technological means in this area, repeat no more herein.
In fact, because Microprocessor System for Real Time Record is according to time order and function journal and export data, so database O&M system also stores data in database into according to time order and function order.Like this, for each database, the time in time field in data line formerly in this database, always early than after data line in time in time field; Being equivalent to each data line in this database, is tactic according to the time order and function in time field.
Database O&M system is based on the above-mentioned storage means to data, after the data of Microprocessor System for Real Time Record record are stored in each database, the present invention also provides database O&M system in each database, to inquire about the method for the data of arbitrary time range, the process flow diagram of the method as shown in Figure 2, comprises the steps:
S201: database O&M system receives after the query statement of user's input, therefrom parses condition to be checked.
Particularly, database O&M system receives after the query statement of user's input, from this query statement, parses querying condition.Querying condition specifically comprises: query time section and inquiry field.
S202: database O&M system is determined the related timing statistics section of query time section in the querying condition parsing.
Particularly, if database O&M system is judged the query time section parsing in step S201 and is greater than setting cycle, determine fall within this query time section and with the equitant timing statistics paragraph of this query time section, as the related timing statistics section of this query time section.
If database O&M system is judged the query time section parsing in step S201 and is less than or equal to setting cycle, determine the timing statistics section that comprises this query time section, as the related timing statistics section of this query time section.
S203: database O&M system, for each timing statistics section of determining in step S202, finds out the database that filename includes this timing statistics section.
S204: inquire about in the database respectively finding out that the inquiry field that database O&M system employs parses relates at step S203 and obtain Query Result and show.
Particularly, database O&M system, for each database finding out in step S203, is determined timestamp in this database and is fallen within the record in the query time section parsing in step S201.Afterwards, from the record of determining of this database, use the inquiry field parsing in step S201 to inquire about and obtain Query Result.For example, if querying condition is the content of obtaining field A in query time section, database O&M system is for each database, because the record in this database is to arrange with the sequencing of timestamp, therefore can, according to putting in order of recording, inquire about one by one the record of determining of this database; For each record being queried, obtain the content of field A in this record, as Query Result.
For another example, if querying condition is to obtain the content that query time section is interior, the content of field A meets the field B of the record imposing a condition, database O&M system is for each database, from the record of determining of this database, the content that finds out field A meets the record that this imposes a condition, and obtains the content of field B of the record finding out as Query Result.
Afterwards, database O&M system shows the Query Result obtaining.
Preferably, in the situation that Query Result shows the form with paging, the setting line number of the single paging of database O&M system acquisition; For each database finding out, if judge this database the record of determining outnumber setting line number, the record that at every turn obtains setting line number from the record of determining of this database uses the inquiry field parsing to inquire about, using the Query Result obtaining as one page Query Result; Thereby obtain each page of Query Result of this database.The method that the inquiry field of using concrete grammar that the inquiry field that parses inquires about to parse with utilization the record of determining from this database for the record of the setting line number of obtaining is at every turn inquired about is identical, repeats no more.Afterwards, by each page of Query Result of this database, the mode with paging shows.
For each database finding out, database O&M system judges that the number of the record of determining of this database does not surpass setting line number, to the whole record of determining of this database, use the inquiry field parsing to inquire about, using the Query Result obtaining as one page Query Result, in the mode of single page, show.
In fact, due to the number of the database of determining in above-mentioned steps 203, be conventionally less than for storing the number of database of the data of Microprocessor System for Real Time Record output; The scope that has been equivalent to dwindle inquiry, can improve inquiry velocity.And the number of each data line to be checked is less than the number of all data lines in database cluster to be checked conventionally, further dwindled the scope of inquiry, be conducive to improve inquiry velocity.
Obviously, the number of database cluster to be checked is less than conventionally for storing the number of each database of the data of Microprocessor System for Real Time Record record, has been equivalent to dwindle the scope of inquiry, can improve inquiry velocity.And the number of each data line to be checked is less than the number of all data lines in database cluster to be checked conventionally, further dwindled the scope of inquiry, be conducive to improve inquiry velocity.
Database O&M system is based on the invention provides the above-mentioned storage means to data, after the data of Microprocessor System for Real Time Record record are stored in each database, the present invention also provides the database O&M system method to arbitrary data are upgraded in each database, the process flow diagram of the method as shown in Figure 3, comprises the steps:
S301: database O&M system receives after the Data Update instruction of user's input, therefrom parses update condition.
Particularly, database O&M system receives after the Data Update instruction of user's input, therefrom parses update condition.Update condition specifically comprises: more newer field, renewal value and update time.
S302: database O&M system is determined the timing statistics section under the update time in update condition.
Particularly, database O&M system is determined the timing statistics section that comprises the update time that step S301 relates to, as the timing statistics section under update time.
S303: the timing statistics section that database O&M system is determined for step S302, finds out the database that filename includes the sign of this timing statistics section.
S304: determine after data to be updated according to the update condition parsing in the database that database O&M system finds out at step S303, use renewal value to upgrade the data to be updated of determining.
Particularly, in the database that database O&M system finds out at step S303, if find out the record that timestamp equals update time, using the content of the data field of this record as data to be updated; Use renewal value to replace data to be updated.
In the database that database O&M system finds out at step S303, if search the record that equals update time less than timestamp, a newly-increased record, and will store into respectively renewal value, update time in the data field, timestamp field of this newly-increased record.
In fact, due to the number recording in the database of determining in above-mentioned steps 303, conventionally much smaller than the number recording for storing the database of the data of Microprocessor System for Real Time Record output; Be equivalent to dwindle and searched the scope recording under data to be updated, be conducive to improve and search the speed recording under data to be updated, thereby can improve renewal speed.
Based on above-mentioned, to the O&M of data (store, inquire about and upgrade) method, the internal truss frame structure schematic diagram of the database O&M system of the embodiment of the present invention as shown in Figure 4, comprising: timing statistics section determination module 401 and data memory module 402.
Timing statistics section determination module 401 is for receiving the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception; Wherein, timing statistics section divides out in advance with setting cycle.
Data memory module 402 is for searching the database that whether has the sign that filename comprises the timing statistics section that timing statistics section determination module 401 determines; If have, the data of timing statistics section determination module 401 current receptions are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises the timing statistics section that timing statistics section determination module 401 determines, the data of timing statistics section determination module 401 current receptions are deposited in the database of establishment.
Preferably, the database O&M system of the embodiment of the present invention, as shown in Figure 4, also comprises: data query module 403.
Data query module 403, for receiving after the query statement of user's input, therefrom parses querying condition, comprising: query time section and inquiry field; And determine after the related timing statistics section of query time section, the timing statistics section of determining for each, the database creating, finds out the database that filename includes the sign of this timing statistics section from data memory module; The inquiry field of using querying condition determining unit to export is inquired about and is obtained Query Result and show in the database respectively finding out.
The internal truss frame structure schematic diagram of data query module 403 as shown in Figure 5, comprising: querying condition determining unit 501, query unit 502 and display unit 503.
Querying condition determining unit 501, for receiving after the query statement of user's input, therefrom parses querying condition output; The querying condition parsing comprises: query time section and inquiry field.
Query unit 502 is for determining after the related timing statistics section of the query time section of querying condition determining unit 501 output, the timing statistics section of determining for each, the database creating from data memory module 402, find out the database that filename includes the sign of this timing statistics section.The inquiry field of using querying condition determining unit 501 to export is inquired about and is obtained Query Result output in the database respectively finding out; Specifically for each database for finding out, determine the record of timestamp in the query time section of querying condition determining unit 501 outputs in this database, and outnumbering of the record of determining in judgement set after line number, each inquiry field of obtaining record utilization querying condition determining unit 501 outputs of setting line number from the record of determining is inquired about, and using the Query Result obtaining as one page Query Result, exports.
Display unit 503 is for showing the Query Result of query unit 502 outputs; Specifically for by each page of Query Result of query unit 502 outputs, the mode with paging shows.
Preferably, the database O&M system of the embodiment of the present invention, as shown in Figure 4, also comprises: data update module 404.
Data update module 404, for receiving after the Data Update instruction of user's input, therefrom parses more newer field, renewal value, and update time; Determine after the timing statistics section under described update time, for the timing statistics section of determining, the database creating from data memory module 402, find out the database that filename includes the sign of this timing statistics section; In the database finding out, according to described more newer field, determine after data to be updated, use renewal value to upgrade described data to be updated.
Above-mentioned timing statistics section determination module 401, data memory module 402, data query module 403 and data update module 404, and the concrete methods of realizing of the function of the querying condition determining unit 501 in data query module 403, query unit 502 and display unit 503, can, with reference to the particular content of above-mentioned method flow step as shown in FIG. 1 to 3, repeat no more herein.
In the technical scheme of the embodiment of the present invention, the sign that the filename of database comprises timing statistics section, the timestamp that in database, record comprises data; Can filter out the database that timing statistics section meets query time section, and in the database filtering out, further filter out the record of timestamp in query time section and inquire about; Dwindled the scope recording under data to be checked that finds out, that is to say, the same period only takies less system resource overhead for attended operations such as the inquiry of certain or certain several toy data bases or modifications, thereby can improve the response speed to the inquiry of database.
And, can filter out the database that timing statistics section comprises update time, from the database filtering out, carry out Data Update; Dwindled and found out the scope recording under data to be updated, thereby can improve the response speed to the renewal of database.
The above is only the preferred embodiment of the present invention; it should be pointed out that for those skilled in the art, under the premise without departing from the principles of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (10)
1. the maintaining method of database O&M system to data, is characterized in that, comprising:
Database O&M system receives the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception; Wherein, described timing statistics section divides out in advance with setting cycle;
Whether described database O&M system searching has the database of the sign that filename comprises described timing statistics section; If have, the data of current reception are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises described timing statistics section, the data of current reception are deposited in the database of establishment.
2. the method for claim 1, is characterized in that, also comprises:
Described database O&M system receives after the query statement of user's input, therefrom parses querying condition, comprising: query time section and inquiry field;
Described database O&M system is determined after the related timing statistics section of described query time section, and the timing statistics section of determining for each, finds out the database that filename includes the sign of this timing statistics section;
Use described inquiry field to inquire about in the database respectively finding out to obtain Query Result and show.
3. method as claimed in claim 2, is characterized in that, the described inquiry field of described utilization is inquired about and obtained Query Result in the database respectively finding out, and specifically comprises:
For each database finding out, determine the record of timestamp in described query time section in described database; In the record of determining, use described inquiry field to inquire about and obtain Query Result.
4. method as claimed in claim 3, is characterized in that, describedly in the record of determining, uses described inquiry field to inquire about to obtain Query Result, specifically comprise:
If described in the record determined outnumber setting line number, from the record of determining, obtain the record of setting line number at every turn and use described inquiry field to inquire about, using the Query Result obtaining as one page Query Result; And
The described inquiry field of described utilization is inquired about and is obtained Query Result and show in the database respectively finding out, and is specially:
Mode by each page of Query Result with paging shows.
5. the method for claim 1, is characterized in that, also comprises:
Described database O&M system receives after the Data Update instruction of user's input, therefrom parses more newer field, renewal value, and update time;
Described database O&M system is determined after the timing statistics section under described update time, and the timing statistics section for determining, finds out the database that filename includes the sign of this timing statistics section;
In the database finding out, according to described more newer field, determine after data to be updated, use renewal value to upgrade described data to be updated.
6. a database O&M system, is characterized in that, comprising:
Timing statistics section determination module, for receiving the data of the periodicity record of Microprocessor System for Real Time Record output, and after the timestamp of each data, determines the timing statistics section under the data of current reception according to the timestamp of the data of current reception; Wherein, described timing statistics section divides out in advance with setting cycle;
Data memory module, for searching the database that whether has the sign that filename comprises the timing statistics section that described timing statistics section determination module determines; If have, the data of the current reception of described timing statistics section determination module are deposited in the database finding out; Otherwise, create after the database of the sign that a filename comprises the timing statistics section that described timing statistics section determination module determines, the data of the current reception of described timing statistics section determination module are deposited in the database of establishment.
7. system as claimed in claim 6, is characterized in that, also comprises:
Data query module, for receiving after the query statement of user's input, therefrom parses querying condition, comprising: query time section and inquiry field; And determine after the related timing statistics section of described query time section, the timing statistics section of determining for each, the database creating, finds out the database that filename includes the sign of this timing statistics section from described data memory module; The inquiry field of using described querying condition determining unit to export is inquired about and is obtained Query Result and show in the database respectively finding out.
8. system as claimed in claim 7, is characterized in that, described data query module specifically comprises:
Querying condition determining unit, for receiving after the query statement of user's input, therefrom parses querying condition output; Described querying condition comprises: query time section and inquiry field;
Query unit, for determining after the related timing statistics section of the query time section of described querying condition determining unit output, the timing statistics section of determining for each, the database creating from described data memory module, find out the database that filename includes the sign of this timing statistics section; The inquiry field of using described querying condition determining unit to export is inquired about and is obtained Query Result output in the database respectively finding out;
Display unit, for showing the Query Result of described query unit output.
9. system as claimed in claim 8, is characterized in that,
Described query unit is specifically for each database for finding out, determine the record of timestamp in the query time section of described querying condition determining unit output in described database, and outnumbering of the record of determining in judgement set after line number, each record that obtains setting line number from the record of determining uses the inquiry field of described querying condition determining unit output to inquire about, and using the Query Result obtaining as one page Query Result, exports; And
Described display unit is specifically for by each page of Query Result of described query unit output, the mode with paging shows.
10. system as claimed in claim 6, is characterized in that, also comprises:
Data update module, for receiving after the Data Update instruction of user's input, therefrom parses more newer field, renewal value, and update time; Determine after the timing statistics section under described update time, for the timing statistics section of determining, the database creating from described data memory module, find out the database that filename includes the sign of this timing statistics section; In the database finding out, according to described more newer field, determine after data to be updated, use renewal value to upgrade described data to be updated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410261090.XA CN104063441A (en) | 2014-06-12 | 2014-06-12 | Database operation maintenance system and data operation maintenance method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410261090.XA CN104063441A (en) | 2014-06-12 | 2014-06-12 | Database operation maintenance system and data operation maintenance method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104063441A true CN104063441A (en) | 2014-09-24 |
Family
ID=51551155
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410261090.XA Pending CN104063441A (en) | 2014-06-12 | 2014-06-12 | Database operation maintenance system and data operation maintenance method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104063441A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104516957A (en) * | 2014-12-18 | 2015-04-15 | 深圳市燃气集团股份有限公司 | Data query management method and system |
| CN105187882A (en) * | 2015-09-09 | 2015-12-23 | 无锡天脉聚源传媒科技有限公司 | Video correlation information synchronization processing method and device |
| CN105389352A (en) * | 2015-10-30 | 2016-03-09 | 北京奇艺世纪科技有限公司 | Log processing method and apparatus |
| CN105653551A (en) * | 2014-11-14 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Method and device for data update and statistics in distributed system |
| CN105677687A (en) * | 2014-11-21 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110069525A (en) * | 2018-08-20 | 2019-07-30 | 赛凡信息科技（厦门）有限公司 | A kind of scheme of acceleration search database information |
| CN110297811A (en) * | 2019-06-28 | 2019-10-01 | 联想(北京)有限公司 | Data processing method and device, computer system and computer readable storage medium storing program for executing |
| CN111143377A (en) * | 2018-11-05 | 2020-05-12 | 百度在线网络技术（北京）有限公司 | Automatic driving simulation data collection method, device and system |
| CN111506600A (en) * | 2020-03-23 | 2020-08-07 | 杭州海康威视系统技术有限公司 | Paging query method and device and electronic equipment |
| WO2021057253A1 (en) * | 2019-09-27 | 2021-04-01 | 苏宁云计算有限公司 | Data separation and storage method and apparatus, computer device and storage medium |
| CN112802610A (en) * | 2021-01-31 | 2021-05-14 | 淮航 | Passenger information big data intelligent processing method and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040003009A1 (en) * | 2002-07-01 | 2004-01-01 | Wilmot Gerald J. | Real-time database update transaction with disconnected relational database clients |
| CN101459557A (en) * | 2008-11-29 | 2009-06-17 | 成都市华为赛门铁克科技有限公司 | Secure logging centralized storage method and device |
| CN101534514A (en) * | 2008-03-11 | 2009-09-16 | 中兴通讯股份有限公司 | User state distribution statistical system and method thereof |
| CN102411765A (en) * | 2011-08-22 | 2012-04-11 | 广东省电力设计研究院 | Three-dimensional power grid construction method and device |
| CN102541908A (en) * | 2010-12-27 | 2012-07-04 | 沈阳中科博微自动化技术有限公司 | Log database system sub-volume management method |
| CN102799651A (en) * | 2012-06-28 | 2012-11-28 | 用友软件股份有限公司 | Query processing device and method |
| CN103778137A (en) * | 2012-10-19 | 2014-05-07 | 腾讯科技（深圳）有限公司 | Blog content searching method and system |
-
2014
- 2014-06-12 CN CN201410261090.XA patent/CN104063441A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040003009A1 (en) * | 2002-07-01 | 2004-01-01 | Wilmot Gerald J. | Real-time database update transaction with disconnected relational database clients |
| CN101534514A (en) * | 2008-03-11 | 2009-09-16 | 中兴通讯股份有限公司 | User state distribution statistical system and method thereof |
| CN101459557A (en) * | 2008-11-29 | 2009-06-17 | 成都市华为赛门铁克科技有限公司 | Secure logging centralized storage method and device |
| CN102541908A (en) * | 2010-12-27 | 2012-07-04 | 沈阳中科博微自动化技术有限公司 | Log database system sub-volume management method |
| CN102411765A (en) * | 2011-08-22 | 2012-04-11 | 广东省电力设计研究院 | Three-dimensional power grid construction method and device |
| CN102799651A (en) * | 2012-06-28 | 2012-11-28 | 用友软件股份有限公司 | Query processing device and method |
| CN103778137A (en) * | 2012-10-19 | 2014-05-07 | 腾讯科技（深圳）有限公司 | Blog content searching method and system |
Non-Patent Citations (2)
| Title |
|---|
| SS12SS: "Informix Dynamic Server数据库分段存储(1)", 《HTTP://WWW.EDUCITY.CN/DEVELOP/1447927-2.HTML》 * |
| 李鹏: "基于存储过程的分段数据存储方式设计", 《信息技术》 * |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653551B (en) * | 2014-11-14 | 2019-01-11 | 阿里巴巴集团控股有限公司 | The method and device thereof that data are updated and counted in distributed system |
| CN105653551A (en) * | 2014-11-14 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Method and device for data update and statistics in distributed system |
| CN105677687A (en) * | 2014-11-21 | 2016-06-15 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN104516957A (en) * | 2014-12-18 | 2015-04-15 | 深圳市燃气集团股份有限公司 | Data query management method and system |
| CN105187882B (en) * | 2015-09-09 | 2018-05-15 | 无锡天脉聚源传媒科技有限公司 | The synchronization processing method and device of a kind of video related information |
| CN105187882A (en) * | 2015-09-09 | 2015-12-23 | 无锡天脉聚源传媒科技有限公司 | Video correlation information synchronization processing method and device |
| CN105389352A (en) * | 2015-10-30 | 2016-03-09 | 北京奇艺世纪科技有限公司 | Log processing method and apparatus |
| CN110069525A (en) * | 2018-08-20 | 2019-07-30 | 赛凡信息科技（厦门）有限公司 | A kind of scheme of acceleration search database information |
| CN111143377A (en) * | 2018-11-05 | 2020-05-12 | 百度在线网络技术（北京）有限公司 | Automatic driving simulation data collection method, device and system |
| CN110297811A (en) * | 2019-06-28 | 2019-10-01 | 联想(北京)有限公司 | Data processing method and device, computer system and computer readable storage medium storing program for executing |
| CN110297811B (en) * | 2019-06-28 | 2022-04-19 | 联想(北京)有限公司 | Data processing method and device, computer system and computer readable storage medium |
| WO2021057253A1 (en) * | 2019-09-27 | 2021-04-01 | 苏宁云计算有限公司 | Data separation and storage method and apparatus, computer device and storage medium |
| CN111506600A (en) * | 2020-03-23 | 2020-08-07 | 杭州海康威视系统技术有限公司 | Paging query method and device and electronic equipment |
| CN112802610A (en) * | 2021-01-31 | 2021-05-14 | 淮航 | Passenger information big data intelligent processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104063441A (en) | Database operation maintenance system and data operation maintenance method thereof | |
| CN105808284A (en) | Incremental upgrading method and server using increment upgrading method | |
| CN102541450B (en) | Display control method and display control device for application program icons | |
| US20150095326A1 (en) | Generating And Using Temporal Metadata Partitions | |
| CN103020204A (en) | Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table | |
| CN102073527B (en) | Method and device for updating input method word stock | |
| CN104063254A (en) | Online upgrading method for electric energy meter | |
| CN103106222A (en) | Processing method and processing device of timer | |
| CN110659430A (en) | Block chain browsing method supporting multi-block chain network | |
| CN104657387A (en) | Data query method and device | |
| CN104182441A (en) | Data sheet synchronization method and device | |
| Blunck et al. | On heterogeneity in mobile sensing applications aiming at representative data collection | |
| CN102937905A (en) | Method and device for trying out application software and supporting trying out application software | |
| CN110941617A (en) | Power grid GIS data storage method based on version control | |
| CN101615815A (en) | Collocation method to different acquisition units parameter reorganization demonstration in the electric power monitoring system | |
| CN106445927A (en) | Data paging querying method and device | |
| CN104683870A (en) | Digital television channel search and updating system and application method of digital television channel search and updating system | |
| JP2021518957A (en) | Clearing / verification method, equipment and computer equipment | |
| CN109634975A (en) | Method of data synchronization and device, electronic equipment and computer readable storage medium | |
| CN101923553A (en) | Installation method of FAT (File Allocation Table) file system | |
| CN101833585A (en) | Database server operation control system, method and device | |
| CN110765074B (en) | Method and system for quickly accessing electric load curve data of acquisition terminal | |
| US9934307B2 (en) | Apparatus and method for managing job flows in an information processing system | |
| CN109117295B (en) | Transaction timeout monitoring method and device | |
| CN105653367A (en) | Method and device for traversing timer |
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: 20140924 |
|
| RJ01 | Rejection of invention patent application after publication |