CN103106242A - Phone bill query method and phone bill query system - Google Patents
Phone bill query method and phone bill query system Download PDFInfo
- Publication number
- CN103106242A CN103106242A CN 201210544432 CN201210544432A CN103106242A CN 103106242 A CN103106242 A CN 103106242A CN 201210544432 CN201210544432 CN 201210544432 CN 201210544432 A CN201210544432 A CN 201210544432A CN 103106242 A CN103106242 A CN 103106242A
- Authority
- CN
- China
- Prior art keywords
- query
- inquiry
- query statement
- route
- service end
- 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
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention relates to a phone bill query method and a phone bill query system. The phone bill query method comprises multiple steps, wherein a step 1 is that a foreground query end issues a query command; a step 2 is that a proxy server receives and parses the query command, conducts routing distribution and transfers the query command to a background query server; a step 3 is that the background query server queries charging detail record data in a charging detail record storage module and sends a query result to the proxy server; a step 4 is that the proxy server receives the query result and transfers the proxy server to the foreground query end for display. The invention further provides the large-capacity high-concurrency phone bill query system. According to the phone bill query method and the phone bill query system, a routing distribution method is used, the data accessing speed is greatly increased, requirements on system hardware are greatly lowered at the same time, and cost is saved. In addition, an external unified service interface is provided and used for loading and unloading query data, and therefore internal high concurrency and load balancing can be realized.
Description
Technical field
The present invention relates to the ticket treatment technology of telecommunication system, particularly a kind of CDR inquiry method and inquiry system for the high concurrent ticket of large capacity.
Background technology
At present the total volume of global enterprise data is approximately will quadruple in every 3 years.Therefore, how to carry out fast query in mass data, and satisfy enterprise to low-cost and high available demand data, become the more and more stern challenge that most enterprises face, it is also like this that the ticket of field of telecommunications is processed.
In prior art, each large operator mostly adopts database mode, file system mode to user's Call Detail Record, hereinafter to be referred as detailed list, store and inquire about, perhaps integrated database technology, file system technology realize mixing storage and inquiry, and these technology more or less have deficiency for reducing costs, reduce risks and raising the efficiency three aspects.
Summary of the invention
Technical matters to be solved by this invention is to provide querying method and the inquiry system of the high concurrent ticket of large capacity, and the cost that exists for the solution prior art is high, risk is high, inefficient problem.
The technical scheme that the present invention solves the problems of the technologies described above is as follows: a kind of CDR inquiry method comprises:
Step 1, the foreground queries end sends query statement;
Step 2, acting server receive and resolve query statement, query statement is carried out route share, determine the route route after the forwarding inquiries instruction to backstage inquiry service end;
Step 3, the detailed forms data in the detailed single memory module of backstage inquiry service end inquiry obtains the detailed list with the query statement Condition Matching, and Query Result is returned to acting server by the route route of step 2;
Step 4, acting server receives Query Result, is transmitted to the foreground queries end and shows.
On the basis of technique scheme, the present invention can also do following improvement.
Further, send query statement with the form of query requests bag in described step 1, and described query requests bag comprises that the host node route that the number mark according to appointment inquires shares the address.
Further, the parsing query statement of described step 2 specifically comprises: judge whether the query statement form is correct; If the query statement form is incorrect, finish inquiry, if the query statement correct format carries out route and shares.
Further, in described step 2, query statement being carried out route shares specifically and comprises: by the busy-idle condition of routing overhead situation discriminatory analysis node, preferential backstage inquiry service end corresponding to node of free time the most that use, determine the route route according to the node busy-idle condition, and carry out the query statement forwarding.
Further, described routing overhead situation comprises the idle ratio of main frame and program busy-idle condition.
Further, the busy-idle condition of described discriminatory analysis node comprises: whether extremely detect the idle node that finds, if having extremely, carry out main and subordinate node and switch; If without abnormal, according to the route route forwarding inquiries instruction of determining.
Further, the detailed forms data in described step 3 in the detailed single memory module of backstage inquiry service end inquiry need at the appointed time be completed,, if query timeout finishes inquiry, and returns to query failure message; If inquire about not overtimely, Query Result is returned to acting server.
Further, the detailed single memory module in described step 4 is single in detail with the mode number of the pressing section storage of database, and it can realize dynamic load and the detailed forms data of unloading.
A kind of CDR inquiry system comprises foreground queries end, acting server, backstage inquiry service end and detailed single memory module:
The foreground queries end, it is used for sending query statement and shows Query Result;
Acting server, it is used for receiving and resolving described foreground queries end and send query statement, and the forwarding inquiries instruction also is used for receiving the Query Result that described backstage inquiry service end returns to described backstage inquiry service end;
Backstage inquiry service end, it is used for inquiring about the detailed forms data of described detailed single memory module, and Query Result is returned to acting server;
Detailed single memory module, it is used for storing detailed forms data.
On the basis of technique scheme, the present invention can also do following improvement.
Further, a described acting server connects at least one described backstage inquiry service end, and all acting servers namely provide external unified service interface all by same query interface reception query statement and forwarding inquiries result.
The invention has the beneficial effects as follows: the present invention adopts the route allocation way, has greatly improved the access speed of data, greatly reduces simultaneously the requirement to system hardware, has saved cost.And along with the growth of call bill data amount, this income will be obvious all the more.In addition, the invention provides external system service one interface, dynamically load and unload inquiry and use, realize inner high concurrent and load balancing.
Description of drawings
Fig. 1 is the schematic flow sheet of the querying method of the high concurrent ticket of large capacity of the present invention;
Fig. 2 is the structural representation of the querying method of the high concurrent ticket of large capacity of the present invention.
Embodiment
Below in conjunction with accompanying drawing, principle of the present invention and feature are described, example only is used for explaining the present invention, is not be used to limiting scope of the present invention.
As shown in Figure 1, the present embodiment one is a kind of CDR inquiry method based on the high concurrent ticket of large capacity, comprising:
Step 1, the foreground queries end sends query statement.
Particularly, be to send query statement with the form of query requests bag in described step 1, and described query requests bag comprises that the host node route that the number mark according to appointment inquires shares the address from routing control table, and send query statement.For routing control table, it is an allocation list of setting up in detailed single memory module, its the main field number of comprising section, IP address and port numbers can find according to number section IP and the inquiry service port numbers of the detailed forms data place main frame of this number section by inquiring about this form.
Step 2, acting server receive and resolve query statement, query statement is carried out route share, determine the route route after the forwarding inquiries instruction to backstage inquiry service end.
Particularly, resolve query statement and comprise judging whether the query statement form is correct, if the query statement form is incorrect, finish inquiry, if the query statement correct format carries out route and shares.Query statement is carried out route to be shared and comprises: by the busy-idle condition of routing overhead situation discriminatory analysis node, preferential backstage inquiry service end corresponding to node of free time the most that use, determine the route route according to the node busy-idle condition, and carry out the query statement forwarding.Wherein the routing overhead situation comprises the idle ratio of main frame and program busy-idle condition.In addition, the busy-idle condition of discriminatory analysis node comprises: whether extremely detect the idle node that finds, if having extremely, carry out main and subordinate node and switch; If without abnormal, according to the route route forwarding inquiries instruction of determining.
Step 3, the detailed forms data in the detailed single memory module of backstage inquiry service end inquiry obtains the detailed list with the query statement Condition Matching, and Query Result is returned to acting server by the route route of step 2.
The scheme that relates in step 2 and step 3 has adopted external unified service interface, and capable of dynamic loads and unloading is used, and realizes inner high concurrent and load balancing.Described external unified service interface refers to that a plurality of backstages inquiry service end connects an acting server, and acting server externally represents a query interface, externally referring to the foreground queries end here.The described inner high concurrent backstage inquiry service end that refers to can start a plurality of processes.Dynamic load refers in the situation that do not stop the number that inquiry business can increase and reduce the inquiry service process dynamically.Unloading is used and is referred to unload the QueryTicket service, as: after the unloading of the inquiry service on the 172.16.9.13 main frame, all data above 172.16.9.13 all can not have been inquired about.Load balancing refers to that acting server assigns to query statement on different backstage inquiry service ends according to the busy-idle condition of each backstage inquiry service end.
In addition, the detailed forms data in described step 3 in the detailed single memory module of backstage inquiry service end inquiry need at the appointed time be completed, if query timeout finishes inquiry, and returns to query failure message; If inquire about not overtimely, Query Result is returned to acting server.
Detailed single memory module is single in detail with the mode number of the pressing section storage of database, is convenient to Xin Jia and removes data by routing management information registering and cancellation, and capable of dynamic loads and the unloading data.The unloading data refer to unload detailed forms data, as No. 1521083 segment faults, no longer look into the data of this number section, can be routing control table medium size section 1521083 record deletion, can't look into the data of this number section again.Particularly, detailed single memory module is that the data number of pressing section is write in file, and file of each number section is placed under different paths, writes data file according to the path that configures in routing control table during operation, and is as shown in the table.
Step 4, acting server receives Query Result, is transmitted to the foreground queries end and shows.
As shown in Figure 2, the inquiry system of the high concurrent ticket of a kind of large capacity of setting up according to the method for embodiment one comprises foreground queries end, acting server, backstage inquiry service end and detailed single memory module:
The foreground queries end, it is used for sending query statement and shows Query Result; Acting server, it is used for receiving and resolving described foreground queries end and send query statement, and the forwarding inquiries instruction also is used for receiving the Query Result that described backstage inquiry service end returns to described backstage inquiry service end; Backstage inquiry service end, it is used for inquiring about the detailed forms data of described detailed single memory module, and Query Result is returned to acting server; Detailed single memory module, it is used for storing detailed forms data.
A described acting server connects at least one described backstage inquiry service end, and all acting servers namely provide external unified service interface all by same query interface reception query statement and forwarding inquiries result.
There are 2000 general-purpose families in two: one provinces of embodiment, assign to two host process, and every main frame is exactly 1,000 ten thousand user, build 4 mass file DBMS storehouses for every main frame and store the client to bring in storage single in detail.QueryTicket of each host-initiated is externally unified assembly simultaneously, starts 20 QueryTicket bundles of services.It is in real time in operation that QueryTicket is externally unified assembly and QueryTicket service.A QueryTicket business operation is initiated at interface, a foreground, and presentation layer can generate a query statement, finds the corresponding proxy retrieves service end of host node by query routing management information, sends out request.Can search from the inquiry service of its management according to load balancing after acting on behalf of the retrieval service end to obtain query statement an idle inquiry service query statement is resolved and is navigated to data query collection corresponding to data Layer and inquire about and return results collection.If note abnormalities during inquiry, the interface, foreground can be found from node-agent retrieval service end by query routing management information, repeats to initiate inquiry, reaches the function that the node Autonomic Migration Framework realizes cloud
Here, mass file DBMS storehouse namely is equivalent to detailed single memory module of embodiment one, and it is arranged in data Layer.The interface, foreground is equivalent to the foreground queries end in embodiment one, and it is arranged in presentation layer.The proxy retrieves service end is equivalent to the acting server in embodiment one, and it is arranged in application layer, and the inquiry service of proxy retrieves service end management is equivalent to the backstage inquiry service end in embodiment one.
The above is only preferred embodiment of the present invention, and is in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, is equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a CDR inquiry method, is characterized in that, comprises the following steps:
Step 1, the foreground queries end sends query statement;
Step 2, acting server receive and resolve query statement, query statement is carried out route share, determine the route route after the forwarding inquiries instruction to backstage inquiry service end;
Step 3, the detailed forms data in the detailed single memory module of backstage inquiry service end inquiry obtains the detailed list with the query statement Condition Matching, and Query Result is returned to acting server by the route route of step 2;
Step 4, acting server receives Query Result, is transmitted to the foreground queries end and shows.
2. CDR inquiry method according to claim 1, is characterized in that, sends query statement with the form of query requests bag in described step 1, and described query requests bag comprises that the host node route that the number mark according to appointment inquires shares the address.
3. CDR inquiry method according to claim 1, is characterized in that, the parsing query statement of described step 2 specifically comprises: judge whether the query statement form is correct; If the query statement form is incorrect, finish inquiry, if the query statement correct format carries out route and shares.
4. CDR inquiry method according to claim 1, it is characterized in that, in described step 2, query statement being carried out route shares specifically and comprises: by the busy-idle condition of routing overhead situation discriminatory analysis node, preferential backstage inquiry service end corresponding to node of free time the most that use, determine the route route according to the node busy-idle condition, and carry out the query statement forwarding.
5. CDR inquiry method according to claim 4, is characterized in that, described routing overhead situation comprises the idle ratio of main frame and program busy-idle condition.
6. CDR inquiry method according to claim 4, is characterized in that, the busy-idle condition of described discriminatory analysis node comprises: whether extremely detect the idle node that finds, if having extremely, carry out main and subordinate node and switch; If without abnormal, according to the route route forwarding inquiries instruction of determining.
7. CDR inquiry method according to claim 1, it is characterized in that, the detailed forms data in described step 3 in the detailed single memory module of backstage inquiry service end inquiry need at the appointed time be completed, if query timeout, finish inquiry, and return to query failure message to acting server; If inquire about not overtimely, Query Result is returned to acting server.
8. CDR inquiry method according to claim 1, is characterized in that, the detailed single memory module in described step 4 is single in detail with the mode number of the pressing section storage of database, and it can realize dynamic load and the detailed forms data of unloading.
9. a CDR inquiry system, is characterized in that, comprises foreground queries end, acting server, backstage inquiry service end and detailed single memory module:
The foreground queries end, it is used for sending query statement and shows Query Result;
Acting server, it is used for receiving and resolving described foreground queries end and send query statement, and the forwarding inquiries instruction also is used for receiving the Query Result that described backstage inquiry service end returns to described backstage inquiry service end;
Backstage inquiry service end, it is used for inquiring about the detailed forms data of described detailed single memory module, and Query Result is returned to acting server;
Detailed single memory module, it is used for storing detailed forms data.
10. CDR inquiry system according to claim 9, it is characterized in that, a described acting server connects at least one described backstage inquiry service end, and all acting servers all receive query statement and forwarding inquiries result by same query interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201210544432 CN103106242A (en) | 2012-12-14 | 2012-12-14 | Phone bill query method and phone bill query system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201210544432 CN103106242A (en) | 2012-12-14 | 2012-12-14 | Phone bill query method and phone bill query system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103106242A true CN103106242A (en) | 2013-05-15 |
Family
ID=48314097
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201210544432 Pending CN103106242A (en) | 2012-12-14 | 2012-12-14 | Phone bill query method and phone bill query system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103106242A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104780519A (en) * | 2014-01-10 | 2015-07-15 | 中国移动通信集团四川有限公司 | Phone bill query method and system |
| CN105828309A (en) * | 2015-01-05 | 2016-08-03 | 中国移动通信集团广西有限公司 | Phone bill processing method, phone bill processing device, and phone bill processing system |
| CN106649530A (en) * | 2016-10-21 | 2017-05-10 | 北京卡拉卡尔科技股份有限公司 | Cloud detailed list inquiry management system and method |
| CN107818122A (en) * | 2016-09-14 | 2018-03-20 | 深圳市优朋普乐传媒发展有限公司 | A kind of Agent components, search management method and search management system |
| CN111432077A (en) * | 2020-03-27 | 2020-07-17 | 广西东信易联科技有限公司 | CDR-based normalized flow statistical device and method |
-
2012
- 2012-12-14 CN CN 201210544432 patent/CN103106242A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104780519A (en) * | 2014-01-10 | 2015-07-15 | 中国移动通信集团四川有限公司 | Phone bill query method and system |
| CN105828309A (en) * | 2015-01-05 | 2016-08-03 | 中国移动通信集团广西有限公司 | Phone bill processing method, phone bill processing device, and phone bill processing system |
| CN105828309B (en) * | 2015-01-05 | 2019-07-02 | 中国移动通信集团广西有限公司 | A kind of call bill processing method, equipment and system |
| CN107818122A (en) * | 2016-09-14 | 2018-03-20 | 深圳市优朋普乐传媒发展有限公司 | A kind of Agent components, search management method and search management system |
| CN106649530A (en) * | 2016-10-21 | 2017-05-10 | 北京卡拉卡尔科技股份有限公司 | Cloud detailed list inquiry management system and method |
| CN106649530B (en) * | 2016-10-21 | 2020-12-15 | 北京卡拉卡尔科技股份有限公司 | Cloud detail query management system and method |
| CN111432077A (en) * | 2020-03-27 | 2020-07-17 | 广西东信易联科技有限公司 | CDR-based normalized flow statistical device and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102971732B (en) | The system architecture of the integrated classification query processing of key/value storer | |
| US11301446B1 (en) | System and method for interacting with a plurality of data sources | |
| JP2023532947A (en) | Data transfer method, proxy server, storage medium and electronic device | |
| CN102541990A (en) | Database redistribution method and system utilizing virtual partitions | |
| CN103106242A (en) | Phone bill query method and phone bill query system | |
| CN105025053A (en) | Distributed file upload method based on cloud storage technology and system | |
| CN102104617A (en) | Method for storing massive picture data by website operating system | |
| CN102201010A (en) | Distributed database system without sharing structure and realizing method thereof | |
| CN1859505B (en) | Bill checking system and method | |
| CN102890714A (en) | Method and device for indexing data | |
| CN110727738B (en) | Global routing system based on data fragmentation, electronic equipment and storage medium | |
| US8930518B2 (en) | Processing of write requests in application server clusters | |
| CN110519354A (en) | Distributed object storage system and service processing method and storage medium thereof | |
| CN105516284A (en) | Clustered database distributed storage method and device | |
| US11442632B2 (en) | Rebalancing of user accounts among partitions of a storage service | |
| CN100414936C (en) | Method for balancing load between multi network cards of network file system server | |
| US20240205292A1 (en) | Data processing method and apparatus, computer device, and computer-readable storage medium | |
| CN108259605B (en) | Data calling system and method based on multiple data centers | |
| CN102737061A (en) | Distributed ticket query management system and method | |
| CN102801876B (en) | Business information centralized processing system and method | |
| CN105978744A (en) | Resource allocation method, device and system | |
| CN113127568A (en) | Method and device for data routing and database and table division of distributed memory database | |
| CN109104482A (en) | A kind of distributed system of earth mat platform | |
| WO2024103690A1 (en) | Data request method and apparatus, and device and non-volatile readable storage medium | |
| CN109451090B (en) | Domain name resolution method and device |
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: 20130515 |