Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I would to have a database that:

1) stores all the property addresses and names in all counties in only a single state, so efficiency is a factor.

2) allows for multiple people to access the database at the same time and make changes to it.

3) is installed on multiple computers, so price is a factor

4) has a relatively small learning curve

5) is compatible with excel, since a lot of calculations to manipulate strings (e.g. addresses) is necessary before info is imported into database, UNLESS the database has similar functions like excel to manipulate content, such as splitting addresses based on spaces or delimiters and being able to compare and match two files of content and do something if there's a match

6) has the ability to import columns from excel and translate them into fields, if the fields do not exist, and if they do, then to update the value of the fields

7) has some kind of ability to measure success of a marketing campaign

Does anyone know of a database that best suits these needs? I don't mean something like PHP with a Mysql server. I mean something like Microsoft Access vs Act! vs Goldmine vs SugarCRM vs something else. Something that you purchase and comes with some degree of support. That is, something already designed and ready to be used with little programming knowledge.

Thanks for response.

share|improve this question

migrated from superuser.com Oct 5 '10 at 7:18

This question came from our site for computer enthusiasts and power users.

1  
VTC - This isn't really a programming question. –  JohnFx Oct 3 '10 at 15:49
    
If your definition of programming pertains exclusively to a core language like PHP, Ruby, or .NET, then you are correct. However, I do believe this indirectly pertains to programming, as it would be dealing with a database, even if it's a pseudo-database like Access. –  JohnMerlino Oct 3 '10 at 16:00
    
First, Access isn't a pseudo-database. Second, it isn't a programming question it is a purchasing question. –  JohnFx Oct 3 '10 at 16:48
    
These kinds of questions are inevitably either too broad (rendering them into simple popularity polls) or too localized because they ask us to answer only for the OP's use case. This particular instance is worse than usual because conditions 7 is unrelated to the database and conditions 5 & 6 suggest that the OP has asked us to solve the intermediate problem instead of telling us what the really issue is (i.e. John has already decided on half his technology stack). Too localized. –  dmckee Oct 4 '10 at 17:19
add comment

2 Answers

I don't think you are going to be able to resolve all your issues by only using a DataBase. I would suggest PostgreSQL (free, performs very well, integrates very well with .NET, Python, Java, PHP, you name it) and deploying an application for your users with a programming language that suits your needs.

share|improve this answer
add comment

Sounds like you are likely to have a pretty small database without many users that needs to integrate with MS Office to some degree. and you don't have a advanced programming skill at the ready. Your best bet is probably MS Access.

share|improve this answer
1  
Would you recommend running Access as a front end (since this is something that needs to be done quick and it appears access is already a finished product as opposed to a php app which would need to be done from scratch) and Mysql as the backend - since the default Access database is extremely limited(think it's called ACE?) from my understanding? –  JohnMerlino Oct 3 '10 at 16:41
    
The Access Database engine (JET) is not extremely limited. It is more limited than industrial strength databases like SQL Server, Oracle, MySQL, etc., but for what he is describing it should do just fine and the backend can be ported to a larger platform if the project grows in scope later without much rework of the UI. –  JohnFx Oct 3 '10 at 16:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.