KR101436423B1 - Facility Management Data Managing System and Method Therefor - Google Patents

Abstract

The present invention relates to a system and a method for managing data on facility maintenance and, more specifically, to a system and a method for managing data on facility maintenance, which set data schemas and data conversion codes to be suitable for an extract transform load (ETL) tool used by a management server with respect to data inputted in various forms and types; store data sources, the data schemas and the data conversion codes in an integrated database; monitor whether the data sources are updated; update and store a corresponding data source, data schema, and data conversion code when an update of the data source occurs; and enable a manager to search desired data by only searching the data schemas and the data conversion codes from the integrated database when the manager searches a specific data, thereby easily searching and checking data according to desired forms and types by only accessing the integrated database without finding scattered data sources one by one from the point of view of a facility maintenance manager.

Description

{Facility Management Data Management System and Method Therefor}

The present invention relates to a facility maintenance data management system and method. More particularly, the present invention relates to a facility maintenance data management system and method, and more particularly, to a facility maintenance data management system, Data schema, and data conversion code in the integrated database. It monitors whether the data source is updated. When the data source is updated, it updates and saves the data source, data schema, and data conversion code. Can retrieve the desired data by merely retrieving the data schema and data conversion code from the integrated database when searching for specific data, so that the facility maintenance manager does not search the scattered data sources Even to simply connect to the consolidated database is also related to facility maintenance data management system and method that allows to easily search and view the data according to the form and type of their choice.

Recently, researches are being conducted to manage facilities based on BIM, and the interoperability among these model data sources considering the expansion and convenience from the user point of view is becoming an issue.

In the field of construction, the Building Smart Association has developed the IFC (Industry Foundation Class) to standardize and to meet the requirements of the industry for smooth information interoperability. However, when exchanging data between models in practice, some information is lost or transformed (Lim Jae-In, 2008.6) have been reported.

In relation to these problems, the facility maintenance manager must find a separate data system that is scattered when searching for the data that he wants, since most facility management systems are separate files for each excel file or area of interest It is common to build and manage separately.

Accordingly, the documents related to the maintenance of the facilities, the management history file, the management information, and the information of the customer are not systematically managed. In order to search the drawings for the positional information of the facilities or to check the maintenance history, You need to search the device's folder and open the file directly.

On the other hand, technologies related to this type of system data interlocking include ETL (Extract Transform Load) technology for building a DW (Data Warehouse) in the field of business engineering.

In the GIS field, DW is extended to Spatial Data Warehouse (SDW) by including spatial data, and nonvolatile data with spatial and temporal properties are stored in an integrated manner to support analysis and decision making There was research (S. Chaudhuri, 1997).

SDW can be created and updated topic-oriented via ETL. In the BIM-related technology, the spatial data extracted from various types of system data through the ETL process have to be structured to support the data analysis requirements for the DW (Konstantin Krivoruchko, 2003).

Another related technology is the technology developed by H. Ufuk Gokce and K. Umut Gokce. In the energy management system, the system is implemented by extracting, transforming and loading data using ETL (H. Ufuk Gokce, 2011) .

However, in such technologies or researches, it has been pointed out that it is difficult to interwork with the model system data in an environment in which the database is used separately among the project stakeholders.

It is an object of the present invention to overcome the above problems by setting a data schema and a transform code suitable for an ETL tool used by a management server for data inputted in various types and types, Data schema and data conversion code is stored in the integrated database. It monitors whether the data source is updated. When the data source is updated, the data source, data schema, and data conversion code are updated and stored. When the administrator searches for specific data By retrieving the data schema and data conversion code from the integrated database, you can search for the data you want, so that the facility maintenance manager can access the integrated database without having to search through the scattered data sources. The user can easily search and confirm data in accordance with the type and type desired by himself / herself.

The present invention relates to a facility maintenance data management system, comprising: a data source for receiving data collection requests from a central server periodically or from time to time and transmitting related data to the central server; The facility maintenance data are received regularly or from time to time by sending a request for collection of data related to facility maintenance to the above-mentioned model data source, and the received facility maintenance data is classified according to a specific classification standard, The data schema and the data conversion code are set for each data so as to be suitable for the ETL (Extract Transform Load) tool for the maintenance related data, and if the update data of the facility maintenance data is updated, Collects data, receives a request to retrieve data related to facility maintenance from an administrator terminal, retrieves a data schema and a data conversion code to provide facility maintenance data, and stores facility maintenance data, data classification information, data schema, If the store data conversion code and related data is updated, the central server storing the update it; And a manager terminal for transmitting a facility maintenance related data search request to the central server and receiving facility maintenance related data from the central server.

