KR20080078392A - Method and apparatus for managing database by using monitoring function - Google Patents

Abstract

A method and a device for managing a database by using a monitoring function are provided to enable users to manage the database flexibly by searching and managing a plurality of databases effectively with a database management function for collecting and managing predetermined data from all databases. A collector(510) collects data received from a mirroring port of a switch connected to a plurality of database servers. A filter(520) filters the collected data by determining whether the collected data is included in a predetermined collection range and contents of the collected data are included in the collection range. A schema manager(530) requests a schema of the database server and maps the collected data to the received schema. An indexer(540) classifies the collected data according to the schema by analyzing the filtered data. A statistic processor(550) calculates statistics for the data classified/stored by the indexer. A translator(560) translates a predetermined part of original data into a predetermined language. The filter performs filtering by using IP(Internet Protocol) information of the database servers. The schema includes at least one of a database server name, the IP address, a database server type, a table name, and a column name.

Description

Database management method using monitoring function and its device {METHOD AND APPARATUS FOR MANAGING DATABASE BY USING MONITORING FUNCTION}

1 schematically illustrates a database management system according to an embodiment of the present invention.

2 is a schematic block diagram of a DB management apparatus according to an embodiment of the present invention.

3 and 4 are flowcharts illustrating a database management method using a monitoring function according to an embodiment of the present invention.

5 illustrates a schema structure of a database server according to an embodiment of the present invention.

6 illustrates an example of automatic conversion of customer information according to an embodiment of the present invention.

7 and 8 illustrate screens of a database management device for explaining a search method according to an embodiment of the present invention.

9 illustrates a messenger implemented in a database management device according to an embodiment of the present invention.

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

110, 130, 210, 230: DB server

150, 250: collection server

270: lower DB management device

300: Switch

350: mirroring port

500: DB management device

The present invention relates to a database management system, and more particularly, to a database management method and a server using a monitoring function for providing a function of collecting and managing specific data from all databases in a DB collection server connected to a plurality of databases. will be.

In general, the limitation of the processing speed of the CPU, the limitation of the hard disk capacity, the limitation of the bus speed, which serves as a path for exchanging information between the central processing unit and the hard disk, to build a database system. Consider the limitations of the same computer hardware. Therefore, in the related art, since a large-capacity database system that overcomes such hardware limitations cannot be constructed, a database that performs the same function is configured in a local unit, that is, in a distributed system form.

With the recent advances in hardware, these limitations have been overcome, leading to projects around the world for building a single large database system. Large database systems are backed up by switches from multiple database servers and managed by a single database management device.

However, because the information that is backed up and stored in the database server is stored sequentially, even if a specific table of the database server contains customer information, it is difficult for an administrator to check which table contains the customer information and what the customer information contains. There has been a problem. In addition, the schema for managing customer information is slightly different for each DB server. Therefore, the administrator who manages data centrally has a specific column registered in the filtering window, but it is difficult to understand what the column name means. Therefore, there has been a problem that it is difficult to manage the database unless the operator is in charge.

In addition, in the conventional database management system, there has been a problem in that there is no method of notifying the lower database manager, that is, another operator of the guidance in real time about the DB management, in case of an accident or the operator cannot cope quickly when an emergency occurs.

The present invention was created in view of the above circumstances, and an object of the present invention is to provide a plurality of databases by providing a function of collecting and managing specific data from all databases in a database server or a collection server connected to a plurality of databases. The present invention provides a method and apparatus for managing a database using a monitoring function that enables users to manage a database flexibly by searching and managing effectively.

Another object of the present invention is to provide a method and apparatus for managing a database using a monitoring function for easily modifying and immediately applying a policy for database management such as a data collection target range and a collection target data range in a DB management apparatus. .

Still another object of the present invention is to provide a quick solution when a query or a problem occurs by implementing an agent or a messenger function between a DB management device, a lower DB management device, and a data collection target between a DB server or a collection server and an administrator terminal. The present invention provides a method and apparatus for managing a database using a monitoring function for presenting and applying the same.

Database management method using a monitoring function according to a first aspect of the present invention for achieving the above object,

