What is Mysql - HU Berlin

obtainablerabbiData Management

Jan 31, 2013 (4 years and 8 months ago)

105 views


What is MySQL?


History


Facts


SQL Databases


Alternatives


Benefits


Drawbacks


Setting Up Database Driven Websites


How It Works


PHP and MySQL


Specific SQL Tools


A Database Driven SBU ‘Course Guidance’ Website


EXAMPLE OF PROJECT


Flowchart


Useful Sites


Content of Presentation

What is MySQL?


MSQL / MySQL Databases

The world's most widely used open source database application.
MySQL

is a relational database management system. World Class SQL
Server




PHP

A server
-
side, cross
-
platform, HTML embedded scripting language.


Why MySQL and not another database system that supports

SQL?


MySQL is:



Available at little cost ….. or Free



Well
-
supported and



Fast

History


In 1996
T.c.X. DataKonsultAB

, a
consulting firm in Sweden developed
MySQL.


Created Alternative database from the
general idea of mSQL.

Facts


MySQL is the largest growing relational database
out on the market.


MySQL mainly runs on UNIX
-
based
environments


MySQL acts as a DBMS


MySQL is one of the most used open source
databases in the world.


Can use Enhanced MySQL


Capacity to handle 50,000,000+ records.


Very fast command execution, perhaps the
fastest to be found on the market.


Easy and efficient user privilege system.


SQL Databases

Server Side

• Administration

• Java

• MySQL

• PHP

• Perl

• PostgreSQL

• Python

• Roxen

• Wireless

• XML

• Zope



Client Side

• DHTML

• Flash

• Graphics

• JavaScript

• Style Sheets

• WML

Alternatives

MySQL and PostGreSQL
Compared


MySQL


Ease of use / long
-
term stability


PostGre
-

Funtionality


Postgres has an arcane limit of 8k of data per
row


Postgres
-

its "serial" data type (the equivalent of
MySQL's auto_increment) creates a "sequence"
which does not get dropped when its parent
table is dropped.


MySQL is "smart" enough to increment its
auto_increment value when you import data


MySQL has no built in method for doing db size
limits

Benefits (1)


Able to handle large databases that can be
accessed over the Web.


Flexible and secure password system to protect
your data
-

powerful security system


Fast, reliable, easy to use, and affordable!


Relational database management system


Stability


On
-
line help facility
-

(type

help or
-
?,)


MySQL meets the ANSI SQL92 regulations

Benefits (2)


MySQL allows users to connect to a
specific database on the server and issue
requests.


Concurrent access


This system can run on virtually on any
platform


UNIX and Windows


MySQL also comes with a source code


MySQL is used at the enterprise level
because of its security.

Drawbacks


The hard part about this is there is not a
lot of documentation available


MySQL has no built in method for doing db
size limits


MySQL requires that you either:



code the data integrity into your product or



you right some scripts to go through the logs
and check that integrity was maintained

Setting Up Database Driven
Websites



Setup the MySQL database server


Setup the Apache web server


Setup the PHP 3.0 Hypertext
Preprocessor for server
-
side
-
scripting


Create a simple web enabled database

How It Works


MySQL is based on a client/server model

BLACK BOX

CLIENT PROGRAM

PHP and MySQL



the best tools available for the rapid
development of database driven web
applications,


"Open Source" and available at no cost,


happen to be particularly easy to learn and
use, and yet are quite robust and scalable,


are excellent choices for anyone seeking a
powerful, affordable, easy and efficient
web development environment.


Specific SQL Tools


DBTools Manager


DBUI


exportSQL


ForwardSQL


Intelligent Converters Software


KMySQLAdmin


Mac SQL


MyAccess


MySQL Data Manager


MySQL WebClient


MySQL Admin

A Database Driven SBU ‘Course
Guidance’ Website


Help potential students choose their ideal
course,


Provide an on
-
line interactive service,


Shorten the decision
-
making process,


Save valuable time,


Provide vast amounts of course information and
guidance,


Send out and view on
-
line prospectuses

Database Driven ‘COURSE GUIDANCE’ Website for SBU

Original Database:

Implemented in Access

SRS


Student Record System


Converted on UNIX Platform/Server

Updated version of database:

Converted to MySQL

Using PHP

Data Manipulation

and extraction

Of Course details

Design of

Front End

Using HTML.

JavaScript and PHP

Implemented by:

South Bank University

Choice of 3 tools:

-
CGI script,

-

Perl,

-
PHP

Useful Sites


http://www.mysql.com/


THE OFFICIAL MYSQL WEBSITE



http://www.mysql.com/documentation/


CODING/HELP DOCUMENTATION



http://www.mysql.com/information/presentations/presentation
-
ede2000
-
20001010/


SYNTAX EXPLAINED



http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutor
ial4.html


PHP AND MYSQL TUTORIAL



http://www.devshed.com/Server_Side/MySQL


THE DEVELOPER SHED (MYSQL INFO.)



http://www.faqts.com/knowledge_base/index.phtml/fid/94


MYSQL QUERIES AND COMMON PROBLEMS