XBRL Database: Difference between revisions
No edit summary |
No edit summary |
||
| Line 31: | Line 31: | ||
* The Excel functions that access information in XBRL reports using filters. | * The Excel functions that access information in XBRL reports using filters. | ||
* Any other application trying to load information from SQL to another BI (Business Intelligence) system. | * Any other application trying to load information from SQL to another BI (Business Intelligence) system. | ||
==Standard entity model== | |||
The standard entity model is documented [[http://www.reportingstandard.com/pojo/documentation/entities/index.html here]]. | |||
==User data model== | ==User data model== | ||
Revision as of 20:09, 9 November 2014
Product page
Description
The XBRL Database is a permament repository system implemented using relational databases and the most advanced technologies in order to allow the storage of document level information like XBRL reports, XBRL Taxonomies and XBRL Linkbases along with granular level information as XBRL Fact items, XBRL concept definitions, XBRL Labels, XBRL Resources, XBRL Relationships.
- The storage system allows the storage of everything that is valid XBRL 2.1
- The storage repository accepts information for any existing or new XBRL 2.1 taxonomy
- The storage system allows users to develop complex cross instance document and cross taxonomy information systems
There is a live demo of the XBRL Database that store all the information published by the SEC here [ExploreXBRL direct link].
For more information about the XBRL Database please contact reporting standard directly by sending an email to info at reportingstandard.com
Starting with version 2.6.12 of Reporting Standard S.L. tools, the XBRL Database functionality has been incorporated into XBRLizer and XBRLViewer. Also, a new software component has been created in order to access to information stored in the XBRL Database from Excel formulas.
Now, the XBRL Database can receive XBRL reports from:
- The XBRL Validation component (server mode) after XBRL 2.1 validation is finished with no errors.
- The XBRL Grab daemon that periodically search for new reports published (We currently support the SEC RSS feed)
- XBRLizer and XBRLViewer, using the File -> XBRL Database -> Store document into the XBRL Database.
- All the components above relays on a API component in the library for storing a DTS into the XBRL Database. That API is available from other applications to use.
The XBRL Database can be used from:
- XBRLizer, XBRLviewer and any other API component the File -> Open component has a button to open data from the XBRL Database. The XBRL Database can be used as a proxy for official documents based on the absolute document URI.
- The Excel functions that access information in XBRL reports using filters.
- Any other application trying to load information from SQL to another BI (Business Intelligence) system.
Standard entity model
The standard entity model is documented [here].
User data model
The XBRL Database API provides a mechanism to extend the XBRL data model. This allows developers using Reporting Standard XBRL API to create their own data model and tables on top of the XBRL data model and use them as any other tables in the model.
There is more information in the How to add classes to the XBRL Database model wiki page.
