CN1300028A - Dynamic attribute database management retrieval method and system - Google Patents

Abstract

The invention relates to a management and retrieval method and a system of a dynamic attribute database, which mainly comprises that a user actively defines a plurality of attributes to the data to describe the nature and the type of the data, and can form association with other data through the definition of the attributes to form a structured database, and the user appoints the attributes in a retrieval and query part, and can quickly and accurately find out the required data through the matching of attribute management and intersection or union operation.

Description

Dynamic attribute database management retrieval method and system

The present invention relates to a management and retrieval method and system of a dynamic attribute database. It mainly uses the user to actively define data into multiple different attributes to quickly and accurately find out the management retrieval method and system of the data.

With the formation of an information society, ordinary people and even companies attach great importance to the collection and application of information, especially in some special industries, where the accumulation and preservation of data is an important business resource, such as newspapers and publishing industries. Since data is an important resource, there must be a set of methods to manage it. In essence, the early data management was only "centralization". It stored useful data in a centralized manner, and when it was needed, it filtered it by reading it one by one. This traditional method of data management has no structure at all, and it certainly does not meet the requirements of modern society that emphasizes efficiency and speed.

In recent years, the use of computers has become more and more popular, and it is widely used in data management. It is naturally more efficient in management than traditional centralized management methods. Its management methods generally include classification index and similar book card system. The former is for managers to make subjective judgments on the data according to the established classification standards, and store them in the folders of the classification. Folders of specific nature filter the required information one by one.

And the latter defines the nature of the document data according to the fixed fields, such as author, date of publication, publication, title or classification number, etc., when users want to find information in the future, they can use the aforementioned fields to search.

However, whether it is a classified index or a similar book card system, there are disadvantages:

First of all, as far as the classification index method is concerned, the manual classification method relies entirely on the subjective judgment of the management personnel. When the management personnel's cognition of the nature of the data differs from the established standards, the data that should have been classified as Class A may be misclassified as Class B. category, because this classification method is only roughly divided into a single category, so when it is misclassified and classified into other categories, the data is almost missing for its original category. It can be seen that it is obviously extremely dangerous to use a single category as the only basis for classification.

As for the classification system similar to book cards, although there are many fixed fields for retrieval, compared with the aforementioned classification index method, its instability has been slightly reduced, but there are still inherent defects. The most obvious defect is that the fixed fields are inherently It is impossible to meet the needs of all clippings. For example, the database of a newspaper office or publishing industry has a variety of data types. With only a few fixed columns, it is absolutely impossible to make appropriate and appropriate definitions for various types of different data. Let’s take a simple example to illustrate that if there are seven authors in a document, but the system can only allow up to three authors in the author field, then there must be a choice in the input of the author field, which means that for the author field For a document, only three authors can be registered, and the four authors whose registration has been abandoned will not be able to identify their works based on their names in the future, resulting in a dead end for data retrieval.

In addition to the above-mentioned author field, which is limited by the number of fields, there must be a trade-off in the registration operation, other aspects such as subject, time, and related personnel, events, and objects may encounter the above-mentioned problems.

In addition to the above-mentioned management methods, there is also a keyword search method, which is to enter keywords related to the desired article, such as 'politics', 'cross-strait relations', 'sea foundation', etc., and then the system will use the The keywords entered by the reader search the full text of all the documents in the database one by one to find out the articles containing the aforementioned keywords. However, the accuracy of this retrieval method is obviously insufficient. The problem is that it uses keywords as the object of retrieval judgment. Therefore, the retrieved objects are all articles containing the keyword, not related to the meaning of the keyword. Articles, this method will make the data retrieval work more effective with less effort.

From the above, it can be seen that the efficiency and speed of the management retrieval methods of existing archives are not ideal, so further review and improvement are needed.

Therefore, the main purpose of the present invention is to provide a dynamic attribute database management retrieval method, which uses an unspecified number of fields for the user to actively define data as a plurality of different attributes, and utilizes actively defined attributes to generate information for the user. Familiarity and easy-to-memory features can quickly and accurately find out information.

The secondary purpose of the present invention is to provide a dynamic attribute database system, which does not set its structure with a preset standpoint, but takes the data itself as a starting point and uses its characteristics as a guide to develop a management system;

The so-called file characteristic orientation means that it is not limited to use several columns to define the characteristics of the document, but the user will actively make all the information with reference value into columns according to the actual needs, and use the columns that can be added dynamically Bits define multiple attributes of the file. In other words, each file can have multiple attributes at the same time, which can be more convenient for data retrieval after intersection or union operations.

