KR100871784B1 - Apparatus and method for updating data valid value in table column - Google Patents

Abstract

The present invention relates to a current management apparatus and method for easily understanding the meaning of data values recorded in a table that is a physical storage of data in a system that is not standardized, and an effective value recorded in a column of a data table. The current management apparatus for managing the actualization of a (valid value) may include extracting a column including the classification word as part of the column name based on the classification word and the negative word input by the user, but not including the classification word as part of the column name. Current object extraction means; Data valid value collecting means for collecting a data valid value for each column extracted by the current object extraction means; And column definition generation means for retrieving the meaning of the data valid values of each column collected by the data valid value collecting means from a semantic dictionary database to generate a semantic definition of the data valid values of each column.

Currentization, Tables, Valid Values, Meanings, Meaning Definitions

Description

Apparatus and method for managing the effective value of data {APPARATUS AND METHOD FOR UPDATING DATA VALID VALUE IN TABLE COLUMN}

1 is a functional configuration diagram of a table actualization management apparatus according to an embodiment of the present invention.

2A is an example of an interface screen of the current object extraction module.

2B is an example of an interface screen of a schedule registration module.

2C is an example of an interface screen of a meaning inquiry module.

3 is a flowchart illustrating a data effective value actualization management method according to an embodiment of the present invention.

<Explanation of symbols for the main parts of the drawings>

110: extraction target module 120: schedule registration module

130: valid data collection module 140: column definition generation module

150: semantic lookup module 160: table DB

170: semantic dictionary DB 180: current target DB

190: semantic definition DB

The present invention relates to current management, and more particularly, to the management of a table, which is a physical repository for storing and managing data.

As the data table managed by the company increases over time, its complexity continues to increase, and many companies try to manage the data table through reverse modeling, but the important data included in the data table We don't know what value and meaning are. As a result, data quality is degraded and causes system failure.

Recently, the data model manages the values of the data recorded in the data table through the code to understand the meaning, but this is only possible for the new system to which standardization is applied. It is still difficult to understand the meaning of the values of the data recorded in the data table.

For example, when one column of a table that manages subscription information of a subscriber is an item that records the subscriber's subscription status, and the subscriber's subscription status is contract, termination, suspension, etc., conventionally, the subscriber's subscription status information is For the contract, the contract is coded into 'subscribe', the cancel 'cancel', and the suspension is coded as 'suspension'. However, the meanings of the codes recorded in such a table can be easily understood only by the person in charge who first defined the code. Accordingly, developers who develop a system using such a table take a considerable time to understand the data values recorded in the table, and thus, system development is very delayed. Of course, if the codes recorded in the table are standardized, the meaning can be easily understood. However, as described above, in the new system and the existing system to which the standard is not applied, the meaning of the values of the data recorded in the table is still understood. There is a difficulty.

The present invention has been proposed to solve the above problems, and provides an apparatus and method for managing the current, which enables to easily grasp the meaning of data values recorded in a table, which is a physical storage of data, in a system that is not standardized. There is a purpose.

Other objects and advantages of the present invention can be understood by the following description, and will be more clearly understood by the embodiments of the present invention. Also, it will be readily appreciated that the objects and advantages of the present invention may be realized by the means and combinations thereof indicated in the claims.

According to the first aspect of the present invention for achieving the above object, the current management device for the actualization management of the data table, based on the classification words and negative words entered by the user includes the classification words as part of the column name The negative term extraction means means for extracting a column that does not include as part of the column name; A data valid value collection step of collecting data valid values for each column extracted by the current object extraction means; And column definition generation means for retrieving the meaning of data valid values of each column collected by the data valid value collecting means from a semantic dictionary database and generating a semantic definition of the data valid values of each column. do.

Preferably, the apparatus may further include scheduling means for scheduling the execution of the currentization according to the current execution date and the execution period input from the user.

Also, preferably, a semantic definition database for storing the semantic definition generated by the column definition generating means; And semantic definition inquiry means for retrieving the semantic definition of the column selected by the user from the semantic definition database and providing the semantic definition to the user.

The classification word may include at least one of a code, a number, a rate, an ID, a serial number, and a date.

On the other hand, the meaning definition query means, characterized in that for adding the data valid value and the meaning of the valid value input by the user to the meaning definition retrieved from the meaning definition database.

