Database Blog

  • Is a Cloud Data Warehouse Right for My Company?

    May 29, 2020

    Reading Time: 6 minutes This post compares on-premises versus cloud data warehouse architectures and explains the pros and cons of each.

    Read more Add new comment
  • Schemas, Databases and Instances—Defined and Discussed

    May 12, 2020

    Reading Time: 5 minutes 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 are very important when planning a database architecture, so let’s explore them.

    Read more Add new comment
  • Does Data Governance Make You Shudder?

    Jun 24, 2019

    Reading Time: 4 minutes 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 sensors, etc.), another was responsible for university student and teacher data (lesson plans, research findings, etc.), and one was responsible for his organization’s IT security.  During the conversation, someone mentioned data governance. Immediately there was a…..

    Read more Add new comment
  • Architect Your Oracle Database for Efficient Backup and Recovery

    Aug 3, 2017

    Reading Time: 4 minutes 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 explore another often overlooked objective that can be influenced by the database architecture: backup and recovery efficiency. Very large databases are common in today’s business environment. Multi-terabyte databases are prevalent in all but the smallest organizations. Despite these large sizes, we tend to find that…..

    Read more Add new comment
  • Using Oracle GoldenGate for real time data replication and integration.

    Sep 23, 2016

    Reading Time: 2 minutes 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 systems—including not just various Oracle Database versions but also non-Oracle databases like SQL Server, Sybase, IBM DB2 and others. Though extremely powerful and flexible, Oracle GoldenGate is straightforward to install and configure. Its transformation, filtering and custom processing features make…..

    Read more Add new comment
  • Architecting to Maximize Recovery Options in Oracle

    Apr 21, 2016

    Reading Time: 2 minutes 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 (ASP). Their customers’ data is in an Oracle database that our client manages. Our client organizes this database such that each of its customers’ applications is served by a separate…..

    Read more Add new comment
  • 4 Key Use Cases for Oracle’s Multitenant Architecture

    Mar 19, 2015

    Reading Time: 2 minutes If you’re thinking of moving to Oracle Database 12c, “the first database designed for the cloud,” one of the most compelling reasons could be the Oracle Multitenant option. In this revolutionary new architecture, you can “plug” many Oracle databases into a single container database—no application changes required. Let’s quickly head off any potential confusion around the term “multitenant.” That word has been used for awhile in relation to sharing data elements (records) across databases, especially…..

    Read more Add new comment
  • 3 Oracle DBA Strategic Responsibilities to Outsource for Maximum Business Value

    Aug 5, 2014

    Reading Time: 2 minutes Many organizations have limited their Oracle DBA outsourcing to tactical/operational functions like monitoring, backup and patching. But the changing technology landscape is transforming the DBA role and requiring greater expertise. Today’s enterprise data stores are increasingly massive and architecturally complex. They must support e-commerce and other critical applications that are web-based and demand continuous availability, on-demand scalability, robust security, maximum performance and mobile device support. Further, more and more of the data that drives these…..

    Read more Add new comment
  • Oracle RAC is Now Supported on VMware

    Nov 24, 2010

    Reading Time: 2 minutes In a recent change to its long-standing policy, Oracle Corp. will now support its customers running Oracle Real Application Cluster (RAC) software on VMware platforms in certain circumstances. This positive move for customers was announced in a document titled “Support Position for Oracle Products Running on VMware Virtualized Environments,” which Oracle posted on its support web page on November 8. You can read the specifics of the new policy here (Oracle Support login required). Basically,…..

    Read more Add new comment