A) collecting data of the DB server included in a predetermined collection target range according to a filtering policy among data transmitted from a mirroring port of a switch connected to a plurality of DB servers;

B) filtering and analyzing the data according to the filtering policy;

C) indexing the analyzed data and storing it together with the original data; And

D) performing statistical operations on the data based on the indexed data.

Database management method using a monitoring function according to a second aspect of the present invention for achieving the above object,

Iii) collecting data transmitted from a mirroring port of a switch connected to a plurality of database servers;

Ii) analyzing the data to determine whether a DB server corresponding to the data is included in a preset collection target range according to a filtering policy;

Iii) transmitting a predetermined guide message to an administrator terminal when the DB server is not included in the collection target range;

Iii) filtering and analyzing data belonging to the collection target range of the data when the DB server is included in the collection target range according to the change of the filtering policy; And

Iii) indexing the analyzed data and storing it together with the original data.

Database management apparatus using a monitoring function according to a third aspect of the present invention for achieving the above object,

A collector configured to collect data transmitted from a mirroring port of a switch connected to a plurality of DB servers;

A filtering unit for determining and filtering whether the data is data collected from the DB server included in a preset collection target range, and whether the data included in the data belongs to the collection target range;

Schema management unit for requesting the schema of the DB server from the DB server and mapping to a predetermined schema (Schema);

An indexing unit analyzing the data received from the filtering unit and classifying the data according to the predetermined schema; And

And a statistics unit for calculating statistics on the data classified and stored through the indexing unit.

Hereinafter, with reference to the accompanying drawings will be described a preferred embodiment of the present invention.

1 schematically illustrates a database management system according to an embodiment of the present invention.

Referring to FIG. 1, a database management system using a monitoring function is referred to as a plurality of database servers 110, 130, 210, and 230 (DB servers), and data of the DB servers 110, 130, 210, and 230. A switch 300 connected to at least one of a collection server 150 and 250 collecting the data, a lower DB management device 270 managing the at least one collection server 250, a DB server, a collection server, and a lower DB management device. ), A mirroring port 350 that backs up and collects data of all servers connected to the switch 300, and a DB management device 500 that collects data from the mirroring port 350 and performs monitoring. It is configured to include.

In an application example, the DB servers 110 and 130 may be directly connected to the switch 300. When a plurality of DB servers are provided, the collection server 150 and 250 collects data of each DB and then switches Send to 300.

The switch 300 includes a plurality of ports and backs up data from at least one of a DB server, a collection server 150 and 250, and a lower DB management server 270 connected to the port 330. Transmission to the mirroring port 350 provided in (300).

In one application, a sub-switch (not shown) is connected to a port of the switch 300, and the lower switch can be connected to at least one of a DB server, a collection server, and a lower DB management device. Do.

