What Is a Real-Time Database?

A real-time database is broadly defined as a data store designed to collect, process, and/or enrich an incoming series of data points (i.e., a data stream) in real time, typically immediately after the data is created. This term does not refer to a discrete class of database management systems, but rather, applies to several types of databases that handle data that streams in real time, including in-memory data grids, in-memory databases, NewSQL databases, NoSQL databases, and time-series databases.

A real-time database is in contrast to traditional relational database management systems (RDBMSs), in which a database administrator would typically load data via an ETL tool/process at regular intervals such as nightly or weekly. A real-time database may sit alongside RDBMSs for modern use cases in larger enterprises. As the volume of data continues to grow and the velocity of data continues to accelerate, some technologies that once relied primarily on batch-oriented databases now rely more heavily on real-time database technologies (e.g., recommendation engines).

Streaming database overview.
A real-time database collects streaming data in real time for immediate processing or for subsequent batch processing.

Business Use Cases for a Real-Time Database

There are many reasons why business teams are encouraging their IT partners to adopt real-time databases. At a high level, business teams see that real-time databases can enable them to:

  • Respond to events faster than competitors
  • Enable real-time alerting for market changes
  • Support preventive maintenance use cases
  • Analyze data in real time as it is generated
  • Deploy real-time machine learning inference

Technical Use Cases for a Real-Time Database

Technologists are adopting real-time databases for a variety of use cases. These include:

  • Stream data enrichment. One important use case for real-time databases is storing data that can enrich streaming data. Since real-time data, especially from Internet of Things (IoT) sources, is almost always minimalistic, joining that data with reference data from a streaming database can provide more context for analysis.
  • Real-time event capture and processing. From the C-level down, many companies want to become event-driven, and real-time databases can help IT teams get there while often providing some of the same benefits as traditional databases, such as the ability to interact with SQL-like languages.
  • Microservices architectures. Real-time databases can move data from purpose-built app to purpose-built app in real time, so they can serve as the backbone for sharing data and messaging in microservices architectures, which are becoming more common.
  • Stream processing. Much of the data that people, applications, and machines create today is generated as a series of ongoing events. Real-time databases can execute continuous queries to process these events as they occur rather than as idle batches of stale data.

 

Related Topics

Stream Processing

Streaming Database

In-Memory Database

In-Memory Data Grid

Time-Series Database

Streaming ETL

 

Relevant Resources

Video

Live from QCon London: Streaming in a World of Legacy Applications

There are common themes when people describe their reasons for rearchitecting legacy business applications, at a technical level: Speed & Scalability. At a business level: The need to gain new insights flowing from an increasing stream of data. These legacy applications commonly centre around some central datastore such as a relational database.  Moving away from this architecture requires massive migration effort. The costs and risks associated with such an effort can sometimes be prohibitive for business owners, you can’t just rip out your relational database.
Webinar
| Video
| 60 minutes

Fast Data: The Key Ingredients to Real-Time Success

Today, the average enterprise has data streaming into business-critical applications and systems from a dizzying array of endpoints, from smart devices and sensor networks, to web logs and financial transactions. This onslaught of fast data is growing in size, complexity and speed, fueled by increasing business demands along with the rise of the Internet of Things. Therefore, it is no surprise that operationalizing insights at the point-of-action has become a top priority. Many new technologies are coming to the forefront to facilitate real-time analytics, including in-memory platforms, self-service BI tools and all-flash storage arrays. To educate its readers about the key ingredients for success in building a fast data system, Database Trends and Applications is hosting a special roundtable webinar on February 23rd. Attendees will learn about enabling technologies, important success factors and real-world use cases.
View All Resources