KR102124954B1 - IoT PLATFORM SYSTEM FOR SUPPORTING HETEROGENEOUS DATABASE MANAGEMENT SYSTEM SIMULTANEOUSLY AND OPERATING METHOD THEREOF - Google Patents

Abstract

According to one embodiment of the present invention, provided is an IoT platform system for simultaneously supporting a heterogeneous database management system, which comprises: a message processing module processing a received message and delivering the received message to a target client or a server; a DB adapter receiving a request for access to data storage from the message processing module and generating a query in accordance with a type of a database management system to be accessed; and data storage configured with a plurality of types of database management systems and performing an operation in accordance with a query generated by the DB adapter.

Description

IoT platform system for simultaneous support of heterogeneous database management system and its operation method{IoT PLATFORM SYSTEM FOR SUPPORTING HETEROGENEOUS DATABASE MANAGEMENT SYSTEM SIMULTANEOUSLY AND OPERATING METHOD THEREOF}

The present invention relates to an IoT platform system and its operation method for simultaneously supporting heterogeneous database management systems, and more specifically, an IoT platform system and its operation method to enable access to various types of databases with a common service logic. It is about.

Recently, with the development of IT technology and communication technology, IoT platforms that enable data transmission and reception between various IoT devices and communication between IoT devices and service servers are widely used.

In order to process service logic in IoT platform, it is necessary to access the database. Types of databases include relational databases and non-relational databases, and various types of databases exist in relational and non-relational databases.

In the existing IoT platform, service logic had to be developed differently according to the type of the database, and this had to be verified.

For example, if the database you want to access from the IoT platform is Oracle, which is a kind of relational database management system (RDBMS), you need to create a module for database query processing according to it, and create service logic that utilizes it. did.

If you want to install and use this IoT platform on a site that uses MySQL, which is a kind of non-relational database management system, it is necessary to modify the source code of the IoT platform developed for the existing Oracle database.

In the case of such a relational database management system family, the scope of change may not be great, but the transition from relational to non-relational involved amendments to the vast range.

This problem was problematic even when the customer first introduced the IoT platform, but was particularly problematic when replacing the database with a heterogeneous database while using the IoT platform.

In order to solve the above problems, it is necessary to support the IoT platform that does not depend on the type of database, and with the existing technology, an implementation (code implementation) capable of supporting all types of databases must be added to the IoT platform internal implementation.

This will allow the IoT platform to use multiple types of databases, but the IoT platform itself will become heavy and the functional relationships will be complicated, making maintenance difficult.

In addition, since several types of databases exist in relational and non-relational databases, verification of the operation of the existing database is required whenever a new type of database is added, and the verification scope is inevitably expanded.

In addition, since this method affects service logic that is not related to the database, the scope of modification is inevitably widened, such as having to modify not only the database processing module but also the service logic whenever a database is added.

The present invention is to solve the above-mentioned problems of the prior art, and an object thereof is to enable work processing with a common service logic regardless of the type of database.

Another object of the present invention is to allow the modification of the upper layer to be minimized even if the type of database is added, so that the coupling between the service logic and the database is low.

Another object of the present invention is to enable the creation of service logic in the same way regardless of the database type from the developer's point of view.

The objects of the present invention are not limited to the objects mentioned above, and other objects not mentioned will be clearly understood from the following description.

According to an embodiment of the present invention for achieving the above object, an IoT platform system for simultaneously supporting a heterogeneous database management system, comprising: a message processing module that processes a received message and delivers it to a target client or server; A DB adapter that receives a request for access to data storage from the message processing module and generates a query according to the type of database management system to be accessed; And a data storage configured with a plurality of types of database management systems and performing an operation according to a query generated by the DB adapter.

The DB adapter includes a business data connection module that is requested to access data storage from a business module including service logic; And a common data access module that converts the common query syntax transmitted from the business data access module to suit the type of database management system to be accessed.

The DB adapter may further include a DB proxy that delivers a query converted by the common data access module to the data storage through a proxy determined according to the type of database management system to be accessed.

The DB adapter may further include a configuration applying module that supports determining a specific proxy according to the type of the database management system to be connected among the plurality of proxies according to the type of database management system.

The DB adapter may further include a custom specialized module that works with the DB proxy and supports additional functions when necessary.

According to another embodiment of the present invention, an operation method of an IoT platform system for simultaneously supporting a heterogeneous database management system, the method comprising: receiving data from a client; Calling a DB adapter for access to data storage through a business module in the business layer; In response to the call, the common data connection module in the DB adapter converting the integrated query syntax into a query according to the type of database management system to be accessed; And transmitting the query converted by the common data connection module to a data storage through a proxy corresponding to the type of the database management system.

The method may further include, prior to the step of receiving the data, determining a proxy to be used according to a type of a database management system to be accessed based on a setting value of a setting file by a setting applying module in the DB adapter. Can be.

The method may further include, after the step of invoking the DB adapter, passing, by the business data connection module in the DB adapter, the integrated query syntax to the common data connection module.

According to an embodiment of the present invention, work processing with common service logic is possible regardless of the type of database.

According to an embodiment of the present invention, even if the type of database is added, since the change of the upper layer is minimized, the degree of coupling between the service logic and the database can be reduced.

According to an embodiment of the present invention, it is possible to write service logic in the same way regardless of the database type from the developer's point of view.

It should be understood that the effects of the present invention are not limited to the above-described effects, and include all effects that can be deduced from the configuration of the invention described in the detailed description or claims of the present invention.

1 is a diagram schematically showing the configuration of an IoT system according to an embodiment of the present invention.
2 is a view showing the internal configuration of the IoT platform system according to an embodiment of the present invention.
3 is a view showing the architecture of an IoT platform system according to an embodiment of the present invention.
4 is a view showing a DB adapter operation process of the IoT platform system according to an embodiment of the present invention.

Hereinafter, the present invention will be described with reference to the accompanying drawings. However, the present invention may be implemented in various different forms, and thus is not limited to the embodiments described herein. In addition, in order to clearly describe the present invention in the drawings, parts irrelevant to the description are omitted, and like reference numerals are assigned to similar parts throughout the specification.

Throughout the specification, when a part is "connected" to another part, this includes not only "directly connected" but also "indirectly connected" with another member in between. . Also, when a part “includes” a certain component, this means that other components may be further provided instead of excluding other components, unless otherwise stated.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is a diagram schematically showing the configuration of an IoT system according to an embodiment of the present invention.

Referring to FIG. 1, the IoT system may include a client 100, an IoT platform system 200, a data analysis platform system 300, and a service providing server 400.

The client 100 includes a home device, a sensing sensor, an energy sensor, an environmental sensor, a factory device, a device switch, an IoT device such as a robot, a mobile terminal (a computing device equipped with a communication function such as a mobile phone, a smartphone, a tablet PC), It is a concept including a gateway and the like.

The IoT platform system 200 enables communication between the clients 100 or communication and message transmission and reception between the client 100 and the service providing server 400. For example, collecting data from the client 100, requesting the analysis of the data from the data analysis platform system 300, processing the data analysis result received from the data analysis platform system 300 to provide a service server ( 400). In addition, the IoT platform system 200 provides management functions for each service provided by the service providing server 400.

The IoT platform system 200 may provide a data collection/delivery function, a data storage function, a service utilization function, a portal service support function, and an IoT security function.

The data collection/delivery function collects data from the client 100 in various protocols such as IoT standard protocols such as HTTP, MQTT, CoAP, TCP, Web Socket, BACnet, Modbus, or industry standard protocols, and transmits them to other devices. Function.

The data storage function stores the registration information, group information, data security policy, network connection information, message transmission information, data subscription information, device location information, charging policy, etc. of each client 100 according to the standard, and external linkage It is a function to store service information, platform status information, and authentication information.

The service utilization function is to provide various basic functions that can provide various services. The basic functions include device information processing, device search, group information processing, service information processing, platform information processing, network connection processing, message parsing/transmission, data storage processing, subscription and notification, security policy application, device location search, charging Processing, user/terminal authentication, firmware information processing, and the like.

