Which techniques / tips can you give in relation to summarizing the report data points, so that you store raw data in Do not have to do the database?
For example, if I was storing pageview traffic for a website, and my report was accurate for hours, I could roll-up all the database rows for hours, And then even possible to carry out the tables, various tables such as per day / month etc.
Any other tips / tricks with these lines?
You are talking about data storage / data mining. You still need OLTP ("raw") data in the database, but you will create an additional OLAP data warehouse with "pre-ordered" numbers for faster reports access. However, this is a costly enterprise in dollar and time - certainly not suitable for web site statistics unless you are Google or Amazon, so it is better that you have set up what you have set up and to summarize the data. Use your questions.
Comments
Post a Comment