Question:
Hi, I'm starting a database project and I don't know where I can start from?
LilmizzSopie x
2013-06-04 05:06:43 UTC
I want to make a database which will can run independently on a local server.
What hardware and software would I need to be able to get this up and running as soon as possible
Any help will be much appreciated
Four answers:
Almighty Wizard
2013-06-04 06:26:42 UTC
That is not nearly enough information to answer your question.



How many users will be accessing your database?

How much information do you anticipate storing?

How will your users be accessing your database?

What OS do you want the local server to be running?



These are just a few basic questions you need to ask yourself and need to be answered.



If it's a small database with just you working on it, just follow the minimum requirements for whichever database you are going to use. Otherwise, we would need to know a lot more about what your situation is.



The same goes for what OS are you using... if you are on Windows, you can try SQL Server Express, Oracle Express, or MySQL databases. Obviously these won't all work if you are using a Linux or Unix box.
?
2013-06-04 13:52:09 UTC
You have literally _tons_ of options for database server. It really depends on your use case and budget.



We'll assume basic relational setup and not object oriented or data warehousing...



Simple and basic use: Any workstation running SQLite.



A step up: MS Access (has a GUI interface for helping the design, creating forms and reports)



Enterprise class, but still usable at lower class level: MySQL, PostgreSQL, and the like (which are free). For extensive support and class A reliability, Oracle, DB2, Microsoft SQL Server, Informix, etc. (which are far from free).



As for hardware, you never really have to worry about it for small projects.



- You do, however, need to make sure your entire DBMS and data store is backed up. This gives you snapshots of the past and also the obvious benefit of restoring if your server crashes.



- For high reliability and performance, a RAID 5 disk setup is nearly optimal for all files. Oracle takes this one step further by suggesting the OS and system files/programs sit on a RAID 1 (mirror) setup, RAID 1 or RAID 10 for log files (mirror and striping with mirror respectively), and RAID 5 or RAID 10 for the DBMS and data. Again, this is for large scale database use (like for an ERP system). For a simple database system, a plain workstation set up with no RAID or simple RAID 1 would work.



- RAM is relatively inexpensive, so there's no excuse not to beef up on it.



- Though hard drives seem inexpensive, quality and quantity should be the focus, with read/write speed, bus speed, and number of drives being more important than disk space per drive.



So, the real answer is, as in many things, with the lack of info about your use case (how many people, how many transactions, what type of transactions -- predominantly read or write?, network setup), it depends. You mentioned "as soon as possible". You can always upgrade, so starting with a basic workstation and an OS you are familiar with is the way to begin.
Sadsongs
2013-06-04 12:22:42 UTC
Your main choices fro db are probably Oracle and MySQL. Then latter is simpler to install and configure so I'd go with that. You'll need the MySQL server - that can be got for free from http://dev.mysql.com/downloads/mysql/ and is available for several platforms - so any computer will probably do.
ray_diator
2013-06-04 12:33:16 UTC
If you have MS Office installed then I guess you could use Access.


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...