Another object of the present invention is to provide a dynamic attribute database management retrieval method, including an attribute recording area and a file recording area, wherein:

The attribute recording area is used to store the attributes defined by the user for different files. Each attribute will be recorded with items such as 'attribute name', 'attribute number' and 'relationship attribute number':

The 'property name' is actively input by the user;

The 'attribute number' is generated by an attribute record management unit in the attribute record area, which automatically generates an attribute number for each record attribute, and the attribute number can be a sequential serial number.

The 'relationship attribute number' is another attribute number related to the document attribute actively input by the user, so that the relationship number becomes a part of the attribute of the document in question.

The file recording area is to record and store the file data with defined attributes, and assign a file number and storage address to each piece of file data, and record its attribute number, where the file number is just like the attribute number, which is used as an identification description , as long as it does not repeat.

Using the aforementioned management retrieval method can make the database structure more humanized.

Another object of the present invention is to provide a dynamic attribute database management retrieval method. When the management retrieval method is executed by a computer, the location of the file recording area can be marked by the disk drive name, path and file name.

The dynamic attribute database management retrieval method related to the present invention is divided into a management part and a retrieval part, wherein the management part includes:

1. Steps for defining attributes of saved data from the user's point of view;

1. The step of finding the relationship attribute related to the data from the defined attributes to form the subordination relationship;

1. The step of storing the attribute of the data and its relationship attribute in a specific form;

1. The step of storing the data in a specific location, and respectively marking its file location and associated attribute number, and associating with the aforementioned positioning attribute; wherein:

The 'property definition step': is guided by the user's own point of view to define the properties of the file to be saved, which means that the user is not limited by fixed fields or a standard format when defining the properties of the file. Conversely, any information that is subjectively identified by the user as having reference value is listed as an attribute item that can be defined, such as a word, a symbol, a specific noun, number, person's name, place name, organization, etc.

For example, people can define an article about the general situation of Taiwan's trade with Canada in 1990, which can be used to define the attribute items of the article including: 1990, Taiwan, Canada, trade, crops, imports, etc., all can become attributes project.

Since the aforementioned attribute is proposed by the user, it is most consistent with the user's point of view. When the user performs a search, he can specify the attribute accurately and quickly find the desired content.

And because the attribute item is proposed by the user, there is no restriction on the field item, so the shortcomings of the traditional similar book card system that cannot be defined in detail due to the restriction of the field item will not occur.

The step of defining relational attributes: when the saved and managed data accumulates, the defined attribute items will also increase, and in order to make the data structured, a subordinate relationship will be formed between the existing attributes to facilitate the structured data.

Further illustrate the present invention below in conjunction with accompanying drawing:

Fig. 1 is a schematic diagram of an attribute recording area of the present invention;

Fig. 2 is a schematic diagram of the file recording area of the present invention;

Fig. 3 is a schematic diagram of newly added file records of the present invention;

Fig. 4 is a schematic diagram of retrieval file records of the present invention;

Fig. 5 is a schematic diagram of another retrieval file record of the present invention.

Please refer to FIG. 1 , which is a schematic diagram of the attribute recording area of the present invention. As shown in the figure, the data schema of an attribute item is exposed. In FIG. 1 , the first row 11 stores the attribute number of each attribute, the second row 12 stores the attribute name of each attribute, and the third row 13 stores the associated attribute number of each attribute.

In Table 10 in Figure 1, the defined attribute names include: geographical terms such as Earth, Asia, America, Taiwan, Taichung, History, Canada, etc., which are listed in the second line 12 respectively, and are numbered sequentially as 0001-0007 as The attribute numbers are listed in the first row 11, and the associated attribute numbers in the third row 13 are used to list the affiliation between the attributes.

Examples are as follows:

In Fig. 1, the attribute Asia (attribute number 0002) is a part of the earth (attribute number 0001), so the associated attribute number of Asia is 0001;

The attribute America (attribute number 0003) is also a part of the earth (attribute number 0001), so the associated attribute number of America is also 0001;

