Oracle9i Database

By Timothy Dyck  |  Posted 2001-08-20 Print this article Print

Oracle9i Database

Organizations that want to tightly manage or consolidate information storage and those developing complex database applications will find the highly flexible, programmable Oracle9i Database a good fit. However, its complexity and high cost will be drawbacks for those that just need a database for basic transaction processing and reporting.

SHORT-TERM BUSINESS IMPACT // New database administration features, such as the ability to change table definitions without making that table inaccessible or to redefine more server settings without a restart, will make day-to-day management of Oracle simpler.

LONG-TERM BUSINESS IMPACT // Oracles much-improved clustering technology will enable some organizations to take advantage of multiserver database clusters instead of buying very large, extremely costly servers.

Very rich feature set, including Java application server, content and document management, and, new with this release, OLAP capabilities; clustering features support ERP applications; very strong resource governor and access control features.

OLAP functionality introduces a new set of OLAP APIs; OLAP features not available on Linux; Standard Edition lacks key database features such as intraquery parallelism; high cost.

Oracle Corp., Redwood Shores, Calif.; (650) 506-7000;

Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel