KR20100054328A - Method for data input processing to database table - Google Patents

Abstract

PURPOSE: A database data processing method storing data of source file to data base table is provided to effectively and accurately process the process data which is included in a source file written by using commercial program to be inputted in the database table. CONSTITUTION: A database management tool of a computer outputs a manager interface screen on a monitor, thereby enabling an administrator to appoint a source file and a database server(S23). The database management tool inspects an data error of the source file(S24). If the error is found, the database management tool outputs error contents on a monitor by a fixed form(S26). If the error is not found, the database management tool stores data in the source file in a table of the specific data base server according to a corresponding form(S27).

Description

Method for Data Input Processing to Database Table}

The present invention relates to a method for processing database data, and more particularly, to efficiently input data of a separately created source file through a commercial spreadsheet program or the like into a database table.

Various database related technologies are widely used to help manage a lot of information at a glance.

In order for the various devices or systems using the database to operate normally, the integrity of the information stored in the database must be assumed. If there is an error in the information in the database, it can have fatal consequences.

As an example of an online game service, data about non-player characters (NPCs), items, game objects, etc. plays a very important role in the game, and this data must be entered and managed from as few as tens to tens of thousands. .

If there is an error in this data, it can cause problems such as a broken game balance and a bug, which can be a huge loss for the game company as it is an important factor for users to be reluctant to use the game. In fact, many game companies are suffering from data entry errors, and the losses can be serious enough to ruin the company.

From another perspective, storing and maintaining large amounts of data in a database can be time-consuming and expensive. The greater the amount of data, the more time-consuming the task.

Database administrators use Microsoft's Excel program to create source data that will be stored in the database once, and then use the database commands to save the contents of the file. However, finding errors in the data in the source file is not easy, and errors are unlikely to occur in the process of moving and storing the data.

Once the error data is stored in the database, it will take a long time to detect the error because it can be seen through the field test and the problem occurs, and the process of finding and correcting the error occurrence part becomes more difficult.

Therefore, in order to operate the database effectively, it is necessary to make inputting necessary information into the database more accurately and quickly.

Accordingly, an object of the present invention is to provide a method for processing a database data, which enables the process of inputting data contained in a source file into a database table to be made accurately and efficiently.

In order to achieve the above object, in the database data processing method according to the present invention, a database management tool installed on a computer device and driven to output an administrator interface screen to a monitor so that an administrator can designate a source file and a specific database server. (The source file is a file consisting of one or more fields and one or more data is input corresponding to each field); Checking, by the database management tool, the data of the source file to see if there is an error; Outputting, by the database management tool, the error content to a monitor according to a predetermined format when the inspection result is an error; And if there is no error as a result of the check, the database management tool storing the data contained in the source file in a table of a specific database server designated by the administrator according to a corresponding format.

The name of the table may be directly input by an administrator or configured to be processed as the name of the source file.

In this case, the database management tool may be configured to create a new table when a table having a corresponding name does not exist in a specific database server designated by an administrator.

The manager interface screen may be configured by a manager inputting a path and name of a source file directly through a keyboard, or by selecting a desired source file by searching a file stored in each storage medium.

The administrator interface screen may display a list of one or more database servers, and the administrator may be configured to select a specific database server among them.

The administrator interface screen may be configured to allow the administrator to select a 'table update mode' for deleting the contents of a table already existing in a specific database server and updating the data in the source file.

When the administrator selects the table update mode, the database management tool deletes the contents of the corresponding table existing in the specific database server and updates the data in the source file.

When the administrator selects the table update mode, the database management tool checks whether the format of the source file matches the format of the corresponding table in the step of checking whether there is an error.

In each of the above embodiments, a file having a comma separated values (CSV) format may be used as the source file.

According to the present invention, if the administrator designates the source file and the database server according to the administrator interface displayed on the screen, the data input process can be easily and quickly performed because the data of the source file is automatically transferred to the corresponding database table.

In addition, it is possible to prevent the mis-input situation that can occur in the process of entering data into the database, it is possible to maintain a stable database.

In particular, the error check for the data of the source file is output and the details can be printed quickly, and error checking and action on the source data can be performed quickly, and the time and cost associated with error checking can be greatly reduced.

The administrator can conveniently perform data entry through an intuitive interface screen and manage data entry for multiple database servers in a batch.

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

Referring to Fig. 1, a database management tool 12 is installed on a computer 11 of an administrator who manages a database. The database management tool 12 is constituted by a computer program installed and operated on the manager computer 11.

The database management tool 12 maintains communication information for communicating with one or more database servers 13, and an administrator can access each database server 13 by operating the database management tool 12. .

Referring to Figure 2, an embodiment of a database data processing method according to the present invention will be described in detail.

When the administrator drives the database management tool 12 (S21), the database management tool 12 outputs an administrator interface screen to the monitor (S22). The form and function of the administrator interface screen may be variously configured as necessary.

