Click here to Skip to main content
Click here to Skip to main content
Technical Blog

Tagged as

Good to Know SQL JARGON – An interview TIP #56

, 9 Oct 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
  Hello friends, Just wanted to share some technical words here again it is good to know 1) OLAP :  On Line Analytical  Processing 2) MOLAP :- Multidimensional  On Line Analytical Processing 3) ROLAP :- Relational On Line Analytical Processing 4) HOLAP :- Hybrid On Line Analytical Processing 5) RTOL

 

Hello friends,

Just wanted to share some technical words here again it is good to know

1) OLAP :  On Line Analytical  Processing

2) MOLAP :- Multidimensional  On Line Analytical Processing

3) ROLAP :- Relational On Line Analytical Processing

4) HOLAP :- Hybrid On Line Analytical Processing

5) RTOLAP :- Real Time On Line Analytical Processing

6) DOLAP :- Desktop On Line Analytical Processing

8) SSIS :- SQL Server Integration Services

9) SSAS :- SQL Server Analysis Services

10) SSMS :- SQL  Server Management Studio

11) SSRS :- SQL Server Reporting Services

12)Magic Table:- A temporary table use at the time of  trigger

13)DML :- Data Manipulation Language (Insert/Update/Delete)

14) DDL :- Data Definition Language  (Create /Alter /Drop)

15) DCL :- Data Control Language (Grant /Revoke)

16) TCL:- Transaction Control Language  (Rollback /Commit)

17) ACID :- Atomicity,  Consistency , Isolation ,Durability

18) PK- Primary Key

19) FK – Foreign Key

20) NF:- Normal Form (1NF,2NF,3NF)

21) ODBC :-  Open Database Connectivity

22) OLEDB :- Object Linking  and Embedding Database

23) RDBMS :- Relational Database Management System

24) CRUD:- Create, Read , Update, Delete

25) ETL :- Extract Transform Load

26) BI :- Business Intelligence

27) SP :- Stored Procedure

28) VLDB :- Very Large Data Base

29) CTE:- Common Table Expression

30) CDC :- Change Data Capture

31) TDE :- Transparent Data Encryption

I will add more in future.

Thanks & Enjoy !!!

RJ !!!


Filed under: CodeProject, Database, DENALI, Sql server, SQL SERVER 2008 - R2, SQL SERVER 2014, SSIS, SSRS, TIPS Tagged: SQL JARGON, Sql server, TIPS

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Rajat-Indiandotnet
Technical Lead
India India
No Biography provided
Follow on   Twitter   LinkedIn

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.141223.1 | Last Updated 10 Oct 2014
Article Copyright 2014 by Rajat-Indiandotnet
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid