Database Management System Database Design, Data Mining/Warehousing and Web Technology [ Note of RBB (Rastriya Banijya Bank) ] | Note of Rastriya Banijya Bank

Data

• Data refers to raw and unprocessed facts and figures.
• It may include numbers, text, symbols, images, or measurements.
• Data alone may not have a clear meaning until it is processed.
• It is used as input for processing in computer systems.
• Examples: Student names, marks, phone numbers, dates.

Information

• Information is processed and organized data that has meaning and value.
• It helps users understand situations and make decisions.
• Information is obtained after analyzing and interpreting data.
• It is used for planning, decision-making, and problem-solving.
• Examples: Student result reports, monthly sales reports, attendance summaries.

 

Database Management System (DBMS)

• A Database Management System (DBMS) is software used to create, store, organize, and manage data in a database.
• It allows users to insert, update, delete, and retrieve data efficiently.
• It provides a secure way to store and access large amounts of information.
• DBMS reduces data redundancy and improves data consistency.
• Common examples of DBMS include MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.

Functions of DBMS

1. Data Storage

• Stores large amounts of data in an organized manner.
• Saves data permanently for future use.
• Organizes data into tables, rows, and columns.
• Makes data easy to access and manage.

2. Data Retrieval

• Retrieves required data quickly and accurately.
• Allows users to search specific records easily.
• Supports queries to find information.
• Saves time by providing fast access to data.

3. Data Insertion

• Allows users to add new records to the database.
• Ensures data is stored correctly.
• Supports adding multiple records efficiently.
• Keeps the database updated with new information.

4. Data Updating

• Allows modification of existing records.
• Keeps information accurate and up to date.
• Updates data without affecting other records.
• Helps maintain correct information.

5. Data Deletion

• Removes unnecessary or outdated records.
• Frees storage space in the database.
• Keeps the database clean and organized.
• Prevents the use of incorrect information.

6. Data Organization

• Organizes data into tables and relationships.
• Makes data easy to understand and manage.
• Improves data accessibility.
• Supports efficient database operations.

7. Data Security

• Protects data from unauthorized access.
• Uses usernames, passwords, and permissions.
• Ensures only authorized users can modify data.
• Maintains the confidentiality of information.

8. Data Sharing

• Allows multiple users to access the same database.
• Supports simultaneous access by different users.
• Improves collaboration among users.
• Ensures everyone works with the latest data.

9. Backup and Recovery

• Creates backup copies of important data.
• Restores data after system failures.
• Prevents permanent data loss.
• Ensures business continuity.

10. Data Integrity

• Maintains the accuracy of stored data.
• Prevents invalid or incorrect data entry.
• Enforces database rules and constraints.
• Keeps data reliable and consistent.

11. Data Redundancy Control

• Reduces unnecessary duplication of data.
• Saves storage space.
• Prevents inconsistent information.
• Improves database efficiency.

12. Data Consistency

• Ensures the same data appears correctly throughout the database.
• Updates changes in all related records.
• Prevents conflicting information.
• Improves data reliability.

13. Transaction Management

• Manages database transactions safely.
• Ensures all operations are completed successfully.
• Rolls back changes if an error occurs.
• Maintains database consistency.

14. Concurrent Access Control

• Allows multiple users to access data simultaneously.
• Prevents conflicts between users.
• Protects data from corruption.
• Ensures correct transaction execution.

15. Report Generation

• Generates reports from stored data.
• Provides summarized information.
• Helps in analysis and decision-making.
• Saves time in preparing reports.

Types of DBMS

1. Hierarchical DBMS

• Stores data in a tree-like structure with parent-child relationships.
• Each child record has only one parent, but one parent can have many children.
• Data is accessed from the top (root) to the bottom.
• It is simple and provides fast data retrieval for one-to-many relationships.
• It is difficult to represent many-to-many relationships.

            Advantages

·         Fast data access.

·         Easy to understand for simple structures.

·         Maintains strong parent-child relationships.

Disadvantages

·         Does not support many-to-many relationships.

·         Difficult to modify the database structure.

·         Data redundancy may occur.

2. Network DBMS

• Stores data in a network structure instead of a tree.
• A child record can have multiple parent records.
• Supports many-to-many relationships.
• Records are connected using links or pointers.
• More flexible than the hierarchical model.

Advantages

·         Supports complex relationships.

·         Faster data access through pointers.

·         Reduces data redundancy.

Disadvantages

·         Complex database design.

·         Difficult to maintain.

·         Requires skilled users.

3. Relational DBMS (RDBMS)

• Stores data in tables (relations) consisting of rows and columns.
• Tables are connected using Primary Keys and Foreign Keys.
• Uses SQL (Structured Query Language) to manage data.
• The most widely used type of DBMS today.
• Supports data integrity, security, and relationships between tables.

Advantages

• Easy to use and maintain.
• Reduces data redundancy through normalization.
• Supports multiple users simultaneously.
• Provides high data security and integrity.

Disadvantages

• Can be slower for very complex queries.
• Requires more storage for large databases.
• Database design can be complex.

Examples: MySQL, Oracle Database, Microsoft SQL Server, PostgreSQL, SQLite

 

4. Object-Oriented DBMS

• Stores data in the form of objects, similar to object-oriented programming languages.
• Combines both data and methods into a single object.
• Supports concepts like classes, objects, inheritance, and polymorphism.
• Suitable for multimedia, engineering, and scientific applications.

Advantages

• Handles complex data easily.
• Supports object-oriented programming.
• Suitable for multimedia and engineering applications.

Disadvantages

• ·         More complex than RDBMS.
• ·         Less widely used.
• ·         Higher implementation cost.

 

Table

• A table is the basic structure used to store data in a database.
• It organizes data into rows and columns for easy storage and management.
• Each table stores information about a specific entity, such as students, employees, customers, or products.
• A table consists of columns (fields) that define the type of data and rows (records) that store the actual data.
• Each column has a unique name and stores a specific type of information.
• Each row contains complete information about one record.
• Every table should have a Primary Key to uniquely identify each record.
• Tables can be related to other tables using Foreign Keys.
• A well-designed table reduces data duplication and improves data organization.
• Tables make it easier to insert, update, delete, and retrieve information.

Record

• A record is a single row in a database table.
• It contains complete information about one entity or object.
• Every record is made up of values from all the columns in the table.
• Each record represents one real-world object, such as one student, one employee, or one customer.
• A record is usually identified by a Primary Key, which makes every record unique.
• Records can be inserted, updated, deleted, and retrieved by the DBMS.
• Multiple records together form a complete table.
• Records help organize and manage data efficiently.
• The number of records in a table can increase as new information is added.
• Each record must follow the same structure defined by the table.

Relationship

• A relationship is an association or connection between two or more tables in a database.
• It allows data stored in different tables to be linked together.
• Relationships are created using Primary Keys and Foreign Keys.
• They help reduce data redundancy by avoiding repeated data.
• Relationships maintain data consistency and integrity.
• They make it easier to retrieve related information from multiple tables.
• A well-designed relationship improves database efficiency.
• Relationships help maintain accuracy when data is updated.
• Most relational databases use relationships to connect tables.

·    

Types of Relationships in DBMS

1. One-to-One Relationship (1:1)

• A one-to-one relationship exists when one record in one table is related to only one record in another table.
• It connects two tables where each entity has only one corresponding entity in the other table.
• Each record in the first table matches with exactly one record in the second table.
• It is used to divide large tables into smaller tables for better organization and security.
• The primary key of one table can be used as a foreign key in another table.
• It helps reduce data duplication and improves database structure.
• This type of relationship is less common compared to other relationships.
• Example: One person has one passport, and one passport belongs to one person.

 

2. One-to-Many Relationship (1:M)

• ·         A one-to-many relationship exists when one record in one table is related to many records in another table.
• ·         It is the most commonly used relationship type in relational databases.
• ·         One record from the first table can have multiple related records in the second table.
• ·         Each record in the second table is connected to only one record in the first table.
• ·         The primary key of the first table is stored as a foreign key in the second table.
• ·         It helps reduce data redundancy and improves data organization.
• ·         It is commonly used in real-world applications.
• ·         Example: One teacher can teach many students, but each student has only one teacher.

3. Many-to-Many Relationship (M:N)

• ·         A many-to-many relationship exists when many records in one table are related to many records in another table.
• ·         It allows multiple entities from one table to connect with multiple entities from another table.
• ·         This relationship cannot be directly implemented in a relational database.
• ·         A third table called a junction table or bridge table is created to connect the two tables.
• ·         The junction table contains foreign keys from both related tables.
• ·         It is used for complex data relationships in large database systems.
• ·         It provides flexibility and helps maintain proper data organization.
• ·         Example: Many students can enroll in many courses, and each course can have many students.

 

Indexing

• ·         Indexing is a technique used to improve the speed of searching and retrieving data from a database.
• ·         It creates a special data structure that allows the database to locate records quickly.
• ·         An index works like the index of a book, helping users find information without searching every page.
• ·         Indexes are usually created on columns that are searched frequently.
• ·         Indexing reduces the time required to execute SQL queries.
• ·         It improves the performance of large databases.
• ·         Multiple indexes can be created on a table if necessary.
• ·         Indexes require additional storage space.
• ·         Too many indexes can slow down INSERT, UPDATE, and DELETE operations because the indexes must also be updated.
• ·         Proper indexing improves the overall efficiency of the database.

