KR20070014365A - Control method of data for standard - Google Patents

Abstract

A method for managing standardization of data information is provided to enable banking facilities and large companies to possess automation, and a management organization and system, and efficiently/effectively manage data of entire company by constructing a metadata management system. A system catalog of a database is read and loaded to a standard data system(S10), and a power design file is uploaded to a server to read meta information of a model(S11). The meta information of the model is loaded to or discarded from the system(S12). The model of a model-Cd is deleted from design model loading information, design table information, and design column information of the system(S13). The model applied to the database is mapped in a database-to-model style(S14). A result comparing a table schema of an operation database with a standard column dictionary is output(S15). The model information of a design table is loaded and compared with the standard column dictionary(S16). It is checked whether the information of an operation system is matched with the information of the design information(S17). Attribute information of the database is loaded(S18).

Description

CONTROL METHOD OF DATA FOR STANDARD}

1 is a configuration diagram of a system for a method for standardizing and managing data information according to the present invention.

2 is a flowchart illustrating a standardization management method of data information of the present invention.

3 to 13 are display screens showing respective steps of managing an operation screen in the standardized management method of data information of the present invention.

The present invention relates to a standardized management method of data information of the present invention, and more particularly, to a standardized management method of a computer development and operation system.

With the development of the information industry, the establishment of metadata management system using computer networks is being actively performed. As data is used to make key decisions in management strategies, financial institutions and other businesses are setting up metadata management systems to increase data utilization. This is because the company's data is actively used in management strategy and decision making in recent years. We are building a metadata management system around banks that have completed the construction of next-generation systems and some large companies such as life insurance, cards and securities. In addition to the financial sector, telecommunications, distribution, and public institutions are actively reviewing the use of data.

Accordingly, related IT companies are also fiercely competing in the financial metadata management system market in connection with data integration.

In January last year, the Bank began building a data management system in parallel with the new system, and completed it in September. As such, banks and large corporations have a large amount of data, and most have plans to proceed in parallel with the construction of next-generation systems.

Now, financial institutions and large corporations are shifting their attention from data accumulation to simple transaction data. The use of this data is used in financial institutions and large corporations' management strategies and key decision making. This raises the need for systematic and efficient data management, recognizing the importance of data quality rather than the data itself.

In the meantime, each financial institution has managed data through the establishment of an enterprise-wide data warehouse (EDW) or the construction of a next-generation system, but it has been difficult because the management method is not automated.

The present invention has been made to solve the above-mentioned problems of the prior art, financial institutions and large enterprises through the establishment of a metadata management system equipped with automation, management organization, management system, etc. to enable efficient and effective enterprise-wide data management It aims to do it.

It also manages domain dictionaries, standard terminology dictionaries and representation data types as basic information management so that standard terms can be searched and applied during system maintenance and development, and standard column management, standard column dictionary, standard non-compliant DB column, The purpose is to search standard non-compliant model columns and work with standard terms and standard data types when creating tables. It is also an object of the present invention to manage the extracted programs and to collectively search the common codes used for each system.

The present invention is to read the system catalog of the DB for loading the standard data system for the purpose of the above, uploading the power design file to the server to read the information of the model, read the meta information of the model and load it into the system Or discarding, deleting the model of the model Cd from the design model loading information, design table information, design column information of the system, mapping the model applied to the DB to the DB-to-model, the table schema of the operational DB Outputting the result of comparison and comparison of the dictionary, taking model information of the design table and comparing it with the standard column dictionary, comparing the information of the operating system and the information of the design model, and determining the match and inconsistency, the attribute information of the DB It provides a standardized management method of the data information comprising the step of loading.

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

As shown in FIG. 1, a system for implementing a standardized management method of data information according to the present invention includes a user who is a plurality of users, a web server (JSP Container) through which the users log in through a computer, etc .; It is composed of a database server directly connected to the web server.

Using this management system, you can contact, start, stop, monitor and modify the web server. To access the web server, connect to the server through the web and log in by entering the ID and password. Start the web server by typing dwstart in the console window, for example. Shut down the web server, for example by typing dwstop into the console window. Web server monitoring allows you to monitor system usage by entering dwlog into a console window. For example, the JSP file can be uploaded using FTP after modification. If the CLASS is changed, the web server must be restarted. When modifying the CLASS file, move the CLASS file and JAVA file to a certain path. You must restart.

