• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MsAccess vs. Oracle A simple Question

 
Vikas Aggarwal
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have this question: Which one would be best suitable for a simple web application considering following:
1. There is only one table in the database.
2. The table can have max of 100 rows and 4 columns.
3. The server is Win NT with all required drivers.
4. No RDBMS is required as there is only one table.
Thanks.
 
Bosun Bello
Ranch Hand
Posts: 1511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If cost of product is not an issue and reliability is important, I will go with oracle.
 
Mika Goeckel
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!
Sounds like you're looking for a small and easy solution rather than a full featured relational database.
As a java addict I would suggest hsqldb (http://hsqldb.sourceforge.net/).
Another (but grown up database) is mysql (http://www.mysql.org).
Oracle would be breaking a butterfly on a wheel.
If your table is static (means no updates during runtime) you could think of using a xml file and something like digester (http://jakarta.apache.org/commons/digester.html) to read it in.
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Heck, if it was static you could put it into a Java class, XML, or even hard coded.
Even cloudscape, which comes with J2EE, would work for such a small table. But Oracle would definitely be overkill.
MySql is overkill, in the fact of its power for such a simple data related issue, but it is also free. And if you know Databases and how to set them up, make grants, etc, then MySQL is good.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic