Pt2520 Unit 1 Research Assignment

In: Computers and Technology

Submitted By dustinjgreen
Words 358
Pages 2
1. After reviewing the history on SQL server, I have found that there have been 7 revisions of the SQL standard. In the most recent, SQL 2011, there were many new non-temporal features. You have DELETE in MERGE, Pipelined DML, CALL enhancements, Limited fetch capability, Collection type enhancements, non-enforced table constraints, and window enhancements. With SQL:2011 replacing SQL:2008 as the standard in December of 2011, there were also some new DDL features that improved the usability of generated and identity columns.

2. SQL Express allows certain features that are available in the regular edition. The following are major features that are supported in SQL Express: Stored Procedures, Views, Triggers, Cursors, sqlcmd and osql utilities, Snapshot Isolation levels, Native XML support (including XQuery and XML Schemas) Transact-SQL language support, and dedicated administrator connection. In Oracle Express, you are able to use a browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate reports. DB2 Express is a no-charge community edition of DB2 data server and is ideal for small businesses and multi-branch companies. It includes self-managing capabilities and includes all of the core features of the larger DB2 editions which include Data Studio, Time Travel Query, PureXML and compression backup. After looking over all of the specs of each of these programs, I believe that SQL and Oracle are the top two. When we look into the finer details of things, my personal preference would be to go with SQL Express as there are many reviews that support it.
Bibliography
IBM. (2012). DB2 Express. Retrieved September 2012, from http://www-01.ibm.com/software/data/db2/express/about.html
Microsoft. (2012). SQL Express. Retrieved September 2012, from…...

Similar Documents

Pt250 Database Concepts Unit 1 Research Assignment

...Unit 1 Research Assignment The History Of SQL SQL was created in 1970 by Dr. E. F. Codd. There have been three revisions of the standard and they are SQL99, SQL2003 and SQL2008. The Query was the most recent edition of SQL. Microsoft SQL 2010 Express Features 1. Simplify Development Efforts Leverage Existing Skills Get started today developing on SQL Server with SQL Server Data Tools. Take advantage of existing Transact-SQL skills, and incorporate technologies, including the Microsoft ADO.NET Entity Framework and LINQ. Develop applications faster through deep integration with Visual Studio, Visual Web Developer, and SQL Server Management Studio. Improve Developer Productivity Increase developer productivity and simplify deployment through integration with Visual Studio and Visual Web Developer. Take advantage of advanced capabilities, including rich table and query designers, full integration with Server Explorer, and drag-and-drop IDE support for rapidly building data-bound applications. Tune the Design Process Manage SQL Server 2012 Express databases with SQL Server Management Studio Express. Connect to local SQL Server 2012 Express databases and manage objects with full Object Explorer integration. Write, execute, and test queries by using visual query plans that provide hints to tune queries and access management and maintenance options. 2. Develop Sophisticated Applications Rapid data exploration & visualization Discover...

Words: 751 - Pages: 4

Pt2520-Unit 1 Research-Exploring Programming Language

...Unit 1 Research Assignment 1: Exploring Programming Language Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex datbases. (Base, 2013). SQL was developed in the 1970’s by IBM to initially manipulate and retrieve data in IBM system R. The SQL language was standardized in 1986 by the American National Standards Institute (ANSI); however, later releases were released as International Organization Standardization (ISO) standards. (Inc., 2013) Although IBM authored SQL, the first SQL implementation was provided by Oracle Corporation (then called Relational Software Inc.). Early commercial implementations were concentrated on midsized UNIX-based DBMSs, such as Oracle, Ingres, and Informix. IBM followed in 1981 with SQL/DS, the forerunner to DB2, which debuted in 1983. (Unknown, 2010) ANSI published the first SQL standard (SQL-86) in 1986. An international version of the standard issued by ISO appeared in 1987. A significant update to SQL-86 was released in 1989 (SQL-89). Virtually, all relational DBMSs that you encounter today support most of the 1986 standard. (Unknown, 2010) In 1992, the standard was revised again (SQL-92), adding more...

