WO2003079187A1 - System and method for generating computer code to facilitate development of cdr management tools - Google Patents

System and method for generating computer code to facilitate development of cdr management tools Download PDF

Info

Publication number
WO2003079187A1
WO2003079187A1 PCT/US2003/007598 US0307598W WO03079187A1 WO 2003079187 A1 WO2003079187 A1 WO 2003079187A1 US 0307598 W US0307598 W US 0307598W WO 03079187 A1 WO03079187 A1 WO 03079187A1
Authority
WO
WIPO (PCT)
Prior art keywords
cdr
generic
raw
computer code
detail record
Prior art date
Application number
PCT/US2003/007598
Other languages
French (fr)
Inventor
Robert E. Cerami
John D. Ensminger
Douglas C. Van Natter
Original Assignee
Bellsouth Intellectual Property Corporation
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Bellsouth Intellectual Property Corporation filed Critical Bellsouth Intellectual Property Corporation
Priority to AU2003218117A priority Critical patent/AU2003218117A1/en
Publication of WO2003079187A1 publication Critical patent/WO2003079187A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code

Definitions

  • the present invention relates generally to the field of telephone switching equipment. More specifically, the present invention relates to a tool for generating computer code to facilitate development of call detail record management tools. Background of the Invention
  • a continuing problem faced by cellular telephone companies is monitoring activity on their cellular telephone networks.
  • One consequence of the inability to effectively monitor activity in the system is the possibility that unbilled or otherwise unauthorized activity can occur on the network. This can happen for a number of reasons, including stolen service through a variety of cellular fraud schemes, billing mistakes due to incorrect entry of billing information, manufacturer errors in configuring telephone switches that lead to missed billing opportunities, errors in switch operating systems and poor management that results in improper billing for used services. Detecting such lost billing opportunities requires analysis of the activity of each telephone switch in the telephone network.
  • Telephone switches in cellular telephone systems typically generate one or more call detail records (CDRs).
  • the CDRs include information related to every telephone call that the telephone switch generating the CDR has a part in handling. Exemplary information commonly found in CDRs includes information regarding the originator of the telephone call, including calling party number or a-number, and information regarding the called party, including dialed number, called number or b- number.
  • CDR information generally includes the time the call was made, the duration of the call, the status of the call or termination code and any other desired information regarding a telephone call captured by the switch.
  • CDRs generated by switches manufactured by different manufacturers usually have different structures. For example, some switch manufacturers provide switches that use the same CDR structure for every telephone call handled by the switch. Other switch manufacturers provide switches that generate CDRs having different structures based on the type of telephone call. Differences in CDR structures can also exist in CDRs generated by different switches manufactured by the same manufacturer. For example, different CDR structures may be used for telephone calls originating on land-line telephones, telephone calls originating on cellular telephones, telephone calls terminating on land-line telephones and telephone calls terminating on cellular telephones.
  • the present invention solves the foregoing problems in the art associated with developing new tools to process call detail records (CDRs) generated by telephone switches in cellular telephone networks by providing a system and method for generating computer software that can access CDR information output by a switch and can format that information for storage in a generic CDR that can be used to facilitate development of new CDR processing tools.
  • the present invention can generate computer code to output information stored in a generic CDR in a raw CDR format. That is, the data stored in a generic CDR format can be output for storage in the same format that it was originally stored in when generated by a telephone switch.
  • the present invention is a method for generating computer code that facilitates development of call detail record management tools.
  • the method includes the steps of opening a computer code file to store generated computer code.
  • a structure of a generic call detail record comprising a plurality of fields is read.
  • a function header is written to the computer code file.
  • the method includes the step of generating a code segment. Each code segment generated is written to the computer code file.
  • the computer code file is closed.
  • the present invention is a system for generating computer code to facilitate development of call detail record management tools.
  • the system comprises a generic call detail record format and at least one raw call detail record format.
  • the raw call detail record formats correspond to raw call detail record formats that are to be encapsulated by the generic call detail record.
  • a call detail record code generation tool inputs the raw call detail record format and the generic call detail record format.
  • the call detail record generation tool generates computer code that will build a generic call detail record using the at least one raw call detail record format.
  • the system includes a file to store computer code that populates a generic call detail record format using data stored in at least one raw call detail record when executed.
  • FIG. 1 A is an exemplary proprietary CDR structure as might be in the prior art.
  • FIG. IB is another exemplary proprietary CDR structure as might be in the prior art.
  • FIG. 1C is an exemplary generic CDR structure according to an embodiment of the present invention.
  • FIG. 2A is an exemplary raw CDR structure that incorporates preprocessor directives to conserve computer memory according to an embodiment of the present invention.
  • FIG. 2B is another exemplary raw CDR structure that incorporates preprocessor directives to conserve computer memory according to an embodiment of the present invention.
  • FIG. 2C is an exemplary generic CDR structure that uses preprocessor directives to conserve computer memory according to an embodiment of the present invention.
  • FIG. 1 A is an exemplary proprietary CDR structure as might be in the prior art.
  • FIG. IB is another exemplary proprietary CDR structure as might be in the prior art.
  • FIG. 1C is an exemplary generic CDR structure according to an embodiment of the present invention.
  • FIG. 2A is an exemplary raw CDR structure that incorporates pre
  • FIG. 3 is a flow chart for generating computer code to create a generic CDR according to an embodiment of the present invention.
  • FIG. 4 is a schematic diagram for a system for generating computer code to build a generic CDR from data stored in raw CDRs and to recover raw CDRs from data stored in a generic CDR.
  • FIG. 5A is a flow chart for a method for generating computer code to populate a generic CDR with data from one or more raw CDRs according to an embodiment of the present invention.
  • FIG. 5B is a flow chart for a method for generating computer code to populate a raw CDR with data from a generic CDR according to an embodiment of the present invention.
  • FIG. 6 is exemplary computer code to build a generic CDR from raw CDRs as generated by an embodiment of the present invention.
  • FIG. 7 is exemplary computer code to recover a raw CDR from a generic
  • CDRs Call detail records generated by a telephone switch are generally stored to tape or disk in a raw CDR format.
  • the CDR raw format is a binary format that is proprietary to each switch manufacturer.
  • the variation in CDR structures and storage formats complicates writing general software to manage CDRs. Consequently, according to an embodiment of the present invention, a generic CDR structure is used.
  • a generic CDR encapsulates one or more raw CDRs.
  • the generic CDR structure facilitates development of new CDR management and processing techniques by relieving the developer from writing specific code to handle the many different raw CDR structures that exist.
  • the use of the generic CDR structure allows the developer to concentrate on the development of a CDR management technique rather than the details of accessing CDR data.
  • a generic CDR structure is a data structure that has a field corresponding to every field that can be present in any CDR produced by a switch of any one manufacturer.
  • the generic CDR structure can have a field corresponding to every field that can be present in any CDR produced by a switch of any manufacturer. That is, the generic CDR structure encapsulates the data found in one or more raw CDRs. During the process of converting one or more raw CDRs to a generic CDR, any field in the generic CDR that is not present in the raw CDR being converted is left blank or populated with a dummy value to indicate it is not a real value.
  • the generic CDR structure is updated to reflect any changes in any CDR structure from the switch manufacturer for example, new versions of CDRs.
  • FIG. 1 A is an exemplary CDR data structure 102 for a conventional raw CDR generated by a switch.
  • FIG. IB is an exemplary CDR data structure 104 for another conventional raw CDR that can be generated by the same switch.
  • FIG. IC illustrates a generic CDR structure 106 that is generated from the raw CDRs of FIGs. 1 A and IB according to an embodiment of the present invention. As can be seen generic CDR structure 106 has a field corresponding to every field that is found in either one of CDR structures 102 and 104.
  • type conversions may be made where required for compatibility with the generic CDR structure.
  • the recnu field is an array of bytes in the CDR structure 102.
  • This data type is converted to an "int" data type in generic CDR structure 106.
  • the computer code generated by the present invention automatically includes calls to the appropriate conversion functions. Methods for performing any required data type conversions are well known to those skilled in the art. If no conversions are needed, the generated code comprises a memcpyO or variable assignment.
  • raw CDR structure 202 shown in FIG. 2 A illustrates a situation where a manufacturer increases the length of the "date" field in a second version of one of its switches.
  • Raw CDR structure 202 illustrates a situation where the manufacturer added a "location" field in the second version of the switch.
  • preprocessor directives can be used. For example, memory efficiency can be enhanced using the #ifdef preprocessor directive when defining the generic CDR structure. Using the #ifdef preprocessor directive allows tailoring of the generic CDR structure to use only the memory required to encapsulate the CDRs generated by a particular switch version.
  • a generic CDR 205 (shown in FIG. 2C) is built using both raw CDR structures 202 and 204. Moreover, the present invention intelligently determines which fields are common to each version of the switch and which fields are unique to any version. Generic CDR 205 uses the #ifdef preprocessor directive to make more efficient use of the computer memory when declaring a generic CDR. Generic CDR 205 includes a common portion 206 and two unique portions 208 and 210. Common portion 206 is found in each version of structures 202 and 204. Specific portion 208 corresponds to the portion of raw CDR structures 202 and 204 unique to version 1 of the switch. Specific portion 210 corresponds to the portion of raw CDR structures 202 and 204 that is unique to version 2 of the switch.
  • #ifdef preprocessor directive is illustrated by the flow chart of FIG. 3. Processing begins in step 301.
  • a generic CDR structure is read in step 302. This structure may be empty , in which case it will be created by this tool, or it may be created manually, or it may have been created during a previous use of this tool. Even if created by a previous use of this tool, it may be manually modified to change data types.
  • the raw CDR structures of the CDRs that are to be encapsulated by the generic CDR are read in step 304.
  • step 306 a common portion among the read raw CDR structures is determined, if one exists. If a common portion is found, the common portion is added to the generic CDR in step 308.
  • the generic CDR comprises a group of CDR fields that is common to each of the raw CDR structures that the generic CDR structure will encapsulate.
  • step 310 the non-common portion of the selected raw CDR structure is added to the generic CDR structure offset by #ifdef or #elif defined() preprocessor directives in step 312.
  • the preprocessor directive #ifdef is used if the raw CDR is the first CDR, otherwise the #elif preprocessor directive is used to offset the non- common portion of the raw CDR structure.
  • step 314 it is determined whether there are additional raw CDR structures to process. If there are additional raw CDR structures, processing continues in step 310 where another raw CDR structure is selected for processing.
  • step 315 If there are no additional raw CDRs, an #endif compiler directive is inserted in the generic CDR structure in step 315.
  • the generic CDR structure is saved in step 316 and the method ends in step 317.
  • #ifdef preprocessor directive More complex generic CDRs that can be created using the #ifdef preprocessor directive would also fall within the scope and spirit of the present invention.
  • #ifdefs can be inserted into the generic CDR structure as required to handle interspersed differences between the raw CDR structures.
  • a generic CDR as described by the above processes can be generated either manually or automatically from the raw CDR data structures according to the method described above.
  • An automatically generated generic CDR may be modified to change the data types of some fields. When this is done the tool will have to be rerun to properly generate the conversion code.
  • the present invention generates source code that can access and extract the actual data from one or more raw CDRs generated by cellular telephone switches.
  • the raw CDRs are stored on a storage device such as a disk.
  • the generated source code extracts the data from one or more raw CDRs and stores it in a variable having the data structure of the generic CDR.
  • FIG. 4 is a schematic illustration of a system for generating computer code to assist in the development of CDR management tools according to an embodiment of the present invention.
  • a CDR computer code generation tool 402 inputs a raw CDR format 404 and a generic CDR format 406.
  • the terms structure and format are used interchangeably to indicate any format for a generic call detail record or a raw call detail record.
  • exemplary raw CDR formats are illustrated by the computer structure definitions 102, 104, 203 and 204.
  • Exemplary generic CDR formats are illustrated by the computer structure definitions shown in FIGs. 202 and 205.
  • Generic CDR format 406 is designed to encapsulate raw CDR format 404.
  • CDR code generation tool 402 uses the input raw CDR format and the generic CDR format to generate CDR build code 408 and CDR recover code 410.
  • CDR build code 408 is used to build a generic CDR from information stored in a raw CDR.
  • CDR recover code 410 is used to recover a raw CDR from data stored in a generic CDR.
  • a method for generating computer code to populate a generic CDR using data from one or more raw CDRs or to recover a raw CDR from data in the generic CDR structure is provided in the flow charts of FIGs. 5 A and 5B.
  • the method proceeds in two passes.
  • the first pass illustrated in the flow chart of FIG. 5A.
  • the first pass of the method generates BuildCDR functionality.
  • the BuildCDR function is computer code that, when executed, populates a generic CDR using data read from one or more previously stored raw CDRs.
  • the second pass generates RecoverCDR functionality.
  • the RecoverCDR function is computer code that, when executed, recreates a raw CDR for a particular switch CDR format using data stored in a generic CDR.
  • pass 2 is executed immediately after pass 1.
  • each pass is executed separately and independently of the time of execution of the other pass.
  • FIG. 5A is a flow chart for a method for generating BuildCDR functionality to populate a generic CDR with data from one or more raw CDRs.
  • the method begins in step 501.
  • a computer code file is opened in step 502.
  • the computer code file is used to store the computer code generated by the method described in FIGs. 5A and 5B.
  • a generic CDR structure is read.
  • the name, type and size of each field in the generic CDR structure is stored in computer memory.
  • a raw CDR data structure is identified.
  • the generic and one or more raw CDR structures are stored in header file.
  • the header file is opened and the data required to complete steps 503 and 504 is read.
  • the header file is configured such that the generic CDR structure is first.
  • a function header is generated and stored to the computer code file.
  • the function header is the function header for a BuildCDR function.
  • a form for the BuildCDR function header according to one embodiment of the present invention is "void BuildCDR (CDR_typel *rawCDR)", where CDR typel indicates CDR type, for example, switch version and rawCDR is a pointer to a data structure defined according the CDR version.
  • CDR_typel *rawCDR CDR_typel *rawCDR
  • CDR typel indicates CDR type, for example, switch version
  • rawCDR is a pointer to a data structure defined according the CDR version.
  • a field of a raw CDR is read. The field can be read from the header file or from memory if the raw CDR is stored in memory when it is identified in step 504.
  • the read field is compared to the fields in the generic CDR structure to determine if it is a new field.
  • a new field is a field that is not already present in the generic CDR structure. If the field is a new field, the method continues in step 516, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be stored in the corresponding generic CDR field. Preferably, the method continues in step 513 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later. If the read raw CDR field is not new, the method continues in step 514 with the step of determining whether the field is identical to a field in the generic CDR. Two fields are identical if they have the same name, data type and size.
  • step 516 the method continues in step 516, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be copied to the corresponding generic CDR field. Copying in this instance is accomplished using either a variable assignment or memcpy() function.
  • step 513 the step of writing the computer code so generated to the computer code file.
  • the generated computer code is stored in memory and written to the computer code file later.
  • the method continues in step 518 with the step of determining whether the field is compatible with a field in the generic CDR. A field is compatible with another field if its data type can be converted to match the data type of the other field. If the read raw CDR field is compatible with a field in the generic CDR, the method continues in step 520, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be converted to the compatible generic CDR field.
  • the computer code generated is a function call to computer code that will perform the actual conversion. As described above, it would be apparent to those skilled in the art how to write such conversion code.
  • the method continues in step 513 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
  • step 522 If the read field is not compatible, then the method continues in step 522 with the step of generating an error message.
  • the error message indicates, that the read raw CDR field was not new, nor identical nor compatible with any field in the generic CDR structure indicating that it requires special consideration.
  • step 524 by determining whether the end of the raw CDR structure being processed has been reached. For example, when using C or C++, the end of the structure is reached upon encountering a " ⁇ ". If the end of the raw CDR structure has not been reached, the method continues in step 508, by reading the next field of the raw CDR structure.
  • step 526 the method optionally continues in step 526 with the generation of a return statement that is written to the computer code file. Whether performing step 526 or not, the method continues in step 528 by determining whether there is another raw CDR structure to process. If there are additional raw CDR structures to process, the method continues in step 504 by identifying the next raw CDR structure to process. If there are no more raw CDR structures to process, the method ends pass 1 in step 530. Optionally, at this point, the method can close the computer code file. However, it is preferably left open for use in the second pass.
  • FIG. 5B is a flow chart for a method for generating RecoverCDR functionality to populate a generic CDR with data from one or more raw CDRs.
  • the flow chart illustrated in FIG. 5B is executed as the second pass of the method described above.
  • the second pass of the method begins in step 550. If the computer code file was closed at the end of the first pass, it is opened. Preferably, however, the computer code file is not closed at the end of the first pass, and the second pass is initiated immediately upon completion of the first pass.
  • a generic CDR structure is read.
  • the name, type and size of each field in the generic CDR structure is stored in computer memory.
  • a raw CDR data structure is identified.
  • the generic and one or more raw CDR structures are stored in header file.
  • the header file is opened and the data required to complete steps 553 and 554 is read.
  • the header file is configured such that the generic CDR structure is first.
  • a function header is generated and stored to the computer code file.
  • the function header is the function header for a RecoverCDR function.
  • a form for the RecoverCDR function header according to one embodiment of the present invention is the form "void RecoverCDR (CDR_typel *rawCDR)", where CDR_typel indicates CDR type, for example, switch version and rawCDR is a pointer to a data structure defined according the CDR version.
  • CDR_typel indicates CDR type, for example, switch version
  • rawCDR is a pointer to a data structure defined according the CDR version.
  • a field of a raw CDR is read. The field can be read from the header file or from memory if the raw CDR is stored in memory when it is identified in step 554.
  • step 560 the read field is compared to the fields in the generic CDR structure to determine if it is a new field.
  • a new field is a field that is not already present in the generic CDR structure. If the field is a new field, the method continues in step 566, with the step of generating computer code that, when executed, will cause data stored in the corresponding generic CDR field to be stored in the raw CDR field.
  • the method continues in step 563 with the step of writing the computer code so generated to the computer code file.
  • the generated computer code is stored in memory and written to the computer code file later.
  • step 564 the method continues in step 564 with the step of determining whether the field is identical to a field in the generic CDR. Two fields are identical if they have the same name, data type and size. If the fields are identical, the method continues in step 566, with the step of generating computer code that, when executed, will cause data stored in the corresponding generic CDR field to be copied to the raw CDR field. Copying in this instance is accomplished using either a variable assignment or memcpy() function.
  • step 563 the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
  • the method continues in step 518 with the step of determining whether the field is compatible with a field in the generic CDR. A field is compatible with another field if its data type can be converted to match the data type of the other field. If the read raw CDR field is compatible with a field in the generic CDR, the method continues in step 570, with the step of generating computer code that, when executed, will cause data stored in the compatible generic CDR field to be converted to the raw CDR field.
  • the computer code generated is a function call to computer code that will perform the actual conversion. As described above, it would be apparent to those skilled in the art how to write such conversion code.
  • the method continues in step 563 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
  • step 572 If the read field is not compatible, then the method continues in step 572 with the step of generating an error message.
  • the error message indicates, that the read raw CDR field was not new, nor identical nor compatible with any field in the generic CDR structure indicating that it requires special consideration.
  • step 574 After the generated code segment has been written in step 563, or alternatively stored in memory or an error message is generated in step 572, the method continues processing in step 574 by determining whether the end of the raw CDR structure being processed has been reached. For example, when using C or C++, the end of the structure is reached upon encountering a " ⁇ ". If the end of the raw CDR structure has not been reached, the method continues in step 558, by reading the next field of the raw CDR structure.
  • step 576 the method optionally continues in step 576 with the generation of a return statement that is written to the computer code file. Whether performing step 576 or not, the method continues in step 578 by determining whether there is another raw CDR structure to process. If there are additional raw CDR structures to process, the method continues in step 554 by identifying the next raw CDR structure to process. If there are no more raw CDR structures to process, ends the second pass in step 582.
  • the computer code file can be closed at this point. However, preferably additional processing can be performed upon completion of the second pass prior to closing the computer code file. Specifically, at the end of the second pass, a revised generic CDR is generated and written to the computer code file.
  • the revised generic CDR is generated by printing the type, size, and name information for each field found in the original generic CDR and those that were added by processing the raw CDR structures in the first pass. Further, in one embodiment of the present invention, the type, size, and name information from the revised generic CDR is printed to the computer code file in a format that is compatible with the structure used by a CDR viewing tool. At this point the computer code file is closed.
  • the CDR viewing tool uses this information to permit a user to select what fields to view and to determine the best format for displaying this information.
  • preprocessor directives are found that are not specifically recognized, these preprocessor directives are duplicated in the output file at the point at which they are encountered. For example, if a portion of the raw CDR is optional (based on some condition that can be determined at compile time), the code to copy or convert these fields will be optional based on the same conditions.
  • FIG. 6 is exemplary CDR build code that is generated by CDR code generator tool 402.
  • the computer code that is generated builds a generic CDR using the data from a raw CDR.
  • the data stored in the raw CDR is obtained earlier by opening a CDR data file that was generated by a switch, and storing the data contained therein. Therefore, the variable "rawCDR” is defined prior to the code generation shown in FIG. 6. That is, the variable "rawCDR" is defined and initialized prior to the BuildCDR function, illustrated in FIG. 6, being invoked.
  • "rawCDR" is passed as a parameter to BuildCDR, which uses the data contained therein to populate the generic CDR.
  • FIG. 6 also illustrates the use of the function overload feature available in many programming languages.
  • the function name BuildCDR can be reused, so long as the proper parameters are passed to each function.
  • the function BuildCDR is overloaded so that it can build generic CDRs for typel and type 2 CDRs.
  • the particular function that will be invoked at runtime depends on whether the function is called with a pointer to a CDR TYPE1 or a CDR TYPE2 structure.
  • CDR code generation tool 402 accesses a set of built in conversion rules to obtain the code segments required to create the BuildCDR function that it generates. If any data type conversions are required, subroutines to perform the conversions are referenced in the computer code segments. For example, the subroutines "cnv()" and “Convert_Time()" are used to perform data type conversions on the data of the raw CDR to store in the generic CDR.
  • CDR code generation tool 402 also generates code that converts a generic
  • FIG. 7 is exemplary code that is generated by CDR code generator tool 402 to recover a raw CDR using the data stored in a generic CDR.
  • FIG. 7 illustrates the use of the function overload feature of many programming languages.
  • the function name RecoverCDR can be reused, so long as the proper parameters are passed to each function.
  • the function RecoverCDR is overloaded so that it can recover raw CDRs for two CDR types from a generic CDR.
  • the particular function that will be invoked at runtime depends on whether a pointer to a CDR TYPE1 or a CDR TYPE2 structure is used.
  • subroutines to perform the reverse conversions are referenced in the computer code segment. For example, subroutines "uncnv()" and "UnConvertTimeO" are used to convert parameters back to the data types for storage in the raw CDR.