An agent or instant messenger function is provided in the DB server, the collection server 150, 250, and the lower DB management device 270, or the DB server, the collection server 150, and the lower DB management device ( Agent or messenger function is provided in the manager terminal connected to the processor 270, and a warning message is generated in real time through a messenger installed in the DB management apparatus 500 when a suspicious query occurs related to important data such as customer information. Send and receive, and send and receive a report for the query.

In addition, it is possible to mutually communicate a warning function of the system environment and the current state through a messenger installed in each of the DB server, the collection server 150, 250, or the lower DB management device 270 and the DB management device 500.

In one embodiment, the DB management device 500 grants access rights after a predetermined authentication process to a user of the DB server, collection server, or lower DB management device connected to the general user rights through the agent or messenger It is possible to implement to allow access to the DB management device 500. It is also possible to give the user who is connected with the general user authority not only the access authority but also the authority to manage the DB server. The DB management device 500 can immediately change the set policy, and notify the DB server, collection server, or lower DB management device connected to the switch 300 through the agent or messenger of the changed policy and notify the policy. It is possible to do it right away.

In one application example, the DB management apparatus 500 generates a report including statistical information such as a report recording information of a user connected with general user authority through the agent or a messenger or a connection rate over time, and designated a manager terminal. To send.

Referring to FIG. 2, the DB management apparatus 500 includes a collecting unit 510, a filtering unit 520, a schema managing unit 530, an indexing unit 540, a statistics unit 550, a translation unit 560, and a message. It includes a generator 570, and a messenger 580.

The collection unit 510 is directly connected to the mirroring port 350 of the switch 300 to collect data of the DB server, the collection server, or the lower DB management device 270 through the mirroring port 350.

The collection unit 510 may log the DB server having a preset IP according to a policy of an administrator who manages the DB management apparatus 500 and collect only data of the DB server. At this time, the data of the DB server other than the preset IP is filtered using a 'disposal in a trash basket' function and the like, and is not managed by the DB management apparatus 500.

In one application example, when the collector 510 receives data from a DB server of an IP not preset according to the administrator's policy through the mirroring port 350, the collector 510 guides the data. Request to the message generator 570 to generate a message, the message generator 570 to the mobile terminal 700 and / or wired terminal 800, which is an administrator terminal through a wired network and / or mobile communication network 600 Send the guide message.

The filtering unit 520 performs a function of filtering data to be managed by the DB management apparatus 500 among data collected by the collecting unit 510. The filtering unit 520 determines whether the data is included in a preset target range. To judge. The target range is a blocking target range for blocking the data or a target range for including the data in a collection target.

In one application example, the filtering unit 520 may perform not only the above-described data filtering function but also a function of determining whether the DB server is a server having an IP conforming to a policy.

The data filtered by the filtering unit 520 is transmitted to the indexing unit 540 and stored by adding a footer to the data, or extracting specific information from the data and storing it together with the original data. The footer simply displays numbers, symbols, etc. as summary information corresponding to the data. For example, the name is mapped to "1", the address is "2", and the telephone number is "3". When the data includes all of the name, address, and telephone number, "123" is the footer of the data. Is added.

When the indexing unit 540 extracts and stores specific information of data, the specific information is a predetermined item that is preset for indexing. The predetermined item is a schema defined by the schema manager 530 to be described later.

The schema manager 530 maps and manages schemas of all DB servers managed by the DB management apparatus 500 with the schema defined by the DB management apparatus 500. For example, each DB server manages customer information according to the needs of an administrator of the DB server. There are some differences in the format. Referring to FIG. 5, the e-Pay server 410 located in Boramae # 2 may use "Addr." As a customer address. Or the "AddExt" column, Boramae # 2's Moneta Card Web Server 430 uses customer addresses as columns such as "ADDRESS", "ADDR", "HOME_ADD", "HOME_ADDI", and the Moneta Card Server ( 450 may be used as a customer address such as "HOME_ADDI" and "HOME_ADDR2". Therefore, the DB management apparatus 500 collects the column for the customer address from the e-Pay server 410, Moneta card web server 430, and Moneta card server 450 to define a "customer address", the customer Map "Addr.", "AddExt", "ADDRESS", "ADDR", "HOME_ADD", "HOME_ADDI", and "HOME_ADDR2" to the address.

The schema managed by the schema manager 530 includes at least one of a DB server name, an IP address, a DB server type, a table name, and a column name. An example of the column name is a customer name, a phone number, a customer account. , Customer address, social security number, credit card number, password, and email address.

As illustrated in FIG. 6, the translator 560 stores the customer information of reference number 510, that is, "select * from pnbx_cust_point_hist where soc_sec_num = '720724xxxxxxx'", as shown by reference number 530, as shown in FIG. The keyword is translated, such as the master table of the total points of use where social security number = '720724xxxxxxx' ".

In one application, the translation unit 560 may select one of "select * from pnbx_cust_point_hist where soc_sec_num = '720724xxxxxxx'" by a user using a mouse for a specific phrase or symbol, such as "*", "pnbx_cust_point_hist", or "soc_sec_num". Select to translate the selected phrase or symbol. Alternatively, when the user mouses over a search condition such as a main column name or a table name among the customer information with the mouse, the user automatically translates and displays it.

The statistics unit 550 interoperates with the schema manager 530 and the indexer 540, and calculates and provides statistics based on the schema of the DB management apparatus 500 and the stored original data.

The statistics unit 550 provides a search tool to a screen of the DB management apparatus 500 or an administrator terminal, an example of which is illustrated in FIGS. 7 and 8, respectively. 7 limits the information to be searched. First, the location 610 of the DB server is selected, the DB server name 620 is selected, and then the IP address 630 is selected. Thereafter, the DB type 640, the table name 650, the customer information 660, and the main column 670 are sequentially selected. 8 shows the location of the DB server 610, DB server name 620, IP address 630, DB type 640, table name 650, customer information 660, the main column 670 to select An example is shown.

In addition, the statistics unit 550 performs a statistical operation on the data based on the indexed data to access an IP connected to the DB management apparatus or an IP of a client connected to a specific DB server. The frequency is calculated and the result is transmitted to the filtering unit 520. If the filtering policy for the IP is changed by determining the range of the access IP based on the calculated statistical data, the filtering unit 520 performs a task of adding the access permission IP.

The statistics unit 550 performs a statistical operation on a query based on the indexed data, analyzes the query having a frequency of occurrence or more among predetermined values, and performs customer analysis on the contents of the query. If the content does not exist, the result is transmitted to the filtering unit to be included in the blocking target range or the collection target range.

As a result of the determination by the filtering unit 520, the message generator 570 determines that the collected data is data collected from a DB server that is not included in a preset collection target range, or that the contents included in the data are collected. If not within the range, a guide message or a warning message is transmitted to the mobile terminal 700 and / or the wired terminal 800 which are the manager terminals.

In this case, when the messenger function is implemented between at least two of the DB management apparatus 500 and the DB server, the collection server, and the lower DB management apparatus connected through the DB management apparatus 500 and the switch 300, real-time, It is possible to send and receive the guide message or warning message. An example is shown in FIG. 9. Referring to FIG. 9, a total of 345 warning messages have been generated 810 in the "notification board". If the reference number 830 is selected by processing 340 warning messages, the details are displayed. In addition, five of the warning messages remain unprocessed (reference number 850) and 30 are classified for review (reference number 870).

The operating state of the present invention configured as described above will be described.

3 and 4 are flowcharts illustrating a database management method using a monitoring function according to an embodiment of the present invention.

Referring to FIG. 3, a first embodiment according to the present invention will be described.

At least one of a DB server, a collection server, a lower DB management device 270, and a lower switch (not shown) is connected to each of the plurality of ports 330, and the connected DB server, collection server, and lower DB management device 270 are connected to each other. And the DB management apparatus 500 collects the entire packet data through the mirroring port 350 that has received the data backed up from the lower switch (S210).

In this case, when the data passes through a network interface card (NIC), the DB management apparatus 500 applies an IP filtering policy to collect the data from the IP of the DB server included in the IP filtering policy. It is determined whether the data is (S220).

As a result of the determination in step S220, if the data is not the corresponding IP, the data is discarded in the crash basket (S230). However, as a result of the determination in step S220, in the case of data of the corresponding IP, it is determined whether the content of the data falls within the collection target range (S240).

When the content of the data does not belong to the collection target range or when the data is out of the defined format, the DB management apparatus 500 transmits a predetermined warning message to the administrator terminal so that the administrator can process the data. To perform (S250, S260). The DB management apparatus 500 transmits the warning message to the manager terminal through a wired or mobile communication network. In addition, when an agent or an instant messenger is installed in the collection servers 150 and 250 of the DB server 100 connected through the DB management apparatus 500 and the switch 300, the DB management apparatus ( 500 transmits and receives data with the DB server 100 in real time.

However, if the content of the data falls within the collection target range, the data is analyzed and indexing is performed (S270). The indexing operation may be performed by adding a footer to the data or storing predetermined items extracted from the data along with the original data according to a schema set by the DB management apparatus 500 (S280). Examples of the predetermined items include a DB server name, an IP address, a type of DB server, a table name, a column name, and the like. Here, the DB management device 500 requests and receives the schema used in the DB server from the DB server or lower DB management devices 150 and 250 connected to the switch 300, and the DB management device 500 ) Mapping to the schema applied in) to save management.

