dbms

What kind of decomposition it is ?

I have Table with columns | paper_id | reviewer_no | author_id| . candidate keys are 1.{ paper_id,reviewer_no}. 2. { author_id,reviewer_no}. And my primary key is { paper_id,reviewer_no}. I decomposed it into ---- table1 ----- |paper_id|reviewer_no| where {paper_id,reviewer_no} is pr...

Help in getting a database management system running.

http://projectabstracts.com/406/java-based-online-shopping.html This project is about "Online Shopping". It uses Java as front-end implementing applets, servlets and JDBC as the connecting link to the back-end which is implemented using SQL. The problem is that I'm a newbie in all this stuff and I don't understand how to get this projec...

Why aren't object oriented database management systems more popular?

I mean, with EJB, LINQ2SQL, EF etc we're trying to (at least in my perspective) map the rdb in a way so we can use the entities as objects. How come there hasn't been a surge of OODBMS since they should remove many barriers we face today, or at least lessen the burden? I'm probably overlooking something but the main reason I can see as...

Are there any NoSQL DBMS's that can work with Visual Basic 6/.net? If there are then how do I make it happen?

I've tried working with OrientDB but it seems inserting to the database is not supported by the REST interface. Looking at Cassandra and MongoDB, they seem to be alright but I haven't seen any references to VB in their site. ...

Which database would best suit the following needs?

I am trying to work out the best database(s) considering the following requirements: The bulk of the data is "document" style, with specific common fields that will be indexed. There needs to be joining across these indexed fields. However, the data in the indexes is heavily hierarchical, i.e., graph. A specific example is the hierarch...

What is the best Relational Database Management System (DBMS) to use with a web app?

It seems like most people use MySQL together with PHP. I've used H2 and Postgres with Java, but I can't really say why, I didn't evaluate any before I started. Does some work best with a specific language? Are there more stable ones that are better at large capacities? ...