Abstract

A computer code generation tool (402) generates computer code (408) to facilitate development of call detail record (CDR) management tools. The computer code generation tool (402) inputs one or more raw CDR structures (404) and creates a generic CDR structure therefrom. Given a generic CDR tool (406) computer to read data from the raw CDR(s) stored on disk and store that data generate raw CDRs from the data stored in the generic CDR.

Description

SYSTEM AND METHOD FOR GENERATING COMPUTER CODE TO FACILITATE DEVELOPMENT OF CDR MANAGEMENT TOOLS
BACKGROUND
Field of the Invention
[0001] The present invention relates generally to the field of telephone switching equipment. More specifically, the present invention relates to a tool for generating computer code to facilitate development of call detail record management tools. Background of the Invention
[0002] A continuing problem faced by cellular telephone companies is monitoring activity on their cellular telephone networks. One consequence of the inability to effectively monitor activity in the system is the possibility that unbilled or otherwise unauthorized activity can occur on the network. This can happen for a number of reasons, including stolen service through a variety of cellular fraud schemes, billing mistakes due to incorrect entry of billing information, manufacturer errors in configuring telephone switches that lead to missed billing opportunities, errors in switch operating systems and poor management that results in improper billing for used services. Detecting such lost billing opportunities requires analysis of the activity of each telephone switch in the telephone network.
[0003] Telephone switches in cellular telephone systems typically generate one or more call detail records (CDRs). The CDRs include information related to every telephone call that the telephone switch generating the CDR has a part in handling. Exemplary information commonly found in CDRs includes information regarding the originator of the telephone call, including calling party number or a-number, and information regarding the called party, including dialed number, called number or b- number. In addition, CDR information generally includes the time the call was made, the duration of the call, the status of the call or termination code and any other desired information regarding a telephone call captured by the switch.
[0004] CDRs generated by switches manufactured by different manufacturers usually have different structures. For example, some switch manufacturers provide switches that use the same CDR structure for every telephone call handled by the switch. Other switch manufacturers provide switches that generate CDRs having different structures based on the type of telephone call. Differences in CDR structures can also exist in CDRs generated by different switches manufactured by the same manufacturer. For example, different CDR structures may be used for telephone calls originating on land-line telephones, telephone calls originating on cellular telephones, telephone calls terminating on land-line telephones and telephone calls terminating on cellular telephones.
[0005] Managing the large amount of information contained in CDRs efficiently requires development of new software CDR management tools. These management tools will be able to use the information in the CDRs to help better understand the dynamics of the cellular telephone system. The management tools have to access the CDRs produced by the switches in the cellular telephone system. Consequently, software that allows access of the CDRs has to be written for each new management tool. However, writing new software to access the information stored by cellular telephone switches for each new management tool that is developed is an inefficient process that is prone to error. SUMMARY OF THE INVENTION
[0006] The present invention solves the foregoing problems in the art associated with developing new tools to process call detail records (CDRs) generated by telephone switches in cellular telephone networks by providing a system and method for generating computer software that can access CDR information output by a switch and can format that information for storage in a generic CDR that can be used to facilitate development of new CDR processing tools. In addition, the present invention can generate computer code to output information stored in a generic CDR in a raw CDR format. That is, the data stored in a generic CDR format can be output for storage in the same format that it was originally stored in when generated by a telephone switch.
[0007] In one embodiment, the present invention is a method for generating computer code that facilitates development of call detail record management tools. The method includes the steps of opening a computer code file to store generated computer code. A structure of a generic call detail record comprising a plurality of fields is read. A function header is written to the computer code file. Then for each field in the generic call detail record the method includes the step of generating a code segment. Each code segment generated is written to the computer code file. The computer code file is closed.
[0008] In another embodiment, the present invention is a system for generating computer code to facilitate development of call detail record management tools. The system comprises a generic call detail record format and at least one raw call detail record format. The raw call detail record formats correspond to raw call detail record formats that are to be encapsulated by the generic call detail record. A call detail record code generation tool inputs the raw call detail record format and the generic call detail record format. The call detail record generation tool generates computer code that will build a generic call detail record using the at least one raw call detail record format. Further, the system includes a file to store computer code that populates a generic call detail record format using data stored in at least one raw call detail record when executed.
BRIEF DESCRIPTION OF THE DRAWINGS
[0009] FIG. 1 A is an exemplary proprietary CDR structure as might be in the prior art. [0010] FIG. IB is another exemplary proprietary CDR structure as might be in the prior art. [0011] FIG. 1C is an exemplary generic CDR structure according to an embodiment of the present invention. [0012] FIG. 2A is an exemplary raw CDR structure that incorporates preprocessor directives to conserve computer memory according to an embodiment of the present invention. [0013] FIG. 2B is another exemplary raw CDR structure that incorporates preprocessor directives to conserve computer memory according to an embodiment of the present invention. [0014] FIG. 2C is an exemplary generic CDR structure that uses preprocessor directives to conserve computer memory according to an embodiment of the present invention. [0015] FIG. 3 is a flow chart for generating computer code to create a generic CDR according to an embodiment of the present invention. [0016] FIG. 4 is a schematic diagram for a system for generating computer code to build a generic CDR from data stored in raw CDRs and to recover raw CDRs from data stored in a generic CDR. [0017] FIG. 5A is a flow chart for a method for generating computer code to populate a generic CDR with data from one or more raw CDRs according to an embodiment of the present invention. [0018] FIG. 5B is a flow chart for a method for generating computer code to populate a raw CDR with data from a generic CDR according to an embodiment of the present invention. [0019] FIG. 6 is exemplary computer code to build a generic CDR from raw CDRs as generated by an embodiment of the present invention. [0020] FIG. 7 is exemplary computer code to recover a raw CDR from a generic
CDR as generated by an embodiment of the present invention.
DETAILED DESCRIPTION OF THE INVENTION
[0021] Call detail records (CDRs) generated by a telephone switch are generally stored to tape or disk in a raw CDR format. Typically, the CDR raw format is a binary format that is proprietary to each switch manufacturer. The variation in CDR structures and storage formats complicates writing general software to manage CDRs. Consequently, according to an embodiment of the present invention, a generic CDR structure is used. As described in more detail below, a generic CDR encapsulates one or more raw CDRs. The generic CDR structure facilitates development of new CDR management and processing techniques by relieving the developer from writing specific code to handle the many different raw CDR structures that exist. Thus, the use of the generic CDR structure allows the developer to concentrate on the development of a CDR management technique rather than the details of accessing CDR data.
[0022] According to an embodiment of the present invention, a generic CDR structure is a data structure that has a field corresponding to every field that can be present in any CDR produced by a switch of any one manufacturer. In an alternative embodiment of the present invention, the generic CDR structure can have a field corresponding to every field that can be present in any CDR produced by a switch of any manufacturer. That is, the generic CDR structure encapsulates the data found in one or more raw CDRs. During the process of converting one or more raw CDRs to a generic CDR, any field in the generic CDR that is not present in the raw CDR being converted is left blank or populated with a dummy value to indicate it is not a real value. The generic CDR structure is updated to reflect any changes in any CDR structure from the switch manufacturer for example, new versions of CDRs.
[0023] FIG. 1 A is an exemplary CDR data structure 102 for a conventional raw CDR generated by a switch. FIG. IB is an exemplary CDR data structure 104 for another conventional raw CDR that can be generated by the same switch. FIG. IC illustrates a generic CDR structure 106 that is generated from the raw CDRs of FIGs. 1 A and IB according to an embodiment of the present invention. As can be seen generic CDR structure 106 has a field corresponding to every field that is found in either one of CDR structures 102 and 104.
[0024] In addition, type conversions may be made where required for compatibility with the generic CDR structure. For example, the recnu field is an array of bytes in the CDR structure 102. This data type is converted to an "int" data type in generic CDR structure 106. If conversion is necessary, as described below, the computer code generated by the present invention automatically includes calls to the appropriate conversion functions. Methods for performing any required data type conversions are well known to those skilled in the art. If no conversions are needed, the generated code comprises a memcpyO or variable assignment.
[0025] Switch manufacturers occasionally make changes to CDR definitions through new releases of their switch software. For example, raw CDR structure 202 shown in FIG. 2 A illustrates a situation where a manufacturer increases the length of the "date" field in a second version of one of its switches. Raw CDR structure 202 illustrates a situation where the manufacturer added a "location" field in the second version of the switch.
[0026] To accommodate such changes efficiently and to preserve computer memory, preprocessor directives can be used. For example, memory efficiency can be enhanced using the #ifdef preprocessor directive when defining the generic CDR structure. Using the #ifdef preprocessor directive allows tailoring of the generic CDR structure to use only the memory required to encapsulate the CDRs generated by a particular switch version.
[0027] A generic CDR 205 (shown in FIG. 2C) is built using both raw CDR structures 202 and 204. Moreover, the present invention intelligently determines which fields are common to each version of the switch and which fields are unique to any version. Generic CDR 205 uses the #ifdef preprocessor directive to make more efficient use of the computer memory when declaring a generic CDR. Generic CDR 205 includes a common portion 206 and two unique portions 208 and 210. Common portion 206 is found in each version of structures 202 and 204. Specific portion 208 corresponds to the portion of raw CDR structures 202 and 204 unique to version 1 of the switch. Specific portion 210 corresponds to the portion of raw CDR structures 202 and 204 that is unique to version 2 of the switch.
[0028] A method for generating a generic CDR structure that incorporates using the
#ifdef preprocessor directive is illustrated by the flow chart of FIG. 3. Processing begins in step 301. A generic CDR structure is read in step 302. This structure may be empty , in which case it will be created by this tool, or it may be created manually, or it may have been created during a previous use of this tool. Even if created by a previous use of this tool, it may be manually modified to change data types. The raw CDR structures of the CDRs that are to be encapsulated by the generic CDR are read in step 304. In step 306, a common portion among the read raw CDR structures is determined, if one exists. If a common portion is found, the common portion is added to the generic CDR in step 308. After completion of step 308, the generic CDR comprises a group of CDR fields that is common to each of the raw CDR structures that the generic CDR structure will encapsulate.
[0029] In step 310, the non-common portion of the selected raw CDR structure is added to the generic CDR structure offset by #ifdef or #elif defined() preprocessor directives in step 312. The preprocessor directive #ifdef is used if the raw CDR is the first CDR, otherwise the #elif preprocessor directive is used to offset the non- common portion of the raw CDR structure. In step 314, it is determined whether there are additional raw CDR structures to process. If there are additional raw CDR structures, processing continues in step 310 where another raw CDR structure is selected for processing.
[0030] If there are no additional raw CDRs, an #endif compiler directive is inserted in the generic CDR structure in step 315. The generic CDR structure is saved in step 316 and the method ends in step 317.
[0031] More complex generic CDRs that can be created using the #ifdef preprocessor directive would also fall within the scope and spirit of the present invention. For example, #ifdefs can be inserted into the generic CDR structure as required to handle interspersed differences between the raw CDR structures.
[0032] A generic CDR as described by the above processes can be generated either manually or automatically from the raw CDR data structures according to the method described above. An automatically generated generic CDR may be modified to change the data types of some fields. When this is done the tool will have to be rerun to properly generate the conversion code. [0033] While the generic CDR structure is being created, as described below, the present invention generates source code that can access and extract the actual data from one or more raw CDRs generated by cellular telephone switches. Preferably, the raw CDRs are stored on a storage device such as a disk. The generated source code extracts the data from one or more raw CDRs and stores it in a variable having the data structure of the generic CDR.
[0034] FIG. 4 is a schematic illustration of a system for generating computer code to assist in the development of CDR management tools according to an embodiment of the present invention. A CDR computer code generation tool 402 inputs a raw CDR format 404 and a generic CDR format 406. In the present description, the terms structure and format are used interchangeably to indicate any format for a generic call detail record or a raw call detail record. For example, exemplary raw CDR formats are illustrated by the computer structure definitions 102, 104, 203 and 204. Exemplary generic CDR formats are illustrated by the computer structure definitions shown in FIGs. 202 and 205.
[0035] Generic CDR format 406 is designed to encapsulate raw CDR format 404.
Using the input raw CDR format and the generic CDR format, CDR code generation tool 402 generates CDR build code 408 and CDR recover code 410. As described below, CDR build code 408 is used to build a generic CDR from information stored in a raw CDR. As described below, CDR recover code 410 is used to recover a raw CDR from data stored in a generic CDR.
[0036] A method for generating computer code to populate a generic CDR using data from one or more raw CDRs or to recover a raw CDR from data in the generic CDR structure is provided in the flow charts of FIGs. 5 A and 5B. Preferably, the method proceeds in two passes. The first pass, illustrated in the flow chart of FIG. 5A. The first pass of the method generates BuildCDR functionality. The BuildCDR function is computer code that, when executed, populates a generic CDR using data read from one or more previously stored raw CDRs. The second pass generates RecoverCDR functionality. The RecoverCDR function is computer code that, when executed, recreates a raw CDR for a particular switch CDR format using data stored in a generic CDR. Preferably, pass 2 is executed immediately after pass 1. However, in an alternate embodiment of the present invention, each pass is executed separately and independently of the time of execution of the other pass.
[0037] FIG. 5A is a flow chart for a method for generating BuildCDR functionality to populate a generic CDR with data from one or more raw CDRs. The method begins in step 501. A computer code file is opened in step 502. The computer code file is used to store the computer code generated by the method described in FIGs. 5A and 5B.
[0038] In step 503, a generic CDR structure is read. The name, type and size of each field in the generic CDR structure is stored in computer memory. In step 504, a raw CDR data structure is identified. Preferably, the generic and one or more raw CDR structures are stored in header file. The header file is opened and the data required to complete steps 503 and 504 is read. In addition, preferably, the header file is configured such that the generic CDR structure is first.
[0039] In step 506, a function header is generated and stored to the computer code file. In the first pass, the function header is the function header for a BuildCDR function. A form for the BuildCDR function header according to one embodiment of the present invention is "void BuildCDR (CDR_typel *rawCDR)", where CDR typel indicates CDR type, for example, switch version and rawCDR is a pointer to a data structure defined according the CDR version. In step 508, a field of a raw CDR is read. The field can be read from the header file or from memory if the raw CDR is stored in memory when it is identified in step 504. In step 510, the read field is compared to the fields in the generic CDR structure to determine if it is a new field. A new field is a field that is not already present in the generic CDR structure. If the field is a new field, the method continues in step 516, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be stored in the corresponding generic CDR field. Preferably, the method continues in step 513 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later. If the read raw CDR field is not new, the method continues in step 514 with the step of determining whether the field is identical to a field in the generic CDR. Two fields are identical if they have the same name, data type and size. If the fields are identical, the method continues in step 516, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be copied to the corresponding generic CDR field. Copying in this instance is accomplished using either a variable assignment or memcpy() function. Preferably, the method continues in step 513 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
[0041] If the read raw CDR field is not identical, the method continues in step 518 with the step of determining whether the field is compatible with a field in the generic CDR. A field is compatible with another field if its data type can be converted to match the data type of the other field. If the read raw CDR field is compatible with a field in the generic CDR, the method continues in step 520, with the step of generating computer code that, when executed, will cause data stored in the raw CDR field to be converted to the compatible generic CDR field. Preferably, the computer code generated is a function call to computer code that will perform the actual conversion. As described above, it would be apparent to those skilled in the art how to write such conversion code. Preferably, the method continues in step 513 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
[0042] If the read field is not compatible, then the method continues in step 522 with the step of generating an error message. The error message indicates, that the read raw CDR field was not new, nor identical nor compatible with any field in the generic CDR structure indicating that it requires special consideration.
[0043] After the generated code segment has been written in step 513, or alternatively stored in memory or an error message is generated in step 522, the method continues processing in step 524 by determining whether the end of the raw CDR structure being processed has been reached. For example, when using C or C++, the end of the structure is reached upon encountering a "}". If the end of the raw CDR structure has not been reached, the method continues in step 508, by reading the next field of the raw CDR structure.
[0044] If the end of the raw CDR structure has been reached, the method optionally continues in step 526 with the generation of a return statement that is written to the computer code file. Whether performing step 526 or not, the method continues in step 528 by determining whether there is another raw CDR structure to process. If there are additional raw CDR structures to process, the method continues in step 504 by identifying the next raw CDR structure to process. If there are no more raw CDR structures to process, the method ends pass 1 in step 530. Optionally, at this point, the method can close the computer code file. However, it is preferably left open for use in the second pass.
[0045] FIG. 5B is a flow chart for a method for generating RecoverCDR functionality to populate a generic CDR with data from one or more raw CDRs. Preferably, the flow chart illustrated in FIG. 5B is executed as the second pass of the method described above. The second pass of the method begins in step 550. If the computer code file was closed at the end of the first pass, it is opened. Preferably, however, the computer code file is not closed at the end of the first pass, and the second pass is initiated immediately upon completion of the first pass.
[0046] In step 552, a generic CDR structure is read. The name, type and size of each field in the generic CDR structure is stored in computer memory. In step 554, a raw CDR data structure is identified. Preferably, the generic and one or more raw CDR structures are stored in header file. The header file is opened and the data required to complete steps 553 and 554 is read. In addition, preferably, the header file is configured such that the generic CDR structure is first.
[0047] In step 556, a function header is generated and stored to the computer code file. In the second pass, the function header is the function header for a RecoverCDR function. A form for the RecoverCDR function header according to one embodiment of the present invention is the form "void RecoverCDR (CDR_typel *rawCDR)", where CDR_typel indicates CDR type, for example, switch version and rawCDR is a pointer to a data structure defined according the CDR version. In step 558, a field of a raw CDR is read. The field can be read from the header file or from memory if the raw CDR is stored in memory when it is identified in step 554. In step 560, the read field is compared to the fields in the generic CDR structure to determine if it is a new field. A new field is a field that is not already present in the generic CDR structure. If the field is a new field, the method continues in step 566, with the step of generating computer code that, when executed, will cause data stored in the corresponding generic CDR field to be stored in the raw CDR field. Preferably, the method continues in step 563 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
[0048] If the read raw CDR field is not new, the method continues in step 564 with the step of determining whether the field is identical to a field in the generic CDR. Two fields are identical if they have the same name, data type and size. If the fields are identical, the method continues in step 566, with the step of generating computer code that, when executed, will cause data stored in the corresponding generic CDR field to be copied to the raw CDR field. Copying in this instance is accomplished using either a variable assignment or memcpy() function. Preferably, the method continues in step 563 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
[0049] If the read raw CDR field is not identical, the method continues in step 518 with the step of determining whether the field is compatible with a field in the generic CDR. A field is compatible with another field if its data type can be converted to match the data type of the other field. If the read raw CDR field is compatible with a field in the generic CDR, the method continues in step 570, with the step of generating computer code that, when executed, will cause data stored in the compatible generic CDR field to be converted to the raw CDR field. Preferably, the computer code generated is a function call to computer code that will perform the actual conversion. As described above, it would be apparent to those skilled in the art how to write such conversion code. Preferably, the method continues in step 563 with the step of writing the computer code so generated to the computer code file. Alternatively, the generated computer code is stored in memory and written to the computer code file later.
[0050] If the read field is not compatible, then the method continues in step 572 with the step of generating an error message. The error message indicates, that the read raw CDR field was not new, nor identical nor compatible with any field in the generic CDR structure indicating that it requires special consideration. [0051] After the generated code segment has been written in step 563, or alternatively stored in memory or an error message is generated in step 572, the method continues processing in step 574 by determining whether the end of the raw CDR structure being processed has been reached. For example, when using C or C++, the end of the structure is reached upon encountering a "}". If the end of the raw CDR structure has not been reached, the method continues in step 558, by reading the next field of the raw CDR structure.
[0052] If the end of the raw CDR structure has been reached, the method optionally continues in step 576 with the generation of a return statement that is written to the computer code file. Whether performing step 576 or not, the method continues in step 578 by determining whether there is another raw CDR structure to process. If there are additional raw CDR structures to process, the method continues in step 554 by identifying the next raw CDR structure to process. If there are no more raw CDR structures to process, ends the second pass in step 582.
[0053] The computer code file can be closed at this point. However, preferably additional processing can be performed upon completion of the second pass prior to closing the computer code file. Specifically, at the end of the second pass, a revised generic CDR is generated and written to the computer code file. The revised generic CDR is generated by printing the type, size, and name information for each field found in the original generic CDR and those that were added by processing the raw CDR structures in the first pass. Further, in one embodiment of the present invention, the type, size, and name information from the revised generic CDR is printed to the computer code file in a format that is compatible with the structure used by a CDR viewing tool. At this point the computer code file is closed.
[0054] One such CDR viewing tool is described in U.S. Patent Application No. , Attorney Docket No. BSOO-075, entitled "System and Method for Managing
CDR Information", filed on March 12, 2002, which is hereby incorporated by reference in its entirety. The CDR viewing tool uses this information to permit a user to select what fields to view and to determine the best format for displaying this information.
[0055] It would be apparent to those skilled in the art that if original generic CDR structure was empty, one would be created that would contain every field found in any of the raw CDR structures. No conversions would be generated unless the field exists in two (or more) raw CDR structures with different formats. If the user wants to force some conversions to be done, the fields to be converted must exist in the generic CDR structure with the appropriate type prior to using this tool.
[0056] If preprocessor directives are found that are not specifically recognized, these preprocessor directives are duplicated in the output file at the point at which they are encountered. For example, if a portion of the raw CDR is optional (based on some condition that can be determined at compile time), the code to copy or convert these fields will be optional based on the same conditions.
[0057] FIG. 6 is exemplary CDR build code that is generated by CDR code generator tool 402. As shown in FIG. 6, the computer code that is generated builds a generic CDR using the data from a raw CDR. The data stored in the raw CDR is obtained earlier by opening a CDR data file that was generated by a switch, and storing the data contained therein. Therefore, the variable "rawCDR" is defined prior to the code generation shown in FIG. 6. That is, the variable "rawCDR" is defined and initialized prior to the BuildCDR function, illustrated in FIG. 6, being invoked. "rawCDR" is passed as a parameter to BuildCDR, which uses the data contained therein to populate the generic CDR.
[0058] FIG. 6 also illustrates the use of the function overload feature available in many programming languages. Using function overload, the function name BuildCDR can be reused, so long as the proper parameters are passed to each function. In the embodiment illustrated in FIG. 6, for example, the function BuildCDR is overloaded so that it can build generic CDRs for typel and type 2 CDRs. The particular function that will be invoked at runtime depends on whether the function is called with a pointer to a CDR TYPE1 or a CDR TYPE2 structure.
[0059] In an embodiment of the present invention, CDR code generation tool 402 accesses a set of built in conversion rules to obtain the code segments required to create the BuildCDR function that it generates. If any data type conversions are required, subroutines to perform the conversions are referenced in the computer code segments. For example, the subroutines "cnv()" and "Convert_Time()" are used to perform data type conversions on the data of the raw CDR to store in the generic CDR.
[0060] CDR code generation tool 402 also generates code that converts a generic
CDR to a raw CDR corresponding to a particular CDR type. FIG. 7 is exemplary code that is generated by CDR code generator tool 402 to recover a raw CDR using the data stored in a generic CDR. As with FIG. 6 above, FIG. 7 illustrates the use of the function overload feature of many programming languages. Using function overload, the function name RecoverCDR can be reused, so long as the proper parameters are passed to each function. In the embodiment illustrated in FIG. 7, for example, the function RecoverCDR is overloaded so that it can recover raw CDRs for two CDR types from a generic CDR. The particular function that will be invoked at runtime depends on whether a pointer to a CDR TYPE1 or a CDR TYPE2 structure is used.
[0061] If any reverse conversion back to the raw CDR data types are required, subroutines to perform the reverse conversions are referenced in the computer code segment. For example, subroutines "uncnv()" and "UnConvertTimeO" are used to convert parameters back to the data types for storage in the raw CDR.
[0062] The foregoing disclosure of the preferred embodiments of the present invention has been presented for purposes of illustration and description. It is not intended to be exhaustive or to limit the invention to the precise forms disclosed. Many variations and modifications of the embodiments described herein will be apparent to one of ordinary skill in the art in light of the above disclosure. The scope of the invention is to be defined only by the claims appended hereto, and by their equivalents.
[0063] Further, in describing representative embodiments of the present invention, the specification may have presented the method and/or process of the present invention as a particular sequence of steps. However, to the extent that the method or process does not rely on the particular order of steps set forth herein, the method or process should not be limited to the particular sequence of steps described. As one of ordinary skill in the art would appreciate, other sequences of steps may be possible. Therefore, the particular order of the steps set forth in the specification should not be construed as limitations on the claims. In addition, the claims directed to the method and/or process of the present invention should not be limited to the performance of their steps in the order written, and one skilled in the art can readily appreciate that the sequences may be varied and still remain within the spirit and scope of the present invention.

