Tag: spider schema

Spider Schema – a Bridge Between OLTP and OLAP?

IntroductionAs I mentioned in my article “OLAP for OLTP practitioners” , I am working on a project that needs to create ananalyticaldatabase for on-line analytical processing (OLAP). I have mostly worked with on-line transaction processing (OLTP) with some limited reporting features. OLAP is a new area for me. In OLAP, the main focus of the database itself is simply to store data for analysis; there is limited maintenance of data. In the previous article, I focused on the differences in