WO2016095509A1

WO2016095509A1 - Conversion method and conversion apparatus for object-oriented model data

Info

Publication number: WO2016095509A1
Application number: PCT/CN2015/083982
Authority: WO
Inventors: 张恒; 唐雄
Original assignee: 中兴通讯股份有限公司
Priority date: 2014-12-15
Filing date: 2015-07-14
Publication date: 2016-06-23
Also published as: CN105760372A

Abstract

A conversion method and a conversion apparatus for object-oriented model data. The conversion method for object-oriented model data comprises the following steps: acquiring a database table and a preconfigured mapping relationship, and acquiring an object class of an object-oriented model corresponding to the database table according to the mapping relationship and a mapping condition; and converting the object class into data in the database table according to the mapping condition.

Description

Object-oriented model data conversion method and conversion device

Technical field

This paper relates to the field of object model technology, and in particular to a method and a conversion device for object-oriented model data.

Background technique

With the rapid development of communication technology and the wide application of object-oriented technology, the 3rd Generation Partnership Project (3GPP) recommends the use of managed objects (MO) for data processing to improve operations. Convenience.

MOM (Managed Object Model) is an object-oriented abstraction of all manageable resources of a base station, which defines a method of modeling management resources and a structure of information transfer between the management party and the managed party. MOM describes base station information or communication network data in an object-oriented manner. Each base station is described in terms of MOM, and all base stations MOMs in the entire network are connected together to form a larger and more complete network. The MOM model of each base station is a complete tree with more than 200 types of nodes, forming an integrated logical view that clearly describes all the resource information of the base station; it can be divided into four types of resources, and defines between the object instances. relationship.

The relationship definition of the MOM model is simple, and the relationship between object instances is more and more complicated. The MOM model mainly follows the 3GPP protocol, and the relational database cannot fully follow the MOM model or the 3GPP protocol. Therefore, if the MOM model data is completely mapped into relational database data, it is undoubtedly very complicated, and complex mapping adaptation is required. The MOM model is converted to table data of a relational database.

The above content is only used to assist in understanding the technical solutions herein, and does not constitute an admission that the above is prior art.

Summary of the invention

This paper provides an object-oriented model data conversion method and conversion device, which aims to solve the technical problem of how to realize the simple and effective conversion of object-oriented model data to relational database data.

A method for transforming object-oriented model data, comprising:

Obtaining a database table and a pre-configured mapping relationship, and acquiring an object class and a mapping condition of the object-oriented model corresponding to the database table according to the mapping relationship;

Converting the object class to data in the database table according to the mapping condition.

Optionally, the step of converting the object class into data in the database table according to the mapping condition comprises:

Obtaining a value of the object class, and determining whether the value of the object class is a value of a corresponding object class in the mapping relationship;

If not, searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Converting the value of the found object class to the data in the database table according to the mapping condition.

Obtaining an attribute of the object class, and determining whether the attribute of the object class is an attribute of the corresponding object class in the mapping relationship;

Converting the attributes of the found object class to the data in the database table according to the mapping condition.

Obtaining a relationship between the object classes, and determining whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship;

Converting the relationship between the found object classes into the database table according to the mapping condition The data.

Optionally, the step of searching according to the relationship between the object class and the object class and other object classes includes:

According to the mapping relationship, the object class and the parent-child relationship, the association relationship, or the combination relationship between the object class and other object classes are searched.

An apparatus for converting object-oriented model data, the object-oriented model data conversion apparatus comprising:

The obtaining module is configured to: obtain a database table and a pre-configured mapping relationship, and acquire an object class and a mapping condition of the object-oriented model corresponding to the database table according to the mapping relationship;

The conversion module is configured to: convert the object class into data in the database table according to the mapping condition.

Optionally, the conversion module includes:

The first determining unit is configured to: obtain a value of the object class, and determine whether the value of the object class is a value of the corresponding object class in the mapping relationship;

The first searching unit is configured to: if the value of the object class is not the value of the object class, search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The first conversion unit is configured to: convert the value of the found object class into data in the database table according to the mapping condition.

Optionally, the conversion module includes:

The second determining unit is configured to: obtain an attribute of the object class, and determine whether the attribute of the object class is an attribute of the corresponding object class in the mapping relationship;

The second search unit is configured to: if the attribute of the object class is not an attribute of the object class, perform a search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The second conversion unit is configured to: convert the attributes of the found object class into data in the database table according to the mapping condition.

Optionally, the conversion module includes:

The third determining unit is configured to: acquire a relationship between the object classes, and determine whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship;

