A system for detecting unused data in a database

Abstract

The present invention relates to a system (1) for detecting unused data in a database (4) by means of machine learning algorithms.

Description

[0001] A SYSTEM FOR DETECTING UNUSED DATA IN A DATABASE

[0002] Technical Field

[0003] The present invention relates to a system for detecting unused data in a database by means of machine learning algorithms.

[0004] Background of the Invention

[0005] Today, the importance of data increases day by day and the data size increases accordingly. Using the existing databases efficiently and reducing inevitable costs are of essential importance. Especially in systems with multiple users, there are objects that are created in a database yet not used. These objects occupy unnecessary space in a database and also cause performance and disk problems.

[0006] For this reason, considering the studies and deficiencies included in the current technique, it is understood that there is a need for a system which enables the objects defined but not used in a database to be detected by extracting the information in the form of object definition information and usage statistics in the respective database by means of machine learning, thereby deleting the objects from the database by presenting the respective unused object list to the users with an interface.

[0007] The Chinese patent document no. CN115374097A, an application included in the state of the art, discloses a device and system for cleaning a database. In the said invention, it is enabled to determine a predetermined cleaning strategy by analyzing the data recorded in the database by obtaining working status information and data protection information. As a result of the analysis, it is enabled to clean the database depending on the predetermined cleaning strategy. The strategies and data protection actions used during the cleaning process are determined by deep learning algorithms by using the historical cleaning strategies of the database. Status analysis is carried out by synchronizing the data protection requirements with the operational data of the database by using deep learning algorithms and it is enabled to keep a record of the data related to the cleaning action to be performed in the database. It is enabled to transmit the information regarding the cleaning operations of the database to the maintenance personnel through notification, and the cleaning analysis report can be queried, published and instructions thereof can be viewed.

[0008] Summary of the Invention

[0009] An object of the present invention is to realize a system developed for detecting unused objects in a database by means of machine learning algorithms.

[0010] Another object of the present invention is to realize a system developed for enabling the objects defined but not used in a database to be detected by extracting the information in the form of object definition information and usage statistics in the respective database by means of machine learning, thereby deleting the objects from the database by presenting the respective unused object list to the users with an interface.

[0011] A further object of the present invention is to realize a system developed for preventing disk and performance problems that may occur in databases, saving costs and increasing the speed of applications as the load on the database will be reduced.

[0012] Detailed Description of the Invention

[0013] “A System for Detecting Unused Data in a Database” realized to fulfd the objectives of the present invention is shown in the figure attached, in which: Figure 1 is a schematic view of the inventive system.

[0014] The components illustrated in the figure are individually numbered, where the numbers refer to the following:

[0015] 1. System

[0016] 2. Electronic Device

[0017] 3. Interface

[0018] 4. Database

[0019] 5. Server

[0020] The inventive system (1) developed for detecting unused objects in the database (4) by means of machine learning algorithms comprises at least one electronic device (2) which is configured to exchange data by using any remote communication protocol and to run at least one application thereon; at least one interface (2) which is configured to be run on the electronic device (3) and to enable the data detected as unused to be displayed and the respective data to be deleted; at least one database (4) which is configured to keep a record of various data and unused data information therein; and at least one server (5) which is configured to establish connection with the electronic device (2) by using any communication protocol; and to establish communication with the interface (3) run on the electronic device (2) through this established connection; to access data on the database (4); and to save data on the database (4); to detect whether the data on the database (4) is used or not by analyzing the definition information and usage statistics of the data on the database (4) through machine learning, supervised learning and deep learning algorithms; to store the information on whether the data on the database (4) is used or not in a table on the database (4); to list the data detected as unused on the database (4) onto the interface (3) run on the electronic device (2) and to access the approval of the user for deleting the respective data; to keep the respective data for a certain period of time by changing their names and then to permanently delete them from the database (4).

[0021] The electronic device (2) included in the inventive system (1) is configured to exchange data by using any remote communication protocol and to run at least one application thereon. The electronic device (2) is a device in the form of a tablet computer, desktop computer and / or portable computer. The electronic device (2) is configured to run the interface (3) thereon. The electronic device (2) is configured to establish connection with the server (5) by using any remote communication protocol included in the state of the art.

[0022] The interface (3) included in the inventive system (1) is configured to be run on the electronic device (2). The interface (3) is configured to display the data detected as unused on the database (4) transmitted through the server (5) and to enable users to delete the respective data.

[0023] The database (4) included in the inventive system (1) is configured to establish connection with the server (5). The database (4) is configured to keep a record of various data therein. The database (4) is configured to keep a record of unused data information therein.

[0024] The server (5) included in the inventive system (1) is configured to establish connection with the electronic device (2) by using any communication protocol included in the state of the art, and to establish communication with the interface

[0025] (3) run on the electronic device (2) through this established connection. The server (5) is configured to access data on the database (4) and to save data on the database