The administrator designates a source file and a database server through an administrator interface screen (S23).

Here, the source file is a file containing data to be stored in a database table, and in particular, is composed of one or more fields and has a format in which one or more data are input corresponding to each field.

Tables managed through the database server 13 generally have one or more fields, and since each field is defined by name, type of data, and range of data, the source file must also be created in such a format.

The source file can be created using a commercial program such as Microsoft's Excel program.

The source file can be created as a CSV (Comma Separated Values) file. In this case, the source file creator can create a source file using an Excel program and save it as a file with the extension '.csv'.

3 shows an example of a source file created using an Excel program.

The source file consists of three fields, the first row is the description of each field, the second row is the name of each field, the third row is the type of data that will fit in that field, and the fourth row is the range of data. .

Here, 'N' as a data type is an integer (Number), 'R' is a real number, 'S' is a string, and 'P' is a primary key.

That is, the first field is named 'ID' and has a type of 'NP', and the data range is '0 to 100,000'. The second field is named 'STATE' and has a type of 'N'. The range of data is '0 ~ 3'. The third field is named 'NAME' and has a type of 'S'. The range of data is '50'. From the fifth row, actual data of each field is input.

In operation S23, the administrator interface screen may be configured to directly specify a path and name of a source file through a keyboard, or may be configured to allow an administrator to select a source file by searching a storage medium and a path.

In addition, in step S23, the manager interface screen may be configured to display a list of database servers 13 accessible by the database management tool 12 and to select a database server from which the administrator wishes to access.

Now, the database management tool 12 reads the data of the source file according to the administrator's command and checks whether there is an error (S24).

It goes without saying that the type and content of the error checked in step S24 can be set in various ways as necessary. For example, it checks for any errors, such as whether the data entered in each field of the source file fits the type or range of the field, or whether unacceptable blanks or special characters are used.

Let's look at an example of the content of the error.

The description of each field, name, type of data, range of data, etc., may include the condition that it should not be larger than a certain size, and the condition that blank or special characters should not be used.

For integers of data types, 'tinyint' should generally have values of 0 to 255, 'short' to -32768 to 32767, 'long' to -2147483647 to 2147483647, and 'bigint' to -9223372036854775808 to 9223372036854775807.

Thus, for each integer or real type, data outside that range can be treated as error data.

In addition, data of a string type may be treated as error data when the number of characters is not within a range of a prescribed value, or when characters which are not allowed such as special characters or blanks are included.

Referring to FIG. 4, an example of a process of performing step S24 is described. First, a variable i representing a field (column) and a variable j representing a row are initialized (S24-1).

Then, the j-th line of the i-th field is read from the source file (S24-2), and it is checked whether an error exists (S24-3). If an error exists as a result of the check in step S24-3, the error content is stored (S24-4, S24-5).

If there are still rows to be checked in the i-th field (S24-6), increase the variable j by 1 and proceed to step S24-2 (S24-7). It is determined whether the inspection is completed (S24-8).

If there are still fields to be checked, the variable i is increased by 1 and the flow proceeds to step S24-2 (S24-9), and if all fields have been checked, the error checking process is finished.

4 merely illustrates an example of an error checking process, and the error checking process may be variously configured as necessary. As an example, you might perform error checking by reading each field in the order of the rows.

If there is an error as a result of the check in step S24 (S25), the error content is output on the screen according to a predetermined format and processed so that an administrator can know (S26). The administrator then knows which part of the source file contains the error and can immediately correct the error.

However, if there is no error as a result of the check in step S24, the database management tool 12 stores the data contained in the source file in a table of the database server designated by the administrator (S27).

If the source file is a CSV format file, the database management tool 12 reads each row with a comma (,) of the source file as a separator in step S27 to generate a record by inserting each row as a value of each field of the corresponding table. .

In this case, the database management tool 12 may insert data into a table using ODBC (Open Database Connectivity). ODBC is one of Microsoft's standard application programming interfaces (APIs) that allows Windows applications to openly access many kinds of data without having to know the structure or form of the data source. Therefore, administrators can more easily access various kinds of databases.

On the other hand, the name of the table to store the data of the source file may be configured by the administrator to directly input by using a keyboard, or the name of the source file may be treated as the table name as it is.

Further, in step S27, the database management tool 12 creates a new table when the table of the corresponding name does not exist in the database server.

In this way, you can create a new table on the database server specified by the administrator and save the data in the source file in the table. However, you may want to update the contents of the table already created on the database server.

To this end, the manager interface screen may be configured to allow the administrator to select a 'table update mode'.

In this case, when the administrator selects the table update mode in the administrator interface screen, the database management tool 12 deletes only the contents of the existing table and updates the data of the source file, instead of creating a new table in the database server. .

When the administrator selects the table update mode, the database management tool 12 also checks whether the format of the source file matches the format of the corresponding table in the error checking process (S24) of the source file.

