4 ms·
Sounds to me like you want data warehousing/Online Analytics Processing tools, but you don’t have a DW/OLAP environment. I’m not sure what kind of tools you co
by bradknowles 6y ago
Sounds to me like you want data warehousing/Online Analytics Processing tools, but you don’t have a DW/OLAP environment.
I’m not sure what kind of tools you could bolt onto SQL databases to make them more useful in this kind of context.
You might be better off exporting all your data on a regular basis to real DW databases and then using their tooling.
I’m sorry that I don’t have any better answers for you.
- rntksi 6y agoThis works too, I'm guessing having some sort of data aggregation environment that pulls out data into it via defined procs that converts raw data into named, meaningful tables ? DW/OLAP sounds like big concepts that big entreprises would need. I guess that's why I never thought of it that way.