The third search unit is configured to: if the relationship between the object classes is not the relationship between the object class and other objects, according to the relationship between the object class and the object class and other object classes in the mapping relationship Find

The third conversion unit is configured to: convert the relationship between the found object classes into data in the database table according to the mapping condition.

A computer readable storage medium storing computer executable instructions for performing the method of any of the above.

An object-oriented model data conversion method and conversion device, when converting an object class of an object-oriented model into data in a database table, pre-configuring a mapping relationship between the object class and the database table, and obtaining a database table corresponding according to the mapping relationship The object class and the mapping condition of the object-oriented model can then be converted into the data in the database table according to the mapping condition. In the embodiment of the present invention, the mapping relationship between the object class and the database table is pre-configured, and it is determined that the mapping condition is met. Conversion, thus enabling a structured and efficient transformation of object-oriented model data to relational database data, the implementation process is relatively simple.

BRIEF abstract

1 is a schematic flow chart of an embodiment of an object-oriented model data conversion method according to the present invention;

2 is a schematic flow chart of a refinement of an embodiment of step S102 in FIG. 1;

3 is a schematic diagram of relationships between object classes in the object-oriented model of FIG. 1;

4 is a schematic flow chart of another embodiment of step S102 in FIG. 1;

FIG. 5 is a schematic diagram showing a refinement process of still another embodiment of step S102 in FIG. 1;

6 is a schematic diagram of functional modules of an embodiment of an object-oriented model data conversion apparatus according to the present invention;

7 is a schematic diagram of a refinement function module of an embodiment of the conversion module of FIG. 6;

8 is a schematic diagram of a refinement function module of another embodiment of the conversion module of FIG. 6;

FIG. 9 is a schematic diagram of a refinement function module of still another embodiment of the conversion module of FIG. 6. FIG.

Embodiments of the invention

An embodiment of the present invention provides a method for converting object-oriented model data. Referring to FIG. 1, in an embodiment, the method for converting object-oriented model data includes:

Step S101: Obtain a database table and a pre-configured mapping relationship, and obtain an object class and a mapping condition corresponding to the database table according to the mapping relationship.

This embodiment can be applied to data management of a wireless base station.

In this embodiment, the mapping relationship is mainly configured by mapping the object class of the object-oriented model and the relational database table, that is, the mapping relationship between each object class (the name of the object class) and the database table (the name of the database table). .

In the mapping relationship, you can configure two types of object classes: this object class and other object classes. This object class is mandatory, and other object classes are optional.

The mapping relationship between the object class and the relational database table of the object-oriented model of the embodiment includes a one-to-one mapping relationship, a one-to-many mapping relationship, and a many-to-one mapping relationship, that is, an object class corresponding to a database table, An object class corresponds to a mapping relationship between multiple database tables and multiple object classes corresponding to one database table.

In this embodiment, the mapping condition indicates under what conditions the object class is converted into data in the database table.

In this embodiment, when the conversion is performed, the database table is traversed, and each database table is processed. According to the mapping relationship configuration, the corresponding object class list and the corresponding mapping conditions can be obtained.

Step S102: Convert the object class into data in the database table according to the mapping condition.

In this embodiment, the object class list corresponding to each database table is converted. When the mapping condition is met, the corresponding object class is converted into the data in the database table, and then the next in the object class list is processed. An object class; skipping the object class when the mapping condition is not met The next object class.

Then continue to process the next database table, the object class corresponding to the next database table is converted into data in the database table.

In this embodiment, at the time of conversion, the mapping between the object class and the database table field is obtained, and the data conversion is performed sequentially when the mapping condition is satisfied, that is, the object class is converted into data in the database table, and finally the data is generated according to the format of the relational database table. .

In this embodiment, the object class is converted into data in the database table, and the value of the object class may be converted into data in the database table, or the attribute of the object class may be converted into data in the database table, or may be Convert the relationship of an object class to data in a database table.

Compared with the related art, in this embodiment, when the object class of the object-oriented model is converted into the data in the database table, the mapping relationship between the object class and the database table is pre-configured, and the object-oriented model corresponding to the database table can be obtained according to the mapping relationship. The object class and the mapping condition can then be converted into the data in the database table according to the mapping condition. In this embodiment, the mapping relationship between the object class and the database table is pre-configured, and the conversion is determined when the mapping condition is satisfied, so that the implementation can be implemented. The object-oriented model data to the relational database data is organized and effective, and the implementation process is relatively simple.

In an embodiment, as shown in FIG. 2, based on the foregoing embodiment of FIG. 1, the foregoing step S102 includes:

