Databases, Data, and Debates

Stephen Ramsay, in his article on databases, addresses the differences between flat and relational databases. After reflecting on his explanations, it is impossible to determine whether flat or relational databases are inherently better because, after analyzing their pros and cons, it is clear that they are useful in different situations. Flat databases, like spreadsheets, are easier to design and can do some basic calculations with small sets of data. They are especially useful in personal projects with limited information, especially as they are easily manipulated. On the other hand, relational databases can do more complex associations with huge amounts of data, although they are often more complicated to understand and develop. Because flat databases don´t work well with large sets of data and complex calculations, and relational databases don´t work well with small sets of data and are too complicated to be worthwhile pursuing just for basic understanding, it is clear that the use of either database should be determined on a case-by-case basis.

There are also some inherent issues in data collection as well. It is important to decide whether you need to keep the data secure. This is almost always important because otherwise anyone could manipulate or delete data and affect the usefulness of your database. Additionally, it is important obtain data legally and be aware of where your data is coming from and how/if you are going to add to your databases, as this would affect your ability and approach to the database.

Author: Abbey

Leave a Reply

Your email address will not be published. Required fields are marked *