MySQL

-

What is MySQL?

MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).

MySQL runs on virtually all platforms

There are two main components to MySQL:
  • ·         The MySQL database server, mysqld. This is the MySQL DBMS that does the actual work of managing your databases. It runs all the time in the background, accepting connections from client programs, web scripts and so on.
  • ·         Various client and utility programs. These include mysql, the command-line MySQL Monitor client that issues commands to the server.

There are many ways to install the MySQL server and associated programs. Here are two ways that you can do it:

Ø  Using an official MySQL installation package

·         MySQL Community Server
·         MySQL Cluster
·         MySQL Router
·         MySQL Workbench
MySQL Workbench is a cross platform, unified visual tool for data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup and so on.

Ø  Installing an entire LAMP/WAMP/MAMP package

·         XAMPP

XAMPP is a free and open source cross-platform (it works equally well on Linux, Mac and Windows.) web server solution stack package developed by Apache Friends.
It is used by developers to create a local web server for testing and deployment purposes.
Everything needed to set up a web server – server application (Apache HTTP Server), database (MariaDB), and scripting language (PHP) – is included in an extractable file.

·         WAMP

WAMP is a Windows web server equivalent.

It stands for "Windows, Apache, MySQL, and PHP."

Comments

Post a Comment

Popular posts from this blog

Normalization

-
Image
Normalization is a process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies. Normalization starts by identifying the dependencies of a given relation and progressively breaking up the relation (table) into a set of new relations (tables) based on the identified dependencies. Normal Forms 0NF            Multi-valued attributes exists 1NF           Any multi-valued attributes (repeating groups) have been removed. 2NF           Any partial functional dependencies have been removed 3NF           Any transitive dependencies have been removed BCNF           Any anomalies resulting from functional dependencies have been removed 4NF           Any multi valued dependencies have been removed 5NF           Any remaining anomalies have been removed The table in 0NF : eliminate the nulls by making sure that each repeating group attribute contains an appropriate data va
Read more

Database Types

-
Types of Databases Databases can be classified according to the number of users, o    Single user database - A single-user database that runs on a personal computer is called a desktop database o    Multi user database ·          Workgroup database - the multiuser database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization ·          Enterprise database Databases can be classified according to the database location(s), o    Centralized database - a database that supports data located at a single Site. o    Distributed database – a database that supports data distributed across several different sites The most popular way of classifying databases today, however, is based on how they will be used and on the time sensitivity of the information gathered from them. o    operational database (sometimes referred to as a transactional or production database) - A database that is designed primarily to suppor
Read more

Entity Relationship Diagram (Pat II)

-
Image
Mapping Binary Relationships One to one Relationship  Partial participation (Partial participation is represented by single lines.)           Not every professor teaches every student. Every student is not learnt by every professor.             Relational Mapping                                                                   Professor ( Name , Phone , Address )                                                                                       ↑FK            Course   ( CourseId  , CourseName , Credits , Name) Total Participation (Total participation is represented by double lines.)             Every professor teaches every student. Every student is learnt by every professor           Relational Mapping                      Professor ( Name , Phone , Address , CourseId , CourseName , Credits) One to many Relationship (Partial participation)           Relational Mapping                                          
Read more