XBRL Processor

Uma Ferramenta Para Geração De Instâncias XBRL

Autores/as

  • Henderson Acosta Bragança Câmara Municipal de Porto Velho

Palabras clave:

XBRL, Mapeamento de dados, Integração de dados, Integração XBRL, XBRL Processor

Resumen

El uso de la tecnología eXtensible Business Reporting Language (XBRL) en el contexto de la información financiera en Internet es evidente, ya sea por sus ventajas y beneficios o por imposiciones gubernamentales. Sin embargo, los datos que este lenguaje debe transportar se almacenan, en su mayor parte, en estructuras definidas, como bases de datos relacionales, archivos JSON o archivos CSV. Por tanto, es fundamental que las organizaciones integren la tecnología XBRL con otras tecnologías de almacenamiento de datos. Este artículo presenta una solución de Extracción, Transformación y Carga (ETL), orientada a extraer datos de fuentes de diferentes formatos de almacenamiento y generar instancias XBRL, denominada Procesador XBRL. Esta herramienta incluye diferentes tipos de fuentes de datos y genera la instancia XBRL. Además, se implementaron parámetros para cumplir con la entrega de la Matriz de Balances Contables para el Sistema de Información Contable y Financiera de la Secretaría del Tesoro Nacional de Brasil (SICONFI) y se realizó un estudio de caso para validar la herramienta Procesador XBRL.

Citas

AKRAM, S.; AQEEL, M.; HAMID, K. Enhancing Software Quality Through Usability Experience and Hci Enhancing Software Quality Through Usability Experience and Hci Design Principles. , , n. February, p. 45–75, 2023.

ASIMADI, E.; REIFF-MARGANIEC, S.; DONNELLY, B.; BAKER, J.; FANG, D. Semantic approach to financial data integration for enabling new insights. CEUR Workshop Proceedings, v. 1890, p. 1–15, 2017.

BEELITZ, C. The dilemma of XBRL-XML versus XBRL-JSON regarding linkage of financial information. CEUR Workshop Proceedings, v. 1890, p. 1–11, 2017.

BIN, Y. U.; XU, L. U.; CONG, T.; ZHEN-HUA, D.; NAN, Z. Parallel Runtime Verification for Calling Sequences of SQLite3 Database APIs. Journal of Software, v. 33, n. 8, p. 2755–2768, 2022. Disponível em: . .

BOGNER, J.; MERKEL, M. To Type or Not to Type? A Systematic Comparison of the Software Quality of JavaScript and Typescript Applications on GitHub. Proceedings of the 19th International Conference on Mining Software Repositories. Anais... , MSR ’22. p.658–669, 2022. New York, NY, USA: Association for Computing Machinery. Disponível em: <https://doi.org/10.1145/3524842.3528454>. .

BRAGANCA, H. A.; CAETANO, P.; BERNADINO, N. Data Mapping for XBRL : A Systematic Literature Review. American Academic Scientific Research Journal for Engineering, Technology, and Sciences, v. 90, p. 124–143, 2022. Disponível em: <http://asrjetsjournal.org/>. .

BRAGANÇA, H. A.; LADISLAU, S. P.; DA SILVA, M. A. P.; DA SILVA, P. C. XBRL-ETL Engine: A Data Transformation Tool For XBRL-Siconfi Taxonomy Motor XBRL-ETL: Uma ferramenta para transformação de dados baseada na taxonomia XBRL-SICONFI. , , n. 1, p. 1–19, 2019.

CERQUEIRA, M. G. DE; SILVA, P. C. DA. A survey of XBRL adoption impact on financial software development processes and software quality. International Journal of Business Information Systems, v. 37, n. 2, p. 263–286, 2021.

CERQUEIRA, M. G.; SILVA, P. C. DA. Coming Impacts of Xbrl Adoption in Financial Software Development Processes and Software Quality Factors: a Systematic Mapping. Proceedings of the 13th CONTECSI International Conference on Information Systems and Technology Management, v. 13, p. 3185–3209, 2016.

CHRISTUDAS, B. MySQL. Practical Microservices Architectural Patterns: Event-Based Java Microservices with Spring Boot and Spring Cloud. p.877–884, 2019. Berkeley, CA: Apress. Disponível em: <https://doi.org/10.1007/978-1-4842-4501-9_27>. .

DIMOU, A.; SANDE, M. VANDER; COLPAERT, P.; et al. RML: A generic language for integrated RDF mappings of heterogeneous data. CEUR Workshop Proceedings, v. 1184, 2014.

DUNCE, M. M. M.; SILVA, P. C. DA; VIANA, S. Similarity Evaluation Between Concepts Represented By Xbrl. , p. 3933–3963, 2013.

GRAY, G. L.; MILLER, D. W. XBRL: Solving real-world problems. International Journal of Disclosure and Governance, v. 6, n. 3, p. 207–223, 2009.

GYŐRÖDI, C. A.; DUMŞE-BURESCU, D. V.; ZMARANDA, D. R.; GYŐRÖDI, R. A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management. Big Data and Cognitive Computing, v. 6, n. 2, 2022.

JAYASHREE, G.; PRIYA, C. Data Integration with XML ETL Processing. 2020 International Conference on Computer Science, Engineering and Applications, ICCSEA 2020, , n. March, 2020.

LAZZARI, L.; FARIAS, K. An exploratory study on the effects of pair programming. Association for Computing Machinery, 2022.

NAVATHE, ELMASRI. &. Sistemas de Banco de Dados. 2013.

SILVA, P. C.; SILVA, L.; SANTOS, A.; CRUZ, M. O Framework Xbrl. International Conference on Information Systems and Technology Management 5th, p. 4343–4365, 2008.

SOARES, B. E.; BOSCARIOLI, C. Modelo de Banco de Dados Colunar: Características, Aplicações e Exemplos de Sistemas. Escola Regional de Banco de Dados–Sociedade Brasileira de Computação (IX ERBD–SBC), 2013.

SOMMERVILLE, I. Software engineering. Pearson, 2011.

STN, S. DO T. N. Matriz de Saldos Contábeis. Secretaria Do Tesouro Nacional, v. 1, 2017. Disponível em: <https://siconfi.tesouro.gov.br/siconfi/pages/public/arquivo/conteudo/Cartilha_Matriz_de_Saldos_Contabeis.pdf>. .

ZHU, H.; YU, H.; FAN, G.; SUN, H. Mini-XML: An efficient mapping approach between XML and relational database. Proceedings - 16th IEEE/ACIS International Conference on Computer and Information Science, ICIS 2017. Anais... . p.839–843, 2017.

Publicado

18-09-2024

Cómo citar

Acosta Bragança, H. (2024). XBRL Processor: Uma Ferramenta Para Geração De Instâncias XBRL. CUADERNO DE FINANZAS PÚBLICAS, 24(03). Recuperado a partir de https://publicacoes.tesouro.gov.br/index.php/cadernos/article/view/240