Checking your session…
Module 02: Introduction to Databases and SQL

2.5 Core Database Characteristics

Level: 2 | Version: v1.1 | Author: Meptrasoft

Overview

A good database system should do more than simply store data.

It should keep data organized, accurate, secure, available, and usable by multiple users.

The core characteristics of a database include:

  1. Reduced Data Redundancy
  2. Large-Scale Data Management
  3. Data Integrity
  4. Data Security
  5. Data Consistency
  6. Backup and Recovery
  7. Privacy
  8. Data Sharing

A simple way to remember the goal is:

TEXT 
STORE DATA
    ↓
KEEP IT CORRECT
    ↓
KEEP IT SECURE
    ↓
MAKE IT AVAILABLE
    ↓
LET AUTHORIZED USERS USE IT
Core Characteristics of a Database: Less Redundancy, Large Data Handling, Integrity, Security, Consistency, Backup and Recovery, Privacy, and Data Sharing
Figure 1: A good database system keeps data organized, accurate, secure, recoverable, and accessible to authorized users.

1. Reduced Data Redundancy

Data redundancy means storing the same piece of data unnecessarily in multiple places.

For example, suppose a customer's phone number is stored repeatedly in several files:

TEXT 
Customer File    → 9876543210
Order File       → 9876543210
Payment File     → 9876543210

If the customer changes the number, every copy may need to be updated.

A well-designed database reduces unnecessary duplication.

Reduced redundancy means avoiding unnecessary copies of the same data.

2. Managing Large Amounts of Data

Database systems are designed to store and manage large volumes of data.

For example, an e-commerce application may store:

TEXT 
Customers
Products
Orders
Payments
Shipments

The database should allow applications to search and manage this data efficiently as the amount of data grows.

3. Data Integrity

Data integrity means keeping data correct, valid, and reliable.

For example, if a student's age must be a positive number, the database should prevent invalid values such as:

TEXT 
Age = -20

Relational databases can use rules such as:

  • PRIMARY KEY
  • FOREIGN KEY
  • NOT NULL
  • UNIQUE
  • CHECK

to help enforce data integrity.

Integrity asks: “Is the data valid and correct?”

4. Data Security

Data security protects data from unauthorized access or modification.

For example:

TEXT 
Student
→ Can view their own records

Teacher
→ Can view authorized student information

Admin
→ Can manage required records

Database systems can use authentication, roles, privileges, and permissions to control access.

Security asks: “Who is allowed to access or change the data?”

5. Data Consistency

Data consistency means data remains accurate and does not contain conflicting values when it is accessed or updated.

For example, imagine an order system showing:

TEXT 
Order System      → Payment = Paid
Payment System    → Payment = Pending

Such a conflict can cause problems.

Database transactions and integrity rules help maintain consistent data.

Integrity vs Consistency

These terms are related but slightly different:

Integrity Consistency
Data follows defined rules Data does not conflict across related operations
Focuses on validity Focuses on correct state
Example: Age cannot be negative Example: completed payment should not remain incorrectly marked as pending

6. Backup and Recovery

Data can be lost because of:

  • Hardware failure
  • Software errors
  • Accidental deletion
  • System crashes
  • Other failures

A database system can support backup and recovery mechanisms so data can be restored after certain failures.

For example:

TEXT 
DATABASE
   ↓
BACKUP
   ↓
SYSTEM FAILURE
   ↓
RECOVERY
   ↓
DATA RESTORED

Backup protects a copy of data; recovery restores data after a failure.

7. Privacy

Privacy means protecting sensitive information and ensuring that only authorized people can access it.

Examples of sensitive data include:

  • Personal details
  • Salary information
  • Banking information
  • Student records
  • Health records

A database system can support privacy through permissions, access controls, encryption, and appropriate application design.

8. Data Sharing

A database often needs to support multiple authorized users and applications at the same time.

For example, in an online shopping system:

TEXT 
Customer  → Places Order
Warehouse → Updates Inventory
Payment   → Confirms Payment
Admin     → Checks Order

All of these systems may work with shared database data.

The DBMS manages concurrent access so that users and transactions can work safely.

Additional Database Characteristics

The characteristics above describe what a database system should provide. Database systems also have several important concepts that help achieve these goals.

Self-Describing Nature

A database system stores metadata, which means data about data.

For example, metadata can describe:

TEXT 
Table Name
Column Name
Data Type
Constraints
Indexes
Permissions

This information is typically maintained in a system catalog or data dictionary.

Example

Suppose a table contains:

TEXT 
Student_ID → INTEGER
Name       → VARCHAR
Marks      → INTEGER

The actual values are data.

The information describing those columns is metadata.

Data = the stored values. Metadata = information describing the stored data.

Program-Data Independence

Program-data independence means application programs can remain largely unchanged when certain aspects of how data is stored or organized are changed.

For example, an administrator might change the physical storage structure without requiring the application to be rewritten.

This separation makes database systems easier to maintain.

TEXT 
APPLICATION
     ↓
DATABASE SYSTEM
     ↓
