Relational Database Model and Management Systems Overview
"Explore the fundamentals of relational databases, including data organization, DBMS functions, merits and demerits, and popular implementations like MySQL, SQLite, and PostgreSQL. Learn about constraints, data structures, and common terms in the context of database management. Enhance your knowledge of data handling and storage systems."
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
an International CBSE Finger Print School Coimbatore SUBJECT NAME-Computer Science GRADE-XII UNIT Relational Database
CONSIDER AN EXAMPLE What is data? Data can be facts to any object in consideration Example: your name, age, height, weight, etc. What is database? Database is a systematic collection of data. They support electronic storage and manipulation of data. The data can be easily accessed, managed, modified, updated controlled and organized. 5/26/2020 2/12 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
What is dbms? The dbms (database management system) refers to a software that is responsible for storing, maintaining and utilizing databases. 5/26/2020 3/12 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Merits: Data redundancy Data inconsistency Provide import and export. Shared by multiple application Demerits: High cost for installing. Cost of staff training. Database failure may cause data loss. . 5/26/2020 4 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Relational database model In relational data model, Data organized in tables(rows and column) relations Rows of relations are generally referred as tuples. Column of relations are generally referred as attributes. 5/26/2020 5 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Relational Database Term Byte: a byte is a group of 8 bits and used to store character. Data item: a data in a cell . Record: a complete unit of information in a rows. Table: file that holds all the data. Field: one type of information in a columns. 5/26/2020 6 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
MYSQL, SQLite, PostgreSQL, Microsoft SQL server, IBMDB2, etc., out of these MYSQL, SQLite, PostgreSQL are open source implementation. 5/26/2020 7 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Run on virtually all platforms, including Linux, Unix and Windows Popular for web based applications and online publishing. LAMP(Linux, Apache, MYSQL, PHP ). 5/26/2020 8 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
SQLite SQLite is not a client-server database engine, rather its is embedded into the end of the program. It is used by several widespread browsers, operating systems, embedded system. 5/26/2020 9 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
PostgreSQL Object-RDBMS, most advanced open source DBM. It is free and open source. 5/26/2020 10 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
MYSQL MySQL is a freely available open source Relational Database Management System(RDBMS) that uses Structured Query Language(SQL). It is downloadable from site www.mysql.org. In a MySQL database information is stored in Tables. A single MySQL database can contain many tables at once and store thousands of individual records. It support a secure environment for storing,maintaining and accessing data. MySQL is a fast,reliable,scalable alternative to many of the commercial RDBMSs available today. 5/26/2020 11 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Mysql Database System The server(MySQL server) listens for client requests coming in over the network and accesses database contents according to those requests and provides that to the clients. Clients are programs that connect to the database server and issue queries in a pre-specified format. 5/26/2020 12 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
Some of the key features of MySQL are 1.Speed -> It runs very fast ,It supports clustered servers for demanding applications. 2.Ease of use -> High performance,Relatively simple database system. It has been configured,monitored and managed from the command line.Graphical interfaces are also available. 3.Cost -> Free of cost,It is a open source database.It is a part of LAMP(Linux,Apache,Mysql,PHP) 4.Query Language support -> Mysql understands standard based SQL (Structured Query Language) 5.Portability -> Broad range of different compilers and can work on many different platforms. 6.Datatypes ->Mysql provides many datatypes to support different types to support different types of data.It also supports fixed-length and variable-length records 5/26/2020 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY 13
7.Security -Mysql offers a privilege and password system that is very flexible and secure and that allows host based verification.Passsword traffic is encrypted when you connect to a server. 8.Scalability and limits-It can handle large databases.Some real life MYSQL databases contain 50 million records. 9.Connectivity clients can connect to MYSQL server using several protocols 10.Locialization The server can provide error messages to clients in many languages. 11.Clients and Tools Mysql provides several clients and utility programs.These include both command-line programs such as mysqldump and mysqladmin and graphical programs such as Mysql Administrator and Mysql Query Browser. 5/26/2020 14 CONSTRAINT SATISFACTION PROBLEM/16CS318-ARTIFICIAL INTELLIGENCE/MONISHA R/MATHS/SNS ACADEMY