Step S1021, obtaining the value of the object class, determining whether the value of the object class is the value of the corresponding object class in the mapping relationship, and if so, proceeding to step S1022, and if not, proceeding to step S1023;

Step S1022: Convert the value of the object class to the data in the database table according to the mapping condition;

Step S1023: Perform a search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Step S1024, converting the value of the found object class into data in the database table according to the mapping condition.

In this embodiment, the value of the object class can be converted into data in the database table, and the first step is to determine the desired Whether the value of the changed object class is the value of the object class itself. If it is the value of the object class, the value of the object class is directly converted into the data in the database table when the mapping condition is satisfied; if it is not the object class The value needs to be searched according to the relationship between the object class and the object class and other object classes. Referring to FIG. 3, the relationship between the object classes in the object-oriented model shown in FIG. 3 includes parent-child relationship and association relationship. And the combination relationship. In this embodiment, the object class and the parent-child relationship, the association relationship, or the combination relationship between the object class and the other object class may be searched.

One end of the diamond represents the parent object, and the other end represents the child object; one end of the arrow represents the referenced object, and the other end represents the reference object; the combination relationship is a combination of the parent-child relationship and the association relationship. The search for these relationships can be cross-level. For example, the parent-child relationship lookup: the parent relationship and the child relationship. For example, looking for the object class 0 from the object class 3 can be found directly through the parent relationship (3->1->0); instead, the object class 3 is found from the object class 0, Can be found directly through the child relationship (0->1->3). Association relationship lookup: that is, reference and referenced relationship, for example, looking up object class 6 from object class 3, can be found directly through the referenced relationship (3->7->6); from object class 6 to find object class 3, can be directly Find by reference relationship (6->7->3). Combination relationship search: parent relationship, child relationship, reference relationship, combination of referenced relationship, for example, to find object class 3 from object class 5, you can first find object class 6 through child relationship, and then find object class 3 by reference relationship.

In this embodiment, when the value of the object class is found, the value of the found object class is converted into the data in the database table on the premise that the mapping condition is satisfied.

In another embodiment, as shown in FIG. 4, based on the foregoing embodiment of FIG. 1, the foregoing step S102 includes:

Step S2021, acquiring the attribute of the object class, determining whether the attribute of the object class is the attribute of the corresponding object class in the mapping relationship, if yes, proceeding to step S2022, and if not, proceeding to step S2023;

Step S2022: Convert the attribute of the object class to the data in the database table according to the mapping condition;

Step S2023: searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Step S2024: Convert the attributes of the found object class into data in the database table according to the mapping condition.

In this embodiment, the attribute of the object class can be converted into the data in the database table. First, it is determined whether the attribute of the object class to be converted is the attribute of the object class itself. If the attribute of the object class is the attribute of the object class, the mapping condition is directly met. Convert the attributes of this object class to the data in the database table; if it is not the attribute of the object class, you need to search according to the relationship between the object class and the object class and other object classes. This embodiment can be based on this object. The class and the parent-child relationship, association relationship, or combination relationship between the object class and other object classes are searched. When the attribute of the object class is found, the attributes of the found object class are converted into data in the database table on the premise that the mapping condition is satisfied.

In still another embodiment, as shown in FIG. 5, based on the foregoing embodiment of FIG. 1, the foregoing step S102 includes:

Step S3021: Obtain a relationship between the object classes, determine whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship, and if yes, proceed to step S3022, and if not, Then proceeds to step S3023;

Step S3022: Convert the relationship between the object classes into data in the database table according to the mapping condition;

Step S3023: searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Step S3024: Convert the relationship between the found object classes into data in the database table according to the mapping condition.

In this embodiment, the relationship between the object classes can be converted into data in the database table. First, it is determined whether the relationship between the object classes to be converted is the relationship between the object class itself and other objects, and if the object class and other objects are The relationship is directly converted to the data in the database table when the mapping condition is satisfied; if not, the relationship between the object class and the object class and other object classes needs to be searched according to the relationship between the object class and the other object class. The object class and the parent-child relationship, association relationship, or combination relationship between the object class and other object classes are searched. When the relationship between the object classes is found, the relationship between the found object classes is converted into a database under the condition that the mapping condition is satisfied. The data in the table.

The embodiment of the present invention further provides an apparatus for converting object-oriented model data. As shown in FIG. 6, in an embodiment, the object-oriented model data conversion apparatus includes:

The obtaining module 101 is configured to: acquire a database table and a pre-configured mapping relationship, and acquire an object class and a mapping condition of the object-oriented model corresponding to the database table according to the mapping relationship;

