information technology Essay

Submitted By ackwrestler
Words: 631
Pages: 3

SQL Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Although SQL is often described as, and to a great extent is, a declarative language (4GL), it also includes procedural elements. SQL was one of the first commercial languages for Edgar F. Codd's relational model, as described in his influential 1970 paper "A Relational Model of Data for Large Shared Data Banks". Despite not entirely adhering to the relational model as described by Codd, it became the most widely used database language. There have been 3 major revisions. And the latest was in 1999.
As the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well as quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence. SQL Server 2012 helps deliver predictable and next-generation performance backed by customer, partner, and industry-leading benchmarks. Investigate new benchmark results published with hardware partners, such as Dell, HP, NEC, IBM, and Unisys, that demonstrate leading performance and scalability results for SQL Server against TPC-E, the most rigorous industry-standard measure of OLTP performance.
With respect to growing needs for storage, Oracle Database 11g XE now offers a full 11GB for user data alone, which is almost threefold increase since previous 4GB limit in Oracle Database 10g XE. Other hardware restrictions remain the same with CPU usage capped at one physical core and memory at 1GB. Oracle Database 11g XE is available immediately for Windows and Linux platforms. Oracle Application Express (APEX) remains one of the most actively developed Oracle Database features, with two important milestones reached since the 2.1 release that was included with Oracle Database 10g XE. First, Oracle APEX 3.0 brought PDF printing, Access migration, page caching, and a number of builder enhancements. Then, release 4.0, which is bundled with 11g XE in the form of Oracle APEX 4.0.2, introduced Web sheets - a unique technology for effortless content management where users take control of both content and structure of exposed data. Other improvements include native dynamic actions, a plug-ins framework, team features for