Linux Databases

Prepared byRajeev.P.V,

CB.EN.P2CSE13014

Before Linux

● In 1980’s, Microsoft’s DOS was the dominated OS for PC.● Apple's MAC was better, but expensive.● UNIX was much better, but much more expensive. Only for

minicomputer for commercial applications.● People were looking for a UNIX based system, which is cheaper and

can run on PC.● Both DOS, MAC and UNIX were proprietary, i.e., the source code of

their kernel is protected.● No modification is possible without paying high license fees.

GNU project

● Established in 1984 by Richard Stallman, who believes that software should be free from restrictions against copying or modification in order to make better and efficient computer programs.

● GNU is a recursive acronym for “GNU's Not Unix”

● Aim at developing a complete Unix-like operating system which is free for copying and modification.

● Stallman built the first free GNU C Compiler in 1991. But still, an OS was yet to be developed.

Beginning of Linux

● A famous professor Andrew Tanenbaum developed Minix, a simplified version of UNIX that runs on PC.

● In Sept 1991, Linus Torvalds, a second year student of Computer Science at the University of Helsinki, developed the preliminary kernel of Linux, known as Linux version 0.0.1

Unix, Linux and variant history● 1957:Bell labs introduced BESYS operating system to deal with batch

jobs.

● 1971:First edition of Unix was released.

● 1972:Second edition of Unix released December 06, 1972.

● 1972:Ritchie written the new language C.

● 1973-1975: third, fourth, fifth, sixth editions of Unix were released.

● 1977:1BSD released late 1977.

● 1978:2BSD released mid 1978.

● 1979:Seventh edition of Unix released January 1979.

● 1979:3BSD released late 1979.

● 1979:SCO founded by Doug and Larry Michels as Unix porting and consulting company.

● 1980:4.0BSD released October 1980.

Unix, Linux and variant history(contd..)● 1982:SGI introduces IRIX.

● 1983:The GNU operating system is first announced by Richard Stallman September 27, 1983.

● 1984:Ultrix 1.0 was released.

● 1985:Eighth edition of Unix released February 1985.

● 1986:HP-UX 1.0 released.

● 1986:Ninth edition of Unix released September 1986.

● 1989:HP-UX 7.0 released.

● 1989:Tenth edition of Unix released October 1989

● 1997:HP-UX 11.0 released.

● 1998:Sun Solaris 7 operating system released.

Unix,linux and varient history(contd..)● 2004:The first release of Ubuntu is released October 20, 2004.

● 20 October 2004:Ubuntu 4.10 (Warty Warthog)

● 8 April 2005:Ubuntu 5.04 (Hoary Hedgehog)

● 13 October 2005:Ubuntu 5.10 (Breezy Badger)

● 1 June 2006:Ubuntu 6.06 LTS (Dapper Drake)

● 26 October 2006:Ubuntu 6.10 (Edgy Eft)

● 19 April 2007:Ubuntu 7.04 (Feisty Fawn)

● 18 October 2007:Ubuntu 7.10 (Gutsy Gibbon)

● 24 April 2008:Ubuntu 8.04 LTS (Hardy Heron)

● 30 October 2008:Ubuntu 8.10 (Intrepid Ibex)

● 23 April 2009:Ubuntu 9.04 (Jaunty Jackalope)

● 29 October 2009:Ubuntu 9.10 (Karmic Koala)

Unix, Linux and variant history(contd..)

● 29 April 2010:Ubuntu 10.04 LTS (Lucid Lynx)

● 10 October 2010:Ubuntu 10.10 (Maverick Meerkat)

● 28 April 2011:Ubuntu 11.04 (Natty Narwhal)

● 13 October 2011:Ubuntu 11.10 (Oneiric Ocelot)

● 26 April 2012:Ubuntu 12.04 LTS (Precise Pangolin)

● 18 October 2012:Ubuntu 12.10 (Quantal Quetzal)

● 25 April 2013:Ubuntu 13.04 (Raring Ringtail)

● 17 October 2013:Ubuntu 13.10 (Saucy Salamander)

● 17 April 2014(future):Ubuntu 14.04 LTS (Trusty Tahr)

Linux today

● Linux has been used for many computing platforms like PC, PDA, Supercomputer etc.

● Not only character user interface but graphical user interface is available.

● Source code is freely available.

List of Linux databases

● Commerecial databases.

● Opensource databases.

● NoSQL databases.

Commercial databases

SQL:SQL:

● Oracle

● IBM DB2 universal database for Linux

● Sybase for Linux

● Borland Interbase – FireBird

● MIMER SQL DBMS

● Adabas (from Germany)

● Empress: Embedded Database

● Pervasive

Analytic DB:Analytic DB:

● HP VerticaHP Vertica

● Teradata Aster etc.Teradata Aster etc.

Non-SQL databases

● FairCom: C-Tree, Database server and Server SDK.

● Pick Systems: D3

● Solid (from Finland)

● Cache

● Oracle: Berkeley Db.

● HDFgroup.org: Hierarchical Data Format.

● DBMaker

Open source databases● MySQL

● PostgresSQL.

● Drizzle.

● SQLite.

● VoltDB.

● Sap-DB

● Actian: Ingres Open Source Database.

● GigaBASE.

● FastDB.

DatabasesThe two popular databases for linux are:

● MySQL

● PostgreSQL

MySQL advantages1. Scalability and Flexibility.

2. High Performance.

3. High Availability.

4. Robust Transactional Support.

5. Web and Data Warehouse Strengths.

6. Strong Data Protection.

7. Comprehensive Application Development.

8. Management Ease.

9. Open Source Freedom and 24 x 7 Support.

10. Lowest Total Cost of Ownership.

MySQL on Linux● To install:

sudo apt-get install mysql-server

● To start:

mysql -u root -p

● To create database

create database amrita;

● To show database

show databases;

References• http://www.computerhope.com/history/unix.htm , Accessed on

07-01-2014.

• http://en.wikipedia.org/wiki/List_of_Ubuntu_releases, Accessed on 06-01-2014.

• http://www.yolinux.com/ , Accessed on 02-01-2014.

• http://www.mysql.com/why-mysql/topreasons.html, Accessed on 27-12-2013.

• https://help.ubuntu.com/13.04/serverguide/mysql.html, Accessed on 22-12-2013.

Thank you...Thank you...