PHYSICAL STORAGE

The application does not need to know every detail of the physical storage.

Multiple Views of Data

Different users may need different parts of the same database.

For example:

TEXT 
Student
→ Name, Course, Marks

Teacher
→ Student Name, Marks, Attendance

Admin
→ Student, Course, Fee, Attendance

A view can provide a customized representation of database data.

For example:

SQL 
CREATE VIEW Student_Public_Info AS
SELECT Student_ID, Name, Department
FROM Students;

A view can expose only the information a particular user or application needs.

Multi-User Transaction Processing

A database can have many users performing operations at the same time.

For example:

TEXT 
Customer A → Books Seat 10
Customer B → Books Seat 11
Customer C → Checks Available Seats

The DBMS manages these operations using mechanisms such as transactions, locking, and isolation.

The goal is to prevent concurrent operations from producing incorrect or conflicting results.

Common Beginner Mistakes

✗ Mistake ✓ Correct Understanding
Redundancy and inconsistency are the same Redundancy is unnecessary duplication; inconsistency means conflicting or incorrect values
Security means the database is automatically safe Security requires proper authentication, permissions, configuration, and application controls
Backup and recovery are the same thing Backup creates a recoverable copy; recovery restores data after a failure
Privacy and security are exactly the same Security provides controls; privacy concerns appropriate protection and use of personal information
Data integrity means data can never change Integrity means data remains valid and follows defined rules
A view stores a completely separate copy of the data A traditional database view is a virtual representation based on a query
Multiple users can freely modify the same data without control DBMS concurrency mechanisms help coordinate simultaneous operations

Placement Quick Points

TEXT 
REDUNDANCY
→ AVOID UNNECESSARY DUPLICATION

INTEGRITY
→ KEEP DATA VALID AND CORRECT

CONSISTENCY
→ AVOID CONFLICTING DATA STATES

SECURITY
→ CONTROL ACCESS

PRIVACY
→ PROTECT SENSITIVE INFORMATION

BACKUP
→ CREATE A RECOVERABLE COPY

RECOVERY
→ RESTORE DATA AFTER FAILURE

SHARING
→ SUPPORT AUTHORIZED MULTIPLE USERS
  • Databases reduce unnecessary data duplication.
  • Data integrity ensures values follow defined rules.
  • Data consistency helps prevent conflicting data states.
  • Security controls who can access or modify data.
  • Privacy focuses on protecting sensitive information.
  • Backup and recovery help protect against data loss.
  • Databases support controlled sharing among multiple users.
  • Metadata describes the structure and properties of stored data.
  • Views can provide different users with customized representations of data.
  • Transactions and concurrency controls help manage simultaneous database operations.

Interview Questions

What is data redundancy?

Data redundancy is the unnecessary storage of the same data in multiple places.

What is data integrity?

Data integrity means that data remains accurate, valid, and follows defined rules.

What is the difference between data integrity and data consistency?

Integrity focuses on whether data satisfies defined validity rules. Consistency focuses on whether the database remains in a correct, non-conflicting state.

What is data security?

Data security is the protection of data from unauthorized access, modification, or misuse.

What is the difference between backup and recovery?

A backup is a stored copy of data that can be used later. Recovery is the process of restoring data after a failure or loss.

What is metadata?

Metadata is data about data. It describes database objects such as tables, columns, data types, constraints, indexes, and permissions.

What is program-data independence?

It is the ability to make certain changes to the database's storage or structure without requiring corresponding changes to application programs.

What is a database view?

A view is a virtual representation of data defined by a SQL query. It can provide users with a customized or restricted view of the underlying data.

Why is concurrency control important?

Concurrency control helps multiple users or transactions access shared data safely without producing incorrect or conflicting results.

Practice & Hands-On Exercises

Beginner Practice

  1. Explain data redundancy with a simple example.
  2. What is data integrity?
  3. What is data security?
  4. What is the difference between backup and recovery?
  5. Why is data privacy important?

Think and Answer

  1. Why is unnecessary duplicate data a problem?
  2. Give an example of inconsistent data in an online shopping system.
  3. Why should a student not have the same database permissions as an administrator?
  4. How does a database support multiple users at the same time?
  5. What is metadata? Give two examples.

SQL Connection

Consider:

SQL 
CREATE VIEW Student_Public_Info AS
SELECT Student_ID, Name, Department
FROM Students;
  1. What is the purpose of this view?
  2. Which columns are visible through the view?
  3. Why might a university use a view instead of giving every user access to the entire Students table?

💡 Tip: Test your queries using the in-browser interactive runner above.

Key Takeaway

TEXT 
GOOD DATABASE
     ↓
LESS REDUNDANCY
+ DATA INTEGRITY
+ DATA CONSISTENCY
+ SECURITY
+ PRIVACY
+ BACKUP & RECOVERY
+ CONTROLLED SHARING
     ↓
RELIABLE DATA MANAGEMENT

A good database system does more than store data. It keeps data accurate, secure, consistent, recoverable, and available to authorized users.

End of Core Database Characteristics