In addition, a translation function for the predetermined items is provided, and when the user selects one of the predetermined items among the original data or requests translation for the original data while the original data is displayed, the DB management is performed. The device 500 performs a translation according to the request and displays it on the screen (see FIG. 6).

In addition, when a statistical task is requested by the administrator, the statistical task is performed based on the indexed and stored data and the result is displayed on the screen (S290).

In addition, the DB management apparatus 500 performs a statistical operation on the data based on the indexed data to access an IP connected to the DB management apparatus 500 or a specific DB server. The client's IP is used to calculate the connection frequency. The DB management apparatus 500 determines the range of the access IP based on the calculated statistical data and adds the access permission IP to change the filtering policy for the IP.

In addition, the DB management apparatus 500 performs a statistical operation on the query (Query) based on the indexed data, and analyzes the query having the frequency of occurrence of the query more than a predetermined value to analyze the contents of the query. It is determined whether or not there is information related to customer information. Therefore, if there is no content related to the customer information as the result of the determination, the DB management apparatus 500 includes the content in the preset blocking target range so that the query is blocked.

In one application example, when more than two DB management devices 500 need to be operated as more data to be managed, one DB management device 500 does not log in to all of the DB management devices 500, respectively. By logging in, all programs and data of the two or more DB management apparatuses 500 may be accessed.

