Exploring Programming Languages
Structured Query Language (SQL) is a standard database computer language used for querying, modifying and managing data in Relational Database Management Systems (RDBMS). 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 for Standardization (ISO) standards.
Until this day, there are lots of users who refuse to refer to it as SQL. To some people, SEQUEL is the right name for this international standardized database language. SQL has additionally been revised in 1989 and then 1992 (SQL-92). Ever since, SQL has undergone many revisions to enhance their standardization.
Sybase and Ashton with their team support created a product which is known with the name of the SQL server 1.0 and within few years SQL server 4.21 also came in existence for the Microsoft NT operating system. Microsoft itself on their individual basis work for the SQL server 6.0 and this was the first Individual product of the SQL series for the Microsoft which works with the Windows NT because at that point of time windows NT was the main operating system.
After few years later, when a copyrights conflict is there between the Microsoft and Sybase then Microsoft has done so many revisions in its project which lead to the development of the SQL server 7.0 which is known with the name of SQL server 2000 and the main part of this scheme and model is that it can work with the 64 bit platform.
The development of the Integrated development Environment for the creation of web and windows packages with the SQL server 2005 that includes so many tools and utilities that includes the ETL tool, a Reporting server, data mining server, and several messaging service brokers that will be for the notification services. The next version which was come after the Microsoft SQL Server2005 is the Microsoft SQL server 2008, the aim of which is to make the data management features still under control using self-tuning.
SQL Server 2008 R2 whose code name is given as “Kilomanjaro” and it is announced on year 2009, to add different management features to the SQL Server 2008 which is the earlier version. The SQL Server 2008 R2 also includes the number of new services that includes the PowerPivot for the Excel and Sharepoint master data services for building the reports using the data tier application.
2.The features of SQL Express are as follows:
Stored ProceduresSQL Server Configuration Manager
ViewsReplication (as a subscriber only)
TriggersAdvanced Query Optimizer
CursorsSMO/RMO
sqlcmd and osql utilitiesIntegration with Visual Studio 2005 Snapshot Isolation LevelsService Broker (as a client only)¹ Native XML support, including XQuery and XML SchemasSQL CLR Transact-SQL language supportMultiple Active Result Sets (MARS) Dedicated Administrator Connection²
The features of Oracle Express are as follows:
Direct Path Load API
External tables
External procedures
Synchronous Change Data Capture
Asynchronous Change Data Capture
Transportable tablespaces, including cross-platform
Advanced Queuing
Basic Replication
Advanced Replication
Distributed queries
Distributed transactions
Transparent Gateways
Generic connectivity
The features of DB2 Express are as follows:
Advanced Copy ServicesOracle Compatibility
Compression: backuppureXML® storage
High availability disaster recoverySpatial Extender
Homogenous FederationIBM Tivoli® System Automation for Multiplatforms Homogenous SQL Replication
IBM Data Studio
Net Search Extender
Online reorganization
The free version of DB2 (DB2 Express-C) has much less limitations than those existing in Oracle and SQL Server, Oracle Express Edition 10g/11g and SQL Server 2005/2008 Express.
CharacteristicDB2 Express-CSQL Server 2005/2008 ExpressOracle 10g/11g Express Edition CPUs MaxUntil 2 cores11
RAM Max2 GB1 GB1 GB
Size LimitUnlimited4 GB4 GB/11 GB
32/64 bits32-64 bits32 bits / 32-64 bits32 bits / 32-64 bits