In this case, the central server includes a function of layering the data to be classified into attributes of data in classifying the data collected from the model data source.

According to another aspect of the present invention, there is provided a facility maintenance data management method, comprising the steps of: (A) transmitting a facility maintenance related data collection request to a central data source and receiving facility maintenance data; (B) classifying the collected facility maintenance related data according to a specific classification criterion; (C) setting the data schema and the data conversion code on a data-by-data basis so that the central server compares the acquired facility maintenance related data collected and classified with the extracted data to the ETL (Extract Transform Load) tool; (D) the central server storing facility maintenance related data, data classification information, a data schema, and a data conversion code in an integrated database; (E) receiving the facility maintenance related data provision request from the administrator terminal and providing the facility maintenance related data to the central server; And (F) updating the related data of the integrated database by collecting updated data when the central server monitors whether the facility maintenance related data is updated at the model data source and updated.

In this case, the step (B) may include: (B1) the central server layering and classifying data to be classified into attributes of data.

In this case, the step (E) may include: (E1) the central server searches the data schema and the data conversion code set for each facility maintenance related data according to the search request from the administrator terminal, The method comprising the steps of:

According to the present invention, when a facility maintenance manager searches for specific data, it is possible to search for desired data by merely searching the data schema and data conversion code in the integrated database, There is an effect that it is possible to easily retrieve and check data according to a form and a type desired by itself even by accessing the integrated database without searching the data sources.

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is an overall configuration diagram of a facility maintenance data management system according to a preferred embodiment of the present invention; FIG.
FIG. 2 is a reference diagram for explaining a conventional facility maintenance operation scenario; FIG.
3 is a reference diagram for explaining a view definition metadata structure according to a preferred embodiment of the present invention;
4 is a reference diagram for explaining a data presentation method according to a preferred embodiment of the present invention.
FIG. 5 is an overall flowchart of a facility maintenance data management method according to a preferred embodiment of the present invention. FIG.

Before describing the specific details for the practice of the invention, terms and words used in the specification and claims should be construed to enable the inventor to properly define the concept of a term in order to best describe its invention It should be interpreted as meaning and concept consistent with the technical idea of the present invention.

It is to be noted that the detailed description of known functions and constructions related to the present invention is omitted when it is determined that the gist of the present invention may be unnecessarily blurred.

Hereinafter, a facility maintenance data management system according to a preferred embodiment of the present invention will be described in detail with reference to FIG. 1 to FIG.

FIG. 1 is a general configuration diagram of a facility maintenance data management system according to a preferred embodiment of the present invention, FIG. 2 is a reference diagram for explaining a conventional facility maintenance work scenario, and FIG. 3 is a block diagram of a preferred embodiment FIG. 4 is a reference diagram for explaining a method of representing data according to a preferred embodiment of the present invention. Referring to FIG.

1, a facility maintenance data management system according to a preferred embodiment of the present invention includes a data source 100, a central server 200, and an administrator terminal 300. As shown in FIG.

The data source 100 refers to various systems or databases that produce and provide data related to facility maintenance, and may be multiple, and may receive data collection requests periodically or from time to time, To the server (200).

The central server 200 is a server of a company that operates and provides the facility maintenance data management system according to the preferred embodiment of the present invention. The central server 200 includes a collection unit 210, a setting unit 220, a providing unit 230, (240).

The collection means 210 transmits facility maintenance related data collection requests to the model data source 100 periodically or from time to time and receives facility maintenance related data from the model data source 100 in the form of an XML file , The types and types of data related to facility maintenance may vary.

In order to explain the types of facility maintenance data collected by the collecting means 210, an FM work scenario to be applied for maintenance of a conventional facility or the like can be referred to in a public institution that manages the facility, as shown in FIG. 2 have.

Referring to FIG. 2, the data related to the maintenance of the facility includes basic information of the target facility, defect information of the target facility, target facility maintenance history information, maintenance company information, and maintenance cost information.