In addition, it is desirable to restrict the programs and data that can be accessed according to the grade by assigning the grade to the ID and password provided to the administrator.

Second Embodiment

4, a second embodiment according to the present invention will be described.

At least one of a DB server, a collection server 150 and 250, a lower DB management device 270, and a lower switch (not shown) is connected to each of the plurality of ports 330, and the connected DB server and lower DB management device are connected to each other. The DB management apparatus 500 collects the entire packet data through the mirroring port 350 backed up the data from the lower switch (270).

After the data passes through a network interface card (NIC), before analyzing the contents of the data, the DB management apparatus 500 applies an IP filtering policy to the DB in which the data is included in the collection target range. It is determined whether the data collected from the IP of the server (Site) (S320).

As a result of the determination in step S320, if the data is not the corresponding IP, the data is sent to the manager terminal without discarding the data in the crash basket (S322). This is when a new DB server is connected to the switch 300 but is not registered in the DB management apparatus 500 or when a new DB server to which the DB management apparatus 500 needs to back up data is connected to the administrator terminal. Send it. When the DB management apparatus 500 requests registration of the new DB server 100 from the administrator terminal, the DB management apparatus 500 registers the new DB server 100 (S324).

However, as a result of the determination in step S320, in the case of data of the corresponding IP, it is determined whether the content of the data falls within the collection target range (S340).

If the content of the data does not belong to the collection target range, or if the data is out of the defined format, the DB management device 500 transmits a predetermined warning message to the administrator terminal, the administrator processes the data. To perform (S350, S360). The DB management apparatus 500 transmits the warning message to the manager terminal through a wired or mobile communication network. In addition, when an agent or an instant messenger is installed in the collection server of the DB server connected to the DB management apparatus 500 and the switch 300, the DB management apparatus 500 is in real time with the DB server. Sends and receives data.

However, when the content of the data belongs to the collection target range, the data is analyzed and indexing is performed (S370). The indexing operation may be performed by adding a footer to the data or storing predetermined items extracted from the data along with the original data according to a schema set by the DB management apparatus 500 (S380). Examples of the predetermined items include a DB server name, an IP address, a type of DB server, a table name, a column name, and the like. Here, the DB management device 500 requests and receives a schema used in the DB server from a DB server or a lower DB management device 270 connected to the switch 300, and applies it in the DB management device 500. Save and manage by mapping (mappling) to the schema.

In addition, a translation function for the predetermined items is provided, and when the user selects one of the predetermined items among the original data or requests translation for the original data while the original data is displayed, the DB management is performed. The device 500 performs a translation according to the request and displays it on the screen (see FIG. 6).

