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

Chapter
Part of the Lecture Notes in Information Systems and Organisation book series (LNISO, volume 3)

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  

References

  1. 1.
    Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)CrossRefGoogle Scholar
  2. 2.
    Date C.J.: An introduction to database systems, vol. 1, 4th edn. Addison-Wesley, Reading, MA (1986)Google Scholar
  3. 3.
    Codd E.F.: The relational model for database management, 2nd edn. Addison Wesley Publishing Company (1990)Google Scholar
  4. 4.
    Hall J.A.: Accounting information systems, 7th edn. South-Western, USA (2011)Google Scholar
  5. 5.
    Chen P.P.: The entity-relationship model-toward a unified view of data. In: ACM Transactions on Database Systems, ACM-Press, 9–36 (1976)Google Scholar
  6. 6.
    Churcher, C.: Beginning Database Design. Apress, New York (2012)CrossRefGoogle Scholar
  7. 7.
    Fong, J.F.P.: Information systems reengineering and integration, 2nd edn. Springer Verlag, Heidelberg (2006)Google Scholar
  8. 8.
    Hall, J.A.: Accounting information systems, 2nd edn. Southwestern Publishing, Cincinnati (1998)Google Scholar
  9. 9.
    Wang, T.J., Du, H., Lee, H.L.: A user-oriented approach to data modeling: a blueprint for generating financial statements and other accounting-related documents and reports. Rev. Bus. Inf. Syst. 6(4), 17–32 (2011)Google Scholar
  10. 10.
    Badia A., Lemire D.: A call to arms: Revisiting Database Design. SIGMOD Record. September, 40, 3, 61–69 (2011)Google Scholar
  11. 11.
    Debreceny, R.S., Bowen, P.L.: The effects on end-user query performance of incorporating object-oriented abstractions in database accounting systems. J. Inf. Syst. 19(1), 43–74 (2005)Google Scholar
  12. 12.
    Cardenas, A.F., McLeod, D.: Research foundations in object-oriented and semantic database systems. Prentice Hall, Englewood Cliffs (1990)Google Scholar
  13. 13.
    Locuratolo E., Palomaki J.: Extensional and intensional aspects of conceptual design. In: Jaakkola H., Kiyoki Y., Tokura T. (eds.) Information Modelling and Knowledge Bases XIX, IOS Press, pp. 160–169 (2008)Google Scholar
  14. 14.
    Verdaasdonk P.: An object-oriented model for ex-ante accounting information. J. Inf. Syst., 17(1), 43–61 (2003)Google Scholar
  15. 15.
    Mahmud S.M., Osborn S.L.: Tradeoff analysis of relational database storage of privacy preferences. In: Jonker W., Petkovic M. (eds) Secure Data Management. Proceedings of 9th VLDB Workshop, SDM 2012, Istanbul, Turkey, 27 August 2012Google Scholar
  16. 16.
    Roman, S.: Code overload plagues NYC welfare system. MIS Week 16, 1–17 (1987)Google Scholar
  17. 17.
    Celko J.: Joe Celko’s data and databases: Concepts in practice. Morgan Kaufmann Publishers, Burlington (1999)Google Scholar
  18. 18.
    Baeza-Yates R., Ribeiro B.: Modern information retrieval. Addison-Wesley, Reading, MA (1999)Google Scholar
  19. 19.
    Tinnefeld C., Wagner B., Plattner H.: Operating on hierarchical enterprise data in an in-memory column store. DBKDA The Fourth International Conference on Advances in Databases, Knowledge, and Data Applications. pp 58–63 (2012)Google Scholar
  20. 20.
    Cacheda F., Viña A.: Superimposing Codes Representing Hierarchical Information in Web Directories. Proceedings of the 3rd international workshop on Web information and data management, ACM, NY, USA, 54–60 (2001)Google Scholar
  21. 21.
    Borthick, A.F., Bowen, P.L., Liew, S.T., Rohde, F.H.: The effects of normalization on end-user query errors: an experimental evaluation. Int. J. Acc. Inf. Syst. 2(4), 195–221 (2001)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2013

Authors and Affiliations

  • Carlo Caserio
    • 1
  • Luciano Marchi
    • 1
  • Gabriele Pulcini
    • 1
  1. 1.Department of Economics and ManagementUniversity of PisaPisaItaly

Personalised recommendations