This embodiment can be applied to data management of a wireless base station.

In this embodiment, the mapping relationship is mainly configured by mapping the object class of the object-oriented model and the relational database table, that is, the mapping relationship between each object class (the name of the object class) and the database table (the name of the database table). . The mapping relationship between the object class and the relational database table of the object-oriented model of the embodiment includes a one-to-one mapping relationship, a one-to-many mapping relationship, and a many-to-one mapping relationship, that is, an object class corresponding to a database table, An object class corresponds to a mapping relationship between multiple database tables and multiple object classes corresponding to one database table.

The conversion module 102 is configured to convert the object class into data in the database table according to the mapping condition.

In this embodiment, the object class list corresponding to each database table is converted. When the mapping condition is met, the corresponding object class is converted into the data in the database table, and then the next in the object class list is processed. An object class; when the mapping condition is not met, the object class is skipped and the next object class is processed.

In this embodiment, during the conversion, the mapping between the object class and the database table field is obtained, and the data conversion is performed sequentially when the mapping condition is met, that is, the object class is converted into data in the database table, and finally Generate data in the format of a relational database table.

In an embodiment, as shown in FIG. 7, the foregoing conversion module 102 includes:

The first determining unit 1021 is configured to: acquire a value of the object class, and determine whether the value of the object class is a value of a corresponding object class in the mapping relationship;

The first searching unit 1022 is configured to: if the value of the object class is not the value of the object class, search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The first converting unit 1023 is configured to convert the value of the found object class into data in the database table according to the mapping condition.

In this embodiment, the value of the object class can be converted into data in the database table. First, it is determined whether the value of the object class to be converted is the value of the object class itself. If the value of the object class is the value of the object class, the mapping condition is directly met. Convert the value of this object class to the data in the database table; if it is not the value of the object class, you need to find the relationship between the object class and the object class and other object classes, see Figure 3, Figure 3 The relationships between object classes in the presented object-oriented model, including parent-child relationships, associations, and composite relationships. In this embodiment, the object class and the parent-child relationship, the association relationship, or the combination relationship between the object class and the other object class may be searched.

One end of the diamond represents the parent object, and the other end represents the child object; one end of the arrow represents the referenced object, and the other end represents the reference object; the combination relationship is a combination of the parent-child relationship and the association relationship. The search for these relationships can be cross-level. For example, the parent-child relationship lookup: the parent relationship and the child relationship. For example, looking for the object class 0 from the object class 3 can be found directly through the parent relationship (3->1->0); instead, the object class 3 is found from the object class 0, Can be found directly through the child relationship (0->1->3). Association relationship lookup: that is, reference and referenced relationship, for example, looking up object class 6 from object class 3, can be found directly through the referenced relationship (3->7->6); from object class 6 to find object class 3, can be directly Find by reference relationship (6->7->3). Combination relationship lookup: parent relationship, child relationship, reference relationship, group of referenced relationships For example, if you find the object class 3 from the object class 5, you can first find the object class 6 through the child relationship, and then find the object class 3 by referring to the relationship.

In another embodiment, as shown in FIG. 8, the foregoing conversion module 102 may further include:

The second determining unit 2021 is configured to: acquire an attribute of the object class, and determine whether the attribute of the object class is an attribute of the corresponding object class in the mapping relationship;

The second searching unit 2022 is configured to: if the attribute of the object class is not an attribute of the object class, search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The second converting unit 2023 is configured to: convert the attributes of the found object class into data in the database table according to the mapping condition.

In another embodiment, as shown in FIG. 9, the conversion module 102 may further include:

The third determining unit 3021 is configured to: acquire a relationship between the object classes, and determine whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship;

The third searching unit 3022 is configured to: if the relationship between the object classes is not the relationship between the object class and other objects, according to the mapping relationship between the object class and the object class and other object classes Make a search;

The third converting unit 3023 is configured to: between the found object classes according to the mapping condition The relationship is converted to data in the database table.

In this embodiment, the relationship between the object classes can be converted into data in the database table. First, it is determined whether the relationship between the object classes to be converted is the relationship between the object class itself and other objects, and if the object class and other objects are The relationship is directly converted to the data in the database table when the mapping condition is satisfied; if not, the relationship between the object class and the object class and other object classes needs to be searched according to the relationship between the object class and the other object class. The object class and the parent-child relationship, association relationship, or combination relationship between the object class and other object classes are searched. When the relationship between the object classes is found, the relationship between the found object classes is converted into data in the database table under the condition that the mapping condition is satisfied.

