MYSQL

 MYSQL

             

Introduction of mysql

                           MYSQL was owned and sponsored by swedish comany  MYSQLAB, which was brought by sun microsystem and now oracle coporation, mysqlab is a creater of  relational database management system.

                           mysql is an open  source relational database management system (RDBMS), mysql co-founder Michael widenius ,initial release 23 may 1995 nearly 25 years ago, operating system are linux, macOS, windows, solaris. written by c,c++ language  fast reliable ,easiness to use. In current market many application are provide mysql including giant industries such as twitter , facebook and service based application such as youtube, twitter many more.


Relational database management system.

                           The relational database management system  and database management system are designed specific for relational database . A relational database store huge data in structured format using row and column .it easy locate and assess specific values in the database.

Advantages (RDBMS)

                      >Multi-user access

                      >privileges

                      >Network access

                         > Speed

                         > Maintenance

Multi -user access

                     RDBMS allow multiple database users to access a database simultaneously. built-in locking and transaction

Privileges

                    Authorization and privilege control features in RDBMS. grand privilegas to individual users based on the task they need to perform. Authorization can be defined based on the client ip address

Network Access

                  User do not able to login to the physical computer system to the database 

                  network access allows developers to build desktop  tools and web applications to insert with the database

speed

                 The relational database model is not the faster data structure

                  improvements in technology , increasing processor speeds and decreasing memory and the storage cost  allow system admin to build incredibly fast system that can overcome any database 

Maintenance

                  RDBMS database admin with tools to easily maintain, test, repair, and backup the database

                  Automation tools available on the operating system

Language

                  RDBMS support a generic language called Structured Query Language    

                  simple syntax and language used standard english  language and easy to learn 

              

DATABASE USED IN REAL LIFE 

              Banks use database to keeps track of customer account ,balances and deposits ,customer information  that data should be stored and easily retrieved

How mysql work

             Mysql creates  a database for storing data the relationship of each table.

             Mysql clients can make requests by typing  SQL statements on mysql

Comments

Post a Comment

Popular posts from this blog

Python if....elif....else statements

Image
python if... Statements:                python if..  statement is used for decision making operation.      It contains the body of code which will run only when the conditions given in the if statement is true if only ---- when condition True : if.. flowchart Example: #if only ------ condition true x = 100 y = 50 if x > y: print ( "greater then y" ) print ( "condition true" ) Output: greater then y condition true                In this example we have two variable x=100,y=50 and we create if expression [if x > y:] then we give statement [print("greater then y")]    if condition expression is true then statement is pass .then outside of if statement print will be execute. if only ---- when condition False:               I n this example we have two variable x=100,y=50 and we create if expression [if x < ...
Read more

What is InnoDB - Why InnoDB use - ACID properties

InnoDB innodb is a storage engine database management system (DBMS) MySQL and MariaDB InnoDB release on MySQL 5.5.5 in 2010 its provide ACID-compliant transaction features what is InnoDB in MySQL InnoDB has evolved from being a storage subsystem to a general-purpose storage engine for MySQL.                  Its combination of high performance and high reliability,                  It was made the default storage engine from Version 5.6 onwards.                MySQL can handle large volumes of reads and writes                A DBMS is a tool that allows you to store, index, and retrieve data in a table ACID:                  Atomicity, consistency, isolation, durability is a set of properties of data...
Read more

Object-oriented programming (OOPs)-python

 OOPs Concepts:                  An object-oriented programming is to design the program using classes and objects.     The object is related to real-word entities such as book, house, pencil, etc.     OOPs concept code writing is reusable code Principles of OOPs:                  C lass       Object       Method       Inheritance       Polymorphism       Data Abstraction       Encapsulation Class:         Class can be define as collection of object. The class have some specific attributes and methods.   For example: If you have school class, The it must contain an attribute and method     i.e an student name,roll num,email id,age, DOB Example:               ...
Read more