There are several tools that we need, to handle the issues presented.
- We must extract existing data from multiple relational systems and load it into a clean environment where we will track data access and changes.
- We must manage the definitions of key business nouns across multiple environments.
- We must track metadata concerning various documents, spreadsheets, and other objects.
- We must use unstructured and semi-structured data as a source for data mining and data analysis tasks by storing metadata concerning these objects in SQL Server.
- We must search through and index semi-structured and un-structured data across the enterprise. This will include every server, every laptop, and all of the miscellaneous storage devices.