CN101958987B - Method and system for dynamically converting telecommunications service data - Google Patents
Method and system for dynamically converting telecommunications service data Download PDFInfo
- Publication number
- CN101958987B CN101958987B CN200910152289.8A CN200910152289A CN101958987B CN 101958987 B CN101958987 B CN 101958987B CN 200910152289 A CN200910152289 A CN 200910152289A CN 101958987 B CN101958987 B CN 101958987B
- Authority
- CN
- China
- Prior art keywords
- conversion rule
- data conversion
- function
- telecommunication service
- functions
- 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.)
- Active
Links
Images
Abstract
The invention discloses a method and a system for dynamically converting telecommunications service data. The method comprises the following steps of: obtaining a preset telecommunications service data converting rule; dynamically generating a JAVA source code in a service realizing type according to the data converting rule and a preset service realizing type template; compiling and generating a JAVA program code; dynamically loading and executing the service realizing type; and generating a source data file into an object data file. The invention aims at the characteristics of the telecommunications service data to establish a rich function set, provides a function self-defining interface at the same time and is convenient to user self definition and function set expansion. Different from the current script interpretative type ETL (Extract-Transform-Load) tool, the invention adopts dynamic compiling, dynamic loading and a JAVA reflection technology, increases data conversion efficiency and has stronger cross-platform property and application flexibility.
Description
Technical field
The present invention relates to extraction, conversion and loading (ETL, Extract, Transform, the Load) technology in data warehouse, relate in particular to a kind of method and system thereof of telecommunication service Data Dynamic conversion.
Background technology
Along with opening gradually of telecommunication market, new operator constantly produces, the competition of telecommunication market.In order can to survive and sustainable development in competition, have higher requirement to the operation and management of enterprise in each telecom operation commercial city.The ETL technology is for telecom operators' managing telecommunications operation system, analysis business datum, assurance business development direction, and it is most important to promote service level.
At present, on market, the commercialization ETL instrument of main flow mainly contains platform for data arrangement (DI, DataIntegrator), DataStage, Informatica etc.These business-like ETL instruments are all each has something to recommend him on function, can satisfy the demand of general data conversion process.But telecommunication service is extremely various, and the business renewal is frequent, all kinds of packaged service of releasing as continuous in telecom operators.This just requires the ETL instrument to have good dirigibility and professional platform independence.Because commercialization ETL instrument lacks, the telecommunication service data analysed in depth and understood, only being to provide general processing module and calling for the user; And the interface of opening is fairly simple, need to do when optimizing and revising often more difficultly in case run into the performance bottleneck problem, and perhaps cost is higher.Therefore, it is little that this class instrument ratio is more suitable for data volume, and business is comparatively single and change little data-switching occasion.
If the data owner telephone relation inventory that the telecom operation system generates, telephone customer data etc., this type of data bulk is huge usually, and more than one hundred million records are arranged easily, and especially listings data, as single in detail in the local telephone network of landline telephone, and its data volume is huger.And the telecommunication service data have specific business implication, and when adopting general commercialization ETL instrument that these telecommunication service data are processed, owing to not taking full advantage of telecommunication service data self, its conversion efficiency is lower.In addition, the ETL instrument of some script explanation types that provide in the market need to spend the more time, so its data conversion efficiency is also lower when explaining script.Undoubtedly, sharply increasing of the high speed development of telecommunication service, data volume caused very large performance pressure to the data crossover tool.Therefore, for huge data volume like this, the treatment effeciency that how effectively to improve system becomes the technical matters that this area needs to be resolved hurrily.In addition, if when directly above-mentioned ETL tool applications being arrived telecommunication system, have the weak points such as software development is complicated, dirigibility is relatively poor, the system cross platform poor performance.
Be difficult to satisfy the requirement of business administration based on the computer management system of the every service operation of support of the ETL too development of aforementioned commercial, telecommunications enterprise is in the urgent need to seeking a kind of new digital conversion means, can realize low-cost, expeditiously the conversion of telecommunication service Data Dynamic, thereby make managerial personnel can understand timely and accurately market resource operating position and business development situation, in order in time find and deal with problems.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of method and system thereof of telecommunication service Data Dynamic conversion, it is for telecommunication service own characteristic customization collection of functions, configuration telecommunication service data transformation rule, and in conjunction with JAVA on-the-flier compiler and reflection technology, the shortcomings such as General ETL Tool very flexible, conversion efficiency be low have been overcome.The invention provides following technical scheme:
One aspect of the present invention provides the method for telecommunication service Data Dynamic conversion, and the method comprises: obtain the telecommunication service data conversion rule that presets according to service identification; According to the template of data conversion rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; Dynamic load is also carried out the business realizing class, and source data file is generated target data file.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, dynamic load and the step of carrying out the business realizing class comprise: adopt dynamic load JAVA class technology and reflection to call JAVA function technology dynamic load and carry out the business realizing class.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, the method also comprises step: receive the user to the configuration of data transformation rule by graphic interface.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, the method also comprises step: receive the user to definition and/or the expansion of collection of functions by graphic interface.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, collection of functions comprises the function that splits access code, area code, operator's informaiton from telephone number.
Another aspect of the present invention provides a kind of telecommunication service Data Dynamic converting system, and this system comprises: the data conversion rule storage subsystem is used for store electricity communication service data conversion rule and collection of functions; Data conversion rule scheduler subsystem is used for obtaining the telecommunication service data conversion rule from the data conversion rule storage subsystem; According to the template of transformation rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out the business realizing class, source data file is generated target data file.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, this system also comprises data conversion rule build environment subsystem, be used for receiving the user to the configuration of telecommunication service data conversion rule by graphic interface, the data conversion rule of revising or increase is saved in the data conversion rule storage subsystem; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem comprises: the data conversion rule configuration module, be used for the data conversion rule that presets is safeguarded, the guiding user configures new data conversion rule, and is responsible for importing/deriving selected data conversion rule; The collection of functions configuration module is used for the collection of functions that presets is safeguarded, is responsible for the guiding user and configures new function, and importing/derivative function collection or single function; System maintaining module is used for the systematic parameter of storage data conversion rule build environment subsystem and the system journal of generation.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, the data conversion rule configuration module comprises: data conversion rule is safeguarded submodule, and the tree-shaped information that represents with transformation rule that be used for to be responsible for the transformation rule list represents; Data conversion rule configuration wizard submodule is used for being responsible for the configuration that the guiding user progressively completes data conversion rule; Data conversion rule imports/derives submodule, is used for being responsible for importing and deriving selected transformation rule, for user ID and/or deployment.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, the collection of functions configuration module comprises: collection of functions is safeguarded submodule, is used for the collection of functions that presets is safeguarded; Self-defining function guide submodule is used for being responsible for the definition that the guiding user completes function; Function imports/derives submodule, is used for importing/derivative function collection or single function, for user ID and/or deployment.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, system maintaining module comprises: the systematic parameter submodule, for the systematic parameter of configure and maintenance data conversion rule build environment subsystem; The system journal submodule, the system journal that is used for generating and storing data conversion rule build environment subsystem.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem comprises: the data conversion rule engine is used for obtaining the telecommunication service data conversion rule from the data conversion rule storage subsystem; Dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out the business realizing class, source data file is generated target data file; System maintaining module is used for the systematic parameter of storage data conversion rule scheduler subsystem and the system journal of generation.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, the data conversion rule engine comprises: source code generator, be used for dynamically generating the JAVA source code file of business realizing class according to the template of data conversion rule with the business realizing class that presets; The compilation of source code device, the JAVA source code file for compiling business realizing class generates the JAVA program code; And the data conversion rule processor, be used for reading and writing data file, be responsible for the conversion of telecommunication service data; And concentrate and the disposal system mistake.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, system maintaining module comprises: the systematic parameter submodule, for the systematic parameter of configure and maintenance data conversion rule scheduler subsystem; The system journal submodule is used for the system journal of generation and storage data conversion rule scheduler subsystem.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, the collection of functions of data conversion rule memory subsystem stores comprises for split out the function of access code, area code, operator's informaiton from telephone number.
The data volume that the telecom operation system generates is all very large, especially detailed forms data, and its data volume is huger, and this has caused certain performance pressure to the data crossover tool undoubtedly.Simultaneously, telecommunication service is extremely various, and variation is very fast, as all kinds of packaged service of telecommunications release.This just requires the ETL instrument to have good dirigibility.In addition, ETL instrument in the market is not optimized processing for the telecommunication service data characteristics, can not average out between dirigibility and efficient; For huge telecommunication service data volume, how effectively to improve the treatment effeciency of system, be also the problem that needs consideration.The present invention is directed to the telecommunication service data characteristic and set up abundant collection of functions, the function self defined interface is provided simultaneously, be convenient to user's spread function collection; Be different from current script explanation type ETL instrument, the present invention adopts dynamic generation source code, and on-the-flier compiler, and the mode of dynamic load and run time version have improved data conversion efficiency effectively, have very strong practicality.The present invention proposes to adopt collection of functions with innovating, and employing JAVA is design language, and good cross-platform characteristic is conducive to the compatibility of each subsystem and integrated.Use the JAVA reflection technology, can be flexibly dynamically executing data rule JAVA code generate the telecommunication service data file; Thereby avoid causing the miscellaneous work amount of revising ETL implementing procedure code when change occurs telecommunication service data-switching demand.Dynamically realize the telecommunication service data-switching, for telecommunication system provides accurate, unified data file.
Description of drawings
Fig. 1 illustrates the process flow diagram according to an embodiment of the method for telecommunication service Data Dynamic conversion of the present invention;
Fig. 2 illustrates the process flow diagram according to an embodiment of the method for telecommunication service Data Dynamic conversion of the present invention;
Fig. 3 illustrates the structural representation according to an embodiment of the system of telecommunication service Data Dynamic conversion of the present invention;
Fig. 4 illustrates the present invention by a graphic interface that embodiment provides of data conversion rule build environment subsystem;
The embodiment that Fig. 5 shows data conversion rule scheduler subsystem is loaded into progress monitoring interface in Database Systems with the record in target data file;
Fig. 6 illustrates the structural representation according to an embodiment of the system of telecommunication service Data Dynamic conversion of the present invention;
Fig. 7 illustrates the structural representation according to an embodiment of the system of telecommunication service Data Dynamic conversion of the present invention;
Fig. 8 illustrates the process flow diagram according to a concrete application examples of the method for telecommunication service Data Dynamic conversion of the present invention;
Fig. 9 illustrates the process flow diagram according to a concrete application examples of the system of telecommunication service Data Dynamic conversion of the present invention.
Embodiment
With reference to the accompanying drawings the present invention is described more fully, the various embodiment that the present invention is exemplary are described.
Fig. 1 illustrates the process flow diagram according to an embodiment of telecommunication service Data Dynamic conversion method of the present invention.
As shown in Figure 1, step 102 is obtained the telecommunication service data conversion rule that presets according to service identification.In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, directly obtain the telecommunication service data conversion rule according to service identification (being generally digitized service code) from the telecommunication service data conversion rule information of storage.In an embodiment of Data Dynamic conversion method provided by the invention, store the information such as telecommunication service data conversion rule information that the user customizes in advance and collection of functions in system database.After a while telecommunication service data conversion rule information and collection of functions are briefly introduced.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, the telecommunication service data conversion rule information comprises the compiling status information of telecommunication service data conversion rule and corresponding conversion rule.In the present invention, the compiling status information of mentioned transformation rule mainly leaves in compiling status information table (seeing table 1).
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | MODULE_ID | VARchar(250) | Module id |
| 2 | SERVICE_ID | INTEGER | Service identification |
| 3 | COMPILED_FLAG | SMALLINT | 0 (not compiling), 1 (compiling) |
Table 1
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, it customizes some function sets according to the telecommunication service data characteristics, mainly comprises dimension table query function, Dates Study function, character string transfer function, timestamp format output function, date format function, analyzes Number for access function, analysis area code function, analysis user number function, analysis operator's function and phase-split network type of functions etc.Below 10 kinds of related main functions are carried out brief description:
(1), dimension table query function: its N according to appointment (N 〉=1) field value is right＜queryColumnName, queryColumnValue〉question blank " tableName ", return to the value of " resultColumnName " field, return to the value of " resultColumnValue " appointment without Query Result.
public final static String lookupOneByFour(String tableName，
String queryColumnName1, the title of // inquiry field 1 used
String queryColumnValue1, the value of // inquiry field 1 used
String queryColumnName2, the title of // inquiry field 2 used
String queryColumnValue2, the value of // inquiry field 2 used
…
…
String queryColumnNameN, the title of // inquiry field N used
String queryColumnValueN, the value of // inquiry field N used
String resultColumnName, // title of field need to be returned to
String resultColumnValue//need to return to the default value of field
)；
(2), Dates Study function: analyzing whether the str character string is date format, is not to return to default value defaultDate.
public final static String parseDate(String str，StringdefaultDate)；
(3), character string transfer function: convert character string to numeral (integer, floating-point ...).
public final static String str2Double(String str，StringdefaultVal)；
public final static String str2Int(String str，String defaultVal)；
…
(4), the timestamp format output function: the date string format is turned to the timestamp form of " YYYY-MM-DD HH:MM:SS ", failed return to default value defaultDate.
public final static String formatTimestamp(String date，StringdefaultDate)；
(5), the date format function: the date string format is turned to the date format of " YYYY-MM-DD ", failed return to default value defaultDate.
public final static String formatDate(String date，StringdefaultDate)；
(6), analyze the Number for access function: analyze the telephone number serviceNo of appointment, therefrom split out service access number, as 17909,17951 etc.Failed return to default value defaultValue.
public final static String analyzeAccessCode(
String serviceNo, // service numbers
Whether String hasAccessCode contains access code in // service numbers
Whether String hasAreaCode is with area code in // service numbers
String recAreaCode, // ticket issue the ground area code
String defaultValue//default value
)；
(7), analyze the area code function: analyze the telephone number serviceNo of appointment, therefrom split out area code, as 020,757 etc.Failed return to default value defaultValue.
public final static String analyzeAreaCode(
String serviceNo, // service numbers
Whether String hasAccessCode contains access code in // service numbers
Whether String hasAreaCode is with area code in // service numbers
String recAreaCode, // ticket issue the ground area code
String defaultValue//default value
)；
(8), analysis user number function: analyze the telephone number serviceNo of appointment, therefrom split out subscriber directory number, as 13388888888,87654114 etc.Failed return to default value defaultValue.
public final static String analyzeUserNo(
String serviceNo, // service numbers
Whether String hasAccessCode contains access code in // service numbers
Whether String hasAreaCode is with area code in // service numbers
String recAreaCode, // ticket issue the ground area code
String defaultValue//default value
)；
(9), analyze operator's function: analyze the telephone number serviceNo of appointment, therefrom split out operator's informaiton, as China Telecom, China Mobile etc.Failed return to default value defaultValue.
public final static String analyzeCarrierID(
String serviceNo, // service numbers
Whether String hasAccessCode contains access code in // service numbers
Whether String hasAreaCode is with area code in // service numbers
String recAreaCode, // ticket issue the ground area code
String defaultValue//default value
)；
(10), phase-split network type of functions: analyze the telephone number serviceNo of appointment, therefrom split out network type information, as landline telephone, Personal Handyphone System, mobile phone etc.Failed return to default value defaultValue.
public final static String analyzeNetTypeID(
String serviceNo, // service numbers
Whether String hasAccessCode contains access code in // service numbers
Whether String hasAreaCode is with area code in // service numbers
String recAreaCode, // ticket issue the ground area code
String defaultValue//default value
)；
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, (for example use the collection of functions of aforementioned novelty, analyze area code function, analysis user number function and analyze operator's function), can split the information such as access code, area code, operator from the numeral of calling party's dialing.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, method comprises: the basic function collection is provided; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.The collection of functions relevant information leaves in respectively in collection of functions information table (seeing table 2) and function parameter information table (seeing table 3).
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | FUNCTION_ID | INTEGER | Function identification |
| 2 | FUNCTION_NAME | VARchar(100) | Function name |
| 3 | FUNCTION_TYPE | VARchar(200) | Function category |
| 4 | FUNCTION_DESCRIPTION | VARchar(500) | The function performance explanation |
Table 2
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | FUNCTION_ID | INTEGER | Function identification |
| 2 | PARAMETER_INDEX | SMALLINT | The parameter sequence number |
| 3 | PARAMETER_NAME | VARchar(100) | Parameter name |
| 4 | PARAMETER_TYPE | VARchar(100) | Parameter type |
| 5 | PARAMETER_DESCRIPTION | VARchar(500) | Parametric description |
Table 3
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, preserve the source data file of business realizing class JAVA source code and store in system, produce associated source data file Basic Information Table (seeing table 4) and source data file field information table (seeing table 5)
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | FORMAT_ID | BIGINT | Format identification (FID) |
| 2 | SERVICE_ID | INTEGER | Service identification |
| 3 | FORMAT_INDEX | SMALLINT | The form numbering |
| 4 | COLUMN_DELIMITER | VARchar(20) | Field delimiter (during f format is |
| Empty) |
Table 4
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | FORMAT_ID | BIGINT | Format identification (FID) |
| 2 | COLUMN_INDEX | SMALLINT | The field sequence number |
| 3 | COLUMN_NAME | VARchar(100) | Field name |
| 4 | COLUMN_LENGTH | SMALLINT | Field length |
| 5 | COLUMN_DESCRIPTION | VARchar(100) | Field description |
Table 5
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, the command line parameter that on-the-flier compiler business realizing class source code file is generated the program code that the virtual function of JAVA carries out is as follows:
“String[]compileArgs＝
new String[]{″-d″，classFilePath，sourceFileName}；
int retCode＝
com.sun.tools.javac.Main.compile(compileArgs，logFile)；
”
Wherein, " classFilePath ": the class file storing directory that compiling generates;
" sourceFileName ": source code file name (containing the path);
" logFile ": journal file handle.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, Dynamic loading technique, being about to business realizing class class class that compiling generates, to be loaded into the code of internal memory as follows:
“Class svcImpl；
try{
svcImpl＝Class.forName(serviceImplementClassName)；
}catch(ClassNotFoundException e)
{
// abnormality processing
}
”
Wherein, " serviceImplementClassName ": the business realizing class class filename that generates during on-the-flier compiler.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, in order to call flexibly the implementation method of business realizing class, the business realizing class all needs to realize an interface function doTransform ().Adopt the reflection technology invoke code as follows:
“try{
Class []parameterClasses＝new Class[1]；
parameterClasses[0]＝ServiceRule.class；
Object[]methodArgs＝new Object[1]；
methodArgs[0]＝serviceRule；
Method implMethod＝svcImpl.getMethod(″doTransform″，
parameterClasses)；
implMethod.invoke(svcImpl.newInstance()，methodArgs)；
}catch(Exception ex){
// abnormality processing
}
”
Wherein, " ServiceRule ": business rule object definition;
" serviceRule ": business rule object instance;
" svcImpl ": business realizing class example.
In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, dynamically generate telecommunication service data file (file destination) and be loaded in Database Systems, related data information relates generally to file destination Basic Information Table (seeing table 6), file destination field information table (seeing table 7), file destination field transformation rule (function call) information table (seeing table 8) and file destination field function call example information table (seeing table 9).
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | FORMAT_ID | BIGINT | Format identification (FID) |
| 2 | SERVICE_ID | INTEGER | Service identification |
| 3 | RECORD_DELIMITER | VARchar(20) | The row decollator |
| 4 | COLUMN_DELIMITER | VARchar(20) | The column split symbol |
| 5 | FILE_NAME | VARchar(200) | The file destination name |
Table 6
| Sequence number | Property Name | Data type | Attribute description |
| 1 | COLUMN_ID | BIGINT | Field identification |
| 2 | FORMAT_ID | BIGINT | Format identification (FID) |
| 3 | COLUMN_MAP_IND EX | SMALLINT | Field conversion serial number |
| 4 | COLUMN_OUT_IND EX | SMALLINT | Field output sequence number ,-1: field does not output to file |
| 5 | COLUMN_NAME | VARchar(10 0) | Field name |
| 6 | COLUMN_TYPE | VARchar(20 | Field type |
| ) | |||
| 7 | COLUMN_DESCRIP TION | VARchar(10 0) | Field description |
Table 7
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | INSTANCE_ID | BIGINT | Instance identification |
| 2 | COLUMN_ID | BIGINT | Field identification |
| 3 | FUNCTION_INDEX | SMALLINT | Call sequence number |
| 4 | FUNCTION_ID | INTEGER | Function identification |
Table 8
| The attribute sequence number | Property Name | Data type | Attribute description |
| 1 | INSTANCE_ID | INTEGER | Instance identification |
| 2 | PARAMETER_INDEX | SMALLINT | The parameter sequence number |
| 3 | PARAMETER_VALUE | VARchar(500) | Parameter value |
Table 9
Fig. 2 illustrates the process flow diagram according to an embodiment of telecommunication service Data Dynamic conversion method of the present invention.
As shown in Figure 2, step 202, store electricity communication service data conversion rule information and collection of functions.For example, store the information such as telecommunication service data conversion rule information that the user customizes in advance and collection of functions in system database.
Step 204 is obtained telecommunication service data conversion rule compiling status information.For example, the user obtains from system database and directly obtains transformation rule compiling status information in the telecommunication service data conversion rule information, is used for judging whether this transformation rule compiled.
Step 206 judges whether transformation rule compiles.If confirm that according to the transformation rule compiling status information of obtaining this transformation rule did not compile, execution in step 208; Otherwise directly jump to step 214.
Step 208 is obtained the telecommunication service data conversion rule that presets according to service identification.In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, directly obtain the telecommunication service data conversion rule according to service identification (being generally digitized service code) from the telecommunication service data conversion rule information of storage.
Step 210 according to the template of data conversion rule with the business realizing class that presets, dynamically generates the JAVA source code of business realizing class.For example, obtain according to service identification the business rule information that has configured in step 208, subsequently according to business realizing class masterplate file, D ynamic instantiation generates business realizing class JAVA source code file.
Step 212, the JAVA source code of compiling business realizing class generates the JAVA program code.For example, the JAVA compilation of source code with the business realizing class generates the program code that the virtual function of JAVA is carried out.
Step 214, dynamic load is also carried out the business realizing class, and source data file is generated target data file.For example, adopt dynamic load JAVA class and reflection to call the technology of JAVA function, load and carry out business realizing class template file, read source data file, generate target data file.Source data file comprises systematic parameter or service identification, as information such as the kind of telecommunication service, package name.The target data file that generates offers other system and uses (the data file import tool as utilizing database to carry is loaded into the record in target data file in Database Systems).
Fig. 3 illustrates the structural representation according to an embodiment of telecommunication service Data Dynamic converting system of the present invention.As shown in Figure 3, telecommunication service Data Dynamic converting system 300 mainly comprises: data conversion rule storage subsystem 302, data conversion rule build environment subsystem 304 and data conversion rule scheduler subsystem 306.
Wherein, data conversion rule storage subsystem 302 is used for depositing store electricity communication service data conversion rule information and collection of functions, comprises the transformation rule of the telecommunication service data that the user has customized, the compiling state of transformation rule, and the information such as collection of functions.
Data conversion rule build environment subsystem 304 is used for from data conversion rule storage subsystem 302 call function collection customization telecommunication service data conversion rule, and the information of the transformation rule revising or increase is saved in data conversion rule storage subsystem 302; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 304 provides patterned interface (as shown in Figure 4), carry out data conversion rule configure and maintenance collection of functions for the user, and provide DLL (dynamic link library) to carry out self-defined and the spread function collection to (possessing the JAVA programming experience) advanced level user, thereby satisfy the demand of user individual.
Data conversion rule scheduler subsystem 306 is used for obtaining the telecommunication service data conversion rule from data conversion rule storage subsystem 302; Dynamically generate the JAVA source code of business realizing class according to transformation rule; Generate according to the JAVA compilation of source code of business realizing class the code that the virtual function of JAVA is carried out; And dynamically generate the telecommunication service data file.in an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 306 is according to service identification (being generally digitized service code), obtain the telecommunication service data conversion rule information that has configured from data conversion rule storage subsystem 302, and according to business realizing class masterplate file, D ynamic instantiation generates business realizing class JAVA source code file, then compiling generates the program code that the virtual function of JAVA is carried out, adopt dynamic load JAVA class and reflection to call the technology of JAVA function, load and carry out the business realizing class, read source data file, generate target data file, (for example use in order to other system, the data file import tool that utilizes database to carry, record in target data file is loaded in Database Systems), its progress monitoring interface as shown in Figure 5.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 306 is first obtained the transformation rule status information to judge whether this transformation rule compiled from data conversion rule storage subsystem 302; If the state of this transformation rule is marked as " compiling ", telecommunication service Data Dynamic converting system 300 is directly skipped the code that the JAVA source code dynamically generates and the virtual function of compiling generation JAVA is carried out, and is carried out dynamically generating the telecommunication service data file by data conversion rule scheduler subsystem 306.
Telecommunication service Data Dynamic conversion method based on collection of functions provided by the invention customizes for the characteristics of telecom operation data, and system development costs is lower, and its treatment effeciency is higher.In addition, the operations such as the transformation rule that the user can be in transformation rule build environment subsystem analyzes data to telecom operation easily increases, deletion and modification, thus can be adapted to the analysis demand of frequent variations.The present invention proposes to adopt collection of functions with innovating, has good dirigibility, and the backstage adopts the mode of on-the-flier compiler dynamically to realize the telecommunication service data-switching, for telecommunication system provides accurate, unified data file.
Fig. 4 illustrates a graphic interface that embodiment provides of data conversion rule build environment subsystem of the present invention.As shown in Figure 4, this patterned interface in common window interface except being provided with " file ", " demonstration ", " regulation management " and " help " toolbar, left side at window is provided with " business transformation rule tree ", it has tree structure, and the user can choose suitable transformation rule from tree-like node.Choose the transformation rule of certain node as the user after, launch immediately the relevant Custom Interface of this rule, as " input definition " hurdle, " output definition " hurdle, " mapping relations definition " hurdle.Take " mapping relations definition " hurdle as example, it arranges out " field name " and " transfer function " corresponding with " ID " by sequence number.Give the buttons such as interpolation, deletion on Fig. 4 right side, be used for the operation of modifying of listed function.
The embodiment that Fig. 5 shows data conversion rule scheduler subsystem converts source data file to target data file and is loaded into progress monitoring interface in Database Systems.The user generates with the business datum transformation rule compiling of obtaining the program code that the virtual function of JAVA is carried out, adopt dynamic load JAVA class and reflection to call the technology scheduled for executing data conversion rule business realizing class of JAVA function, generate target data file and be loaded in Database Systems.As shown in Figure 5, when Business Name " TMAS06_CT_LDIST_200_CDR " is loaded preservation, this interface can show the title of current file, reads record amount, current progress, start time, uses the information such as time and excess time, and average velocity.
Fig. 6 illustrates the structural representation according to a specific embodiment of telecommunication service Data Dynamic converting system of the present invention.As shown in Figure 6, telecommunication service Data Dynamic converting system 600 mainly comprises: data conversion rule storage subsystem 602, data conversion rule build environment subsystem 604 and data conversion rule scheduler subsystem 606.
Wherein, data conversion rule storage subsystem 602 is used for depositing store electricity communication service data conversion rule information and collection of functions, comprises the transformation rule of the telecommunication service data that the user customizes in advance, the compiling state of transformation rule, and the information such as collection of functions.
Data conversion rule build environment subsystem 604 is used for receiving the user to the configuration of telecommunication service data conversion rule by graphic interface, will revise or the information of the transformation rule of increase is saved in data conversion rule storage subsystem 602; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 604 provides patterned interface (as shown in Figure 4), carry out data conversion rule configure and maintenance collection of functions for the user, and provide DLL (dynamic link library) to carry out self-defined and the spread function collection to (possessing the JAVA programming experience) advanced level user, thereby satisfy the demand of user individual.
Data conversion rule scheduler subsystem 606 is used for obtaining the telecommunication service data conversion rule from data conversion rule storage subsystem 602; According to the template of transformation rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out the business realizing class, source data file is generated target data file.in an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 606 is according to service identification (being generally digitized service code), obtain the telecommunication service data conversion rule information that has configured from data conversion rule storage subsystem 602, and according to business realizing class masterplate file, D ynamic instantiation generates business realizing class JAVA source code file, then compiling generates the program code that the virtual function of JAVA is carried out, adopt dynamic load JAVA class and reflection to call the technology of JAVA function, load and carry out the business realizing class, read source data file, generate target data file, (for example use in order to other system, the data file import tool that utilizes database to carry, record in target data file is loaded in Database Systems), its progress monitoring interface as shown in Figure 5.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 606 is first obtained the transformation rule status information to judge whether this transformation rule compiled from data conversion rule storage subsystem 602; If the state of this transformation rule is marked as " compiling ", telecommunication service Data Dynamic converting system 600 is directly skipped the code that the JAVA source code dynamically generates and the virtual function of compiling generation JAVA is carried out, and is carried out dynamically generating the telecommunication service data file by data conversion rule scheduler subsystem 606.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 604 provides patterned interface for users customization telecommunication service data conversion rule, and it comprises that mainly the graphical display module 6041 of data conversion rule, data conversion rule configuration wizard module 6042, data conversion rule import/derive module 6043, collection of functions configuration module 6044, self-defining function and import/derive module 6046 to guide module 6045 and function.
Wherein, the graphical display module 6041 of data conversion rule, the tree-shaped information that represents with transformation rule that be used for to be responsible for the transformation rule list represents.Specifically, the service identification information of the transformation rule that the graphical display module 6041 of data conversion rule has customized the user as Business Name etc., shows in tree-shaped mode; During certain tree node, show the details of this business corresponding data transformation rule in the viewing area, and can modify and delete selected transformation rule in elected.
Data conversion rule configuration wizard module 6042 is used for being responsible for the definition that the guiding user progressively completes transformation rule.Specifically, the definition of 6042 pairs of transformation rules of data conversion rule configuration wizard module comprises: the service identification definition, the formal definition of this service source data file, the formal definition of this business objective data file, and the definition of the transformation rule of each field in this business objective document format data.Wherein the formal definition of this service source data file comprises and cuts apart type and segmentation symbol between definition record line Separator number, record field, and the information such as title, type and length of each field in record.The formal definition of this business objective data file comprises list separator, the file destination name between definition record line Separator number, record field, the title of each record field, type, length and output order, and the information such as conversion order.In this business objective document format data, the definition of the transformation rule of each field comprises that some functions that call function is in certain sequence concentrated define the transformation rule of each field in this business objective document format data; Specifically, mainly comprise function name and function parameter.Wherein, function parameter can be the rreturn value of any one other function call before the quoting of certain field value in the quoting of: certain field value in systematic parameter (as service identification, source data file name, account phase etc.), source data file form, target data file form, this function call, and constant.
Data conversion rule imports/derives module 6043, is used for being responsible for importing and deriving selected transformation rule, for user ID and/or deployment.This data conversion rule imports/derives module 6043 and can facilitate the timely Backup Data conversion rule information of user and fast transferring to dispose.
Collection of functions configuration module 6044 is used for the collection of functions that has customized is safeguarded; Be specifically related to the operation such as modification, deletion to selected function.
Self-defining function is used for being responsible for to guide module 6045 definition that the guiding user completes function.The user can complete replenishing the self-defined of function to the guiding of guide module 6045 a step by a step according to self-defining function, is specifically related to draw together the information such as customization function name, the required bag of function (package), function input parameter, function output parameter and function body.
Function imports/derives module 6046, is used for importing/derivative function collection or single function, for user ID and/or deployment.This function imports/derives module 6046 and can facilitate the timely backup function information of user and fast transferring to dispose.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 604 also comprises: systematic parameter module and system journal module; Wherein the systematic parameter module, be used for being responsible for the information such as configure and maintenance database server parameter, access account; The system journal module is used for being responsible for centralized collection and storing the mistake that data conversion rule build environment subsystem 604 occurs, as information such as exception error, Operation Logs.
Fig. 7 illustrates the structural representation according to a specific embodiment of telecommunication service Data Dynamic converting system of the present invention.As shown in Figure 7, telecommunication service Data Dynamic converting system 700 mainly comprises: data conversion rule storage subsystem 702, data conversion rule build environment subsystem 704 and data conversion rule scheduler subsystem 706.
Wherein, data conversion rule storage subsystem 702 is used for depositing store electricity communication service data conversion rule information and collection of functions, comprises the transformation rule of the telecommunication service data that the user customizes in advance, the compiling state of transformation rule, and the information such as collection of functions.
Data conversion rule build environment subsystem 704 is used for receiving the user to the configuration of telecommunication service data conversion rule by graphic interface, will revise or the information of the transformation rule of increase is saved in data conversion rule storage subsystem 702; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 704 provides patterned interface (as shown in Figure 4), carry out data conversion rule configure and maintenance collection of functions for the user, and provide DLL (dynamic link library) to carry out self-defined and the spread function collection to (possessing the JAVA programming experience) advanced level user, thereby satisfy the demand of user individual.
Data conversion rule scheduler subsystem 706 is used for obtaining the telecommunication service data conversion rule from data conversion rule storage subsystem 702; According to the template of transformation rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out the business realizing class, source data file is generated target data file.in an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 406 is according to service identification (being generally digitized service code), obtain the telecommunication service data conversion rule information that has configured from data conversion rule storage subsystem 702, and according to business realizing class masterplate file, D ynamic instantiation generates business realizing class JAVA source code file, then compiling generates the program code that the virtual function of JAVA is carried out, adopt dynamic load JAVA class and reflection to call the technology of JAVA function, load and carry out the business realizing class, read source data file, generate target data file, (for example use in order to other system, the data file import tool that utilizes database to carry, record in target data file is loaded in Database Systems), its progress monitoring interface as shown in Figure 5.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 706 is first obtained the transformation rule status information to judge whether this transformation rule compiled from data conversion rule storage subsystem 702; If the state of this transformation rule is marked as " compiling ", telecommunication service Data Dynamic converting system 700 is directly skipped the code that the JAVA source code dynamically generates and the virtual function of compiling generation JAVA is carried out, and is carried out dynamically generating the telecommunication service data file by data conversion rule scheduler subsystem 706.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 706 comprises source code generator 7062 and compilation of source code device 7064.Wherein, source code generator 7062 is in order to according to data conversion rule, and instantiation business realizing class source code template file generates business realizing class JAVA source code file; Compilation of source code device 7064 generates in order to compile business realizing class JAVA source code file the code that the virtual function of JAVA is carried out.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 706 also comprises: data conversion module, data file module for reading and writing, mistake processing module, systematic parameter module and system journal module.Wherein data conversion module, be used for dynamic load JAVA class, adopts the JAVA executable code program of reflection technology scheduled for executing business rule, the source data file record that reads converted to the target data file record, and write in target data file.The data file module for reading and writing is used for being responsible for reading of data source file and writing of target data file.The mistake processing module is used for being responsible for centralized collection and disposal system mistake, as situations such as file read-write mistake, data-switching mistakes.The systematic parameter module is used for being responsible for the information such as configure and maintenance database server parameter, access account, data-switching Thread Count, data file read-write buffer size.The system journal module, the log information for being responsible for the register system operational process comprises compiling information, data-switching information etc.
Fig. 8 illustrates the process flow diagram according to a concrete application examples of telecommunication service Data Dynamic conversion method of the present invention.
As shown in Figure 8, step 802, log-on data transformation rule build environment subsystem.
Step 804 is selected the transformation rule configuration wizard.For example, the user is the business rule configuration wizard in data conversion rule build environment subsystem, progressively completes layoutprocedure to the telecommunication service data conversion rule in order to guide the user.
Step 814 is obtained telecommunication service data conversion rule compiling status information.For example, data conversion rule scheduler subsystem is obtained the telecommunication service data conversion rule information corresponding with the service code parameter from the data conversion rule storage subsystem, and directly read transformation rule compiling status information, be used for judging whether this transformation rule compiled.
Step 816 judges whether transformation rule compiles.If confirm that according to the transformation rule compiling status information of obtaining this transformation rule did not compile, execution in step 818; Otherwise directly jump to step 824.
Step 818 is obtained the telecommunication service data conversion rule that presets according to service identification.In an embodiment of telecommunication service Data Dynamic conversion method provided by the invention, directly obtain the telecommunication service data conversion rule according to service identification (being generally digitized service code) from the telecommunication service data conversion rule information of storage.
Step 820 according to the template of data conversion rule with the business realizing class that presets, dynamically generates the JAVA source code of business realizing class.For example, obtain according to service identification the business rule information that has configured in step 818, subsequently according to business realizing class masterplate file, D ynamic instantiation generates business realizing class JAVA source code file.
Fig. 9 illustrates the process flow diagram according to a concrete application examples of the system of telecommunication service Data Dynamic conversion of the present invention.The system 900 of the conversion of telecommunication service Data Dynamic as shown in Figure 9, comprises: data conversion rule storage subsystem 902, data conversion rule build environment subsystem 904 and data conversion rule scheduler subsystem 906.
Wherein, data conversion rule storage subsystem 902 is used for depositing store electricity communication service data conversion rule information and collection of functions, comprises the transformation rule of the telecommunication service data that the user customizes in advance, the compiling state of transformation rule, and the information such as collection of functions.
Transformation rule build environment subsystem 904 is used for receiving the user to the configuration of telecommunication service data conversion rule by graphic interface, will revise or the information of the transformation rule of increase is saved in data conversion rule storage subsystem 902; And the User-Defined Functions DLL (dynamic link library) is provided, for user's spread function collection.In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule build environment subsystem 904 provides patterned interface for users customization telecommunication service data conversion rule, it comprises: data conversion rule configuration module 9042, collection of functions configuration module 9044, system maintaining module 9046; Wherein, data conversion rule configuration module 9042 comprises: data conversion rule is safeguarded submodule 90422, and the tree-shaped information that represents with transformation rule that be used for to be responsible for the transformation rule list represents; Data conversion rule configuration wizard submodule 90424 is used for being responsible for the definition that the guiding user progressively completes transformation rule; Data conversion rule imports/derives submodule 90426, is used for being responsible for importing and deriving selected transformation rule, for user ID and/or deployment.Collection of functions configuration module 9044 comprises: collection of functions is safeguarded submodule 90442, is used for the collection of functions that presets is safeguarded, relates to the operations such as modification to selected function, deletion; Self-defining function guide submodule 90444 is used for being responsible for the definition that the guiding user completes function; Function imports/derives submodule 90446, is used for importing/derivative function collection or single function, for user ID and/or deployment.System maintaining module 9046 comprises systematic parameter submodule 90462 and system journal submodule 90464, is respectively used to the systematic parameter of configure and maintenance data conversion rule build environment subsystem 904, generates and stores system journal.
Data conversion rule scheduler subsystem 906 is used for obtaining the telecommunication service data conversion rule from data conversion rule storage subsystem 902; According to the template of transformation rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out the business realizing class, source data file is generated target data file.In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 906 comprises: data conversion rule engine 9062 and system maintaining module 9064; Wherein, data conversion rule engine 9062 comprises: source code generator 90622 is used for dynamically generating the JAVA source code file of business realizing class according to the template of data conversion rule with the business realizing class that presets; Compilation of source code device 90624, the JAVA source code file for compiling business realizing class generates the JAVA program code; And data conversion rule processor 90626, be used for reading and writing data file, be responsible for the telecommunication service data-switching; And concentrate and the disposal system mistake.System maintaining module 9064 comprises: systematic parameter submodule 90642, for the systematic parameter of configure and maintenance data conversion rule scheduler subsystem 906; System journal submodule 90644 is used for the system journal of generation and storage data conversion rule scheduler subsystem 906.
In an embodiment of telecommunication service Data Dynamic converting system provided by the invention, data conversion rule scheduler subsystem 906 is first obtained the transformation rule status information to judge whether this transformation rule compiled from data conversion rule storage subsystem 902; If the state of this transformation rule is marked as " compiling ", telecommunication service Data Dynamic converting system 900 is directly skipped the code that the JAVA source code dynamically generates and the virtual function of compiling generation JAVA is carried out, and is carried out dynamically generating the telecommunication service data file by data conversion rule scheduler subsystem 906.
ETL instrument in the market because be not optimized processing for the telecommunication service data characteristics, therefore, fails to obtain balance preferably between dirigibility and efficient.The present invention is directed to the telecommunication service data characteristic and set up abundant collection of functions, the function self defined interface is provided simultaneously, be convenient to user's spread function collection; Be different from current script explanation type ETL instrument, the present invention adopts dynamic generation source code, on-the-flier compiler, and the mode of dynamic load and run time version, effectively improved data conversion efficiency, can avoid the modification of the ETL implementing procedure code that causes when change occurs telecommunication service data-switching demand, have very strong practicality.A specific embodiment as telecommunication service Data Dynamic conversion method provided by the invention and system thereof, telecommunication service Data Dynamic converting system is successfully used in the telecom operation system of Guangdong Telecom branch office of China Telecom, and has obtained good Expected Results.
The carried out JAVA code of the disposable generation telecommunication service of telecommunication service Data Dynamic conversion method and system thereof the data conversion rule based on collection of functions provided by the invention.When carrying out the data-switching of certain specified services, system can first check the compiling state of the transformation rule that this business is corresponding; If the compiling status indication of this transformation rule is for compiling, the generation of JAVA source code and JAVA code compilation link are skipped by system, and directly use the JAVA reflection technology to start this business " dynamically generating the telecommunication service data file "; Thereby more efficiently, realize that neatly the present invention is to telecommunication service data-switching and excavation.
In addition, the present invention is in the telephone number split process, preferentially by mate (for example, to domestic area code, preferential matching length be 3 area code) of length to common access code and area code, minimizing matching times that like this can be suitable, thereby the conversion efficiency of raising data.And use technology and the methods such as multithreading and multimode collaborative work, improve the parallel processing capability of system; With needing standardized dimension table data in data conversion process, be synchronized in internal memory, improve the data normalization inquiry velocity.The present invention sees on the whole, because the phase is adopted the whole telecommunication service Data Dynamic converting system of pure JAVA design, thereby can obtain good professional platform independence.
Although reference example embodiment has described the present invention, should be appreciated that, the present invention is not limited to disclosed exemplary embodiment.Many modifications and variations are apparent for the ordinary skill in the art.Selecting and describing embodiment is for better explanation principle of the present invention and practical application, thereby and makes those of ordinary skill in the art can understand the various embodiment with various modifications that the present invention's design is suitable for special-purpose.
Claims (15)
1. the method for a telecommunication service Data Dynamic conversion, is characterized in that, described method comprises:
Obtain the telecommunication service data conversion rule that presets according to service identification;
According to the template of described data conversion rule with the business realizing class that presets, dynamically generate the JAVA source code of described business realizing class, and compiling generates the JAVA program code;
Dynamic load is also carried out described business realizing class, and source data file is generated target data file;
Described dynamic load and the step of carrying out described business realizing class comprise:
Adopt dynamic load JAVA class technology and reflection to call JAVA function technology dynamic load and carry out described business realizing class and the function that calls described business realizing class, the function of described business realizing class comprises the collection of functions according to the customization of telecommunication service data characteristics.
2. method according to claim 1, is characterized in that, also comprises:
The basic function collection is provided, and the User-Defined Functions DLL (dynamic link library) is provided.
3. method according to claim 1, is characterized in that, described method also comprises step:
Receive the user to the configuration of described data conversion rule by graphic interface.
4. method according to claim 1, is characterized in that, described method also comprises step:
Receive the user to definition and/or the expansion of collection of functions by graphic interface.
5. method according to claim 1, is characterized in that, described collection of functions comprises the function that splits access code, area code, operator's informaiton from telephone number.
6. the system of a telecommunication service Data Dynamic conversion, is characterized in that, described system (300,900) comprising:
Data conversion rule storage subsystem (302,902) is used for store electricity communication service data conversion rule and collection of functions, and described collection of functions comprises the function according to the customization of telecommunication service data characteristics;
Data conversion rule scheduler subsystem (306,906) is used for obtaining described telecommunication service data conversion rule from described data conversion rule storage subsystem (302,902); According to the template of described transformation rule with the business realizing class that presets, dynamically generate the JAVA source code of business realizing class, and compiling generates the JAVA program code; And dynamic load and carry out described business realizing class and call the function of described business realizing class, generate target data file according to source data file.
7. system according to claim 6, it is characterized in that, described system also comprises data conversion rule build environment subsystem (304,904), be used for receiving the user to the configuration of described telecommunication service data conversion rule by graphic interface, the described data conversion rule of revising or increase is saved in described data conversion rule storage subsystem (302,902); And the User-Defined Functions DLL (dynamic link library) is provided, expand described collection of functions for the user.
8. system according to claim 7, is characterized in that, described data conversion rule build environment subsystem (904) comprising:
Data conversion rule configuration module (9042) is used for the described data conversion rule that presets is safeguarded that the guiding user configures new data conversion rule, and is responsible for importing/deriving selected described data conversion rule;
Collection of functions configuration module (9044) is used for the described collection of functions that presets is safeguarded, is responsible for the guiding user and configures new function, and import/derive described collection of functions or single function;
System maintaining module (9046) is used for storing the systematic parameter of described data conversion rule build environment subsystem (904) and the system journal of generation.
9. system according to claim 8, is characterized in that, described data conversion rule configuration module (9042) comprising:
Data conversion rule is safeguarded submodule (90422), and the tree-shaped information that represents with described transformation rule that be used for to be responsible for the transformation rule list represents;
Data conversion rule configuration wizard submodule (90424) is used for being responsible for the configuration that the guiding user progressively completes described data conversion rule;
Data conversion rule imports/derives submodule (90426), is used for being responsible for importing and deriving selected described transformation rule, for user ID and/or deployment.
10. system according to claim 8, is characterized in that, described collection of functions configuration module (9044) comprising:
Collection of functions is safeguarded submodule (90442), is used for the described collection of functions that presets is safeguarded;
Self-defining function guide submodule (90444) is used for being responsible for the definition that the guiding user completes described function;
Function imports/derives submodule (90446), is used for importing/deriving described collection of functions or single function, for user ID and/or deployment.
11. system according to claim 8 is characterized in that, described system maintaining module (9046) comprising:
Systematic parameter submodule (90462) is for the systematic parameter of the described data conversion rule build environment of configure and maintenance subsystem (904);
System journal submodule (90464) is used for the system journal that generates and store described data conversion rule build environment subsystem (904).
12. system according to claim 6 is characterized in that, described data conversion rule scheduler subsystem (906) comprising:
Data conversion rule engine (9062) is used for obtaining the telecommunication service data conversion rule from described data conversion rule storage subsystem (302,902); Dynamically generate the JAVA source code of described business realizing class, and compiling generates described JAVA program code; And dynamic load and carry out described business realizing class, source data file is generated target data file;
System maintaining module (9064) is used for storing the systematic parameter of described data conversion rule scheduler subsystem (906) and the system journal of generation.
13. system according to claim 12 is characterized in that, described data conversion rule engine (9062) comprising:
Source code generator (90622) is used for the template according to described data conversion rule and the described business realizing class that presets, and dynamically generates the JAVA source code file of business realizing class;
Compilation of source code device (90624), the JAVA source code file for compiling described business realizing class generates described JAVA program code; And
Data conversion rule processor (90626) is used for reading and writing data file, is responsible for the conversion of telecommunication service data; And concentrate and the disposal system mistake.
14. system according to claim 12 is characterized in that, described system maintaining module (9064) comprising:
Systematic parameter submodule (90642) is for the systematic parameter of the described data conversion rule scheduler subsystem of configure and maintenance (906);
System journal submodule (90644) is for the system journal that generates and store described data conversion rule scheduler subsystem (906).
15. system according to claim 6 is characterized in that, the described collection of functions of described data conversion rule storage subsystem (302,902) storage comprises for split the function of access code, area code, operator's informaiton from telephone number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910152289.8A CN101958987B (en) | 2009-07-14 | 2009-07-14 | Method and system for dynamically converting telecommunications service data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910152289.8A CN101958987B (en) | 2009-07-14 | 2009-07-14 | Method and system for dynamically converting telecommunications service data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101958987A CN101958987A (en) | 2011-01-26 |
| CN101958987B true CN101958987B (en) | 2013-06-26 |
Family
ID=43486085
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910152289.8A Active CN101958987B (en) | 2009-07-14 | 2009-07-14 | Method and system for dynamically converting telecommunications service data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101958987B (en) |
Families Citing this family (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104050161B (en) * | 2013-03-11 | 2017-05-17 | Sap欧洲公司 | Dynamic bridging of application and data servers |
| EP3007064A4 (en) * | 2014-01-16 | 2016-09-28 | Huawei Tech Co Ltd | Method for loading code and network apparatus |
| CN105022620B (en) * | 2014-04-28 | 2019-06-25 | 上海未达数码科技有限公司 | A kind of applied software development method based on mobile platform |
| CN104461544B (en) * | 2014-12-12 | 2017-11-07 | 用友网络科技股份有限公司 | Encode dynamic generation apparatus and method |
| CN105205117B (en) * | 2015-09-09 | 2019-03-05 | 郑州悉知信息科技股份有限公司 | A kind of tables of data moving method and device |
| CN105653268A (en) * | 2015-12-28 | 2016-06-08 | 中国民航信息网络股份有限公司 | Rule engine debugging method and rule engine debugging system |
| CN105677353A (en) * | 2016-01-08 | 2016-06-15 | 北京物思创想科技有限公司 | Feature extraction method and machine learning method and device thereof |
| CN107295039B (en) * | 2016-03-31 | 2021-04-20 | 创新先进技术有限公司 | Data access processing method and device |
| CN107357792B (en) * | 2016-05-10 | 2019-12-31 | 北京京东尚科信息技术有限公司 | Data analysis method and device |
| CN106227710A (en) * | 2016-07-26 | 2016-12-14 | 浪潮通用软件有限公司 | A kind of data file transition collocation method based on EXCEL |
| CN106227855A (en) * | 2016-07-28 | 2016-12-14 | 努比亚技术有限公司 | A kind of transacter, system and method |
| CN108550037B (en) * | 2018-04-11 | 2022-05-17 | 北京知金链网络技术有限公司 | File processing method and device based on block chain |
| CN109254951A (en) * | 2018-08-22 | 2019-01-22 | 北京知金链网络技术有限公司 | A kind of method and apparatus that the card customized deposit system of platform is deposited based on block chain |
| CN109710428B (en) * | 2018-12-27 | 2021-07-13 | 杭州数梦工场科技有限公司 | Dynamic calling method and device for implementation class |
| CN109753536A (en) * | 2019-01-15 | 2019-05-14 | 顺丰科技有限公司 | A kind of data docking facilities and method |
| CN110297859B (en) * | 2019-06-10 | 2021-07-06 | 恩亿科(北京)数据科技有限公司 | Method and apparatus for processing real-time data |
| CN110502910B (en) * | 2019-08-07 | 2021-03-30 | 珍岛信息技术（上海）股份有限公司 | Cloud information storage system based on data encryption |
| CN111143446A (en) * | 2019-11-26 | 2020-05-12 | 贝壳技术有限公司 | Data structure conversion processing method and device of data object and electronic equipment |
| CN111142852B (en) * | 2019-12-30 | 2023-10-27 | 亚信科技（中国）有限公司 | Interface conversion function generation method and device |
| CN115277803A (en) * | 2022-07-21 | 2022-11-01 | 广州鑫景信息科技服务有限公司 | Message management method, system, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007038231A2 (en) * | 2005-09-23 | 2007-04-05 | Busniess Objects, S.A. | Apparatus and method for data profile based construction of an extraction, transform, load (etl) task |
| CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
| CN101101651A (en) * | 2007-08-01 | 2008-01-09 | 中兴通讯股份有限公司 | Conversion processing method, system and conversion rule engine for electronic worksheet data |
| CN101169798A (en) * | 2007-12-06 | 2008-04-30 | 中国电信股份有限公司 | Data excavation system and method |
| CN101364240A (en) * | 2008-10-14 | 2009-02-11 | 杭州华三通信技术有限公司 | Metadata management method and device |
-
2009
- 2009-07-14 CN CN200910152289.8A patent/CN101958987B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007038231A2 (en) * | 2005-09-23 | 2007-04-05 | Busniess Objects, S.A. | Apparatus and method for data profile based construction of an extraction, transform, load (etl) task |
| CN101075304A (en) * | 2006-05-18 | 2007-11-21 | 河北全通通信有限公司 | Method for constructing decision supporting system of telecommunication industry based on database |
| CN101101651A (en) * | 2007-08-01 | 2008-01-09 | 中兴通讯股份有限公司 | Conversion processing method, system and conversion rule engine for electronic worksheet data |
| CN101169798A (en) * | 2007-12-06 | 2008-04-30 | 中国电信股份有限公司 | Data excavation system and method |
| CN101364240A (en) * | 2008-10-14 | 2009-02-11 | 杭州华三通信技术有限公司 | Metadata management method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101958987A (en) | 2011-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101958987B (en) | Method and system for dynamically converting telecommunications service data | |
| US7320007B1 (en) | Dynamic generation of target files from template files and tracking of the processing of target files | |
| US9092443B2 (en) | Dynamic generation of target files from template files and tracking of the processing of target files | |
| US9026901B2 (en) | Viewing annotations across multiple applications | |
| CN100520718C (en) | Script order registration method, method and device for calling source program code | |
| CN111078702B (en) | SQL sentence classification management and unified query method and device | |
| CN1968154A (en) | System and method for service expansion using plug | |
| US20070005648A1 (en) | Network capacity management system | |
| US20080195622A1 (en) | Service provisioning system | |
| CN100561476C (en) | A kind of code generating method based on the ASN type object | |
| CN103593457B (en) | Method for converting document format | |
| CN103744647A (en) | Java workflow development system and method based on workflow GPD | |
| CN104750472B (en) | The resource package management method and device of a kind of terminal applies | |
| CN101499063A (en) | Tracing-based database schema evolution method and system | |
| CN102999600A (en) | Method and system for automatically generating embedded database | |
| CN102289774A (en) | Graphical message processing and test system and method in financial transaction processing system | |
| CN107797823A (en) | Business Rule Management method, apparatus, storage medium and computer equipment | |
| CN103390018A (en) | Web service data modeling and searching method based on SDD (service data description) | |
| CN102521008B (en) | Program compiling device and method for compiling program | |
| Onose et al. | XQuery at your web service | |
| CN109116828A (en) | Model code configuration method and device in a kind of controller | |
| CN105468793A (en) | Automated management method for simulation model data | |
| CN109992585A (en) | Data lead-in method for office management system | |
| CN103593188A (en) | System and method for managing what-you-see-is-what-you-get menus of instrument | |
| CN103501341A (en) | Method and device for establishing Web service |
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 |