Types of indexing

1. Primary Indexing

·         Primary indexing is an index created on the primary key of a table.

·         It is used to quickly search records using the primary key value.

·         The primary key column must contain unique values.

·         The data records are stored in the same order as the primary key.

·         It helps improve the speed of data retrieval.

·         Only one primary index can be created on a table because a table can have only one primary key.

2. Secondary Indexing

·         Secondary indexing is an index created on a column that is not a primary key.

·         It allows faster searching based on non-primary key attributes.

·         A table can have multiple secondary indexes.

·         It does not change the physical order of data storage.

·         It improves query performance when searching frequently used columns.

3. Clustered Indexing

·         Clustered indexing stores data records in the same order as the index.

·         The physical arrangement of data in the table is changed according to the index.

·         It allows faster retrieval of records because data is stored in sorted order.

·         Only one clustered index can be created on a table.

·         It is usually created on columns that are frequently searched or sorted.

4. Non-Clustered Indexing

·         Non-clustered indexing creates a separate index structure that stores pointers to the actual data records.

·         The physical order of data remains unchanged.

·         A table can have multiple non-clustered indexes.

·         It improves the speed of searching without changing the original data arrangement.

·         It requires additional storage space for maintaining the index.

5. Dense Indexing

·         Dense indexing creates an index entry for every record in the database.

·         Each search key value has a corresponding index entry.

·         It provides faster data retrieval because every record can be accessed directly.

·         It requires more storage space because many index entries are created.

·         It is suitable for frequently accessed databases.

6. Sparse Indexing

·         Sparse indexing creates index entries only for some records instead of every record.

·         It requires less storage space compared to dense indexing.

·         It works efficiently when data is stored in sorted order.

·         Searching may require additional scanning after finding the closest index value.

·         It is less costly to maintain.

7. Composite Indexing

·         Composite indexing is an index created on two or more columns of a table.

·         It is used when queries frequently search using multiple attributes.

·         It improves performance for complex queries.

·         The order of columns in the index affects query performance.

·         It helps retrieve data faster from large tables.

Data Warehousing

• ·         Data warehousing is a system used to collect, store, and manage large amounts of data from different sources.
• ·         It stores historical data that is used for analysis and decision-making.
• ·         A data warehouse provides organized and integrated data for business intelligence.
• ·         It helps organizations identify trends and make better decisions.
• ·         Data warehouses are mainly used for reporting, analysis, and data mining.

Process in Data Warehousing

1. Data Extraction

• Data extraction is the process of collecting data from different sources and systems.
• Data is gathered from various sources such as databases, applications, files, and external systems.
• It collects both structured and unstructured data.
• The extracted data is usually raw and may contain errors or inconsistencies.
• Data extraction prepares information for further processing.
• It ensures that required data is collected from all available sources.

2. Data Transformation

• Data transformation is the process of converting raw data into a suitable format for storage and analysis.
• ·         Removes errors and duplicate data.
• ·         Cleans and organizes the collected data.
• ·         Converts data into a common format.
• ·         Applies rules and calculations to improve data quality.
• ·         Ensures that data from different sources becomes consistent.

3. Data Loading

• Data loading is the process of storing transformed data into the data warehouse.
• ·         Transfers processed data into the central warehouse.
• ·         Loads data according to the warehouse structure.
• ·         Can be performed periodically or continuously.
• ·         Ensures that the warehouse contains updated information.
• ·         Maintains organized storage of large amounts of data.

4. Data Storage

• Data storage is the process of maintaining processed data in the data warehouse.
• ·         Stores large volumes of historical data.
• ·         Organizes data for fast retrieval and analysis.
• ·         Maintains data security and consistency.
• ·         Allows users to access stored information when required.
• ·         Supports long-term data management.

5. Data Analysis and Reporting

• Data analysis is the process of examining stored data to generate useful information.
• ·         Helps identify trends and patterns.
• ·         Supports business decision-making.
• ·         Generates reports, charts, and dashboards.
• ·         Allows managers to analyze business performance.
• ·         Helps in forecasting future outcomes.

Advantages of Data Warehousing

• ·         Provides better decision-making support.
• ·         Stores historical data for future analysis.
• ·         Improves data quality and consistency.
• ·         Allows faster reporting and analysis.
• ·         Combines data from multiple sources.
• ·         Helps identify business trends.
• ·         Supports business intelligence applications.

Disadvantages of Data Warehousing

• ·         Requires high implementation cost.
• ·         Needs skilled professionals for management.
• ·         Requires large storage capacity.
• ·         Development and maintenance are complex.
• ·         Data loading and updating may take time.

