DBMS IN TELUGU PART 1 - INTRODUCTION TO DATABASE | DATABASE EVOLUTION IN TELUGU |

Understanding Data and Database Models

What is Data?

• Data refers to facts or pieces of information that can be stored and utilized by computer programs and gadgets.

• It encompasses any information conveyed through various media, highlighting its versatility.

Defining Databases

• A database is a collection of interrelated data used for retrieving, inserting, and deleting information. It organizes data in formats such as tables, schemas, views, and reports.

• An example of a practical application of databases is a college database that manages faculty and student records effectively.

Evolution of Database Models

• The evolution of database models includes:

• 1960s-70s: Hierarchical and network models.

• 1980s: Introduction of the relational model.

• 1990s: Development of object-oriented models.

• 2000+: Emergence of NoSQL databases.

Types of Databases

Flat File Database

• A flat file database stores information in a single file or table format where each line represents one record; fields may have fixed lengths or be separated by commas or whitespace. This type cannot contain multiple tables.

Hierarchical Database

• In hierarchical databases, data is organized in a parent-child structure (e.g., electronics categories like televisions and MP3 players). This model allows for multiple relationships among data points but can become complex with many levels.

Relational Model

• The relational model structures data into rows and columns within tables (also called relations), facilitating easy representation of relationships between different datasets. Edgar F. Codd initially described this model in 1969.

Object-Oriented Database Management Systems (OODBMS)

• OODBMS present data as objects rather than traditional relational tables, allowing for more complex data representations suitable for certain applications. This approach differs significantly from conventional relational databases.