Exploring Programming Languages

Structured Query Language (SQL) is a standard database computer language utilise for querying, modifying and managing data in Relational Database Management Systems (RDBMS). SQL was developed in the 1970s by IBM to initially manipulate and retrieve data in IBM System R. The SQL language was regulate 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 cite to it as SQL. To some people, SEQUEL is the right lift 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 police squad support created a product which is cognise with the name of the SQL server 1.0 and within a few(prenominal) 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 world 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 function. The succeeding(a) version which was come after the Microsoft SQL Se rver2005 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 evince are as followsStored 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 decision maker ConnectionThe features o f 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 connectivityThe features of DB2 Express are as followsAdvanced Copy ServicesOracle Compatibility Compression backuppureXML storage High availability disaster recoverySpatial Extender Homogenous FederationIBM Tivoli System Automation for Multiplatforms Homogenous SQL Replication IBM Data Studio give notice 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 Limi tUnlimited4 GB4 GB/11 GB 32/64 bits32-64 bits32 bits / 32-64 bits32 bits / 32-64 bits