According to a second aspect of the present invention for achieving the above object, the current management method for managing the actualization of the data table, (a) receiving a classification word and a negative word from the user; (b) extracting a column including the classification term as part of the column name but not including the negative term as part of the column name; (c) collecting data valid values for each of the extracted columns; (d) retrieving a meaning of data valid values of each collected column from a semantic dictionary database; And (e) generating a meaning definition for each column by mapping the retrieved meanings to data valid values of each column.

Preferably, prior to the step (c), further comprising the step of receiving the date of the currentization execution from the user; wherein the steps (c) to (e) is characterized in that is performed upon the arrival of the date of the currentization It is done.

Also, preferably, (f) receiving a specific column from the user; And (g) searching and providing the semantic definition of the selected column to the user.

The classification word may include at least one of a code, a number, a rate, an ID, a serial number, and a date.

The method may further include receiving a data valid value to be input in addition to the semantic definition searched in the step (g) and the meaning of the valid value from the user and storing the data valid value in the searched semantic definition.

The above objects, features and advantages will become more apparent from the following detailed description taken in conjunction with the accompanying drawings, whereby those skilled in the art may easily implement the technical idea of the present invention. There will be. In addition, in describing the present invention, when it is determined that the detailed description of the known technology related to the present invention may unnecessarily obscure the gist of the present invention, the detailed description thereof will be omitted. Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

Valid-value actualization management refers to extracting and managing a minimum unit of information that is the basis of an information system managed by an enterprise. In an embodiment of the present invention, homogeneity among information managed by an information system of an enterprise is managed. The current management of the table, which is the physical repository that stores and manages the information with the system. Furthermore, the current management is performed on a column, which is a storage unit that stores a substantial data value as an item for managing information in the table.

1 is a functional configuration diagram of a table actualization management apparatus according to an embodiment of the present invention, the function and operation of the table actualization management apparatus according to the present invention will be described with reference to FIGS. 2A to 2C.

Table currentization management apparatus according to the present invention shown in Figure 1, the currentization target extraction module 110, schedule registration module 120, data valid value collection module 130, column definition generation module 140, meaning The query module 150 includes a table DB 160, a semantic dictionary DB 170, a current target DB 180, and a semantic definition DB 190. The table actualization management apparatus according to the present invention is a computing system including a ROM, a RAM, a CPU, an operating system, and a program storage device. Each component module shown in FIG. 1 configures a predetermined current management program to store a program storage device. It may be stored in and operate, or may be implemented in hardware to operate. This can be selected according to the embodiment.

First, the currentization target extraction module 110 searches for and extracts a table of the currentization management target and a column constituting the table according to a user input. At this time, the selection of the current management target is based on the negative word and the classification word input by the user. That is, the current object extraction module 110 receives a negative word and a classification word from the user, and searches for and extracts the table and the columns constituting the table as the current object management target, including the classification word but not including the negative word.

2A is an example of an interface screen of the current object extraction module 110. In the embodiment of FIG. 2A, the current object is a column constituting a table. First, a user inputs a predetermined word in the negative input window 210a to select a column to be excluded from the current management object, and selects a category word selection window 230a to select a column to be included in the current management object. Select the appropriate classification word from. The currentization target extraction module 110 first selects a column including the classification word selected by the user in the classification word selection window 230a as the currentization management target, and then includes the word input in the negative input window 210a. Exclude columns from current management. Of course, when the user inputs only one of the negative input window 210a and the classification word selection window 230a, the current management target may be selected according to the corresponding negative word or the classification word.

More specifically, in FIG. 2A, the user selects a code 231a, whether or not 233a, and a type 235a as the classification word in the classification word selection window 230a, and displays the ID, DATE, Enter SEQ, CTN, SSN '. Then, the current object extraction module 110 includes a column including 'code' corresponding to the code 231a as the column name among the columns of the tables, and a column including 'IDD' corresponding to the column 233a as the column name. Then, the column including 'type' corresponding to the type 235a as the column name is selected as the current column. In this case, a column of a table having at least one of 'ID', 'DATE', 'SEQ', 'CTN', and 'SSN', which are words entered in the negative input window 210a, is present. Exclude from management. That is, the column corresponding to the classification term is selected as the target of the currentization management, but the column having the negative word as part of the column name is excluded from the current management. In the classification words of FIG. 2a, the number means' NO 'and' NUM ', the rate means' RATE', the ID means' ID ', the classification means' DIS', and the serial number is' SEQ ', and the date means' DATE'.

