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.
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.
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.
Simple Dashboards produced without major effort.
Reports of any type to meet the users needs.