KR20010095973A - Method of maintaining a database - Google Patents

Abstract

PURPOSE: A method for managing a database is provided to maintain new data in a database by improving a structure of database management. CONSTITUTION: Product data are inputted according to classified field names(S100). The inputted product data are classified according to kinds of the product data(S101). The classified product data are inputted(S102). The inputted products are compared with the present displayed product(S103). The inputted product corresponding to the present displayed product is searched(S104). The inputted product similar to the displayed product is searched(S105). The inputted product corresponding to the present displayed product and the inputted product similar to the displayed product are processed(S106). The inputted product data are classified according to a fixed period of time(S107). The classified product data are stored in a database(S108).

Description

How to manage your database {METHOD OF MAINTAINING A DATABASE}

The present invention relates to a data retrieval and database management method, and more particularly, to a database management method that can be maintained as new information of a database. Rapid changes in social structure have made consumers' needs more diversified and, in proportion, shorter life cycles of goods.

Moreover, the rapid spread of the Internet is disrupting the existing distribution network and changing the economic order itself with new distribution processes. As a result, the situation in which product producers have to adapt to a new distribution structure in order to meet the needs of consumers and to transform into a multi-product small quantity production structure is accelerating.

In information retrieval, finding the appropriate location of information is the main goal. In the past, advertisements of broadcasting media tend to be approached in terms of distributing information from sellers to buyers. In recent years, however, interactive internet communications have led to the flow of information in completely different ways.

That is, consumers can view various information about new products provided by producers, and can develop development of products they want. In addition, producers are quickly becoming aware of the consumer's reaction to the new products they have developed and effectively promoting the role of an Internet site that provides an opportunity for efficient and productive product development. However, in order to discover new products and give them advertising opportunities, a powerful search engine is needed.

The search engine according to the prior art has the following problems. First, the database search engine according to the prior art has a problem that the specific site data is derived intensively. In addition, a search example is not provided faithfully, and even if a search example is provided, there is a problem of merely using a simple operator.

In general, field constrained search is required to overcome the irregularities of documents indexed by search engines. However, the database search engine according to the related art does not provide a field limited search function, and even if possible, only a title, a host, and a domain may be limited.

Accordingly, a first object of the present invention is to provide a database management method capable of maintaining the freshness of information stored in a database.

A second object of the present invention is to provide a database management method for enabling field limited search in addition to the first object.

It is a third object of the present invention to provide a database management method capable of maintaining only new product or service information in addition to the first object.

1 shows a first embodiment of a method for entering merchandise data into a database according to the present invention;

2 shows a second embodiment of a method for inputting merchandise data into a database according to the invention.

Fig. 3 is a diagram showing an embodiment of a data holding method for freshening commodity data in a database according to the present invention.

In order to achieve the above object, the present invention provides a method for managing a database for data retrieval, comprising: inputting data of an input product according to a selected classification field name; Classifying the input data by type; Determining whether the item to be input matches a product item held by a current database, and deleting if the product to be matched; Retrieving the date of manufacture of the input product to determine whether it is the latest product, and deleting if it is not the latest product; Classifying data of the input goods by periods; It provides a database management method comprising the step of storing the input product in a product table and a period-specific product table.

In addition, in order to achieve a further object of the present invention, a method for managing a database for data retrieval, the registration of the product with reference to the period-specific commodity table that manages the registration period of the product among the data of the product stored in the database Extracting a product item which has exceeded the period; Counting the number of commodity items whose registration period has expired, and determining whether the number of commodity items whose registration period has not exceeded satisfies the selected threshold value or more; As a result of determining the number of commodity items, deleting a commodity item whose expiration date has been exceeded from the commodity table when the number of commodity items whose product registration period has not exceeded a predetermined threshold value or more is satisfied. ; Determining the number of commodity items, and if the number of commodity items for which the commodity registration period has not exceeded a predetermined threshold or more is not satisfied, requesting input of new commodity item data; To provide.

Hereinafter, a preferred embodiment of a database management method according to the present invention will be described in detail with reference to the accompanying drawings.

1 is a view showing a first embodiment of a method for inputting product data into a database according to the present invention. Referring to FIG. 1, through step S100 of inputting commodity data according to a selected classification field name, the input data may be classified by type (step S101).

Then, the sorted data input step (step S102) is performed to compare with the currently displayed product (step S103). As a result, the matched or similar product is processed according to the result of the matched product search (step S104) or the similar product search (step S105) (step S106), and the data for each period is classified (step S107). Finally, the item item data is stored in the database.

2 is a diagram illustrating a second embodiment of a method for inputting commodity data into a database according to the present invention. Referring to Fig. 2, the product data and the manufacturing date are input (step S200), and the input goods are classified into large, medium and small categories according to the selected classification method (step S201).

On the other hand, the classified commodity data is searched for a match among current items (step S202), and if there is a match item, it is deleted (step S203). In addition, the manufacturing date of the input product is searched to determine whether the product is the latest product (step S204), and even when the product is not the latest product, the process moves to step S203 to perform the deleting step.

On the other hand, when the date of manufacture of the input product is searched, if it is the latest product, it may be input by classification by period, and a registration date, a deletion date, a manufacturing date, and the like may be input (step S205). Subsequently, the input product item is stored in the product table 206 and the period-specific product table 207.

3 is a view showing an embodiment of a data holding method for freshening the product data of the database according to the present invention. The present invention is characterized by maintaining the freshness of the database by deleting data that has exceeded a selected period of time stored in the database.

Referring to FIG. 3, a deletion date field is searched for in a life product table (step S300), and an item to be deleted is extracted when a deletion corresponding field exists (step S301). Then, the total number of deleted items is counted (step S303), and the number of remaining items is compared with the selected threshold value (step S304).

At this time, if the number of items that have been deleted and the number of items remaining in the database is less than the selected threshold value, new data input may be requested (step S305). Next, the extracted data is first deleted and the second deletion scheduled date is set. (Step S306). In addition, the product may be deleted from the product table (step S307) and stored in the temporary deletion database (step S308). Subsequently, the second deletion scheduled date may be retrieved (step S309) and finally deleted after the data processing step for secondary deletion (step S310).

The database maintenance method according to the present invention may determine a deletion date by providing a life cycle together with a registration date in the data information. As a preferred embodiment of the present invention, the lifespan may be designated as 1 day, 7 days, 10 days, 30 days, 100 days, or the like, and the deletion date may be a date plus a set life period from the registration date. The aforementioned data may be stored in a life product table.

On the other hand, after registering the product data, for example, by 24 hours every day, the date of deletion field of the commodity table for each period is compared with the current date, it is possible to automatically select the data past the deletion date. The life product table according to the present invention may be sorted in order of deletion date to minimize search time.

Subsequently, the number of remaining data of the item whose data is to be deleted after selection can be calculated. At this time, if a certain amount of data does not exist in the existing item through the constant item count maintenance inspection, a new data is automatically requested from the manager. If a certain amount of data exists, the deletion field of the product table for each period is checked. This step corresponds to the first step of deleting data.

Subsequently, the deleted data is automatically deleted from the merchandise table after the second deletion date is determined which is permanently deleted after a certain period of time. Deleted data is stored in the deletion table, and the data in the deletion table is deleted permanently when the deletion date is exceeded by checking whether the secondary deletion date has been exceeded.

The foregoing has outlined rather broadly the features and technical advantages of the present invention to better understand the claims of the invention which will be described later. Additional features and advantages that make up the claims of the present invention will be described below. It should be appreciated by those skilled in the art that the conception and specific embodiments of the invention disclosed may be readily used as a basis for designing or modifying other structures for carrying out similar purposes to the invention.

In addition, the inventive concepts and embodiments disclosed herein may be used by those skilled in the art as a basis for modifying or designing other structures for carrying out the same purposes of the present invention. In addition, such modifications or altered equivalent structures by those skilled in the art may be variously changed, substituted, and changed without departing from the spirit or scope of the invention described in the claims.

As described above, according to the present invention, the product database is inputted according to the classification field name through a matching product or similar product search method, and the data stored in the product data database is provided with a lifespan for automatically deleting the data that has exceeded the lifespan. You can keep your database data fresh at all times. As a result, a user can save a search cost for searching for new information and search for new content while maintaining freshness.

Claims (8)

In the method of managing a database for data retrieval, Inputting data of an input product according to a selected classification field name; Classifying the input data by type; Determining whether the item to be input matches a product item held by a current database, and deleting if the product to be matched; Retrieving the date of manufacture of the input product to determine whether it is the latest product, and deleting if it is not the latest product; Classifying data of the input goods by periods; Storing the input goods in a goods table and a goods table for each period Database management method comprising a. The method of claim 1, wherein the database management method further comprises inputting a manufacturing date of a product. The method of claim 1, wherein the field name includes any one of a classification code of a product, a product name, a manufacturer, a product price, an inventory amount, a manufacturing date, and a registration date, or a combination thereof. In the method of managing a database for data retrieval, Extracting a product item exceeding a registration period of the product by referring to a period-specific product table managing the registration period of the product among the data of the product stored in the database; Counting the number of merchandise items whose product registration period has exceeded, and determining whether the number of merchandise items whose product registration period has not exceeded a predetermined threshold value or more; As a result of determining the number of commodity items, deleting a commodity item whose expiration date has been exceeded from the commodity table when the number of commodity items whose product registration period has not exceeded a predetermined threshold value or more is satisfied. ; As a result of determining the number of commodity items, requesting input of new commodity item data when the number of commodity items for which the commodity registration period has not exceeded the predetermined threshold value is not satisfied. Database management method comprising a. The method of claim 4, wherein deleting the goods item from the goods table comprises: Setting a scheduled deletion date of a product item extracted to be deleted and storing in a temporary deletion database; And Retrieving the scheduled deletion date and completely deleting the scheduled deletion product item from the temporary deletion database if it corresponds to the scheduled deletion date; Database management method comprising a. The method of claim 4, wherein the deleting of the product item from the product table is repeatedly performed at predetermined intervals. In the method of managing a database for data retrieval, Classifying the input data and storing the input data in a category table; Comparing the classified data with the current item and deleting the classified data when the same data exists; Inspecting a date of manufacture of the classified data and deleting the classified data if the data is older than a selected period; Inspecting the date of manufacture of the classified data and then moving to the classification input box for each period and sorting them in the commodity table in order of commodity code, and storing them in the commodity table for each period in order of deletion date. Database management method comprising a. In the method of managing a database for data retrieval, Setting a registration date and a life cycle of the product data and storing the deletion date data for each product in the product table for each period; Selecting data for which the deletion date has been exceeded by comparing a deletion date field of the product table for each period with a current date; Calculating a number of remaining data of the item to be deleted as a result of the screening step and requesting input of new data when there is no certain amount of data in the existing item; Calculating a number of remaining data of the item to be deleted as a result of the screening step and checking a deletion field in a period-specific commodity table when a certain amount of data exists in the existing item; Setting a second deletion date that is permanently deleted after a period of time for the data to be deleted, and storing the second deletion date in a deletion table; Permanently deleting data stored in the deletion table when the second deletion date has elapsed Database management method comprising a.