Home » Posts tagged 'relational database management'

Tag Archives: relational database management

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…)

Advertisements

Relational DBMS (RDBMS)

What is RDBMS

Please visit SQLVERSITY.COM for more details.

A Database Management System is said to be Relational if it works based on Relational model. This was introduced by E.F.Codd in 1969.

A relational database is a collection of data organized and described in terms of related tables from which data can be accessed easily. A relational database is created using the relational model.
(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…)