Sparsity and Density

What Does Sparsity and Density Mean?

Sparsity and density is a database concept that defines the number of empty, or sparse, cells and those that are full, or dense. The concept is used in multidimensional database (MDB) architectures to identify the average number of cells that are sparse or unutilized.


Techopedia Explains Sparsity and Density

Sparsity and density is used to improve database and data processing performance. Sparse cells can be any cell with zero or an empty cell value, while dense cells can include any non-zero value.

A processor must go through all database cells to find and process data. The number of sparse cells is directly proportional to the amount of a processor’s "useless" processing. Database administrators use sparsity and density to evaluate and eliminate sparse cells and improve database efficiency.


Related Terms

Latest Database Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…