WHY YOU SHOULD USE A RELATIONAL DATABASE INSTEAD OF A SPREADSHEET

$61.74 plus tax (Refund Policy)

Buy Article:

Abstract:

Spreadsheets have become powerful tools and are used widely nowadays. Relational databases seem to disappear into information systems either just for presenting data or forming the basis of complex systems integrating, for example, business rules. It will be shown that—following their rules—relational databases are able to support research in a very flexible manner. The structure of the underlying data may be very simple (just one table) or more complex (consisting of several related tables often according to normalization rules). In each case, the nonprocedural query to the database can give insights from different perspectives assuming that the underlying data are consistent and the often nontrivial query is formulated correctly. Examples will be given in the context of the evaluation of material flows, demonstrating the importance of data consistency, the advantages of the relational data model (and its limitations), and the power that is given by a modern, flexible interface which frees the scientist from explicitly formulating complex queries which are then prone to error. Finally it will be discussed why the spreadsheet is nevertheless used so often when a database is more appropriate.

Document Type: Research Article

DOI: http://dx.doi.org/10.1080/01969720490499461

Affiliations: Research Centre Jülich, Systems Analysis and Technology Evaluation, Jülich, Germany

Publication date: October 1, 2004

More about this publication?
Related content

Share Content

Access Key

Free Content
Free content
New Content
New content
Open Access Content
Open access content
Subscribed Content
Subscribed content
Free Trial Content
Free trial content
Cookie Policy
X
Cookie Policy
ingentaconnect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more