CN101335763B - Data educing and transmitting method in intelligent network system - Google Patents

Data educing and transmitting method in intelligent network system Download PDF

Info

Publication number
CN101335763B
CN101335763B CN 200710123400 CN200710123400A CN101335763B CN 101335763 B CN101335763 B CN 101335763B CN 200710123400 CN200710123400 CN 200710123400 CN 200710123400 A CN200710123400 A CN 200710123400A CN 101335763 B CN101335763 B CN 101335763B
Authority
CN
China
Prior art keywords
data
file
item
task
transmission
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Fee Related
Application number
CN 200710123400
Other languages
Chinese (zh)
Other versions
CN101335763A (en
Inventor
修文飞
李蕊
张擘
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE Corp
Original Assignee
ZTE Corp
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 ZTE Corp filed Critical ZTE Corp
Priority to CN 200710123400 priority Critical patent/CN101335763B/en
Publication of CN101335763A publication Critical patent/CN101335763A/en
Application granted granted Critical
Publication of CN101335763B publication Critical patent/CN101335763B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Abstract

The invention discloses a method for data leading-out and data transmitting in an intelligent network. Data leading-out and data transmission are made into two absolute universal tasks, novel leading-out and transmission requirement of operator can be performed by adding novel configuring items in the configuration files. It is only needed to add novel configuring items rather than modifying codes according to the novel requirement of each data leading-out and transmission aspect; and it is only needed to test configuring items rather than repeatedly testing codes of data leading-out tasks and data transmission tasks, accordingly commendably resolving the problem of longer development time and test time and serious human resources consumption existing in the prior art which results from customizing a corresponding task to each data leading-out requirement and/or data transmission requirement of operators, improving the efficiency of development and test, and reducing investment to human resources.

Description

The method of data derivation and transfer of data in the intelligent net system
Technical field
The present invention relates to intelligent network technology, relate in particular to that data in the intelligent net system derive and the method for transfer of data.
Background technology
Along with the development of intelligent network business, operator is for the consideration of statistics, accounting checking aspect, and often proposition need to export to file with all or part of data of intelligent net system inside, and offers the demand of third party or office side oneself use.
Because the purpose of the demands such as third party's statistics of each operator, accounting checking is also inconsistent, therefore different operators is also inconsistent to the requirement of data, even same operator, the demand of different regions also may be inconsistent, in addition, in the demand side of data, the needs that have be month data, and have plenty of day data, the requirement that has is passed through FTP (File Transfer Protocol with file, file transfer protocol (FTP)) be transferred to the third party, what have does not need transmission, and is read by other task.
Because demand is inconsistent, therefore generally all be that the demand that derives of data to operator or the demand by the FTP transmission all customize a task separately in the prior art, perhaps the task of demand customization that reaches by the FTP transmission is derived in data of operator, different demands according to operator are carried out different codings, configuration, and can the data that will produce require at required time task each task, the other side that is transferred to that correct carry out repeatedly test, after treating that all tests are passed through, just can take on-the-spot the use.Owing to need to test each task, therefore expend a large amount of human resources.
Also there is the another one problem in the above-mentioned processing mode, be that prior art is to require the different task of customization according to the difference of operator, have new data to derive at every turn or the transfer of data demand after, see first and can make amendment on the basis of existing task, if can not, realize with regard to increasing new task.After several times change, not only the maintenance of original task becomes very complicated, and on-the-spot task number increases again and again, all can cause very large inconvenience to daily maintenance, upgrading, in case one of them or several task have been omitted in upgrading, all will cause serious consequence.
Summary of the invention
The invention provides that data in a kind of intelligent net system derive and the method for transfer of data, derive the task that demand and/or transfer of data demand will customize a correspondence in order to solve in the prior art each data for operator, thereby cause development time and testing time longer, human resources expend serious problem.
The method that data derive in a kind of intelligent net system comprises step:
A, derive demand according to data and derive in the configuration file of task configuration in data and derive, respectively derive and be respectively arranged with data derivation statement, the time of implementation of deriving item and the preserving type of export in the item, data derivation task is added in the system task tabulation;
B, calling data are derived task, according to the derivation item time of implementation that arranges in the configuration file, set up the derived data script, set up temporary view, derivation meets from database derives a data that require, and it is preserved according to deriving the preserving type that arranges in the item.
Better, define storing path, the preservation title of export in the described preserving type and kept duration;
After the storage duration of described export arrives described reservation duration, this export is deleted from storing path.
Better, also be included as the step that data derivation task arranges running time in the described steps A.
Better, described step B specifically comprises step:
Derive task according to pre-configured calling data running time, read successively the derivation item that arranges in the configuration file, determine the derivation item of this needs operation according to time of implementation of each derivation item;
Corresponding data are derived in requirement according to the described derivation item of determining from database, it is preserved according to the preserving type that arranges in this derivation item.
The method of transfer of data in a kind of intelligent net system comprises step:
A, in the configuration file of data transfer task, dispose FTP transmission according to the transfer of data demand, be respectively arranged with in each transmission transmission time of implementation, need title, source address and the destination address of the data file of transmission, data transfer task is added in the system task tabulation;
B, calling data transformation task are initiated FTP according to the transmission item time of implementation that arranges in the configuration file and are operated, and data file is transferred to destination address from source address.
Better, specify the store path of data file in this locality in the source address of described data file, specified the user name of address, purpose ftp server of purpose ftp server and password, the store path of data file in the purpose ftp server in the destination address of described data file.
Better, further be provided with the backup path of data file and the reservation duration of backup file in the described transmission item;
When data file is transferred to destination address from source address,,, after the storage duration of this backup file arrives described reservation duration, this backup file is deleted from backup path in the described data file of local backup according to the backup path that arranges in the transmission item.
Better, also be included as the step that data transfer task arranges running time in the described steps A.
Better, described step B specifically comprises step:
Calling data transformation task running time according to pre-configured reads the transmission item that arranges in the configuration file successively, determines the transmission item of this needs operation according to the time of implementation of each transmission item;
Initiate the FTP operation according to the information that arranges in the described transmission item of determining, file is configured to BIN mode or ASC II mode, data file is transferred to destination address from source address.
The present invention has changed the data derivation of existing intelligent net system and the implementation of transfer of data, the data derivation is made two independently common tasks with transfer of data, just can be undertaken by the mode that in configuration file, increases new configuration item for the new derivation of operator and the demand of transmission, accomplishing derives each data of operator, the new demand of transmission aspect, need not revise code, only needing to increase new configuration item gets final product, each test also only needs the test configurations item, and do not need the retest data to derive the code of task and data transfer task, thereby solved well in the prior art each data for operator and derived the task that demand and/or transfer of data demand will customize correspondence, its development time and testing time are longer, human resources expend serious problem, not only improved the efficient of development﹠ testing, reduce the input of human resources, made things convenient for simultaneously the upgrading of system, safeguard.
Description of drawings
Fig. 1 is the flow chart of the method that data derive in the intelligent net system of the present invention;
Fig. 2 is the flow chart of the method for transfer of data in the intelligent net system among the present invention.
Embodiment
The present invention has changed the data derivation of existing intelligent net system and the implementation of transfer of data, the data derivation is made two independently common tasks with transfer of data, just can be undertaken by the mode that in configuration file, increases new configuration item for the new derivation of operator and the demand of transmission like this, accomplishing derives each data of operator, the new demand of transmission aspect, need not revise code, only needing to increase new configuration item gets final product, each test also only needs the test configurations item, and does not need the retest data to derive the code of task and data transfer task.
Below in conjunction with each accompanying drawing specific implementation process of the present invention is carried out further detailed elaboration.
See also Fig. 1, this figure is the flow chart of the method that data derive in the intelligent net system of the present invention, and its main implementation procedure is:
Step 10, derive demand according to the data of operator and derive in the configuration file of task configuration in data and derive, be respectively arranged with during each is derived time of implementation that SQL (standardization query language) statement that derived data uses derives and export storing path, preserve title and keep duration;
Wherein, the naming method that the preservation title of export should the support of employing system defines.
Step 11, data derivation task is added in the system task tabulation, for data derivation task arranges running time, for example can data derivation task be set to the day operation mode, namely call a secondary data in the set time of every day and derive task.
Step 12, according to pre-configured running time calling data derive task, read successively the derivation item that arranges in the configuration file, the time of implementation that arranges in deriving is determined the derivation item of this needs operation according to each;
Step 13, set up the derived data script according to the requirement of the derivation item of this needs operation of determining in the step 12, set up temporary view, from database, derive corresponding data, it is preserved according to the preserving type that arranges in deriving.
After the storage duration of described export arrives described reservation duration, this export is deleted from storing path.
See also Fig. 2, this figure is the flow chart of the method for transfer of data in the intelligent net system among the present invention, and its main implementation procedure is:
Step 20, in the configuration file of data transfer task, dispose FTP transmission according to the transfer of data demand, be respectively arranged with in each transmission transmission time of implementation, need title, source address and the destination address of the data file of transmission;
Wherein, specify the store path of data file in this locality in the source address of described data file, specified the user name of address, purpose ftp server of purpose ftp server and password, the store path of data file in the purpose ftp server in the destination address of described data file.In addition, can also further be provided with the backup path of data file and the reservation duration of backup file in the described transmission item.
Step 21, data transfer task is added in the system task tabulation, for data transfer task arranges running time, for example can be set to the day operation mode by data transfer task, namely call data transfer task one time in the set time of every day.
Step 22, according to pre-configured calling data transformation task running time, read successively the transmission item that arranges in the configuration file, determine the transmission item of this needs operation according to time of implementation of each transmission.
Step 23, initiate the FTP operation according to the information that arranges in this transmission item that need to move of determining in the step 22, file is configured to BIN mode or ASC II mode, data file is transferred to destination address from source address.
In this step, can as required the FTP transmission means be configured to BIN mode or ASC II mode, when adopting the BIN mode that data file is transmitted between Windows system and Unix system, file is not made any change, and adopt ASC II mode with data file during from the Windows system to the Unix system transmissions, can automatically the new line symbol transition in the data file be the line feed symbol, opposite, when adopting ASC II mode that data file during from the Unix system to the Windows system transmissions, can be converted to the new line symbol with the line feed symbol in the data file automatically.The configurable of this option can make it not only can adapt to the Unix server so that the flexibility of transfer of data is larger, can also adapt to nt server.
If when being provided with the reservation duration of the backup path of data file and backup file in the transmission, in this step when data file is transferred to destination address from source address, need to be according to the backup path that arranges in the transmission item in the described data file of local backup, after the storage duration of this backup file arrives described reservation duration, this backup file is deleted from backup path.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, if of the present invention these are revised and modification belongs within the scope of claim of the present invention and equivalent technologies thereof, then the present invention also is intended to comprise these changes and modification interior.

Claims (7)

1. the method that data derive in the intelligent net system is characterized in that, comprises step:
A, derive demand according to data and derive in the configuration file of task configuration in data and derive, respectively derive and be respectively arranged with data derivation statement, the time of implementation of deriving item and the preserving type of export in the item, data derivation task is added in the system task tabulation, and for data derivation task be set running time;
B, according to pre-configured running time calling data derive task, according to the derivation item time of implementation that arranges in the configuration file, set up the derived data script, set up temporary view, read successively the derivation item that arranges in the configuration file, determine the derivation item of this needs operation according to time of implementation of each derivation item; Corresponding data are derived in requirement according to the described derivation item of determining from database, it is preserved according to the preserving type that arranges in this derivation item.
2. the method for claim 1 is characterized in that, has defined storing path, the preservation title of export in the described preserving type and has kept duration;
After the storage duration of described export arrives described reservation duration, this export is deleted from storing path.
3. transmit the method for utilizing the described method derived data of claim 1 in an intelligent net system, it is characterized in that, comprise step:
A, in the configuration file of data transfer task, dispose FTP transmission according to the transfer of data demand, be respectively arranged with in each transmission transmission time of implementation, need title, source address and the destination address of the data file of transmission, data transfer task is added in the system task tabulation;
B, calling data transformation task are initiated FTP according to the transmission item time of implementation that arranges in the configuration file and are operated, and data file is transferred to destination address from source address.
4. method as claimed in claim 3, it is characterized in that, specify the store path of data file in this locality in the source address of described data file, specified the user name of address, purpose ftp server of purpose ftp server and password, the store path of data file in the purpose ftp server in the destination address of described data file.
5. method as claimed in claim 3 is characterized in that, further is provided with the backup path of data file and the reservation duration of backup file in the described transmission item;
When data file is transferred to destination address from source address,,, after the storage duration of this backup file arrives described reservation duration, this backup file is deleted from backup path in the described data file of local backup according to the backup path that arranges in the transmission item.
6. method as claimed in claim 3 is characterized in that, also is included as the step that data transfer task arranges running time in the described steps A.
7. method as claimed in claim 3 is characterized in that, described step B specifically comprises step:
Calling data transformation task running time according to pre-configured reads the transmission item that arranges in the configuration file successively, determines the transmission item of this needs operation according to the time of implementation of each transmission item;
Initiate the FTP operation according to the information that arranges in the described transmission item of determining, file is configured to BIN mode or ASC II mode, data file is transferred to destination address from source address.
CN 200710123400 2007-06-28 2007-06-28 Data educing and transmitting method in intelligent network system Expired - Fee Related CN101335763B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 200710123400 CN101335763B (en) 2007-06-28 2007-06-28 Data educing and transmitting method in intelligent network system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 200710123400 CN101335763B (en) 2007-06-28 2007-06-28 Data educing and transmitting method in intelligent network system

Publications (2)

Publication Number Publication Date
CN101335763A CN101335763A (en) 2008-12-31
CN101335763B true CN101335763B (en) 2013-05-29

Family

ID=40198068

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 200710123400 Expired - Fee Related CN101335763B (en) 2007-06-28 2007-06-28 Data educing and transmitting method in intelligent network system

Country Status (1)

Country Link
CN (1) CN101335763B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102497436B (en) * 2011-12-16 2015-03-18 方正国际软件有限公司 Networked file storing method and system based on HTTP (Hyper Text Transport Protocol)
US20140359261A1 (en) * 2013-05-31 2014-12-04 Vordel Limited Environmentalization technique for promotion of application programming interface (api) server in lifecycle succession of deployments
CN106445951B (en) * 2015-08-07 2022-05-17 中兴通讯股份有限公司 File transmission method and device
CN107577527B (en) * 2017-08-30 2020-10-30 北京金山安全软件有限公司 Task generation and scheduling method and device
CN110830567A (en) * 2019-10-31 2020-02-21 中国银行股份有限公司 Data transmission method and device

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1408155A (en) * 1999-12-03 2003-04-02 艾利森电话股份有限公司 Method and arrangement for performing analysis of data network

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1408155A (en) * 1999-12-03 2003-04-02 艾利森电话股份有限公司 Method and arrangement for performing analysis of data network

Also Published As

Publication number Publication date
CN101335763A (en) 2008-12-31

Similar Documents

Publication Publication Date Title
CN103688250B (en) Use dynamic aspect to optimize data to process
US8495227B2 (en) Method and system to distribute policies
CN100407659C (en) Method for realizing software edition upgrading
US8554805B2 (en) Methods and systems for importing source data
CN101656928B (en) Short message processing method, system and assembly program unit
CN101335763B (en) Data educing and transmitting method in intelligent network system
CN101006424A (en) Universal upgrade architecture
CN101106784B (en) Information sorting and method, system and device for establishing initial network communication contact book
CN102314469A (en) Method for implementing cross-domain request callback
US6442569B1 (en) Apparatus and method for data transfer between databases
CN107193668A (en) The call method and system at interface service end
CN1973282A (en) System and method for managing a change to a cluster configuration
CN101211360A (en) System and method for processing a plurality of data form of report forms data source
CN109871221A (en) A kind of system for deployment mobile application software of quickly installing for mobile terminal device
WO2019043462A1 (en) Systems and methods for creating automated interface transmission between heterogeneous systems in an enterprise ecosystem
CN102609494A (en) Method for processing data of machine account and device
CN104578418B (en) Configuration method and system of automatic power distribution equipment based on 101 protocols, and equipment
CN109726213A (en) A kind of program code conversion method, device, medium and calculate equipment
CN103135991A (en) Customization implementation method of embedded device web interface
CN109857374A (en) The development approach and device of mobile application
CN105700966B (en) A kind of processing method and processing device of application program error
CN107220327A (en) Data query method and system based on MongoDB, service terminal, memory
CN107943980A (en) Method and apparatus for inquiring about device data
CN107329739A (en) Page menus method for customizing and device
CN105718536A (en) Mobile terminal order query method and system

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20130529

Termination date: 20160628