NetworkingServers – database

Preface

A database is an organized collection of data. The data is typically organized to model relevant aspects of reality, in a way that supports processes requiring this information. There are many vendor offers database application (or Database Management System, DBMS).

Traditional database based on set and relation operation while recent database based on various method.

This page is a metapage. It means deeper and more focused article will be written in other place and their entry will be indexed here. Browse following catalog to search what you want.

Table of Content

  1. Relational DBMS
  2. Document-Oriented DBMS
  3. Column-Based DBMS
  4. Key-Value Based DBMS
  5. Graph DBMS

Article

  1. Set and Relation
  2. NoSQL, Gearing Toward New Era of Database

Relational DBMS

Product in this category:

  1. FirebirdSQL
  2. MariaDB
  3. Oracle MySQL
  4. Oracle
  5. PostgreSQL

[x] FirebirdSQL

[x] MariaDB

  • Installation
    • MariaDB on Linux (Source/Deb/RPM/Pacman)
    • MariaDB on BSD
    • MariaDB on Windows
  • Configuration
  • Other

[x] Microsoft SQL Server

  • Installation
    • SQL Server 2008 on Windows
  • Configuration
  • Other

[x] Oracle MySQL

  • Installation
    • MySQL on Linux (Source/Deb/RPM/Pacman)
    • MySQL on BSD
    • MySQL on Windows
  • Configuration
  • Other

[x] Oracle DB

  • Installation
    • Oracle
  • Configuration
  • Other

[x] PostgreSQL

  • Installation
    • PostgreSQL on Linux (Source/DEB/RPM/Pacman)
  • Configuration
  • Other
    • Add PostgreSQL User Account

[x] SQLite

Document-Oriented DBMS

Pair each key with a complex data structure known as a document. Documents can contain many different key-value pairs, or key-array pairs, or even nested documents.

  1. MongoDB

[x] MongoDB

  • Installation
    • MongoDB on Linux (Source/Deb/RPM/Pacman)
    • MongoDB on BSD
    • MongoDB on Windows
  • Configuration
  • Other

Column-Based DBMS

Optimized for queries over large datasets, and store columns of data together, instead of row.

  1. Cassandra
  2. HBase

[x] Cassandra

  • Installation
    • Cassandra on Linux (Source/Deb/RPM/Pacman)
    • Cassandra on BSD
    • Cassandra on Windows
  • Configuration
  • Other

[x] HBase

  • Installation
    • HBase on Linux (Source/Deb/RPM/Pacman)
    • HBase on BSD
    • HBase on Windows
  • Configuration
  • Other

Key-Value DBMS

Simplest NoSQL databases. Every single item in database is stored as an attribute name (key) together with its value.

  1. Riak
  2. Voldemort
  3. Redis

[x] Riak

  • Installation
    • Riak on Linux (Source/Deb/RPM/Pacman)
    • Riak on BSD
    • Riak on Windows
  • Configuration
  • Other

[x] Voldemort

  • Installation
    • Voldemort on Linux (Source/Deb/RPM/Pacman)
    • Voldemort on BSD
    • Voldemort onWindows
  • Configuration
  • Other

[x] Redis

  • Installation
    • Redis on Linux (Source/Deb/RPM/Pacman)
    • Redis on BSD
    • Redis on Windows
  • Configuration
  • Other

Graph DBMS

Used to store information about networks, such as social connections.

  1. Neo4J
  2. HyperGraphDB

[x] Neo4J

  • Installation
    • Neo4J on Linux (Source/Deb/RPM/Pacman)
    • Neo4J on BSD
    • Neo4J on Windows
  • Configuration
  • Other

[x] HyperGraphDB

  • Installation
    • HyperGraphDB on Linux (Source/Deb/RPM/Pacman)
    • HyperGraphDB on BSD
    • HyperGraphDB on Windows
  • Configuration
  • Other

Affiliation