uncleflo
Registered since September 28th, 2017
Has a total of 4281 bookmarks.
Showing top Tags within 1 bookmarks
howto information development guide reference administration design website software solution service online product business uk tool company linux code server system application web list video marine create data experience tutorial description explanation learn technology build article blog world boat project download windows lookup security free performance javascript technical london control network beautiful tools support course file research purchase image library programming youtube example php construction opensource install community html quality profile computer feature power browser music platform mobile process work manage professional user share database hardware buy industry internet dance advice developer installation camera search 3d access customer material travel money test standard develop css review documentation engineering photography engine webdesign digital device speed api source event question management program client phone discussion story simple content water marketing app yacht account setup idea interface package fast communication cheap compare script market study easy live google resource operation demonstration startup monitor
Tag selected: normalization.
Looking up normalization tag. Showing 1 results. Clear
Data Warehousing Summary Tables
Saved by uncleflo on June 27th, 2018.
This document discusses the creation and maintenance of "Summary Tables". It is a companion to the document on Data Warehousing Techniques. The basic terminology ("Fact Table", "Normalization", etc) is covered in that document. Summary tables are a performance necessity for large tables. MariaDB and MySQL do not provide any automated way to create such, so I am providing techniques here. (Other vendors provide something similar with "materialized views".) When you have millions or billions of rows, it takes a long time to summarize the data to present counts, totals, averages, etc, in a size that is readily digestible by humans. By computing and saving subtotals as the data comes in, one can make "reports" run much faster. (I have seen 10x to 1000x speedups.) The subtotals go into a "summary table". This document guides you on efficiency in both creating and using such tables.
mysql mariadb warehouse warehousing summary table technique terminology normalization performance large material view total guide efficiency improve development developer create database average administration administrator infrastructure howto blog article description solution
No further bookmarks found.