May 26, 2014 at 6:10 pm
A few days ago i asked how Ebay.com or Amazon.com or Indeed.com created the item counts, typically on the left side of the web page.
My theory was SQL Indexed Views or SQL Triggers or SQL Functions or a combination.
Someone recently suggested OLAP cubes.
Would that be a better solution than SQL Indexed Views or SQL Triggers or SQL Functions?
Thanks
May 27, 2014 at 9:14 am
Cubes create distinct counts as part of the build process.
But unless you plan on using more functionality (measures and dimensions), seems like overkill.
Yet another toolset, query language, and process to maintain.
Counts are only as good as the last time the cube is processed.
If you have a cube already, or wish to learn more, that might help you decide.
Another piece of the puzzle is just why (and how) you are going to use these counts.
Generally when I do a cube, it is tied to a data warehouse, and users are involved in what dimensions and measures they need available to slice and dice the data.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply