SQL -Chapter 1 Part 3
What are the good and bad of DB2's reputation?
Good: DB2 is reliable and easy to use. Bad: DB2 is expensive.
What is the good and bad of SQL Server's reputation?
Good: Inexpensive and easy to use. Bad: Does not work well on systems with a large number of users.
What is the good and bad of Oracle's reputation?
Good: Oracle has a reputation for being reliable. Bad: Oracle has a reputation for being expensive and difficult to use.
In 1985, what happened with SQL?
IBM came out with DB2 (Database 2).
What happened in 1970 with SQL?
In 1970, Dr. E. F. Codd published an article that described the relational database model he had been working on with IBM.
What happened in 1979 with SQL?
In 1979, relational software inc. released the first relational database management system called Oracle.
In 1982, what happened with SQL?
In 1982, IBM released their first commercial SQL-based RDBMS called SQL/DS (SQL/Data System).
In 1995, what happened with SQL?
In 1995 MySQL was released.
In 2000, what happened with SQL?
In 2000, MySQL became an open-source database.
What is the newer version of an ER diagram known as?
It is known as EER or enhanced entity-relationship diagram.
When is Microsoft SQL Server used?
Microsoft (MS) SQL Server is used for small- to medium-sized systems that run on one or more Windows servers.
What do most companies use for their operating system when it comes to mission-critical applications?
Most large companies use z/OS and Unix because they are more stable and secure than Windows. As a result, they can't use SQL server and must use Oracle, DB2, or MySQL.
What company developed MySQL?
MySQL AB
What has happened since 2000 with MySQL?
MySQL has become one of the most popular databases, especially for web applications. In 2008, MySQL was acquired by Sun Microsystems, and in 2010 Oracle bought Sun Microsystems.
When is MySQL used?
MySQL is a popular open-source database that runs on all major operating systems and is commonly used for web applications.
MySQL is an open-source database, what does this mean?
MySQL is an open-source database which means that any developer can view and improve its source code.
What operating system does MySQL work on?
MySQL runs on all major operating systems and is widely used for web applications.
What is the main difference between MySQL and SQL server?
MySQL runs under most operating systems including Unix, Windows, Mac OS, and IBM's z/OS. SQL Server only runs on the Windows operating system.
Did SQL/DS and DB2 run on any computer?
No, both systems only ran on IBM mainframe computers. However, it was later ported to Unix and Windows.
On large systems, who uses DDL statements?
On large systems DDL is used exclusively by database administrators (DBAs).
On smaller systems, who fulfills the role of the DBA?
On smaller systems the SQL programmer may fill the role of the DBA.
When is Oracle used?
Oracle is used for large, mission-critical systems that run on one or more Unix servers.
What servers use Oracle the most?
Oracle is widely used by servers running the Unix operating system.
What did Oracle originally run on and what language did it use?
Oracle ran on a microcomputer and used SQL as its query language.
What types of systems does Oracle work well on?
Oracle works well on large systems.
What were databases like before the release of the first relational database management system?
Prior to the release of the first relational database management system, each database had a unique physical structure and a unique programming language that the programmer had to understand. This changed when SQL came about.
What types of systems use SQL Server?
SQL Server is widely used by small- to medium sized department systems.
Who created SQL Server?
SQL Server was designed by Microsoft to run on Windows.
In 1989, what happened with SQL?
The American National Standards Institute (ANSI) published its first set of standards for a database query language.
What is the job of the Database Administrator (DBA)?
The DBA's job is to maintain existing databases, tune them for faster performance, and create new databases.
Is MySQL free?
The MySQL Community Server is free for most users, although Oracle also sells an Enterprise Edition of MySQL that has advanced features.
What is the benefit of using standards in SQL?
The main benefit of standards is that the basic SQL statements are the same in each dialect.
What kind of diagram can you use when working with relational databases?
When working with relational databases, you can use an entity-relationship (ER) diagram
What are the two categories that SQL statements can be divided into?
1. Data Manipulation Language (DML) 2. Data Definition Language (DDL)
What are the four most popular databases?
1. MySQL 2. Oracle 3. DB2 4. Microsoft (MS) SQL Server
Does every vendor use SQL the same?
Although SQL is a standard language, each vendor has its own SQL dialect, or variant, that may include extensions to the standards.
What is IBM's premier database system?
DB2 is IBM's premier database system.
When is DB2 used?
DB2 is typically used for large, mission-critical systems that run on legacy IBM mainframe systems using the z/OS or OS/390 operating system.
What types of systems does DB2 work well on?
DB2 works well on IBM mainframes and it works well on hybrid environments where IBM mainframes and newer servers coexist.
What is DDL?
DDL stands for Data Definition Language and these are statements that create databases and work with objects within a database.
What is DML?
DML stands for Data Manipulation Language and these are statements that work with the data in a database.
What does an entity-relationship diagram show?
ER diagrams show how the tables in a database are defined and related.