KR100644563B1 - User-friendly database management method on the computer - Google Patents

Abstract

The present invention discloses a user-friendly database management method in a computer. A user-friendly database management method on a computer includes the steps of (a) creating a database tool by defining a plurality of criterions that are used to classify files owned by a user, and (b) allowing a user to register files. If desired, displaying, in the database tool, a list of top-level folders and branch folders corresponding to each of the plurality of cryterias, (c) selecting at least one list by the user from the displayed list, and (d ) Registering the file with the selected criterion.

Description

User friendly database managing method in computer

1 is a flowchart for explaining a user friendly database management method in a computer.

2 is a diagram illustrating an example of an application to which the present invention is applied.

3 is a diagram illustrating an example of dragging and dropping a file in the screen illustrated in FIG. 2.

4 is a diagram illustrating another example of dragging and dropping a file on the screen illustrated in FIG. 2.

FIG. 5 illustrates a newly displayed database bank window on the screen shown in FIG. 2.

6 is a diagram showing an example of selection in the database bank window.

7 is a diagram showing another example of selection in the database bank window.

8 is a diagram illustrating a criterion enabled in the database bank window.

The present invention relates to a database, and more particularly, to a user friendly database management method on a computer.

In general, database management tools that manage data are difficult for ordinary personal computer users to access due to the complexity of usage and the high cost. You need to create a database management tool that fits your needs while still being simple to use and small enough to meet your needs.

A database is a collection of data that is organized and conveniently classified and stored largely by a group or a company. It is a tool developed to search quickly when needed. Recently, as the capacity of the auxiliary storage device of a personal computer increases and the price decreases, general personal computer users also have a storage space ranging from several gigabytes to several tens of gigabytes. This means that even ordinary personal computer users can store vast amounts of data for personal needs. For the average user, most of the data comes from multimedia contents such as movies, video chips, and music files for entertainment.

When these data range from a few gigabytes to tens of gigabytes, no matter how large each multimedia content is, the number of their data will also be small. In particular, music files such as MP3 are not very large and can store hundreds of songs. It can be inconvenient for the average personal computer user to remember all of these file names for a large amount of data, or to search the entire hard drive directory directly by remembering the song name or movie title to find the desired file name.

Typically, personal computer users use Windows Explorer's folders to manage files on their hard disks. In this case, you can easily remember the file name when managing the file you created, but remember all the file names when the file is obtained from the Internet or other external sources such as music files such as MP3 or video chips such as AVI. Is difficult. Especially in the case of music files such as MP3, the size is not so big, and many songs are poured out from various artists every day, so if users keep their favorite songs on their personal computer continuously, The number is not small.

Thus, even if the MP3 music files are divided into folders defined by the personal computer user, they may not remember the location and title of the desired song later, or may not remember which folder contains the song. Also, the user will have to scan all of the hundreds of MP3 files in the expected folder to find the song he is looking for. As a result, it can be difficult for users to organize their files using Windows Explorer's folders.

To solve this, you need a database management tool that manages some kind of data. However, commercially available database management tools provided by Oracle and Windows are very difficult to reach users in terms of price and complexity. Therefore, there is a need for a management tool that can be easily accessed from a graphical user interface (GUI) without any scripting language or technical background.

SUMMARY OF THE INVENTION The present invention has been made in an effort to provide a user-friendly database management method on a computer that enables a user to easily manage a file registered by a user using a simple database management tool.

In order to achieve the above object, a user-friendly database management method in a computer according to the present invention,

(a) predefining a plurality of cryterias that are the criteria for classifying files owned by a user to create a database tool; and (b) in case the user wants to register a file, Displaying a list of top-level folders and branch folders corresponding respectively to (c) selecting at least one list from the displayed list by the user, and (d) registering a file with the selected criterion. Characterized in that.

In order to accomplish the above other task, a database tool is defined by defining a plurality of criterions that are used as a basis for classifying files owned by a user, and when the user wants to register a file, the database tool includes: Displaying at least one list of top-level folders and branch folders corresponding to the respective criterions, the user selecting at least one list from the displayed list, and registering the file with the selected criterion. A recording medium storing executable program code.

Hereinafter, with reference to the accompanying drawings, a user-friendly database management method of a computer according to the present invention will be described as follows.

1 is a flowchart for explaining a user friendly database management method in a computer.

Referring to FIG. 1, first, a database tool is created by predefining a plurality of criterias which are criteria for classifying files owned by a user (step 100).

To help understand the present invention, an MP3 file, which is a music-only file, which is recently popular, is described as an example. Suppose a user has hundreds of MP3 files. These songs will be songs that you have stored on your personal computer over time. Thus, the user may be able to memorize all the names of the songs, except in the case of some songs he likes to enhance.

A user-friendly database management tool is composed of a plurality of criterions. In the case of a music file, the songs can be classified by a predefined criterion as shown in FIG.

2 is a diagram illustrating an example of an application to which the present invention is applied and shows a database manager. The left side shows a general Windows Explorer type window, and the right side shows a database window.

2, Album, Artist, Class, Mood, Situation, etc. are arranged on the far right as a plurality of cryterias, and a selection button is provided so that the user can select a desired cryterrier. Pressing each select button changes the name of the parent folder in the upper right corner of the database window to the selected criterion. 2 illustrates an example in which an album is selected.