Words: 802 - Pages: 4

Unit 2 Assignment 1 Disk Redundancy Research

...Assignment Title Unit 2. Assignment 1. Disk Redundancy Research Assignment Overview: Using the Internet and the ITT Tech Virtual Library, research the following questions, and provide your thoughts on each one. Submit your answers in a Word Document and ensure that you cite any resources you utilized with the proper APA format. 1. What does RAID stand for? RAID stands for Redundant Array of Inexpensive Disks 2. When would we use RAID? 3. Define the following types of RAID: a.RAID 0: Striped Set -- A RAID 0 setup splits data evenly across two or more disks. It is important to note that RAID 0 was not one of the original RAID levels, and is not redundant. If one drive goes down your server will need to be restored from backup b. RAID 1 Mirrored Set -- A Raid 1 setup creates an exact copy (or mirror) of data on two or more disks. A typical setup just has two drives that are setup to mirror data. If one drive goes down your server will still be functional until a scheduled drive replacement can be installed. c. RAID 5 Striped Set with Parity -- A RAID 5 setup uses block-level striping with parity data distributed across all disks in the RAID Array. This means you can have one drive fail and your server will remain functional until a scheduled drive replacement can be installed. RAID 5 also increases read/write speeds while using the available disk space efficiently. d. RAID 6 Similar to RAID 5 but not as widely used, RAID 6 performs either two parity......

Words: 422 - Pages: 2

Pt2520 Unit 1 True or False

...PT2520 Database Concepts GRADED ASSIGNMENTS ------------------------------------------------- Graded Assignment Requirements This document includes all of the assignment requirements for the graded assignments in this course. Your instructor will provide the details about when each assignment is due. Unit 1 Assignment 1: Homework Learning Objectives and Outcomes Describe the role of software for computers. Identify the hardware associated with a computer. Describe how computers store data. Explain how programs work. Differentiate among machine language, assembly language, and high-level languages. Differentiate between compilers and interpreters. Identify the different types of software. Assignment Requirements Answer the following true-or-false questions. Required Resources * Textbook Submission Requirements Submit your answers on the answer sheet provided to your instructor at the beginning of Unit 2. Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases, logical design is kept separate from physical design. 6) A......

Words: 7907 - Pages: 32

Pt1420 Programming Unit 1 Research Assignment

...prior to Miranda and Haskell. LML is a strongly typed, statically scoped implementation of ML, with lazy evaluation. The key innovation of LML was to demonstrate how to compile a lazy functional language. Until then, lazy languages had been implemented via interpreted graph reduction. LML compiled to G-machine code. LML is also notable as the language in which HBC, the Haskell B Compiler, was implemented. Modula-3 is a programming language conceived as a successor to an upgraded version of Modula-2 known as Modula-2+. While it has been influential in research circles (influencing the designs of languages such as Java, C#, and Python) it has not been adopted widely in industry. It was designed by Luca Cardelli, James Donahue, Lucille Glassman, Mick Jordan (before at the Olivetti Software Technology Laboratory), Bill Kalsow and Greg Nelson at the Digital Equipment Corporation (DEC) Systems Research Center (SRC) and the Olivetti Research Center (ORC) in the late 1980s. Modula-3's main features are simplicity and safety while preserving the power of a systems-programming language. Modula-3 aimed to continue the Pascal tradition of type safety, while introducing new constructs for practical real-world programming. SMALL, (Small Machine Algol Like Language), is a programming language developed by Dr. Nevil Brownlee of Auckland University. SMALL was used extensively from about 1980 to 1985 at Auckland University as a programming teaching aid, and for some internal projects.......

Words: 1885 - Pages: 8

Unit 2 Assignment 1: Disk Redundancy Research

...Unit 2 Assignment 1: Disk Redundancy Research December 14, 2013 1) What does RAID stand for? RAID stands for? RAID stands for Redundant Array of Independent Disks. 2) When would we use RAID? RAID can be used by either individual users or large network users to store data across multiple locations to increase fault tolerance. 3) Define the following types of RAID: a) RAID 0 b) RAID 1 c) RAID 5 d) RAID 6 RAID 0 | Strips data without redundancy. Provides faster performance, but it lacks fault tolerance. | RAID 1 | Known as disk mirroring. This method doesn’t strip data, it saves all data intact across at least two disks to provide fault tolerance. | RAID 5 | Uses rotating parity to store data. There is do data duplication, but the parity data can be used to reconstruct data. Mostly used by large organizations for data that is not performance sensitive. | RAID 6 | Same as RAID 5, but adds another parity scheme to increase fault tolerance. | 4) Why is RAID 0 of any use if it offers no redundancy? RAID 0 allows data to be broken up in order to allow faster access to data. 5) Why do you think that RAID 1 can be the most expensive? Why would people utilize it if it’s so costly? RAID 1 can be the most expensive because it requires an entire drive to make a duplicate of any data and the more copies you want, the more drives you need. People still use is because it makes complete copies of data, not partial ones. The complete copies allow......