The attribute Taiwan (attribute number 0004 is part of Asia (attribute number 0002), so the associated attribute number of Taiwan is 0002;

The attribute Taichung (attribute number 0005) is part of Taiwan (attribute number 0004), so the associated attribute number in Taichung is 0004;

The attribute Canada (attribute number 0007) is a part of America (attribute number 0003), so the associated attribute number of Canada is 0003.

However, in the two attribute items of attribute earth and history, there is no record of the associated attribute number, which means that there is no other attribute that can cover it.

The assignment of the above-mentioned association attribute number is mainly to structure the association between the data, so as to facilitate the structure and search of the data.

In this attribute storage step, the defined attribute item exists in a specific form, which is mainly achieved by establishing an attribute record area as shown in Table 10. Every time an attribute item is created, its attribute name, attribute number and associated attribute The number (item as shown in Figure 1) is stored in the attribute record area, where the attribute name is actively input when using the defined attribute, and the attribute number is automatically generated by the attribute record management unit in the attribute record area. The principle is Each attribute number must be unique and must not overlap with the numbers of other attribute items. The easiest way is to mark them sequentially with serial numbers according to the order of creation.

As for the associated attribute number, the user searches for and records the relevant attribute item according to the previous existing attribute item.

In the file storage step, a file recording area is created for execution. The records in the file recording area include: file number, storage location and attribute number attached to the stored data file, among which:

The file number is organized for each stored file, which is the same as the attribute number. The file number is used for identification, as long as it is unique and not repeated.

The storage location is mainly to mark the storage location of the file. Assuming that the computer system is used to implement this method, the storage location can be marked with the name of the disk drive, the path and the file name. As shown in Figure 2, the storage of each file data The location is saved with the drive with path and file name respectively.

The attribute number is defined by the user actively. In addition to storing the attribute recording area, the file itself is also stored in the file recording area along with the data.

Please refer to Fig. 2, which is a schematic diagram of the file recording area of the present invention. As shown in the figure, the table 20 in Fig. 2 is for storage as a file, wherein the first row 21 can record the file number, and the second row 22 The location where the file is stored is recorded, and the third line 23 records the associated attribute number of the file.

When saving a file, the user can select or define at least one attribute and save this with the file. As shown in Table 20 in Figure 2, the file record management unit will create at least one file record corresponding to the file. and a record for that attribute.

A file, its file number is A000025 (the first line 21), the storage location is C:\Document\Article.doc (the second line 22), and it is defined by the three attribute items of Taichung, History and Canada, so Table 20 There are three documents with file number A000025 included. In these three pieces of data, except for their associated attribute numbers (23 in the third row) which are 0006, 0005, and 0007, the rest are the same.

There is another file with the file number A000030 (the first line 21), and the storage location is D:\Person\Report.xls (the second line 22), which is only defined by the attribute Taiwan, so there is only one file number in Table 20 For the data of A000030, its associated attribute number (23 in the third row) is 00004.

There is another file with the file number A000035 (the first line 21), and the storage location is E:\Readme.txt (the second line 22), which is only defined in the attribute table, so there is only one file number A000035 in Table 20 , its associated attribute number (23 in the third line) is 0005.

Since the data file may change the attribute due to modification of the content, the user must increase or decrease the attribute number content in the file recording area. If the user deletes an attribute, the corresponding file record will be removed from the table 20; on the contrary, if the user adds an attribute, the table 20 also needs to add a corresponding data.

The following compares Figure 2 and Figure 3 for illustration. In the storage content shown in Figure 2, the file number is A000030, and the storage location is in D:\Person\Report.xls. The associated attribute number was originally only Taiwan (0004 ). If other attribute definitions can be added after the data file is modified, it is only necessary to add a record of related attributes to the data (as shown in Figure 3), then the data is not only associated with Taiwan to form an attribute , is also associated with the history (0006) attribute. Therefore, a record of file number A000030 and associated attribute number 0006 will be added to Table 20, as shown in FIG. 3 .

On the contrary, if the above-mentioned data is deleted from the table 20 shown in FIG. 3 , then the data file is no longer associated with the attribute item of history.

It can be seen from the above description that the present invention realizes the principle and purpose of data classification. When the user desires to search for data from Table 10 and Table 20, the retrieval methods include:

1. Designation step: the user assigns the attributes to be designated;

1. Retrieve attributes step: check out the attributes that meet the specified conditions in the attribute recording area of Table 10;

A step of retrieving associated attributes: check out the associated attributes related to the designator in the third line 13 of the attribute recording area in Table 10;

1. Retrieve the file step associated with the specified attribute: go to the file record area of Table 20 to find the data file associated with the specified attribute;

A step of retrieving the files associated with the associated attribute of the specified attribute: Go to the file record area of Table 20 to find the data files associated with the associated attribute of the specified attribute.

The aforementioned designation steps are performed by the user, and the feasible designation methods include the following two:

1. Browse the attribute record area data in Table 10, and specify the attribute: the storage form of the attribute record area is very easy to browse and analyze, the main reason is that each record includes the attribute number and the associated attribute number, as shown in Table 10 in Figure 1 Take the content as an example. There are seven attribute items in total. If you filter out two items with no related attributes first, that is, there are only two attribute items of earth and history. If you analyze the attribute item of earth, you can find that only America and Asia The associated attribute of is the earth, so it is necessary to select only for Asia and America. If, when making a selection for Asia, only the associated attribute of Taiwan is Asia, so people can directly specify Taiwan as the specified attribute for retrieval. This step-by-step option method can quickly find relevant attributes.

2. One-by-one comparison: specify an attribute item and compare it one by one with the attribute items stored in the attribute recording area in Table 10. With the processing speed of the current computer, specify an attribute item and compare it one by one with all the stored attribute items in the attribute recording area Matching is so quick and easy to do that mechanical comparisons like this one can be done by a computer. It only needs to select some specific attributes, and use the computer to conduct a full-text search to find some similar or identical attribute items, and then cooperate with the judgment of each attribute item and its associated attributes to effectively narrow the search scope and quickly detect required materials.

In the aforementioned specifying steps, as long as the attributes are specified, the relevant files can be easily found from the file recording area. Taking the storage content in Table 20 in Figure 2 as an example, if the user refers to the attribute of Taichung, the file recording area can Two data files with file numbers A000025 and A000035 (as shown in Figure 4) were found in the .

After completing the specified steps, the system will execute the retrieval steps of attributes and data files. For example, if the user specifies the attribute America, its attribute number is 0003, and then in In the step of retrieving associated attributes, the attribute Canada whose associated attribute number is 0003 will be found in the attribute record area, and in the step of retrieving files associated with specified attributes, it will be found in the file recording area that the associated attribute number is 0003 files, and finally in the step of retrieving the files associated with the specified attribute, find out the data file whose associated attribute number is 0007 (Canada) in the file record area (as shown in Figure 5).

Through the aforementioned steps, the user can quickly and accurately find the data file with the specified attribute, and at the same time, other data files related to the data file will also be checked out for the user's reference.

And when more attributes are specified by the user, after intersection or union processing, the scope of retrieved data will be smaller and more accurate. For example, the theme of a file talks about the trade import and export situation between Taiwan and Canada in the 1990s. For this theme, the user will easily specify four attributes such as 1990, Taiwan, Canada and trade, and the file that specifies the attribute of Taiwan can be There are 20 files, and there may be 15 files that specify the attribute of Canada. After the logical intersection operation, it is possible to specify both Taiwan and Canada. There may be only 5 files left. If the attribute of trade is specified, it is likely that only Next 2 files. It can be seen that, through simple logical operations, the desired file can be found more accurately.

To sum up, it should be known that the present invention relates to a management and retrieval method of a dynamic attribute database, which is mainly a management and retrieval method that the user actively defines data into multiple different attributes to quickly and accurately find out the data, so the present invention In fact, it is full of novelty, progress, and can be used in the industry. It should undoubtedly meet the requirements for patent application, and apply for an invention patent in accordance with the law.

However, the above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention, that is, all changes and equivalent changes made according to the shape, structure, characteristics and spirit described in the patent scope of the present invention Modifications should be included in the patent application scope of the present invention.

Claims (26)

1, a kind of dynamic attribute Quest Central For Databases search method is characterized in that step comprises:

A. attribute data is stored to a first record area, wherein this attribute data includes the subordinate relation between attribute and attribute, makes data be able to structuring;

When b. storing data archives, can define at least one and this profile associated attributes by the user;

The archives material that c. will comprise the incidence relation between attribute and profile is stored to a second record area.

2, dynamic attribute Quest Central For Databases search method as claimed in claim 1 is characterized in that: among this step a., each attribute data includes an Attribute Recognition sign indicating number in the first record area, and is subordinated to the subordinate relation identification code of this attribute.

3, dynamic attribute Quest Central For Databases search method as claimed in claim 1, it is characterized in that: among this step a., each pen attribute data includes an attribute number, a Property Name and relating attribute numbering in the first record area, and wherein this relating attribute numbering is the attribute number that is subordinated to the attribute of this attribute for.

4, dynamic attribute Quest Central For Databases search method as claimed in claim 1 is characterized in that: in this step c, each archives material includes the identification code of a profile identification code and each relating attribute in the second record area.

5, dynamic attribute Quest Central For Databases search method as claimed in claim 1, it is characterized in that: in this step c, each archives material includes a Docket No., an archival location and relating attribute numbering in the second record area, and wherein this relating attribute is numbered an attribute number that is associated with the attribute of these archives.

6, dynamic attribute Quest Central For Databases search method as claimed in claim 1 is characterized in that: among this step b., but user's form a social stratum move the attribute that is stored in the second record area.

7, dynamic attribute Quest Central For Databases search method as claimed in claim 1 is characterized in that: among this step b., use just can be carried out a text searching and use the attribute of locating in the second record area.

8, dynamic attribute Quest Central For Databases search method as claimed in claim 1 is characterized in that: among this step b., the user can define a new attribute with the method that comprises the following step;

B1. define the Property Name of a new attribute by the user;

B2. allow the user to specify any already present attribute to be subordinated to this new attribute; And

B3. according to the information of step b1. and b2. gained, set up a data corresponding to this new attribute in first record area.

9, dynamic attribute Quest Central For Databases search method as claimed in claim 1 still includes the following step:

D. after the user defines an attribute, will do a tabulation to profile that should attribute, with as response.

10, dynamic attribute Quest Central For Databases search method as claimed in claim 9 is characterized in that: this steps d. in, but user's form a social stratum move the attribute that is stored in second record area, to define this attribute.

11, dynamic attribute Quest Central For Databases search method as claimed in claim 1 still includes the following step:

D. after the user defined the attribute of at least one logic association, the profile that will meet this attribute logic association was done a tabulation, with as responding.

12, dynamic attribute Quest Central For Databases search method as claimed in claim 11, it is characterized in that: this steps d. in logic association be the connection collection of more than one attribute, and the profile that meets this attribute logic connection also is the profile that definition has the interior all properties of this connection collection.

13, a kind of dynamic attribute document library system is characterized in that including:

One first record area can be for storing attribute data, and wherein each notes record stores an attribute, and selectivity stores the information that can describe subordinate relation between this attribute and other attributes, can be understood the structure between descriptor attribute by this information; And

One second record area can supply the save File data, and wherein each notes record definition one profile and is subordinated to the attribute of this profile.

14, dynamic attribute document library system as claimed in claim 13, it is characterized in that: when a profile has attribute more than a subordinate, then will have many records corresponding to these single data archives in this second record area, wherein each notes record defines an attribute that is subordinated to this profile respectively.

15, dynamic attribute document library system as claimed in claim 13, it is characterized in that: each the notes record in the first record area includes an attribute number, a Property Name and relating attribute numbering, and wherein this relating attribute is numbered an attribute number that is subordinated to this attribute.

16, dynamic attribute document library system as claimed in claim 13 is characterized in that: each the notes record in the second record area includes a Docket No., an archival location and relating attribute numbering, wherein this relating attribute number definition one attribute.

17, dynamic attribute document library system as claimed in claim 13 is characterized in that: but user's form a social stratum move the attribute that is stored in second record area, to define an already present attribute.

18, dynamic attribute document library system as claimed in claim 13 is characterized in that: the user can carry out a text searching to locate the attribute in the second record area.

19, dynamic attribute document library system as claimed in claim 13 is characterized in that: the user can and after specifying any already present attribute to be subordinated to this new attribute, should be stored in the first record area by new attribute in the Property Name of definition one new attribute.

20, dynamic attribute document library system as claimed in claim 13 is characterized in that: but user's form a social stratum move the attribute that is stored in second record area, to define an already present attribute.

21, dynamic attribute document library system as claimed in claim 13 is characterized in that: behind the attribute of at least one logic association of user's definable, the profile that will meet this attribute logic association is done a tabulation, with as responding.

22, dynamic attribute document library system as claimed in claim 21 is characterized in that: this logic association is the connection collection for more than one attribute, and the profile that meets this attribute logic association also is the profile that definition has the interior all properties of this connection collection.

23, a kind of dynamic attribute Quest Central For Databases search method is characterized in that step includes:

A. allow user's defined attribute;

B. allow the subordinate relation between user's defined attribute and attribute;

C. allow the user to select at least one attribute, and it is assigned to each profile; And

D. allow the user to obtain profile with attribute.

24, dynamic attribute Quest Central For Databases search method as claimed in claim 23 is characterized in that: d. comprises the subordinate relation that allows between user's dependency and moves attribute.

25, dynamic attribute Quest Central For Databases search method as claimed in claim 23 is characterized in that: d. comprises the permission user and carries out search according to the attribute that is designated to profile.

26, dynamic attribute Quest Central For Databases search method as claimed in claim 23 is characterized in that: d. comprises the permission user and carries out search according to the logic association of attribute.

Images