The Data Management Conundrum: Spreadsheet or Database? Part 3
By Ian MacOlive. In our previous articles, we compared spreadsheets to databases. We recommended upsizing to a customised database solution when your spreadsheet reaches its limit of effectiveness. Since databases require a degree of skill and knowledge, we further recommended making use of a consultant programmer. In this article, we look at how you can […]
The Data Management Conundrum: Spreadsheet or Database? Part 2
By Ian MacOlive. In our previous article, we looked at the spreadsheet in some detail and considered the limitations that they can present when a project gets too large. The upsizing of a spreadsheet to a database is the next logical step. Since a database management system, or DBMS, contains the data in a series […]
The Data Management Conundrum: Spreadsheet or Database? Part 1
Written by Ian MacOlive. The spreadsheet is a powerful tool for performing complex calculations and data storage for small projects. When VisiCalc hit the scene back in the eighties (in the last century), the relatively small group of Apple II users went crazy. It was like manna from heaven for the poor accountants, scientists and […]