Tag Archives: OLAP

Day 18 Storage engine

MySQL is special compare to all the other RDBMs System because of its special architecture, the STORAGE Engine. MySQL has many storage engine as per the developer/application requirements. With this good part is that MySQL can work multiple storage engine … Continue reading

Posted in Internal, MySQL, Others, What I learned today | Tagged , , , , | Leave a comment

Operational Analytics -SQL Server 2016

What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is a operational system where day to day task eg order table keeps on updating. and Analytics is a OLAP where analysis … Continue reading

Posted in Future DBA, Others, sql 2016, Whats New | Tagged , | Leave a comment

Denali – Day 23: Data Quality Services (DQS)

Denali – Day 23: Data Quality Services(DQS) Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data in it, most of the time, we enter the data but as a user they enter the data … Continue reading

Posted in BI, Denali | Tagged , | Leave a comment