Category Archives: DBMS

The Cost of Virtual Database Conferences

This year — 2020 — the year of the COVID-19 pandemic and quarantine is wreaking havoc on the technical conference industry. So far, we have already seen many conferences postponed or canceled. Those that continue are soldiering along with online, … Continue reading

Posted in conferences, DB2, DBA, DBMS, Microsoft SQL Server | 1 Comment

A Little Database History: Relational vs. OO

I am a packrat, which means I have closets full of old stuff that I try to keep organized. A portion of my office closet is reserved for old magazines and articles I’ve cut out of IT publications. For example, … Continue reading

Posted in DBMS, History, OO, relational | Leave a comment

Database Schema Change and DevOps

  Traditionally, the DBA is the custodian of database changes. The DBA is the information technician responsible for ensuring the ongoing operational functionality and efficiency of an organization’s databases and the applications that access those databases. However, the DBA is … Continue reading

Posted in DBA, DBMS, DevOps, standards | Leave a comment

Implementing a Database Infrastructure

I recently received a question about how to put together a database environment from scratch. This is a quick question that requires an in-depth answer — usually moreso than can adequately be explained over email or texting. Furthremore, to do … Continue reading

Posted in architecture, DBMS | 2 Comments

Ancelus: an Intriguing New Type of Database

There are many different DBMS types and products on the market these days. We have relational, key/value, document, wide column stores, graph, in-memory, multi-model, and even pre-relational DBMS types. It is rare to see anything truly new and interesting in … Continue reading

Posted in data, DBMS, performance | 1 Comment

Digital Transformation and Database Scalability

Today’s business systems are undergoing a revolutionary transformation to work within the digital economy. This phenomenon is known as digital transformation. There are four over-arching trends that are driving digital transformation today summarized by the acronym SMAC: social, mobile, analytics and … Continue reading

Posted in Big Data, DBMS, digital transformation, scalability | Leave a comment

FaunaDB: A multi-model, distributed database system with ACID consistency

Although relational, SQL database systems continue to dominate the DBMS market, modern database management has shifted to encompass additional types of database systems. This is exemplified in the rise of the NoSQL database system to serve the needs of modern … Continue reading

Posted in cloud, data availability, DBMS, Isolation Level, NoSQL, relational, temporal | 1 Comment

Keeping Up With the DBMS

  One of the more troubling trends for DBAs is keeping up with the latest version of their DBMSs. Change is a fact of life and each of the major DBMS products change quite rapidly. A typical release cycle for … Continue reading

Posted in change management, DBMS, fixpacks, maintenance | 1 Comment

An Overview of Today’s Leading DBMS Platforms

Recently I wrote a series of DBMS product descriptions/overviews for the TechTarget web portal. The product descriptions were an adjunct a 7 part series of articles I wrote reviewing DBMS technology and considerations circa 2015. Anyway, the purpose of today’s post … Continue reading

Posted in cloud, DB2, DBMS, NoSQL, open source, relational | 1 Comment