Building the solution

This section outlines the construction of a proof-of-concept application that will implement the functionality required for this application. The details of data warehousing, OLAP, and data security each would require large, detailed books in and of themselves. At a minimum, we would suggest you consider studying the following topics:

  • Partitioning strategies for data storage and loading
  • Compression strategies
  • Transparent data encryption
  • Data access auditing for PID
  • Multi-dimensional data structures
  • Encryption strategies for data in motion
  • SAN and physical infrastructure design

From a very high level (and shown below), we will be taking data already encrypted on the source system using agreed upon encryption algorithms, decrypting ...

Get Applied Architecture Patterns on the Microsoft Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.