Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-05-31
2004-09-21
Corrielus, Jean M. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
06795830
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates to accessing databases over a network such as the Internet, and, in particular, to increasing efficiency by hosting data server functionality and data storage functionality on separate devices.
BACKGROUND OF THE INVENTION
The complexity of a general purpose database system combined with the complexity of a general purpose operating system with which the database system interacts on a general purpose computer is typically sufficient to require employment of a full-time database administrator (DBA). It is the responsibility of the DBA to grapple with the complexity of the database system, the operating system, and the interactions between them, so that the other database users can take advantage of the database system without being exposed to underlying complexity. Unfortunately, employing a full-time DBA makes ownership of a useful database system an expensive option that may be outside the means of the small to medium sized enterprise.
Maintaining an in house computer system to host a database and Website is also an expensive undertaking even when the enterprise can afford a DBA or small team of information services (IS) professionals. Most computer equipment requires special air-conditioning and power supplies that are expensive to construct in a facility. The equipment itself is expensive and prone to become obsolete as new hardware devices are developed. Even if the equipment is leased, the facility costs remain, and the transfer to upgraded equipment may put a database out of service and consume considerable amounts of skilled IS labor.
One of the costs contributing to a network of database devices is the expense and complexity of each device. A conventional database server device includes a database server and a mass storage subsystem for storing the database files. The database server processes interact with the storage system, adding to the complexity of the database server and the database server device. This complexity both adds to the cost of the server device and decreases the reliability of the entire database on the network. In addition, this requirement to support the data files of the database forces the minimum database device configuration to include sufficient mass storage to support typical database applications adding to the cost of the system, also adding to the cost of the server device. Also because the device must support database server processes as well as storage functions, the device hardware and configuration can not be simultaneously optimized for both server functions and storage functions. Furthermore, including mass storage for the data files on the device inhibits utilization and sharing high-performance storage systems that may become available on the market after the database server device is procured.
Based on the foregoing, it is clearly desirable to provide a computer system that employs features that reduce the cost of maintaining the hardware and software of the database system and the Internet presence. It is further desirable to decrease the complexity of computer systems, and to provide management techniques that allow companies to reduce the size and cost of their in-house IS departments.
SUMMARY OF THE INVENTION
The embodiments of the disclosed techniques reduce the costs to small and medium sized enterprises of establishing and maintaining one or more databases using a network, such as the Internet. According to one aspect of the invention, a database server appliance includes a processor; a database server process, a special purpose operating system and non-volatile storage. The database server process persistently stores data files for the database on a second device connected to the database server appliance over a network. The special purpose operating system has features and configuration that are dictated by the database server and supporting components. The non-volatile storage is sufficiently large to store and execute instructions that cause the processor to perform as the database server process and the special purpose operating system and not sufficiently large to store all data files in the database.
According to another aspect of the invention, techniques for distributing database functions in a system of database devices includes performing database management tasks for a database on a first device connected to a network. The first device is designated a database host. Data file storage and retrieval tasks for the database are sent to a second device connected to the network. The second device is designated an off-host storage device.
These techniques increase reliability of the database on the network by insulating database server processes from the storage system. These techniques also allow sharing of a high performance storage system among multiple database server appliances.
REFERENCES:
patent: 5606693 (1997-02-01), Nilsen et al.
patent: 5625816 (1997-04-01), Burdick et al.
patent: 5668986 (1997-09-01), Nilsen et al.
patent: 5809237 (1998-09-01), Watts et al.
patent: 5819066 (1998-10-01), Bromberg et al.
patent: 5838918 (1998-11-01), Prager et al.
patent: 5848243 (1998-12-01), Kulkarni et al.
patent: 5890147 (1999-03-01), Peltonen et al.
patent: 5978811 (1999-11-01), Smiley
patent: 6016394 (2000-01-01), Walker
patent: 6026433 (2000-02-01), D'Arlach et al.
patent: 6044367 (2000-03-01), Wolff
patent: 6049787 (2000-04-01), Takahashi et al.
patent: 6052720 (2000-04-01), Traversat et al.
patent: 6075938 (2000-06-01), Bugnion et al.
patent: 6075939 (2000-06-01), Bunnell et al.
patent: 6148410 (2000-11-01), Baskey et al.
patent: 6151601 (2000-11-01), Papierniak et al.
patent: 6154738 (2000-11-01), Call
patent: 6170061 (2001-01-01), Beser
patent: 6182111 (2001-01-01), Inohara et al.
patent: 6185587 (2001-02-01), Bernardo et al.
patent: 6219680 (2001-04-01), Bernardo et al.
patent: 6263352 (2001-07-01), Cohen
patent: 6286038 (2001-09-01), Reichmeyer et al.
patent: 6304886 (2001-10-01), Bernardo et al.
patent: 6308188 (2001-10-01), Bernardo et al.
patent: 6313835 (2001-11-01), Gever et al.
patent: 6330575 (2001-12-01), Moore et al.
patent: 6341303 (2002-01-01), Rhee et al.
patent: 6345294 (2002-02-01), O'Toole et al.
patent: 6381324 (2002-04-01), Shaffer et al.
patent: 6401085 (2002-06-01), Gershman et al.
patent: 6484150 (2002-11-01), Blinn et al.
patent: 6487547 (2002-11-01), Ellison et al.
patent: 6487594 (2002-11-01), Bahlmann
patent: 6519571 (2003-02-01), Guheen et al.
patent: 6519640 (2003-02-01), Hattori et al.
patent: 6564261 (2003-05-01), Gudjonsson et al.
patent: 6580904 (2003-06-01), Cox et al.
patent: 6611834 (2003-08-01), Aggarwal et al.
patent: 6629135 (2003-09-01), Ross, Jr. et al.
patent: 6636588 (2003-10-01), Kimura et al.
patent: 2002/0035584 (2002-03-01), Scheier et al.
patent: 0 274 406 (1988-07-01), None
patent: 0 803 808 (1997-10-01), None
patent: 1 056 022 (2000-11-01), None
Yoo et a. (Operating System Performance and Large Servers), 1994, ACM Press, ISBN: 1-23456-789-0, pp. 166-171.*
Hyuck Yoo et al. Operating system performance and large servers, Proceedings of the 6th workshop on ACM SIGOPS European works application needs, Sep. 1994, pp. 166-171.*
Achutha Raman R., et al., “PARDISC: A Cost Effective Model for Parallel and Distributed Computing, ” High Performance Computing, 1996, Proceedings 3rdInternational Conference, Dec. 19-22, 1996, IEEE, Catalog No.: 96TB100074, pp. 451-456.
Mary Fernandez, et al., “Declarative specification of Web sites with Strudel,” The VLDB Journal (2000), pp. 38-55.
Banerjee Niloy
Rocha Michael
So John John E.
Brokaw Christopher J.
Corrielus Jean M.
Hickman Palermo & Truong & Becker LLP
Oracle International Corporation
To Baoquoc N
LandOfFree
Techniques for providing off-host storage for a database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Techniques for providing off-host storage for a database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Techniques for providing off-host storage for a database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3207922