What is MySQL? - PowerPoint PPT Presentation

About This Presentation
Title:

What is MySQL?

Description:

The world's most widely used open source database application. ... DHTML. Flash. Graphics. JavaScript. Style Sheets. WML. MySQL. Alternatives ... – PowerPoint PPT presentation

Number of Views:32
Avg rating:3.0/5.0
Slides: 18
Provided by: azhar4
Learn more at: http://web.cs.wpi.edu
Category:
Tags: mysql | dhtml

less

Transcript and Presenter's Notes

Title: What is MySQL?


1
Content of Presentation
MySQL
  • 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

2
What is MySQL?
MySQL
  • MSQL / MySQL DatabasesThe world's most widely
    used open source database application. MySQL is a
    relational database management system. World
    Class SQL Server
  • PHPA 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

3
History
MySQL
  • In 1996 T.c.X. DataKonsultAB , a consulting firm
    in Sweden developed MySQL.
  • Created Alternative database from the general
    idea of mSQL.

4
Facts
MySQL
  • 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.

5
MySQL
SQL Databases
6
MySQL
Alternatives
Server Side Administration Java MySQL
PHP Perl PostgreSQL Python Roxen
Wireless XML Zope
Client Side DHTML Flash Graphics
JavaScript Style Sheets WML
7
MySQL and PostGreSQL Compared
MySQL
  • 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

8
Benefits (1)
MySQL
  • 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

9
Benefits (2)
MySQL
  • 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.

10
Drawbacks
MySQL
  • 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

11
Setting Up Database Driven Websites
MySQL
  • 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

12
How It Works MySQL is based on a client/server
model
MySQL
BLACK BOX
CLIENT PROGRAM
13
PHP and MySQL
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.

14
Specific SQL Tools
MySQL
  • DBTools Manager
  • DBUI
  • exportSQL
  • ForwardSQL
  • Intelligent Converters Software
  • KMySQLAdmin
  • Mac SQL
  • MyAccess
  • MySQL Data Manager
  • MySQL WebClient
  • MySQL Admin

15
A Database Driven SBU Course Guidance Website
MySQL
  • 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

16
Database Driven COURSE GUIDANCE Website for SBU
MySQL
Original Database Implemented in Access SRS
Student Record System
Converted on UNIX Platform/Server
Implemented by South Bank University
Updated version of database Converted to MySQL
Data Manipulation and extraction Of Course
details
  • Choice of 3 tools
  • CGI script,
  • Perl,
  • PHP

Using PHP
Using HTML. JavaScript and PHP
Design of Front End
17
Useful Sites
MySQL
  • http//www.mysql.com/
  • THE OFFICIAL MYSQL WEBSITE
  • http//www.mysql.com/documentation/
  • CODING/HELP DOCUMENTATION
  • http//www.mysql.com/information/presentations/pre
    sentation-ede2000-20001010/
  • SYNTAX EXPLAINED
  • http//hotwired.lycos.com/webmonkey/programming/ph
    p/tutorials/tutorial4.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/fi
    d/94
  • MYSQL QUERIES AND COMMON PROBLEMS
Write a Comment
User Comments (0)
About PowerShow.com