Claims

WHAT IS CLAIMED IS:
1. A method for generating computer code that facilitates development of call detail record management tools, comprising the steps of:
(a) opening a computer code file to store generated computer code;
(b) reading the structure of a generic call detail record, the generic call detail record comprising a plurality of fields;
(c) writing a function call to the computer code file;
(d) generating a code segment for each field in the raw call detail record;
(e) storing each code segment to the computer code file; and
(f) closing the computer code file.
2. The method recited in claim 1, further comprising the step of creating the generic call detail record from a plurality of raw call detail records.
3. The method recited in claim 2, further comprising the steps of:
(a) reading the generic call detail record structure;
(b) reading each call detail record structure corresponding to each raw call detail record structure to be encapsulated by the generic call detail record structure; and
(c) for each raw call detail record structure, adding to the generic record structure each field of the raw call detail record that does not match a field in the generic record structure.
4. The method recited in claim 3, wherein processing of each raw call detail record structure is performed prior to reading the next call raw detail record for processing.
5. The method recited in claim 2, further comprising the steps of: (a) reading the generic call detail record structure; (b) reading each raw call detail record structure to be encapsulated in the generic call detail record;
(c) determining a common portion among the fields available to different versions of a switch;
(d) if there is a common portion determined in step 5(c), storing the common portion in the generic call detail record structure; and
(e) for each version of the raw call detail record structure to be encapsulated in the generic call detail record structure, storing the uncommon portion of the raw call detail record structure in the generic call detail record structure offset in a manner to indicate that it is distinct to correspond to the particular switch version.
6. The method recited in claim 5, further comprising the step of using #ifdef and #elif compiler directives to offset the uncommon portions.
7. A system for generating computer code that facilitates development of call detail record management tools, comprising: means for opening a computer code file to store generated computer code; means for reading the structure of a generic call detail record, the generic call detail record comprising a plurality of fields; means for writing a function call to the computer code file; for each field in the generic call detail record, means for generating a code segment; means for writing each code segment to the computer code file; and means for closing the computer code file.
PCT/US2003/007598 2002-03-12 2003-03-11 System and method for generating computer code to facilitate development of cdr management tools WO2003079187A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003218117A AU2003218117A1 (en) 2002-03-12 2003-03-11 System and method for generating computer code to facilitate development of cdr management tools

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US10/094,642 US6951009B2 (en) 2002-03-12 2002-03-12 System and method for generating computer code to facilitate development of CDR management tools
US10/094,642 2002-03-12

