CN103514180A - Data providing method and device - Google Patents
Data providing method and device Download PDFInfo
- Publication number
- CN103514180A CN103514180A CN201210207907.6A CN201210207907A CN103514180A CN 103514180 A CN103514180 A CN 103514180A CN 201210207907 A CN201210207907 A CN 201210207907A CN 103514180 A CN103514180 A CN 103514180A
- Authority
- CN
- China
- Prior art keywords
- server
- statistical form
- data
- form data
- statistical
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- G06F16/972—Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a data providing method and device. The data providing method comprises the steps that a first server obtains statistical table data from a second server; after receiving a query request of a user side, the first server provides statistical table data, corresponding to the query request, in the obtained statistical table data for the user side. Through the data providing method and device, the first server is responsible for query operation of the statistical table data, the second server is responsible for storage and statistics operation of the statistical table data, the first server obtains the statistical table data from the second server, and then after receiving the query request of the user side, the first server provides statistical table data, corresponding to the query request, in the obtained statistical table data for the user side. The data providing method and device solve the problem that data storage, a statistical process and a query process affect one another when many call tickets exist in the prior art, and can rapidly response and query report data, shorten request time, and improve user experience.
Description
Technical field
The present invention relates to the communications field, in particular to a kind of data offering method and device.
Background technology
In telecommunication service field, continuous growth along with service supplier and use surfing Internet with cell phone user, the ticket that operation system produces is also constantly increased, for user, inquire about the process of ticket statistics, generally, statistical server is responsible for warehouse-in, statistics and the inquiry of data, and as shown in Figure 1, this flow process comprises the following steps (step S102-step S106) to the querying method of traditional call bill data:
Step S102, enters library call bill data is put in storage to ticket storehouse and shown;
Step S104, statistics task phone bill, according to adding up, writes statistics table by the data after statistics;
Step S106, user's query statistic result table, offers user by the data after statistics.
Yet in the more operation system of ticket amount, the number of operations per second of portfolio (Tip-Per-Second, referred to as TPS) has reached 5000/second even, the data volume of half a year just reaches T rank.Meanwhile, supplier also pays close attention to further to key statistics report datas such as monitor system performance, user behavior analysis.For the little situation of portfolio, the querying flow of above-mentioned ticket statistics can return to statistics to user in time, but in high traffic situation, the querying flow of above-mentioned ticket statistics exists following defect:
The first, call bill data amount is huge, and the system resource that causes warehouse-in process, statistics task to take is too much, so user's report query request can not be responded conventionally fast, causes user to wait as long for, and affects user and experiences.The second, during multi-user concurrent query statistic data, database is caused to performance impact, be embodied in that resource is fought for, lock table, when serious, also can affect bill storage.
The interactive problem of data loading, statistic processes and query script when ticket amount is more in correlation technique, not yet proposes effective solution at present.
Summary of the invention
The interactive problem of data loading, statistic processes and query script when ticket amount is more in correlation technique, the invention provides a kind of data offering method and device, at least to address the above problem.
According to an aspect of the present invention, provide a kind of data offering method, the method comprises: first server is obtained statistical form data from second server; Above-mentioned first server receives after the inquiry request of user side, and statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining are offered to above-mentioned user side.
Before first server is obtained above-mentioned statistical form data from second server, said method can also comprise: the statistics table that first server establishment is identical with the list structure of the statistical form of second server.
First server is obtained above-mentioned statistical form data from second server and can be comprised: first server periodic scanning second server, the above-mentioned statistical form data of extraction second server; Or first server receives the above-mentioned statistical form data that second server regularly sends.
First server is after second server obtains above-mentioned statistical form data, and said method can also comprise: first server is stored in the above-mentioned statistical form data of obtaining in above-mentioned statistics table.
First server is after second server obtains above-mentioned statistical form data, and said method can also comprise: first server records the Extracting Information of the above-mentioned statistical form data of obtaining; Wherein, above-mentioned Extracting Information comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
Above-mentioned statistical form numbering can be the numbering of the above-mentioned statistical form on second server, above-mentioned extraction starts extraction that sequence number can equal last time to extract and finishes sequence number and add 1, and it can be the maximum sequence number in the current statistical form on second server that above-mentioned extraction finishes sequence number.
The above-mentioned Extracting Information that first server records the above-mentioned statistical form data of obtaining can comprise: first server records the above-mentioned Extracting Information of the above-mentioned statistical form data of obtaining to extract the form of log sheet.
According to a further aspect in the invention, provide a kind of data supplying device, this application of installation is in first server, and this device comprises: data acquisition module, for obtain statistical form data from second server; Data provide module, for receiving after the inquiry request of user side, statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining are offered to above-mentioned user side.
Said apparatus can also comprise: statistics table creation module, and for creating the statistics table identical with the list structure of the statistical form of second server.
Above-mentioned data acquisition module can comprise: data pick-up unit, for first server periodic scanning second server, extracts the above-mentioned statistical form data of second server; Or, data receiver unit, the above-mentioned statistical form data that regularly send for receiving second server.
Said apparatus can also comprise: data memory module, and for the above-mentioned statistical form data of obtaining are stored in to above-mentioned statistics table.
Said apparatus can also comprise: Extracting Information logging modle, for recording the Extracting Information of the above-mentioned statistical form data of obtaining; Wherein, above-mentioned Extracting Information comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
Above-mentioned Extracting Information logging modle can comprise: Extracting Information record cell, and for record the above-mentioned Extracting Information of the above-mentioned statistical form data of obtaining to extract the form of log sheet.
By the present invention, first server is responsible for the query manipulation of statistical form data, second server is responsible for warehouse-in and the statistical operation of statistical form data, first server is obtained statistical form data from second server, then after receiving the inquiry request of user side, first server offers above-mentioned user side by statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining, solved data loading when ticket amount is more in correlation technique, the interactive problem of statistic processes and query script, can respond fast inquiry report data, shortened request time, promoted user's experience.
Accompanying drawing explanation
Accompanying drawing described herein is used to provide a further understanding of the present invention, forms the application's a part, and schematic description and description of the present invention is used for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is according to the process flow diagram of the querying method of the call bill data of correlation technique;
Fig. 2 is according to the process flow diagram of the data offering method of the embodiment of the present invention;
Fig. 3 is according to the process flow diagram of the inquiry processing method of the call bill data of the embodiment of the present invention;
Fig. 4 is according to the process flow diagram of the abstracting method of the statistical form data of the embodiment of the present invention;
Fig. 5 is according to the structured flowchart of the data supplying device of the embodiment of the present invention;
Fig. 6 is the first concrete structure block diagram according to the data supplying device of the embodiment of the present invention;
Fig. 7 is the second concrete structure block diagram according to the data supplying device of the embodiment of the present invention;
Fig. 8 is according to the structured flowchart of the query processing device of the call bill data of the embodiment of the present invention.
Embodiment
Hereinafter with reference to accompanying drawing, also describe the present invention in detail in conjunction with the embodiments.It should be noted that, in the situation that not conflicting, embodiment and the feature in embodiment in the application can combine mutually.
In correlation technique, statistical server is responsible for warehouse-in, statistics, the query function of statistical form data simultaneously, the embodiment of the present invention provides a kind of data offering method and device, the statistical server of being simultaneously responsible for warehouse-in, statistics, query function is split, an independent newly-built querying server (below also referred to as first server), this querying server is only responsible for the query function of statistical form data.
Through function, split, statistical server is responsible for bill storage, statistics, and querying server is responsible for report query, and the statistics by extracting statistical server is to querying server, and user can directly obtain statistics by querying server.Below by embodiment, be elaborated.
The present embodiment provides a kind of data offering method, the process flow diagram of data offering method as shown in Figure 2, and the method comprises the following steps (step S202-step S204);
Step S202, first server is obtained statistical form data from second server;
Step S204, above-mentioned first server receives after the inquiry request of user side, and statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining are offered to above-mentioned user side.
Pass through above-described embodiment, first server is responsible for the query manipulation of statistical form data, second server is responsible for warehouse-in and the statistical operation of statistical form data, first server is obtained statistical form data from second server, then after receiving the inquiry request of user side, first server offers above-mentioned user side by statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining, solved data loading when ticket amount is more in correlation technique, the interactive problem of statistic processes and query script, can respond fast inquiry report data, shortened request time, promoted user's experience.
In second server phone bill, according to after putting in storage, adding up, obtain statistical form data, then first server need to be obtained above-mentioned statistical form data from second server, and being convenient to provides basis for the inquiry of subsequent user end.Before first server is obtained statistical form data from second server, need to first create the statistics table identical with the list structure of the statistical form of second server.Like this, the statistical form data of second server can successfully write first server, and first server is after second server gets statistical form data, and first server can be stored in the statistical form data of obtaining in above-mentioned statistics table.Aforesaid way provides condition for the storage of statistical form data.Certainly, statistical form data also can otherwise be stored, but generally, statistical form data are all to store with the form of statistical form.
When first server is obtained statistical form data from second server, it can be first server scanning second server, from second server, extract statistical form data, also can be that second server obtains call bill data warehouse-in, statistics after statistical form data, initiatively statistical form data are sent to first server.Based on this, the present embodiment provides a kind of preferred implementation, and first server is obtained statistical form data from second server and comprised: first server periodic scanning second server, extracts the statistical form data of second server; Or first server receives the statistical form data that second server regularly sends.
By the way, first server can get the statistical form data of second server, when subsequent user end need to be inquired about statistical form data, can directly pass through first server query statistic table data, like this, first server and second server can parallel work-flows, avoided the phase mutual interference between the warehouse-in, statistics of call bill data and user's data query request, work efficiency is provided, has improved the performance of query function.
After being drawn into statistical form data in first server from second server, first server can record concrete Extracting Information, facilitates next statistical form data pick-up process.After first server is obtained statistical form data from second server, first server records the Extracting Information of the statistical form data of obtaining; Wherein, this Extracting Information can comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
Above-mentioned statistical form is numbered the numbering of the statistical form on second server, and the form of the numbering of statistical form and user's inquiry is corresponding, for example, number 1 corresponding KPI form, numbers 2 corresponding success ratio statistical report forms, numbers 3 corresponding requests and counts statistical report form.Above-mentioned extraction starts extraction that sequence number equals last time to extract and finishes sequence number and add 1, and it is the maximum sequence number in the current statistical form on second server that above-mentioned extraction finishes sequence number.On every statistical server, the every line item of statistics table is all numbered, and for example usage data storehouse is numbered from adding, and it is 2 that the first row is recorded as 1, the second line item.Certainly also have other numbering, above-mentioned usage data storehouse is certainly added and is numbered is the most frequently used mode.
When first server records the Extracting Information of the statistical form data of obtaining, can record this Extracting Information to extract the form of log sheet.Extract log sheet and at least comprise statistical form numbering, extract and start sequence number, extract information such as finishing sequence number, further can also comprise following information: the extraction time, extract consuming time, extract result etc.
Compare with statistical server in correlation technique, querying server (being above-mentioned first server) requires lower to hardware configuration, therefore can utilize lower-cost personal computer (Personal Computer, referred to as PC) to replace.Configurable many of statistical server (being above-mentioned second server) after function splits, concrete quantity can be adjusted according to portfolio size, every statistical server is on average shared portfolio, carries out warehouse-in, the statistical work of ticket, and the data after statistics are write to statistics table separately.On querying server, register every statistical server information, like this, the statistics table that querying server can all statistical servers of successful access.
In order to optimize the extraction process of statistical form data, on querying server, can dispose timed task, timer-triggered scheduler statistics extracts storing process, extracts the statistical form data of every statistical server.Statistics on querying server extracts storing process: the statistics table of every statistical server of periodic scanning, extracts new data to statistical form with incremental mode.Data recording in statistical form on every statistical server is numbered, when this end of scan, extract when complete, extraction is finished to sequence number and be recorded to extraction log sheet.When next sweep start, according to extracting end sequence number, obtain extraction beginning sequence number, generally, will last time extract end sequence number and add 1 as this extraction beginning sequence number.
Specific works flow process for statistical server and querying server, is introduced below.Fig. 3 is according to the process flow diagram of the inquiry processing method of the call bill data of the embodiment of the present invention, and as shown in Figure 3, the method comprises the following steps (step S302-step S306):
Step S302, statistical server carries out warehouse-in, the statistical operation of call bill data.
Step S304, querying server extracts the statistical form data of statistical server to local.
Step S306, user obtains statistical form data by querying server.
The process that querying server is extracted from statistical server statistical form data is below introduced, Fig. 4 is according to the process flow diagram of the abstracting method of the statistical form data of the embodiment of the present invention, as shown in Figure 4, the method comprises the following steps (step S402-step S412):
Step S402, extracts operation and regularly calls extraction process.
Step S404, extraction process obtains this extraction beginning, finishes sequence number by extracting log sheet.
The content information that for example extracts log sheet can be as shown in table 1.
Table 1
| Statistical form numbering | Extract and start sequence number | Extract and finish sequence number | Extract result | Extract consuming time |
| 1 | 1 | 100 | 0 | 123 |
| 2 | 1 | 50 | 0 | 134 |
| 3 | 1 | 80 | 0 | 255 |
The form of statistical form numbering and user's inquiry is corresponding, for example, number 1 corresponding KPI form, numbers 2 corresponding success ratio statistical report forms, numbers 3 corresponding requests and counts statistical report form.
Extract and start sequence number initial value since 1, successor value calculates by extracting end sequence number.For example, the extraction of three form next times starts sequence number and is followed successively by 101,51,81.
Extract to finish sequence number and extract while starting at this, by the current maximum sequence number of statistics table on statistical server, drawn.On every statistical server, the every line item of statistics table is all numbered, and for example usage data storehouse is numbered from adding, and it is 2 that the first row is recorded as 1, the second line item.Certainly also have other numbering, above-mentioned usage data storehouse is certainly added and is numbered is the most frequently used mode.
Step S406, obtains this and extracts beginning sequence number, extracts and finish after sequence number, and extraction process judgement starts sequence number and whether is less than end sequence number, if so, illustrates that new statistics needs extraction, execution step S408, if not, execution step S412.
Step S408, extraction process writes querying server by extracting the statistics table data that start sequence number, extract in end sequence number interval on every statistical server.
Step S410, extraction process comprises that by this Extracting Information this extract to start sequence number, extracts and finish sequence number, extract result, extract the information such as consuming time and write extraction log sheet, during for next time extraction.
For example after this extraction, the content information of log sheet can be as shown in table 2.
Table 2
| Statistical form numbering | Extract and start sequence number | Extract and finish sequence number | Extract result | Extract consuming time |
| 1 | 1 | 100 | 0 | 123 |
| 2 | 1 | 50 | 0 | 134 |
| 3 | 1 | 80 | 0 | 255 |
| 1 | 101 | 200 | 0 | 144 |
| 2 | 51 | 60 | 0 | 25 |
| 3 | 81 | 90 | 0 | 86 |
After this extracts, in the statistical form of numbering 1, extracting beginning sequence number is 101, and it is 200 that extraction finishes sequence number, and extracting consuming time is 144.In numbering 2 statistical form, extract that to start sequence number be 51, extract that to finish sequence number be 60, extracting consuming time is 25 etc.
Step S412, extraction process finishes.
For with above-mentioned data offering method, the present embodiment provides a kind of data supplying device, this application of installation is in first server (being above-mentioned querying server), for realizing above-described embodiment.Fig. 5 is according to the structured flowchart of the data supplying device of the embodiment of the present invention, and as shown in Figure 5, this device comprises: data acquisition module 10 and data provide module 20.Below this structure is described.
Data provide module 20, are connected to data acquisition module 10, and for receiving after the inquiry request of user side, statistical form data corresponding with described inquiry request in the statistical form data that above-mentioned data acquisition module 10 is obtained offer described user side.
Pass through said apparatus, first server is responsible for the query manipulation of statistical form data, second server is responsible for warehouse-in and the statistical operation of statistical form data, data acquisition module 10 obtains statistical form data from second server, then after receiving the inquiry request of user side, data provide module 20 that statistical form data corresponding with above-mentioned inquiry request in the statistical form data of obtaining are offered to above-mentioned user side, solved data loading when ticket amount is more in correlation technique, the interactive problem of statistic processes and query script, can respond fast inquiry report data, shortened request time, promoted user's experience.
After second server phone bill certificate is put in storage, is added up, obtain statistical form data, before obtaining statistical form data in first server from second server, need to first create the statistics table identical with the list structure of the statistical form of second server, like this, the statistical form data of second server just can successfully write first server.Therefore, said apparatus also comprises statistics table creation module, for creating the statistics table identical with the list structure of the statistical form of above-mentioned second server.Said apparatus also comprises: data memory module, and for the above-mentioned statistical form data of obtaining are stored in to above-mentioned statistics table.
When first server is obtained statistical form data from second server, it can be first server scanning second server, from second server, extract statistical form data, also can be that second server obtains call bill data warehouse-in, statistics after statistical form data, initiatively statistical form data are sent to first server.Based on this, the present embodiment provides a kind of preferred implementation, the first concrete structure block diagram of data supplying device as shown in Figure 6, this device is except comprising the modules in above-mentioned Fig. 5, data acquisition module 10 also comprises data pick-up unit 12 or data receiver unit 14.Fig. 6 only be take data acquisition module 10 and is comprised that data pick-up unit 12 describes as example.
Data pick-up unit 12, for the above-mentioned second server of above-mentioned first server periodic scanning, extracts the above-mentioned statistical form data of above-mentioned second server; Or,
Data receiver unit 14, the above-mentioned statistical form data that regularly send for receiving above-mentioned second server.
By the way, first server can get the statistical form data of second server, when subsequent user end need to be inquired about statistical form data, can directly pass through first server query statistic table data, like this, first server and second server can parallel work-flows, avoided the phase mutual interference between the warehouse-in, statistics of call bill data and user's data query request, work efficiency is provided, has improved the performance of query function.
After being drawn into statistical form data in first server from second server, first server can record concrete Extracting Information, facilitates next statistical form data pick-up process.Fig. 7 is the second concrete structure block diagram according to the data supplying device of the embodiment of the present invention, this device is except comprising the modules in above-mentioned Fig. 6, also comprise Extracting Information logging modle 30, be connected to data acquisition module 10 and data module 20 is provided, for recording the Extracting Information of the statistical form data of obtaining; Wherein, this Extracting Information comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
When first server records the Extracting Information of the statistical form data of obtaining, can record this Extracting Information to extract the form of log sheet.Be that above-mentioned Extracting Information logging modle comprises: Extracting Information record cell, for record the above-mentioned Extracting Information of the above-mentioned statistical form data of obtaining to extract the form of log sheet.
Compare with statistical server in correlation technique, first server requires lower to hardware configuration, therefore can utilize lower-cost PC to replace.
Fig. 8 is according to the structured flowchart of the query processing device of the call bill data of the embodiment of the present invention, and as shown in Figure 8, this device comprises: warehouse-in statistical module, time block, statistical form data extraction module, logging modle and enquiry module.Below this structure is described.
Warehouse-in statistical module, is applied to above-mentioned second server (being the statistical server after function splits), for warehouse-in and the statistics of call bill data.
Time block, is applied to above-mentioned first server (being querying server), for setting the execution frequency of statistical form data extraction module.
Statistical form data extraction module, is applied to above-mentioned first server (being querying server), and the function of the data acquisition module in its function and above-described embodiment is suitable, puts the statistical form data of statistical module for the decimation in time of setting according to time block in storage.Statistical form data pick-up storing process is the statistics table of every statistical server of periodic scanning, with incremental mode, new data is extracted to the statistical form to querying server.
Logging modle, is applied to above-mentioned first server (being querying server), and the function of the Extracting Information record cell in its function and above-described embodiment is suitable, for filling in the extraction log sheet that records above-mentioned statistics.This extraction log sheet starts, finishes the information such as sequence number for recording the extraction of each statistical form data.Particularly, this extraction log sheet comprises that following information one of at least: statistical form numbering, extract and start sequence number, extract and finish sequence number.This extraction log sheet can also comprise that following information is one of at least: the extraction time, extract consuming time, extract result.
Enquiry module, is applied to above-mentioned first server (being querying server), and the data in its function and above-described embodiment provide the function of module suitable, for the inquiry of user's ticket statistics.
In the specific implementation process of above-mentioned query processing device, the inquiry processing method of the workflow of this device and above-mentioned ticket statistics is similar, does not repeat herein.
As can be seen from the above description, the present invention is independent by the inquiry of the warehouse-in of call bill data, statistics and data, the impact of having avoided bill storage, ticket statistics expense to cause report query, even when multi-user concurrent request, also can respond fast and return to report data, shorten request time, promoted user's experience.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on the network that a plurality of calculation elements form, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in memory storage and be carried out by calculation element, and in some cases, can carry out shown or described step with the order being different from herein, or they are made into respectively to each integrated circuit modules, or a plurality of modules in them or step are made into single integrated circuit module to be realized.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (13)
1. a data offering method, is characterized in that, comprising:
First server is obtained statistical form data from second server;
Described first server receives after the inquiry request of user side, and statistical form data corresponding with described inquiry request in the statistical form data of obtaining are offered to described user side.
2. method according to claim 1, is characterized in that, before described first server is obtained described statistical form data from described second server, described method also comprises:
The described first server establishment statistics table identical with the list structure of the statistical form of described second server.
3. method according to claim 1, is characterized in that, described first server is obtained described statistical form data from described second server and comprised:
Second server described in described first server periodic scanning, extracts the described statistical form data of described second server;
Or,
Described first server receives the described statistical form data that described second server regularly sends.
4. method according to claim 2, is characterized in that, described first server is after described second server obtains described statistical form data, and described method also comprises:
Described first server is stored in the described statistical form data of obtaining in described statistics table.
5. method according to claim 1, is characterized in that, described first server is after described second server obtains described statistical form data, and described method also comprises:
The Extracting Information of the statistical form data of obtaining described in described first server record; Wherein, described Extracting Information comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
6. method according to claim 5, it is characterized in that, described statistical form is numbered the numbering of the described statistical form on described second server, described extraction starts extraction that sequence number equals last time to extract and finishes sequence number and add 1, and it is the maximum sequence number in the current statistical form on described second server that described extraction finishes sequence number.
7. method according to claim 5, is characterized in that, the described Extracting Information of the statistical form data of obtaining described in described first server records comprises:
Described first server is to extract the described Extracting Information of the statistical form data of obtaining described in the form record of log sheet.
8. a data supplying device, is applied to first server, it is characterized in that, comprising:
Data acquisition module, for obtaining statistical form data from second server;
Data provide module, and for receiving after the inquiry request of user side, statistical form data corresponding with described inquiry request in the statistical form data that described data acquisition module is obtained offer described user side.
9. device according to claim 8, is characterized in that, described device also comprises:
Statistics table creation module, for creating the statistics table identical with the list structure of the statistical form of described second server.
10. device according to claim 8, is characterized in that, described data acquisition module comprises:
Data pick-up unit, for second server described in described first server periodic scanning, extracts the described statistical form data of described second server; Or,
Data receiver unit, the described statistical form data that regularly send for receiving described second server.
11. devices according to claim 9, is characterized in that, described device also comprises:
Data memory module, for being stored in described statistics table by the described statistical form data of obtaining.
12. devices according to claim 8, is characterized in that, described device also comprises:
Extracting Information logging modle, for the Extracting Information of the statistical form data obtained described in recording; Wherein, described Extracting Information comprise following one of at least: statistical form numbering, extract start sequence number, extract finish sequence number, extraction time, extract consuming time, extract result.
13. devices according to claim 12, is characterized in that, described Extracting Information logging modle comprises:
Extracting Information record cell, the described Extracting Information of the statistical form data of obtaining described in recording for the form with extraction log sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210207907.6A CN103514180A (en) | 2012-06-21 | 2012-06-21 | Data providing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210207907.6A CN103514180A (en) | 2012-06-21 | 2012-06-21 | Data providing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103514180A true CN103514180A (en) | 2014-01-15 |
Family
ID=49896918
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210207907.6A Pending CN103514180A (en) | 2012-06-21 | 2012-06-21 | Data providing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103514180A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317934A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Fast batch calling method and system |
| WO2016101560A1 (en) * | 2014-12-23 | 2016-06-30 | 中兴通讯股份有限公司 | Method and system for realizing telephone traffic statistic and method and device for call ticket storage |
| CN106885957A (en) * | 2017-02-08 | 2017-06-23 | 广州新拓慧电子科技有限公司 | Electromagnetic environment integrated estimation system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6141686A (en) * | 1998-03-13 | 2000-10-31 | Deterministic Networks, Inc. | Client-side application-classifier gathering network-traffic statistics and application and user names using extensible-service provider plugin for policy-based network control |
| US20050080794A1 (en) * | 2003-10-10 | 2005-04-14 | Robert Ledingham | Database architecture for an air traffic information system |
| CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
| CN101431524A (en) * | 2007-11-07 | 2009-05-13 | 阿里巴巴集团控股有限公司 | Method and device for implementing oriented network advertisement delivery |
-
2012
- 2012-06-21 CN CN201210207907.6A patent/CN103514180A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6141686A (en) * | 1998-03-13 | 2000-10-31 | Deterministic Networks, Inc. | Client-side application-classifier gathering network-traffic statistics and application and user names using extensible-service provider plugin for policy-based network control |
| US20050080794A1 (en) * | 2003-10-10 | 2005-04-14 | Robert Ledingham | Database architecture for an air traffic information system |
| CN101266606A (en) * | 2007-03-15 | 2008-09-17 | 阿里巴巴公司 | On-line data migration method based on Oracle database |
| CN101431524A (en) * | 2007-11-07 | 2009-05-13 | 阿里巴巴集团控股有限公司 | Method and device for implementing oriented network advertisement delivery |
Non-Patent Citations (4)
| Title |
|---|
| 张友生 等: "《系统分析师教程》", 28 February 2010 * |
| 彭毓琼等: ""广西铁通详细话单查询、打印系统优化之路"", 《电信技术》 * |
| 李东 等: ""大型企业电话信息管理系统的构建"", 《电力系统通信》 * |
| 王林: "《数据库系统原理与应用技术基础（Oracle）》", 31 March 2003, 北京希望电子出版社 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104317934A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Fast batch calling method and system |
| CN104317934B (en) * | 2014-10-31 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of method and system of rapid batch outgoing call |
| WO2016101560A1 (en) * | 2014-12-23 | 2016-06-30 | 中兴通讯股份有限公司 | Method and system for realizing telephone traffic statistic and method and device for call ticket storage |
| CN106885957A (en) * | 2017-02-08 | 2017-06-23 | 广州新拓慧电子科技有限公司 | Electromagnetic environment integrated estimation system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100478956C (en) | Method and corresponding system for creating and obtaining report forms | |
| CN102891826B (en) | The control method of web page access, equipment and system | |
| CN100456286C (en) | Universal file search system and method | |
| CN104104717A (en) | Inputting channel data statistical method and device | |
| CN101557427A (en) | Method for providing diffluent information and realizing the diffluence of clients, system and server thereof | |
| CN106658096A (en) | Method and device for pushing live program | |
| CN102256337A (en) | Message processing method and equipment in wireless local area network (WLAN) | |
| CN112612686A (en) | Performance test method and device, electronic equipment and storage medium | |
| CN105721629A (en) | User identifier matching method and device | |
| CN103778908A (en) | Karaoke member VOD system and VOD method thereof | |
| CN104657435A (en) | Storage management method for application data and network management system | |
| CN107483381A (en) | The monitoring method and device of interlock account | |
| CN112468409A (en) | Access control method, device, computer equipment and storage medium | |
| CN101807184B (en) | Method for searching character string with wildcard character and system thereof | |
| WO2021036319A1 (en) | Data cleaning method and system | |
| CN103514180A (en) | Data providing method and device | |
| CN103136315A (en) | Storage processing method and storage processing device for call detail record (CDR) data | |
| CN111431818A (en) | Cross-domain request traffic distribution method and device, storage medium and computer equipment | |
| CN108520401B (en) | User list management method, device, platform and storage medium | |
| CN104135499A (en) | Traffic reminding method, traffic reminding device and traffic reminding system, traffic query method and traffic query device | |
| CN111200645B (en) | Service request processing method, device, equipment and readable storage medium | |
| CN106469166B (en) | A kind of information processing method and device | |
| CN101815277A (en) | Method and device for statistical treatment of call bill data | |
| CN106817592A (en) | Homepage recommends scheduling method and device | |
| CN111259062B (en) | Method and device capable of guaranteeing sequence of statement result set of full-table query of distributed database |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140115 |