Denormalization

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

speeds up reads

-improves query performance -BI reporting -BA data cubes you can find the information faster...it comes back to you quicker

denormalization

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields when you duplicate the data so it can be found in multiple places (more useful like this)

denormalization def

conversion of a table that is in third normal form to a table that is no longer in third normal form...introduces anomaly problems but can decrease the number of disk accesses required by certain types of transactions...thus improves performance

slows down writes

makes sure the data is being written in accurately not an architectural approach

denormalization and big data

normalization atomizes data -queries piece it back together it can be difficult to piece it back together, because big data does not always play along


संबंधित स्टडी सेट्स

Organization of political parties

View Set

Art History 2 Final: Artworks; Author, Title, Date, Culture, Style

View Set

algebra 1b - unit 3: using functions

View Set