Databases and Database Management Systems.md

Databases and Database Management Systems

• Data Warehouse and Data Lake
  • AWS Redshift - Fast, simple, cost-effective data warehousing
  • Google Cloud BigQuery - Fully managed, petabyte scale, low cost analytics data warehouse
  • Apache Tajo - A robust big data relational and distributed data warehouse system for Apache Hadoop
• NoSQL
  • Document
    • MongoDB - NoSQL document store
    • CouchBase - A document database with a SQL-based query language that is engineered to deliver performance at scale
    • CouchDB - NoSQL document store
    • AWS DynamoDB - A fully managed NoSQL database service that provides fast and predictable performance with seamless scalability
    • RethinkDB - RethinkDB is the open-source, scalable database that makes building realtime apps dramatically easier
    • Azure's DocumentDB - A fully managed NoSQL database service built for fast and predictable performance, high availability, elastic scaling, global distribution, and ease of development
  • Column and wide-column (Big-table style)
    • Google Cloud BigTable - Fast, fully managed, massively scalable NoSQL database service
    • Apache Cassandra - Free and open-source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure
    • Druid - An open source data store designed for OLAP queries on event data
    • HyperTable - A high performance, open source, massively scalable database modeled after Bigtable
    • Apache HBase - Apache HBase is the Hadoop database, a distributed, scalable, big data store
    • AWS SimpleDB - A highly available, scalable, and flexible non-relational data store that enables you to store and query data items using web services requests
  • Key-value
    • Redis - An open source (BSD licensed), in-memory data structure store, used as database, cache and message broker
    • Memcache - High-performance, distributed memory object caching system
    • Riak - Distributed NoSQL Database
    • AWS DynamoDB - A fully managed NoSQL database service that provides fast and predictable performance with seamless scalability
    • Azure Table Storage (ATS)
  • Graph
    • Neo4j - World's fastest and most scalable graph database
    • Titan - A highly scalable graph database optimized for storing and querying large graphs with billions of vertices and edges distributed across a multi-machine cluster
    • OrientDB - A document-graph database, meaning it has full native graph capabilities coupled with features normally only found in document databases
• RDBMS
  • AWS RDS - Amazon Relational Database Service
    • AWS Aurora - MySQL-compatible relational database with 5X performance
    • Oracle
    • Microsoft SQL Server
    • PostgreSQL
    • MySQL
    • MariaDB
  • MySQL - Open source RDBMS
  • PostgreSQL - Open-source Object-Relational DBMS supporting almost all SQL constructs
  • SQLite - A self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine
  • Apache Kudu - A columnar storage manager developed for the Hadoop platform
  • Oracle Database
  • Microsoft SQL Server
• In-memory
  • VoltDB - The only in-memory, operational database purpose-built to help businesses build high velocity applications
  • MemSQL - A high-performance, in-memory database that combines
  • SAP HANA - An open platform-as-a-service that provides unique in-memory database and application services the horizontal scalability of distributed systems with the familiarity of SQL
• Static storage
  • AWS S3 - Simple, durable, massively scalable object storage
• Search and full-text
  • ElasticSearch - Service that makes it easy to deploy, operate, and scale Elasticsearch in the AWS Cloud
  • Apache Lucene - Java-based indexing and search technology, as well as spellchecking, hit highlighting and advanced analysis/tokenization capabilities
  • Apache Solr - A high performance search server built using Lucene Core, with XML/HTTP and JSON/Python/Ruby APIs, hit highlighting, faceted search, caching, replication, and a web admin interface
  • Apache PyLucene - A Python port of the Lucene Core project
• Cache
  • Memcache - High-performance, distributed memory object caching system
  • Redis - An open source (BSD licensed), in-memory data structure store, used as database, cache and message broker
• Time-series and event data
  • InfluxDB - A time series database built from the ground up to handle high write and query loads
  • Prometheus - An open-source systems monitoring and alerting toolkit originally built at SoundCloud
  • Druid - An open source data store designed for OLAP queries on event data