GST Billing Software

header image

Introduction

Erachana Line

1. Introduction

A database is just what the name implies, a base collection of data. The data is organized in some manner so that the information contained within the database can be easily retrieved. Some of the simple databases that you might be familiar with are things like phone books or rolodexes. As data processing has become more sophisticated, so have methods for collecting, storing and retrieving information. Databases have become the cornerstone for an overwhelming amount of the computing environment in existence.


1.1 What is Data?

Data, in the context of databases, refers to all the single items that are stored in a database, either individually or as a set. Data in a database is primarily stored in database tables, which are organized into columns that dictate the data types stored therein. In simple words data can be facts related to any object in consideration.

Example :

• Name, age, height, weight etc. are some data related to you.

• A picture, image, file, pdf etc. can also be considered data.


1.2 What is Database?

A database is one of the important components for many applications and is used for storing a series of data in a single set. A database is just what the name implies, a base collection of data. In other words, it is a group/package of information that is put in order so that it can be easily accessed, manage and update. The data is organized in some manner so that the information contained within the database can be easily retrieved. Some of the simple databases that you might be familiar with are things like phone books or rolodexes. As data processing has become more sophisticated, so have methods for collecting, storing and retrieving information. Databases have become the cornerstone for an overwhelming amount of the computing environment in existence. An organized collection of related information so that it can easily be accessed, managed and updated.

Example :

• A Contact_Manager, which consists of tables such as Contact_details, Country, State, Place, Designation


1.3 What is Database Management System (DBMS)?

A database management system (DBMS) refers to the technology for creating and managing databases. The main aim of a DBMS is to supply a way to store up and retrieve database information that is both convenient and efficient. By data, we mean known facts that can be recorded and that have embedded meaning. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

The Database management system possess many advantages, some of them are listed below:

  • Data independence : Application programs should be as free or independent as possible from details of data representation and storage. DBMS can supply an abstract view of the data for insulating application code from such facts.
  • Efficient data access : DBMS utilizes a mixture of sophisticated concepts and techniques for storing and retrieving data competently and this feature becomes important in cases where the data is stored on external storage devices.
  • Data integrity and security : If data is accessed through the DBMS, the DBMS can enforce integrity constraints on the data.
  • Data administration : When several users share the data, integrating the administration of data can offer major improvements. Experienced professionals understand the nature of the data being managed and can be responsible for organizing the data representation to reduce redundancy and make the data to retrieve efficiently.