Not yet registered? Create a OverBlog!

Create my blog

What are the differences between Flat files and databases?

Data storage is an intrinsic part of the internet but how is that data stored? What is a flat file? How does a flat file compare to a database? Indeed, what options are there when it comes to data storage and what are the benefits of the options. This article attempts to clear up some of the mud in the water and explain what the different types are.

Data storage types

Flat File
These are the simplest form of data storage.
The main use for a flat file is to move data between different data storage systems.
Usually, these are created by an export function on an application although they can be hand created.
The most common form of flat file is a CSV or Comma Separated Variable file. Spreadsheet
A spreadsheet is effectively a combination of a bunch of flat files and mathematical functions. It's a fairly simple form of data storage but also one that can be used fairly effectively by most people.
The in built mathematical functions make this a popular choice for many people. Database
A database is effectively a bunch of flat files set-up in a system that allows rapid searching, cross referencing and manipulation of data.
Databases can be very complex systems but also flexible.

Pros and cons

Flat File
Simple data storage.
Transportable between systems.
Can be read by a simple text editing package. Cons
Hard to search data.
No facility for cross searching of data.
No ability to apply mathematical formulae. Spreadsheet Pros
Simple data storage.
Effective where mathematical formulae are needed.
Easy to use, no real programming ability to get a lot out of a database.
Excellent ability to do statistical analysis and graphs. Cons
Poor cross tabulation.
Hard to avoid data duplication.
No real facility for search queries. Database
Very flexible and efficient way of storing data.
Excellent ability to do queries of the data.
If designed properly has minimal data duplication.
Saves a lot of time, more than offsetting any development costs. Cons
Requires expert knowledge to set-up and configure.
Can lose efficiency if it's poorly designed.
Can be expensive to maintain.
Final word
Overall databases are simply the best way to store data.
They are very efficient and flexible in the way they store data.
Flat files are only any good as a source that is then imported into a Spreadsheet or a Database.
Spreadsheets are only really useful when statistical graphics are required.
The best solution is to store all the data in a database and then do spreadsheet statistics off exports from queries on the database.

Same category articles Computers

How to stop computer crashes

How to stop computer crashes

Whether you are using your computer for Word documents and spreadsheets, or games as well as videos, nothing is more frustrating than having your PC freezing. In this guide, some simple methods will be shown to you in order to prevent this from happening. Moreover, this will also have the fringe benefits of speeding up your computer. Read on to find your route for a more stable computer.
How do I clean my computer's hard drive?

How do I clean my computer's hard drive?

Over time your computer may slow down, but it's not time to buy a new machine yet. Start by cleaning out your computer and you'll save drive space and money on a new computer. In this article, we'll make the process of a computer clean-up quick and simple!
Where to buy a laptop printer

Where to buy a laptop printer

Whilst for many people they can work on their laptop computers and wait until they get to the office, home or school to print out some valuable work. For others, this is not a viable option, especially for those who do much travelling in their line of work and a hard copy is needed there. This article shall be looking on where to buy a laptop printer.
A guide to Linksys routers

A guide to Linksys routers

Linksys is a popular brand of home routers manufactured by Cisco. A router joins two computer networks together. There are many types of routers, such as wireless routers, DSL routers, and cable routers. Once, you have your Linksys router connected, it is simple to setup and configure. Once, you have the router set up and configured, you can access the Internet on any computer in the network.