Exploring Programming Languages

Structured Query Language (SQL) is a standard entropybase computer lyric poem used for querying, modifying and managing selective information 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 standardized in 1986 by the American National Standards Institute (ANSI) however, afterward releases were released as International Organization for Standardization (ISO) standards.Until this day, thither are lots of users who refuse to refer to it as SQL. To some people, SEQUEL is the right surname for this internationalist standardized database language. SQL has augmentitionally been revised in 1989 and and so 1992 (SQL-92). Ever since, SQL has undergone many revisions to enhance their standardization.Sybase and Ashton with their team survive created a product which is known with the name of the SQL master of ceremonies 1.0 and within few age SQL server 4.21 in like manner came in existence for the Microsoft NT operating system. Microsoft itself on their exclusive basis work for the SQL server 6.0 and this was the first unmarried product of the SQL series for the Microsoft which works with the Windows NT because at that rase of time windows NT was the main operating system.After few years later, when a copyrights conflict is there between the Microsoft and Sybase thus Microsoft has done so many revisions in its understand which lead to the utilise of the SQL server 7.0 which is known with the name of SQL server 2000 and the main part of this scheme and type is that it can work with the 64 bit platform.The development of the Integrated development Environment for the creation of sack and windows packages with the SQL server 2005 that includes so many tools and utilities that includes the ETL tool, a report server, data mining server, and several messaging function brokers that will be for the notification services. The next discrepa ncy which was come after the Microsoft SQL innkeeper2005 is the Microsoft SQL server 2008, the aim of which is to answer the data management features still under restrict 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 surpass and Sharepoint master data services for building the reports using the data tier application.2.The features of SQL expect are as followsStored ProceduresSQL Server Configuration Manager ViewsReplication (as a reader only) Triggers mature Query Optimizer CursorsSMO/RMO sqlcmd and osql utilitiesIntegration with Visual Studio 2005 Snapshot closing off 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 tieThe features of Oracle Express are as follows withdraw Path Load API External tables External procedures coexisting transpose Data Capture Asynchronous Change Data Capture Transportable tablespaces, including cross-platform Advanced Queuing introductory Replication Advanced Replication Distributed queries Distributed transactions plain Gateways Generic connectivityThe features of DB2 Express are as followsAdvanced Copy ServicesOracle Compatibility Compression backuppureXML storage High approachability disaster recoverySpatial Extender consistent FederationIBM Tivoli System Automation for Multiplatforms Homogenous SQL Replication IBM Data Studio Net assay Extender Online reorganization The free version of DB2 (DB2 Express-C) has much less(prenominal) limitations than those existing in Oracle and SQL Server, Oracle Express translation 10g/11g and SQL Server 2005/2008 Express.CharacteristicDB2 Express-CSQL Server 2005/2008 ExpressOracle 10g/11 g 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