|
Related YoLinux Tutorials:
°MySQL on Linux
°PostgreSQL on Linux
°Apache, Tomcat, MySQL and Java
°YoLinux Tutorials Index
Free Information Technology Magazines and Document Downloads
|
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.
- Sybase for Linux
- 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.
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.
- Revolutionary Software: rdb - relational database management and application development. Shell commands.
- FairCom: C-Tree, Database server and Server SDK - file management, ISAM, ODBC multi-threaded API. Full source code.
- Pick Systems: D3 - Database server. Also FlashConnect, FlashBASIC
- Solid (from Finland)
- Cache - They brag about speed and their widespread use in healthcare.
- Oracle: Berkeley Db - small tight and often used in embedded systems.
- HDFgroup.org: Hierarchical Data Format (HDF) - large file based data store for complex data collections. Used by NASA to organize, store, discover, access, analyze, share, and preserve Earth observation data.
- DBMaker: SQL database. Supports ODBC, XML, COBOL, C++, Visual Basic, Delphi, Perl and PHP. Used to add database functionality to software.
Other:
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.
- HBase: Distributed database based on Hadoop technology. Java
- Apache Hadoop: Hadoop Distributed File System (HDFS) and Map-Reduce parallel data store.
- Hypertable: modeled after Google's "Bigtable" database.
- High Performance Computing Cluster (HPCC): LexisNexis parallel map-reduce data store. C++.
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
- 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 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
- 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.
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, ...
- Inoflex: SqlFlex, Queryflex, 4GL, AccountFlex - Report Writer for Non-programmers. Lots of Informix like tools. Accounting systems
- Unify - J2EE enterprise application support, Shopping carts and e-commerce solutions, 4GL.
- DataModes: TM4 -
Integrated data processing solution. Applications include Wholesale
Distribution (mail order), Equipment Sales and Service, Manufacturing
and Chemical, Pharmaceutical, Food.
- PlugSys: Max, MSP, OxBC - Connects to FoxPro, dBase, CA-Clipper. Application development for text and web applications.
- OpenLink Software: Virtuoso - Virtual Database. Derive data from heterogeneous data sources. XML based e-business solutions.
- Herrin Software - Faunix: Veterinary practice management
- EasySoft ODBC-ODBC, JDBC-ODBC bridge and SQL engine - Unix ODBC driver manager to multiple ODBC sources
- PlugSys International: MAX and MSP - Generates character based applications and dynamic web applications.
- Automation Technology: Open RDA - ODBC driver for Linux
- AD Software - Cross-Platform C++ Programming Tools
- Report Writer - OOFILE report-writer is a cross-platform, open-source report-writer for C++
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: |
 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)
|
|
 |
"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.
|
|
 |
"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, ...
|
|
 |
"Complete Guide to DB2 Universal Database"
by D. D. Chamberlin
ISBN # 1558604820, Morgan Kaufmann Publishers
|
|
 |
"PostgreSQL: Introduction and Concepts"
by Bruce Momjian
ISBN # 0201703319, Morgan Kaufmann Publishers
|
|
 |
"MySQL, Second edition"
by Paul DuBois
ISBN # 0735712123, New Riders Publishing
|
|
 |
"Managing and Using MySQL"
by George Reese, Randy Jay Yarger, Tim King
ISBN # 0596002114, O'Reilly
|
|
 |
"MySQL Cookbook"
by Paul DuBois
ISBN # 0596001452, O'Reilly
|
|
 |
"High Performance MySQL"
by Jeremy D. Zawodny, Derek J. Balling
ISBN # 0596003064, O'Reilly
|
|
 |
"The Definitive Guide to MySQL, Second Edition"
by Michael Kofler
ISBN # 1590591445, APress
|
|
 |
"MySQL Certification Study Guide"
by Paul Dubois, Stefan Hinz, Carsten Pedersen
ISBN # 0672326329, Sams
|
|
 |
"Informix Handbook"
by Ron M. Flannery
ISBN # 0130122475, Prentice Hall PTR
|
|
 |
"Hadoop: The Definitive Guide"
by Tom White
ISBN # 1449389732, Yahoo Press; Second Edition edition (October 12, 2010)
|
|
 |
"Cassandra: The Definitive Guide"
by Eben Hewitt
ISBN # 1449390412, O'Reilly Media; 1 edition (November 29, 2010)
|
|
 |
"CouchDB: The Definitive Guide"
by J. Chris Anderson, Jan Lehnardt, Noah Slater
ISBN # 0596155891, O'Reilly Media; 1 edition (February 2, 2010)
|
|
 |
"MongoDB: The Definitive Guide"
by Kristina Chodorow, Michael Dirolf
ISBN # 1449381561, O'Reilly Media; 1 edition (September 24, 2010)
|
|
 |
Oracle Magazine
Contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs.
|
Free Subscription
|
|
|