5 shows an example of the manager interface screen 50.

The 'Input Method' item allows the administrator to select whether to create a new table and save the data of the source file or to update only the contents of an existing table.

When creating an initial table or dropping an existing table and creating a new one, the administrator selects the 'Create New Table' item (51) and selects 'Delete Previous' when updating only the existing table. Select the Data and Create New Table 'item (52).

In the latter case, the error check also checks whether the format of the source file matches the format of the table on the database server.

The Browse button 53 is an item that allows an administrator to search for and find a source file (eg, a file with a csv extension).

The 'Server' item 54 shows the administrator a list of each database server and allows the administrator to select a specific database server.

The 'Apply to DB Server' button 55 is used to instruct the administrator to specify the source file and the database server and to store the data of the source file in the corresponding table.

Referring to FIG. 6, an example of a process in which the database management tool 12 stores data of a source file in a corresponding table according to an administrator's command will be described.

First, when the administrator selects the 'Create New Table' item 51, the database management tool 12 processes to create the table with the database server (S61-1), and the administrator deletes the 'Delete Previous Data and If the item 52 of 'Create New Table' is selected, the contents of the corresponding table are deleted (S61-2).

Now the variable i to display the position of the row is initialized (S62).

The database management tool 12 reads the i th row from the source file (S63), and processes the data corresponding to each field of the row with the database server in each field of the i th row of the table. (S64).

If there are still rows to be processed in the source file, the database management tool 12 increments the variable i by 1 and proceeds to step S62 to read data of the next row (S66).

However, when the processing for all the rows of the source file is completed, the data storage operation ends (S65).

7, the structure and overall operation of the database management tool 12 will be described.

The input module 12-1 outputs an administrator interface screen 50 to the monitor as shown in the example shown in FIG. 5 so that an administrator can select a table creation mode or a table update mode and specify a source file and a database server. .

The error checking module 12-2 reads the data of the currently designated source file 16 in order through the same procedure as the example described with reference to FIG. 4 and checks whether an error exists.

The error output module 12-3 displays error information detected by the error checking module 12-2 on a screen according to a predetermined format so that an administrator can know.

If no error exists as a result of the check of the error checking module 12-2, the data storage module 12-4 communicates with the corresponding database server to create a table or delete the contents of an existing table, and then the source file. The data in (16) is read in order and stored in the table.

The above-described embodiments are intended to help the understanding of the present invention, and the present invention is not limited to the above-described embodiments and can be variously modified and implemented by those skilled in the art without departing from the spirit of the present invention. to be.

1 is an overview of a system for entering data into a database according to the present invention;

2 is an embodiment of a database data processing method according to the present invention;

3 is an example of a source file,

4 is an example of a process of checking an error of a source file,

5 is an example of an administrator interface screen;

6 is an example of a process of storing data of a source file in a database table;

7 is an example of a tool for database management.

DESCRIPTION OF THE REFERENCE NUMERALS

11: administrator computer 12: tools for database administration

13: Database Server 14: Tables

16: Source File 12-1: Input Module

12-2: Error Checking Module 12-3: Error Output Module

12-4: Data Storage Module

Claims (9)

A database management tool installed and driven on a computer device outputs an administrator interface screen to a monitor so that an administrator can specify a source file and a specific database server (the source file is composed of one or more fields and corresponds to each field. One or more files are inputted); Checking, by the database management tool, the data of the source file to see if there is an error; Outputting, by the database management tool, the error content to a monitor according to a predetermined format when the inspection result is an error; And And if there is no error as a result of the checking, the database management tool storing the data contained in the source file in a table of a specific database server designated by the administrator according to a corresponding format. The method of claim 1, And the name of the table is directly input by an administrator or configured to be processed as a name of the source file. The method of claim 2, And the database management tool is configured to create a new table when a table having a corresponding name does not exist in a specific database server designated by an administrator. The method of claim 1, The administrator interface screen is configured to allow the administrator to directly input the path and name of the source file through a keyboard, or to specify a desired source file by searching for a file stored in each storage medium. How the data is processed. The method of claim 1, The manager interface screen displays a list of one or more database servers, and the administrator is configured to select a specific database server among them. The method of claim 1, And the manager interface screen is configured to allow a manager to select a table update mode for deleting the contents of a table already existing in the database server and updating the data with the data contained in the source file. The method of claim 6, And the database management tool is configured to delete the contents of a corresponding table existing in a specific database server and update the data in the source file when the administrator selects the table update mode. The method of claim 6, The database management tool is configured to check whether or not the format of the source file and the format of the corresponding table in the step of checking whether there is an error when the administrator selects the table update mode. How database data is processed. The method according to any one of claims 1 to 8, The source file is a database data processing method, characterized in that consisting of a file of CSV (Comma Separated Values) format.

Images