Hi folks. I'm looking for a bit of help and guidance on what you think would be the most suitable DB for a project I'm working on. This isn't a web-based project but as I couldn't find a more suitable sub-forum to post this query, I thought I would ask on here.
My DB will initially hold approximately 300 columns and 3 million rows but this will grow to tens if not hundreds of millions as time passes. Each row will contain information relating to a specific file - author, date created etc... Now the main purpose of this DB is to identify commonalities between entries - a query for example to see if any records contain a created date of between 01/01/2011 - 05/01/2011 AND the same author? Similarly, would it be better to spread my data across multiple tables or just one? The sources for my data will be from various sources but the information will all fall under the same headings (columns) and I'd want to compare the data across all info from the various sources.
Many thanks and enjoy your weekend