One of ordinary skill in the art will appreciate that all or a portion of the steps of the above-described embodiments can be implemented using a computer program flow, which can be stored in a computer readable storage medium, such as on a corresponding hardware platform (eg, The system, device, device, device, etc. are executed, and when executed, include one or a combination of the steps of the method embodiments.

Alternatively, all or part of the steps of the above embodiments may also be implemented by using an integrated circuit. These steps may be separately fabricated into individual integrated circuit modules, or multiple modules or steps may be fabricated into a single integrated circuit module. achieve.

The devices/function modules/functional units in the above embodiments may be implemented by a general-purpose computing device, which may be centralized on a single computing device or distributed over a network of multiple computing devices.

When the device/function module/functional unit in the above embodiment is implemented in the form of a software function module and sold or used as a stand-alone product, it can be stored in a computer readable storage medium. The above mentioned computer readable storage medium may be a read only memory, a magnetic disk or an optical disk or the like.

Industrial applicability

In the embodiment of the present invention, the mapping relationship between the object class and the database table is pre-configured, and the conversion is performed when the mapping condition is satisfied, so that the object-oriented model data to the relational database data can be realized in a structured and effective manner, and the implementation process is simple.

Claims

A method for transforming object-oriented model data, comprising:

Obtaining a database table and a pre-configured mapping relationship, and acquiring an object class and a mapping condition of the object-oriented model corresponding to the database table according to the mapping relationship;

Converting the object class to data in the database table according to the mapping condition.
The method of converting object-oriented model data according to claim 1, wherein said converting said object class into data in said database table according to said mapping condition comprises:

Obtaining a value of the object class, and determining whether the value of the object class is a value of a corresponding object class in the mapping relationship;

If not, searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Converting the value of the found object class to the data in the database table according to the mapping condition.
The method of converting object-oriented model data according to claim 1, wherein said converting said object class into data in said database table according to said mapping condition comprises:

Obtaining an attribute of the object class, and determining whether the attribute of the object class is an attribute of the corresponding object class in the mapping relationship;

If not, searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Converting the attributes of the found object class to the data in the database table according to the mapping condition.
The method of converting object-oriented model data according to claim 1, wherein said converting said object class into data in said database table according to said mapping condition comprises:

Obtaining a relationship between the object classes, and determining whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship;

If not, searching according to the relationship between the object class and the object class and other object classes in the mapping relationship;

Converting the relationship between the found object classes into data in the database table according to the mapping condition.
The method for converting object-oriented model data according to claim 2, 3 or 4, wherein the step of searching according to the relationship between the object class and the object class and other object classes comprises:

According to the mapping relationship, the object class and the parent-child relationship, the association relationship, or the combination relationship between the object class and other object classes are searched.
A device for transforming object-oriented model data, comprising:

The obtaining module is configured to: obtain a database table and a pre-configured mapping relationship, and acquire an object class and a mapping condition of the object-oriented model corresponding to the database table according to the mapping relationship;

The conversion module is configured to: convert the object class into data in the database table according to the mapping condition.
The apparatus for converting object-oriented model data according to claim 6, wherein the conversion module comprises:

The first determining unit is configured to: obtain a value of the object class, and determine whether the value of the object class is a value of the corresponding object class in the mapping relationship;

The first searching unit is configured to: if the value of the object class is not the value of the object class, search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The first conversion unit is configured to: convert the value of the found object class into data in the database table according to the mapping condition.
The apparatus for converting object-oriented model data according to claim 6, wherein the conversion module comprises:

The second determining unit is configured to: obtain an attribute of the object class, and determine whether the attribute of the object class is an attribute of the corresponding object class in the mapping relationship;

The second search unit is configured to: if the attribute of the object class is not an attribute of the object class, perform a search according to the relationship between the object class and the object class and other object classes in the mapping relationship;

The second conversion unit is configured to: convert the attributes of the found object class into data in the database table according to the mapping condition.
The apparatus for converting object-oriented model data according to claim 6, wherein the conversion module comprises:

The third determining unit is configured to: acquire a relationship between the object classes, and determine whether the relationship between the object classes is a relationship between the corresponding object class and other objects in the mapping relationship;

The third search unit is configured to: if the relationship between the object classes is not the relationship between the object class and other objects, according to the relationship between the object class and the object class and other object classes in the mapping relationship Find

The third conversion unit is configured to: convert the relationship between the found object classes into data in the database table according to the mapping condition.
A computer readable storage medium storing computer executable instructions for performing the method of any of claims 1-5.