Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Oracles New Edge

    By
    Timothy Dyck
    -
    August 20, 2001
    Share
    Facebook
    Twitter
    Linkedin

      Oracle Corp.s corporate strategy is to make its database be all things to all people, an approach that has produced the Swiss Army Knife of data management. In eWeek Labs tests of Oracle9i Database, we found a database that will probably do everything organizations ask of it and likely more besides. However, its also a big, complex product that requires highly trained administrators, high-end hardware and a fat wallet, and we found mixed levels of maturity and quality from component to component in the product.

      Organizations that just want a relational database will find that IBMs, Microsoft Corp.s or Sybase Inc.s databases are less expensive and offer more functionality when the standard editions of all three databases are compared. At the high end, IBMs DB2 offers comparable programmability, extensibility and SQL engine features to what Oracle9i provides.

      Oracle9i Database continues to be not just an object relational database but also includes file and document management, e-mail, Web server, message queuing, and Java 2 Enterprise Edition application server features.

      This release also gains important performance and fault-tolerance improvements for customers using Oracle database clusters and management changes that ease administration and provide greater data safety.

      Oracles database clustering is unique on the market in that it supports complex packaged applications such as SAP AGs enterprise resource planning suite (just a few SAP applications run on IBMs DB2 clusters, the only other sophisticated database clustering option on the market).

      Oracle9i Database also includes strong data analysis capabilities through the addition of relational and multi- dimensional OLAP (online analytical processing), as well as data mining. IBM and Microsoft have already included OLAP capabilities in DB2 and Microsoft SQL Server databases, respectively.

      Unfortunately, both the new relational OLAP and data mining features use a new Java-based API, so they will only be useful in new applications designed for Oracle9i. Oracle needs to bite the bullet and support Microsofts OLAP APIs because theyre the ones that data analysis software vendors have moved en masse to support.

      All for One and One for All

      Overall, the Oracle9i package provides a very rich feature set (more than any other database vendor provides in one product); has a fairly consistent management strategy; and is oriented toward thin-client HTML application deployment through its XML (Extensible Markup Language), XSL (Extensible Stylesheet Language) and Java-oriented design.

      The downside to the Oracle strategy is leaving behind a best-of-breed approach for the consistency and centralized management of an integrated suite, a trade-off Oracle CEO Larry Ellison freely acknowledges in his speeches.

      In tests, we found quality and maturity varied substantially from poor (the e-mail server) to fair (the message queuing features, Java application server features and Internet File System component—we looked at IFS in detail in our Jan. 1 Oracle8i Release 3 review) to good (its administration tools and XML query features, which are very simple to use and allow automatic transformations using XSL style sheets) to excellent (the database itself).

      In particular, Oracle9is database features that stand out as first-rate are its fine-grain access control features, flexible resource governor for mixed transactional and reporting workloads, auditing and data recovery features, object-oriented design features, and overall programmability.

      For example, using Oracles access control features, we could set security access policies down to row and column granularity without having to add custom views for this purpose, as is necessary with DB2 and Microsoft SQL Server. Sybase Adaptive Server Enterprise added this feature with its 12.5 release, which shipped in June.

      Oracle9i comes in a Standard Edition, which costs $15,000 per CPU or $300 per named user, and an Enterprise Edition, which costs $40,000 per CPU or $800 per named user. We tested the Enterprise Edition.

      The Enterprise Edition also has a number of options (at extra cost) for database clustering, data partitioning, OLAP, data mining, geospatial (mapping) data support, additional security support, and extra management and performance tuning tools.

      Oracle9i first shipped in mid-June for Solaris, then in the following eight weeks shipped on Compaq Computer Corp.s Compaq Tru64 Unix, Hewlett-Packard Co.s HP-UX, IBMs AIX and OS/390, and Linux. We tested the Linux edition. (The OLAP features arent available on the Linux version now, although they will be coming in a later update.) Windows support is due next month.

      Oracle9is pricing has dropped from Oracle8is per-CPU-megahertz model but remains the most expensive choice among its competitors. This is particularly true at the lower end because Oracle Standard Edition is a gutted version of its big brother, lacking major features available to Enterprise Edition users. Competitors do provide these features at similar price points. Notably absent are most multi-CPU features, including parallel query, materialized views and fine-grained security, as well as the option to add OLAP, data mining and additional management tools.

      As a result, although Enterprise Edition is an excellent database, Standard Edition falls to the bottom of the pack when set beside its competitors.

      Keeping Data Safe

      Oracle9i adds a number of new or enhanced features to increase data safety and overall database uptime. One particularly striking feature is Oracles Log Miner, which let us go back through already committed SQL statements to undo past work, something normally not possible without doing a database restore. Oracle9i includes a new graphical tool that makes viewing the log much easier than in Oracle8i.

      Third parties such as Lumigent Technologies Inc.s Log Explorer provide this capability for Microsoft SQL Server, but wed like to see it provided directly by the other big database vendors.

      Oracles administration tools, fronted by its Enterprise Manager administration console (see screen, Page 47), have slowly but steadily improved over the years weve been using them and are now quite stable and usable.

      Oracle9i Database

      Oracle9i Database

      USABILITY

      B

      CAPABILITY

      A

      PERFORMANCE

      B

      INTEROPERABILITY

      B

      MANAGEABILITY

      C

      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; www.oracle.com/ip/deploy/database/9i/index.html?content.html

      Avatar
      Timothy Dyck
      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.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×