Book a Demo

Efficient XBRL Data Storage

Leverage cost-effective, innovative XBRL storage models for your organization.

Enable any XBRL document to be stored in a database, without changing the underlying data model, while benefiting from a performant platform for cross-document queries and BI tools. With the XT Database, a key component of the XBRL Toolkit, you can use standard SQL-based tools to build dashboards and custom analyses.

The XT Database can also act as a robust platform that enables XBRL data to be readily extracted into a format compatible with independent data warehouse or custom reporting systems. Enrich the XT Database model and metadata with application-specific data — such as DPM codes, Table Linkbase definitions and more — to better maintain your extraction routines and other ETL processes.

The first, what we term the ‘XBRL Database Adapter (XDA)’ approach, involves developing a special database schema that can represent the complexity of any XBRL taxonomy, but also stores each XBRL fact as a simple row in a relational database.

The second approach is to store XBRL documents in their native form, i.e. an XML file or increasingly JSON format and use the schema provided by the XBRL taxonomy to index and query the data.

Both approaches have advantages and disadvantages and UBPartner has worked on both to understand how and when they should be deployed.

Native XBRL Database Solutions

Today, data vendors offer two main approaches to storing XBRL data.

XML Databases

Adopted for the Oracle Database XBRL Extension, this approach allows for the rapid loading of XBRL documents. To enable query performance over a range of documents, the database vendor needs to provide a mechanism to generate indexed relational views from the XBRL Taxonomy.

Big Data (noSQL)

The growing availability of noSQL databases that can handle a wide range of data types provides another potential platform for the effective analysis of XBRL data. The Big Data approach offers simple load mechanisms, document management, semantic search and, ultimately, a platform for greater use and applicability of XBRL data.

Need help deciding which approach is right for you?

Our consultants can find or tailor a solution for your unique XBRL data storage requirements.
Contact us or Request a Demo or learn more about our XT Database

Simple Dashboards produced without major effort.

Reports of any type to meet the users needs.