Big Data Consultant

Ranko Mosic

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

Top Stories by Ranko Mosic

The Oracle Database Cloud is Platform as a Service ( PaaS ) so it only makes sense to compare it to Oracle on Amazon RDS.  Oracle on Amazon EC2, on the other hand, is an IaaS ( Infrastructure as a Service ) offering, which gives you full control over the installation, features and actions around your database. Oracle Public Cloud will consist of a number of major services, the Oracle Database Cloud being one of them. Please refer here for a complete list  of services. One of the most interesting characteristics of the Oracle Database Cloud is that there is no need to  purchase database license. In that respect service is similar to Amazon RDS. The Oracle Database Cloud is based on monthly subscription -"per user-per month or per environment-per month basis". Access to the database is likely to be at the level of an application database administrator i.e. you will o... (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)

Oracle RDBMS and Very Large Data Set Processing

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)

Overcoming Large Oracle Database Performance Problems

Typical Oracle VLDB is multi terabyte megalith running on big, expensive hardware. It is hard or impossible to back up, adding or modifying columns can take days and query optimization is very difficult. Database sharding is a well known method of breaking up a large database into smaller, manageable pieces ( database shards ). It is data warehouses i.e. VLDBs that can best take advantage of AWS database sharding capabilities. Basic premise is: manage huge volume of data by splitting it into multiple databases instead of creating table partitions. Database sharding provides a me... (more)

Mainstream Business Applications and In-Memory Databases

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