In the result list of FIG. 2A, columns not marked on the check box are currently managed, and columns marked separately on the check box are excluded from the current management. That is, the column corresponding to the reference numeral 270a includes the negative word 'SSN' and thus is excluded from the current management. Meanwhile, in FIG. 2A, assuming that at least one column to be currentized exists in all tables, only the columns to be sorted by the negative word and the taxonomy are limited to the columns, and the table is separately selected by the user's manual operation. In addition, it is obvious that a table can be excluded from the current object by a negative word and a classification word as above. As such, the list of tables and columns selected for the current management target is stored in the current target DB 180 according to a user's input of the storage command 290a.

Next, the schedule registration module 120 receives schedule information on the current management target table and columns from the user and stores the schedule information in the current target DB 180. When a time corresponding to the schedule information stored in the currentization target DB 180 arrives, the schedule registration module 120 implements the data valid value collection module 130 and the column definition generation module 140. Request the currentization of the current target table and columns stored in the target DB (180). Alternatively, if the schedule registration module 120 receives a command for immediately performing the currentization from the user, the schedule registration module 120 may request the currentization for the current target table and column stored in the current target DB 180.

2B is an example of an interface screen of the schedule registration module 120. The user inputs and registers a time to perform the currentization on the table extracted by the currentization target extraction module 110. That is, the user selects the schedule registration (210b) menu, and inputs the time of the first currentization and the currentization execution period of the table extracted by the currentization target extraction module 110. In FIG. 2B, October 31, 2006 is set as the first scheduled execution date, and one of quarter, half year, and year is selected and entered as a subsequent execution cycle.

In addition, the user may query preset current execution schedule information. In FIG. 2B, the user inputs a date to be searched in the registration date input window 270b. Then, the schedule registration module 120 inquires the currentization target table having the working day of the same date as the input date in the currentization target DB 180 and then displays the schedule information of the inquired table. In this case, the work day is a work day from which the table is extracted by the current object extraction module 110. In addition, the user can enter the schedule information and immediately request the currentization. In FIG. 2B, when the user selects the immediate collection 230b menu, the schedule registration module 120 requests immediate currentization for the currently displayed current target table.

Meanwhile, when the schedule registration module 120 arrives at a time corresponding to the schedule information stored in the currentization target DB 180, the schedule registration module 120 may request an update of the currentization target table and column to the currentization target extraction module 110. . Then, the currentization target extraction module 110 selects the currentization target column newly added to the existing currentization target table, collects data valid values included in the newly selected currentization target column, and displays the current value. Stored in the target DB (180). In addition, the data valid value (valid value) newly added to the existing column to be currentized is collected and stored in the currentized object DB (180).

Next, the data valid value collection module 130, according to the schedule registration module 120, the data valid value (valid) for each column of the current table to be stored in the current target database (180) value). For example, when data is stored in the order of 1, 3, 1, 2, 3, 1, etc. in any current column, one of 1, 2, 3 is stored in each column of the current column. Data is selected and stored, and data valid values are 1, 2, and 3.

Meanwhile, the column definition generation module 140 searches the semantic dictionary DB 170 for the meaning of the valid values of each column collected by the data valid value collection module 130, and defines the meaning definition for the valid values of each column. Create In the above-described example, when 1, 2, and 3 are collected as data valid values of one column, the column definition generation module 140 means what each of the valid values 1, 2, and 3 has meaning. Dictionary DB 170 ) And generate a valid value definition by matching the retrieved meaning against each valid value. The valid value definition of each column generated in this way is stored in the semantic definition DB 190. At this time, the semantic dictionary 170 preferably updates its dictionary information periodically.

Next, the semantic inquiry module 150 searches for and displays the valid values of the corresponding columns and the meanings of the valid values in the semantic definition DB 190 for the columns of the table selected by the user. 2C illustrates an example of an interface screen of the semantic inquiry module 150. The user selects a desired table from the table list 210c. In FIG. 2C, the user selects the 'SUBSCRIBER' table. Then, the user selects a desired column from among the plurality of columns constituting the 'SUBSCRIBER' table. In Figure 2c the user selected the 'SUB-STATUS' column. Then, the semantic inquiry module 150 searches for and displays the valid value definition for the 'SUB-STATUS' column selected by the user in the semantic definition DB 190. In FIG. 2C, the valid value definition 250c of the 'SUB-STATUS' column includes 'CAN', 'NAC', and 'SUS' as valid values of the corresponding column, and in the meaning of each valid value, contract termination, first Includes opening, suspension of use. That is, each column of the 'SUB-STATUS' column stores any one of 'CAN', 'NAC' and 'SUS', 'CAN' is terminated, 'NAC' is first opened, and 'SUS' is suspended. It implies the meaning of.

