Study guide: Database Systems Overview

📋 Course Outline

1. Database Purpose and Components
2. Data and Information
3. Traditional File Systems
4. File System Limitations
5. Industry 4.0 Technologies
6. Database and DBMS Concepts
7. File Systems Versus Databases
8. Database User Roles

📖 1. Database Purpose and Components

🔑 Key Concepts & Definitions

• Database: a shared collection of related data used to support the activities and information needs of a particular organization

📝 Essential Points

• A database system is built to meet an organization's information needs and contains basic components that support the collection and use of data.

📖 2. Data and Information

🔑 Key Concepts & Definitions

• Data: collected raw facts about a topic or item that are unorganized and unstructured
• Information: data that have been processed, interpreted, organized, structured, or presented so as to become meaningful or useful

📝 Essential Points

• In the student example, separate unordered values become information when they are organized under the fields STUDENT_ID, NAME, ADDRESS, and PHONE.

💡 Memory Hook

Data are raw facts, whereas information is meaningful processed data.

📖 3. Traditional File Systems

🔑 Key Concepts & Definitions

• File Management System: software that manages data files in a computer system

★ Must-know

• In a traditional file-based system, each file is independent of the others and data from different files are integrated by writing an individual program for each application.

Further detail

📌 Traditional file systems are simple to use, less complex, require minimal investment, and do not require specialists, but they are inefficient for maintaining records in large firms with many items.

📖 4. File System Limitations

★ Must-know

• Traditional file systems have high data redundancy because the same data may be duplicated across files.

• Traditional file systems have high program-data dependency because changing a file structure requires changing the application programs that access it.

• Traditional file systems provide poor security and lack automatic backup and recovery, while concurrent access is commonly managed by locking a file when an application opens it.

Further detail

• Traditional file systems face data integrity problems because a changed constraint must be updated in every application program that accesses the data file.

💡 Memory Hook

Independent files → redundancy, dependence, weak integrity, security, and recovery.

📖 5. Industry 4.0 Technologies

🔑 Key Concepts & Definitions

• Industry 4.0: a phase of the Industrial Revolution focused on interconnectivity, automation, machine learning, and real-time data
• Blockchain: a distributed database that maintains a continuously growing list of ordered records called blocks, linked using cryptography and containing a previous-block hash, a timestamp, and transaction data
• Artificial Intelligence: a computer's ability to perform tasks and make decisions that would historically require some level of human intelligence
• Big Data: large sets of structured or unstructured data that can be stored, organized, and analyzed to reveal patterns, trends, associations, and opportunities
• Cloud Computing: the use of interconnected remote servers hosted on the Internet to store, manage, and process information
• Quantum Computing: the use of quantum computers and quantum bits, or qubits, which can represent 0 and 1 simultaneously to enable parallel processing beyond traditional computer speeds
• Automatic Speech Recognition: algorithms to convert spoken language into written text and thereby reduces reliance on manual transcription
• Renewable Energy Technologies: technologies generate power from resources that are naturally replenished on a human timescale

📝 Essential Points

• Industry 4.0 includes: blockchain, IoT, IIoT, big data, artificial intelligence, cloud computing, quantum computing, text-to-speech technologies, renewable energy technologies

📌 IoT connects physical objects such as sensors or machines to the Internet, whereas IIoT connects people, data, and machines in manufacturing.

💡 Memory Hook

IoT, IIoT, Big Data, AI, Cloud, Quantum, Speech, and Renewable Energy.

📖 6. Database and DBMS Concepts

🔑 Key Concepts & Definitions

• DBMS: software that controls the storage, organization, and retrieval of data and enables users to create, maintain, and control access to databases

★ Must-know

• The primary goal of a DBMS is to provide users with an environment that is convenient and efficient for retrieving and storing information.

• The database approach reduces redundancy because ideally each data item is stored in only one place in the database.

📌 A DBMS enforces integrity constraints so users enter valid information and maintain data integrity.

• A DBMS supports concurrent access through a concurrency control subsystem that allows multiple users to access the same data while controlling simultaneous updates.

Further detail

• Schools, banks, airlines, railways, and telecommunication departments use databases for information such as students and courses, customers and transactions, reservations and schedules, and networks and bills.

💡 Memory Hook

Centralized control → lower redundancy, stronger integrity, and concurrent access.

📖 7. File Systems Versus Databases

★ Must-know

📌 A file system stores unstructured data as isolated files, whereas a database system stores structured data with well-defined constraints and interrelationships.

📌 File systems generally have high data redundancy, high data inconsistency, and low security, whereas database systems generally have low redundancy, low inconsistency, and high security.

Further detail

📌 File systems are easy-to-use systems for general files requiring fewer security constraints, whereas database systems are used when security constraints are high.

💡 Memory Hook

File systems favor simplicity; database systems favor security, structure, and control.

📖 8. Database User Roles

🔑 Key Concepts & Definitions

• End Users: access the database from a terminal and use developed applications without needing knowledge of database design or operation
• Database Designers: define the database content, structure, constraints, and functions or transactions and communicate with end users to understand their needs
• Database Administrator: who may be one person or a group, is responsible for authorizing access, coordinating and monitoring database use, controlling its use, and monitoring operational efficiency
• Application Programmers: implement specific application programs that access stored data and must be familiar with DBMSs

📝 Essential Points

• A DBA is responsible for:
  • deciding database instances
  • defining the schema
  • communicating with users
  • defining security
  • managing backup and recovery

📊 Synthesis Tables

File System and Database System Comparison