In addition, when a statistical task is requested by the administrator, the statistical task is performed based on the indexed and stored data and the result is displayed on the screen (S390). Through the statistical operation, the access frequency of the IP connected to the DB management apparatus 500 or the IP of a client connected to a specific DB server is calculated, and the range of the access IP is determined based on the calculated statistical data. In addition, it is possible to perform the task of adding an access permission IP. That is, the IP filtering policy of step S320 may be changed by the statistical operation.

As described in detail above, according to the database management method and the server using the monitoring function of the present invention, the data is systematically stored and the retrieval method is improved, it is possible to search the desired information more quickly and conveniently. .

In addition, it provides convenience for monitoring the database by providing statistics on items desired by the administrator based on systematically stored data. It also provides the effect of smooth database management by modifying the filtering policy based on the statistical results.

If a problem occurs as a result of monitoring the data or monitoring the statistical results, the database management device and the messenger function attached to the database server that generated the data can send and receive reports in real time to solve the problem quickly. It also has the advantage of being able to respond quickly to questions and answers.

Although the present invention has been described in detail with reference to preferred embodiments, the present invention is not limited to the above-described embodiments, and the technical field to which the present invention belongs without departing from the gist of the present invention as claimed in the following claims. Anyone skilled in the art will have the technical idea of the present invention to the extent that various modifications or changes are possible.

Claims (30)