Meanwhile, the semantic inquiry module 150 may include a sub function module for registering a new valid value. In FIG. 2C, the meaning inquiry module 150 displays a valid value definition window and adds a button 270c for registering a valid value at the bottom. When the user selects the corresponding button 270c, the semantic inquiry module 150 provides an interface for adding and storing a valid value and a meaning of the valid value in the corresponding column. As shown in FIG. 2C, in the screen provided after pressing the button 270c for registering the valid value, the user inputs a valid value to be newly registered in the valid value input window 271c and enters the meaning input window 273c. The meaning of the input valid value is input. A save button 275c is then selected to save the newly updated valid value definition.

3 is a flowchart illustrating a data effective value actualization management method according to an embodiment of the present invention.

As shown in FIG. 3, the currentization management apparatus first receives a negative word and a classification word for selecting a column of the currentization management object from the user (S301).

The current management apparatus searches for a column in the table DB 150 having the received classification word as part of the column name (S303), and then selects a column having the received negative word as part of the column name among the searched columns. Excluding the current column management target column is selected (S305). In this case, the steps S303 and S305 may be reversed.

More specifically, it will be described with reference to the embodiment of Figure 2a as follows. In FIG. 2A, the user selects a code 231a, whether or not 233a and a type 235a as a classification word in the classification word selection window 230a, and selects 'ID, DATE, SEQ, CTN' in the negative input window 210a. , Enter SSN '. Then, the current management apparatus includes a column including 'code' corresponding to code 231a as part of the column name among columns of tables stored in table DB 150, and 'IDD' corresponding to whether or not 233a as part of the column name. Select a column to include the column to include (for example, the data value of the column is yes, no, or 1, 0, etc.), and the 'type' corresponding to the type 235a as the column name. . In this case, a column of a table having at least one of 'ID', 'DATE', 'SEQ', 'CTN', and 'SSN', which are words entered in the negative input window 210a, is present. Exclude from management. That is, the column corresponding to the classification term is selected as the target of the currentization management, but the column having the negative word as part of the column name is excluded from the current management.

Next, the current management apparatus collects a data valid value for each column of the current management target table selected in step S303 (S307). For example, when data is stored in the order of 1, 3, 1, 2, 3, 1, etc. in any current column, one of 1, 2, 3 is stored in each column of the current column. Data is selected and stored, and data valid values are 1, 2, and 3.

Next, the current management apparatus searches the semantic dictionary 160 for the meaning of the collected data valid values for each column (S309), and for each of the collected columns using the retrieved meanings. A semantic definition of the data valid value is generated (S311). In the above example, when 1, 2, and 3 are collected as data valid values of one column, the current management apparatus searches in the dictionary DB 170 what meanings of each valid value 1, 2, and 3 have meanings. Then, the retrieved meaning is matched for each valid value to generate a valid value definition. The valid value definition of each column generated in this way is stored in the semantic definition DB 190.

Meanwhile, in the present embodiment, the process of steps S307 to S311 is described as being performed immediately after the step S305, that is, the column to be managed currently, is selected. However, according to the embodiment, the step is performed at the reservation time set by the user. The process of S307 to S311 may be performed. After the column of the currentization management object is selected, the user sets a currentization execution reservation time for the selected columns. When the reservation time arrives, the current management apparatus generates the valid value definition of each column by performing the processes of steps S307 to S311.

As described above, when a column of data to be selected is selected and a data valid value definition of each column is generated and stored, when the user requests a valid value definition for a specific column, the current management apparatus DB (190) A valid value definition requested by the user is searched for in the valid value definition for each column stored in the step S) and provided to the user (S313).

