What is Deep Data?

Data is not stored in a simple fashion. In fact, most organisational data is stored on platforms or systems such as SharePoint, Excel files, the Cloud, or Databases.

It is quite common in large Enterprise systems for content to be stored within a Database, and for that content within the database to refer to a file share located elsewhere. Other Enterprise systems may store content inside XML. The XML may then be stored within a database.

While it is common for data to be stored in this way, it make it more difficult to extract the information from its deep repository when needed. This is especially true when trying to obtain programmer-style code stored within these systems or translating binary-style files (such as Microsoft Word) into human-readable forms. Consider also the text of a Microsoft macro which may be stored within an Excel or Word file, but this file is in a Zip file that is stored within a database.

There is clear value in diving into such systems and extracting this internal data – but how can we extract this Deep Data from software systems such as these?

ExaOps’ advanced tools simplify complex data extraction tasks such as these.  Extracting data buried deep within a document, as in the example below, requires a combination of steps:

  • Query the database
  • Open the Zip file
  • Open the Word document within the Zip file
  • Extract the VBA code within the Word file
  • Format the VBA code
  • Save the formatted code to disk
  • OR Save the formatted VBA code directly to Git

The systems in most organisations contain business-critical information stored in such Deep Data environments.

Start discovering and downloading your Deep Data content.  Manage it via a fully managed and maintained DevOps tollsuite.

Recommended Posts