Unit VIII: Physical Design – Database Management System

BCA 4th Semester DBMS (Database Management System) Notes Pdf, Physical Design – Database Management System

Physical Design – Database Management System

In this unit named Physical Design – Database Management System” readers and viewers will get information regarding the following topics:

  1. Introduction to Physical Design
  2. Physical Data Storage
  3. Memory Hierarchy for Computer System
  4. Cache Memory and Main Memory, Secondary Memory
  5. Access Methods in DBMS
  6. Indexes – Access Method
  7. Type of Indexes
  8. Function-Based Indexes, Bitmap Indexes, Domain Indexes, Clusters, Indexed Sequential Access Method (ISAM)
  9. Data Storage Methods
  10. Primary Storage
  11. Main Memory, Cache
  12. Secondary Storage
  13. Flash Memory, Magnetic Disk Storage
  14. Tertiary Storage
  15. Optical Storage, Tape Storage
  16. Data Clustering
  17. How Data Clusters Work?
  18. What Benefits Do Data Cluster Have For Data Management?
  19. What Systems Work Well With Clusters?
  20. Data Partitioning
  21. Advantages of Data Partition
  22. Designing Partitions
  23. Horizontal Partitioning (Sharding), Vertical Partitioning, Functional Partitioning
  24. File Organization
  25. Objectives of File Organization
  26. Organization of Records into Blocks
  27. Fixed Length Records, Variable Length Records
  28. Types of File Organization
  29. Sequential File Organization, Heap File Organization, Hash File Organization, B+ File Organization, Indexed Sequential Access Method (ISAM), Cluster File Organization
  30. Indexing in DBMS
  31. Index Structure
  32. Indexing Methods
  33. Ordered Indices, Primary Index, Dense Index, Sparse Index, Clustering Index, Secondary Index

This article Physical Design – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes:

Unit I: Operating System Overview - Database Management System

Unit II: Designing A Database - Database Management System

Unit III: Data Normalization - Database Management System

Unit IV: Queries In Database - Database Management System

Unit V: Advanced Queries In Database - Database Management System

Unit VI: Developing Stored Procedures - Database Management System

Unit VII: Creating DML Triggers - Database Management System

Unit IX: Database Application Types - Database Management System

Unit X: Distributed Database System - Database Management System

Unit XI: Object Oriented Database - Database Management System

No comments

Post a Comment

Share your honest opinion and feedback about this website, through the comment box.

Don't Miss
© 2019 - All Rights Reserved
Lots of BCA Notes (Pokhara University)