Portal service support functions include portal service support functions for administrators such as service management, terminal management, platform monitoring, log monitoring, firmware management, and system management functions, and portals for developers such as service management, terminal management, technical support, and openAPI testing. Includes service support functions.

The IoT security function is to provide a security policy applied when information is transmitted to the service providing server 400 for data collection/transmission from the client 100 and data utilization through the network.

Meanwhile, the service providing server 400 functions to provide various services using an IoT system, and may provide services such as smart city, smart building, smart factory, smart home, and smart mobility.

2 is a view showing the internal configuration of the IoT platform system 200 according to an embodiment of the present invention.

Referring to FIG. 2, the IoT platform system 200 may be implemented as software for a server, and may include a front end layer 210 and a back end layer 220.

The front end layer 210 may include a message queue 211, a message broker 212, a message processing module 213, a firmware management module 214, a DB adapter 215, and a back end layer 220 May include a data storage 221, a service API 222, a management portal support module 223, a cache memory 224, and a network attached storage (NAS) 225.

Front end layer 210, back end layer 220, message queue 211, message broker 212, message processing module 213, firmware management module 214, DB adapter 215, data storage 221 ), the service API 222, the management portal support module 223, the cache memory 224, and the network-coupled storage 225 may be program modules or hardware capable of communicating with an external device. The program module or hardware may be included in the IoT platform system 200 in the form of an operating system, an application program module, and other program modules, and may be physically stored on various known storage devices. Meanwhile, these program modules or hardwares include, but are not limited to, routines, subroutines, programs, objects, components, data structures, etc. that perform specific tasks or execute specific abstract data types to be described later according to the present invention.

The message queue 211 performs a function of waiting for a message before the message broker 212 transmits and receives a message with the message processing module 213.

The message broker 212 provides a communication channel between the client 100 and the IoT platform system 200, and is an information transmission relay module for internal processing of the IoT platform system 200. That is, the message broker 212 serves as a proxy for the message processing module 213.

The message processing module 213 receives a standard message from the message queue 211 or the message broker 212 and transmits it to the target client 100 or the service providing server 400, or processes a service corresponding to the message. To perform. In addition, the message processing module 213 processes the message and transmits and receives data to and from the data storage 221 through the DB adapter 215.

The firmware management module 214 provides firmware for each version to the client 100 or the service providing server 400, and provides a firmware management and upgrade function. In addition, the DB adapter 215 and network-coupled storage 225 can be tracked.

The DB adapter 215 receives a request related to a DB connection from the message processing module 213 and performs a transaction with the data storage 221 of the back end layer 220.

The DB adapter 215 according to an embodiment of the present invention processes messages regardless of the type of the data storage 221, for example, a relational database management system (RDBMS) or a non-relational database management system. The transaction between the module 213 and the data storage 221 is processed.

By doing so, the message processing module 213 performs only message processing without considering whether the data storage 221 is a relational database management system, a non-relational database management system, or any type within a relational or non-relational database management system. You can.

The detailed configuration and detailed operation method in the DB adapter 215 will be described in detail later.

The data storage 221 of the back end layer 220 stores all data used in the IoT platform system 200. A non-relational database management system 221a and a relational database management system 221b may exist in the data storage 221. In the data storage 221, the non-relational database management system 221a and the relational data are stored. At least one of the database management systems 221b may be selectively used.

In addition, when it is necessary to perform a quick request or response according to an application program, the data storage 221 may temporarily store the corresponding data.

The service API 222 is responsible for communication between the data storage 221 and the external platform system 500, and rules for communication may be defined therein.

The management portal support module 223 interoperates with the management portal 600 that supports the portal service for managing the IoT platform system 200 from the administrator's perspective.

The cache memory 224 functions to temporarily store messages or authentication information processed by the message broker 212, the message processing module 213, and the firmware management module 214.

The network-coupled storage 225 stores files for each version of firmware installed in the client 100 or the service providing server 400, and performs a function of providing necessary firmware according to a request from the firmware management module 214. .

3 is a view showing the architecture of an IoT platform system according to an embodiment of the present invention.

