by Robert Buda | May 29, 2020 | Data Warehouse, Database Architecture
You’ve probably heard the catchphrase, “Data is the new oil.” You need it to run your business, and its potential value is huge… But first you have to drill for it. Companies that can collect, process and analyze their data resources efficiently and effectively will...
by Robert Buda | May 12, 2020 | Database Architecture, Oracle, SQL Server
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB? These terms can be confusing, but they are very important when planning a...
by Robert Buda | Jun 24, 2019 | Database, Database Architecture, Oracle DBA
At a recent vendor conference, I found myself talking with a varied group of technology professionals. Two were technology generalists, one was a data engineer, one was responsible for transportation technology at a major university (think autonomous vehicles, traffic...
by Robert Buda | Aug 3, 2017 | Backup and Recovery, Best Practices, Database Architecture, Oracle
Architecting for Backup and Recovery Efficiency with Oracle RMAN Database architecture is critical to achieving many business objectives. These include application performance, business continuity, security, and geographic distribution. This article will...
by Robert Buda | Sep 23, 2016 | Best Practices, Database, Database Architecture, Oracle, Oracle DBA
Oracle GoldenGate is Oracle’s best-of-breed, strategic solution for real-time data replication and integration. It offers a rapid, robust and low-overhead approach for moving small or large volumes of transactional data between diverse operational and analytical...
by Robert Buda | Apr 21, 2016 | Backup and Recovery, Best Practices, Database Architecture, Oracle DBA
I recently received a frantic call from a client that believed they have been hacked and had to quickly recover data. They said that data belonging to two or more of their customers had been lost. Our customer functions essentially as an application service provider...