Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need suggestions in choosing a correct database

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2011
Member
 
Join Date: May 2011
Posts: 30
Need suggestions in choosing a correct database
  

I have just opened my software company and I advertised a lot in order to obtain software projects from various clients. Thus nowadays I got one project, it is nice project, I am capable of doing it, but I need some suggestions in using a particular database for this project. The database should be capable of storing more number of records in it, as it would be accessed very frequently. So provide me some suggestions so that I could choose the database for my project.

Reply With Quote
  #2  
Old 09-06-2011
Member
 
Join Date: May 2009
Posts: 532
Re: Need suggestions in choosing a correct database

I would surely help you in this case. Basically there are two types of databases that you might know, the desktop database and server database. As you told that you want your database to be online for twenty four hours as well it is going to be accessed very frequently. So thus if you expect multiple users to access your database then you should definitely go for server database because this type of database have a capability to maintain the consistency and integrity of data.
Reply With Quote
  #3  
Old 09-06-2011
Member
 
Join Date: May 2009
Posts: 503
Re: Need suggestions in choosing a correct database

In this current market there are number of database vendors which provide the database for each individual company. But if I have to suggest you a particular database vendor then I would recommend you to go for MySQL. I found this open source database excellent and also it optimizes any of SQL queries easily. So if you go for this then you can configure the settings as necessary or required by you. Thus have a look on this database features from its official site.
Reply With Quote
  #4  
Old 09-06-2011
Member
 
Join Date: May 2011
Posts: 30
Re: Need suggestions in choosing a correct database

Well thanks for providing me solutions; I would provide you more details about my query. I am having a project and in this I want a database which would process more records, around 1 million records the database should be able to store and I guess this is approximate figure calculated for a weekly basis. I do understand that I would require the multi user server database as simultaneously it would be accessed by several users at same time.
Reply With Quote
  #5  
Old 09-06-2011
Member
 
Join Date: May 2009
Posts: 533
Re: Need suggestions in choosing a correct database

I guess it is very important project that you got as it requires you to store million of records a week. So basically you should go for better database as if you go for a regular database then there might be a chance you may lose all your data, may be due to incapability, inefficiency. So better is that you don?t go for MySQL and instead of this choose Microsoft SQL Server as it provides all the features that you require and even it is most appropriate one for backup system.
Reply With Quote
  #6  
Old 09-06-2011
Member
 
Join Date: Apr 2009
Posts: 567
Re: Need suggestions in choosing a correct database

Yes I do agree with the above post that as you are expecting millions of record transaction approximately for week duration then you should go for standard database. The above recommended SQL server is also a good choice or you can opt for Oracle. There is not a much difference between these databases, it is just that with whichever you are compatible with or you are used to it you should select the same and you can then start with your project.
Reply With Quote
  #7  
Old 11-06-2011
Member
 
Join Date: May 2009
Posts: 525
Re: Need suggestions in choosing a correct database

If I had the option then I would go with Microsoft SQL server as it provides easy interface and it also offers multithreaded process and this is the thing which you also require. So once you login with Server Management Studio then you can setup maintenance plans, backups, replication, integrations etc. as needed for your project. I would say that it also fits in a regular budget. This database is suitable for large project the same which you have got.
Reply With Quote
  #8  
Old 29-03-2012
Member
 
Join Date: Mar 2012
Posts: 1
Re: Need suggestions in choosing a correct database

What kind of API do you need? SQL Server, SQLite and Oracle are all major players, though can get a bit expensive if you do not need a full enterprise database. There are some other companies that provide database solutions that are very scalable:
- Raima
- MongoDB
- CouchDB
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need suggestions in choosing a correct database"
Thread Thread Starter Forum Replies Last Post
What is the correct way to organize SL App and SQL Database Vincent D Windows Software 5 28-04-2011 10:27 AM
Creating Database link in database Lachlann Software Development 3 28-01-2010 01:17 PM
Choosing a new CPU, help Billie Motherboard Processor & RAM 3 07-08-2008 02:14 PM
convert filemaker pro database to access database Czack MS Office Support 3 15-04-2007 01:06 AM


All times are GMT +5.5. The time now is 10:27 PM.