Programming with Python

  1. Home
  2. Docs
  3. Programming with Python
  4. Database in Python
  5. Introduction

Introduction

Database is a collection of data. It is a special type of computer file that can integrate multiple data files.

A database is centralized, program independent and organized collection of data which removes data redundancy and ensures data integrity.

A Database system is basically a computer based record keeping system. The collection of data, usually referred to as the database.

A database system should be a repository of the data needed for an organization’s data processing.

A DBMS (Database management system) refers to a software that is responsible for storing, maintaining and utilizing databases. A database along with DBMS is referred to as a database system.

A typical file processing system suffers from some major limitations like Data redundancy, data inconsistency, unsharable data, unstandardized data, insecure data, incorrect data, etc.

On the other hand, a database system overcomes all these limitations and ensures continuous efficiency.

The advantages of database system are:-

  1. Reduces data redundancy.
  2. Controlled data inconsistency.
  3. Secured data
  4. Integrated data
  5. Standardized data

Relational Database- Data are stored in form of tables also known as relations. Generally each table represent one entity.

Data => Database => Relational Database => Tables or entities => Tuple or record => Attributes.

Relational Database Management system RDBMS is an application software for creating and managing relational databases. It makes us possible for us to create, read, update and delete data from a database .

Some of the popular RDBMS software which use a client server model are:-

  • Oracle
  • SQL server
  • MySQL
  • DB2
  • MS access

To give instructions to database we use SQL or structured query language.

The primary purpose of SQL is to query and manupulate data stored in a relational database.

Statement of SQL is classified into 5 categories:-

  • Data definition language
  • Data retrieval
  • Data manipulation language
  • Transaction control
  • Data control

This is all about Database in python.

Was this article helpful to you? Yes No

How can we help?