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

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

Real-time, Hybrid OLTP/OLAP Now Possible with Columnar, In-memory Databases

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)

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)

Towards Next Generation Enterprise IT

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)