Multi-list file organisation, Database Management System

Assignment Help:

Multi-list file Organisation

Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical ordering of records is not of concern. In linked organisation the series of records is governed by the links that verify the next record in series. Linking of records can be unordered but such a linking is very costly for searching of information from a file. Thus, it may be a good idea to link records in the order of increasing primary key. This will facilitate deletion and insertion algorithms. Also this really helps the search performance. In addition to making order during linking, search by a file can be further facilitated by producing primary and secondary indexes. All these ideas are supported in the multi-list file organisation. Let us describe these concepts further with the help of an example.

Consider the employee data as given in Figure. The record numbers are given as alphabets for better explanation. Suppose that the Empid is the key field of the data records. Let us describe the Multi-list file organisation for the data file.

 

Record

Number

Empid

Name

Job

Qualification

Gender

City

Married/

Single

Salary

A

800

Jain

Software

Engineer

B. Tech.

Male

New Delhi

Single

15,000/-

B

500

Inder

Software

Manager

B. Tech.

Female

New Delhi

Married

18,000/-

C

900

Rashi

Software

Manager

MCA

Female

Mumbai

Single

16,000/-

D

700

Gurpreet

Software

Engineer

B. Tech.

Male

Mumbai

Married

12,000/-

E

600

Meena

Software

Manager

MCA

Female

Mumbai

Single

13,000/-

                                                                  Figure: Sample data for Employee file

Since, the primary key of the file is Empid, thus the linked order of records should be defined as B (500), E(600), D(700), A(800), C(900). Though, as the file size will grow the search performance of the file would deteriorate. Therefore, we can make a primary index on the file (please note that in this file the records are in the logical series and tied together using links and not physical placement, thus, the primary index will be a linked index file rather than block indexes).


Related Discussions:- Multi-list file organisation

I need label printing program, Project Description: Hi I'm seeking someo...

Project Description: Hi I'm seeking someone to make my dBase application work. I know it's not a 'modern' language but it's what I know. I have written an order program and I ne

Define the term- making common behaviour abstract, Making Common Behaviour ...

Making Common Behaviour Abstract Let us define abstraction "Abstraction means to focus on the necessary, inherent aspects of an entity and ignoring its accidental features". O

Write short notes on relational constraints, Write short notes on relationa...

Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check

Write a program within embedded sql to associative relation, Write a progra...

Write a program within embedded SQL to associative the total trip expenses of the salesman named ‘John' for the relations. EXEC SQL BEGIN DECLARE SECTION; long total_expenses;

Lock, intent locking

intent locking

Differences between a file processing system and a dbms, List any two signi...

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t

Need for a database management system, NEED FOR A DATABASE MANAGEMENT SYSTE...

NEED FOR A DATABASE MANAGEMENT SYSTEM A Database is a structured, persistent collection of data of an organisation. The database management system (DBMS) manages the database o

Create the database in oracle using ddl, The Assessment page has a link to ...

The Assessment page has a link to download a conceptual model, and a list of data. You are to map this conceptual model, and create the database in Oracle using your own DDL.  T

Datawarehouse Case studies, I have been given 8 differebt data warehouseing...

I have been given 8 differebt data warehouseing failure case studies. I need to question 4 questions for each

Sub query in the update command, Sub query in the UPDATE command : Exam...

Sub query in the UPDATE command : Example :  //Double  the  commission  for  employees,  who  have  got  at  least  2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd