CN103856969A - Method, device and system for counting network element characteristic parameters - Google Patents
Method, device and system for counting network element characteristic parameters Download PDFInfo
- Publication number
- CN103856969A CN103856969A CN201410123716.0A CN201410123716A CN103856969A CN 103856969 A CN103856969 A CN 103856969A CN 201410123716 A CN201410123716 A CN 201410123716A CN 103856969 A CN103856969 A CN 103856969A
- Authority
- CN
- China
- Prior art keywords
- parameter
- target property
- network element
- characterisitic parameter
- 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.)
- Pending
Links
Images
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention provides a method, device and system for counting network element characteristic parameters. The method comprises the following steps: setting a characteristic parameter template, recording attribute information of target characteristic parameters into the characteristic parameter template, generating a query script of the target characteristic parameter according to the attribute information of the target characteristic parameter, reading the data of the target characteristic parameters in a databank through the query script, outputting the read data of the target characteristic parameters to a user, thereby achieving batch query on network elements under the management of an OMC (Operation and Maintenance Center), alleviating the workload of maintaining personnel of communication networks, and improving the efficiency in querying the network element characteristic parameters.
Description
Technical field
The present invention relates to the technical field of communication network, especially relate to statistical system method, the Apparatus and system of network element characterisitic parameter.
Background technology
TD SDMA (Time Division-Synchronous Code Division Multiple Access, TD-SCDMA) wireless network is in running, can open many characteristics, such as high speed downlink packet access (High Speed Downlink Packet Access, HSDPA) characteristic, high speed uplink packet access (High Speed Uplink Packet Access, HSUPA) characteristic, frame divides characteristic etc., help to promote efficiency and the performance of TD-SCDMA wireless network, realize the application software of characteristic functions by operation, be reached for user the object of the wireless communication network environments of high-quality is more provided.
In the prior art, because TD-SCDMA wireless network is constantly doing the network such as dilatation, cutover alter operation, being open at this process and all may having variation of every characteristic; In general,, in the characteristic of opening in TD-SCDMA wireless network, usually can be accompanied by the amendment of mass property parameter.Therefore, the attendant of TD-SCDMA wireless network must make regular check on every characteristic and open after its relevant parameter be whether unanimously, whether have projects such as mistakes and omissions.At present, the mode that checks the characterisitic parameter in TD-SCDMA wireless network is: to an independent radio network controller (Radio Network Controller, RNC) network element is inquired about, cannot be to (the Operation and Management Center of operation maintenance center, OMC) a large amount of RNC network elements of management carry out batch query, so attendant's workload is large, efficiency is very low.
Summary of the invention
The invention provides a kind of statistical method, Apparatus and system of network element characterisitic parameter, while carrying out batch query for solving the RNC network element of prior art OMC management, attendant's the problem that workload is large, efficiency is very low.
For solving the aforementioned problems in the prior, the invention provides a kind of statistical method of network element characterisitic parameter, wherein, comprising:
Characterisitic parameter template is set, the attribute information of typing target property parameter in described characterisitic parameter template;
Generate the query script of described target property parameter according to the attribute information of described target property parameter;
In database, read the data of described target property parameter by described query script;
The data of the described target property parameter reading are exported to user.
The present invention also provides a kind of statistic device of network element characterisitic parameter, wherein, comprising:
Module is set, for characterisitic parameter template is set, the attribute information of typing target property parameter in described characterisitic parameter template;
Generation module, for generating the query script of described target property parameter according to the attribute information of described target property parameter;
Read module, for reading the data of described target property parameter at database by described query script;
Output module, for exporting to user by the data of the described target property parameter reading.
The present invention also provides a kind of statistical system of network element characterisitic parameter, wherein, comprises the statistic device of above-mentioned any one network element characterisitic parameter.
The beneficial effect of embodiment provided by the invention:
First characterisitic parameter template is set, according to the attribute information of target property parameter in characterisitic parameter template, generated query script, in database, read the data of target property parameter by query script, then the data of the target property parameter reading are exported to user, to realize, the characterisitic parameter of a large amount of RNC network elements under OMC management is carried out to batch query, reduce the attendant's of communication network workload, improve the efficiency of inquiry network element characterisitic parameter.
Brief description of the drawings
The present invention above-mentioned and/or additional aspect and advantage will become from the following description of the accompanying drawings of embodiments obviously and easily and understand, wherein:
Fig. 1 is the flow chart of the statistical method embodiment of network element characterisitic parameter of the present invention;
Fig. 2 is the structural representation of the statistic device embodiment of network element characterisitic parameter of the present invention.
Embodiment
Describe embodiments of the invention below in detail, the example of described embodiment is shown in the drawings, and wherein same or similar label represents same or similar element or has the element of identical or similar functions from start to finish.Be exemplary below by the embodiment being described with reference to the drawings, only for explaining the present invention, and can not be interpreted as limitation of the present invention.
Fig. 1 is the flow chart of the statistical method embodiment of network element characterisitic parameter of the present invention.As shown in Figure 1, in the present embodiment, the statistical method of network element characterisitic parameter specifically comprises the steps:
In this step, user can arrange the characterisitic parameter template of RNC network element in cordless communication network in OMC, the attribute information of typing target property parameter in characterisitic parameter template, for batch query network element characterisitic parameter, or the deployment quantity of inquiry network element characteristic etc.Wherein, characterisitic parameter template comprises 1 above target property parameter; Or characterisitic parameter template comprises the opening information of target property parameter in each network element.In actual applications, characterisitic parameter is stored in oracle database.
Characterisitic parameter template can comprise for the attribute information of the datum target characterisitic parameter of the same characterisitic parameter of each network element in statistics cordless communication network: the database table title of characteristic title, characterisitic parameter title, storage characteristics parameter, the positional information that characterisitic parameter is arranged in database table and/or the opening information of characteristic.Wherein, characteristic title is the title that needs the characteristic of inquiry, and characterisitic parameter title is the title of parameter corresponding to characteristic, and database table title is the title of the database table of storage characteristics parameter in oracle database.
In the present embodiment, be called high-speed downlink packet access HSDPA characteristic taking name and introduce technical scheme as example.
Table 1
As shown in table 1, HSDPA characterisitic parameter template comprises 4 characterisitic parameters, the name of 4 characterisitic parameters is called characterisitic parameter 1, characterisitic parameter 2, characterisitic parameter 3 and characterisitic parameter 4, the title of the database table in the oracle database at above-mentioned 4 characterisitic parameter places is respectively Oracle table 1, Oracle table 2, Oracle table 3 and Oracle table 4, and 4 characterisitic parameters respectively positional information in Oracle table 1, Oracle table 2, Oracle table 3 and Oracle table 4 are 11,22,33 and 44.After characterisitic parameter template is set, enter step 102.
In this step, read the term of the attribute information of target property parameter in characterisitic parameter template, for example, using the title of the database table at the characterisitic parameter place in attribute information and positional information that characterisitic parameter is arranged in database table as term, then according to the term reading, generate the query script of target property parameter, and query script is sent to the query interface of oracle database, then enter step 103.
In this step, query script is according to term, and the data of the target property parameter in the oracle database of storage characteristics parameter in each network element of batch query, after inquiring the data of this target property parameter, enter step 104.
In this step, after inquiring the data of target property parameter in each network element, the data of the target property parameter reading are exported to user.In actual applications, can by batch query to the data of target property parameter export to user in the mode of data sheet, to facilitate attendant's the reading of cordless communication network.
In the present embodiment, HSDPA characterisitic parameter is target property parameter, the data of HSDPA characterisitic parameter are exported to user in the mode of data sheet, as shown in table 2, the data of HSDPA characterisitic parameter are short and sweet, it is convenient to read, the data that are conducive to check target property parameter whether accurately, omission etc., the personnel that maintain easily analyze and management.
Table 2
In the present embodiment, first characterisitic parameter template is set, according to the attribute information of target property parameter in characterisitic parameter template, generated query script, in database, read the data of target property parameter by query script, then the data of the target property parameter reading are exported to user, to realize, the characterisitic parameter of a large amount of RNC network elements under OMC management is carried out to batch query, reduce the attendant's of communication network workload, improve the efficiency of inquiry network element characterisitic parameter.
Further, can also add up by characterisitic parameter template is set the opening information of some characterisitic parameters in each network element of cordless communication network, the deployment quantity of the characteristic that the opening information of characterisitic parameter is can Statistical Parameters corresponding.In the present embodiment, by being set, characterisitic parameter template adds up HSDPA characteristic, high speed uplink packet access (the High Speed Uplink Packet Access of each network element in cordless communication network, HSUPA) characteristic opening information and frame divide characteristic, opening information is the number of switches information of function corresponding to characteristic in cordless communication network, and the information in characterisitic parameter template is as shown in table 3:
Table 3
Then, read the term of the attribute information of the target property parameter in table 3, the term in the present embodiment comprises: the title of the database table at characterisitic parameter place and messaging parameter are positioned at the positional information of database table.Whether the term of the attribute information of the target property parameter that judgement is read is complete, if the term reading is imperfect, needs again to read, if the term reading is complete, according to term generated query script.Inquire about the opening information of inquiring about the target property parameter in each network element in the oracle database of storage characteristics parameter by query script, then in the mode of data sheet, the opening information of above-mentioned 3 target property information is exported to user, as shown in table 4,
Characteristic title | Open quantity |
HSDPA characteristic | 100 |
HSUPA characteristic | 200 |
Frame divides characteristic | 300 |
Table 4
As shown in table 4, in the present embodiment, the unlatching quantity of HSDPA characteristic, HSUPA characteristic and frame point characteristic is respectively 100,200 and 300, thereby utilize a data sheet just can present the unlatching quantity of each characteristic in cordless communication network, maintain easily personnel's analysis and management.
Fig. 2 is the structural representation of the statistic device embodiment of network element characterisitic parameter of the present invention.As shown in Figure 2, the statistic device of the present embodiment network element characterisitic parameter comprises: module 201, generation module 202, read module 203 and output module 204 are set.Wherein, module 201 is set for characterisitic parameter template is set, the attribute information of typing target property parameter in characterisitic parameter template, generation module 202 is for generating the query script of target property parameter according to the attribute information of target property parameter, read module 203 is for reading the data of target property parameter at database by query script, output module 204 is for exporting to user by the data of the target property parameter reading.
Further, in the present embodiment, module 201 is set specifically for more than 1 target property parameter is set in characterisitic parameter template; Or, the opening information of target property parameter in each network element is set in characterisitic parameter template, to count the unlatching quantity of characteristic corresponding to target property parameter.Read module 203 is specifically for sending to query script data base querying interface, to read the data of target property parameter from database, output module 204 specifically for by the data importing of the target property parameter reading in data sheet, data sheet is exported to user.
In the present embodiment, by module is set, characterisitic parameter template is set, generation module is according to the attribute information of target property parameter in characterisitic parameter template, generated query script, in database, read the data of target property parameter by read module query script, then by output module, the data of the target property parameter reading are exported to user, to realize, the characterisitic parameter of a large amount of RNC network elements under OMC management is carried out to batch query, reduce the attendant's of communication network workload, improve the efficiency of inquiry network element characterisitic parameter.
The present invention also provides a kind of statistical system of network element characterisitic parameter, wherein, comprises the statistic device of network element characterisitic parameter as shown in Figure 2.Wherein, the statistic device of network element characterisitic parameter comprises: module 201, generation module 202, read module 203 and output module 204 are set.Wherein, module 201 is set for characterisitic parameter template is set, the attribute information of typing target property parameter in characterisitic parameter template, generation module 202 is for generating the query script of target property parameter according to the attribute information of target property parameter, read module 203 is for reading the data of target property parameter at database by query script, output module 204 is for exporting to user by the data of the target property parameter reading, to realize, the characterisitic parameter of a large amount of RNC network elements under OMC management is carried out to batch query, reduce the attendant's of communication network workload, improve the efficiency of inquiry network element characterisitic parameter.。
Those skilled in the art are appreciated that realizing all or part of step that said method embodiment carries is can carry out the hardware that instruction is relevant by program to complete, described program can be stored in a kind of computer-readable recording medium, this program, in the time carrying out, comprises step of embodiment of the method one or a combination set of.
In addition, the each functional unit in each embodiment of the present invention can be integrated in a processing module, can be also that the independent physics of unit exists, and also can be integrated in a module two or more unit.Above-mentioned integrated module both can adopt the form of hardware to realize, and also can adopt the form of software function module to realize.If described integrated module realizes and during as production marketing independently or use, also can be stored in a computer read/write memory medium using the form of software function module.
The above-mentioned storage medium of mentioning can be read-only memory, disk or CD etc.
The above is only part execution mode of the present invention; it should be pointed out that for those skilled in the art, under the premise without departing from the principles of the invention; can also make some improvements and modifications, these improvements and modifications also should be considered as protection scope of the present invention.
Claims (10)
1. a statistical method for network element characterisitic parameter, is characterized in that, comprising:
Characterisitic parameter template is set, the attribute information of typing target property parameter in described characterisitic parameter template;
Generate the query script of described target property parameter according to the attribute information of described target property parameter;
In database, read the data of described target property parameter by described query script;
The data of the described target property parameter reading are exported to user.
2. the statistical method of network element characterisitic parameter according to claim 1, is characterized in that, the attribute information of described characterisitic parameter comprises:
Characteristic title, characterisitic parameter title, the database table title of storing described characterisitic parameter, described characterisitic parameter are arranged in the opening information of positional information and/or the characteristic of described database table.
3. the statistical method of network element characterisitic parameter according to claim 1, is characterized in that, characterisitic parameter template is set, and specifically comprises:
Described characterisitic parameter template comprises 1 above target property parameter;
Or described characterisitic parameter template comprises the opening information of target property parameter in each network element.
4. the statistical method of network element characterisitic parameter according to claim 1, is characterized in that, reads the data of described target property parameter by described query script in database, specifically comprises:
Described query script is sent to data base querying interface, to read the data of described target property parameter from described database.
5. the statistical method of network element characterisitic parameter according to claim 1, is characterized in that, the data of the described target property parameter reading are exported to user, specifically comprises:
The data importing of the described target property parameter reading, in data sheet, is exported to user by described data sheet.
6. a statistic device for network element characterisitic parameter, is characterized in that, comprising:
Module is set, for characterisitic parameter template is set, the attribute information of typing target property parameter in described characterisitic parameter template;
Generation module, for generating the query script of described target property parameter according to the attribute information of described target property parameter;
Read module, for reading the data of described target property parameter at database by described query script;
Output module, for exporting to user by the data of the described target property parameter reading.
7. the statistic device of network element characterisitic parameter according to claim 6, is characterized in that, described arrange module specifically for:
Described characterisitic parameter template comprises 1 above target property parameter;
Or described characterisitic parameter template comprises the opening information of target property parameter in each network element.
8. the statistic device of network element characterisitic parameter according to claim 6, is characterized in that, described read module specifically for:
Described query script is sent to data base querying interface, to read the data of described target property parameter from described database.
9. the statistic device of network element characterisitic parameter according to claim 6, is characterized in that, described output module specifically for:
The data importing of the described target property parameter reading, in data sheet, is exported to user by described data sheet.
10. a statistical system for network element characterisitic parameter, is characterized in that, comprising: the statistic device of the arbitrary described network element characterisitic parameter of claim 6-9.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410123716.0A CN103856969A (en) | 2014-03-28 | 2014-03-28 | Method, device and system for counting network element characteristic parameters |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410123716.0A CN103856969A (en) | 2014-03-28 | 2014-03-28 | Method, device and system for counting network element characteristic parameters |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103856969A true CN103856969A (en) | 2014-06-11 |
Family
ID=50864082
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410123716.0A Pending CN103856969A (en) | 2014-03-28 | 2014-03-28 | Method, device and system for counting network element characteristic parameters |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103856969A (en) |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106293661A (en) * | 2015-05-22 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The generation of pictorial statement, generation processing method and processing device |
CN106547756A (en) * | 2015-09-17 | 2017-03-29 | 北京国双科技有限公司 | The creation method and device of data base |
CN106844467A (en) * | 2016-12-21 | 2017-06-13 | 大唐网络有限公司 | Method for exhibiting data and device |
WO2018035799A1 (en) * | 2016-08-25 | 2018-03-01 | 阿里巴巴集团控股有限公司 | Data query method, application and database servers, middleware, and system |
CN110457064A (en) * | 2019-07-16 | 2019-11-15 | 中盈优创资讯科技有限公司 | The generation method and device of network cutover script |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040078787A1 (en) * | 2002-07-19 | 2004-04-22 | Michael Borek | System and method for troubleshooting, maintaining and repairing network devices |
CN101867494A (en) * | 2010-06-18 | 2010-10-20 | 北京神州泰岳软件股份有限公司 | Soft hardware performance monitoring method based on monitoring template, and system thereof |
CN101888655A (en) * | 2010-06-28 | 2010-11-17 | 中兴通讯股份有限公司 | Method and device for configuring network element data in template way in network management system |
-
2014
- 2014-03-28 CN CN201410123716.0A patent/CN103856969A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040078787A1 (en) * | 2002-07-19 | 2004-04-22 | Michael Borek | System and method for troubleshooting, maintaining and repairing network devices |
CN101867494A (en) * | 2010-06-18 | 2010-10-20 | 北京神州泰岳软件股份有限公司 | Soft hardware performance monitoring method based on monitoring template, and system thereof |
CN101888655A (en) * | 2010-06-28 | 2010-11-17 | 中兴通讯股份有限公司 | Method and device for configuring network element data in template way in network management system |
Non-Patent Citations (1)
Title |
---|
方伟: "网络管理系统测量管理子系统的设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106293661A (en) * | 2015-05-22 | 2017-01-04 | 阿里巴巴集团控股有限公司 | The generation of pictorial statement, generation processing method and processing device |
CN106547756A (en) * | 2015-09-17 | 2017-03-29 | 北京国双科技有限公司 | The creation method and device of data base |
CN106547756B (en) * | 2015-09-17 | 2021-02-12 | 北京国双科技有限公司 | Database creation method and device |
WO2018035799A1 (en) * | 2016-08-25 | 2018-03-01 | 阿里巴巴集团控股有限公司 | Data query method, application and database servers, middleware, and system |
CN106844467A (en) * | 2016-12-21 | 2017-06-13 | 大唐网络有限公司 | Method for exhibiting data and device |
CN106844467B (en) * | 2016-12-21 | 2021-06-22 | 大唐网络有限公司 | Data display method and device |
CN110457064A (en) * | 2019-07-16 | 2019-11-15 | 中盈优创资讯科技有限公司 | The generation method and device of network cutover script |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103856969A (en) | Method, device and system for counting network element characteristic parameters | |
CN103559217B (en) | A kind of massive multicast data towards isomeric data storehouse warehouse-in implementation method | |
JP2019520615A (en) | Character recognition method, device, server and storage medium of claim document for damages | |
US9135280B2 (en) | Grouping interdependent fields | |
CN103475584B (en) | Three-state content addressing memory (TCAM) querying method and device | |
CN111061758B (en) | Data storage method, device and storage medium | |
CN105574032A (en) | Rule matching operation method and device | |
CN103714086A (en) | Method and device used for generating non-relational data base module | |
CN105573774B (en) | Application Parameters management and configuration method | |
TW201344601A (en) | Test file management system and method | |
CN102984737A (en) | Unified parameter configuration method and device for wireless network | |
CN104199977A (en) | Method for searching based on data creation information in database | |
CN100492994C (en) | Method for establishing equipment configuration parameter and base station single plate configuration system | |
CN104021002B (en) | A kind of PDM system standards part storage method | |
CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
CN105550333A (en) | MongoDB-based test data storage query method and system | |
CN101645073A (en) | Method for guiding prior database file into embedded type database | |
CN102692908A (en) | Paperless workshop quality feedback method | |
CN104461931A (en) | Method for output processing of trace logs of multi-kernel storage device and multi-kernel environment | |
CN107269564B (en) | Method and device for automatically regulating and controlling rotating speed of fan | |
CN107733880A (en) | Scheduling disciplines management information system | |
CN102375886A (en) | Multi-channel high-speed data comparing method | |
KR101830504B1 (en) | In-Memory DB Connection Support Type Scheduling Method and System for Real-Time Big Data Analysis in Distributed Computing Environment | |
CN103793519A (en) | Automatic tool supporting exportation of mass data | |
CN102437920A (en) | Method and device for processing configuration data and wireless communication device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140611 |
|
RJ01 | Rejection of invention patent application after publication |