| By Ranko Mosic | Article Rating: |
|
| October 24, 2011 04:07 PM EDT | Reads: |
7,029 |
Oracle database is a relational database management system that mostly complies with ACID transaction requirements ( atomicity, consistency, isolation, durability ). It means that each database transaction will be executed in a reliable, safe and integral manner. In order to comply with ACID Oracle database software implements fairly complex and expensive (in terms of computing resources, i.e., CPU, disk, memory) set of processes like redo and undo logging, memory latching, meta data maintenance etc. that make concurrent work possible, while maintaining data integrity. Any database transaction or even SELECT statement makes relational database systems perform tremendous amounts of work behind the scene, thus making it inherently slow and resource intensive.
Oracle is trying to address scalability and performance problem in a variety of ways:
- by introducing constant performance enhancements to the query optimizer
- Oracle RAC - Real Application Clusters based scale out ( much increased complexity with little practical value in terms of performance and functionality )
- appliances ( Exa* line of products - complex, unbalanced architecture, suboptimally utilized hardware, patched up and repackaged software )
All these attempt still feature performance and scalability bottleneck in shape of Oracle RDBMS and its shared-nothing, or assymmetric MPP ( in case of Exadata ) architecture.
Companies dealing with millions of users, huge volumes of data and needing great performance like Google could not use proprietary RDBMSs. They developed their own solutions, relying on utilizing commodity hardware and open source software. They developed software that can make thousands of Intel boxes behave like a single system that can process your query searching through petabytes of data in sub-second time. This could never be accomplished if they used standard RDBMS like Oracle. RDBMSs were not designed to deal with problems that Google is facing.
Data processing technologies that originated at Google or other places ( including direct Google research descendant Hadoop, NoSQL group of products, etc. ) parallelize work and distribute data over thousands of servers, relax ACID requirement so it now maybe becomes BASE (Basically Available, Soft state, Eventual consistency) i.e., they provide weaker consistency guarantees ( CAP theorem ), they loose relational data structure i.e. basically go back to flat files, or distributed, scalable hash tables. By relaxing, modifying or loosing some properties of RDBMs and optimizing to run on commodity hardware they were able to get results that are good enough in terms of data quality and consistency, while achieving great performance and sufficient accuracy for very basic transactions. Ironically many of these technologies are step backwards i.e. they will end up reinventing many RDBMS features as they mature ( Hadapt - Hadoop based relational database; Hive, Hbase ).
Oracle RDBMS has completely different purpose, i.e., it is targeted for corporate/business use where complex transactions must be accurately executed. Eventually consistent paradigm does not suffice here. While Oracle database can contain huge volumes of multi-media data, its main purpose is to store and concurrently process structured data sets relatively limited in size, for a limited number of concurrent corporate/business users.
Published October 24, 2011 Reads 7,029
Copyright © 2011 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Ranko Mosic
Ranko Mosic ( OCP ) is specializing in Oracle Database Administration work. He has more than 20 years of North American IT industry experience. His texts about Oracle database were published in various industry publications and his profile was published in Oracle Magazine. He can be reached at ranko.mosic@gmail.com
- Cloud People: A Who's Who of Cloud Computing
- How to Move Your Oracle Databases to Amazon EC2 Cloud
- Cloud Expo NY: Best Practices for Delivering Oracle Database as a Service
- Session Topics: 12th Cloud Expo / Cloud Expo New York
- Cloud Expo New York: Build Modern Business Applications
- Velocity Technology Solutions Introduces IBM Power Systems Universal Cloud Services at COMMON 2013
- Here Comes Oracle’s New Sparc Servers
- Cloud Expo NY: Fast-Track Your Transformation to Enterprise Private Cloud
- Cloud Business Solutions, Social Media, and Platform Systems of Engagement Market Shares, Strategies, and Forecasts, Worldwide, 2013 to 2019
- Cloud Expo New York: Ten Myths of Cloud Computing
- Research and Markets: Global Platform-As-A-Service Market Expected To Post Revenue of US$6.45 Billion in 2016 According To Latest Report
- Oracle Buys Tekelec
- Cloud People: A Who's Who of Cloud Computing
- Global Micro Servers Market (2013 - 2018), By Processor Type (Intel, Arm, Amd), Component (Hardware, Software, Operating System), Application (Media Storage, Data Centers, Analytics, Cloud Computing) & Geography (North America, Europe, Apac, Row)
- How to Move Your Oracle Databases to Amazon EC2 Cloud
- Cloud Expo NY: Best Practices for Delivering Oracle Database as a Service
- Session Topics: 12th Cloud Expo / Cloud Expo New York
- Cloud Expo New York: Build Modern Business Applications
- Red Hat Reinforces Java Commitment
- Five Steps Toward Achieving Better Compliance with Identity Analytics
- Velocity Technology Solutions Introduces IBM Power Systems Universal Cloud Services at COMMON 2013
- Here Comes Oracle’s New Sparc Servers
- Java Cryptography | Part 3
- Cavalry Rides into Oracle’s Java Suit
- AJAX World RIA Conference & Expo Kicks Off in New York City
- The Top 250 Players in the Cloud Computing Ecosystem
- Oracle SOA Suite
- A Review Of Oracle Application Server 10g
- An Introduction to Abbot
- Java Product Review — Oracle JDeveloper An IDE Worth a Second Look
- Cloud People: A Who's Who of Cloud Computing
- Red Hat Named "Platinum Sponsor" of Virtualization Conference & Expo
- Universal Middleware: What's Happening With OSGi and Why You Should Care
- Report From the Oracle/PeopleSoft Frontline: Alienating PeopleSoft
- Cloud Expo New York Call for Papers Now Open
- The Oracle-Sun Buddyfest: What's It All Mean?
























