PT2520 Unit 1 Research Assignment

Topics: SQL, Relational model, Database Pages: 1 (452 words) Published: October 28, 2014

SEQUEL or SQL is a data language that provides benefits for all types of users. SQL’s purpose is to provide an interface to a relational database such as Oracle Database. Dr. Edgar Frank “Ted” Codd introduced the first commercially available implementation of SQL. Today, SQL is accepted as the standard RDBMS language. The features of SQL include processing sets of data as groups rather than as individual units and providing automatic navigation to the data. It uses statements that are complex and powerful individually, and that therefore stand alone. Flow-control statements were not part of SQL originally, but they are found in the recently accepted optional part of SQL. Flow-control statements are commonly known as "persistent stored modules" (PSM), and the PL/SQL extension to Oracle SQL is similar to PSM. Major commercial database developers have set a trend of offering “Express” versions of their databases. Companies such as Microsoft, Oracle and IBM DB2 are a part of this trend setting. Microsoft has a program called SQL Express which has the following features; SQL Server Configuration Manager, Replication, Advanced Query Optimizer, SMO/RMO, Sqlcmd, and Integration with Visual Studio 2005. SQL Express all has snapshot isolation level features, Native XML support, SQL language support-Multiple Active Result Sets (MARS), and Dedicated Admin Connection-Import/Export Wizard. These features are different than that of Oracles express version. Some of the software limitations include a 1GB maximum memory, the maximum size of each relational database. Oracle Express is Oracle’s express edition of their SQL database. This edition has many different features that can be used. Some of those features include; Interactive reports, Declarative BLOB support, Enhanced report printing, adding to the theme repository, Optional runtime-only installation, improved security, Application date format, and Application builder refinements. These features are used to create...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • PT2520 Unit 1 Research Assignment 1 Essay
  • assignment brief unit 1 Essay
  • Unit 1 Research Assignment 1: Exploring Programming Languages Essay
  • Essay on Unit 2 Research Assignment 1
  • Essay on Pt2520 Unit 8 Research Assignment
  • Unit 1 Research Paper
  • Essay on unit 1 assignment 1
  • pt2520 assignment 1 Essay

Become a StudyMode Member

Sign Up - It's Free