XBRL databases have evolved through a decade of changing technologies to a period of relative stability. Whether viewed from a U.S. perspective for SEC filings, or an EU perspective for securitization, most production usage is SQL, with some adoption of NoSQL and hybrid technologies. Where complete filing databases exist, such as for SEC filings, the challenge is how data tagged differently by filers is presented and consumed by projections normalizing views for consumption. Additional technologies impacting database architectures include inline XBRL and disengagement of XBRL from XML. Some projects maintain dual models in the database, an abstract model structure of the data and a classical table structure of forms. Design varies from DPM and table linkbase to financial report structures optimized for business purposes. Hear Herm Fischer, Mark V Solutions, provide a high level diagrammatic view of these approaches.
Leave a Reply