BI Glossary

Database

Back to Glossary

What is a Database?

Databases are systems that store and organize data in a structured way. There are many different types of databases, each with its own advantages and disadvantages.

 

What is a Multi-tenant Database?

A database designed for SaaS applications that use a tenant architecture for the software platform. Learn more about multi-tenant database.

 

Types of Databases Include:

Relational databases

How do relational databases store data?

These are databases that store data in tables, which consist of rows and columns. Each row represents a record or an instance of an entity, and each column represents an attribute or a property of the entity.

Relational database query language is SQL, to manipulate and retrieve data.

Relational database use cases

  • online transaction processing
  • data warehousing
  • internal business intelligence.

Some examples of relational databases

  • MySQL
  • Snowflake
  • AWS Redshift
  • PostgreSQL
  • Oracle
  • SQL Server.

 

Non-relational databases

How do non-relational databases store data

These are databases that store data in formats other than tables, such as documents, key-value pairs, graphs, or columns. Non-relational databases, also known as NoSQL databases, are more flexible and scalable than relational databases, and can handle large volumes and varieties of data.

Non-relational database use cases

  • big data
  • web applications
  • real-time analytics.

Examples of non-relational database products

 

Object-oriented databases

How do object-oriented databases store data

These are databases that store data as objects, which consist of attributes and methods. Objects can inherit properties and behaviors from other objects, and can be organized into classes and hierarchies.

What query languages do object-oriented databases use?

Object-oriented databases use an object-oriented programming language, such as Java or C++, to manipulate and retrieve data.

Object-oriented database use cases include complex and dynamic data models such as:

  • multimedia
  • geographic
  • scientific data.

Examples of object-oriented databases are:

  • ObjectDB
  • db4o
  • Versant.

 

Analytics for Those Who Want More

Build Less Software. Deliver More Value.

Request a Demo Watch a Demo

More Insights

multi-tenant analytics

Why is Multi-Tenant Analytics So Hard?

BLOG

Creating performant, secure, and scalable multi-tenant analytics requires overcoming steep engineering challenges that stretch the limits of...

Read The Post

How Embedded Analytics Helps Product Managers Exceed Their KPIs

GUIDE

Discover how an embedded analytics platform, like Qrvey, can help PMs exceed their KPIs and deliver more value to their customers.

Read The Guide

Beyond Dashboards: The Transformative Power of Embedded Analytics

WEBINAR ON-DEMAND

Discover how embedding customizable analytical tools allows you to deliver powerful analytics...

Watch Now