Database Management Systems PDF

DATABASE MANAGEMENT SYSTEMS Reporting by AC2A - Group 3 WHAT IS DATABASE ? MANAGEMENT SYSTEM? is an application software which is used to perform various operations on data DBMS provides a platform for users to carry out different...

DATABASE MANAGEMENT SYSTEMS Reporting by AC2A - Group 3 WHAT IS DATABASE ? MANAGEMENT SYSTEM? is an application software which is used to perform various operations on data DBMS provides a platform for users to carry out different actions like database creation, updation, deletion and a lot more Aguinaldo, Maurine WHAT IS DATABASE ? MANAGEMENT SYSTEM? D ENTERPRISESOFTWARE ENTERPRISE SOFTWARE DEVELOPMENT DEVELOPMENT B DYNAMIC WEBSITE M S WEBSITE/BLOGS DATA BASE Aguinaldo, Maurine EXAMPLES OF DATABASE MANAGEMENT SYSTEM Aguinaldo, Maurine PURPOSES OF DATABASE MANAGEMENT SYSTEM (DBMS) Data Organization and Management It helps in organizing data systematically and efficiently. Store, retrieve, and manage large volumes of data Data Security It provides several security features like password protection, encryption, and access control. Perez, Janelle PURPOSES OF DATABASE MANAGEMENT SYSTEM (DBMS) Data Integrity refer to the accuracy and consistency of data over it lifecycle. minimizes errors Backup and Recovery DBMS allows data to be backed up and restored easily. ensures that important information is not lost permanently and can be recovered. Perez, Janelle PURPOSES OF DATABASE MANAGEMENT SYSTEM (DBMS) Concurrent Access and DataSharing enables multiple users to access and manipulate data at the same time without conflicts. Perez, Janelle TEN POPULAR DATABASE MANAGEMENT SYSTEMS (DBMS)  MYSQL MySQL is a free, open source relational database management system (RDBMS). It was initially owned by MySQL AB, before being acquired by Sun Microsystems (part of Oracle Corporation since 2010). MySQL was originally developed by Ulf Michael Widenius, Swedes David Axmark and Allan Larsson, founders of MySQL AB. Many database-driven web applications, such as WordPress, Joomla and phpBB, as well as many popular websites like MediaWiki, Twitter and Facebook, use MySQL. Developer: Oracle Corporation. Original author: MySQL AB. Latest MySQL release: MySQL 8.0.32. MySQL license: GNU General Public License version 2 and proprietary. Camacho, Jimarie MARIADB MariaDB is a community-developed, free and open source relational database management system. It is a fork of MySQL. MariaDB was originally developed by Ulf Michael Widenius, Swedes David Axmark and Allan Larsson, founders of MySQL AB and the MariaDB Foundation. Ulf Michael Widenius is the current lead developer and CTO of MariaDB. MariaDB is also included in numerous Linux distributions, such as CentOS, Debian and RHEL. Besides, it is used by many organizations such as Wikipedia, Google or Tumblr. Developer: MariaDB Corporation Ab and MariaDB Foundation. Latest MariaDB release: MariaDB 11.1.0. MariaDB license: GPL version 2. Camacho, Jimarie MICROSOFT SQL SERVER Microsoft SQL Server is a commercial relational database management system. It is available in multiple editions, divided into three main categories: mainstream, specialized and discontinued editions. Developer: Microsoft. Latest Microsoft SQL Server release: Microsoft SQL Server 2022. Microsoft SQL Server license: proprietary license. Camacho, Jimarie ORACLE DBMS A commercial, multi-model database management system. It is commonly used for running: online transaction processing (OLTP) and data warehousing (DW). Developer: Oracle Corporation. Latest Oracle DBMS long-term release: Oracle DBMS 19c. Latest Oracle DBMS release: Oracle DBMS 23c beta. Oracle DBMS license: proprietary license. Operating Systems: AIX, BS2000, HP-UX, Linux, MacOS and Windows Written in: Assembly language, C and C++ Fortus, Eden Shane POSTGRESQL A free, open source relational database management system (RDBMS). It was initially developed as a successor of the Ingres database, developed at the University of California, Berkeley. Developer: PostgreSQL Global Development Group. Latest PostgreSQL release: PostgreSQL 15.2. PostgreSQL license: PostgreSQL license. Operating Systems: FreeBSD, Linux, MacOS, OpenBSD and Windows Written in: C Fortus, Eden Shane MONGODB An open source, NoSQL, document-oriented database management system. MongoDB Inc. offers an integrated suite of cloud database services, as well as commercial support. This document-oriented database software is commonly used for high-volume data storage. Developer: MongoDB Inc. Latest MongoDB release: MongoDB 6.0.4. MongoDB license: Server Side Public License (SSPL). Operating Systems: FreeBSD, Linux, MacOS and Windows Written in: C++, JavaScript and Python Fortus, Eden Shane IBM DB2 IBM DB2 is a database management product developed by IBM, formerly known as DB2 for Linux, UNIX and Windows. Developer: IBM. Latest IBM DB2 release: IBM DB2 11.5.8. IBM DB2 license: proprietary license. Silva, Joice Ann Nicole V. ELASTICSEARCH Elasticsearch is a distributed, RESTful search and analytics engine. It is based on the Lucene library. Elasticsearch is the successorto a previous search engine called Compass, also designed by Shay Banon. Developer: Elastic NV. Latest Elasticsearch release: Elasticsearch 8.7. Elasticsearch license: dual-licensed Elastic license and Server Side Public License. Original author: Shay Banon. Silva, Joice Ann Nicole V. SQLITE SQLite is a public domain database engine that belongs to the embedded, relational database management systems family. It has bindings to many programming languages. Developer: Dwayne Richard Hipp. Latest SQLite release: SQLite 3.41.2. SQLite license: Public domain. Estomagio, Reene MICROSOFT ACCESS Microsoft SQL Server is a commercial relational database management system. It is available in multiple editions, divided into three main categories: mainstream, specialized and discontinued editions. Developer: Microsoft Latest Microsoft SQL Server release: Microsoft SQL Server 2022. Microsoft SQL Server license: Proprietary license. Estomagio, Reene THANK YOU !