Hierarchical and Relational Database Accounting Systems: Critical Aspects and Trade-Offs

Carlo Caserio (), Luciano Marchi () and Gabriele Pulcini ()
Additional contact information
Carlo Caserio: University of Pisa
Luciano Marchi: University of Pisa
Gabriele Pulcini: University of Pisa

A chapter in Accounting Information Systems for Decision Making, 2013, pp 221-231 from Springer

Abstract: Abstract Although the transition from hierarchical to relational databases marked a crucial turning point in the development of accounting systems, the concept of hierarchy has not entirely been abandoned. The aim of this research is to highlight the critical aspects and trade-offs between the hierarchical and relational structures of a database accounting system (DAS). First, we address the relationships between database accounting structure and accounting data coding: hierarchical coding, as distinct from sequential encoding schemes, may have different implications on the selectivity/accuracy/efficiency of the DAS. Next, we investigate the impact that both structure and data encoding schemes have on select queries and update queries: hierarchical models allow for higher efficiency in performing select queries, but higher rigidity in executing update queries; conversely, relational models allow for higher flexibility of update queries, but higher complexity in performing select queries. Finally, we offer suggestions for managing the trade-offs between both types of DAS.

Keywords: Hierarchical; Relational; Database accounting systems; Selectivity; Flexibility (search for similar items in EconPapers)
Date: 2013
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:lnichp:978-3-642-35761-9_13

Ordering information: This item can be ordered from
http://www.springer.com/9783642357619

DOI: 10.1007/978-3-642-35761-9_13

Access Statistics for this chapter

More chapters in Lecture Notes in Information Systems and Organization from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().