MySQL is most useful Relational Database Management System (RDBMS), that is also Open Source Database and free of Cost available in the Internet market.
 |
| MySQL |
Basic of Database, Table and SQL:
Database is a collection of data and made up of tables. Table is a made up of columns and rows. Columns are like a categories and each row of table is known as entry or record. All tables should have primary key. primary key defines 100% unique column.
SQL stands for Structured Query Language. MySQL is a program that understands SQL.
Basic of MySQL:
MySQL is faster, more reliable, and cheaper.
Features of MySQL:
- Relational Database System
- Client/Server Architecture
- SQL Support
- Views
- Stored Procedures
- Triggers
- User Interface
- Replication
- Transaction
- GIS functions
- Programming Languages
- ODBC
- Platform Independence
- Speed
Some Advantage of MySQL:
- Open Source
- Security
MySQL Table Types / Storage Engine:
- MyISAM
- The default MySQL storage engine and the one that is used the most in Web, data warehousing, and other application environments. MyISAM is supported in all MySQL configurations, and is the default storage engine unless you have configured MySQL to use a different one by default.
- InnoDB
- The InnoDB tables fully support ACID-compliant and transactions. They are also very optimal for performance. InnoDB table supports foreign keys, commit, rollback, roll-and forward operations. The size of the InnoDB table can be up to 64 - TB. Like MyISAM, the InnoDB tables are portable between different platforms and OSes. MySQL also checks and repair InnoDB tables, if necessary, at startup.
- Merge
- Enables a MySQL DBA or developer to logically group a series of identical MyISAM tables and reference them as one objectMemory.
- Memory
- Stores all data in RAM for extremely fast access in environments that require quick lookups of reference and other like data. This engine was formerly known as the HEAP engine.
- Archive
- Provides the perfect solution for storing and retrieving large amounts of seldom-referenced historical, archived, or security audit information.
- CSV
- The CSV storage engine stores data in text files using comma-separated values format. You can use the CSV engine to easily exchange data between other software and applications that can import and export in CSV format.
- Federated
- Offers the ability to link separate MySQL servers to create one logical database from many physical servers. Very good for distributed or data mart environments.
MySQL Website and Download Link:
- Website: MySQL Official Website
- Download: MySQL Download
0 comments :
Post a Comment