In addition, the collecting means 210 can classify the collected data related to the maintenance of the facilities according to a specific classification standard. The classification standard includes types of facilities, existence of facility defects, existence of facilities maintenance, types of maintenance companies, And may be a perspective of a user, a manager, an operator, or the like.

In this case, the user refers to a customer who actually uses the facility, the manager refers to the manager of the company that provides the central server 200, and the operator refers to the person in charge of the company that performs facility maintenance.

For example, if the facility manager logs in to the central server 200 through the manager terminal 300, he or she may want to check the status of the facility, and the worker performing the maintenance work through the facility management company may check the building structure information and maintenance history You may want to check the information. Therefore, collected facility maintenance related data should be classified according to each point of view and can be provided according to the viewpoint of the subject searching for the data.

In a preferred embodiment of the present invention, the user perspective information among the information classified by the collection means 210 may be corresponding manager information, facility number information, facility area information, etc., and the manager information may include facility layer information, facility classification information, Information on facility date, facilities area information, facility boundary information, facility size information, height information of facility, etc., and the operator information may be maintenance status information, maintenance ratio information, maintenance date information, and the like.

Particularly, when the collecting means 210 classifies the data collected from the model data source 100, the classification target data is expressed in layers of attributes of data, that is, a category, a name, a value and a type, Is formatted into category, property name, property value, and property type using metadata and script, that is, expressed as Property = {Category, Name, Value, Type}.

The setting unit 220 sets a data schema and a data conversion code on a data-by-data basis in accordance with an ETL (Extract Transform Load) tool for facility maintenance related data collected and classified by the collecting unit 210, And updates the facility maintenance related data in the storage unit 210 so that the collection unit 210 can collect the updated data.

The providing means 230 receives the facility maintenance related data provision request from the administrator terminal 300 and provides the facility maintenance related data to the administrator terminal 300. In particular, And provides the search result to the administrator terminal 300. The administrator terminal 300 searches the data schema and the data conversion code for each facility maintenance related data.

The object providing the facility maintenance related data by the providing means 230 is not limited to the administrator terminal 300 but may be provided in the form of XML either as a user terminal of a separate user or an operator or a worker terminal Of course.

The integrated database 240 stores the facility maintenance related data collected by the collecting means 210 and classified, the data classification information, the data schema set by the setting means 220, and the data conversion code, and the model data source 100 Data classification information, a data schema, and a data conversion code are integrated and stored, and when related data is updated, it is updated and stored.

The administrator terminal 300 transmits the facility maintenance related data provision request to the central server 200 and receives the facility maintenance related data from the central server 200. In particular, In the form of a search request by a keyword or the like, and receive the search result in the form of XML.

Hereinafter, collection, classification, and provision of facility maintenance related data by the model data source 100 handled by the central server 200 will be described in more detail by way of example.

In data processing of the central server 200, the data definition is handled by the DataView, and is converted from the ETL (Extract, Transform and Load), and is responsible for converting the data stored in the DW into a format that is easy to view. The parts related to data extraction and conversion are defined in LogicView and the ETL module defined here is responsible. The data extraction from the model data source 100 can be processed through the ETL and can include logic to perform data conversion, so that business logic processing can be implemented at the same time. ViewStyle is responsible for data representation by perspective. ViewStyle is responsible for handling styles so that the user can view the converted data.

LogicView, DataView, and ViewStyle are a collection of these model data extraction and transformation according to the user's point of view of acquiring information, so we define this point of view and reuse it. This metadata structure is shown in Fig.

To acquire an information view according to the viewpoint, the data view according to the step of processing information, the logic view for information conversion, and the style view for information representation are classified as follows.

end. Viewpoint-Oriented Conversion Logic View: Since this is the part that extracts and changes the data, this part applies using ETL. In order to process FM in the BIM-based system, it is necessary to extract the facility management data accumulated in the scattered DB and convert and store it in a form that is easy to use in DW. This is done in the ETL. The extracted attribute data can extract or analyze information supporting the viewpoint of project stakeholders through data extraction and refinement from various geospatial data, data conversion, and data loading in DW. In the present invention, the ETL engine uses Talend, an open source ETL. Data sources can be files, databases, Open API, and so on. OBJECT_GUID is defined so that the data can be combined with the BIM object.

I. Viewpoint-oriented data view: Defines a data view for representing extracted data as BIM object attributes. Attributes combine with BIM objects defined with OBJECT_GUID. Attributes are expressed in categories, names, values, and types. The attributes to be extracted are formatted with the metadata, script, and category, property name, property value, and property type. Types are defined as integer, real, and string types.

All. View-oriented style view: Defines the format for displaying data on the screen through the style view. For formatting, it is expressed in XML form as shown in FIG.

The concept as shown in FIG. 4 can be represented as an XML format as metadata. In the metadata format, LogicView maps from various data sources to defined data destinations and schemas. The DataView defines how data is formatted to represent BIM object attributes. The final information expression method is defined as StyleView and processes the expression format and unit conversion.

Hereinafter, a facility maintenance data management method according to a preferred embodiment of the present invention will be described in detail with reference to FIG.

5 is a flowchart illustrating a method of managing facility maintenance data according to a preferred embodiment of the present invention.

First, as shown in FIG. 5, the central server 200 transmits a facility maintenance related data collection request to the model data source 100 periodically or from time to time. From the model data source 100, Maintenance-related data in the form of an XML file (S10).

The facility maintenance related data received by the central server 200 in step S10 may include basic information of the target facility, target facility fault information, target facility maintenance history information, maintenance company information, and maintenance cost information.

Next, the central server 200 classifies the collected facility maintenance related data according to a specific classification criterion (S20).

The sorting criterion in step S20 may be a type of facility, a facility defect, the presence or absence of facility maintenance, a type of maintenance company, a maintenance cost, and the like, and may be a perspective of the user, the manager, or the operator.

Step S20 may include the step of the central server 200 layering and representing data to be classified into attributes of data, that is, a category, a name, a value, and a type.

Next, the central server 200 sets a data schema and a data conversion code for each facility so as to comply with the ETL (Extract Transform Load) tool for the facility maintenance related data collected and classified (S30).

Next, the central server 200 stores the facility maintenance related data, the data classification information, the data schema, and the data conversion code in the integrated database 240 (S40).

Next, the central server 200 receives the facility maintenance related data provision request from the administrator terminal 300 and provides the facility maintenance related data (S50).

In step S50, the central server 200 searches the data schema and data conversion code set for each facility maintenance related data according to the search request from the administrator terminal 300, and provides the search result to the administrator terminal 300 . ≪ / RTI >

Lastly, when the central server 200 monitors whether or not the facility maintenance related data is updated in the data source 100, the central server 200 collects the updated data and updates related data of the integrated database 240 (S60) .

While the present invention has been particularly shown and described with reference to preferred embodiments thereof, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims. It will be appreciated by those skilled in the art that numerous changes and modifications can be made without departing from the invention. Accordingly, all such modifications and variations are intended to be included within the scope of the present invention.

100: Data source 200: Central server
210: collecting means 220: setting means
230: Providing means 240: Integrated database
300: administrator terminal

Claims (5)

A facility maintenance data management system comprising:
A data source 100 for receiving data collection requests from the central server 200 periodically or from time to time and transmitting related data to the central server 200;
The facility maintenance related data collection request is transmitted to the data source 100 periodically or from time to time to receive the facility maintenance related data in the form of an XML file and the received facility maintenance related data is classified according to a specific classification standard , A data schema and a data conversion code are set for each data so as to comply with an ETL (Extract Transform Load) tool for data related to facility maintenance collected and classified, and whether or not to update the facility maintenance related data in the data source 100 And updates data related to facility maintenance by retrieving a data schema and a data conversion code by receiving a facility maintenance related data retrieval request from the administrator terminal 300. In addition, Data, data classification information, data A central server 200 for storing a schema and a data conversion code, and updating and storing related data when they are updated; And
And an administrator terminal (300) for transmitting a facility maintenance related data search request to the central server (200) and receiving facility maintenance related data from the central server (200)
The central server 200 classifies the data collected from the data source 100 by a user's viewpoint, a manager's viewpoint and an operator's viewpoint, and the user's viewpoint information includes corresponding manager information, facility number information, and facility area information And the manager perspective information includes the facility floor information, the facility classification information, the facility name information, the facility date information, the facility area information, the facility boundary information, the facility size information and the facility height information, Maintenance ratio information, and maintenance date information,
The central server 200 classifies the data to be classified into categories, a property name, a property value, and a type (hereinafter referred to as " property type), and formatting the facility maintenance data.
delete delete delete delete

Images