Exploring Programming Languages
Misty Moore
September 23, 2014
PT2520
Unit 1 Exploring Programming Languages In 1970 Dr. E.F. Codd published a paper “A Relational Model of Data for Large Shared Data Banks”. Codd’s model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation Inc., to use Codd’s model. SEQUEL later was shortened to SQL. In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard language.1 SQL has gone through three major revisions and several minor revisions: SQL1-Also known as SQL-86. The first publication of this version was in 1986 by ANSI. Shortly after ANSI also published two minor revisions SQL1:SQL-87 and SQL-89. The second major revision of SQL was SQL2- Also known as SQL/92, SQL-92, and ISO/IEC 9075: in 1992 once again by ANSI. The third major revision was SQL3 – Also known as SQL: 1999 probably due to the fact it was introduced in 1999. Several minor changes were made inside SQL: 1999. They were published on SQL3; SQL: 2003, SQL: 2006 and SQL: 20082 The most recent one I found was with Microsoft and they have SQL Server 2014. So seems they are still constantly updating SQL just like with any software or hardware in the computer business. Microsoft Express Edition offers In-Memory Built-In, Enhanced Security & Scalability, High Availability, Mission Critical Support, and Easy Access to Data, Big & Small, Powerful Insights with Familiar Tools, Complete BI Solution, Hybrid Cloud Scenarios, Easy On-Ramp to Cloud, and Complete & Consistent.3 With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations. Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per
September 23, 2014
PT2520
Unit 1 Exploring Programming Languages In 1970 Dr. E.F. Codd published a paper “A Relational Model of Data for Large Shared Data Banks”. Codd’s model is now accepted as the definitive model for relational database management systems (RDBMS). The language, Structured English Query Language (SEQUEL) was developed by IBM Corporation Inc., to use Codd’s model. SEQUEL later was shortened to SQL. In 1979, Relational Software, Inc. (now Oracle) introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard language.1 SQL has gone through three major revisions and several minor revisions: SQL1-Also known as SQL-86. The first publication of this version was in 1986 by ANSI. Shortly after ANSI also published two minor revisions SQL1:SQL-87 and SQL-89. The second major revision of SQL was SQL2- Also known as SQL/92, SQL-92, and ISO/IEC 9075: in 1992 once again by ANSI. The third major revision was SQL3 – Also known as SQL: 1999 probably due to the fact it was introduced in 1999. Several minor changes were made inside SQL: 1999. They were published on SQL3; SQL: 2003, SQL: 2006 and SQL: 20082 The most recent one I found was with Microsoft and they have SQL Server 2014. So seems they are still constantly updating SQL just like with any software or hardware in the computer business. Microsoft Express Edition offers In-Memory Built-In, Enhanced Security & Scalability, High Availability, Mission Critical Support, and Easy Access to Data, Big & Small, Powerful Insights with Familiar Tools, Complete BI Solution, Hybrid Cloud Scenarios, Easy On-Ramp to Cloud, and Complete & Consistent.3 With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations. Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per