Words: 405 - Pages: 2

Intro to Programming Unit 1 Research Assignment

...Unit 1 research assignment 1 1970’s 1) Pascal, Creator, Niklaus Wirth. The specific motivation behind this language was to encourage good programming practice using structured programming and data structuring. 2) SQL (Structured Query Language) designed by, Donald D. Chamberlin, and Raymond F. Boyce. The motivation behind this language was designed for managing data held in a relational database management system. ( RDBMS) 3) C, Designed by Dennis Ritchie. the motivation behind this language is structured programming and allows lexical variable scope and recursion. 4) Applesoft BASIC, developed by Marc McDonald, and Ric Weiland. The motivation with this language was it was designed to be backwards-compatible with integer BASIC and used the core of Microsoft’s 6502 BASIC implementation. 5) GRASS, Developed by Thomas A. DeFanti. GRASS is similar to BASIC in sytax, but added numerous instructions for specifying 2D object animation, including scaling, translation, rotation and color changes over time. 1980’s 1) BASICA, Designed by Thomas E. Kurtz. Designed to offer support for the graphics and sound hardware of the IBM PC line. 2) Turbo Pascal, developed by Borland, under Philippe Kahn’s leadership. This is a software development system that includes a compiler and an integrated development environment for the Pascal programming language. 3) C++, designed by Bjarne Stroustrup. This is a general purpose programming language that is......

Words: 677 - Pages: 3

Pt2520 Unit 1

...Unit 1 Research Assignment | Exploring Programming Languages | Cody Tidwell | PT2520 1.) Edgar Frank “Ted” Codd was a mathematician and also a computer scientist who never stopped believing. Going for his doctorate on a scholarship from IBM, his determination was proven to many. Once he finished his Ph.D., he worked for IBM where his work truly began to take off. He was the one proposed a set of “12 Rules”, which there are actually 13 when you include the 0). In SQL Server 2012 Service Pack 1 Cumulative Update 4, it expands the supported features for SQL Server backup and restores with Windows Azure Storage. In this release, new Powershell cmdlets have been added. MICROSOFT EXPRESS FEATURES Stored Procedures-SQL Server Configuration Manager Views-Replication (as a subscriber only) Triggers-Advanced Query Optimizer Cursors-SMO/RMO Sqlcmd and osql utilities-Integration with Visual Studio 2005 Snapshot Isolation Levels-Service Broker (as a client only) Native XML support, including XQuery and XML Schemas-SQL CLR Transact-SQL language support-Multiple Active Result Sets (MARS) Dedicated Admin Connection-Import/Export Wizard ORACLE EXPRESS FEATURES Interactive reports Declarative BLOB support Enhanced report printing Adding to the theme repository Optional runtime-only installation Improved security Application date format Application builder refinements DB2 EXPRESS FEATURES Bi-temporal data management Always on transactions Enhanced......

Words: 316 - Pages: 2

Unit 1 Research Assignment 1

...Database Concepts Unit 1 Research Assignment 1 Exploring Programming Languages SQL, in a simplest form, is a data sublanguage purposely invented to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database. SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Some of its features include processing sets of data as groups rather than as individual units, as well as provide automatic navigation to the data. Since SQL was first created there have been three major changes to the program and eleven minor changes. The latest major change addressed the requirement for objects and "object identifiers" in SQL and also specifies supporting features such as encapsulation, subtypes, inheritance, and polymorphism. Microsoft SQL Express is a free edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs. It includes the full version of SQL Server 2014 Management Studio and provides LocalDB; a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. Microsoft SQL Express even has the options of adding tools or advanced services to the express package.......

Words: 375 - Pages: 2

Pt2520 Unit 7 Research Assignment

...PT2520 Database Concept Unit 7 Research Assignment 1. What are the advantages of a declarative language as opposed to a procedural language? ANSWER: The advantage of declarative programming languages is mainly two-fold. The programs are concise; this makes it easy even for non-programmers to obtain solutions. In the SQL example above, an analyst or business support person can get the desired information. Similarly, laypersons can write acceptable web pages with simple HTML and CSS commands. The second advantage of the declarative programming model is that repetitive imperative code that indicates how to solve things is provided in the computer system behind the scenes. Such code can be made highly efficient and can incorporate the best ideas from computing. It can take advantage of parallelism 2. What advantages might a procedural language have over a declarative language? ANSWER: Procedural programming is used for developing simple applications. The languages that use the procedural programming methodology include Pascal and C languages. Some of the benefits of the procedural programming methodology are: (1) Easy to read program code. (2) Easy maintainable program code as various procedures can be debugged in isolation. (3) Code is more flexible as you can change a specific procedure that gets implemented across the program. 3. Why do you think cross joins are allowed as a legitimate join? What uses can you see for joins? ANSWER: I think that a cross-join......

Words: 324 - Pages: 2

Pt2520 Unit 1 Assignment 1

...Mike Garrison 12/15/14 PT2520 Unit 1 True or False 1) At its simplest, a database can be seen as a collection of related data. TRUE 2) A delimited file is a file where the length of the file is limited. FALSE 3) A delimited file is one in which the data is separated by a character such as a comma. TRUE 4) Al fixed length files are of the same length. TRUE 5) In relational databases, logical design is kept separate from physical design. TRUE 6) A hierarchical database is designed with a tre-like structure that resembles a file system. TRUE 7) Cod defined the core principles of a relational database in 1970. TRUE 8) Data redundancy improves the integrity of a database. FALSE 9) In a diagram, crows fet notation conveys more information about The relationships. TRUE 10) A primary key uniquely identifes each row in a database table. TRUE 11) In a relational database, alL data is kept in tables, even the information about the tables. TRUE 12) SQL is the language used by relational databases to create objects and to manipulate and retrieve data. TRUE 13) An entiy is someone who is interested in the database. FALSE 14) In a statement of scope, a constraint is a limit on what he database wil do. TRUE 15) Oracle is a popular relational database management system. TRUE 16) A relational database management system does not include tools for backing up and restoring databases. FALSE 17) Documentation is not an important part of database development. FALSE 18) In a......

Words: 316 - Pages: 2

Pt2520 Unit 5 Assignment 1,Unit 5 Research Paper 1 and Quiz 4

...Lab 5.1 Unit 5 Assignment 1 1) Choosing a database management system requires a great deal of analysis. TRUE 2) When choosing a database management system, you should consider system compatibility and hardware requirements. TRUE 3) Only insert and update statements are part of a database transaction. FALSE 4) Physical design is independent of any particular database management system. FALSE 5) A data type is a column specification that determines what kind of data can be stored in it. TRUE 6) Int, decimal and money are character numeric types. TRUE 7) Char and NChar are variable-length character types. FALSE 8) Varchar and NVarchar are variable length character types. TRUE 9) NChar and NVarchar are based on the unicode character set. TRUE 10) Unicode is an expanded character set that contains non-Latin characters. TRUE 11) A null is the same as a 0 or an empty string. FALSE 12) You should not allow nulls in columns that are critical to your business rules. TRUE 13) Tables can only be created by SQL statements in SQL Server. FALSE 14) Referential integrity exists when every foreign key relates to a primary key. TRUE 15) When referential integrity is in effect, you cannot delete a record in the primary key table until you have first deleted all the related records in the foreign key table. TRUE 16) When referential integrity is in effect, you can only enter records in the foreign key side of the relation if it relates directly to a record in the primary key......

