Create a spreadsheet or Word table similar to the table below. As you go through
ID: 3920651 • Letter: C
Question
Create a spreadsheet or Word table similar to the table below. As you go through the chapters this quarter, begin listing commands and show the differences in the syntax among MySQL, Oracle, SQL Server, and DB2. You will basically be creating a document along the lines of a quick reference or documentation guide for database users. Give examples of each of the commands you choose to document. You must have a minimum of two commands from each chapter. Feel free to include any other topics not included in the text or any additional DBMS.
Command
MySQL
Oracle
SQL Server
DB2
Additionally, discuss the different indexing options for MySQL and Oracle – and which index types might be best suited for different types of data.
Command
MySQL
Oracle
SQL Server
DB2
Explanation / Answer
MYSQL Indexes:
What is an index how is it used?
Indexes are mainly used to find the rows with specific column. If a data in the middle of the table need to be found, without indexes,MYSQL had to
search the entire table which takes lot of time and costs. Hence indexing comes into picture. So that each column is indexed so that the search can be
done quickly even in the middle of the data file without having to look at the entire data.
MYSQL uses PRIMARY KEY indexing, UNIQUE indexing, FULL TEXT indexing on B Trees.
MySQL uses indexes in finding the rows matching a WHERE clause quickly.
Oracle Indexing:
There are many types of indexing in Oracle. As Follows:
b-Tree Index, Function based Index, Reverse Key Index, Bitmap Index,Bitmap join Index, Compressed Index, Partitioned Index, Cluster Index, Index organised tables, Descending, Domain Index, Invisible Index, Virtual Index
Command MYSQL SQL Oracle DB2 storage group No storage group. only database No storage group. only database No storage group. only database db2 select * from syscat.stogroups(to see list of available storage groups) tablespace Only table no tablespace Only table no tablespace Only table no tablespace db2 create tablespace <tablespace_name> using stogroup <stogroup_name> (Creating a tablespace to a storage group) create table CREATE TABLE table_name (column1 datatype,column2 datatype,column3 datatype,..); CREATE TABLE table_name (column1 datatype,column2 datatype,column3 datatype,..); CREATE TABLE table_name (column1 datatype,column2 datatype,column3 datatype,..); db2 create table <schema_name>.<table_name> (column_name column_type....) in <tablespace_name> listing table db2 select tabname, tabschema, tbspace from syscat.tables insert INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...); INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...); db2 insert into <tab_name>(col1,col2,...)
values(val1,val2,..) select SELECT * FROM table_name SELECT * FROM table_name; SELECT * FROM table_name db2 select * from <tab_name> index ALTER TABLE table_name
DROP INDEX index_name; DROP INDEX table_name.index_name; DROP INDEX index_name; DROP INDEX index_name;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.