Content of presentation
This presentation is the property of its rightful owner.
Sponsored Links
1 / 17

Content of Presentation PowerPoint PPT Presentation


  • 106 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

Content of Presentation

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Content of presentation

MySQL

Content of Presentation

  • 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


What is mysql

MySQL

What is 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


History

MySQL

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

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.


Content of presentation

MySQL

SQL Databases


Content of presentation

MySQL

Alternatives

Server Side• Administration• Java• MySQL• PHP• Perl• PostgreSQL• Python• Roxen• Wireless• XML• Zope

Client Side• DHTML• Flash• Graphics• JavaScript• Style Sheets• WML


Mysql and postgresql compared

MySQL

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

MySQL

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

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

MySQL

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

MySQL

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

MySQL

How It WorksMySQL is based on a client/server model

BLACK BOX

CLIENT PROGRAM


Php and mysql

MySQL

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

MySQL

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

MySQL

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


Content of presentation

MySQL

Database Driven ‘COURSE GUIDANCE’ Website for SBU

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


Useful sites

MySQL

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/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/fid/94

    MYSQL QUERIES AND COMMON PROBLEMS


  • Login