In the method of standardizing data information according to the present invention, as shown in FIG. 2, a system catalog of DB is read and loaded into a standard data system (S10), and a power design file is uploaded to a server to read the model information. Step (S11), reading the meta information of the model and loading or discarding it in the system (S12), deleting the model of the model Cd from the design model loading information, design table information, design column information of the system (S13), Mapping the model applied to the DB to DB vs. model (S14), and outputting the result of comparing and inspecting the table schema of the operation database with the standard column dictionary (S15), taking the model information of the design table and compare with the standard column dictionary In step S16, comparing the information of the operating system and the information of the design model to determine the match, inconsistency (S17), and loads the attribute information of the DB (S18).

Here, in step S10, as shown in FIGS. 3 to 5, after mapping DBMS-specific data types and standard data types and selecting a corresponding DB, a table catalog is displayed in the target system table view, and the corresponding DB may be selected. If the DB is loaded in the system, the loading status is displayed in the system view, and the catalog of the DB can be reflected in the standard data system by loading or discarding.

In addition, in step S11, when the file of the TreeView is selected as shown in FIG. 6, the XML information of the corresponding file is loaded, and if the folder is clicked, the contents of the folder can be viewed. Enter the folder name in the new folder name and click Create Folder to configure the screen so that a new folder can be created. Click Browse on the screen, select a file, and click Upload to configure the XML file to be uploaded to the server.

Steps S12 and S13 select the TreeView file to load the XML information of the corresponding wave as shown in FIG. 7, and if the model is loaded in the system with the model code name when the model is in mode, the current view of the model in the system view is displayed. Load the system load status. When you view a model in the system view and click Reflect on system, the model information is newly loaded, and when you click Discard from system in the existing loaded deleted system view, the model is discarded from the system and the XML file is selected in the tree view. And delete it, find the model information of the system with the model code registered in the file and delete it all.

Step S14 allows the DBMS to be registered and used in the common code as shown in FIG. 8, and the DB causes the data entered in the DB information management of the configuration to appear as a combo, and maps information of the model to be used or used in the DB. do.

In step S15, as shown in FIG. 9, a table of an operation DB is selected to determine whether a term suitable for a standard column dictionary is used, and a screen for displaying the result according to a condition is displayed.

In step S16, as shown in FIG. 10, DBMS, DB, and MODEL must be selected and a filter and a table are selected or all the queries are made. Configure the standard non-compliant model columns to be searched separately.

Step S17 allows the BMS to be registered and used in the common code as shown in FIG. 11, and the DB causes the data entered in the DB information management of the environment setting to appear as a combo, and the table is the basic information-DB meta information and the basic. Information-In the model meta information, the list of tables loaded in the system is displayed. In addition, mutual match and inconsistency of the selected table can be judged by the selected criteria-logical column name and physical column name.

Next, in step S18, the BMS can be registered and used in the common code as shown in Figs. 12 and 13, and the DB causes the data entered in the DB information management of the environment setting to appear as a combo, and the table shows basic information- DB Meta Info and Basic Info-In the model meta info, the list of tables loaded in the system can be displayed and the attributes of the selected table are inquired.

As described above, the present invention manages domain dictionaries, standard terminology dictionaries, and representation data types as basic information management so that standard terms can be searched and applied during system maintenance and development, and standard column dictionaries and standards as standard column management. Basic information management system to search non-compliant DB column, standard non-compliant model column, etc. to work with standard terminology and standard data type when creating table, and to manage extraction program and collectively search common code used by system In this way, it provides the effect of organizing and managing the standard data very efficiently.

The present invention is not limited to the above embodiments and may be variously modified and implemented by those skilled in the art without departing from the technical gist of the present invention.

Claims (1)

Loading system catalog of DB and loading it to standard data system, uploading power design file to server to read model information, loading and discarding system meta data and loading, system design model Deleting the model of the model Cd from the loading information, design table information, design column information, mapping the model applied to the DB to DB to model, and outputs the result of comparing and examining the table schema of the operation database with the standard column dictionary Step, taking the model information of the design table and comparing it with the standard column dictionary, comparing the information of the operating system and the information of the design model to determine the match, inconsistency, loading the attribute information of the DB Standardized management method of data information.

Images