Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2002-08-23
2004-02-10
Mizrahi, Diane D. (Department: 2175)
Data processing: database and file management or data structures
Database design
Data structure types
C709S219000
Reexamination Certificate
active
06691117
ABSTRACT:
FIELD OF THE INVENTION
The present invention relates to database systems and, more particularly, to reducing the total cost associated with maintaining one or more database systems.
BACKGROUND OF THE INVENTION
Inevitably, companies that invest in computer systems discover that the cost of owning a computer system is far greater than the price of the initial hardware and software purchases. Even relatively small computer systems, consisting of a handful of workstations networked together, frequently encounter problems that can consume an exorbitant amount of time and money. To prevent such problems, and to address such problems when they occur, many companies hire full time information service (IS) professionals. Frequently, the size of a company's in-house IS department grows until it consumes a disproportionate amount of the company's resources and profits.
The magnitude of the expenses associated with maintaining a computer system is due in part to the fact that most computer systems are composed of numerous layers of general purpose components, even though the actual use of all layers is directed to a single specific application. For example, a company may purchase a computer system for the sole purpose of handling the company's accounting. However, the actual workstations purchased for this purpose will typically be general purpose machines that provide all of the hardware services required to be able to handle any application. Many of these services are completely irrelevant for the actual use to which the machine will be directed. For example, the machines may come equipped with built-in “three-dimensional” sound capabilities that will never be utilized while the machines are used for accounting.
The general purpose machines that are to implement the accounting system will typically come installed with a general purpose operating system. Similar to general purpose hardware, general purpose operating systems attempt to provide services to address all possible needs of all possible types of software. For example, general purpose operating systems employ complex I/O techniques for handling I/O intensive applications, complex techniques to support computation intensive applications, and complex communication techniques to support communication intensive applications. Many of those services may not be required by the specific context, such as accounting, in which the operating system may actually be used.
Typically, the hardware and operating system would not be the only “general purpose” components that would be used to implement an accounting system. For example, the accounting system may be configured to interact with a database system. Typically, the database system would provide services to address all possible uses of the database system, and not just those required by the accounting program. Given the diverse environments in which database systems may be used, the services actually required by any given application may be a small fraction of all the services provided by the database system.
In the accounting example given above, each of the general purpose components tends to be complex and, consequentially, difficult to manage. When many of such components are thrown together in a single system, the complexity increases exponentially, thus necessitating the significant after-the-purchase computer system maintenance expenses that most companies have encountered.
In the context of database systems, the complexity of the general purpose database system combined with the complexity of the general purpose operating system with which the database system interacts 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.
Based on the foregoing, it is clearly desirable to provide a computer system that employs features that reduce the cost of maintaining the database system without having a negative impact on the ability of the computer system to perform its intended purpose. 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
A database system that incorporates numerous features that reduce the total cost of maintaining the database system is provided. That database system includes a database appliance that executes a database server on a platform that includes a special purpose operating system specifically tailored to the services required by the database server. According to certain aspects, the hardware may also be specially tailored to the services required by the database server. According to one aspect of the invention, the database appliance configures itself by detecting the environment in which it resides and setting operational parameters based on the detected environment. The configuration metadata of all components of the system are stored in a centralized repository which itself may reside external to the system.
According to another aspect, both the database server configuration and the operating system configuration are managed by a remotely located integrated management console, which interacts with and configures the system at the database system level, the operating system level and, according to one embodiment, at the hardware subsystem level. Backup management may also be performed remotely. The remote components, such as the integrated management console, the backup server, and the configuration repository, may communicate with the system through a local area network or wide area network (e.g. the Internet), including through a dial-up connection.
Using the features described herein, numerous benefits are achieved. Specifically, the ease of using a database system is increased by making the database system easier to set up, manage, and service. The total cost of ownership is reduced by avoiding the costs associated with operating systems and middleware (e.g. web server), by providing remote management, by reducing down time, and by protecting the user's investment. Better performance is achieved through the use of a slim lined operating system, by tuning the database system for a dedicated application, and through the use of custom hardware. The availability of the database system is increased by avoiding problems associated with direct user access to the operating system, and through the use of RAID and/or network attached storage.
REFERENCES:
patent: 5502728 (1996-03-01), Smith, III
patent: 5606693 (1997-02-01), Nilsen et al.
patent: 5668986 (1997-09-01), Nilsen et al.
patent: 5701471 (1997-12-01), Subramanyam
patent: 5819066 (1998-10-01), Bromberg et al.
patent: 5838918 (1998-11-01), Prager
patent: 5852818 (1998-12-01), Guay et al.
patent: 5924097 (1999-07-01), Hill et al.
patent: 5978811 (1999-11-01), Smiley
patent: 6016394 (2000-01-01), Walker
patent: 6044367 (2000-03-01), Wolff
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: 6223205 (2001-04-01), Harchol-Balter et al.
patent: 6341303 (2002-01-01), Rhee et al.
patent: 6598173 (2003-07-01), Sheikh et al.
patent: 6604207 (2003-08-01), Sheikh et al.
patent: 6606660 (2003-08-01), Bowman-Amuah
patent: 6615253 (2003-09-01), Bowman-Amuah
patent: 0 274 406 (1988-07-01), None
patent: 0 803 808 (1997-10-01), None
Hyuck Yoo, et al., “Operating System Performance and Large Servers,” Proceedings of the 6thWorkshop on ACM SIGOPS European workshop: Matching operating systems to application needs, 1994, p. 166-171.
Achutha Raman R et al., “PARDISC: A Cost Effective Model for Parallel and Distributed Computing,” Aug. 1996, pp. 451-45
Banerjee Niloy
Bhaduri Pari
Chen Jane
Doherty C. Gregory
Ellison Lawrence J.
Hickman Brian D.
Hickman Palermo & Truong & Becker LLP
Mizrahi Diane D.
Oracle Corporation
LandOfFree
Special purpose operating system for executing 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 Special purpose operating system for executing a database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Special purpose operating system for executing a database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3341835