Saturday, March 2, 2019
Exploring Programming Languages
Structured enquiry Language (SQL) is a standard selective informationbase computer spoken language used for querying, modifying and managing data in Relational infobase Management clays (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 Ameri underside National Standards give (ANSI) however, later releases were released as International Organization for Standardization (ISO) standards.Until this day, there ar lots of users who refuse to refer to it as SQL. To some people, SEQUEL is the proficient name for this international standardized database language. SQL has additionally been revised in 1989 and accordingly 1992 (SQL-92). Ever since, SQL has undergone many revisions to enhance their standardization.Sybase and Ashton with their team support created a crossing which is know with the name of the SQL legion 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 keister work for the SQL server 6.0 and this was the first Individual product of the SQL series for the Microsoft which whole shebang 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 environs 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 innkeeper2005 is the Microsoft SQL server 2008, the claim 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 Sh arpoint master data services for building the reports using the data tier application.2.The features of SQL Express argon as followsStored ProceduresSQL Server Configuration Manager Views counter (as a subscriber only) TriggersAdvanced Query Optimizer CursorsSMO/RMO sqlcmd and osql utilitiesIntegration with Visual Studio 2005 Snapshot Isolation LevelsService Broker (as a customer only) Native XML support, including XQuery and XML SchemasSQL CLR Transact-SQL language supportMultiple Active Result Sets (MARS) Dedicated Administr ator federationThe features of Oracle Express are as follows Direct Path consign 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 handiness 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(prenominal) less limitations than those existing in Oracle and SQL Server, Oracle Express discrepancy 10g/11g and SQL Server 2005/2008 Express.CharacteristicDB2 Express-CSQL Server 2005/2008 ExpressOracle 10g/11g Express Edition CPUs MaxUnti l 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment