answersLogoWhite

0

Sparse advantage, less storage space required

Dense advantage faster since each index key is directly linked to a record key

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Outline one advantage and one disadvantage of using Human Development Index figures to measure standards of living?

one disadvantage of using human development index.


What is difference between sparse index and dense index?

Dense Index: An index record appears for every search key value in file. This record contains search key value and a pointer to the actual record. Sparse Index: Index records are created only for some of the records. To locate a record, we find the index record with the largest search key value less than or equal to the search key value we are looking for. We start at that record pointed to by the index record, and proceed along the pointers in the file (that is, sequentially) until we find the desired record. - - (ref: http://sawaal.ibibo.com/computers-and-technology/difference-between-sparce-index-dence-index-773764.html)


Advantage of graded index fiber over step index fiber?

A graded index multimode fiber will transmit 800 modes, and has a varying refractive index. A step index multimode will transmit 228 modes.


What is the advantage and disadvantage of PI Value Method?

The PI (Profitability Index) Value Method helps prioritize investment projects by comparing the value created per unit of investment, making it easier for decision-makers to allocate resources efficiently. An advantage of this method is that it provides a clear ratio that helps identify the most profitable projects relative to their costs. However, a disadvantage is that it may overlook the scale of investment, potentially favoring smaller projects that yield high returns but may not significantly impact overall profitability compared to larger projects.


Why do baseball players remove a finger from their glove and extend it outside?

That is a personal preference and done mainly for comfort. There is no advantage nor disadvantage in doing it .... some players just feel more comfortable with the finger outside the glove. The index finger is closest to the pocket of the glove so you get more padding by having it outside the finger of the glove.


What are the advantages and disadvantages of index numbers?

There are different types of index numbers, so the advantages and disadvantages would change depending on what type was used. However, in general, the main advantage is ease of use in finding a particular item on the index, the main disadvantage is that all items are treated equally, regardless of true value.


Advantage and disadvantage of Profitability index PI?

Disadvantages of Profitability Index are:-Only used for divisible projectsstrategic value of projects are not considered.( only figures are dealt with not long term not short termlimited use when protect have differing cash flow pattern. ( only limited to investment with major cash at the beginning)absolute NPV vale is ignored, smaller projects receive more favourable treatment ( the equation treats all project as equally important.R.ogunleye university of Herfordshire (UK)


How the index of the DBMS is organized and works?

A database index is a data structure that improves the speed of data retrieval operations in DBMS. An index can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records. Most indexes use a B-tree structure. A B-tree is a tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic amortized time. The B-tree is a generalization of a binary search tree. The B-tree is optimized for systems that read and write large blocks of data. There are several index types out there: Bitmap index Dense index Sparse index Reverse index Etc...


Advantage and disadvantage of potassium hydroxide mount?

Advantages: Potassium hydroxide mount is a useful medium for mounting microscopic samples due to its high refractive index and transparency, which allows for clearer visualization of specimens. Disadvantages: Potassium hydroxide mount can be corrosive and hazardous if not handled properly. It may also have a limited shelf life due to evaporation and absorption of moisture from the air.


Why the refractive index of ice is lower than that of water?

The refractive index of a material is related to how light propagates through it. Ice has a lower refractive index than water because its molecular structure is less dense and more sparse compared to water. This difference in molecular arrangement affects how light interacts with the substance, leading to a lower refractive index in ice compared to water.


How is sparse matrix stored in the memory of a computer?

A sparse matrix contains many (often mostly) zero entries. The basic idea when storing sparse matrices is to only store the non-zero entries as opposed to storing all entries. Depending on the number and distribution of the non-zero entries, different data structures can be used and yield huge savings in memory when compared to a naïve approach. One example of such a sparse matrix format is the (old) Yale Sparse Matrix Format [1]. It stores an initial sparse N×N matrix M in row form using three arrays, A, IA, JA. NZ denotes the number of nonzero entries in matrix M. The array Athen is of length NZ and holds all nonzero entries of M. The array IA stores at IA(i) the position of the first element of row i in the sparse array A. The length of row i is determined by IA(i+1) - IA(i). Therefore IA needs to be of length N + 1. In array JA, the column index of the element A(j) is stored. JA is of length NZ. Another possibility is to use quadtrees


What are the advantages and disadvantages of indexed-sequential file organization?

Well, honey, let me break it down for you. The advantage of indexed-sequential file organization is that it allows for quick access to records through the index, making retrieval faster than in sequential files. However, the downside is that maintaining the index can be a pain in the rear, especially as the file grows in size. So, it's like having a fancy sports car - it's great when it works, but it can be a headache to maintain.