[0026] (4). The server (5) is configured to detect whether the data on the database (4) is used or not by analyzing the definition information and usage statistics of the data on the database (4) through machine learning, supervised learning and deep learning algorithms. The server (5) is configured to store the information on whether the data on the database (4) is used or not in a table on the database (4). The server (5) is configured to create and use a library by labeling the data in the database (4) as “Necessary” and “Unnecessary” in order to create the Supervised Learning algorithm. The server (5) is configured to list the data detected as unused on the database (4) onto the interface (3) run on the electronic device (2) and to access the approval of the user for deleting the respective data. The server (5) is configured to keep the respective data for a certain period of time by changing their names and then to permanently delete them from the database (4). The server (5) is configured to historically store user behavior on the database (4) in order to develop supervised learning and deep learning algorithms in the future processes.

[0027] Industrial Application of the Invention

[0028] In the inventive system (1), the server (5) detects whether the data on the database (4) is used or not by analyzing the definition information and usage statistics of the data on the database (4) through machine learning, supervised learning and deep learning algorithms. The server (5) stores the information on whether the data on the database (4) is used or not in a table on the database (4). The server (5) creates and uses a library by labeling the data in the database (4) as “Necessary” and “Unnecessary” in order to create the Supervised Learning algorithm. The server (5) lists the data detected as unused on the database (4) onto the interface (3) run on the electronic device (2) and accesses the approval of the user for deleting the respective data. The server (5) keeps the respective data for a certain period of time by changing their names and then permanently deletes them from the database (4). The server (5) historically stores user behavior on the database (4) in order to develop supervised learning and deep learning algorithms in the future processes. In this way, the objects defined but not used in the database are enabled to be detected by extracting the information in the form of object definition information and usage statistics in the respective database (4) by means of machine learning, thereby deleting the objects from the database (4) by presenting the respective unused object list to the users with an interface (3).

[0029] Within these basic concepts; it is possible to develop various embodiments of the inventive “A System (1) for Detecting Unused Data in a Database”; the invention cannot be limited to examples disclosed herein and it is essentially according to claims.

Claims

CLAIMS1. A system (1) developed for detecting unused objects in the database (4) by means of machine learning algorithms; comprising at least one electronic device (2) which is configured to exchange data by using any remote communication protocol and to run at least one application thereon; at least one interface (2) which is configured to be run on the electronic device (3) and to enable the data detected as unused to be displayed and the respective data to be deleted;- at least one database (4) which is configured to keep a record of various data and unused data information therein; and characterized by at least one server (5) which is configured to establish connection with the electronic device (2) by using any communication protocol; and to establish communication with the interface (3) run on the electronic device (2) through this established connection; to access data on the database (4); and to save data on the database (4); to detect whether the data on the database (4) is used or not by analyzing the definition information and usage statistics of the data on the database (4) through machine learning, supervised learning and deep learning algorithms; to store the information on whether the data on the database (4) is used or not in a table on the database (4); to list the data detected as unused on the database (4) onto the interface (3) run on the electronic device (2) and to access the approval of the user for deleting the respective data; to keep the respective data for a certain period of time by changing their names and then to permanently delete them from the database (4).

2. A system (1) according to Claim 1; characterized by the electronic device (2) which is a device in the form of a tablet computer, desktop computer and / or portable computer; and is configured to exchange data by using any remote communication protocol and to run at least one application thereon.

3. A system (1) according to Claim 1 or 2; characterized by the electronic device (2) which is configured to run the interface (3) thereon.

4. A system (1) according to Claim 3; characterized by the electronic device (2) which is configured to establish connection with the server (5) by using any remote communication protocol.

5. A system (1) according to any one of the preceding claims; characterized by the interface (3) which is configured to be run on the electronic device (2).

6. A system (1) according to any one of the preceding claims; characterized by the interface (3) which is configured to display the data detected as unused on the database (4) transmitted through the server (5) and to enable users to delete the respective data.

7. A system (1) according to any one of the preceding claims; characterized by the database (4) which is configured to establish connection with the server (5).

8. A system (1) according to any one of the preceding claims; characterized by the database (4) which is configured to keep a record of various data therein.

9. A system (1) according to any one of the preceding claims; characterized by the database (4) which is configured to keep a record of unused data information therein.

10. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to establish connection with the electronic device (2) by using any communication protocol, and to establish communication with the interface (3) run on the electronic device (2) through this established connection.

11. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to access data on the database (4) and to save data on the database (4).

12. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to detect whether the data on the database (4) is used or not by analyzing the definition information and usage statistics of the data on the database (4) through machine learning, supervised learning and deep learning algorithms.

13. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to store the information on whether the data on the database (4) is used or not in a table on the database (4).

14. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to create and use a library by labeling the data in the database (4) as “Necessary” and “Unnecessary” in order to create the Supervised Learning algorithm.

15. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to list the data detected as unused on the database (4) onto the interface (3) run on the electronic device (2) and to access the approval of the user for deleting the respective data.

16. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to keep the respective data for a certain period of time by changing their names and then to permanently delete them from the database (4).

17. A system (1) according to any one of the preceding claims; characterized by the server (5) which is configured to historically store user behavior on the database (4) in order to develop supervised learning and deep learning algorithms in the future processes.

Images