Design and Implementation of a Historical German Firm-level Financial Database

Broad, long-term financial, and economic datasets are scarce resources, particularly in the European context. In this article, we present an approach for an extensible data model that is adaptable to future changes in technologies and sources. This model may constitute a basis for digitized and stru...

Full description

Saved in:
Bibliographic Details
Published in:ACM journal of data and information quality 2022-09, Vol.14 (3), p.1-22, Article 19
Main Authors: Gram, Dennis, Karapanagiotis, Pantelis, Liebald, Marius, Walz, Uwe
Format: Article
Language:English
Subjects:
Applied computing
Database design and models
Deduplication
Digital libraries and archives
Document management and text processing
Economics
Information systems
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites cdi_FETCH-LOGICAL-a136t-f522015d2be236044dfb4da50cc455f0963a274779945044770bd8502d3738a23
container_end_page 22
container_issue 3
container_start_page 1
container_title ACM journal of data and information quality
container_volume 14
creator Gram, Dennis
Karapanagiotis, Pantelis
Liebald, Marius
Walz, Uwe
description Broad, long-term financial, and economic datasets are scarce resources, particularly in the European context. In this article, we present an approach for an extensible data model that is adaptable to future changes in technologies and sources. This model may constitute a basis for digitized and structured long-term historical datasets for different jurisdictions and periods. The data model covers the specific peculiarities of historical financial and economic data and is flexible enough to reach out for data of different types (quantitative as well as qualitative) from different historical sources, hence, achieving extensibility. Furthermore, we outline a relational implementation of this approach based on historical German firm and stock market data from 1920 to 1932.
doi_str_mv 10.1145/3531533
format article
fullrecord <record><control><sourceid>acm_cross</sourceid><recordid>TN_cdi_crossref_primary_10_1145_3531533</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>3531533</sourcerecordid><originalsourceid>FETCH-LOGICAL-a136t-f522015d2be236044dfb4da50cc455f0963a274779945044770bd8502d3738a23</originalsourceid><addsrcrecordid>eNo9kEtLxDAUhYMoOI7i3lV2rqp53aZdyozzgEE3ui63eUikTYekCP57K_NY3QPfx-FyCLnn7IlzBc8SJAcpL8iM17IseF3Ky3MGuCY3OX8zVlZC8Rl5W7ocviLFaOm233eud3HEMQyRDp4i3YQ8DikY7OjapR4jXYXUF537cd0UI0YTJrbEEVvM7pZceeyyuzveOflcvX4sNsXufb1dvOwK5LIcCw9CMA5WtE7IkillfassAjNGAXg2_YxCK63rWsGEtWatrYAJK7WsUMg5eTz0mjTknJxv9in0mH4bzpr_GZrjDJP5cDDR9GfpBP8AZ-9Vbg</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Design and Implementation of a Historical German Firm-level Financial Database</title><source>Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)</source><creator>Gram, Dennis ; Karapanagiotis, Pantelis ; Liebald, Marius ; Walz, Uwe</creator><creatorcontrib>Gram, Dennis ; Karapanagiotis, Pantelis ; Liebald, Marius ; Walz, Uwe</creatorcontrib><description>Broad, long-term financial, and economic datasets are scarce resources, particularly in the European context. In this article, we present an approach for an extensible data model that is adaptable to future changes in technologies and sources. This model may constitute a basis for digitized and structured long-term historical datasets for different jurisdictions and periods. The data model covers the specific peculiarities of historical financial and economic data and is flexible enough to reach out for data of different types (quantitative as well as qualitative) from different historical sources, hence, achieving extensibility. Furthermore, we outline a relational implementation of this approach based on historical German firm and stock market data from 1920 to 1932.</description><identifier>ISSN: 1936-1955</identifier><identifier>EISSN: 1936-1963</identifier><identifier>DOI: 10.1145/3531533</identifier><language>eng</language><publisher>New York, NY: ACM</publisher><subject>Applied computing ; Database design and models ; Deduplication ; Digital libraries and archives ; Document management and text processing ; Economics ; Information systems</subject><ispartof>ACM journal of data and information quality, 2022-09, Vol.14 (3), p.1-22, Article 19</ispartof><rights>Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><cites>FETCH-LOGICAL-a136t-f522015d2be236044dfb4da50cc455f0963a274779945044770bd8502d3738a23</cites><orcidid>0000-0002-6620-5442 ; 0000-0001-9871-1908 ; 0000-0003-4287-3486 ; 0000-0003-4636-1154</orcidid></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><link.rule.ids>314,780,784,27924,27925</link.rule.ids></links><search><creatorcontrib>Gram, Dennis</creatorcontrib><creatorcontrib>Karapanagiotis, Pantelis</creatorcontrib><creatorcontrib>Liebald, Marius</creatorcontrib><creatorcontrib>Walz, Uwe</creatorcontrib><title>Design and Implementation of a Historical German Firm-level Financial Database</title><title>ACM journal of data and information quality</title><addtitle>ACM JDIQ</addtitle><description>Broad, long-term financial, and economic datasets are scarce resources, particularly in the European context. In this article, we present an approach for an extensible data model that is adaptable to future changes in technologies and sources. This model may constitute a basis for digitized and structured long-term historical datasets for different jurisdictions and periods. The data model covers the specific peculiarities of historical financial and economic data and is flexible enough to reach out for data of different types (quantitative as well as qualitative) from different historical sources, hence, achieving extensibility. Furthermore, we outline a relational implementation of this approach based on historical German firm and stock market data from 1920 to 1932.</description><subject>Applied computing</subject><subject>Database design and models</subject><subject>Deduplication</subject><subject>Digital libraries and archives</subject><subject>Document management and text processing</subject><subject>Economics</subject><subject>Information systems</subject><issn>1936-1955</issn><issn>1936-1963</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2022</creationdate><recordtype>article</recordtype><recordid>eNo9kEtLxDAUhYMoOI7i3lV2rqp53aZdyozzgEE3ui63eUikTYekCP57K_NY3QPfx-FyCLnn7IlzBc8SJAcpL8iM17IseF3Ky3MGuCY3OX8zVlZC8Rl5W7ocviLFaOm233eud3HEMQyRDp4i3YQ8DikY7OjapR4jXYXUF537cd0UI0YTJrbEEVvM7pZceeyyuzveOflcvX4sNsXufb1dvOwK5LIcCw9CMA5WtE7IkillfassAjNGAXg2_YxCK63rWsGEtWatrYAJK7WsUMg5eTz0mjTknJxv9in0mH4bzpr_GZrjDJP5cDDR9GfpBP8AZ-9Vbg</recordid><startdate>20220930</startdate><enddate>20220930</enddate><creator>Gram, Dennis</creator><creator>Karapanagiotis, Pantelis</creator><creator>Liebald, Marius</creator><creator>Walz, Uwe</creator><general>ACM</general><scope>AAYXX</scope><scope>CITATION</scope><orcidid>https://orcid.org/0000-0002-6620-5442</orcidid><orcidid>https://orcid.org/0000-0001-9871-1908</orcidid><orcidid>https://orcid.org/0000-0003-4287-3486</orcidid><orcidid>https://orcid.org/0000-0003-4636-1154</orcidid></search><sort><creationdate>20220930</creationdate><title>Design and Implementation of a Historical German Firm-level Financial Database</title><author>Gram, Dennis ; Karapanagiotis, Pantelis ; Liebald, Marius ; Walz, Uwe</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-a136t-f522015d2be236044dfb4da50cc455f0963a274779945044770bd8502d3738a23</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2022</creationdate><topic>Applied computing</topic><topic>Database design and models</topic><topic>Deduplication</topic><topic>Digital libraries and archives</topic><topic>Document management and text processing</topic><topic>Economics</topic><topic>Information systems</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Gram, Dennis</creatorcontrib><creatorcontrib>Karapanagiotis, Pantelis</creatorcontrib><creatorcontrib>Liebald, Marius</creatorcontrib><creatorcontrib>Walz, Uwe</creatorcontrib><collection>CrossRef</collection><jtitle>ACM journal of data and information quality</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Gram, Dennis</au><au>Karapanagiotis, Pantelis</au><au>Liebald, Marius</au><au>Walz, Uwe</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Design and Implementation of a Historical German Firm-level Financial Database</atitle><jtitle>ACM journal of data and information quality</jtitle><stitle>ACM JDIQ</stitle><date>2022-09-30</date><risdate>2022</risdate><volume>14</volume><issue>3</issue><spage>1</spage><epage>22</epage><pages>1-22</pages><artnum>19</artnum><issn>1936-1955</issn><eissn>1936-1963</eissn><abstract>Broad, long-term financial, and economic datasets are scarce resources, particularly in the European context. In this article, we present an approach for an extensible data model that is adaptable to future changes in technologies and sources. This model may constitute a basis for digitized and structured long-term historical datasets for different jurisdictions and periods. The data model covers the specific peculiarities of historical financial and economic data and is flexible enough to reach out for data of different types (quantitative as well as qualitative) from different historical sources, hence, achieving extensibility. Furthermore, we outline a relational implementation of this approach based on historical German firm and stock market data from 1920 to 1932.</abstract><cop>New York, NY</cop><pub>ACM</pub><doi>10.1145/3531533</doi><tpages>22</tpages><orcidid>https://orcid.org/0000-0002-6620-5442</orcidid><orcidid>https://orcid.org/0000-0001-9871-1908</orcidid><orcidid>https://orcid.org/0000-0003-4287-3486</orcidid><orcidid>https://orcid.org/0000-0003-4636-1154</orcidid></addata></record>
fulltext fulltext
identifier ISSN: 1936-1955
ispartof ACM journal of data and information quality, 2022-09, Vol.14 (3), p.1-22, Article 19
issn 1936-1955
1936-1963
language eng
recordid cdi_crossref_primary_10_1145_3531533
source Association for Computing Machinery:Jisc Collections:ACM OPEN Journals 2023-2025 (reading list)
subjects Applied computing
Database design and models
Deduplication
Digital libraries and archives
Document management and text processing
Economics
Information systems
title Design and Implementation of a Historical German Firm-level Financial Database
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-02T20%3A25%3A00IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-acm_cross&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Design%20and%20Implementation%20of%20a%20Historical%20German%20Firm-level%20Financial%20Database&rft.jtitle=ACM%20journal%20of%20data%20and%20information%20quality&rft.au=Gram,%20Dennis&rft.date=2022-09-30&rft.volume=14&rft.issue=3&rft.spage=1&rft.epage=22&rft.pages=1-22&rft.artnum=19&rft.issn=1936-1955&rft.eissn=1936-1963&rft_id=info:doi/10.1145/3531533&rft_dat=%3Cacm_cross%3E3531533%3C/acm_cross%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-a136t-f522015d2be236044dfb4da50cc455f0963a274779945044770bd8502d3738a23%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true