Home » Posts tagged 'Database'

Tag Archives: Database

Q18. What is the difference between the Database and Datawarehouse?

Please visit SQLVERSITY.COM for more details.

(more…)

Advertisements

Object Oriented DBMS (OODBMS)

OODBMS

Please visit SQLVERSITY.COM for more details.

A database management system is said to be object oriented, if the data is stored in the form of objects.

The name itself says that Object Oriented(OO) + Database Management System(DBMS). That means, If we integrate the features of object oriented programming language like C++, Java, C# etc.. and database, the result will be object oriented database management system(OODBMS). It is also called as an object database management system (ODMS). It allows the developers to store the data or modify the data in the form of objects.

Ex: EyeDB, Versant etc..

(more…)

What is Database?

Database Introduction

Please visit SQLVERSITY.COM for more details.

A Database is a collection of data organized in such a way that it can be accessed easily and efficiently.

It seems very easy to define. But this is an important one which rules the entire world in any field.

Our entire life depends on database and the daily activities involves lot of databases. Even the list of your Boyfriend/Girlfriend’s is also a database 😉

(more…)

SQL Server – Comparison between CT and CDC

Please visit SQLVERSITY.COM for more details.

If you have already gone through my previous articles, Change Tracking (CT) and Change Data Capture (CDC), you also need to know the comparison between CT and CDC.

When I was writing articles on CT and CDC, I noticed some similarities and differences between CT and CDC.

Although they look similar, I noticed more differences than similarities. So I would like to share my findings with you guys.

(more…)

SQL Server – Change Data Capture(CDC)

Please visit SQLVERSITY.COM for more details.

Thank you very much for reading my previous article Change Tracking (CT) and I hope you have enjoyed while reading the content of CT.

As I promised you guys, I am back with another awesome feature of SQL Server 2008 called ‘Change Data Capture (CDC)’.  As you all know that I am a lazy fellow and in this entire article I am going to call it as CDC for my convenience.

Microsoft has introduced this feature to overcome a small drawback in CT.

I hope you already got to know the drawback in CT. That is, we cannot get historical data in CT. That means, we can get the details of Primary key, DML (like I/D/U) changes which we have done to the table. But not entire modified data. By using CDC, we can retrieve historical changes also.

Here it goes……!!! (more…)