Home » Posts tagged 'DBMS'

Tag Archives: DBMS

Advertisements

SQL – A database language

SQL

Please visit SQLVERSITY.COM for more details.

SQL Stands for Structured Query Language.

It is a programming language to interact with databases. By executing SQL queries, we can Access, Insert, Update and Delete the data from databases. In earlier 1970’s, Donald D. Chamberlin and Raymond F. Boyce developed SQL at IBM.

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

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.

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