Applications of Data Warehousing

• ·         Banking and financial services
• ·         Healthcare systems
• ·         Education institutions
• ·         Retail businesses
• ·         E-commerce companies
• ·         Telecommunication industries
• ·         Government organizations
• ·         Manufacturing industries

 

HTML (HyperText Markup Language)

• ·         HTML is a standard markup language used to create and structure web pages.
• ·         It defines the basic structure of a website by using tags and elements.
• ·         HTML is used to display content such as text, images, videos, links, tables, and forms on web pages.
• ·         It provides the skeleton of a webpage and works together with CSS and scripts to create complete websites.
• ·         HTML documents are interpreted by web browsers such as Chrome, Firefox, and Edge.
• ·         It uses various tags to organize webpage content, such as headings, paragraphs, lists, and hyperlinks.
• ·         HTML is not a programming language because it does not perform logical operations or calculations.
• ·         It is widely used in web development for creating static and dynamic web pages.
• ·         Common HTML tags include <h1> for headings, <p> for paragraphs, and <img> for images.

Example

HTML Structure

1. <!DOCTYPE html>

• ·         Defines the document type.
• ·         Tells the browser that the document uses HTML5.
• ·         Helps browsers display the page correctly.

2. <html>

• ·         The root element of an HTML document.
• ·         Contains all other HTML elements.

3. <head>

• ·         Contains information about the webpage.
• ·         It includes title, metadata, and links to stylesheets.

4. <title>

• ·         Defines the title of the webpage.
• ·         The title appears on the browser tab.

5. <body>

• ·         Contains the visible content of the webpage.
• ·         Includes text, images, links, tables, and other elements.

Types of HTML Tags

HTML tags are special keywords enclosed within angle brackets (< >) that define the structure and content of a webpage.

1. Paired Tags (Container Tags)

• ·         Paired tags are HTML tags that have both an opening tag and a closing tag.
• ·         The closing tag contains a forward slash (/) before the tag name.

Features:

·         They contain opening and closing tags.

·         They surround the content they affect.

·         The opening tag starts the element, and the closing tag ends it.

·         Most HTML elements are paired tags.

·         They are used to create structured content on webpages.

Examples:

<h1>Welcome</h1>

<p>This is a paragraph.</p>

<b>Bold Text</b>

Common Paired Tags:

   Tag                  Purpose

<html></html>    Defines an HTML document

<head></head>   Contains webpage information

<title></title>      Defines webpage title

<body></body>   Contains visible webpage content

<h1></h1>       Creates heading

<p></p>           Creates paragraph

<div></div>     Creates a section or division

<table></table>   Creates a table

<form></form>    Creates a form

 

2. Empty Tags (Unpaired Tags)

• ·         Empty tags are HTML tags that do not require a closing tag.
• ·         They perform a specific function without containing any content.

   Syntax:  <tagname>

Features:

• ·         They have only an opening tag.
• ·         They do not contain any text or other elements.
• ·         They are used for inserting or controlling specific elements.
• ·         They save space and simplify HTML code.

Examples:

<br>

<hr>

<img src="image.jpg">

Common Empty Tags:

 Tag     Purpose

<br>     Inserts a line break

<hr>     Creates a horizontal line

<img>  Displays an image

<input>            Creates input fields

<meta> Provides information about webpage

<link>  Connects external resources

<area>  Defines an area in an image map

 

Advantages of HTML

• ·         Easy to learn and use.
• ·         Free and open standard.
• ·         Supported by all web browsers.
• ·         Creates structured web pages.
• ·         Supports multimedia content.
• ·         Works with CSS and JavaScript.
• ·         Requires no special software.

Disadvantages of HTML

• ·         Used mainly for creating static webpages.
• ·         Requires CSS for advanced design.
• ·         Cannot perform complex programming operations alone.
• ·         Large websites require additional technologies.
• ·         Security features are limited.

Applications of HTML

• ·         Creating websites.
• ·         Designing web pages.
• ·         Creating online forms.
• ·         Developing web applications.
• ·         Creating email templates.
• ·         Displaying multimedia content.
• ·         Creating website layouts.

Note

1. Heading Tags

·         Heading tags are used to create headings on a webpage.

·         HTML provides six heading levels:

<h1>Main Heading</h1>

<h2>Sub Heading</h2>

<h3>Heading</h3>

<h4>Heading</h4>

<h5>Heading</h5>

<h6>Small Heading</h6>

2. Link (anchor) Tags

·         The anchor tag is used to create hyperlinks.

            Tag: <a href="URL">Link Text</a>

3. Image Tags

·         The image tag is used to display images on webpages.

            Tag: <img src="image.jpg">

4. List Tags

·         List tags are used to display information in list format.

1. Ordered List