A) collecting data of the DB server included in a predetermined collection target range according to a filtering policy among data transmitted from a mirroring port of a switch connected to a plurality of DB servers; B) filtering and analyzing the data according to the filtering policy; C) indexing the analyzed data and storing it together with the original data; And D) performing a statistical operation on the data based on the indexed data. The method of claim 1, wherein the preset collection target range, Database management method using a monitoring function, characterized in that the IP information of the DB server to collect the data. The method of claim 2, wherein the method is By performing statistical operations on the data based on the indexed data, the connection frequency is calculated based on the IP connected to the DB management apparatus or the IP of a client connected to a specific DB server, and based on the calculated statistical data. And determining a range of access IPs and adding access allowable IPs, thereby changing a filtering policy for the IPs. The method of claim 2, wherein step D) D-1) performing a statistical operation on a query based on the indexed data; D-2) performing an analysis on the query having a frequency of occurrence greater than or equal to a predetermined value in the query to determine whether there is content related to customer information in the content of the query; And D-3) if the content related to the customer information does not exist as a result of the determination, comprising the step of including in the blocking target range of the filtering policy. The method of claim 1, wherein the method prior to step A), Requesting, by a DB management device, a schema used by the DB server or the lower DB server, and receiving the schema from the DB server or lower DB management device; And And mapping the schema of the DB server or the lower DB management device to its own schema by the DB management device. The method according to any one of claims 1 to 5, wherein the indexing of the data, And extracting predetermined items from the original data. The method according to any one of claims 1 to 5, wherein the predetermined item for indexing is: A database management method using a monitoring function, comprising at least one of a DB server name, an IP address, a type of DB server, a table name, and a column name. The method of claim 7, wherein the method is A translation function for the original data is provided so that when the predetermined item for the indexing is selected among the original data, the predetermined item is further translated into another language. How to manage. The method of claim 8, wherein in step B), If the data is out of the defined format in the process of analyzing the data, the database using the monitoring function, characterized in that further comprising the step of transmitting a predetermined warning message to the predetermined manager terminal in real time How to manage. The method of claim 9, wherein the method is The manager terminal is connected to the DB management device for transmitting the warning message via a wired or mobile communication network. The method of claim 9, wherein the method is Instant messengers are installed in at least one of the DB management apparatus and the DB server, the collection server, and the lower DB server registered in the DB management apparatus and the DB management apparatus, so that a guide message or a warning message can be sent through the messenger. Database management method using a monitoring function, characterized in that for transmitting and receiving. Iii) collecting data transmitted from a mirroring port of a switch connected to a plurality of database servers; Ii) analyzing the data to determine whether a DB server corresponding to the data is included in a preset collection target range according to a filtering policy; Iii) transmitting a predetermined guide message to an administrator terminal when the DB server is not included in the collection target range; Iii) filtering and analyzing data belonging to the collection target range among the data when the DB server is included in the collection target range according to the change of the filtering policy; And And iii) indexing the analyzed data and storing the indexed data together with the original data. The method of claim 12, wherein in step iii): When the registration to the DB server is requested from the administrator terminal, the database management method using a monitoring function, characterized in that to change the filtering policy to include the DB server in the collection target range. The method of claim 13, wherein the method is And transmitting a predetermined warning message to the manager terminal in real time when the data is out of a defined format in the process of analyzing the data. The method of claim 14, wherein the method is Instant messenger is installed in each of the DB management apparatus and the lower DB management apparatus registered in the DB management apparatus to transmit a guide message or a warning message through the messenger. How to manage your database. The method of claim 14, wherein the collection target range, Database management method using a monitoring function, characterized in that the IP information of the DB server to collect the data. The method of claim 16, wherein the method is Based on the indexed data, a statistical operation is performed on the data to calculate an access frequency of an IP connected to the DB management apparatus or an IP of a client connected to a specific DB server, and calculate the calculated statistical data. Determining a range of the access IP based on the request and adding the access allowable IP, and changing the filtering policy for the IP. 18. The method of claim 17, wherein the method is Performing a statistical operation on a query based on the indexed data; Analyzing the query having an occurrence frequency of the query equal to or greater than a predetermined value to determine whether content related to customer information exists in the content of the query; And And if it is determined that the content related to the customer information does not exist, including the step of including in the blocking target range of the filtering policy. 19. The method of any of claims 12 and 18, wherein the method is performed prior to step iii): Requesting and receiving a schema used by the DB management apparatus from the DB server or the lower DB management apparatus in the DB server or the lower DB server; And And mapping the schema of the DB server or the lower DB server to its own schema by the DB management apparatus. The method of claim 19, wherein the indexing of the data, Or extracting predetermined items from the original data or attaching a footer to the original data. The method of claim 20, wherein the predetermined item for indexing, A database management method using a monitoring function, comprising at least one of a DB server name, an IP address, a type of DB server, a table name, and a column name. The method of claim 19, wherein the method is And a translation function for the original data. When the predetermined item for indexing is selected from the original data, the predetermined item is translated into another language. A collector configured to collect data transmitted from a mirroring port of a switch connected to a plurality of DB servers; A filtering unit for determining and filtering whether the data is data collected from the DB server included in a preset collection target range, and whether the data included in the data belongs to the collection target range; Schema management unit for requesting the schema of the DB server from the DB server and mapping to a predetermined schema (Schema); An indexing unit analyzing the data received from the filtering unit and classifying the data according to the predetermined schema; And And a statistics unit configured to calculate statistics on the data classified and stored through the indexing unit. The method of claim 23, wherein the device, And a translation unit for translating a specific portion of the original data into a predetermined language and providing the translation. The method of claim 23 or 24, wherein the collection unit, And storing the IP information of the DB server, which is a target of collecting the data, and performing filtering using the IP information of the DB server. The method of claim 25, wherein the schema (Schema), And a DB server name, an IP address, a DB server type, a table name, and a column name. The apparatus of claim 25, wherein the device is As a result of the determination by the filtering unit, when the collected data is data collected from a DB server that is not included in the preset collection target range, further comprising a message generating unit for transmitting a predetermined guide message to the administrator terminal; Database management device using monitoring function. The method of claim 25, wherein the server, And a messenger for transmitting and receiving the guide message or the warning message in real time. The method of claim 23, wherein the statistics unit, Perform statistical operations on the data based on the indexed data to calculate the connection frequency of the IP connected to the DB management apparatus or the IP of a client connected to a specific DB server and transmit the result to the filtering unit. , The filtering unit determines a range of access IPs based on the calculated statistical data and adds an access permission IP to change a filtering policy for the IPs. . The method of claim 23 or 29, wherein the statistics unit, Perform statistical operations on the query based on the indexed data, analyze the query having a frequency of occurrence more than a predetermined value among the queries, and have no content related to customer information in the content of the query. And transmitting the result to the filtering unit to be included in the blocking target range.

Images