Apparatus and method for transforming XBRL data into database schema
A computer readable medium includes executable instructions to extract XBRL data from a web service feed data source and construct an optimized database schema and tables, based on maintaining the integrity of the XBRL metadata. The XBRL data can then be loaded into the database, and refreshed, such that the XBRL data is assessed and the database schema and tables are updated as required.
1 . A computer readable medium comprising executable instructions to:
receive eXtensible Business Reporting Language (XBRL) data and associated metadata;
map said XBRL data and associated metadata into a database schema; and
load said XBRL data and associated metadata into said database schema.
2 . The computer readable medium of claim 1 wherein said executable instructions to map include executable instructions to map said XBRL data and associated metadata into a relational database schema.
3 . The computer readable medium of claim 2 wherein said executable instructions to map include executable instructions to map said XBRL data and associated metadata to relational database dimension and fact tables.
4 . The computer readable medium of claim 3 wherein said executable instructions to map include executable instructions to map said XBRL data and associated metadata to relational database dimension and fact tables with joins and contexts.
5 . The computer readable medium of claim 1 wherein said executable instructions to map include executable instructions to validate whether a database exists with required schema, and if not, construct required schema corresponding to said XBRL data and associated metadata.
6 . The computer readable medium of claim 5 further comprising executable instructions to supply recommended schema to a user.
7 . The computer readable medium of claim 6 further comprising executable instructions to allow alterations to recommended schema.
8 . The computer readable medium of claim 1 wherein said executable instructions to receive include executable instructions to receive from a commercial XBRL data source.
9 . A computer readable medium comprising executable instructions to:
receive data with a discoverable taxonomy and linkbase; and
map said data into a database schema; and
load said data into said database schema.
10 . The computer readable medium of claim 9 wherein said executable instructions to map include executable instructions to map said discoverable taxonomy into a relational database schema.
11 . The computer readable medium of claim 10 wherein said executable instructions to map include executable instructions to map said discoverable taxonomy into relational database dimension and fact tables.
12 . The computer readable medium of claim 11 wherein said executable instructions to map include executable instructions to map said discoverable taxonomy to relational database dimension and fact tables with joins and contexts.
13 . The computer readable medium of claim 9 wherein said executable instructions to map include executable instructions to validate whether a database exists with required schema, and if not, construct required schema corresponding to said discoverable taxonomy.
14 . The computer readable medium of claim 13 further comprising executable instructions to supply recommended schema to a user.
15 . The computer readable medium of claim 14 further comprising executable instructions to allow alterations to recommended schema.
16 . The computer readable medium of claim 9 wherein said executable instructions to receive include executable instructions to receive from a commercial XBRL data source.
17 . The computer readable medium of claim 9 further comprising executable instructions to query said database schema.
18 . The computer readable medium of claim 17 wherein said executable instructions to query include executable instructions to query said database using a reporting tool.
19 . The computer readable medium of claim 17 wherein said executable instructions to query said database include executable instructions to automatically query said database.
20 . The computer readable medium of claim 19 wherein said executable instructions to query said database include executable instructions to automatically query said database in accordance with a specified schedule.