Skip to main content

Chapter No 2 Database System DAE CIT 2nd year



Chapter No. 2 
Database System

Legacy DB Systems

   -  File Processing Systems

   - Hierarchical Model

   - Network Model

Legacy Database Systems


Legacy database systems played a crucial role in the evolution of data management, paving the way for more advanced relational database systems.

Legacy Database Systems, including

  1. File Processing Systems
  2. Hierarchical Model
  3. Network Model,.



1. File Processing Systems

Definition:

File Processing Systems are traditional data management systems that use flat files to store and manage data. In this approach, each department or user group maintains its own set of files, leading to data redundancy.


Characteristics:


Data stored in flat files.

No centralized control or structure.

Limited data sharing and integration.

Advantages:


Simplicity: Easy to implement and understand.

Independence: Each department has control over its data.

Cost: Relatively low implementation and maintenance costs.

Performance: Can be efficient for specific tasks.

Flexibility: Each department can choose its file organization.

Disadvantages:


Data Redundancy: Multiple copies of the same data in different files.

Inconsistency: Difficulty in maintaining data consistency.

Data Isolation: Limited data sharing between departments.

Security: Limited access controls.

Lack of Standards: No standardized data formats.

Examples:


Filing cabinets with paper records.

Spreadsheet files stored on individual computers.

Text files storing data for different applications.

2. Hierarchical Model:

The Hierarchical Model organizes data in a tree-like structure, with a single root representing the entire database and branches representing different entities and their relationships. It was widely used in early database management systems.


Characteristics:


Organized in a tree structure.

Parent-child relationships between records.

Navigational access through tree traversal.

Advantages:


Data Integrity: Ensures data relationships.

Efficiency: Can be efficient for certain types of queries.

Simplicity: Simple and intuitive structure.

Security: Access control through parent-child relationships.

Integrity Constraints: Enforces relationships.

Disadvantages:


Lack of Flexibility: Not suitable for all types of relationships.

Complexity in Querying: Complex queries require navigating the hierarchy.

Maintenance Overhead: Changes to the structure can be cumbersome.

Limited Scalability: Difficult to scale for larger datasets.

Data Redundancy: Redundant data due to hierarchical structure.

Examples:


IMS (Information Management System).

Windows Registry (in a hierarchical structure).

3. Network Model

The Network Model represents data as records connected through links or pointers, allowing for more complex relationships than the hierarchical model. It supports many-to-many relationships.





Characteristics:


Records are connected through links.

Supports many-to-many relationships.

Complex navigational structures.

Advantages:


Data Integrity: Maintains data relationships.

Flexibility: Supports complex relationships.

Efficiency: Can be efficient for certain types of queries.

Data Independence: Changes in the database structure do not affect applications.

Security: Access control through record-level permissions.

Disadvantages:

Complexity: Complex structure and navigational paths.

Query Complexity: Writing queries can be intricate.

Maintenance Overhead: Changes to the structure can be challenging.

Lack of Standards: Not widely standardized.

Limited Adoption: Superseded by relational databases.

Examples:

CODASYL (Conference on Data Systems Languages).

IDMS (Integrated Database Management System).










Labels:

Comments

  1. MAHNOORSeptember 18, 2023 at 3:54 AM

    Good 👍

    ReplyDelete
    Replies
    1. AnonymousNovember 15, 2023 at 11:20 PM

      yeah veery beautiful so elegant so beautiful just looking like a wowops cow

      Delete

Post a Comment

Popular posts from this blog

Short Q&A about constructors

  Q1: What is a constructor in Java, and when is it called? A1: A constructor in Java is a special method used to initialize objects. It is called when an instance of a class is created, allocating memory for the object in RAM. Q2: What happens if a class in Java does not have any constructor defined? A2: If a class in Java doesn't have any constructor defined, the Java compiler provides a default constructor by default. Q3: What are the two types of constructors in Java? A3: There are two types of constructors in Java:  1. No-arg constructor (Default constructor) 2. Parameterized constructor Q4: What are the rules for creating a Java constructor? A4: The rules for creating a Java constructor are as follows: - Constructor name must be the same as its class name. - A constructor must have no explicit return type. - A Java constructor cannot be abstract, static, final, or synchronized. Q5: What are the different access modifiers that can be used while declaring a constructor in ...
Post a Comment
Read more

Chapter No 2 Java DAE CIT

  . Variable and Operators 1.1. Variable: Define: A variable is a named storage location in a program that holds data, and its value can be changed during the execution of the program. Syntax: datatype variableName; Explanation: Variables are used to store and manipulate data in a program. They have a data type that defines the kind of data they can hold, such as int, float, char, etc. Code int age; // Declaration of an integer variable age = 25; // Initialization of the variable with a value 1.2. Create Instance of a Variable: Define: Creating an instance of a variable involves declaring and optionally initializing a variable in a program. Syntax: datatype variableName = value; Explanation: This creates a variable and assigns an initial value to it at the time of declaration. score = 95.5  # Declaration and initialization of a floating-point variable 1.3. Use Preemptive Data Types: Define: Preemptive data types are data types that are predefined and provided by...
Post a Comment
Read more

Chapter No 6 Interface Java

  Chapter 6                      Interfaces   6.1 Introduction  6.2. Defining and Implementing Interfaces   6.3. Advantages of using Interface    6.1 Introduction   An interface in Java is a collection of abstract methods. It provides a way to achieve abstraction and multiple inheritance in Java. An interface is a blueprint for a class and allows the definition of methods without specifying the implementation. Classes implementing an interface must provide concrete implementations for all its methods.   Syntax   interface MyInterface{ {      // Declare methods (implicitly public and abstract)      void method1();      void method2(); }   Explanation   An interface is declared using the interface keyword.  Methods declared in the interface ar...
Post a Comment
Read more