CN1265310C - Method of producing MML report based on data bank - Google Patents
Method of producing MML report based on data bank Download PDFInfo
- Publication number
- CN1265310C CN1265310C CN 02147475 CN02147475A CN1265310C CN 1265310 C CN1265310 C CN 1265310C CN 02147475 CN02147475 CN 02147475 CN 02147475 A CN02147475 A CN 02147475A CN 1265310 C CN1265310 C CN 1265310C
- Authority
- CN
- China
- Prior art keywords
- database
- report
- mml
- information element
- machine language
- 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 present invention relates to a method for producing MML report on the basis of data banks. The method comprises the following procedures: a) data frames containing operation maintenance information is transmitted to an operation and maintenance center by maintained apparatus; b) the operation and maintenance center generates initial report and sends the initial report to a databank module after receiving the data frames; c) the databank module interpretes the initial report and generates MML interpretation report which is then returned back to the operation and maintenance center; d) the operation and maintenance center outputs the MML interpretation report. The present invention describes operation maintenance interface data by using databank form data so as to make the operation maintenance interface data irrelevant to specific business. The interpretation from character string to character string is only concerned when processing is carried out by the system, and information which is relevant to business does not need to be concerned. On the basis, the generation of MML report is realized by using the stored procedures and the convenient search function of the data bank.
Description
Technical field
The present invention relates to operation of equipment maintenance technology field, relate to a kind of generation MML method of reporting specifically based on database.
Background technology
In the operation of equipment maintenance service, especially in webmaster and Operation and Maintenance type systematic, MML need be provided (Man Machine Language: report man-machine language) usually, can understand the health information of equipment and user's user mode information etc. by this MML report user, obtain such MML and report that being convenient to the network manager administers and maintains equipment.
In obtaining this MML report, the prior art forms of hard code that adopt realize more, promptly to each Operation and Maintenance function, all (Operation andMaintenance Center: the interface of definition is encoded operation maintenance center) according to maintained equipment and OMC, and the information element in the docking port (IE:Information Element) explains one by one, is illustrated in figure 1 as the processing flow chart of existing generation MML report.The interface here is meant the data frame structure that contains Operation and Maintenance message of communicating by letter between maintained equipment and the OMC, usually these interfaces have two types, one is a standard agreement, as SNMP (Simple Network ManagementProtocol: Simple Network Management Protocol), it two is a proprietary protocol, it is the agreement of equipment vendor oneself definition, standard agreement no matter, or proprietary protocol, the data carried by data frame structure all is an Operation and Maintenance information in agreement, as shown in Figure 2, finally can be decomposed into the most basic information element.
Obviously, the coupling of the interface of above-mentioned existing generation MML method for reporting and maintained equipment is too many, and is too tight with the business association of maintained equipment, thereby causes existing many deficiencies, specifically mainly comprises:
1, every kind of data frame structure all needs to handle code accordingly, and size of code is bigger when causing realizing, especially more equipment to the Operation and Maintenance functional requirement, and it is very huge that the code size of software will seem;
2, very flexible is directly write extremely in the generation of MML report with code;
3, field explains that the dictionary that uses is built in the code, and (it is English transplanting as Chinese) workload is bigger when transplanting.
Summary of the invention
At above shortcoming, the present invention proposes a kind of MML report-generating method based on database, this method can effectively reduce the coding work amount, the dirigibility height, portability and extendibility are good.
For achieving the above object, a kind of generation man-machine language MML method of reporting based on database, this method comprises following steps:
A, maintained equipment are sent to operation maintenance center with Operation and Maintenance message data frame;
After this Frame is received by b, this operation maintenance center, generate initial report and deliver to database;
The initial report of c, this database analysis input is decomposed into single information element with it; This information element is explained one by one, obtained the interpretative version of information element correspondence; The interpretative version of this information element is made up, promptly generate this man-machine language MML report and return to this operation maintenance center;
D, this operation maintenance center are with this man-machine language MML report output.
The agreement of this Frame of carrying is standard agreement or proprietary protocol among the described step a.
Described step c more specifically says: this database uses Stored Procedure Technology, analyzes the initial report of input, and it is decomposed into single information element.
Described step c more specifically says: use Stored Procedure Technology that this information element is explained one by one, obtain the interpretative version of information element correspondence.
Described step c more specifically says and is meant and uses Stored Procedure Technology by the dictionary that inquiry is stored in the database module this information element to be explained one by one, obtains the interpretative version of information element correspondence.
Described step c more specifically says: use Stored Procedure Technology that the interpretative version of this information element is made up, promptly generate this MML report.
Described database is meant SQL Server, Oracle, Sybase.
The present invention makes itself and concrete independent of service by using database table data description Operation and Maintenance interface data, only is concerned about the explanation of character string to character string when system handles, needn't be concerned about professional information of being correlated with; On this basis, utilize the storing process of database and search function easily, realize the generation of MML report.Specifically, the present invention has the following advantages:
1, reduce the complexity that the MML report is handled, the reduction workload improves dirigibility; When what's new, as long as increase corresponding data of description in database, code does not change substantially;
2, the present invention is based on database technology, and database technology is supported polytype hardware and operating system, make that transplanting is more convenient, simple;
3, MML report mainly generates in database, aspect the language support, as long as provide new explanation dictionary just passable, therefore multilingual supportive better.
Describe the present invention in detail below in conjunction with the drawings and specific embodiments.
Description of drawings
Fig. 1 is the processing flow chart of existing generation MML report;
Fig. 2 is the structural representation of existing Operation and Maintenance information data frame;
Fig. 3 is the described processing sequence figure that reports based on the generation MML of database of the embodiment of the invention;
Fig. 4 is the generation MML method of reporting process flow diagram based on database of the present invention;
Fig. 5 is the method flow diagram of step c of the present invention.
Embodiment
The embodiment of the invention is finished by maintained equipment, the OMC of operation maintenance center and user, as shown in Figure 3, after maintained equipment end produces Operation and Maintenance message, fill it in the data frame structure, send to the OMC of operation maintenance center by agreement carrying back packing then, and on operation maintenance center's platform, be built-in with database module, that this database module adopts is SQLServer7.0, include 3 tables in this database module, wherein, the functional description of the title of these tables and table is as shown in table 1 below:
| The title of table | The functional description of table |
| Tbl_OMMsg | All message between equipment and the OMC. |
| Tbl_OMIEInfo | The Operation and Maintenance information element is described form, all IE of all types message between description equipment and the OMC, each type of message identifies by message id, and each IE is by the position unique identification of message id and IE. |
| Tbl_OMDict | Information element is explained dictionary, preserves the explanation dictionary that IE explains to be needed. |
Table 1
Wherein, the attribute definition of the field of each table in the last table 1, shown in table 2,3,4, it is respectively the table definition of tbl_OMMsg, tbl_OMIEInfo, tbl_OMDict.
Table 2
| Field number | Field name | Data type | Field description |
| 1 | MsgID | Integer | Message id |
| 2 | MsgName | Character string | Message name (what kind of message indicates this message is) |
Table 3
| Field number | Field name | Data type | Field description |
| 1 | MsgID | Integer | Message id is used for marking the message of IE correspondence |
| 2 | Serial | Integer | The position of IE in message |
| 3 | Rule | Integer | The interpretative rule of IE, 1: expression need not explain that subject string returns; 2: the storing process that the ProcName correspondence is called in expression makes an explanation |
| 4 | RptLen | Integer | IE explains back MML report length |
| 5 | IEName | Character string | IE title (referring to the display Name in the MML report) |
| 6 | ProcName | Character string | Explain the storing process title of this field correspondence |
| 7 | IEDictKey | Character string | The dictionary key word that uses when IE explains |
Table 4
| Field number | Field name | Data type | Field description |
| 1 | KeyName | Character string | The dictionary keyword name |
| 2 | Value | Character string | Value |
| 3 | Desc | Character string | The description text that value is corresponding |
As shown in Figure 4, describe the detailed step of the described a kind of generation MML method of reporting based on database of the embodiment of the invention below in detail:
The first, the maintained equipment Frame that will contain Operation and Maintenance message is sent to operation maintenance center.
The structure of this Frame as shown in Figure 2, it includes the most basic data cell, i.e. information element IE.
The second, after this Frame is received by this operation maintenance center, generate initial report and deliver to database module.
After this Frame is received by this operation maintenance center, generate the initial report file have form, as between each information element IE with isolate symbol "; " isolate mutually etc., then this initial report file is delivered to database module.
Three, this database module is explained this initial report, generates the MML report and returns to this operation maintenance center.
This database module is called following storing process sp_GetMMLRpt, and to the initial report file that has form analysiss that make an explanation of input, and inquiry explains that dictionary translates into MML with this initial report and explain and report.The correlative detail of this storing process sp_GetMMLRpt is as follows:
Title: sp_GetMMLRpt
Describe: storing process is explained in message MML report:
Input:
The message id of wMsgID:IE correspondence
SSrcRpt: message initial report
Output:
The sMMLRpt:MML report
*/
CREATE PROCEDURE sp_GetMMLRpt
@wMsgID smallint=0,--message id
@sSrcRpt varchar (2048),--initial report, the original value of each IE, between IE with '; ' at interval
@sMMLRpt varchar (2048)=" OUTPUT--MML report, output parameter
AS
BEGIN
DECLARE@iPosi int;--isolate according with '; ' position
DECLARE@sCurIE varchar (256);--as the IE of pre-treatment
DECLARE@sDelimiter varchar (6);--isolate symbol
DECLARE@iIEIdx int;--the IE location index
DECLARE@sIERpt varchar (256);--the IE report text
DECLARE@sReport varchar (2048);--report text
SET@sDelimiter=' %; % '--IE space character
SET@iIEIdx＝1；
SET@sReport＝″；
SET@iPosi＝PATINDEX(@sDelimiter，@sSrcRpt)
WHILE (@iPosi＞0)--field makes an explanation one by one
BEGIN
SET@sCurIE=SUBSTRING (@sRspTxt, 1 ， @iPosi-1); // get current
IE
EXEC sp_GetFiledText@wMsgID，@iIEIdx，@sCurIE，@sIERpt
OUTPUT // acquisition is worked as
Preceding IE interpretative version
SET@sReport=@sReport+@sIERpt+space (2) // assembling newspaper
Accuse
SET@sSrcRpt=SUBSTRING (@sSrcRpt ， @iPosi+1,2048); // calculate
Next IE
SET@iPosi＝PATINDEX(@sDelimiter，@sSrcRpt)
SET@iIEIdx＝@iIEIdx+1；
END
set@sMMLRpt＝@sReport
END
As shown in Figure 5, it specifically may further comprise the steps:
1, the initial report of this database module analysis input is decomposed into single information element with it.
2, this information element is explained one by one, obtained the interpretative version of information element correspondence;
In the process of the interpretative version of acquired information element correspondence, also can use storing process to realize, by using inquiry to explain that the mode of dictionary obtains interpretative version, the correlative detail of the storing process sp_GetIEText for the interpretative version that obtains the IE correspondence as follows:
Title: sp_GetIEText
Describe: IE explains storing process:
Input:
The message id of wMsgID:IE correspondence
The location index of wSerial:IE in message
The character string forms of sValue:IE value
Output:
The interpretative version that the sDesc:IE value is corresponding
*/
CREATE PROCEDURE sp_GetFiledText
@wMsgID smallint＝0，
@wSerial smallint＝0，
@sValue varchar(256)＝″，
@sDesc varchar(256)＝″OUTPUT
AS
BEGIN
DECLARE@iRule smallint；
DECLARE@sProcName varchar(64)；
DECLARE@sKey varchar(64)；
DECLARE@iRptLen smallint；
DECLARE@sReport varchar(256)；
DECLARE@iStrLen smallint；
SET@iRule＝1；
SET@sProcName＝″；
SET@sKey＝″；
SET@sReport＝″；
--at first from the IE description list, get interpretative rule
SELECT@iRule＝Rule，@sName＝IEName，@sProcName＝ProcName，
@sKey＝IEDictKey，@iRptLen＝RptLen
FROM tbl_OMIEInfo
WHERE @wMsgID＝MsgID AND @wSerial＝Serial；
If--there is not corresponding record, directly rreturn value
IF(@@ROWCOUNT＝0OR@iRule＝1OR@sProcName＝″)
BEGIN
SET @sReport＝@sValue
END
ELSE BEGIN
EXEC@sProcName@sKey，@sValue，@sReport OUTPUT；
END
SET@sDesc＝@sReport；
@iStrLen＝datalength(@sReport)；
--reduce or fill space (in order to satisfy report field alignment needs) according to length restriction
IF (@iRptLen＞@iStrLen)--designated length is greater than interpretative version length, the right side lattice of filling a vacancy
BEGIN
SET@sDesc＝@sReport+space(@iRptLen-@iStrLen)
END
ELSE IF (@iRptLen＜@byStrLe)--designated length is less than explaining length, then intercepting
BEGIN
SET@sDesct＝substring(convert(Text，@sReport)，1，@iRptLen)
--if Chinese character intercepted situation, then the back replenishes the space
SET@sDesc＝@sReport+space(@iRptLen-datalength(@sReport))
END
END
3, the interpretative version with this information element makes up, and promptly generates this MML report, and returns to this operation maintenance center.
Four, this operation maintenance center is with this MML report output.
This operation maintenance center gives the user by the mode that shows with this MML report output.
Top embodiment is based on SQL Server database, if use the database of Oracle, Sybase or other types, only need change to storing process gets final product.
Claims (7)
1, a kind of generation man-machine language MML method of reporting based on database is characterized in that this method comprises following steps:
A, maintained equipment are sent to operation maintenance center with Operation and Maintenance message data frame;
After this Frame is received by b, this operation maintenance center, generate initial report and deliver to database;
The initial report of c, this database analysis input is decomposed into single information element with it; This information element is explained one by one, obtained the interpretative version of information element correspondence; The interpretative version of this information element is made up, promptly generate this man-machine language MML report and return to this operation maintenance center;
D, this operation maintenance center are with this man-machine language MML report output.
2, a kind of generation man-machine language MML method of reporting based on database as claimed in claim 1 is characterized in that, the agreement of this Frame of carrying is standard agreement or proprietary protocol among the described step a.
3, a kind of generation man-machine language MML method of reporting as claimed in claim 1 based on database, it is characterized in that, described step c more specifically says: this database uses Stored Procedure Technology, analyzes the initial report of input, and it is decomposed into single information element.
4, a kind of generation man-machine language MML method of reporting as claimed in claim 1 based on database, it is characterized in that, described step c more specifically says: use Stored Procedure Technology that this information element is explained one by one, obtain the interpretative version of information element correspondence.
5, a kind of generation man-machine language MML method of reporting as claimed in claim 4 based on database, it is characterized in that, described step c more specifically says and is meant and uses Stored Procedure Technology by the dictionary that inquiry is stored in the database module this information element to be explained one by one, obtains the interpretative version of information element correspondence.
6, a kind of generation man-machine language MML method of reporting as claimed in claim 1 based on database, it is characterized in that, described step c more specifically says: use Stored Procedure Technology that the interpretative version of this information element is made up, promptly generate this MML report.
7, as each described a kind of generation man-machine language MML method of reporting in the claim 1 to 6, it is characterized in that described database is meant SQL Server, Oracle, Sybase based on database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02147475 CN1265310C (en) | 2002-11-01 | 2002-11-01 | Method of producing MML report based on data bank |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 02147475 CN1265310C (en) | 2002-11-01 | 2002-11-01 | Method of producing MML report based on data bank |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1494024A CN1494024A (en) | 2004-05-05 |
| CN1265310C true CN1265310C (en) | 2006-07-19 |
Family
ID=34232994
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 02147475 Expired - Fee Related CN1265310C (en) | 2002-11-01 | 2002-11-01 | Method of producing MML report based on data bank |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1265310C (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100438431C (en) * | 2005-04-28 | 2008-11-26 | 华为技术有限公司 | Multi-network element journal file loading method |
-
2002
- 2002-11-01 CN CN 02147475 patent/CN1265310C/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN1494024A (en) | 2004-05-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1556482A (en) | Data processing method for realizing data base multitable inguiry | |
| CN1781105A (en) | Retaining hierarchical information in mapping between XML documents and relational data | |
| CN101055588A (en) | Method for catching limit word information, optimizing output and input method system | |
| CN1615480A (en) | Translating configuration files among network devices | |
| CN1595398A (en) | System that translates by improving a plurality of candidate translations and selecting best translation | |
| CN1862543A (en) | Method for leading-in and deriving data in browser/servicer system | |
| CN1248453C (en) | Method for realtime synchronisation of net element and telecommunication system | |
| CN1913524A (en) | Method of network management system interface consulation and its device | |
| CN101047726A (en) | Terminal failure diagnosis system and method | |
| CN1741460A (en) | Method and system for realizing telecommunication network universal performance management | |
| CN1719786A (en) | Automatic testing system and method for command of command line interface of data communication apparatus | |
| CN101042710A (en) | Method and system for implementing acquisition data sharing | |
| CN101047555A (en) | Detection method for quality of equipment | |
| CN1975739A (en) | Report generating method, equipment and system | |
| CN101043368A (en) | Method and system for unifying Web pages | |
| CN1852546A (en) | Operation maintenance system and method for base-station system | |
| CN1265310C (en) | Method of producing MML report based on data bank | |
| CN1357981A (en) | Method of testing several kinds of application protocol | |
| CN1713140A (en) | Interface generating method and device for computer | |
| CN1474297A (en) | Organization and maintenance method based on GIS for computer network map | |
| CN1208299A (en) | Communication device, communication method and medium on which computer program for carrying out method is recorded | |
| CN1869982A (en) | Report data collection system and method | |
| CN1783872A (en) | Method for realizing network configuration interface for opening mobile communication service | |
| CN1960367A (en) | Method for associating general multiple protocols | |
| CN1299200C (en) | Unified converting method for interface data in telecommunication network management system and its 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 |
Granted publication date: 20060719 Termination date: 20161101 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |