|
we have a pseudo dB in excel. There are loads of tables and even stuff like foreign keys and I think it's fully normalised somehow. it also breaks database design patterns in lots of exciting and different ways so that it looks just the way management likes it
|
# ¿ May 16, 2016 22:26 |
|
|
# ¿ Apr 29, 2024 07:10 |
|
qhat posted:you know you can just save it all to csv and probably load it into an sqlite db in about 5 seconds right business people can't edit it then though!!! or put hosed up references to random sheets in
|
# ¿ May 18, 2016 07:58 |
|
refleks posted:can someone explain to me what the gently caress an olap cube is. please keep in mind im a non-technical woman or childe that doesnt touch computers for a living. it's like map of temperatrues, where you have distance x and distance y on different axis and in the cells you have the temperature values. Except maybe you also have height on the z axis and it represents temperature in volumes of the atmosphere, so now you have a cube. And maybe you also have an other axis which represents time, so now you have a hypercube showing temperatures in volumes of the atmosphere over time (don't try and visualise this). etc Then there are loads of ways of extracting subsets of the information. You might only want to know temperature at 8km up, or maybe just how it changed over time at a specific point in time.
|
# ¿ May 22, 2016 11:40 |
|
you could also have another dimension for measures, eg pressure or humidity (and then all your previous values turn out to just have been in the "temperature" slice). obviously you can quickly end up with a lot of data as the total size of your table is the product of the lengths of the different dimensions e: to be clear you will probably only have one dimension defining all the different measures distortion park fucked around with this message at 11:51 on May 22, 2016 |
# ¿ May 22, 2016 11:44 |
|
I had to try and make a user interface to help non technical management and children make charts from any slice of an olap cube and failed miserably. we just hard code them now as no one else in the org understands it
|
# ¿ May 22, 2016 11:46 |
|
|
# ¿ Apr 29, 2024 07:10 |
|
refleks posted:that sounds like a hosed thought from someone who looked at pivot tables in Excel and thought: "This, but only more insane" more or less, yeah. it's a very useful way of looking at some datasets though though!
|
# ¿ May 23, 2016 10:10 |