Home » Posts tagged 'oracle sql server'

Tag Archives: oracle sql server

Object Oriented DBMS (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..



Flat File Based DBMS (FDBMS)

Flat File Database

Please visit SQLVERSITY.COM for more details.

A flat file database is a database which stores the data in plain text file. It is a database consisting of a single table with no structure and relationship.

This kind of database holds one record in a row and fields are separated by delimiters like commas or tabs spaces or pipe symbols or may have fixed length.


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.

Network DBMS (NDBMS)

Please visit SQLVERSITY.COM for more details.

A DBMS is said to be Network DBMS, when it organizes the data in a network structure. As you all are aware that, a network may have as many connections as it can.

In our DBMS language, we can say that a parent can have many children and a child can have more than one parent. So a Network DBMS will have many-to-many relationship.

There are some differences between hierarchical DBMS and Network DBMS.


Hierarchical DBMS (HDBMS)

Please visit SQLVERSITY.COM for more details.

A DBMS is said to be hierarchical DBMS, when the data is organized like a tree structure. That means, it simply represents the data using parent – child relationship. It is the oldest style of organizing/storing data and still some organizations are using this.

It follows one to many relationship. i.e. All parents can have more than one child, but each child should have only one parent.


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.


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