In addition, one cryterrier may include various types of subcriteries. Referring to FIG. 2, Promise, Tears in heaven, Unforgettable, and the like are shown as branch folders for the album, which is a top-level folder. When the user selects one of the branch folders, the titles of all MP3 music files registered in the selected folder are displayed as shown in FIG.

In the initial state of the database manager who manages the database, the top-level folder visible to the user in the tree folder structure of the right database window points to a directory on the hard disk of the personal computer that the user specified when installing the database manager. . Of course, the name of the top-level folder is either predefined by default or user-defined.

In addition, some of the branch folders included in the top-level folder displayed in the database window may be created with a predefined name in a directory designated by the user by default, or may be created by a user's arbitrary name. However, since the database manager adopts predefined folders for classification by criterion, it becomes the default folder.

These folders are already created when you install the database tools on your personal computer. Basically, as shown in Fig. 2, the Windows Explorer-type window on the left shows all the directories in the personal computer in the form of a tree folder, and the database window on the right is the structure of the tree folder in the user-defined directory described above.

Referring back to FIG. 1, after step 100, if the user wants to register a file (step 102), the database tool displays a list of top folders and branch folders corresponding to each of the plurality of cryterias, respectively. (Step 104).

Specifically, in the screen shown in Fig. 2, when the user wants to register any file on the left side, for example, a file whose song name is "Wonderful tonight", the folder corresponding to the desired criterion or sub-criteria is displayed on the screen. If displayed on the screen, the corresponding folder is selected and dragged as shown in FIG. 3.

If the user wants to register any file on the left side in Fig. 4, if the folder corresponding to the desired criterion or its sub-criteria is not displayed on the screen, dragging to the top folder is performed. Then, a database bank window, which is a new window, is displayed on the screen shown in FIG. The new window displays a list of all the top-level folders and their branch folders, each corresponding to a plurality of criterions, in the database tool.

Referring back to FIG. 1, the user selects at least one list from the list displayed after step 104 (step 106).

6 is a diagram showing an example of selection in the database bank window.

As shown in FIG. 6, a song name corresponding to a file to be registered by the user, for example, "Wonderful tonight" is displayed on the upper left. From the contents of each of the six criterions, the user clicks to select a list of branch folders that he thinks is appropriate for the song name. If the user skips the selection among six criterions without clicking the list, the song is not registered in the criterion. Therefore, when searching for a registered file later, no song name can be viewed even if any list of non-selected criterions is selected.

After step 106, the file is registered in the selected criterion (step 108). Subsequently, when a user wants to search for a file registered by the user, all of the corresponding cryterias may be selected from among the plurality of cryterors and searched in multiple times (step 110).

According to the above, when the user selects the rightmost selection button representing the criterion in Fig. 2, the top folder of the tree folder of the database window becomes the selected criterion. In addition, branch folders appear that represent the internal contents of the Criteria. At this time, if the user selects one of those folders, a list of all music files registered in the contents is displayed. In addition, in FIG. 2, if a user drags and drops a music file in a tree folder to a folder corresponding to the right Cryterrier in the Explorer window on the left side, in the window for selecting the content of the Critery in FIG. Only the contents of the criterion in which the user has dropped the selected file are enabled as shown in FIGS. 7 and 8, and the remaining parts are disabled.

If the user drags a file selected in the left window to a branch folder representing one of the contents of the cry terrier in the right window, it is registered only in the contents of the cry terrier that immediately dropped the selected file.

As described above, the user-friendly database management method according to the present invention can easily manage the ever-increasing multimedia files using a simple database management tool, and by selecting the desired criterion later, It is easy to select a song or a list of songs to suit the user's desired situation, and there is an advantage in terms of memory capacity by preventing the user from repeatedly storing the same file on the computer.

Claims (5)

In a user-friendly database management method on a computer, (a) creating a database tool by defining a plurality of cryterias which are criteria for classifying files in advance; (b) displaying, in the database tool, a list of top-level folders and branch folders corresponding to the plurality of cryterias, respectively; (c) selecting at least one list from the displayed lists; And (d) registering the file with the selected criterion. The method of claim 1, wherein after step (d), When searching for a file registered by the user, the database management method characterized in that the multi-search can be selected by selecting all of the corresponding criterion of the plurality of criterion. According to claim 1, wherein the step (a), (a1) when installing a predetermined database manager for managing a database, basically defining a predetermined number of criterions in advance; And (a2) A method for managing a database, comprising the step of additionally defining an arbitrary cryterrier. According to claim 1, wherein step (b), (b1) displaying a window in the form of a general Windows Explorer showing unclassified files possessed by a user on a computer screen; And and (b2) displaying, together with the window, a new window showing a list of the highest folders and branch folders respectively corresponding to the plurality of cryterias. Creating a database tool by predefining a plurality of criterions that are used to classify files, and displaying a list of top-level folders and branch folders corresponding to the plurality of criterions, respectively, in the database tool; And storing program code that can be executed by a computer to select at least one list from among the displayed lists and to register the file with the selected criterion.

Images