More specifically, referring to the embodiment of Figure 2c as follows. The user selects the desired table from the table list 210c. In FIG. 2C, the user selects the 'SUBSCRIBER' table. Thereafter, the user selects a desired column among a plurality of columns belonging to the 'SUBSCRIBER' table. In Figure 2c the user selected the 'SUB-STATUS' column. Then, the current management device searches for and displays the valid value definition for the 'SUB-STATUS' column selected by the user in the semantic definition DB 190. In FIG. 2C, the valid value definition 250c of the 'SUB-STATUS' column includes 'CAN', 'NAC', and 'SUS' as valid values of the corresponding column, and in the meaning of each valid value, contract termination, first Includes opening, suspension of use. That is, each column of the 'SUB-STATUS' column stores any one of 'CAN', 'NAC' and 'SUS', 'CAN' is terminated, 'NAC' is first opened, and 'SUS' is suspended. It implies the meaning of.

On the other hand, according to the embodiment, the current management apparatus can record and store the new valid value and the meaning of the valid value in accordance with the user's input in the inquiry of the valid value definition document. More specifically, referring to the embodiment of Figure 2c as follows. In FIG. 2C, the current management apparatus displays a valid value definition window and adds a button 270c for registering a valid value at the bottom. When the user selects the corresponding button 270c, the current management apparatus provides an interface for adding and storing a valid value and a meaning of the valid value in the corresponding column. As shown in FIG. 2C, in the screen provided after pressing the button 270c for registering the valid value, the user inputs a valid value to be newly registered in the valid value input window 271c and enters the meaning input window 273c. The meaning of the input valid value is input. When the user selects the save button 275c, the current management apparatus stores the newly updated valid value definition document in the semantic definition DB 180.

As described above, the method of the present invention may be implemented as a program and stored in a recording medium (CD-ROM, RAM, ROM, floppy disk, hard disk, magneto-optical disk, etc.) in a computer-readable form. Since this process can be easily implemented by those skilled in the art will not be described in more detail.

The present invention described above is capable of various substitutions, modifications, and changes without departing from the technical spirit of the present invention for those skilled in the art to which the present invention pertains. It is not limited by the drawings.

As described above, the present invention has the effect of reducing development obstacles and improving data reliability and accuracy by clarifying the effective values of the columns of the data table. In addition, providing a single view of data from various sources has the effect of improving the accuracy and speed of decision making. Furthermore, there is an effect that can increase the usability of the information by sharing the information of the data valid value with other systems.

Claims (10)

As a current management device for managing the currentization of the data table, Currentization subject extraction means for extracting a column including the classification word as part of the column name based on the classification word and the negative word input by the user, and the negative word not being included as part of the column name; Data valid value collecting means for collecting a data valid value for each column extracted by the current object extraction means; And A column definition generating means for retrieving the meanings of the data valid values of each column collected by the data valid value collecting means from a semantic dictionary database and generating a semantic definition of the data valid values of each column; . The method of claim 1, And scheduling means for scheduling the execution of the currentization according to the current execution date and the execution period inputted by the user. The method according to claim 1 or 2, A semantic definition database for storing the semantic definition generated by the column definition generating means; And And a semantic definition inquiry means for searching for and displaying a semantic definition for the column in the semantic definition database. The method of claim 3, wherein The classification word, Current management device comprising at least one of a code, number, rate, ID, serial number, date. The method of claim 3, wherein The meaning definition query means, And a data valid value input by the user and a meaning of the valid value are added to and stored in the semantic definition document retrieved from the semantic definition database. As the current management method for managing the currentization of the data table, (a) receiving a classification word and a negative word from a user; (b) extracting a column including the classification term as part of the column name but not including the negative term as part of the column name; (c) collecting data valid values for each of the extracted columns; (d) retrieving a meaning of data valid values of each collected column from a semantic dictionary database; And (e) mapping the retrieved meanings to data valid values of each column to generate a meaning definition for each column. The method of claim 6, Before step (c) above, Receiving an input date of the currentization from the user; further comprising, Step (c) to (e) is the current management method, characterized in that is performed at the arrival of the date of the currentization. The method according to claim 6 or 7, (f) retrieving and displaying a semantic definition of one of the column-specific semantic definitions generated in step (e). The method of claim 8, The classification word, Current management method comprising at least one of a code, number, rate, ID, serial number, date. The method of claim 8, (h) receiving a data valid value to be input in addition to the semantic definition searched in step (f) and a meaning of the valid value from a user and storing the data valid value in the searched semantic definition; How to manage.

Images