Referring to FIG. 3, the IoT platform system 200 according to an embodiment may be implemented in a separated and layered architecture with a business layer (BL) and a data access layer (DAL).

The business layer BL is an area related to business, and may include a plurality of business modules BM as a layer in charge of processing application logic and the like.

Each business module (BM) is a set of functions with logic related to a service. When access to the data storage 221 is required, that is, when a call to the data storage 221 is made, the DB adapter 215 To pass the processing right.

The data access layer (DAL) is a layer corresponding to the DB adapter 215 described with reference to FIG. 2.

The data access layer (DAL), that is, the DB adapter 215 includes a business data connection module 2151, a common data connection module 2152, a DB proxy 2153, a setting application module 2154, and a custom specialization module 2155 ).

The business data connection module 2151 utilizes the functions of the common data connection module 2152 as needed. That is, the business data connection module 2151 tries to access the data storage 221 by calling the common data connection module 2152 according to a request from the business layer BL.

The common data connection module 2152 is responsible for accessing the data storage 221 from a service processing viewpoint. That is, the common data connection module 2152 includes all operations and functions related to access to the data storage 221.

According to an embodiment, a unified query syntax may be input to the business data access module 2151 by a business module (BM), and the common data access module 2152 may access the unified query syntax. It may include an integrated query converter (Unified Query Converter) to convert to suit the type of database management system.

For example, when a business module (BM) attempts to add a dog to a table named animal existing in the relational database management system of the data storage 221 for a data object named animal, the business data access module 2151 includes Animal. Expressions such as Insert ("Dog", "1", "10") are input, and the integrated query converter of the common data access module 2152 inserts the expressions according to the type of database management system to be accessed. INSERT INTO Animal (Category) , age, weight) VALUES ('Dog', '1', '10').

When the IoT platform system 200 is driven, the common data access module 2152 reads a common query syntax written in the business data access module 2151 to generate a query suitable for the type of database management system to be accessed.

The common data connection module 2152 enables query processing regardless of whether the access target is a relational database management system or a non-relational database management system, that is, regardless of the type of database.

In addition, the change of the upper layer is minimized thereby, and the degree of coupling between the service logic and the database can be lowered. That is, it is possible for the developer to write service logic in the same way regardless of the database type.

For example, even if the database is replaced with a heterogeneous database management system while the IoT platform system is in operation, switching is possible without changing the service logic by changing only the settings.

The DB proxy 2153 serves as a practical communication medium between the business data access module 2151 and the data storage 221. The business data access module 2151 controls communication according to the type of database management system (relational or non-relational database management system, various types of systems in a relational or non-relational database management system) to be accessed.

Since the DB proxy 2153 inherits the common data connection module 2152, a common query converter function is also internalized.

The DB proxy 2153 has a connection proxy for each type of database management system, and may be generated when the IoT platform system 200 is built.

When the business data access module 2151 accesses the data storage 221 through the common data access module 2152 and the DB proxy 2153, the actual data access module 2152 is converted according to the integrated query syntax converted by the common data access module 2152. Create, Read, Update, Delete operations are performed. The result processed by accessing the data storage 221 is transmitted from the DB proxy 2153 to the business module BM through the upper layer, that is, the common data access module 2152 and the business data access module 2151.

The setting application module 2154 checks the type of the database management system that needs access, and passes the verification result to the DB proxy 2153. Accordingly, a proxy suitable for the type of database management system to be accessed can be selected.

The custom specialization module 2155 is a module including functions to be additionally executed according to characteristics of a database management system or characteristics of a requested operation, which may be omitted.

4 is a view showing a DB adapter operation process of the IoT platform system according to an embodiment of the present invention.

Referring to FIG. 4, when the IoT platform system 200 is driven, the setting application module 2154 reads a setting file to determine the type of database management system to use (S410 ). The configuration file exists in the business layer BL, and may include information on the type of database management system to be accessed.

The result determined by the setting applying module 2154 is transmitted to the DB proxy 2153 (S420), and accordingly, a proxy to be used in the DB proxy 2153 is determined. That is, a proxy corresponding to the type of the database management system to be accessed is determined.

