Other Database Management Systems

bawltherapistSoftware and s/w Development

Dec 13, 2013 (3 years and 10 months ago)

211 views

Other Database Management Systems
(Besides PostgreSQL)
Dr.Chris Mayeld
Department of Computer Science
James Madison University
Apr 16,2013
So many choices!
Google:open source dbms
I
http://en.wikipedia.org/wiki/List
of
relational
database
management
systems
I
http://www.webresourcesdepot.com/25-alternative-open-source-databases-engines
Lots of models...
I
Relational
I
Object-oriented
I
Document-oriented
I
Graph-structured
I
Key-value store
...and architectures!
I
Client-Server
I
Distributed
I
Embedded
I
Column-oriented
Apr 16,2013 Other Database Management Systems 2 of 12
Example 1:Oce Applications
When your friends ask you for a\database"
Oce applications
Examples
I
Microsoft Access
I
LibreOce Base
I
FileMaker Pro
I
Zoho Creator
Good for
I
Small projects
I
Novice users
I
Prototyping
Try to create/query the following:
division(div_num,div_name)
school(div_num,sch_num,sch_name)
enroll(sch_year,div_num,sch_num,fall_cnt)
Apr 16,2013 Other Database Management Systems 4 of 12
Key concepts
Tables
I
Design View vs Create Wizard
I
Tools!Relationships
Queries
I
Design View vs Create Wizard
I
Visual Designer vs SQL editor
I
pgAdmin has one of these too!
Forms and Reports
I
For data entry and pdf output
Apr 16,2013 Other Database Management Systems 5 of 12
Alternative clients
You can also use Access,Base,etc.as a client
I
Tools!Options!Java!Class Path
I
Try designing your tpch queries visually!
Universal SQL Client
I
http://squirrel-sql.sourceforge.net/
I
Connects to any DBMS that
supports JDBC
I
Especially useful for databases
unfamiliar to you
Apr 16,2013 Other Database Management Systems 6 of 12
Example 2:Embedded Databases
When you want SQL without setting up a server
Embedded databases
Examples
I
SQLite
I
Berkely DB
I
Apache Derby
I
hamsterdb
Good for
I
Zero conguration
I
Mobile devices
I
Ad hoc disk les
Check out your refox/chrome proles!
~/.mozilla/firefox/.../
~/.config/google -chrome/Default/
Useful links:
I
http://www.sqlite.org/whentouse.html
I
http://www.sqlite.org/lang.html
Apr 16,2013 Other Database Management Systems 8 of 12
Sample queries
I
Show all cookies from google.com
I
What are the top 5 sites you visit?
I
Delete sensitive data stored in form history
I
Credit cards,SSNs,passwords,etc
I
Isn't it amazing how many bad developers are out there!
Apr 16,2013 Other Database Management Systems 9 of 12
Example 3:Traditional Databases
What we have been doing all semester
Traditional databases
Examples
I
MySQL
I
PostgreSQL
I
Oracle
I
SQL Server
Good for
I
Client-server
I
High-volume use
I
Large databases
Exercise:Implement hw5sol (\Cars!") using MySQL
1.Create a new table with your username
2.Update the Database.java and jar le
3.Edit the source code to use that table
Apr 16,2013 Other Database Management Systems 11 of 12
MySQL notes
Port number is 3306
I
http://en.wikipedia.org/wiki/List
of
TCP
and
UDP
port
numbers
Command line usage
I
mysql -h db.cs.jmu.edu -p
I
Note:-p stands for password
Setting up JDBC
I
http://dev.mysql.com/downloads/connector/j/
I
Class.forName("com.mysql.jdbc.Driver");
I
jdbc:mysql://db.cs.jmu.edu/test
Apr 16,2013 Other Database Management Systems 12 of 12