·         Displays numbered items.

<ol>

<li>HTML</li>

<li>CSS</li>

</ol>

2. Unordered List

·         Displays items with bullets.

<ul>

<li>HTML</li>

<li>CSS</li>

</ul>

 

5. Table Tags

·         Table tags are used to create tables in webpages.

Common Table Tags:

Tag                          Purpose

<table>       Creates a table

<tr>            Creates a table row

<th>           Creates table heading

<td>           Creates table data

 

6. Form Tags

·         Form tags are used to collect user input.

Example:

<form>

<input type="text">

<button>Submit</button>

</form>

 

Script

• ·         A script is a set of instructions written in a scripting language to add functionality and interactivity to a webpage or application.
• ·         Scripts allow websites to respond to user actions and perform tasks automatically.
• ·         They are used for activities such as form validation, animations, calculations, data processing, and updating webpage content without reloading the page.
• ·         JavaScript is the most commonly used scripting language for web development.
• ·         Scripts can run on the client side (in the user's browser) or on the server side (on a web server).
• ·         They improve user experience by making websites more interactive and responsive.
• ·         Scripts work with HTML to control webpage behavior and with CSS to modify webpage appearance.

Features of Script

• ·         Adds interactivity to web pages.
• ·         Performs calculations and logical operations.
• ·         Responds to user actions such as clicks and keyboard input.
• ·         Validates user input before submitting forms.
• ·         Changes webpage content without reloading the page.
• ·         Can display messages, animations, and effects.
• ·         Makes websites more user-friendly and dynamic.

Uses of Script

• ·         Validating forms before submission.
• ·         Displaying alert messages.
• ·         Performing calculations.
• ·         Creating animations and special effects.
• ·         Updating webpage content dynamically.
• ·         Handling user events like button clicks and mouse movements.
• ·         Building interactive web applications.

Types of Script

1. Internal Script

• An internal script is written directly inside the HTML document using the <script> tag.
• ·         The code is written within the same HTML file.
• ·         Suitable for small programs and simple webpages.
• ·         Easy to test and modify.

Example

<!DOCTYPE html>

<html>

<head>

    <title>Internal Script</title>

</head>

<body>

 

<h2>Welcome</h2>

 

<script>

    alert("Welcome to HTML!");

</script>

 

</body>

</html>

2. External Script

• An external script is written in a separate JavaScript file with the .js extension and linked to the HTML document.
• ·         Keeps HTML code clean and organized.
• ·         The same script can be used on multiple webpages.
• ·         Easier to maintain and update.

Example

<!DOCTYPE html>

<html>

<head>

    <title>External Script</title>

    <script src="script.js"></script>

</head>

<body>

<h2>Welcome</h2>

</body>

</html>

 

JavaScript File (script.js)

alert("Welcome to HTML!");

 

Advantages of Script

• ·         Makes web pages interactive.
• ·         Improves user experience.
• ·         Reduces manual work by automating tasks.
• ·         Performs client-side validation.
• ·         Supports dynamic content updates.
• ·         Increases website functionality.

Disadvantages of Script

• ·         Requires JavaScript support in the browser.
• ·         Errors in scripts may affect webpage functionality.
• ·         Large scripts may reduce webpage performance.
• ·         Some users may disable JavaScript for security reasons.

Stylesheet

• ·         A stylesheet is a file or set of rules used to control the visual appearance and layout of a webpage.
• ·         It defines how HTML elements are displayed on a screen.
• ·         Stylesheets control properties such as colors, fonts, sizes, spacing, backgrounds, borders, and page arrangement.
• ·         CSS (Cascading Style Sheets) is the most commonly used stylesheet language.
• ·         Stylesheets separate the design of a webpage from its content, making websites easier to maintain and update.
• ·         They allow the same design rules to be applied to multiple web pages.
• ·         Stylesheets help create attractive, responsive, and user-friendly web designs.
• ·         They are an essential part of modern web development along with HTML and scripts.

Features of Stylesheet

• ·         Controls the visual appearance of webpages.
• ·         Changes text colors, fonts, and sizes.
• ·         Defines webpage layouts and positioning.
• ·         Adds backgrounds, borders, and spacing.
• ·         Provides responsive design for different screen sizes.
• ·         Allows reuse of styles across multiple pages.
• ·         Separates webpage content from presentation.

Uses of Stylesheet

• ·         Designing attractive webpages.
• ·         Changing text formatting and appearance.
• ·         Creating page layouts.
• ·         Adding colors and backgrounds.
• ·         Designing navigation menus.
• ·         Creating responsive websites.
• ·         Improving website consistency and user experience.

Types of Stylesheet

There are three main types of CSS stylesheets:

1. ·         Inline Stylesheet
2. ·         Internal Stylesheet
3. ·         External Stylesheet

1. Inline Stylesheet

·         An inline stylesheet is a style written directly inside an HTML element using the style attribute.

Features:

• ·         Applies style to a single HTML element.
• ·         Useful for making quick changes.
• ·         Has the highest priority among CSS styles.
• ·         Not suitable for large websites.
• ·         Makes HTML code longer and harder to maintain.

Example:

<p style="color: blue; font-size: 20px;">

    This is a paragraph.

</p>

 

2. Internal Stylesheet

·         An internal stylesheet is written inside the <style> tag within the <head> section of an HTML document.

Features:

• ·         Applies styles to a single webpage.
• ·         Suitable for webpages with unique designs.
• ·         Keeps CSS code separate from HTML elements.
• ·         Easier to manage than inline styles.
• ·         Cannot be reused easily on other webpages.

Example:

<html>

<head>

<style>

p {

    color: red;

    font-size: 18px;

}

</style>

</head>

 

<body>

<p>This is a paragraph.</p>

</body>

</html>

 

3. External Stylesheet

• ·         An external stylesheet is a separate CSS file linked to an HTML document.
• ·         The CSS file is saved with the .css extension.

Features:

• ·         Keeps HTML and CSS code separate.
• ·         Can be used by multiple webpages.
• ·         Makes websites easier to maintain.
• ·         Reduces code duplication.
• ·         Improves website loading and organization.

Example:

HTML File:

<head>

<link rel="stylesheet" href="style.css">

</head>

CSS File (style.css):

p {

    color: green;

    font-size: 18px;

}

Advantages of Stylesheet

• ·         Improves webpage design and appearance.
• ·         Reduces repeated code.
• ·         Saves time during website development.
• ·         Makes websites easier to maintain.
• ·         Provides consistent design across multiple pages.
• ·         Supports responsive web design.
• ·         Separates content from presentation.

Disadvantages of Stylesheet

• ·         Requires knowledge of CSS syntax.
• ·         Incorrect CSS rules may affect webpage appearance.
• ·         Large CSS files can become difficult to manage.
• ·         Browser compatibility issues may occur with some advanced features.

 

XML (Extensible Markup Language)

• ·         XML is a markup language used to store, organize, and transport data between different systems.
• ·         It allows users to create their own custom tags according to their requirements.
• ·         XML focuses on storing and sharing data rather than displaying it.
• ·         It is platform-independent, meaning data can be used across different operating systems and applications.
• ·         XML is commonly used for data exchange between web applications, databases, and software systems.
• ·         It helps in representing data in a structured and readable format.
• ·         XML supports data sharing between different technologies and programming languages.

Advantages of XML

• ·         Simple and easy to understand.
• ·         Allows custom tags.
• ·         Platform independent.
• ·         Supports data sharing between systems.
• ·         Stores data in a structured format.
• ·         Human and machine readable.
• ·         Separates data from presentation.

Disadvantages of XML

• ·         XML files are larger compared to other data formats.
• ·         Requires more storage space.
• ·         Processing XML data can be slower.
• ·         Syntax is more complex than simple text formats.
• ·         Requires proper structure and validation.

Web Server

• ·         A web server is a computer system or software that stores, processes, and delivers web pages to users over the Internet.
• ·         It receives requests from web browsers and sends the required web content back to the users.
• ·         Web servers use protocols such as HTTP (HyperText Transfer Protocol) and HTTPS for communication.
• ·         They store website files such as HTML pages, images, videos, and scripts.
• ·         Web servers handle multiple user requests and provide fast access to websites.
• ·         They also provide security features such as authentication and data protection.
• ·         Common web servers include Apache, Microsoft Internet Information Services (IIS), and Nginx.

Working of a Web Server

 The working process of a web server involves the following steps:

1. User Sends a Request

• ·         A user enters a website address (URL) into a web browser.
• ·         The browser sends a request to the web server using HTTP or HTTPS protocol.
• ·         The request contains information about the required webpage.

Example: A user enters www.example.com in a browser.

 

2. Web Server Receives the Request

• ·         The web server receives the request from the browser.
• ·         It identifies the requested resource.
• ·         It checks whether the requested file is available.

3. Processing the Request

• ·         The server processes the request.
• ·         It may retrieve a static file or execute server-side programs.
• ·         It communicates with databases if dynamic information is required.

4. Sending Response

• ·         The web server sends the requested content back to the browser.
• ·         The response may include HTML pages, images, videos, or other files.
• ·         The browser displays the content to the user.

Advantages of Web Server

• ·         Provides access to websites worldwide.
• ·         Handles multiple user requests.
• ·         Provides secure communication.
• ·         Supports dynamic web applications.
• ·         Stores and manages website resources.
• ·         Improves website availability and performance.

Disadvantages of Web Server

• ·         Requires maintenance and monitoring.
• ·         Hardware and hosting costs can be high.
• ·         Security threats may occur if not properly protected.
• ·         Server failures can make websites unavailable.
• ·         Requires technical knowledge to manage.

Proxy Server

• ·         A proxy server is an intermediate server that acts as a connection between a user device and the Internet.
• ·         It receives requests from users and forwards them to the required Internet resources.
• ·         It provides security by hiding the user's IP address and controlling Internet access.
• ·         Proxy servers can filter unwanted content and block unauthorized websites.
• ·         They improve performance by storing frequently accessed web content through caching.
• ·         They are commonly used in organizations to monitor and manage network traffic.
• ·         Proxy servers provide privacy, security, and efficient Internet access

Working of Proxy Server

 The working process of a proxy server involves the following steps:

1. Client Sends Request

• ·         A user sends a request to access a website through a browser.
• ·         The request first goes to the proxy server instead of directly reaching the website server.      

Example: A user requests to open a website like example.com.

 

2. Proxy Server Processes the Request

• ·         The proxy server receives the user's request.
• ·         It checks security rules, permissions, and filtering policies.
• ·         It decides whether the request should be allowed or blocked.

3. Proxy Server Connects to Destination Server

• ·         If the request is allowed, the proxy server sends the request to the target website server.
• ·         The destination server receives the request from the proxy server instead of the original user.

4. Response is Returned

• ·         The destination server sends the requested data back to the proxy server.
• ·         The proxy server forwards the response to the user's device.
• ·         The user receives the requested webpage or information.

Functions of Proxy Server

1. Provides Security

• ·         Acts as a barrier between users and the internet.
• ·         Prevents direct access to internal networks.
• ·         Helps protect systems from unauthorized access.

2. Improves Privacy

• ·         Hides the user's original IP address.
• ·         Provides anonymity while browsing.
• ·         Prevents websites from identifying the user's actual location.

3. Access Control

• ·         Controls which websites users can access.
• ·         Blocks harmful or restricted content.
• ·         Helps organizations manage internet usage.

4. Caching

• ·         Stores frequently accessed web content.
• ·         Reduces repeated downloads.
• ·         Improves browsing speed and saves bandwidth.

5. Traffic Monitoring

• ·         Tracks internet usage within a network.
• ·         Helps administrators analyze network activity.
• ·         Maintains records for security purposes.

6. Filtering Content

• ·         Blocks unwanted websites and harmful content.
• ·         Provides safe internet access.
• ·         Commonly used in schools and organizations.

Advantages of Proxy Server

• ·         Improves network security.
• ·         Provides user privacy.
• ·         Reduces internet bandwidth usage.
• ·         Increases browsing speed through caching.
• ·         Controls access to websites.
• ·         Helps monitor network activities.
• ·         Provides additional protection from online threats.

Disadvantages of Proxy Server

• ·         Can reduce internet speed if overloaded.
• ·         Requires proper configuration and maintenance.
• ·         Some proxy servers may not provide complete privacy.
• ·         A failed proxy server can interrupt internet access.
• ·         Requires additional hardware or software resources.

Disaster Recovery Planning

• ·         Disaster Recovery Planning (DRP) is a process of preparing strategies and procedures to recover computer systems, data, and network operations after a disaster.
• ·         It helps organizations continue their important activities during and after unexpected events.
• ·         Disasters may include hardware failure, cyberattacks, natural disasters, power failures, or data loss.
• ·         The main goal of disaster recovery planning is to minimize downtime and prevent loss of important information.
• ·         It ensures that critical systems and services can be restored quickly after a failure.

Objectives of Disaster Recovery Planning

1. Data Protection

• ·         Protects important business data from loss or damage.
• ·         Ensures backup copies of data are available.
• ·         Prevents permanent loss of critical information.

2. Minimize Downtime

• ·         Reduces the time required to restore systems.
• ·         Helps continue business operations after a disaster.
• ·         Improves service availability.

3. Ensure Business Continuity

• ·         Allows organizations to continue essential operations.
• ·         Provides alternative methods for performing important tasks.
• ·         Reduces the impact of unexpected failures.

4. Quick Recovery

• ·         Provides clear steps for restoring systems.
• ·         Helps employees respond quickly during emergencies.
• ·         Reduces confusion during disaster situations.

Components of Disaster Recovery Planning

1. Risk Assessment

• ·         Identifies possible threats and risks.
• ·         Determines the impact of different disasters.
• ·         Helps prioritize important systems and data.
• ·         Provides information for creating recovery strategies.

2. Data Backup Plan

• ·         Creates copies of important data.
• ·         Stores backups in secure locations.
• ·         Allows data restoration after data loss.
• ·         Ensures important information is not permanently lost.

Types of Backup:

1. Full Backup

A Full Backup is a complete copy of all data stored in a system.

Features:

·         Copies all files and folders from the selected source.

·         Provides a complete backup of data.

·         Requires more storage space compared to other backup types.

·         Takes more time to complete because all data is copied.

·         Restoring data is faster because only one backup set is required.

·         Used as the base backup for other backup methods.

Example: A company creates a backup of all employee records, documents, and databases every Sunday.

Advantages:

·         Easy and fast data restoration.

·         Complete copy of all information.

·         Simple to manage and maintain.

Disadvantages:

·         Requires large storage space.

·         Takes more time to perform.

·         Uses more network resources.

2. Incremental Backup

An Incremental Backup copies only the data that has changed since the last backup.

Features:

·         Backs up only new or modified files.

·         Requires less storage space.

·         Takes less time compared to full backup.

·         Usually performed after a full backup.

·         Each incremental backup depends on the previous backup.

Example:

·         Monday: Full backup

·         Tuesday: Backup only new changes made on Tuesday

·         Wednesday: Backup only changes made on Wednesday

Advantages:

·         Faster backup process.

·         Requires less storage space.

·         Reduces backup time.

Disadvantages:

·         Data restoration can be slower.

·         Requires multiple backup files for complete recovery.

·         If one backup file is damaged, recovery may fail.

3. Differential Backup

A Differential Backup copies all changes made since the last full backup.

Features:

·         Requires a full backup as the starting point.

·         Stores all changes made after the full backup.

·         Backup size increases over time.

·         Restoration is faster than incremental backup.

·         Requires fewer backup files for recovery.

Example:

·         Monday: Full backup

·         Tuesday: Backup changes after Monday

·         Wednesday: Backup all changes after Monday and Tuesday

Advantages:

·         Faster recovery than incremental backup.

·         Requires fewer backup files.

·         Easier to manage.

Disadvantages:

·         Requires more storage than incremental backup.

·         Backup size increases daily.

·         Takes more time than incremental backup.

3. Recovery Strategy

• ·         Defines methods for restoring systems after a disaster.
• ·         Identifies required resources and technologies.
• ·         Determines the order of system recovery.
• ·         Ensures critical services are restored first.

4. Disaster Recovery Team

• ·         A group of people responsible for managing recovery activities.
• ·         Assigns specific roles and responsibilities.
• ·         Coordinates recovery operations during emergencies.
• ·         Ensures proper communication among team members.

5. Recovery Site

A recovery site is an alternative location used when the main system becomes unavailable.

Types of Recovery Sites:

Hot Site

• ·         A fully equipped backup location.
• ·         Contains ready-to-use hardware and software.
• ·         Provides very fast recovery.

Warm Site

• ·         Contains some required equipment and resources.
• ·         Requires additional setup before use.
• ·         Provides medium recovery speed.

Cold Site

• ·         A basic facility without active systems.
• ·         Requires installation and configuration before use.
• ·         Provides slower recovery.

Disaster Recovery Planning Process

1. Identify Critical Systems

• ·         Determines important applications, data, and resources.
• ·         Identifies systems required for business operations.

2. Perform Risk Analysis

• ·         Evaluates possible disasters and their effects.
• ·         Estimates potential losses and downtime.

3. Develop Recovery Strategies

• ·         Creates methods for restoring systems and data.
• ·         Selects appropriate backup and recovery solutions.

4. Create Disaster Recovery Plan

• ·         Documents recovery procedures and responsibilities.
• ·         Defines steps to follow during emergencies.
• ·         Includes contact information and recovery instructions.

5. Test and Update the Plan

• ·         Tests whether the recovery plan works properly.
• ·         Identifies weaknesses and improves the plan.
• ·         Updates procedures according to changes in technology and business needs.

Advantages of Disaster Recovery Planning

• ·         Protects important data and systems.
• ·         Reduces downtime after disasters.
• ·         Ensures business continuity.
• ·         Improves organizational security.
• ·         Reduces financial losses.
• ·         Provides clear recovery procedures.
• ·         Increases customer confidence.

Disadvantages of Disaster Recovery Planning

• ·         Requires time and financial investment.
• ·         Needs regular testing and maintenance.
• ·         Developing a complete plan can be complex.
• ·         Requires trained personnel.
• ·         Backup systems may increase operational costs.

Importance of Disaster Recovery Planning

• ·         Protects valuable data and resources.
• ·         Reduces downtime and business interruption.
• ·         Helps recover systems quickly after failures.
• ·         Improves security and risk management.
• ·         Ensures continuous availability of important services.