Publications (1)

Publication Number Publication Date
WO2003079187A1 true WO2003079187A1 (en) 2003-09-25

Family

ID=28038829

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2003/007598 WO2003079187A1 (en) 2002-03-12 2003-03-11 System and method for generating computer code to facilitate development of cdr management tools

Country Status (3)

Country Link
US (1) US6951009B2 (en)
AU (1) AU2003218117A1 (en)
WO (1) WO2003079187A1 (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7155205B2 (en) * 2002-03-12 2006-12-26 Bellsouth Intellectual Property Corporation System and method for verifying subscriber data records in a telephone system
US7340422B2 (en) 2003-02-10 2008-03-04 Asentinel Llc Systems and method for managing and processing of telecommunications invoices

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5809507A (en) * 1996-07-01 1998-09-15 Sun Microsystems, Inc. Method and apparatus for storing persistent objects on a distributed object network using a marshaling framework
US5925562A (en) * 1995-04-25 1999-07-20 Irori Remotely programmable matrices with memories
US6016547A (en) * 1994-06-06 2000-01-18 Fujitsu Limited Data processing apparatus with program allocating section for selectively allocating programs in first and second memory
US6038555A (en) * 1997-01-21 2000-03-14 Northern Telecom Limited Generic processing capability
US6249570B1 (en) * 1999-06-08 2001-06-19 David A. Glowny System and method for recording and storing telephone call information

Family Cites Families (51)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US176378A (en) * 1876-04-18 Improvement in collars for cooking-stoves
US191597A (en) * 1877-06-05 Improvement in feed-water heaters for locomotives
US638544A (en) * 1899-09-12 1899-12-05 Mary L Barcley Corset.
EP0541535B1 (en) * 1989-08-14 1997-07-09 Centillion Data Systems, Inc. Billing system
US5146491A (en) 1991-08-08 1992-09-08 Pilgrim Telephone, Inc. Telephone billing method
US5333183A (en) 1992-03-13 1994-07-26 Moscom Corporation Universal MDR data record collection and reporting system
US6052447A (en) 1993-05-28 2000-04-18 Sprint Communications Company L.P. Method and apparatus for aggregating customer information for a telecommunications system
US5553131A (en) 1993-07-09 1996-09-03 Mountain International Corporation Providing the most cost-effective long-distance telephone service based on milage band rates
US5438570A (en) 1993-12-29 1995-08-01 Tekno Industries, Inc. Service observing equipment for signalling System Seven telephone network
SG43099A1 (en) 1994-03-02 1997-10-17 British Telecomm Charging for usage of a telecommunications network
CA2123068C (en) 1994-05-06 1998-04-14 Thomas A. Gray Adaptive method for allocating calls
US5757895A (en) 1995-11-09 1998-05-26 Unisys Corporation Extracting and processing data derived from a common channel signalling network
US5579371A (en) 1994-11-22 1996-11-26 Unisys Corporation Common channel signaling network applications platform
KR0173052B1 (en) 1994-12-20 1999-03-30 양승택 Discount ration processing method of information fee
US5774532A (en) 1995-04-21 1998-06-30 Mci Corporation Single network record construction
US5659601A (en) 1995-05-09 1997-08-19 Motorola, Inc. Method of selecting a cost effective service plan
WO1997018661A1 (en) * 1995-11-13 1997-05-22 Answersoft, Inc. Intelligent information routing system and method
US5930343A (en) 1995-12-15 1999-07-27 Lucent Technologies Inc. Toll call rate provider
US5940487A (en) * 1996-04-10 1999-08-17 Alcatel Usa Sourcing, L.P. Programmable call processing system and method
US5963625A (en) 1996-09-30 1999-10-05 At&T Corp Method for providing called service provider control of caller access to pay services
DE19644024C2 (en) 1996-10-31 2000-03-09 Deutsche Telekom Mobil Method and device for checking the correct and complete creation of communication data records in telecommunication systems
US6122352A (en) 1996-12-19 2000-09-19 Nokia Telecommunications Oy Method for controlling a credit customer call
US5987108A (en) 1997-03-19 1999-11-16 At&T Corp Telephone billing with customer-defined budgeting
US5920613A (en) 1997-04-25 1999-07-06 Ameritech Corporation Method and system for generating a billing record
US5915006A (en) 1997-05-01 1999-06-22 At&T Corp. Telephone line aggregated billing
US5991376A (en) 1997-05-20 1999-11-23 At&T Corp. Subscriber reward method
US6125173A (en) 1997-05-21 2000-09-26 At&T Corporation Customer profile based customized messaging
GB2326055B (en) 1997-06-04 2002-03-13 Northern Telecom Ltd Communication system
US6289502B1 (en) * 1997-09-26 2001-09-11 Massachusetts Institute Of Technology Model-based software design and validation
US6223035B1 (en) 1997-09-30 2001-04-24 Motorola, Inc. Method and apparatus for providing a subscriber record for packet data registration of a mobile station
US6064881A (en) 1997-12-22 2000-05-16 Trw Inc. System and method for processing satellite based telephone usage data for billing service providers
US6052448A (en) * 1997-12-23 2000-04-18 Northern Telecom Limited Method for flexible formatting of call detail records and switching system incorporating same
US5999604A (en) 1998-03-03 1999-12-07 Mci Communications Corporation System and method for managing a telecommunications network by determining service impact
US6411681B1 (en) * 1998-03-26 2002-06-25 Bell Atlantic Network Services, Inc. Traffic track measurements for analysis of network troubles
US6028914A (en) 1998-04-09 2000-02-22 Inet Technologies, Inc. System and method for monitoring performance statistics in a communications network
US6745384B1 (en) * 1998-05-29 2004-06-01 Microsoft Corporation Anticipatory optimization with composite folding
US6249572B1 (en) 1998-06-08 2001-06-19 Inet Technologies, Inc. Transaction control application part (TCAP) call detail record generation in a communications network
US6052449A (en) 1998-06-29 2000-04-18 Lucent Technologies Inc. System for controlling the provisioning of long distance service from different network carriers
US20010056362A1 (en) 1998-07-29 2001-12-27 Mike Hanagan Modular, convergent customer care and billing system
US6301471B1 (en) 1998-11-02 2001-10-09 Openwave System Inc. Online churn reduction and loyalty system
US6298125B1 (en) 1998-12-23 2001-10-02 At&T Corp. Frequency-based discount system for host-system within a communication network
US6224477B1 (en) 1998-12-28 2001-05-01 Nortel Networks Limited Method for ordering subscriber records of wireless communication networks
US6522734B1 (en) 1998-12-31 2003-02-18 Mci Worldcom, Inc. Transaction billing for special service telephone numbers
US6252946B1 (en) * 1999-06-08 2001-06-26 David A. Glowny System and method for integrating call record information
US6337901B1 (en) 1999-10-15 2002-01-08 Bellsouth Intellectual Property Corporation Customer billing relationships software
US6396913B1 (en) * 1999-10-22 2002-05-28 Convergys Cmg Utah Inc. System and method for processing call detail records
US20020176378A1 (en) 2001-05-22 2002-11-28 Hamilton Thomas E. Platform and method for providing wireless data services
GB2376845B (en) 2001-06-19 2006-02-08 Ericsson Telefon Ab L M Association of charging between communication systems
US6845500B2 (en) * 2001-07-17 2005-01-18 Smartmatic Corporation Paradigm for server-side dynamic client code generation
US6798871B2 (en) * 2001-09-18 2004-09-28 Sbc Technology Resources, Inc. Method for correcting call detail record files
US6658092B1 (en) * 2002-06-26 2003-12-02 International Business Machines Corporation Method, apparatus and computer program product for authorizing re-recording

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6016547A (en) * 1994-06-06 2000-01-18 Fujitsu Limited Data processing apparatus with program allocating section for selectively allocating programs in first and second memory
US5925562A (en) * 1995-04-25 1999-07-20 Irori Remotely programmable matrices with memories
US5809507A (en) * 1996-07-01 1998-09-15 Sun Microsystems, Inc. Method and apparatus for storing persistent objects on a distributed object network using a marshaling framework
US6038555A (en) * 1997-01-21 2000-03-14 Northern Telecom Limited Generic processing capability
US6249570B1 (en) * 1999-06-08 2001-06-19 David A. Glowny System and method for recording and storing telephone call information

Also Published As

Publication number Publication date
US6951009B2 (en) 2005-09-27
AU2003218117A1 (en) 2003-09-29
US20030176160A1 (en) 2003-09-18

Similar Documents

Publication Publication Date Title
EP1014265B1 (en) Method and apparatus for testing event driven software
US5287270A (en) Billing system
Holzmann et al. Automating software feature verification
US6567509B1 (en) Method and system to extend functionality of voice processing systems
US6158031A (en) Automated code generating translator for testing telecommunication system devices and method
EP0663750A2 (en) Application-oriented telecommunication system interface
US5048079A (en) SMDR translator
US5159698A (en) SMDR translator
US6798871B2 (en) Method for correcting call detail record files
CN109960708A (en) Data processing method, device, electronic equipment and storage medium
US6542595B1 (en) Process, generating module, server, control module and storage means for the creation of validation rules
US20020034285A1 (en) Extraction of desired data from flow
US5729588A (en) Enhanced recording verification system
WO2002079929A2 (en) Method and system for converting data files from a first format to a second format
CN1996375A (en) Method and device for implementing transaction test in host environment
US8042106B2 (en) Data processing in a mediation or service provisioning system
CN114647422A (en) Vehicle electronic control unit flashing method, device, equipment and medium
US6951009B2 (en) System and method for generating computer code to facilitate development of CDR management tools
EP1417575A2 (en) Robust logging system for embedded systems for software compilers
CA2245156C (en) Service logic portability based on interface definition of execution environment in an intelligent network
CN115421782A (en) SDK compatible method applied to iOS terminal, storage device and intelligent terminal
CN100515002C (en) Method for metering call charge
WO2003079647A2 (en) System and method for ensuring proper billing in a cellular telephone system
KR19990042817A (en) Billing data recording apparatus and method in all electronic switch
AU2005259108B2 (en) Data processing in a mediation or service provisioning system

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ OM PH PL PT RO RU SD SE SG SK SL TJ TM TN TR TT TZ UA UG US UZ VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IT LU MC NL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP