Database Paper

Topics: SQL, Microsoft SQL Server, Relational model Pages: 2 (440 words) Published: June 24, 2013
There have been 6 revisions in SQL, 3 major revisions and 4 minor revisions as well. The three major revisions were SQL-86, SQL-92, and SQL:1999, and the four minor revisions were SQL:2003, SQL:2006, SQL:2008, and SQL:2011. [1] The updates in SQL:2011 are Periods, Application-time period tables, System-versioned tables, and Bitemporal tables. Application-time period tables have Primary keys, Referential constraints, and Querying and System-versioned tables have Primary key, Referential constraints, Querying. [2]

Microsoft’s SQL Express Versions are Express with Advanced Services, Express with Tools, and SQL Server Express. The advanced services have a database engine, full text search, reporting services, business intelligence development studio, and SQL server management studio. The tools have a database engine, and SQL server management studio. The SQL Server SQL Express has just a Database engine. The Limitations are there can only be 1 CPU, only 1GB of memory, only 10GB of size, and you can only do replication if you are a subscriber. [3]

Oracle Database 11g Express has limitations of 1 CPU, 1GB of RAM, 4GB of Size, and only useable with Windows and Linux. It has Features of flashback query, data encryption, SQL developer, Application Express, XML Support, .Net Support, Auto memory management, auto undo management, advanced queuing, distributed queries and transactions, XML DB, Text, and Locator. [4]

DB2 Express features are Time Travel Query, integrated tools environment, Graph Store Technology, SQL Compatibility Feature, and IBM Mobile Database sync and support. Its limitations are only 2 processor cores and 4GB of memory. [5]

DB2 offers the most space out of all of them, but the least performance and a decent amount of RAM. Oracle offers the best performance with RAM, but the least amount of size. Microsoft has good Performance, but the least amount of RAM and the middle ground for database size. Works Cited

[1] | D. H. Yang, "SQL History and...

Cited: [1] | D. H. Yang, "SQL History and Revisions," 2012. [Online]. Available: http://www.herongyang.com/MySQL/SQL-History-and-Revisions.html. [Accessed 18 06 2013]. |
[2] | K. Kulkarni and J.-E. Michels, "sigmod.org," 09 2012. [Online]. Available: http://www.sigmod.org/publications/sigmod-record/1209/pdfs/07.industry.kulkarni.pdf. [Accessed 18 06 2013]. |
[3] | R. Barley, "mssqltips," Edgewood Solutions, 26 05 2010. [Online]. Available: http://www.mssqltips.com/sqlservertip/2024/introduction-to-sql-server-express-2008-r2/. [Accessed 18 06 2013]. |
[4] | "Oracle.com," Oracle, [Online]. Available: http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html. [Accessed 18 06 2013]. |
[5] | "DB2 Express-C," IBM, [Online]. Available: http://www-03.ibm.com/software/products/us/en/db2expressc. [Accessed 18 06 2013]. |
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • database Essay
  • Database Notes Essay
  • reserach paper
  • Database Design: Notes Essay
  • Database Essay
  • Database Access Options in .Net Framework Essay
  • Sql Introduction to Database Essay
  • Essay on Use of Database Management Systems to Meet Business Needs.

Become a StudyMode Member

Sign Up - It's Free