Querying databases using database pools

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

06775661

ABSTRACT:

BACKGROUND
This invention relates to querying databases.
A user at a client system may send a request for information to another system. The other system searches a collection of data for information satisfying the user's request and returns any found information to the client system. In a network environment, the client system may include a computer terminal, the other system may include a server, and the collection of data may include a database. In such a network environment, the server may store and maintain the collection of data or the collection of data may be a separate data repository, such as a data server.
SUMMARY
According to one aspect of the invention, querying databases includes receiving a query for information, the query including a common identifier for a plurality of collections of data and indicating whether a result of the query may include a null result, searching each of the collections of data for the information, and considering a speed of each of the collections of data in performing the searching.
According to another aspect of the invention, a system includes a file including information about collections of data included in a group of collections of data, each collection of data included in the group being associated with a common identifier. The system also includes a first mechanism configured to monitor if access to each of the collections of data is currently available and to determine a speed of each of the collections of data and a second mechanism configured to search the group in response to a query including the common identifier and to consider the availability and the speed of each of the collections of data in performing the search.
One or more of the following advantages may be provided by one or more aspects of the invention.
Grouping databases together in a common group or namespace can enable a user knowing only the common group or namespace to search multiple databases. Multiple databases in the common group or namespace can be searched transparently to the user and results can be returned to the user from any of the multiple databases. Results may be quickly located in the common group or namespace by searching the databases in the common group or namespace from fastest database to slowest database. Furthermore, if any of the databases included in the common group or namespace becomes unavailable for any reason, the other databases in the common group or namespace may still be searched and search results may still be provided to the user. In this way, a database pool can be provided with transparent reliability.
Other advantages and features will become apparent from the following description and from the claims.


REFERENCES:
patent: 5442791 (1995-08-01), Wrabetz et al.
patent: 5659746 (1997-08-01), Bankert et al.
patent: 5915250 (1999-06-01), Jain et al.
patent: 6195652 (2001-02-01), Fish
patent: 6269394 (2001-07-01), Kenner et al.
patent: 6282538 (2001-08-01), Woods
patent: 6334123 (2001-12-01), Ross et al.
patent: 6338055 (2002-01-01), Hagmann et al.
patent: 6397206 (2002-05-01), Hill et al.
patent: 6408291 (2002-06-01), Skeen et al.
patent: 6484184 (2002-11-01), Mizushina et al.
patent: 6507847 (2003-01-01), Fleischman
patent: 6516312 (2003-02-01), Kraft et al.
patent: 2002/0065925 (2002-05-01), Kenyon et al.
Dennis Shasha “Lessons from Wall Street: case studies in configuration, tuning, and distribution”, ACM SIGMOD Record, Proceedings of the 1997 ACM SIGMOD international conference on Management of data, vol. 26, Issue 2, 1997, pp. 498-501.*
Berchtold et al “Independent quantization: an index compression technique for high-dimensional data spaces”, Proceedings of the 16th International conference on Data Engineering, Feb. 29-Mar. 3, 2000, pp. 577-588.

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

Querying databases using database pools does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Querying databases using database pools, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Querying databases using database pools will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3320793

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