( For latest information on Oracle 12c database update please refer to the
following article: Oracle 12c Database and How It Relates to SAP Hana )
RDBMSs are stable and mature products. While there is nothing radically new
on horizon that would challenge Codd's relational theory and related advances
in data processing there are some developments that force established vendors
like Oracle to come up with new features and products.
Column Stores and Oracle
Column store concept has been around for quite a while. Vendors like HP
Vertica grabbed some market share in data warehousing segment with their
column store, MPP databases. Oracle Exadata is offering Hybrid Columnar
Compression - solution that modifies Oracle standard row based storage
(NSM, or row-major) into proprietary format that is probably closer to PAX
(as opposed to DSM) classification. Rows of data are reo... (more)
Amazon Web Services EC2 Cloud is full scale public data center offering
services that are in many aspects far ahead of ancient practices present in
regular IT environments. Fast provisioning and virtually unlimited scale make
old fashioned server procurement and installations look like what they are -
past century's practices. This article will not deal with usual objections to
cloud computing revolving around change management difficulties ( how to
incorporate new environment into the existing IT infrastructure ), security,
reliability, performance etc. since we think that all t... (more)
Most of enterprise class shops today run their Oracle databases on either
HP-UX, AIX or Sun OS operating systems. Is it possible to move these
databases to the public cloud, and, if so, who are providers who can help
with such a move?
Public cloud services are closely related to virtualization i.e. usage of
various flavors of popular Virtual Machines (VMware, XEN). VMs are one of
major ingredients giving cloud services such great characteristics as
scalability, on-demand instant provisioning and deprovisioning of resources.
Virtual Machines are able to run many guest operating s... (more)
Oracle database upgrades are a stressful exercise. Normally you need to
backup production database, upgrade database software, then run database
scripts that will upgrade dictionary. Once it is all done and success is
confirmed you can start using upgraded database. If something goes wrong then
you rely on backups to restore to a previous state. In other words, there
is complete dependency on backups and restore success if things go wrong.
AWS gives us possibility to quickly and cheaply create new database instances
where an upgrade can be tested. We can also instantly create com... (more)
AWS is built on commodity hardware and it is software virtual machine based.
AWS documentation states that:
It's inevitable that EC2 instances will fail, and you need to plan for it.
As a rule of thumb, you should be a pessimist when designing architecture for
That means that putting your Oracle databases on AWS cloud should be
accompanied with carefully thought out fault tolerance and DR procedures.
It is likely that:
An AWS instance running Oracle database will fail
Some of volumes ( EBS storage ) attached to an instance running Oracle
database will fail, i.e., you wi... (more)