ITC 121 BLOG SERATO

ITC 121

BLOG PROJECT #1

First is what is Database?

A database is a logically organized collection of structured data kept electronically in a computer system. A database management system is usually in charge of a database (DBMS). Data may then be accessed, managed, updated, regulated, and organized with ease.

The 2 Database that I have chosen are MySQL and Microsoft SQL Server because this are some of the popular database software,

MySQL

MySQL is a relational database management system that is free and open-source. "My" is the name of co-founder Michael Widenius's daughter, and "SQL" is the abbreviation for Structured Query Language.

The Components of MySQL:

Hardware - Many database-driven web programs, such as Drupal, Joomla, phpBB, and WordPress, use MySQL. Many major websites, such as Facebook, Flickr, MediaWiki, Twitter, and YouTube, use MySQL.

Software - Relational database management software

People - Used for a wide range of purposes, including data warehousing. e-commerce, and logging applications.

Procedure - Parameter has three modes IN, OUT, and INOUT

Data - Storing application data, specifically web application data. Additionally, if you need a relational database that holds data across several tables, MySQL is the way to go. MySQL is a relational database, thus it's a suitable choice for multi-row transaction-heavy applications.

Microsoft SQL Server

Microsoft SQL Server is a relational database management system. It is a database server, which is a software product whose principal role is to store and retrieve data as required by other software applications—which may run on the same computer or on a networked computer.

The Components of Microsoft SQL Server:

Hardware - SQL Server requires a monitor with a resolution of 800x600 pixels or greater. Internet access is required for Internet functionality (fees may apply). All other editions: a minimum of 4 GB, which should be increased as the database grows in size to ensure best performance. Only x64 processors are supported for SQL Server installation.

Software - Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide range of transaction processing, business intelligence, and analytics applications.

People - the system is designed and built to manage and store information.

Procedure - Batch of statements grouped as logical unit and stored in the database

Data - Saves the data to a series of 8KB pages inside the data file.

The Advantages and Disadvantages of each database system that I have chosen to present.

Video Link: ADVANTAGES AND DISADVANTAGES OF MYSQL AND MS SQL - YouTube

REFERENCES:

MySQL

What is MySQL? Everything You Need to Know | Talend

Architecture of MySQL - GeeksforGeeks

What is MySQL and how do I use it? | 123 Reg Support (123-reg.co.uk)

What you need to know about MySQL for Data Analysis (chartio.com)

SQL Server 2019: Hardware & software requirements - SQL Server | Microsoft Docs