CN1859505B - Bill checking system and method - Google Patents
Bill checking system and method Download PDFInfo
- Publication number
- CN1859505B CN1859505B CN2006100582008A CN200610058200A CN1859505B CN 1859505 B CN1859505 B CN 1859505B CN 2006100582008 A CN2006100582008 A CN 2006100582008A CN 200610058200 A CN200610058200 A CN 200610058200A CN 1859505 B CN1859505 B CN 1859505B
- Authority
- CN
- China
- Prior art keywords
- module
- file
- output
- data file
- user
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A calls ticket querying system includes one calls ticket querying module, one querying result output module, configuration module; said configuration module, calls ticket querying module and output module interconnected, said calls ticket querying module according to configuration module stored configuration files and user inputted multiple querying condition to make filtering and querying to calls ticket file, output module outputting said calls ticket querying module stored querying result record file content. The present invention realizes multiple condition querying, fast searching and instant outputting result.
Description
Technical field
The present invention relates to CDR inquiry system and querying method, particularly a kind of the realization searched for and the CDR inquiry system and the querying method of instant output Search Results fast to the call bill data file of the general format of magnanimity.
Background technology
The call bill data file is a kind of file that writes down statistics, each call bill data file is made up of some records, every record comprises some row, and every row all have its corresponding data types, between row and the row two kinds of partitioning schemes is arranged: press separator and separate or separate by regular length.Each call bill data file all has its set form, comprise data type, the row of the columns that every record of file name, filename suffix, call bill data file comprises, every row and be listed as between separation mode etc.
All can adopt the file of above-mentioned form to come record data during user's statistics in telecommunication system, measurement and control area, financial accounting statistics or the like the technical field.Along with the continuous growth of subscriber traffic, different operating processes all can produce the call bill data file of a large amount of different-formats, and these call bill data file loggings different information, is stored in different directories, the different file.The user need inquire about, add up according to certain condition these call bill data files.The demand of user session list inquiry system is to support call bill data file, file format variation, the statistical information of magnanimity can preserve and multiple demand such as importing.
In the prior art, because the difference of call bill data file format, the user is usually at every kind of ticket or inquiry system of the similar ticket exploitation of several form, thereby make the inquiry system function singleness, operate unfriendlyly, inquiry velocity is very slow, not the expectability text formatting, not expectability ticket number range, can not prospective users querying condition, can not realize expeditiously processing to the mass tickets data file.Handle if carry out magnanimity, just the ticket of magnanimity need be imported in the database, utilize database to carry out the query statistic analysis, thereby need building and complicated operations of facility environment.
Global system for mobile communications for example of the prior art (G1obal System of Mobilecommunication, hereinafter to be referred as GSM) short message ticket analyzer, this is the CDR inquiry system of analyzing at the call bill data file that Short Message Center produced of GSM network.Four kinds of tickets that it can only analyze set form simply show analysis result, then can not analyze the ticket of other form.
In a word, there is following shortcoming in existing CDR inquiry system:
1, lacks versatility, can only analyze the format of billing in several predefined particular technology areas;
2, querying condition is fixed, and can not expand;
3, the limited amount of inquiry ticket is not supported the inquiry to the call bill data file of magnanimity, if support the inquiry of the call bill data file of magnanimity is then needed building of facility environment and complicated operations;
4, search efficiency is low, and speed is slower;
5, can not preserve Query Result, can only inquire about again at every turn;
6, statistics is not directly perceived, does not have graphical interfaces.
Summary of the invention
First purpose of the present invention is at the shortage versatility of above-mentioned existing CDR inquiry system existence, does not support slow, the fixing shortcoming of querying condition of inquiry, inquiry velocity to the call bill data file of magnanimity, a kind of CDR inquiry system and querying method are provided, the call bill data file of the arbitrary format of separating with separator or regular length that makes that the user can self-definedly will inquire about, and the user can be provided with the querying condition of multiple condition composite; The querying condition of the multiple condition composite that this system can be provided with the user is handled; According to handling querying condition that the back forms the call bill data file of the user-defined arbitrary format of separating with separator or regular length is inquired about; By the realization of methods such as preliminary treatment and file management the call bill data file of the magnanimity of user's appointment is inquired about fast, and do not needed building and complicated operations of facility environment.
Second purpose of the present invention is low, the slow shortcoming of search efficiency that exists at above-mentioned existing CDR inquiry system, a kind of CDR inquiry system and querying method are provided, manage to be implemented in the query script and can export the result at any time by call bill data file, thereby improve search efficiency according to user's indication to user's appointment.The shortcoming that can not preserve Query Result, can only inquire about again at every turn at above-mentioned existing CDR inquiry system existence, the present invention also can provide a kind of CDR inquiry system and querying method further, this system can preserve Query Result, makes in the inquiry afterwards and can import and export the historical query result.
According to first purpose of the present invention, the invention provides a kind of CDR inquiry system and querying method.Described CDR inquiry system comprises and is used for user's configuration or adds configuration module, CDR inquiry module, the output module of call bill data file format; Interconnect respectively between described configuration module, CDR inquiry module, the output module, single or many conditions that described CDR inquiry module is used for the configuration file preserved according to configuration module and user's input by with/or the querying condition of composition of relations inquire about after the call bill data file that will inquire about is filtered, and preserve the Query Result log file, described output module is used for the content output with the Query Result log file of described CDR inquiry module preservation; The pretreatment module that the configuration file that the CDR inquiry module of described CDR inquiry system also can comprise the input module that is used for the user input query condition further, preserve according to configuration module and the querying condition of user's input filter the call bill data file of user inquiring, and query engine module; Described input module is connected with described pretreatment module, and described pretreatment module is filtered the call bill data file that will inquire about after the querying condition of user's input of described input module record is handled in view of the above; Described pretreatment module is connected with described query engine module, and the Query Result log file is inquired about and preserved to the call bill data file after described query engine module is filtered pretreatment module; Described query engine module is connected with described output module, and described output module is exported the content of the Query Result log file that preserve described query engine module inquiry back.
Described CDR inquiry method is for inquiring about and export Query Result according to the querying condition of user's input to the call bill data file of user's appointment, it is characterized in that: the CDR inquiry module according to single or many conditions of the configuration file of preserving in the configuration module and user input by with/or the querying condition of composition of relations, inquire about after the call bill data file that will inquire about filtered, and preserve the Query Result log file; Output module is exported the content of the Query Result log file that described CDR inquiry module is preserved; Described CDR inquiry method also can specifically may further comprise the steps: at first single or many conditions that the input module of CDR inquiry module is preserved user's input in step 1 by with/or the querying condition of composition of relations, and the querying condition that the pretreatment module of CDR inquiry module is preserved according to configuration file of preserving in the configuration module and input module in step 2 filters the call bill data file of user's appointment; Call bill data file after the query engine module of CDR inquiry module is filtered pretreatment module in step 3 is then inquired about, and Query Result is kept in the Query Result log file; The content of the Query Result log file that output module output query engine module is preserved in step 4.
Described CDR inquiry method can comprise that also configuration module is kept at the format information of the call bill data file that will inquire about of user's configuration or interpolation in the configuration file, and concrete steps can be: configuration module is according to the self-defining call bill data file format information updating configuration file of user's input in step 101; Whether configuration module checks in the configuration file include file type information in step 102, is execution in step 104 then, otherwise execution in step 103; Configuration module notifies the user to add file type information to regenerate configuration file in step 103, and execution in step 102 then; Be that step 104 finishes at last.
The step 2 of described CDR inquiry method also can specifically comprise the steps: at first the form initial interrogation condition of the call bill data file that will inquire about in the configuration file that in step 201 pretreatment module of CDR inquiry module preserves according to configuration module; After the querying condition that pretreatment module is preserved the input module of CDR inquiry module in step 202 formats then, with initial querying condition merging, as the condition set of inquiry; Then the file that all meets the querying condition collection in the call bill data file that the pretreatment module search subscriber provides in step 203.Described step 203 specifically comprises: the file that all meets the querying condition collection in the call bill data file that the method search subscriber by traversal different directories and recursive search subdirectory provides.
The step 3 of described CDR inquiry method can comprise the steps: specifically also that at first the query engine module of CDR inquiry module will be filtered whole consolidation formizations of call bill data file that obtain and the small data file that is divided into user configured length through pretreatment module in step 301; The query engine module is set up the index file of this inquiry in step 302 then, and the storage address of every record in the filename of all small data file and the file is kept in the index file with set form; Then the query engine module is inquired about described index file according to user's querying condition in step 303, obtains the storage address of record corresponding in corresponding small data file name and the file; The query engine module checks in corresponding record according to the storage address that writes down in small data file name and the file in step 304 at last, and it is kept in the Query Result log file.
For realizing second purpose of the present invention, the output module of described CDR inquiry system also can comprise the file manager that can export Query Result in the user inquiring process immediately, is connected with described CDR inquiry module.The content of the Query Result log file of CDR inquiry module preservation is searched and exported to described file manager according to the Query Result record that the user selects by output module in query script.The step 4 of described CDR inquiry method also can comprise the method for file manager instant output Query Result in the user inquiring process of output module, the file manager that specifically comprises the steps: output module in step 41 is inquired about the index file that the CDR inquiry module is preserved according to the call bill data file logging that the user selects by output module, obtains the storage address of corresponding data file; File manager obtains corresponding data file according to the address of finding in step 42 then; Then file manager duplicates described data file in memory buffer in step 43; Last in step 44 content of data file in the file manager output memory buffer.Wherein also can comprise: file manager obtains the length of the data file of current output according to index file, in advance the data file of output next time is copied in the memory buffer before current end of output.
For realizing second purpose of the present invention, the output module of described CDR inquiry system also can comprise the importing module that is used to import and export the historical query result further, is connected with described configuration module with described CDR inquiry module respectively; The historical query record that described importing module is selected by output module according to the user, check according to the configuration file that configuration module is preserved whether the call bill data file format is correct, if correct then search and export the content of the data file corresponding that the CDR inquiry module preserves with the historical query record.The step 4 of described CDR inquiry method can comprise further that also the importing module of output module imports and output historical query result's method, comprises the steps: that specifically at first importing module in step 401 obtains the call bill data file format according to the historical query outcome record file that the user selects by output module; Whether according to file type information check call bill data file format in configuration file correct, be execution in step 403 then if in step 402, importing module, otherwise execution in step 405; In step 403, import the call bill data file of module then according to the correspondence of historical query outcome record file polling CDR inquiry module preservation; In step 404, import the corresponding call bill data file content of module output; Be that step 405 finishes at last.
For realizing second purpose of the present invention, the output module of described CDR inquiry system also can comprise the statistical module that is used for Query Result is carried out statistical analysis further, is connected with described CDR inquiry module; The field that will add up that described statistical module is selected by output module according to the user, this field information in the data file corresponding with the Query Result log file that collection CDR inquiry module is preserved is analyzed the back to the Information Statistics of collecting and is exported.The statistical module that the step 4 of described CDR inquiry method also can comprise output module further specifically comprises the method that Query Result carries out statistical analysis and output: at first the type that statistical module selects to carry out the field of statistical analysis according to the user by output module in step 4001 is collected the information of this field in destination file; Statistical module carries out statistical analysis to the information of collecting in step 4002 then; Statistical module output statistic analysis result in step 4003.Wherein said step 4003 can comprise: statistical module generates statistical log according to statistics.
Further, the method for described file manager instant output Query Result in the user inquiring process can specifically comprise: in query script current Query Result is carried out statistical operation according to the ticket field that the user selects.The statistical module of described output module can specifically comprise the step 4003 that Query Result carries out the method for statistical analysis and output: statistical module is judged employing pie chart or linear graph output statistic analysis result automatically according to the data type of user's needs statistics.
In addition, CDR inquiry system of the present invention also can comprise control module; Described enquiry module, described configuration module, and described output module between interconnect by described control module respectively, described control module is used for the initialization and the maintenance of each module and coordinates each module connecting each other and operating.CDR inquiry system of the present invention also can comprise maintenance module; Described maintenance module is connected with described control module, gets in touch by described control module and other each module, is used for service user interface and configuration file and recording operation daily record.
In technique scheme, by the mass tickets data file consolidation formization that will inquire about and the small data file that is divided into user configured length, and for inquire about the foundation index file corresponding at every turn with the massive data files that will inquire about, thereby make CDR inquiry system of the present invention can support the call bill data file of the arbitrary format separated with separator or regular length, and do not need to introduce database, thereby avoided building and complicated operations of facility environment; Handle by format and merging, make CDR inquiry system of the present invention can support the querying condition of multiple condition composite querying condition; Realize in query script, exporting at any time the effect of Query Result by file manager, thereby improved search efficiency; By file manager the management of data file is reduced the EMS memory occupation problem that the magnanimity inquiry is caused significantly, under lower hardware environment, can carry out the inquiry and the statistics of mass tickets efficiently; Realized preservation and output by the processing that imports module to the historical query result.To the statistical analysis of Query Result with comprise the output intent of pie chart, linear graph etc., realized exporting intuitively the effect of Query Result by statistical module.
As shown from the above technical solution, shortcomings such as the call bill data file format that CDR inquiry system of the present invention and querying method solved the inquiry do not supported in the prior art the call bill data file of magnanimity, be difficult to realize to inquire about complicated query condition, support is single, search efficiency is low, speed is slow, and statistics is difficult to preserve and statistics is not directly perceived; The versatility and the diversity of Business Processing have been realized, make the user only need carry out self-defined any call bill data file format of separating with separator or regular length, just can carry out statistical query work, thereby make the user not need installation database to carry out loaded down with trivial details data importing or the other inquiry system of developing at certain call bill data file any field; Can reach support to the call bill data file of the arbitrary format of separating with separator or regular length of magnanimity carry out quick search, support multiple condition composite querying condition, improve search efficiency, support technique effects such as Query Result are exported in historical query result's preservation and output, support intuitively.
Description of drawings
Fig. 1 is the schematic diagram of the specific embodiment one of CDR inquiry system provided by the invention;
Fig. 2 is the schematic diagram of the specific embodiment two of CDR inquiry system provided by the invention;
Fig. 3 is the schematic diagram of the specific embodiment three of CDR inquiry system provided by the invention;
Fig. 4 is the schematic diagram of the specific embodiment four of CDR inquiry system provided by the invention;
Fig. 5-the 11st, the schematic diagram of the specific embodiment of CDR inquiry method provided by the invention.
Embodiment
Below in conjunction with drawings and Examples, technical scheme of the present invention is described in further detail.
Referring to Fig. 1, be the schematic diagram of the specific embodiment of the invention one.One CDR inquiry system comprises being used for user's configuration or adding configuration module 10, CDR inquiry module 20, the output module 30 of call bill data file format.Interconnect respectively between configuration module 10, CDR inquiry module 20, the output module 30; After filtering the CDR file that will inquire about, inquires about the querying condition that CDR inquiry module 20 is used for the configuration file preserved according to configuration module 10 and user's input, and preserve the Query Result log file, output module 30 is used for the content output with the Query Result log file of CDR inquiry module 20 preservations.
Referring to Fig. 2, be the schematic diagram of the specific embodiment of the invention two.One CDR inquiry system A comprises being used for user's configuration or adding configuration module 10, CDR inquiry module 20, the output module 30 of call bill data file format.Interconnect respectively between configuration module 10, CDR inquiry module 20, the output module 30; CDR inquiry module 20 is inquired about after according to the querying condition of the configuration file of preserving in the configuration module 10 and user's input the CDR file that will inquire about being filtered, and preserve the Query Result log file, output module 30 is exported the content of the Query Result log file that CDR inquiry module 20 is preserved.Pretreatment module 50 and query engine module 40 that CDR inquiry module 20 comprises the input module 60 that is used for the user input query condition, the call bill data file of user inquiring filtered according to the querying condition of user's input.Input module 60 is connected with pretreatment module 50, and pretreatment module 50 is filtered the CDR file that will inquire about after the querying condition of user's input of input module 60 records is handled in view of the above.Pretreatment module 50 is connected with query engine module 40, and the Query Result log file is inquired about and preserved to the call bill data file after 40 pairs of pretreatment module of query engine module 50 are filtered.Query engine module 40 is connected with output module 30, and output module 30 is exported the content of the Query Result log file that preserve query engine module 40 inquiry backs.
Referring to Fig. 3, be the schematic diagram of the specific embodiment of the invention three.One CDR inquiry system B comprises being used for user's configuration or adding configuration module 10, CDR inquiry module 20, the output module 30 of call bill data file format.Interconnect respectively between configuration module 10, CDR inquiry module 20, the output module 30; CDR inquiry module 20 is inquired about according to the querying condition of the configuration file of preserving in the configuration module 10 and user's input, and output module 30 is exported the content of the Query Result log file that CDR inquiry module 20 is preserved.Pretreatment module 50 and query engine module 40 that CDR inquiry module 20 comprises the input module 60 that is used for the user input query condition, the call bill data file of user inquiring filtered according to the querying condition of user's input.Input module 60 is connected with pretreatment module 50, and pretreatment module 50 is filtered the CDR file that will inquire about after the querying condition of user's input of input module 60 records is handled in view of the above.Pretreatment module 50 is connected with query engine module 40, and the Query Result log file is inquired about and preserved to the call bill data file after 40 pairs of pretreatment module of query engine module 50 are filtered.Query engine module 40 is connected with output module 30, and output module 30 is exported the content of the Query Result log file that preserve query engine module 40 inquiry backs.Output module 30 comprises the file manager 70 that can export Query Result in the user inquiring process immediately, the statistical module 90 that is used to import and export historical query result's importing module 80 and is used for Query Result is carried out statistical analysis.File manager 70 is connected with CDR inquiry module 20; The content of the Query Result log file of CDR inquiry module 20 preservations is searched and exported to file manager 70 according to the Query Result record that the user selects by output module 30 in query script.Importing module 80 is connected with configuration module 10 with CDR inquiry module 20 respectively; Import the historical query record that module 80 is selected by output module 30 according to the user, check according to the configuration file that configuration module 10 is preserved whether the call bill data file format is correct, if correct then search and export the content of CDR inquiry module 20 data file corresponding that preserve with the historical query record.Statistical module 90 is connected with CDR inquiry module 20; The field that will add up that statistical module 90 is selected by output module 30 according to the user, this field information in the data file corresponding with the Query Result log file that collection CDR inquiry module 20 is preserved is analyzed the back to the Information Statistics of collecting and is exported.
Referring to Fig. 4, be the schematic diagram of the specific embodiment of the invention four.One CDR inquiry system C comprises being used for user configuration or adding configuration module 10, CDR inquiry module 20, output module 30, the initialization that is used for each module and the maintenance of call bill data file format and coordinate the control module 100 that each module connects each other and operate and be used for service user interface and the maintenance module 110 of configuration file and recording operation daily record; CDR inquiry module 20, configuration module 10, and output module 30 between interconnect by control module 100 respectively, control module 100 is used for the initialization and the maintenance of each module and coordinates each module connecting each other and operating, CDR inquiry module 20 is inquired about according to the querying condition of the configuration file of preserving in the configuration module 10 and user's input, and output module 30 is exported the content of the Query Result log file that CDR inquiry module 20 is preserved.Maintenance module 110 is connected with control module 100, gets in touch by control module 100 and other each module, is used for service user interface and configuration file and recording operation daily record.Pretreatment module 50 and query engine module 40 that CDR inquiry module 20 comprises the input module 60 that is used for the user input query condition, the call bill data file of user inquiring filtered according to the querying condition of user's input.Input module 60 is connected with pretreatment module 50, and pretreatment module 50 is filtered the CDR file that will inquire about after the querying condition of user's input of input module 60 records is handled in view of the above.Pretreatment module 50 is connected with query engine module 40, and the Query Result log file is inquired about and preserved to the call bill data file after 40 pairs of pretreatment module of query engine module 50 are filtered.Query engine module 40 is connected with output module 30, and output module 30 is exported the content of the Query Result log file that preserve query engine module 40 inquiry backs.Output module 30 comprises the file manager 70 that can export Query Result in the user inquiring process immediately, the statistical module 90 that is used to import and export historical query result's importing module 80 and is used for Query Result is carried out statistical analysis.File manager 70 is connected with CDR inquiry module 20; The content of the Query Result log file of CDR inquiry module 20 preservations is searched and exported to file manager 70 according to the Query Result record that the user selects by output module 30 in query script.Importing module 80 is connected with configuration module 10 with CDR inquiry module 20 respectively; Import the historical query record that module 80 is selected by output module 30 according to the user, check according to the configuration file that configuration module 10 is preserved whether the call bill data file format is correct, if correct then search and export the content of CDR inquiry module 20 data file corresponding that preserve with the historical query record.Statistical module 90 is connected with CDR inquiry module 20; The field that will add up that statistical module 90 is selected by output module 30 according to the user, this field information in the data file corresponding with the Query Result log file that collection CDR inquiry module 20 is preserved is analyzed the back to the Information Statistics of collecting and is exported.
Referring to Fig. 5, a kind of CDR inquiry method, comprise: at first single or many conditions that the input module of CDR inquiry module is preserved user's input in step 1 by with/or the querying condition of composition of relations, and the querying condition that the pretreatment module of CDR inquiry module is preserved according to input module in step 2 filters the call bill data file of user's appointment; Call bill data file after the query engine module of CDR inquiry module is filtered pretreatment module in step 3 is then inquired about, and Query Result is kept in the Query Result log file; The content of the Query Result log file that output module output query engine module is preserved in step 4.
Above-mentioned CDR inquiry method comprises that also configuration module is kept at the format information of the call bill data file that will inquire about of user's configuration or interpolation in the configuration file, referring to Fig. 6, its concrete steps are: configuration module is according to the self-defining call bill data file format information updating configuration file of user's input in step 101; Whether configuration module checks in the configuration file include file type information in step 102, is execution in step 104 then, otherwise execution in step 103; Configuration module notifies the user to add file type information to regenerate configuration file in step 103, and execution in step 102 then; Be that step 104 finishes at last.
Referring to Fig. 7, the step 2 of above-mentioned CDR inquiry method specifically comprises the steps: at first the form initial interrogation condition of the call bill data file that will inquire about in the configuration file that in step 201 pretreatment module of CDR inquiry module preserves according to configuration module; After the querying condition that pretreatment module is preserved the input module of CDR inquiry module in step 202 formats then, with initial querying condition merging, as the condition set of inquiry; Then the file that all meets the querying condition collection in the call bill data file that the pretreatment module search subscriber provides in step 203.Described step 203 specifically comprises: the file that all meets the querying condition collection in the call bill data file that the method search subscriber by traversal different directories and recursive search subdirectory provides.
Referring to Fig. 8, the step 3 of above-mentioned CDR inquiry method comprises the steps: specifically that at first the query engine module of CDR inquiry module will be filtered whole consolidation formizations of call bill data file that obtain and the small data file that is divided into user configured length through pretreatment module in step 301; The query engine module is set up the index file of this inquiry in step 302 then, and the storage address of every record in the filename of all small data file and the file is kept in the index file with set form; Then the query engine module is inquired about described index file according to user's querying condition in step 303, obtains the storage address of record corresponding in corresponding small data file name and the file; The query engine module checks in corresponding record according to the storage address that writes down in small data file name and the file in step 304 at last, and it is kept in the Query Result log file.
Referring to Fig. 9, the step 4 of above-mentioned CDR inquiry method can comprise the method for file manager instant output Query Result in the user inquiring process of output module, the file manager that specifically comprises the steps: output module in step 41 is inquired about the index file that the CDR inquiry module is preserved according to the call bill data file logging that the user selects by output module, obtains the storage address of corresponding data file; File manager obtains corresponding data file according to the address of finding in step 42 then; Then file manager duplicates described data file in memory buffer in step 43; Last in step 44 content of data file in the file manager output memory buffer.
Referring to Figure 10, the step 4 of above-mentioned CDR inquiry method can comprise that also the importing module of output module imports and output historical query result's method, comprises the steps: that specifically at first importing module in step 401 obtains the call bill data file format according to the historical query outcome record file that the user selects by output module; Whether according to file type information check call bill data file format in configuration file correct, be execution in step 403 then if in step 402, importing module, otherwise execution in step 405; In step 403, import the call bill data file of module then according to the correspondence of historical query outcome record file polling CDR inquiry module preservation; In step 404, import the corresponding call bill data file content of module output; Be that step 405 finishes at last.
Referring to Figure 11, the statistical module that the step 4 of above-mentioned CDR inquiry method also can comprise output module specifically comprises the method that Query Result carries out statistical analysis and output: at first the type that statistical module selects to carry out the field of statistical analysis according to the user by output module in step 4001 is collected the information of this field in destination file; Statistical module carries out statistical analysis to the information of collecting in step 4002 then; Statistical module output statistic analysis result in step 4003.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (20)
1. CDR inquiry system is characterized in that:
Comprise and be used for user's configuration or add configuration module, CDR inquiry module, the output module of call bill data file format;
Interconnect respectively between described configuration module, CDR inquiry module, the output module, single or many conditions that described CDR inquiry module is used for the configuration file preserved according to configuration module and user's input by with/or the querying condition of composition of relations inquire about after the call bill data file that will inquire about is filtered, and preserve the Query Result log file, described output module is used for the content output with the Query Result log file of described CDR inquiry module preservation;
Single or many conditions of the configuration file that described CDR inquiry module comprises the input module that is used for the user input query condition, preserve according to configuration module and user's input by with/or the querying condition of composition of relations pretreatment module that the call bill data file that will inquire about is filtered, and query engine module;
Described input module is connected with described pretreatment module, and described pretreatment module is filtered the call bill data file that will inquire about after the querying condition of user's input of described input module record is handled in view of the above;
Described pretreatment module is connected with described query engine module, and the Query Result log file is inquired about and preserved to the call bill data file after described query engine module is filtered pretreatment module;
Described query engine module is connected with described output module, and described output module is exported the content of the Query Result log file that preserve described query engine module inquiry back.
2. CDR inquiry system according to claim 1 is characterized in that: described output module comprises the file manager that can export Query Result in the user inquiring process immediately, is connected with described CDR inquiry module; The content of the Query Result log file of CDR inquiry module preservation is searched and exported to described file manager according to the Query Result record that the user selects by output module in query script.
3. CDR inquiry system according to claim 1 is characterized in that: described output module comprises the importing module that is used to import and export the historical query result, is connected with described configuration module with described CDR inquiry module respectively; The historical query record that described importing module is selected by output module according to the user, check according to the configuration file that configuration module is preserved whether the call bill data file format is correct, if correct then search and export the content of the data file corresponding that the CDR inquiry module preserves with the historical query record.
4. CDR inquiry system according to claim 1 is characterized in that: described output module comprises the statistical module that is used for Query Result is carried out statistical analysis, is connected with described CDR inquiry module; The field that will add up that described statistical module is selected by output module according to the user, this field information in the data file corresponding with the Query Result log file that collection CDR inquiry module is preserved is analyzed the back to the Information Statistics of collecting and is exported.
5. CDR inquiry system according to claim 1 is characterized in that: also comprise control module; Described CDR inquiry module, described configuration module, and described output module between interconnect by described control module respectively, be used for the initialization and the maintenance of each module and coordinate each module connecting each other and operating.
6. CDR inquiry system according to claim 5 is characterized in that: also comprise maintenance module; Described maintenance module is connected with described control module, gets in touch by described control module and other each module, is used for service user interface and configuration file and recording operation daily record.
7. CDR inquiry method, Query Result is inquired about and exported to querying condition according to user's input to the call bill data file of user's appointment, it is characterized in that: the CDR inquiry module according to single or many conditions of the configuration file of preserving in the configuration module and user input by with/or the querying condition of composition of relations, inquire about after the call bill data file that will inquire about filtered, and preserve the Query Result log file; Output module is exported the content of the Query Result log file that described CDR inquiry module is preserved;
May further comprise the steps:
Single or many conditions that the input module of step 1, CDR inquiry module is preserved user's input by with/or the querying condition of composition of relations;
The querying condition that the pretreatment module of step 2, CDR inquiry module is preserved according to the configuration file of preserving in the configuration module and input module filters the call bill data file of user's appointment;
Call bill data file after the query engine module of step 3, CDR inquiry module is filtered pretreatment module is inquired about, and Query Result is kept in the Query Result log file;
The content of the Query Result log file that step 4, output module output query engine module are preserved.
8. method according to claim 7 is characterized in that, configuration module is kept at the format information of the call bill data file that will inquire about of user's configuration or interpolation in the configuration file.
9. method according to claim 8 is characterized in that, may further comprise the steps:
The self-defining call bill data file format information updating configuration file that step 101, configuration module are imported according to the user;
Whether step 102, configuration module check in the configuration file include file type information, is execution in step 104 then, otherwise execution in step 103;
Step 103, configuration module notify the user to add file type information to regenerate configuration file, and execution in step 102 then;
Step 104, end.
10. according to claim 7 or 9 described methods, it is characterized in that described step 2 specifically comprises the steps:
The pretreatment module of step 201, CDR inquiry module is according to the form initial interrogation condition of the call bill data file that will inquire about in the configuration file of configuration module preservation;
After the querying condition that step 202, pretreatment module are preserved the input module of CDR inquiry module formats, merge with the initialized querying condition of process, as the condition set of inquiry;
The file that all meets the querying condition collection in the call bill data file that step 203, pretreatment module search subscriber provide.
11., it is characterized in that described step 3 specifically comprises the steps: according to claim 7 or 9 described methods
The query engine module of step 301, CDR inquiry module will be filtered whole consolidation formizations of call bill data file that obtain and the small data file that is divided into user configured length through pretreatment module;
Step 302, query engine module are set up the index file of this inquiry, and the storage address of every record in the filename of all small data file and the file is kept in the index file with set form;
Step 303, query engine module are inquired about described index file according to user's querying condition, obtain the storage address of record corresponding in corresponding small data file name and the file;
Step 304, query engine module check in corresponding record according to the storage address that writes down in small data file name and the file, and it is kept in the Query Result log file.
12., it is characterized in that described step 4 also comprises the method for file manager instant output Query Result in the user inquiring process of output module, specifically comprises the steps: according to claim 7 or 9 described methods
The file manager of step 41, output module is inquired about the index file that the CDR inquiry module is preserved according to the call bill data file logging that the user selects by output module, obtains the storage address of corresponding data file;
Step 42, file manager obtain corresponding data file according to the address of finding;
Step 43, file manager duplicate described data file in memory buffer;
The content of data file in step 44, the file manager output memory buffer.
13., it is characterized in that described step 4 comprises that also the importing module of output module imports and output historical query result's method, specifically comprises the steps: according to claim 7 or 9 described methods
Step 401, importing module obtain the call bill data file format according to the historical query outcome record file that the user selects by output module;
Whether step 402, to import module correct according to the file type information check call bill data file format in the configuration file, is execution in step 403 then, otherwise execution in step 405;
Step 403, import the call bill data file of the correspondence that module preserves according to historical query outcome record file polling CDR inquiry module;
Step 404, the corresponding call bill data file content of importing module output;
Step 405, end.
14., it is characterized in that described step 4 comprises that also the statistical module of output module to the method that Query Result carries out statistical analysis and output, specifically comprises according to claim 7 or 9 described methods:
Step 4001, statistical module are collected the information of this field in the Query Result log file by the type of the field of output module selection will carrying out statistical analysis according to the user;
Step 4002, statistical module carry out statistical analysis to the information of collecting;
Step 4003, statistical module output statistic analysis result.
15. method according to claim 10 is characterized in that, described step 203 specifically comprises: the file that all meets the querying condition collection in the call bill data file that the method search subscriber by traversal different directories and recursive search subdirectory provides.
16. method according to claim 12, it is characterized in that: described step 4 also comprises the method for file manager instant output Query Result in the user inquiring process of output module, specifically comprises the steps: in query script current Query Result to be carried out statistical operation according to the ticket field that the user selects.
17. method according to claim 12, it is characterized in that: described step 4 also comprises the method for file manager instant output Query Result in the user inquiring process of output module, comprise the steps: that specifically file manager obtains the length of the data file of current output according to index file, before current end of output, in advance the data file of output next time is copied in the memory buffer.
18. method according to claim 13 is characterized in that, described step 404 comprises: import module shows view with Query Result method output analysis result.
19. method according to claim 14 is characterized in that, described step 4003 comprises: statistical module is judged employing pie chart or linear graph output statistic analysis result automatically according to the data type of user's needs statistics.
20. method according to claim 14 is characterized in that, described step 4003 comprises: statistical module generates statistical log according to statistics.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2006100582008A CN1859505B (en) | 2006-03-10 | 2006-03-10 | Bill checking system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2006100582008A CN1859505B (en) | 2006-03-10 | 2006-03-10 | Bill checking system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1859505A CN1859505A (en) | 2006-11-08 |
| CN1859505B true CN1859505B (en) | 2010-08-25 |
Family
ID=37298366
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2006100582008A Expired - Fee Related CN1859505B (en) | 2006-03-10 | 2006-03-10 | Bill checking system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1859505B (en) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101009728A (en) * | 2007-01-09 | 2007-08-01 | 华为技术有限公司 | CDR server, match server, CDR inquiry system and CDR inquiry method |
| CN101014070B (en) * | 2007-02-01 | 2011-02-09 | 华为技术有限公司 | Processing method and processing system of user communication recording information |
| CN101562664A (en) * | 2009-05-20 | 2009-10-21 | 中兴通讯股份有限公司 | Ticket processing method and system |
| CN102054000B (en) * | 2009-10-28 | 2012-07-25 | 中国移动通信集团公司 | Data querying method, device and system |
| CN101815277A (en) * | 2010-04-29 | 2010-08-25 | 中兴通讯股份有限公司 | Method and device for statistical treatment of call bill data |
| CN102572159B (en) * | 2010-12-31 | 2014-02-26 | 中国移动通信集团安徽有限公司 | Branch call ticket processing method and system, and device |
| CN102156704A (en) * | 2011-01-26 | 2011-08-17 | 北京沃泰丰通信技术有限公司 | Method and system for filtering detailed call records |
| CN102737061B (en) * | 2011-04-14 | 2015-06-03 | 中兴通讯股份有限公司 | Distributed ticket query management system and method |
| CN104780519A (en) * | 2014-01-10 | 2015-07-15 | 中国移动通信集团四川有限公司 | Phone bill query method and system |
| US11347765B2 (en) * | 2016-10-20 | 2022-05-31 | Nippon Telegraph And Telephone Corporation | Data processing apparatus and data processing method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1409514A (en) * | 2002-09-10 | 2003-04-09 | 信息产业部通信计量中心 | Charge detector |
| CN1514634A (en) * | 2003-08-15 | 2004-07-21 | 广州市新理通信科技有限公司 | Speech sound business real time recording and analysis system and its method |
| CN1567829A (en) * | 2003-07-07 | 2005-01-19 | 中兴通讯股份有限公司 | General purpose data file conversion method |
| CN1741558A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for metering call charge |
-
2006
- 2006-03-10 CN CN2006100582008A patent/CN1859505B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1409514A (en) * | 2002-09-10 | 2003-04-09 | 信息产业部通信计量中心 | Charge detector |
| CN1567829A (en) * | 2003-07-07 | 2005-01-19 | 中兴通讯股份有限公司 | General purpose data file conversion method |
| CN1514634A (en) * | 2003-08-15 | 2004-07-21 | 广州市新理通信科技有限公司 | Speech sound business real time recording and analysis system and its method |
| CN1741558A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for metering call charge |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1859505A (en) | 2006-11-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1859505B (en) | Bill checking system and method | |
| CN101192227B (en) | Log file analytical method and system based on distributed type computing network | |
| CN101853287B (en) | Data compression quick retrieval file system and method thereof | |
| CN106982150B (en) | Hadoop-based mobile internet user behavior analysis method | |
| CN106897909B (en) | Cloud service system and method for printing and storing electronic invoices | |
| CN102902752B (en) | Method and system for monitoring log | |
| CN104714984A (en) | Database optimization method and device | |
| CN105164674A (en) | Queries involving multiple databases and execution engines | |
| CN105045905B (en) | A kind of log maintenance method and system based on full-text search | |
| CN102323940A (en) | Configuration platform implementation method, configuration platform and system based on database | |
| CN101937474A (en) | Mass data query method and device | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| CN102222112A (en) | Resource management device and resource management method | |
| CN115168396A (en) | Comprehensive intelligent platform data management method and system based on spatio-temporal system | |
| CN103106242A (en) | Phone bill query method and phone bill query system | |
| CN101431760B (en) | Method and system for implementing business report | |
| CN1617138A (en) | Data integration and analysis system and method | |
| CN202535378U (en) | Test data processing apparatus | |
| CN101706732B (en) | Method and device for dynamically loading common list | |
| CN100426301C (en) | Portal analysis system and method for implementing portal analysis service | |
| CN105630983A (en) | Resource obtaining and optimizing device and method | |
| CN101594435B (en) | Method and system for managing polyphonic service data | |
| CN201307870Y (en) | Phone bill distributed type searching engine system | |
| CN101827175A (en) | Method and system for storing sorted call bills by catalog | |
| CN103389997A (en) | Invoice information retrieval method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20180427 Address after: London, England Patentee after: GW partnership Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. Effective date of registration: 20180427 Address after: California, USA Patentee after: Global innovation polymerization LLC Address before: London, England Patentee before: GW partnership Co.,Ltd. |
|
| TR01 | Transfer of patent right | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20100825 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |