RDBMS

From BC$ MobileTV Wiki
Jump to: navigation, search

A Relational DataBase Management System (commonly abbreviated as RDBMS) is a data storage and management systems with all the functionalities of a traditional DBMS, plus mechanisms which give a developer or data administrator the ability to relate data in separate tables and/or databases.

An RDBMS manages a relational database, which stores data in connectible (relational) tables. Tables are organized into columns, and each column stores one type of data (integer, real number, character strings, date, …). The data for a single “instance” of a table is stored as a row.


Tools

IBM DB2

Derby

Derby is an Apache project.


Oracle

MySQL

Since Oracle's acquisition of Sun Microsystems, they have owned the MySQL technology and any subsequent community contributions.


PostgreSQL

SQL Lite

HSQLDB

MS SQL Server

Microsoft Access

Sybase

QuestDB

[11]

CockroachDB

CockroachDB is a distributed database solution based on SQL and similar in structure to an RDBMS, however, it pitches itself as being: "architected for the cloud, CockroachDB delivers resilient, consistent, distributed SQL at the required scale".



EXAMPLE

For example, the Customer table would have columns such as CustomerNumber, FirstName, and Surname, and a row within that table would be something like {1701, “James”, “Kirk”}.


Tables typically have keys, one or more columns that uniquely identify a row within the table, in the case of the Customer table the key would be CustomerNumber. To improve access time to a data table you define an index on the table. An index provides a quick way to look up data based on one or more columns in the table, just like the index of a book enables you to find specific information quickly.


The most common use of an RDBMS is to implement simple CRUD functionality and ensure data integrity on linked tables (where data in one table depends on data in one or more other tables). [12]


Resources


Tutorials


External Links


References

  1. DB2 Tutorial - Making the primary key auto incremental in DB2 : http://www.deknight.com/2009/10/db2-tutorial1.html
  2. Mappings of Java data types to DB2 data types: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/rjvjdata.htm
  3. How to implement a DB2 UDB primary key with a surrogate key: http://www.ibm.com/developerworks/data/library/techarticle/dm-0407zhang/index.html
  4. Install/Configure JDBC Driver for DB2: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.apdv.java.doc/doc/t0010264.htm
  5. Using DB2 (JDBC) driver from Java: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/cjvjt2cn.htm
  6. How to escape " and ' (by using double "" and ): http://publib.boulder.ibm.com/infocenter/cmgmt/v8r3m0/index.jsp?topic=%2Fcom.ibm.apg.doc%2Fcmbapmst164.htm
  7. Creating an Oracle 11g database: http://dba-onweb.blogspot.ca/2008/03/oracle-11g-creating-database-with-asm.html
  8. MySQL - Create a Database in MySQL: http://www.abbeyworkshop.com/howto/lamp/my_createdb/index.html
  9. 15 Practical PostgreSQL Database Administration Commands: http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/
  10. SQLite Tutorial: http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html
  11. We Put a SQL Database on the Internet: https://dzone.com/articles/we-put-a-sql-database-on-the-internet
  12. Relational Databases 101 - Looking at the Whole Picture: http://www.agiledata.org/essays/relationalDatabases.html


See Also

DBMS | Object-Oriented | Web 2.0