Skip to main content

Overview of DBMS

 

What is Data?

Data is nothing but facts and statistics stored or free flowing over a network, generally it's raw and unprocessed. For example: When you visit any website, they might store you IP address, that is data, in return they might add a cookie in your browser, marking you that you visited the website, that is data, your name, it's data, your age, it's data.
Data becomes information when it is processed, turning it into something meaningful. Like, based on the cookie data saved on user's browser, if a website can analyse that generally men of age 20-25 visit us more, that is information, derived from the data collected.

What is a Database?

A Database is a collection of related data organised in a way that data can be easily accessed, managed and updated. Database can be software based or hardware based, with one sole purpose, storing data.
During early computer days, data was collected and stored on tapes, which were mostly write-only, which means once data is stored on it, it can never be read again. They were slow and bulky, and soon computer scientists realised that they needed a better solution to this problem.
Larry Ellison, the co-founder of Oracle was amongst the first few, who realised the need for a software based Database Management System.

What is DBMS?

A DBMS is a software that allows creation, definition and manipulation of database, allowing users to store, process and analyse data easily. DBMS provides us with an interface or a tool, to perform various operations like creating database, storing data in it, updating data, creating tables in the database and a lot more.
DBMS also provides protection and security to the databases. It also maintains data consistency in case of multiple users.
Here are some examples of popular DBMS used these days:
  • MySql
  • Oracle
  • SQL Server
  • IBM DB2
  • PostgreSQL
  • Amazon SimpleDB (cloud based) etc. 

  • Characteristics of Database Management System

    A database management system has following characteristics:
  • Data stored into Tables: Data is never directly stored into the database. Data is stored into tables, created inside the database. DBMS also allows to have relationships between tables which makes the data more meaningful and connected. You can easily understand what type of data is stored where by looking at all the tables created in a database.
  • Reduced Redundancy: In the modern world hard drives are very cheap, but earlier when hard drives were too expensive, unnecessary repetition of data in database was a big problem. But DBMS follows Normalisation which divides the data in such a way that repetition is minimum.
  • Data Consistency: On Live data, i.e. data that is being continuosly updated and added, maintaining the consistency of data can become a challenge. But DBMS handles it all by itself.
  • Support Multiple user and Concurrent Access: DBMS allows multiple users to work on it(update, insert, delete data) at the same time and still manages to maintain the data consistency.
  • Query Language: DBMS provides users with a simple Query language, using which data can be easily fetched, inserted, deleted and updated in a database.
  • Security: The DBMS also takes care of the security of data, protecting the data from un-authorised access. In a typical DBMS, we can create user accounts with different access permissions, using which we can easily secure our data by restricting user access.
  • DBMS supports transactions, which allows us to better handle and manage data integrity in real world applications where multi-threading is extensively used.

    Advantages of DBMS

  • Segregation of applicaion program.
  • Minimal data duplicacy or data redundancy.
  • Easy retrieval of data using the Query Language.
  • Reduced development time and maintainance need.
  • With Cloud Datacenters, we now have Database Management Systems capable of storing almost infinite data.
  • Seamless integration into the application programming languages which makes it very easier to add a database to almost any application or website.

  • Disadvantages of DBMS

  • It's Complexity
  • Except MySQL, which is open source, licensed DBMSs are generally costly.
  • They are large in size.


Comments

Post a Comment

Popular posts from this blog

ENRICHING THE ‘INTEGRATION AS A SERVICE’ PARADIGM FOR THE CLOUD ERA

ENRICHING THE ‘INTEGRATION AS A SERVICE’ PARADIGM FOR THE CLOUD ERA INTRODUCTION TO CLOUD INTEGRATION: Cloud Integration is about simplifying technology so that it could be adopted by a much broader audience.  Cloud integration is the process of configuring multiple application programs to share data in the cloud. In a network that incorporates cloud integration; various applications communicate either directly or through third-party software. Cloud integration is the linking of information flows between cloud-hosted applications and other applications hosted in different clouds or in the datacenter. Without integration, cloud applications can’t share data with the rest of the Company and that limits or even eliminates the utility of the cloud. ADVANTAGES OF CLOUD INTEGRATION: Cloud integration offers the following advantages over older, compartmentalized organizational methods: We propose the followi
10 comments
Read more

MIGRATING INTO A CLOUD

  MIGRATING INTO A CLOUD INTRODUCTION: Cloud computing is a disruptive model of IT whose innovation is part technology and part business model. In short a “disruptive techno-commercial model” of IT. This chapter focuses on the key issues and associated dilemmas faced by decision makers, architects, and systems managers in trying to understand and leverage cloud computing for their IT needs. We will discuss the key factors for each of the above questions and a Seven-Step Model of Migration into the Cloud. Several efforts have been made in the recent past to define the term “ cloud computing ” and many have not been able to provide a comprehensive one. We propose the following definition of cloud computing: “It is a techno-business disruptive model of using distributed large-scale data centers either private or public or hybrid offering customers a scalable virtualized infrastructure or an abstracted set of services qu
9 comments
Read more

introduction to cloud computing

CLOUD COMPUTING INTRODUCTION: Cloud Computing provides us a means by which we can access the applications as utilities , over the Internet . It allows us to create , configure , and customize applications online. With Cloud Computing users can access database resources via the internet from anywhere for as long as they need without worrying about any maintenance or management of actual resources. WHAT IS CLOUD? The term Cloud refers to a Network or internet . In other words, we can say that Cloud is something , which is present at remote location. Cloud can provide services over network, i.e., on public networks or on private networks , i.e., WAN, LAN or VPN. Applications such as e-mail, web conferencing, customer relationship management (CRM), all run in cloud. Cloud Computing refers to manipulating, configuring, and accessing the applications online. It offers
1 comment
Read more