List of Linux Databases and Database Related Links

Free Open Source as well as industrial strength Oracle, DB2, Informix and Sybase commercially supported databases are available for Linux. This has thrust Linux into the large enterprise data centers.

Related YoLinux Tutorials:

°MySQL on Linux

°PostgreSQL on Linux

°Apache, Tomcat, MySQL and Java

°YoLinux Tutorials Index




Free Information Technology Magazines and Document Downloads
TradePub link image


Databases:

Commercial Databases

SQL:

  • Oracle: Oracle currently makes their database server software products and support fully available on Linux. The latest trend is to support blade computing on Linux. Oracle supports a procedural extension to SQL called PL/SQL which adds capability and advantages when used with triggers and database scripts. Oracle also has a full suite of development tools as well as remote access administration tools. (Free trial download)
  • IBM DB2 universal database for Linux: This is IBM's flagship database used in large enterprise data centers. (Free trial download)
  • IBM Lotus Notes: (Not really a database in my opinion but it does run on Linux)
  • IBM/Informix - Informix introduced many of the latest database technologies and was considered the most advanced. They were also a case study in poor marketing and were eventually purchased by IBM to save themselves from going under. It may also save IBM from falling too far behind. Informix for Linux is now available from IBM.
  • Borland Interbase - FireBird (now open source and called FireBird)
  • Empress: Embedded Database
  • Adabas (from Germany)
  • MIMER SQL DBMS - ISO PSM standard used for stored procedures.
  • Clustrix - highly parallel, distributed, scalable and fault tollerant SQL database for big data applications.
  • Pervasive - SQL 2000 server database and and SDK. Supports JDBC, ODBC
  • MySQL: (commercial extensions to the open source MySQL database)
    • ScaleDB: pluggable storage engine for MySQL. Automatic recovery of failed nodes. Scalable, high availability. Commercial plugin for an open source database.
    • ScaleBase - big data transaction processing. Scalable, high availability, load balancing for MySQL.
    • DBshards - distributed query, sharding and scaling for MySQL. Includes drivers for Java, PHP, Python, Ruby.
  • Raima for Linux - distributed database with mirroring, replication, partitioning. SQL, low level C/C++ and Labview APIs.
  • Sybase for Linux

Analytic DB:

Analytic stores are databases (usually SQL) for large datasets used for reporting and analytics where columnar optimization and compression are important.
  • HP Vertica - column oriented analytic database for fast queries against a large data wharehouse. Nothing shared architecture for scalability. Runs on a distributed grid of servers.
  • Teradata Aster: SQL/map reduce big data analytic database. Structured and unstructured data.
  • ParAccel - optimized for high query speed of large datasets. Parallel and scalable.
  • IBM Netezza - Database appliance with an asymetric massively parallel processing architecture using FPGAs to support computation.
  • XtremeData - Massively scalable distributed SQL database.
  • Teradata - distributed shared nothing architecture for massive data stores.

Non-SQL DB:

Not just SQL databases. Not constrained to a fixed table schema. Distributed and scalable.

Other:


Open Source Databases

SQL:

  • MySQL - Official Home Page
    • YoLinux Tutorial: MySQL and Linux - Installation, configuration, use and administration.
    • MySQL.com: Manual
    • PHP and MySQL - W.J.Gilmore
    • InfiniDB - scalable database engine for data warehousing and analytic store. Column-oriented DBMS plugin for MySQL. Designed for fast queries against large data stores. Community and commercial editions.
    • InfoBright - MySQL based column-oriented relational database focused on computer generated data (web logs, network logs, sensor data). Sold as a bundled hardware/software appliance. High availability, self tuning, backup/restore.
  • PostgresSQL - included on Redhat distro
  • Drizzle - Streamlined MySQL with features stripped (no views, no triggers, no stored procedures, no ACL, ...) to support massive concurrency
  • SQLite: Embed a SQL engine in your application. Public domain.
  • VoltDB: In memory, high speed, high throughput SQL database. Uses precompiled Java stored procedures. Community GPL and commercial editions.
  • SapDb - SAP released open source database
  • Actian: Ingres Open Source Database
  • GigaBASE: For large (Tbyte) file based databases. C++ API. Inherits most of the features of FastDB.
  • FastDB: Tight integration with C++.

Java based DB Software Products:

  • Apache Derby: open source relational database implemented entirely in Java. Derby is small enough to be embedded in Java applications or it can accessed in client/server mode using JDBC.
  • HSQL Database engine: Small. Can be embedded within an application.
  • MckoiDDB Distributed SQL Database: Supports transactions, triggers. GPL open source.

Other:

  • GNU: gdbm - extensible hashing (clone of UNIX dbm)

Open Source NoSQL Databases
  • Cassandra: multi-master high speed parallel and fault tolerant data store. Open sourced by Facebook.
  • Apache HBase: Distributed fault-tolerant database used in the Hadoop framework. Uses HDFS (Hadoop Distributed Filesystem). Java
  • Apache Hadoop: Hadoop framework based on Hadoop Distributed File System (HDFS) and Map-Reduce parallel distributed processing against the data store. Framework includes "Zookeeper" to support high availability through redundant services.
    SQL front-ends to Hadoop:
  • Kai: open source clone of Amazon's closed source Dynamo NoSQL cloud storage. Erlang
  • Kademlia: distributed hash table for clusters.
  • Hypertable: modeled after Google's "Bigtable" database.
  • High Performance Computing Cluster (HPCC): LexisNexis parallel map-reduce data store. C++.


Key-Value Store:
  • Redis: key-value store for data structures (keys can contain strings, hashes, lists, sets. Speed comes from use of an in-memory dataset and is written in C. Supports master-slave replication, transactions.
  • Memcached:
  • Infinispan: in-memory. Includes JCACHE (Temporary Caching for Java)


Document Store:

The following are NoSQL document data stores:

  • MongoDB: JSON style document storage, Supports replication and high availability, sharding, querying, map-reduce and gridFS
  • Apache CouchDB: document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript. Provides a RESTful JSON API via HTTP requests. Erlang
  • Apache Lucene: indexing/search of structured text data. Typically used with the Solr search platform.
  • Terrastore: scalable and elastic (add/remove nodes dynamically). Based on Terracotta Java clustering technology. Google code
  • OrientDB: scalable Document-Graph DBMS. JSON document import/export. Web management interface. Supports database structure, management of the schema, a subset of SQL queries (even though it is built upon graph relationships), RAW RESTful commands. Java


Graph Databases:

Graph databases store data in node based directed hypergraphs. Use a graph database if your data contains many-to-many relationships, and the primary objective is to find patterns and relationships. The following are NoSQL graph data stores:

  • Neo4j: Object oriented, disk-based transactional graph database. REST. Java
  • Apache Giraph: highly scalable
  • Bigdata: distributed database architecture, RDF database supporting RDFS and limited OWL inference. SPARQL. Java
  • InfiniteGraph: distributed graph analytics, and parallel processes.
  • HyperGraphDB: distributed, embeddable. Supports an RDF storage and API, OWL (Ontology Web Language), reasoning over hypergraphs through Prolog, XML, topic maps, ... Java
  • InfoGrid: Supports REST, Grid replication, user centric id, reusable objects, viewlets, ... Java
  • Franz.com: AllegroGraph: graph database for RDF and the semantic web. Supports SPARQL, RDFS and Prolog. Commercial product.


XML Databases:

The following are NoSQL XML native data stores:

  • eXist-DB: Store XML data, index-based XQuery processing. HTTP interfaces: REST, WebDAV, SOAP, XML-RPC and Atom (RSS feeds). Persistent DOM storage. Java
  • Sedna: ACID transactions, security, hot backup, XQuery. Java/C/PHP/Python/Ruby/Perl/Delphi/C#
  • BaseX: XPath/XQuery processor, GUI front-end
  • Qizx: XQuery processor, B2B XML exchange data logging: XBRL, FIX, FpML, IFX, SWIFTStandards, ...


Other Linux DB Software:

Other and MS/Windows:

  • Embarcadero - Tools for DBA's to design and manage a database. ER/Studio, GDPro, Rapid SQL, DBArtisan. - Windows only products.
  • KE Software - Database and Collection Management Software. Electronic Museum, Vital Statistics, Texpress Object Oriented Database and Software Library Databases.


Linux GUI Database Tools:


Links:


Books:

"Oracle Database 10g: The Complete Reference"
by Kevin Loney
ISBN # 0072253517, McGraw-Hill Osborne

If you are going to own only one Oracle reference, then this is it. It covers it all. (It's a big book)

Amazon.com
"Oracle9i PL/SQL Programming"
by Scott Urman
ISBN # 0072191473, McGraw-Hill Osborne

This is a required reference if you are going to use the full power of the Oracle database. In depth look at triggers, functions, cursors, packages, external procedures, ... This is for Oracle users who are programming Oracle within the Oracle environment. For programmers wishing to interface with Oracle from software, use Pro*C.

Amazon.com
"Oracle10g: A Beginner's Guide"
by Ian Abramson, Michael Abbey, Michael Corey
ISBN # 0072230789, McGraw-Hill Professional Publishing

If you are lost and need a place to start, then get this book. It covers basic DBA functions, data import/export, SQL, PL/SQL, ...

Amazon.com
"Complete Guide to DB2 Universal Database"
by D. D. Chamberlin
ISBN # 1558604820, Morgan Kaufmann Publishers

Amazon.com
"PostgreSQL: Introduction and Concepts"
by Bruce Momjian
ISBN # 0201703319, Morgan Kaufmann Publishers

Amazon.com
"MySQL, Second edition"
by Paul DuBois
ISBN # 0735712123, New Riders Publishing

Amazon.com
"Managing and Using MySQL"
by George Reese, Randy Jay Yarger, Tim King
ISBN # 0596002114, O'Reilly

Amazon.com
"MySQL Cookbook"
by Paul DuBois
ISBN # 0596001452, O'Reilly

Amazon.com
"High Performance MySQL"
by Jeremy D. Zawodny, Derek J. Balling
ISBN # 0596003064, O'Reilly

Amazon.com
"The Definitive Guide to MySQL, Second Edition"
by Michael Kofler
ISBN # 1590591445, APress

Amazon.com
"MySQL Certification Study Guide"
by Paul Dubois, Stefan Hinz, Carsten Pedersen
ISBN # 0672326329, Sams

Amazon.com
"Informix Handbook"
by Ron M. Flannery
ISBN # 0130122475, Prentice Hall PTR

Amazon.com
"Hadoop: The Definitive Guide"
by Tom White
ISBN # 1449389732, Yahoo Press; Second Edition edition (October 12, 2010)

Amazon.com
"Cassandra: The Definitive Guide"
by Eben Hewitt
ISBN # 1449390412, O'Reilly Media; 1 edition (November 29, 2010)

Amazon.com
"CouchDB: The Definitive Guide"
by J. Chris Anderson, Jan Lehnardt, Noah Slater
ISBN # 0596155891, O'Reilly Media; 1 edition (February 2, 2010)

Amazon.com
"MongoDB: The Definitive Guide"
by Kristina Chodorow, Michael Dirolf
ISBN # 1449381561, O'Reilly Media; 1 edition (September 24, 2010)

Amazon.com
Oracle Magazine

Contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs.

Free Subscription
   

    Bookmark and Share


Advertisements




Copyright © 2001 - 2014 by Greg Ippolito