Database System Concept || Database Management System || Diploma second year CO/AN/IT
In today’s world, the essence of the data is more than the essence of crude oil or gases. We use it in pharmacy, science, technology, management studies and various places we never thought about. Due to data, we can predict how many COVID cases are going to get reported in a particular region and how overall country is going to get affected.
In computing, data is information that has been translated into a form that is efficient for movement or processing. It can be what you ate yesterday at the hotel, which video you watched a minute ago or the Instagram post you liked.
In today's blog, we will looking at the DataBase System Concept on by one
For context, we will be learning
1. What is data
2. DataBase and Database Management System
3. Functions and characteristics of DBMS
4. Why should we not work with file processing framework
5. Architectural levels of Database system
6. Working of dbms
7.Types of Data models
So let's get started,
What is data?
In today's digital world, data is like the building blocks of our technology progress. It's a bunch of basic facts and numbers stored in databases, waiting to become useful insights. Computers do the tricky work of turning this data into something valuable.
They organize, process, and refine it in a detailed way. Think of it like how a conductor leads an orchestra. Different kinds of data, like music, videos, and words, come together in the computer world.
Computers figure out what the data means and put it together like making a puzzle. This gives us helpful information, helping us choose wisely and find hidden clues. So, the teamwork between data and computers drives our drive to learn new things and create new stuff.
DataBase and DataBase Management System
Think of a database like a super organized tool that handles information. It helps keep data neat and lets us find things quickly. It's like having a smart system that arranges stuff in a way that's easy to use, change, and find again.
This system also lets different pieces of information connect with each other, kind of like puzzle pieces that fit together.
This whole setup is designed to give us the exact info we need. So, a database is like a helpful friend that keeps things tidy and helps us get the right answers.
It's properties are:
- Real-World Representation: A database mirrors parts of the real world. It's like a digital reflection of things, people, and events, making it easier for us to understand and work with.
- Logical Collection: It's a smart way of gathering data. Imagine it as a virtual container that holds information. This container is organized in a way that makes sense, so you can find what you need without any hassle.
- Meaningful Data: The data in a database isn't just random stuff. It has a purpose and meaning. It's like each piece of data has a label that tells you what it's all about.
- Designed and Built: Creating a database is like designing a blueprint for a house. You plan how everything will be organized and how different parts will connect. Then you build it, adding data like putting furniture into rooms.
- Specific Purpose: Every database has a job. It's made for a particular reason, like keeping track of sales, storing customer information, or managing inventory. It's like having a toolbox with just the right tools for a certain task.
In short, a database is a virtual world where real things are organized logically, given meaning, and put together purposefully. It's a bit like a digital puzzle where each piece fits perfectly.
They are organized by:
- Fields: The Building Blocks: Think of a field as the smallest piece of data that actually makes sense. It's like a tiny brick that carries meaning. For instance, if we talk about a person, a field could be their name, age, or address. Each of these things is a field.
- Records: Gathering Similar Fields: Imagine you have lots of people, and you want to keep track of their information. A record is like a folder that holds together related fields. So, if we're talking about a person, a record could contain fields like name, age, and address, all grouped together.
- Files: Bigger Collections: Imagine you have many of these folders (records) with related information. When you gather these folders together, you create a file. It's like having a bunch of folders in one big cabinet, and each folder has different info about different things, like people or products.
A Database Management System (DBMS) is a computer program that helps you handle data in a database. It takes your instructions, organizes data neatly, and retrieves information when you need it. It's like a virtual assistant for managing data, ensuring things stay organized and accessible. Popular examples include Microsoft Access, MS SQL Server, MySQL, and Oracle. These systems all work to make data management smooth and hassle-free, regardless of their unique features.
Functions and characteristics of DBMS
Functions of dbms are:
1. **Data Definition:** Defines how data is structured and stored in the database.
2. **Schemas:** Represents the logical structure and organization of the data.
3. **Data Manipulation:** Involves actions like insertion, modification, and deletion of data.
4. **Recovery:** Ensures that data can be restored after failures or errors.
5. **Security:** Provides measures to protect data from unauthorized access.
6. **Data Dictionary:** Stores metadata about the database, describing its structure.
7. **Query:** Allows users to request specific information from the database.
8. **Performance:** Focuses on optimizing speed and efficiency of database operations.
Characteristics of DBMS are:
1. **One User, Many Files:** Allows multiple users to access different files in the same database simultaneously.
2. **Self-Describing Nature:** The system stores metadata that describes the structure of the database and its contents.
3. **Isolation Between Programs and Data:** Programs are separated from the data they operate on, ensuring data security and preventing unauthorized access.
4. **Multiple Views:** Offers different perspectives on the same data, catering to various user requirements.
5. **Sharing:** Enables concurrent access to the database by multiple users or programs, while maintaining data integrity.
Why should we not work with file processing framework
In the realm of information management, the File Processing System (FPS) presents some drawbacks that warrant a second thought. One of its major disadvantages is data obscurity and inconsistency, where data gets scattered across various files, leading to confusion and inaccuracies.
Retrieving data from FPS often becomes cumbersome, resulting in difficulty accessing relevant information.
Moreover, FPS fails to provide data isolation, allowing unauthorized access and potentially compromising security. Ensuring data integrity is a challenge as well, as changes might be left incomplete due to crashes or errors.
Concurrent accessing of data in FPS can lead to confusion and data conflicts, hampering its reliability. Data security is also an area of concern, as FPS lacks robust mechanisms to protect sensitive information adequately.
On the other hand, the advantages of a Database Management System (DBMS) shine brightly, rendering it a superior choice.
A DBMS offers the independence of data and program, freeing users from managing data structures directly. It efficiently tackles the redundancy issue, where the same data is repeated across files, saving space and reducing the risk of inconsistencies. Data sharing becomes seamless in a DBMS environment, fostering collaboration among multiple users and applications.
The centralized control it provides simplifies management and maintenance, enhancing data consistency and minimizing errors. With built-in mechanisms, DBMS ensures data integrity, safeguarding the accuracy and reliability of information. Moreover, it addresses security concerns effectively, granting access rights and encryption features.
The performance and efficiency of DBMS elevate operations, thanks to optimized query processing and retrieval.
Instance - it's a collection of information stored in a database at instance of time.
Schema- it's the overall design of database
Architectural levels of Database system
In the world of databases, there exists a fascinating trio of architectural schemas that play a pivotal role in shaping the efficiency and effectiveness of Database Management Systems (DBMS). These schemas serve as a bridge between the intricate complexities of data and the practical needs of users, making data management a seamless experience.
**1. External Schema:** Imagine this as the personalized view, a window tailored to individual user preferences. The external schema focuses on how data appears to end-users and applications. It's like an artist's canvas, allowing users to interact with the database in a way that suits their specific requirements. For instance, consider a company's database housing both sales and inventory data. The sales team might have an external schema that showcases customer orders and revenues, while the inventory team might see a schema highlighting stock levels and suppliers. This separation of views offers flexibility, ensuring that different users can access the same data, each with a unique perspective.
**2. Conceptual Schema:** Here, we dive into the heart of the matter – the core organization of data. The conceptual schema represents the logical structure of the entire database, serving as the blueprint that outlines how different pieces of information relate to each other. Think of it as the architect's plans for a grand building. It abstracts the details, presenting a comprehensive view of data relationships while remaining independent of the technicalities of storage and retrieval. This schema creates a unified map that guides the overall design, ensuring data integrity and coherence across various applications.
**3. Internal Schema:** Beneath the surface, we find the realm of the internal schema. It's like a backstage area where all the behind-the-scenes action takes place. This schema deals with the actual storage, indexing, and physical organization of data on the storage medium. It's analogous to the mechanical and electrical systems of a building – essential yet concealed. The internal schema translates the high-level conceptual design into practical storage arrangements that optimize performance, making data retrieval swift and efficient.
Working of dbms
What is a query processor?
A query processor is the core component of a Database Management System (DBMS) responsible for handling and executing queries on the database, ensuring efficient retrieval and manipulation of data.
- **Query Processor:** The engine at the core of a DBMS that handles data retrieval and interaction, composed of various modules for seamless execution of queries.
- **DML Pre-Compiler:** A specialized tool that prepares and optimizes data manipulation commands, enhancing their efficiency within the DBMS.
- **Embedded Pre-Compiler:** A module that integrates database instructions into application code, enabling smooth interaction between applications and the DBMS.
- **DDL Interpreter:** An essential component that interprets data definition language statements, facilitating the creation and management of database structures.
- **Query Evaluation Engine:** The powerhouse behind query execution, navigating data using indexes and optimization strategies to efficiently retrieve accurate results.
There are various managers to manage the overall dbms. They are:
**1. Buffer Manager:**
- Manages data in memory buffers.
- Controls data movement between disk and memory.
- Optimizes data access by caching frequently used information in memory.
**2. File Manager:**
- Handles reading and writing of data files on disk.
- Ensures efficient storage and retrieval of data.
- Manages file organization, such as sequential or indexed storage.
**3. Transaction Manager:**
- Ensures the atomicity, consistency, isolation, and durability (ACID properties) of database transactions.
- Coordinates concurrent access to data, preventing conflicts.
**4. Orienization and Integrity Managers:**
- Enforces rules for data integrity and constraints defined by the database schema.
- Manages the logical structure of data, ensuring meaningful relationships between different data items.
**5. Database Manager:**
- Oversees the overall management and operation of the database system.
- Coordinates interactions between various components of the storage manager and the database as a whole.
- Ensures data security, performance optimization, and adherence to database design principles.
The types of users are:
1. **End Users (Night Users):** Individuals who access the database during off-peak hours for tasks like generating reports.
2. **Application Programs:** Programs that interact with the database to perform specific tasks on behalf of users.
3. **Profit-Sensitive Users:** Users who leverage the database to enhance business operations and maximize profits.
4. **Database Administrators (DBAs):** Professionals responsible for managing and maintaining the overall health of the database system.
5. **Database Designers:** Individuals who create the blueprint for the database structure, ensuring efficient organization.
6. **Specialized Users:** Individuals with specific expertise, such as data analysts, who extract insights from the data for decision-making.
Types of Data models
There are many data models, but the tops ones are:
**1. Network Model:**
The Network Model organizes data in a more complex structure than the hierarchical model, allowing each record to connect with multiple records. This flexibility comes from the concept of "sets" and "members." Records are grouped into sets, and each set can have multiple members. It's like a web of interrelated records, where each member can link to others. While powerful, this model can be complex to manage and less intuitive for certain types of data.
**2. Hierarchical Model:**
In the Hierarchical Model, data is organized in a top-down structure resembling a family tree. It features parent-child relationships, where each record can have only one parent but can have multiple children. This is useful for representing data with clear hierarchical relationships, like organizational structures. However, it can be limiting for data with more complex connections or multiple parents.
**3. Entity-Relationship (ER) Model:**
The ER Model is a powerful graphical representation used to design databases. It focuses on entities (objects, concepts, or things) and the relationships between them. Entities are represented as rectangles, and relationships are depicted as lines connecting them. Attributes (characteristics) of entities are captured within ovals connected to the entity. This model helps visualize how different entities interact and relate to one another, aiding in database design and conceptualization.
Conclusion:
In the realm of data management, we've journeyed through the essentials, from grasping the nature of data and the intricacies of Database Management Systems (DBMS) to uncovering their functions, architectural levels, and the shortcomings of the File Processing Framework. As we explored various Data Models, we've gained insights into different ways of structuring information. From hierarchies to relationships, our understanding has deepened, empowering us to make informed choices. This knowledge arms us to wield data as a potent tool, driving innovation and progress in a world where information reigns supreme.
Comments
Post a Comment