Docstoc

SQL Server Abbreviations

Document Sample
SQL Server Abbreviations Powered By Docstoc
					1) DBMS – Database Management System
2) RDBMS – Relational Database Management System
3) DB – Database
4) SP – Stored Procedure
5) UDF – User-Defined Function
6) SQL – Structured Query Language
7) T-SQL – Transact SQL
8) DCL – Data Control Language
9) DDL – Data Definition Language
10) DML – Data Manipulation Language
11) TCL –Transactional Control Language
12) ACID – Atomicity, Consistency, Isolation and Durability
13) ADO – ActiveX Data Objects
14) ADO.NET – ActiveX Data Objects for .NET
15) 1NF – First Normal Form
16) 2NF – Second Normal Form
17) 3NF –Third Normal Form
18) 4NF – Fourth Normal Form
19) 5NF – Fifth Normal form
20) BCNF – Boyce Codd Normal Form
21) ODBC – Open Database Connectivity
22) OLE DB – Object Linking and Embedding Database
23) ADO MD – ActiveX Data Objects (Multidimensional)
24) ADOMD.NET – ActiveX Data Objects MultiDimensional.NET
25) AMO – Analysis Management Objects
26) COM – Component Object Model
27) DCOM – Distributed Component Object Model
28) MDX – Multidimensional Expressions
29) DBCS – double-byte character set
30) dbo – database owner
31) DMV – Dynamic Management View
32) DSN – data source name
33) ETL – Extraction, Transformation and Loading
34) IAM – Index Allocation Map
35) MDAC – Microsoft Data Access Components
36) RDS – Remote Data Service
37) NUMA – non-uniform memory access
38) GUID – globally unique identifier
39) OLAP – online analytical processing
40) PAL – publication access list
41) GPO – Group Policy Object
42) RDL – Report Definition Language
43) RID – row identifier
44) SMDL – Semantic Model Definition Language
45) TDS – tabular data stream
46) VLDB – very large database
47) DAC - Data Access Components
48) WMI – Windows Management Instrumentation
49) WQL – WMI Query Language
50) DTS – Data Transformation Services
51) SSIS – SQL Server Integration Services
52) BI – Business Intelligence
53) SSRS – SQL Server Reporting Services
54) SSAS – SQL Server Analysis Services
55) SSMS – SQL Server Management Studio
56) BIDS – Business Intelligence Development Studio
57) DMX – Data Mining Extensions
58) MOLAP –Multidimensional OLAP
59) ROLAP – Relational OLAP
60) HOLAP – Hybrid OLAP
61) ADOX – ActiveX Data Objects Extensions for DDL and Security
62) DAO – Data Access Objects
63) DTC – Distributed Transaction Coordinator
64) JET – Joint Engine Technology
65) RDO – Remote Data Objects
66) LTM – Lightweight Transaction Manager
67) JRO – Jet and Replication Objects
68) UDA – Universal Data Access
69) WAB – Windows Address Book
70) ODL – Object Description Language
71) DBCC – Database Consistency Check
72) BLOB – Binary Large Object
73) CLOB – Character Large Object
74) DKNF – Domain Key Normal Form

				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:129
posted:3/23/2010
language:English
pages:2
Description: This provides a brief list of MS SQL Server Abbreviations.