Building the solution

We will need to deal with both structured data stored in relational databases and unstructured data stored in file systems of various sorts (for example, marketing documents, engineering design drawings). We will manage conflicts between the relational systems using master Data Services, ETL using SSIS, and file system indexing using Search Server and SSIS.

The Electronic Discovery Reference Model (http://edrm.net/) refers to six phases of handling data:

  1. Information management
  2. Identification
  3. Preservation and Collection
  4. Processing, Review, and Analysis
  5. Production
  6. Presentation
    Building the solution

Our tasks focus on steps 1 through 3 while providing a ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.