Book Details

DATABASE ENGINEERING

DATABASE ENGINEERING

Published by uLektz

Course Code:PCCS4205

Author:uLektz

University: Biju Patnaik University of Technology (BPUT)

Regulation:2010

Categories:Computer Science

Format : ico_bookePUB3 (DRM Protected)

Type :eBook

FREE

Buy Now

Description :DATABASE ENGINEERING of PCCS4205 covers the latest syllabus prescribed by Biju Patnaik University of Technology (BPUT) for regulation 2010. Author: uLektz, Published by uLektz Learning Solutions Private Limited.

Note : No printed book. Only ebook. Access eBook using uLektz apps for Android, iOS and Windows Desktop PC.

Topics
UNIT I INTRODUCTION TO DATABASE SYSTEMS, DATABASE SYSTEM ARCHITECTURE AND STORAGE STRATEGIES

1.1 Introduction to database Systems, Basic concepts & Definitions, Data Dictionary, DBA

1.2 File-oriented system vs. Database System, Database Language

1.3 Database System Architecture-Schemas, Sub Schemas & Instances, 3-level database architecture, Data Abstraction, Data Independence, Mappings, Structure

1.4 Components & functions of DBMS, Data models, Mapping E-R model to Relational, Network and Object Oriented Data models, types of Database systems

1.5 Storage Strategies: Detailed Storage Architecture, Storing Data, Magnetic Disk, RAID, Other Disks, Magnetic Tape, Storage Access, File & Record Organization

1.6 File Organizations & Indexes, Order Indices, B+ Tree Index Files, Hashing

UNIT II RELATIONAL ALGEBRA, DATABASE DESIGN & QUERY PROCESSING AND OPTIMIZATION

2.1 Relational Algebra, Tuple & Domain Relational Calculus, Relational Query Languages: SQL and QBE

2.2 Database Design: Database development life cycle(DDLC), Automated design tools, Functional dependency and Decomposition, Dependency Preservation & lossless Design

2.3 Normalization, Normal forms:1NF, 2NF, 3NF, and BCNF, Multi-valued Dependencies, 4NF & 5NF

2.4 Query processing and optimization: Evaluation of Relational Algebra Expressions, Query optimization

UNIT III TRANSACTION PROCESSING AND CONCURRENCY CONTROL, DATABASE RECOVERY SYSTEM AND ADVANCED TOPICS

3.1 Transaction processing and concurrency control: Transaction concepts, concurrency control, locking and Timestamp methods for concurrency control

3.2 Database Recovery System: Types of Data Base failure & Types of Database Recovery, Recovery techniques

3.3 Advanced topics: Object-Oriented & Object – Relational Database, Parallel & Distributed Database

3.4 Introduction to Data warehousing & Data Mining

loading