Big Data Consultant

Ranko Mosic

Subscribe to Ranko Mosic: eMailAlertsEmail Alerts
Get Ranko Mosic via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Ranko Mosic

( 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)

How to Move Your Oracle Databases to Amazon EC2 Cloud

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)

Enterprise Class Oracle Databases in the Public Cloud?

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 Faster and Safer in Amazon Web Services

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)

Building Enterprise Class Oracle Databases on Amazon Web Services

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 the cloud. 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)