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 !!!
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}