Accessing a database using user-defined attributes

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000

Reexamination Certificate

active

06735584

ABSTRACT:

BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention relates to databases and pertains particularly to accessing data from a database using user-defined attributes which are familiar to a user and easily memorized.
2. Description of the Prior Art
The collection and use of information is important both for individuals and corporate entities. This is particularly true for certain professions, such as news agencies and publishing companies. In these professions, the collection and management of data is essential.
In early data management systems, data was collected and preserved. Data, when needed, was searched out one article at a time. Such a traditional data management lacks structure, and is not sufficient for modern society which values efficiency and speed.
In more recent years, the use of computers has greatly increased the efficiency of data management. Data management by computer is generally divided into two systems. In one system, data is sorted by index. In the other system, data is sorted using multiple indexes similar to the use of a bibliographical card index.
When sorting by index, a subjective judgment of data is made according to the existing sorting criteria. Based on this subjective judgement, the data is indexed and stored into a corresponding file. When a particular lot of data is desired, a search is performed by index in an attempt to locate the appropriate data.
One drawback of a single index system is that sorting is done manually in reliance upon the subjective judgment of an administrator. Data supposed to be classified under a first category might be misplaced in a second category simply because the administrator failed to recognize the nature of the data. Since any lot of data is generally put under only one particular category only, the lot of data is practically missing if put under another category by mistake. Therefore, it is easy in a single index for data to become lost or difficult to retrieve.
In multiple index systems, multiple indexes are used. For example, separate columns can be used to allow sorting by author, log-in date, log-in publication, topic or serial number. The data can then be retrieved using an index for any column.
However there are also deficiencies with multiple index systems. For example, for any particular lot of data any and all specific columns can fail to satisfy the needs for organization of data. For instance, it may still be difficult to define and classify data used by a news agency or a publishing company. For example, if there are seven co-authors in a given article and the specific column used to index authors allows the entry of at most three authors, then only three of seven co-authors can be used to index the article. The remaining four authors would have to be abandoned in the entry. A later search for the works of these four authors would not turn up this article. Furthermore, the selection of which authors to include in the entry and which to drop requires a subjective judgment.
Key words can be used to index data. For example, to index a target article, keywords can be used such as “Politics”, “Related to Crossing the Straits”, or “Straits Exchange Foundation”. These keywords can be stored with the document or the database system can perform a full text index through all documents in the database searching for a keyword. However, use of keywords for searching lacks accuracy since articles may contain searched key words, but the key words may have different meanings as used in different articles. Thus searching by key word is often not worth the effort.
SUMMARY OF THE INVENTION
Whereas the existing data index and management methods for files deficient both in terms of efficiency and speed, the primary objective of the present invention is to provide a dynamic methodology for data base index and management by attribute. In the preferred embodiment of the present invention a multiple of columns are provided for a user to actively define the data into various attributes for fast and precise search of target data by the fact that the user is familiar with those user-defined attributes which at the same time can be easily memorized by the user.
Another objective of the present invention is to provide a dynamic methodology for data base index and management by attribute. The configuration of the database is not predetermined. Instead the data itself is used as a starting point to create a data characteristics oriented configuration of the management system. The resulting database system is not limited to using a set number of columns to define identification characteristics. Instead, at the reference, attributes are created and fit into an attribute structure at the discretion of the users. Multiple attributes may be associated with any data lot. What is meant by a data lot is any grouping of data such as a document or data file.
Any word or group of words deemed by a user to have meaning can be formed by a user. A created attribute is then placed in an appropriate location in an existing attribute structure. Multiple attributes can be assigned to a data lot. Any or these attributes or logical combination of these attributes can then be used to access the data lot. Since a particular document may be given various attributes, this allows for an easy search using such logical operations as intersection or union of attributes.
A further objective of the present invention is to include an attribute logging segment and a file logging segment. Within the attribute logging segment is provided for the storage of attributes defined by the user on various documents. Each attribute is respectively designated with items of “Description of Attribute”, “Attribute No.” and “Relevant Attribute No.” for the logging. The “Description of Attribute” is actively entered by the user, the “Attribute Number” which may be in the form of sequential number, is automatically generated by a management unit of attribute logging in the attribute logging segment for each logging attribute and the “Relevant Attribute No.” also actively entered by the user relates to the number of any other attribute related to that of the document, and is made an integral part of those attributes to the document in question.
The file logging segment is provided to log in and store those document data with defined attributes, and file number as well as the address of placement are given to each lot of data together with its attribute number. The file number may be given the same as the attribute number for identification purpose only provided it does not repeat itself. The method described above achieves a structured data and a more user-friendly environment.
Another objective yet of the present invention is the address for placement of the file logging segment may be marked by the description of a disk unit, route and file name while the methods of index and management described above are run by a computer.
In order to satisfy the above objectives the access of data is facilitated using user-defined attributes. Attributes are stored in a first logging segment. Entries for the attributes contain information which indicate subordinate relationships between attributes. The subordinate relationships creating an attribute structure. When a user stores a data lot, the user is allowed to specify one or more attributes to be linked to the data lot. Entries which show links from data lots to attributes are stored in a second logging segment.
In the preferred embodiment, each entry in the first logging segment includes an identification of an attribute and an identification of any subordinating attribute. Specifically, each entry in the first logging segment includes an attribute number, an attribute name and a relative attribute number. The relative attribute number is an attribute number for a subordinating attribute. Likewise, each entry in the second logging segment includes an identification of a data lot and an identification of an associated attribute. Particularly, each entry in the second logging segment includes a file number, a file loc

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Accessing a database using user-defined attributes does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Accessing a database using user-defined attributes, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Accessing a database using user-defined attributes will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3234888

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.