Welcome!

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

Amazon recently added Oracle database hosting capabilities to its RDS service offering. You can rent an Oracle database related infrastructure in a pay-as-you-go fashion now. We are going to explore if corporations should be utilizing Amazon AWS Oracle Database related services (EC2, RDS ), how it should be used, where possible savings and potential trouble points are. With services like Amazon AWS it doesn't matter where your hardware and software physically is - it could be in a room next to you or in some other country. It is much easier and cheaper to procure and get new servers up and running. What's Really New? You swipe your credit card and get an Oracle database server up and running in half an hour. Sounds like magic, especially if you compare it to the weeks and months it normally takes to have an Oracle database server operational in an average enterprise ... (more)

Importance of Having DR Procedures

A recent BlackBerry outage is the nightmare for both RIM and its users. Nature and mass popularity of Blackberry service  make this particular outage highly visible. There are many other in-house outages we never hear about. Companies prefer to keep silent about them, if they can. The only insight we get into the poor state of DR procedures is in some public cases like this one, or from limited personal experience. In my Oracle database infrastructure consulting career I have seen several serious production outages and was part of a few data recovery efforts. Backups and DR proc... (more)

Oracle RMAN, BMC Patrol Catalogs Hosted in Amazon Cloud

Oracle RMAN  (Recovery Manager) catalog database contains backup metadata for all enterprise wide Oracle databases. Each database backed up through RMAN needs connection to a central backup repository database. RMAN catalog  is purged and maintained by removing obsolete backup records, crosschecking with existing media etc. If central repository grows too big then backup performance will suffer since it will take too long for RMAN to locate metadata. Amazon Web Services gives us the ability to quickly and easily create either brand new RMAN catalog database or move an existing c... (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)

Economical Data Warehousing Using Amazon Web Services and Hadoop

Sqoop makes it very easy to transfer data between Oracle and Hadoop using a single command. The reason why we would want to import data from an Oracle database into Hadoop/Hive is that we might want to join Hive tables with Oracle lookup tables, or other data residing in Oracle database. Data originating from an Oracle database can help better understand and analyze raw, more granular data contained in Hive/HDFS. Sqoop uses JDBC driver to connect to an Oracle database. If you have a table results in your Oracle database and want data from it to be imported to Hadoop HDFS ( Hadoop... (more)