Semi- and UnStructured Data

Preparation, Processing, Protection, and Presentation

Semi-Structured Data


Data comes in diverse forms from diverse sources, including an explosion in machine-generated data. Semi-structured data formats with flexible schemas, such as JSON and XML, are now standard formats for sending and storing data. Conventional DBs and DWs built on fixed schema, however, cannot readily store or process it. Thus it must be stored and carried around in its raw form (compromising performance), or transformed before it is loaded (losing information while adding complexity).

IRI software is designed to process semi-structured data without these trade-offs. The CoSort engine inside Voracity handles semi-structured formats natively so you can load without converting its format or imposing a new external schema. By taking this direct approach, Voracity users can leverage the "unparalleled parallel performance" of CoSort engine processing without sacrificing functionality or flexibility. That's why, in addition to big structured data, IRI software can process certain classes of static and streaming semi-structured data, for example:

  • ASN.1 call detail record (CDR) files
  • IDMS, IMS, and other legacy sources
  • MF-ISAM and Vision index files
  • MongoDB (BSON), JSON, and XML
  • Other NoSQL, Hive, and cloud / SaaS sources

Unstructured Data


You can now also search, extract, and structure data from unstructured text file sources in the IRI Workbench GUI -- and then do everything with the flat-file results in that environment. See below regarding masking the data in-situ.

Simultaneously find and organize strings based on patterns or specific values across: email repositories, .pdf, .rtf, MS Office (.doc/x, .ppt/x, .xls/x), .txt, .xml, and other files all at once. Then in the same GUI, use IRI software on the created flat files and their metadata for:

IRI software can manipulate and/or mask data those extracted values offline, and in the case of Excel, in-situ. IRI is now working to mask the values in-situ within the other unstructed sources listed above (plus image files), initially on a static basis, but eventually on a dynamic one as well.

The Bottom Line


The total trove of big data -- whether analyzed in batch or in real-time feeds -- is of great interest to business and government service providers. IRI software - and its Voracity total data management platform in particular - is the fastest, easiest, and most affordable way to blend and prepare [package, protect, and provision] structured, semi-structured, and unstructured data sources ... within your existing IT infrastructure.