Multidimensional, Parallel, and NoSQL Databases

This set of vocabulary flashcards covers the core concepts, architectures, and models of Multidimensional, Parallel, and NoSQL databases as presented in the lecture notes.

Multidimensional Databases (MDDB)

Databases designed for complex analytical queries, Online Analytical Processing (OLAP), business intelligence, and decision support systems, where data is stored in the form of a multidimensional cube.

Online Analytical Processing (OLAP)

A category of software tools that provides analysis of data stored in a database, optimized for fast data analysis and business intelligence in multidimensional environments.

Data Cube

The storage structure used in multidimensional databases to represent data across multiple dimensions, such as Product, Time, and Region.

Slice and Dice

Operations performed on a multidimensional Data Cube to select specific sub-sections or navigate through data for analysis.

Roll-up and Drill-down

Analytical operations in MDDB; roll-up involves summarizing data into higher levels of a hierarchy, while drill-down moves from summary data to more detailed levels.

Parallel Databases

Systems that execute database operations simultaneously using multiple processors or disks to handle large-scale data processing and improve query execution speed.

Shared Memory Architecture

A parallel database architecture where multiple processors share the same main memory.

Shared Disk Architecture

A parallel database architecture where each processor has its own memory but all processors share common disk storage.

Shared Nothing Architecture

A parallel database architecture where each processor has its own private memory and its own private disk storage.

High Throughput

An advantage of parallel databases referring to the ability to process a large volume of transactions or queries at the same time.

NoSQL Databases

Databases that store data in non-relational formats, specifically designed for big data applications, flexible schema handling, and distributed storage.

Key-value model

A type of NoSQL database that stores data as a collection of keys and associated values.

Document model

A NoSQL database type that stores data in document-like structures, such as JSON, including fields like id, name, and course.

Column-family model

A NoSQL data model that organizes data into columns rather than rows, used for large-scale data management.

Graph model

A NoSQL database model designed to represent and store data with complex nodes and relationship connections.

Flexible Schema

A feature of NoSQL databases that allows for the storage of unstructured or semi-structured data without a predefined, rigid structure.

High Availability

An advantage of NoSQL databases ensuring the system remains operational and accessible even during failures, often through distributed storage.