(Please refer to the following article: Oracle 12c In-Memory Database is Out
- Hardly Anybody Notices for update on Oracle 12c databases)
Contemporary large servers are routinely configured with 2TB of RAM. It is
thus possible to fit an entire average size OLTP database in memory directly
accessible by CPU. There is a long history of academic research on how to
best utilize relatively abundant computer memory. This research is becoming
increasingly relevant as databases serving business applications are heading
towards memory centric design and implementation.
If you simply place Oracle RDBMS's files on Solid State Disk, or configure
buffer cache (SGA) large enough to contain the whole database, Oracle will
not magically become an IMDB database, nor it will perform much faster. In
order to properly utilize memory, IMDB databases require purposely
architected, confi... (more)
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 databa... (more)
Latest database related announcements from major vendors like Oracle and IBM
enable radical shifts in the way we design OLTP/OLAP databases and
applications. It is now possible to serve both OLTP and analytical needs from
the same database. Traditional database and application design processes
should be modernized to fully utilize new capabilities.
Contemporary corporate databases are roughly classified as either OLTP or
OLAP - analytical ( Data Marts, Data Warehouses ).
OLTP physical database design implies tables tied together via relationships
to describe business process. H... (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)
Data processing power is likely to continue growing. Are contemporary IT
development methods, processes and procurement practices properly positioned
to take advantage of increasing capabilities?
CPU/Memory/Storage can today be provisioned in a few clicks. Limitations
presented by processing power and physical infrastructure will continue to be
of less importance, as was the case in the past.
We are gradually coming close to a situation where constraints determining
present corporate IT standards are not an issue any more. For example, it is
current practice that OLTP and analyti... (more)