Which database paradigm should I leverage to support a Relational Database, which is updated as a weekly batch, and which supports typical analytics query-patterns.

From the RDBMS-side I need to support: PK <> FK relationships and referential integrity constraints, non-nullability, and 1NF.

From the Datawarehousing/OLAP side I need to support: aggregating 100's of GBs (100 Million records+), creating calculated fields and feeding into a BI Tool.

Finally, the data is delivered as a weekly batch, with the previous week's transactions provided in a file along with reference dimensions, placed on a hosted FTP.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.