Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-02-26
2001-11-06
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
06314427
ABSTRACT:
FIELD OF THE INVENTION
This invention pertains to the field of computer implemented organizational systems, and more particularly to a method and apparatus for using an information model to organize an information repository into an extensible hierarchy of organizational information.
BACKGROUND OF THE INVENTION
Generally, information repositories hold a wealth and variety of information that can be accessed. Examples of information repositories include program files comprising a list of subroutines and/or variables used in the program, and databases comprising records. Information repositories can also be in non-automated form, such as library index cards comprising information like call numbers, publishers, and authors. In a small information repository, information can be relatively easy to decipher and organize. As is often the case, however, any useful information repository will contain and accumulate an infinite amount of information so that organizing the information in any useful manner becomes a difficult task. This problem can be demonstrated in an information repository such as a database.
Databases are a large and powerful resource of information in a society automated by computers and computer processes. A database is a repository of files containing records, where each record contains fields that are attributes of the record, and every record in the same file comprises the same fields. For example, records in a job database can comprise fields such as Position, Level, Company, Salary, Years of Experience, and Skills, each of which is an attribute of a job in the job database. In a more general sense, a database is also a collection of files containing records that are subject to the same set of operations for searching, sorting, recombining, and other functions.
Information in a database can be accessed by a custom program written for a particular application. For example, a program in a job placement application might display a list of all available jobs from a job database. This method of access to database information is limited, however, because it requires that such a program be customized for a particular use, language, and/or database, amongst other factors, which can involve a great deal of expertise, time, and expense. While this is oftentimes necessary, particularly where a database is highly integrated into an application and a user needs sophisticated functionality such as the ability to add, change, and delete database records, it can be overkill for a user who needs minimal access, such as when the user only needs to view database records.
For minimal use, a database can also be accessed by “querying” the database, which at the very least does not require the expertise, time, and expense of a custom program. A query is a specific set of instructions for the purpose of extracting data from a database based on one or more selection criterion. For example, if a user wants to see all jobs in a job database that pay more than $20,000, a query might read “(Salary>=$20,000)”. The query, which is written in commands comprehensible by the particular database being queried (eg., SQL), instructs a program to search the database for any and all records that satisfy the one or more selection criterion of the query. In the previous example, therefore, a program reads the Salary field of each record to determine if the value in that field is greater than or equal to $20,000. If the test fails, the program proceeds to test the next record. If the test passes, the program will extract that record from the database for processing, such as viewing or displaying. The result is a cost effective method of extracting information from a database tailored to a user's specific needs.
While creating queries is cost effective, it is not always efficient. Oftentimes, a user needs access to a specific set of records that requires a more complex query, such as when a user wants to see all of the available professional jobs that do not require computer programming skills. A query to obtain this information from a database might read “((isAvailable=TRUE) AND (Tech/Prof=TRUE) AND (skills<>computer) AND (job<>programmer))”. In a complex query, such as this one, the results can sometimes be uncertain, requiring the user to make several attempts at creating the query to produce the correct results. Another disadvantage of queries, simple or complex, is that they can result in wasted time and space in obtaining commonly used data, and in creating a litany of queries which produce the same results and/or erroneous results.
A need exists, therefore, for meaningful and easy access to information in an information repository that provides the detail of information available from a custom program without the time and expense of creating one, as well as the cost-effectiveness of querying an information repository without the uncertainties of results and the inefficiencies in obtaining them. In a more general sense, a need also exists for a means of meaningful and easy access to information an information repository that presents a user with a conceptual view of the information repository.
SUMMARY OF THE INVENTION
The invention described herein is an apparatus for accessing an information repository, comprising computer readable program code stored on computer readable media, where the computer readable program code comprises code for organizing information stored in the information repository into a hierarchy. The hierarchy comprises a hierarchy of a number of derived containers that are generated in conformance with an information model comprising a hierarchy of type-defined container definition nodes, each belonging to one of a number of container definition node types, where the types comprise organization-based container definition nodes. Each of the derived containers corresponds to one of the type-defined container definition nodes, represents a category of information in the information repository, and comprises contents. Furthermore, the invention described herein is a computer based method of accessing an information repository, comprising a computer creating a hierarchy of derived containers. The hierarchy comprises a hierarchy of a number of derived containers that correspond to type-defined container definition nodes of an information model comprising a hierarchy of type-defined container definition nodes, each belonging to one of a number of container definition node types, including attribute-based container definition nodes, value-based container definition nodes, and organization-based container definition nodes, and that correspond to categories of information stored in the information repository. The computer determines if a given one of the derived containers has been selected by a computer user, and upon selection of a given derived container, displays contents of the given derived container.
These and other important advantages and objectives of the present invention will be further explained in, or will become apparent from, the accompanying description, drawings and claims.
REFERENCES:
patent: 5815703 (1998-09-01), Copeland et al.
patent: 5870751 (1999-02-01), Trotter
patent: 6023703 (2000-02-01), Hill
patent: 6098072 (2000-08-01), Sluiman et al.
Goldman Jason D.
Lachelt David J.
Hewlett--Packard Company
Homere Jean R.
Robinson Greta
LandOfFree
Method and apparatus for using an information model to... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for using an information model to..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for using an information model to... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2582903