Since it is possible to switch to a relational database management system or a non-relational database only through the configuration information existing in the configuration file, there is no significant effect on the service logic stage.

When data is transmitted from the client 100 or the server 400 to the IoT platform system 200 (S430), the business layer BL processes the corresponding data through a business module (BM) for each business, and then accesses business data By calling the module 2151, access to the data storage 221 is attempted (S440). For example, if the client 100 is a temperature sensor and stores sensed information in a DB, after processing data in the temperature processing module BM of the business layer BL, the temperature data connection module 2215 Will call

The business data connection module 2151 utilizes the functions of the common data connection module 2152 and calls the common data connection module 2152 to access the data storage 221 through the DB proxy 2153 (S450). . The common data connection module 2152 converts the query transmitted from the business data connection module 2215 to call the DB proxy 2153 (S460). If necessary, the DB proxy 2153 uses functions to be additionally executed through the custom-specific module 2155 (S461).

When the IoT platform system is driven in the DB proxy 2153, access to the data storage 221 is performed by a specific proxy determined by the setting application module 2154 (S470).

According to an embodiment of the present invention, work processing with a common message is possible regardless of the type of database management system.

The above description of the present invention is for illustration only, and those skilled in the art to which the present invention pertains can understand that the present invention can be easily modified into other specific forms without changing the technical spirit or essential features of the present invention. will be. Therefore, it should be understood that the embodiments described above are illustrative in all respects and not restrictive. For example, each component described as a single type may be implemented in a distributed manner, and similarly, components described as distributed may be implemented in a combined form.

The scope of the present invention is indicated by the following claims, and all modifications or variations derived from the meaning and scope of the claims and their equivalent concepts should be interpreted to be included in the scope of the present invention.

Claims (8)

As an IoT platform system to simultaneously support heterogeneous database management systems,
A business module including service logic and processing a message received from a client;
A DB adapter that receives a connection request for data storage from the business module and generates a query according to the type of database management system to which the business module is accessed; And
It is composed of a plurality of types of database management systems, and includes data storage that performs an operation according to a query generated by the DB adapter.
The DB adapter,
A business data access module that is requested to access data storage from the business module; And
An IoT platform system including a common data connection module that converts a common query syntax transmitted from the business data connection module and input by the business module according to the type of database management system to be accessed. According to claim 1,
The DB adapter,
An IoT platform system including a plurality of connection proxies according to the type of the database management system, and further comprising a DB proxy that delivers a query converted by the common data access module to the data storage through the access proxy. According to claim 2,
The DB adapter,
Further comprising a configuration applying module for determining the type of database management system that needs access based on a configuration file in the business layer containing the business module and passing the decision to the DB proxy,
The DB proxy receives the decision from the setting application module, and determines an access proxy to be used for access according to the type of database management system that requires the access among the plurality of access proxies. According to claim 3,
The DB adapter,
IoT platform system further comprising a custom module for interworking with the DB proxy and supporting additional functions according to the characteristics of the database management system or the operation requested for the database management system. According to claim 1,
The common data connection module,
And an integrated query converter that converts the common query syntax according to the type of database management system to be accessed. As an operation method of the IoT platform system for supporting a business module including service logic in an IoT platform system to access a heterogeneous database management system included in data storage,
Receiving data from a client;
The business module calling a DB adapter for access to the data storage;
In response to a call of the business module, passing a query syntax common to the business data connection module in the DB adapter to a common data connection module in the DB adapter;
The common data connection module converting the passed common query syntax into a query corresponding to a type of database management system to which the business module is accessed; And
And passing the query converted by the common data connection module to the data storage through a DB proxy corresponding to the type of the database management system. The method of claim 6,
IoT platform, further comprising the step of applying a setting module in the DB adapter to determine the type of the database management system to be accessed based on a setting file in the business layer including the business module and passing the decision to the DB proxy. How the system works. The method of claim 7,
The DB proxy determines the access proxy to be used for access according to the type of the database management system to be accessed among the plurality of access proxies inside, and transmits the converted query to the data storage through the determined access proxy. The method of operating the IoT platform system further comprising the step of.

Images