• Post Reply Bookmark Topic Watch Topic
  • New Topic

MsAccess vs. Oracle A simple Question  RSS feed

 
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: 17309
11
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!