Words: 1792 - Pages: 8

Pt2520 Unit 1 Assignment 1

...Joseph McKinney PT2520 Unit 1 research assignment There have been 7 revisions of the SQL standard. In the most recent, SQL 2011, there were many new non-temporal features. You have DELETE in MERGE, Pipelined DML, CALL enhancements, Limited fetch capability, Collection type enhancements, non-enforced table constraints, and window enhancements. With SQL:2011 replacing SQL:2008 as the standard in December of 2011, there were also some new DDL features that improved the usability of generated and identity columns. SQL Express allows certain features that are available in the regular edition. The following are major features that are supported in SQL Express: Stored Procedures, Views, Triggers, Cursors, sqlcmd and osql utilities, Snapshot Isolation levels, Native XML support (including XQuery and XML Schemas) Transact-SQL language support, and dedicated administrator connection. In Oracle Express, you are able to use a browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate reports. DB2 Express is a no-charge community edition of DB2 data server and is ideal for small businesses and multi-branch companies. It includes self-managing capabilities and includes all of the core features of the larger DB2 editions which include Data Studio, Time Travel Query, PureXML and compression backup. After looking over all of the specs of each of these programs, I......

Words: 268 - Pages: 2

Unit 3 Research Assignment 1

...Unit 3 Research Assignment 1 Exploring Reverse Engineering Reverse engineering can be viewed as the process of analyzing a system to: 1. Identify the system's components and their interrelationships 2. Create representations of the system in another form or a higher level of abstraction 3. Create the physical representation of that system. Reverse engineering is very common in such diverse fields as software engineering, entertainment, automotive, consumer products, microchips, chemicals, electronics, and mechanical designs. For example, when a new machine comes to market, competing manufacturers may buy one machine and disassemble it to learn how it was built and how it works. A chemical company may use reverse engineering to defeat a patent on a competitor's manufacturing process. In civil engineering, bridge and building designs are copied from past successes so there will be less chance of catastrophic failure. In software engineering, good source code is often a variation of other good source code. Reverse engineering enables the duplication of an existing part by capturing the component's physical dimensions, features, and material properties. Before attempting reverse engineering, a well-planned life-cycle analysis and cost/benefit analysis should be conducted to justify the reverse engineering projects. Reverse engineering is typically cost effective only if the items to be reverse engineered reflect a high investment or will be reproduced in large......

Words: 342 - Pages: 2

Unit 6 Research Assignment 1

...PT2520 Database Concepts Unit 6 Research Assignment 1: Explore the latest ANSI and ISO Standard True/False 23-Jul-2016 Tim Church Daigre ANSI- The American National Standards Institute (ANSI) oversees the creation, promulgation and use of thousands of norms and guidelines that directly impact businesses in nearly every sector: from acoustical devices to construction equipment, from dairy and livestock production to energy distribution, and many more. ANSI is also actively engaged in accreditation - assessing the competence of organizations determining conformance to standards. To enhance both the global competitiveness of U.S. business and the U.S. quality of life by promoting and facilitating voluntary consensus standards and conformity assessment systems, and safeguarding their integrity. ISO- International Organization for Standardization (ISO) is an independent, non-governmental international organization with a membership of 163 national standards bodies. Through its members, it brings together experts to share knowledge and develop voluntary, consensus-based, market relevant International Standards that support innovation and provide solutions to global challenges. Part II- The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006 and is often referenced as "SQL/XML:2006". ANSI/ISO/IEC 9075:2003, "Database Language SQL", Parts 1......

Words: 278 - Pages: 2