Skip to main content

Posts

Showing posts from February, 2019

Database Architecture

Understanding DBMS Architecture A Database Management system is not always directly available for users and applications to access and store data in it. A Database Management system can be centralised (all the data stored at one location), decentralised (multiple copies of database at different locations) or hierarchical , depending upon its architecture. 1-tier DBMS architecture also exist, this is when the database is directly available to the user for using it to store data. Generally such a setup is used for local application development, where programmers communicate directly with the database for quick response. Database Architecture is logically of two types: 2-tier DBMS architecture 3-tier DBMS architecture 2-tier DBMS Architecture  2-tier DBMS architecture includes an Application layer between the user and the DBMS, which is responsible to communicate the user's request to the database management system and then send the response from the DBMS to

Components of DBMS

The database management system can be divided into five major components, they are: Hardware Software Data Procedures Database Access Language Let's have a simple diagram to see how they all fit together to form a database management system.                                          DBMS Components: Hardware When we say Hardware, we mean computer, hard disks, I/O channels for data, and any other physical component involved before any data is successfully stored into the memory. When we run Oracle or MySQL on our personal computer, then our computer's Hard Disk, our Keyboard using which we type in all the commands, our computer's RAM, ROM all become a part of the DBMS hardware. DBMS Components: Software This is the main component, as this is the program which controls everything. The DBMS software is more like a wrapper around the physical database, which provides us with an easy-to-use interface to store, access and update data.

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-onl

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

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