Sparse dense

Deepalitrapti asked Aug 15, 2018

325 views

0 votes

Deepalitrapti asked Aug 15, 2018

Deepalitrapti

325 views

See all

6 6 Comments

Show 3 previous comments

arvin

commented Aug 15, 2018

1)445

2)45

3)3

4)2

0 votes

Deepalitrapti

commented Aug 15, 2018

1) 435

2) 44 u have to recheck

0 votes

arvin

commented Aug 15, 2018

see for dense index blocking factor= floor(1024/15)=68

no. of levels =(ceil(30000/68))

.................................................................................................................

0 votes

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Voting & Accepting an answer helps improve the community

← Previous Next →

← Previous in category Next in category →

Related questions

0 votes

1 answer

Deepalitrapti asked Aug 14, 2018

998 views

Sparse index and dense index

Deepalitrapti

998 views

Deepalitrapti asked Aug 14, 2018

0 votes

1 answer

set2018 asked Nov 10, 2017

1,683 views

sparse/dense indexing
which statement is true? 1)for any data file it is possible to construct two separate sparse first level index on different keys. 2)for any data file it is possible to construct two separate dense first level index on different keys. 3)for any data file it is possible to construct a sparse first level index and a dense second level indexboth should be useful 4) none.

which statement is true?1)for any data file it is possible to construct two separate sparse first level index on different keys.2)for any data file it is possible to cons...

set2018

1.7k views

set2018 asked Nov 10, 2017

Databases
databases
indexing

+ –

23 votes

1 answer

reena_kandari asked Oct 26, 2017

5,767 views

B+tree with sparse/Dense indexing
Database file consists of $10,000$ records with record size of $100$ bytes, block size $512$ bytes. If sparse B+ tree index is built over given database file with search key size $22$ bytes and both block pointer and record pointer of size $12$ bytes each.Find out a)minimum index block required b)maximum index block required my answers a)$143$ b)$325$.

Database file consists of $10,000$ records with record size of $100$ bytes, block size $512$ bytes. If sparse B+ tree index is built over given database file with search ...

reena_kandari

5.8k views

reena_kandari asked Oct 26, 2017

Databases
databases
indexing
bplustrees

+ –

0 votes

1 answer

srestha asked Sep 16, 2017

618 views

Sparse and Dense index doubt
Block size 1000 B Search key 12 B Pointer size 8B What is max records of DB 1) For Dense index B+ tree of 2 level 2) For Sparse index B+ tree of 2 level How ans will differ , Plz show

Block size 1000 BSearch key 12 BPointer size 8BWhat is max records of DB1) For Dense index B+ tree of 2 level2) For Sparse index B+ tree of 2 levelHow ans will differ , P...

srestha

618 views

srestha asked Sep 16, 2017

Databases
databases
indexing

+ –

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

6 6 Comments reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

6 6 Comments