CN101594435B - Method and system for managing polyphonic service data - Google Patents
Method and system for managing polyphonic service data Download PDFInfo
- Publication number
- CN101594435B CN101594435B CN2009101486209A CN200910148620A CN101594435B CN 101594435 B CN101594435 B CN 101594435B CN 2009101486209 A CN2009101486209 A CN 2009101486209A CN 200910148620 A CN200910148620 A CN 200910148620A CN 101594435 B CN101594435 B CN 101594435B
- Authority
- CN
- China
- Prior art keywords
- statistical server
- data
- polyphonic
- interface
- service data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for managing polyphonic service data. The method comprises that: a polyphonic service system is connected with a statistic server and configures relevant information through a file transmission interface; a polyphonic service database establishes a view according to the configured relevant information, and exports initial data required by the statistic server; and the statistic server imports the initial data, and analyzes the data to acquire statistic data. The system comprises the polyphonic service system and the statistic server, wherein the polyphonic service system is connected with the statistic server through the file transmission interface. The method and the system make generation, storage and search of statistic data and output of relevant report forms separated from the polyphonic service system, solve the problems of dependency of statistic data generation on the service database self and occupation of mass historic data storage on storage resources of the service database server in the prior art, and effectively improve the operation speed of the polyphonic service system.
Description
Technical field
The present invention relates to the database management technology field, relate in particular to a kind of management method and system of polyphonic service data.
Background technology
Along with the development of multimedia ring service system, operator need carry out analytic statistics to a large number of services data, to obtain the business development data, better provides service targetedly.Existing multimedia ring service system provides the statistical requirements of statistics service function to realize that the user proposes in the polyphonic service data storehouse, the polyphonic service data storehouse also provides Service Data Management function, call data management function, bell sound data management function and statistics management function etc. simultaneously.Because the functional type finished of polyphonic service data storehouse is various, a large amount of daily callings and open an account, operations such as cancellation, bell tone audition, ring tone uploading are frequent to the Service Database visit, cause service database system busy.Simultaneously, the generation of statistics is directly carried out in the polyphonic service data storehouse, because the data volume that relates to during statistics is very big and the time of generation statistics file is longer, very likely cause Service Database to be in busy state for a long time, even influence is to the response and the processing of calling out, opening an account, cancellation, ring tone uploading etc. being operated.
Because historical data is such as because the user to the data volume that the bell sound is ordered, operation such as deletion produces, far away more than the data volume of bell sound data itself, takies space, mass data storehouse.The multimedia ring service system storage is on specialized database, for example: ORACLE database or sybase database.The necessary dependency database of the normal operation of multimedia ring service system, if problems such as busy appear in database, multimedia ring service system just can not normally move.In addition,, then need interim shutdown to change hard disk, so also can have influence on the normal operation of multimedia ring service system if want the hard disk in space, expanding data storehouse.
Along with the increasingly extensive application of Ring Back Tone service, also more and more at the secondary value-added service that Ring Back Tone service is born, wherein much need get access to all color ring datas that multimedia ring service system was handled, and it is carried out Business Processing, but the polyphonic service data storehouse of multimedia ring service system all is its nucleus module usually, generally do not allow multimedia ring service system user in addition directly to land visit, otherwise can influence the speed of service of multimedia ring service system, the privacy to information has also constituted certain threat simultaneously.
Summary of the invention
The technical problem to be solved in the present invention is, a kind of management method and system of polyphonic service data are provided, overcome the dependence of the generation of statistics in the prior art, and the preservation of a large amount of historical datas is to the defective that takies of multimedia ring service system storage resources to polyphonic service data storehouse itself.
The technical solution used in the present invention is that the management method of described a kind of polyphonic service data may further comprise the steps:
Step 1, multimedia ring service system link to each other with statistical server by the file transfer interface and dispose relevant information;
View is created according to the relevant information of configuration in step 2, polyphonic service data storehouse, and derives the required initial data of statistical server;
Step 3, statistical server import described initial data, and it is carried out analyzing and processing obtain statistics.
Step 1 Colorful Ring Service system configuration relevant information comprises:
The address information of configuration statistical server and the list structure of statistical server database;
In the configuration statistical server with the share directory of multimedia ring service system;
The cycle that the configuration multimedia ring service system is derived the required initial data of statistical server.
The process that derives the required initial data of statistical server in the step 2 is: regularly generate the raw data file of describing described view, and will put into the share directory of statistical server and multimedia ring service system by the file transfer interface.
Statistical server imports the process of described initial data and is in the step 3: read described raw data file under described share directory, and deposit it in statistical server database.
In the step 3 described initial data being carried out the mode that analyzing and processing obtains statistics is: statistical server provides at least a in a day task, all tasks and month task described initial data is carried out analyzing and processing, obtains the respective table that statistics deposits the statistical server database in.
The present invention also provides a kind of management system of polyphonic service data, and multimedia ring service system links to each other with statistical server by the file transfer interface, wherein,
Multimedia ring service system is used for obtaining initial data according to the relevant information of configuration from multimedia ring service system, and derives raw data file by the file transfer interface;
Statistical server is used to import described raw data file, and it is carried out analyzing and processing obtains statistics.
Described multimedia ring service system comprises polyphonic service data storehouse, polyphonic service data bank interface and polyphonic service data processing module, the polyphonic service data processing module, be used for creating view at the polyphonic service data bank interface according to the relevant information of configuration, from the polyphonic service data storehouse, obtain initial data by the polyphonic service data bank interface, and derive raw data file to statistical server by the file transfer interface;
The polyphonic service data bank interface is used for shadow data storehouse type, externally provides a unified interface to call for the polyphonic service data processing module;
The polyphonic service data storehouse is used to store the various log informations relevant with Ring Back Tone service.
Described statistical server comprises statistical server database, statistical server database interface and statistics processing module, the statistics processing module, be used for described raw data file being imported the statistical server database, and it is carried out analyzing and processing obtain statistics by the statistical server database interface.
The statistical server database interface is used for shadow data storehouse type, externally provides a unified interface to call for the statistics processing module;
The statistical server database is used to store the described raw data file that obtains from multimedia ring service system and handles the statistics file that obtains by analysis.
Adopt technique scheme, the present invention has following advantage at least:
The management method of polyphonic service data of the present invention and system, independent statistical server system has been proposed, making it pass through the file transfer interface links to each other with multimedia ring service system and disposes relevant information, view is created according to the list structure of statistical server database in the polyphonic service data storehouse, and the required initial data of derivation statistical server, finally import described initial data and it is carried out analyzing and processing and obtain statistics by statistical server, therefore, the present invention expands the data statistics function of multimedia ring service system, from multimedia ring service system, independently go out the generation of statistics, the output of storage and inquiry and relevant form, overcome preservation the taking Service Database server stores resource of the generation of statistics in the prior art to dependence and a large amount of historical datas of Service Database itself, effectively promote the multimedia ring service system speed of service, in addition, owing to do not have direct data to conduct interviews, its fail safe also be guaranteed to multimedia ring service system.
Description of drawings
Fig. 1 is the management method flow chart of the described polyphonic service data of first embodiment of the invention;
Fig. 2 is that the management system of the described polyphonic service data of second embodiment of the invention is formed schematic diagram;
Fig. 3 is that the management system of the described polyphonic service data of third embodiment of the invention is formed schematic diagram.
Embodiment
Reach technological means and the effect that predetermined purpose is taked for further setting forth the present invention, below in conjunction with accompanying drawing and preferred embodiment, the management method and the system of the described polyphonic service data that the present invention is proposed, describe in detail as after.
First embodiment of the invention, as shown in Figure 1, the management method of described polyphonic service data comprises following concrete steps:
Step 1, multimedia ring service system link to each other with statistical server by the file transfer interface and dispose relevant information.The file transfer interface can be FTP (File Transfer Protocol, file transfer protocol (FTP)) interface or TFTP (Trivial File Transfer Protocol, TFTP) interface.The relevant information of multimedia ring service system configuration comprises:
The address information of configuration statistical server and the list structure of statistical server database, if what the file transfer interface adopted is the FTP interface, then the address information of statistical server comprises IP address, user name, password, if what the file transfer interface adopted is the TFTP interface, then only need the IP address of configuration statistical server; The effect of the address information of configuration statistical server is to make multimedia ring service system can find statistical server accurately, and the effect of the list structure of configuration statistical server database is to make multimedia ring service system can unify to provide raw data file according to the list structure of statistical server database for it.
In the configuration statistical server with the share directory of multimedia ring service system;
Cycle and statistical server that the configuration multimedia ring service system is derived the required initial data of statistical server scan share directory to import the cycle of initial data, can also make statistical server can directly find the raw data file that need read for deriving the required initial data agreement filename of statistical server;
Optionally, can also dispose the maximum number of days that statistics keeps in the statistical server database--be to discharge database space, such as morning every day statistical server remove statistics and initial data before the maximum number of days of above-mentioned configuration in its database automatically;
Optionally, can also whether back up and backup file deposit position etc., safeguard with this historical data to Ring Back Tone service to statistical server configuration to file.
View is created according to the list structure of statistical server database in step 2, polyphonic service data storehouse, regularly generates the raw data file of describing described view.
Step 3, polyphonic service data storehouse are put into raw data file by the file transfer interface share directory of statistical server and multimedia ring service system.
Step 4, statistical server read described raw data file under described share directory, and deposit it in statistical server database, and statistical server obtains the cycle of described raw data file and can dispose in statistical server according to actual needs;
Step 5, statistical server carry out analyzing and processing to described raw data file and obtain statistics, particularly, statistical server provides at least a in a day task, all tasks and month task described initial data is carried out analyzing and processing, obtains the respective table that statistics deposits the statistical server database in.
Second embodiment of the invention, a kind of management system of polyphonic service data, as shown in Figure 2, at least one multimedia ring service system links to each other with statistical server by the file transfer interface, n among Fig. 2 〉=1, the file transfer interface is FTP interface or TFTP interface, wherein,
Multimedia ring service system comprises polyphonic service data storehouse, polyphonic service data bank interface and polyphonic service data processing module, the polyphonic service data processing module is created view according to the list structure of statistical server in the polyphonic service data bank interface, from the polyphonic service data storehouse, obtain initial data by the polyphonic service data bank interface, and derive raw data file to statistical server by the file transfer interface;
The polyphonic service data bank interface is used for shadow data storehouse type, externally provides a unified interface to call for the polyphonic service data processing module;
The polyphonic service data storehouse is used to store the various log informations relevant with Ring Back Tone service.
Statistical server comprises statistical server database, statistical server database interface and statistics processing module, the statistics processing module imports the statistical server database by the statistical server database interface with described raw data file, and it is carried out analyzing and processing obtains statistics.
The statistical server database interface is used for shadow data storehouse type, externally provides a unified interface to call for the statistics processing module;
The statistical server database is used to store the described raw data file that obtains from multimedia ring service system and handles the statistics file that obtains by analysis.
Third embodiment of the invention, a kind of management system of polyphonic service data, roughly the same with second embodiment as shown in Figure 3, difference is that statistical server in the present embodiment provides basic view to third party's instrument, makes things convenient for the inquiry of third party's instrument.The management system of described polyphonic service data further comprises query facility and data base querying interface, and query facility is by calling the statistics in the data base querying interface query statistic server database.
Adopt the management system of the described polyphonic service data of present embodiment, the process of carrying out the Ring Back Tone service the inquiry of historical data is as follows: query facility sends query requests by the data base querying interface, the data base querying interface carries out record retrieval according to querying condition in the statistical server database, find the statistics file of corresponding basic view correspondence, the data base querying interface returns Query Result and gives query facility then, last query facility shows Query Result, can select the form output of statistics file with Excel form form.
The invention provides basic view and realize the inquiry of a plurality of multimedia ring service system statisticss, have very strong novelty and practicality.
The management method of polyphonic service data of the present invention and system, independent statistical server system has been proposed, making it pass through the file transfer interface links to each other with multimedia ring service system and disposes relevant information, view is created according to the list structure of statistical server database in the polyphonic service data storehouse, and the required initial data of derivation statistical server, finally import described initial data and it is carried out analyzing and processing and obtain statistics by statistical server, therefore, the present invention expands the data statistics function of multimedia ring service system, from multimedia ring service system, independently go out the generation of statistics, the output of storage and inquiry and relevant form, overcome preservation the taking Service Database server stores resource of the generation of statistics in the prior art to dependence and a large amount of historical datas of Service Database itself, effectively promote the multimedia ring service system speed of service, in addition, owing to do not have direct data to conduct interviews, its fail safe also be guaranteed to multimedia ring service system.
By the explanation of embodiment, should be to reach technological means and the effect that predetermined purpose takes to be able to more deeply and concrete understanding to the present invention, yet appended diagram only provide with reference to the usefulness of explanation, be not to be used for the present invention is limited.
Claims (10)
1. the management method of a polyphonic service data is characterized in that may further comprise the steps:
Step 1, multimedia ring service system link to each other with statistical server by the file transfer interface and dispose relevant information; Described configuration relevant information comprises: the address information of configuration statistical server and the list structure of statistical server database;
View is created according to the relevant information of configuration in step 2, polyphonic service data storehouse, and regularly generates the raw data file of describing described view, and puts into statistical server by the file transfer interface;
Step 3, statistical server import described initial data, and it is carried out analyzing and processing obtain statistics, statistics are deposited in the respective table of statistical server database.
2. according to the management method of the described polyphonic service data of claim 1, it is characterized in that step 1 Colorful Ring Service system configuration relevant information also comprises:
In the configuration statistical server with the share directory of multimedia ring service system;
The cycle that the configuration multimedia ring service system is derived the required initial data of statistical server.
3. according to the management method of the described polyphonic service data of claim 2, it is characterized in that step 2 further comprises: the share directory of described raw data file being put into statistical server and multimedia ring service system by the file transfer interface.
4. according to the management method of the described polyphonic service data of claim 3, it is characterized in that the process that statistical server in the step 3 imports described initial data is: under described share directory, read described raw data file, and deposit it in statistical server database.
5. according to the management method of claim 1 or 2 or 3 or 4 described polyphonic service datas, it is characterized in that in the step 3 that described initial data is carried out the mode that analyzing and processing obtains statistics is: statistical server provides at least a in a day task, all tasks and month task described initial data is carried out analyzing and processing, obtains statistics.
6. the management system of a polyphonic service data is characterized in that multimedia ring service system passes through the file transfer interface and links to each other with statistical server, wherein,
Multimedia ring service system is used for obtaining initial data according to the relevant information of configuration from multimedia ring service system, and derives raw data file by the file transfer interface; The relevant information of described configuration comprises: the address information of configuration statistical server and the list structure of statistical server database;
Described multimedia ring service system specifically comprises: polyphonic service data processing module, polyphonic service data bank interface and polyphonic service data storehouse, wherein, the polyphonic service data processing module is created view according to the relevant information of configuration in the polyphonic service data bank interface, the polyphonic service data storehouse regularly generates the raw data file of describing described view, from the polyphonic service data storehouse, obtain initial data by the polyphonic service data bank interface, and derive raw data file to statistical server by the file transfer interface;
Statistical server is used to import described raw data file, and it is carried out analyzing and processing obtains statistics; Described statistical server specifically comprises: statistics processing module, statistical server database interface and statistical server database, wherein, the statistics processing module imports the statistical server database by the statistical server database interface with described raw data file, and it is carried out analyzing and processing obtains statistics.
7. according to the management system of the described polyphonic service data of claim 6, it is characterized in that in the described multimedia ring service system,
The polyphonic service data bank interface is used for shadow data storehouse type, externally provides a unified interface to call for the polyphonic service data processing module;
The polyphonic service data storehouse is used to store the various log informations relevant with Ring Back Tone service.
8. according to the management system of the described polyphonic service data of claim 6, it is characterized in that in the described statistical server,
The statistical server database interface is used for shadow data storehouse type, externally provides a unified interface to call for the statistics processing module;
The statistical server database is used to store the described raw data file that obtains from multimedia ring service system and handles the statistics file that obtains by analysis.
9. according to the management system of claim 6 or 7 or 8 described polyphonic service datas, it is characterized in that the file transfer interface is FTP (File Transfer Protocol, file transfer protocol (FTP)) interface or TFTP (Trivial File Transfer Protocol, TFTP) interface.
10. according to the management system of the described polyphonic service data of claim 9, it is characterized in that further comprising query facility and data base querying interface, query facility is by calling the statistics in the data base querying interface query statistic server database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101486209A CN101594435B (en) | 2009-06-25 | 2009-06-25 | Method and system for managing polyphonic service data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101486209A CN101594435B (en) | 2009-06-25 | 2009-06-25 | Method and system for managing polyphonic service data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101594435A CN101594435A (en) | 2009-12-02 |
| CN101594435B true CN101594435B (en) | 2011-11-30 |
Family
ID=41408861
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101486209A Expired - Fee Related CN101594435B (en) | 2009-06-25 | 2009-06-25 | Method and system for managing polyphonic service data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101594435B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107562809A (en) * | 2017-08-10 | 2018-01-09 | 广州视源电子科技股份有限公司 | Business data statistical method, device and system and readable storage medium |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102098394B (en) * | 2010-12-28 | 2014-09-10 | 北京高信达通信技术有限公司福州分公司 | Polyphonic ringtone data analysis method and device |
| CN102682021B (en) * | 2011-03-15 | 2017-04-12 | 新奥特（北京）视频技术有限公司 | Application method and system of non-invasive data statistic way |
-
2009
- 2009-06-25 CN CN2009101486209A patent/CN101594435B/en not_active Expired - Fee Related
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107562809A (en) * | 2017-08-10 | 2018-01-09 | 广州视源电子科技股份有限公司 | Business data statistical method, device and system and readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101594435A (en) | 2009-12-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105138592B (en) | A kind of daily record data storage and search method based on distributed structure/architecture | |
| CN102906751B (en) | A kind of method of data storage, data query and device | |
| CN102063490B (en) | Database partition method and device | |
| CN101373533A (en) | Real time accurate marketing apparatus based on mobile communication signaling gateway and data processing method | |
| CN105164674A (en) | Queries involving multiple databases and execution engines | |
| CN101621405A (en) | Distributed type management monitoring system, monitoring method and establishing method thereof | |
| CN101990208A (en) | Automatic data checking method, system and equipment | |
| CN1859505B (en) | Bill checking system and method | |
| CN101937474A (en) | Mass data query method and device | |
| CN108763234A (en) | A kind of real time data synchronization method and system | |
| CN102779138B (en) | The hard disk access method of real time data | |
| US20140040292A1 (en) | System and method for massive call data storage and retrieval | |
| CN105608126A (en) | Method and apparatus for establishing secondary indexes for massive databases | |
| CN115033646B (en) | Method for constructing real-time warehouse system based on Flink and Doris | |
| CN110677514A (en) | IP filing information management method and device | |
| CN101833580A (en) | Report inquiring system and data acquisition method and device thereof | |
| CN110532058B (en) | Management method, device and equipment of container cluster service and readable storage medium | |
| CN101594435B (en) | Method and system for managing polyphonic service data | |
| CN102737061B (en) | Distributed ticket query management system and method | |
| CN101729929B (en) | System, device and method for accessing mass data by intelligent network service library | |
| CN111782618B (en) | Data synchronization system | |
| CN105095224A (en) | Method, apparatus and system for carrying out OLAP analysis in mobile communication network | |
| WO2024094107A9 (en) | Mobile number home operator querying method and apparatus, storage medium, and device | |
| CN101552695B (en) | A unified network management method and system for multi-disciplinary networks | |
| CN112199426A (en) | Interface call management method, device, server and medium under micro-service architecture |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20170825 Address after: 450000 No. 2, building 1, No. 188, Longhai West Road, Zhongyuan District, Henan, Zhengzhou 2102, China Co-patentee after: Ning Haiying Patentee after: Lu xiuru Co-patentee after: Tang Yong Co-patentee after: Wang Guodong Co-patentee after: Zhou Fengyun Address before: 518057 Nanshan District Guangdong high tech Industrial Park, South Road, science and technology, ZTE building, Ministry of Justice Patentee before: ZTE Corp. |
|
| TR01 | Transfer of patent right | ||
| CB03 | Change of inventor or designer information |
Inventor after: Lu xiuru Inventor after: Ning Haiying Inventor after: Tang Yong Inventor after: Wang Guodong Inventor after: Zhou Fengyun Inventor before: Zhou Yunjun Inventor before: Ding Kun Inventor before: Zhou Fuxing |
|
| CB03 | Change of inventor or designer information | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20111130 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |