University of Colorado at Boulder: Information Systems

Relational & NoSQL Databases, the Semantic Web, and Multimedia

University of Colorado at Boulder: Information Systems - Relational & NoSQL Databases, the Semantic Web, and Multimedia

Final project

As was discussed in class this past Monday, I would like the following from you:

1. A demo on the day of the final exam.

2. A BRIEF statement that addresses:

a) What kind of data is in each database (relational and noSQL) – and importantly, why that particular db was best for the data you placed in it.  Why would you not put your noSQL data in PostgreSQL or a different noSQL db?  Why is your relational data placed in PostgreSQL and not in some noSQL db?  Please think about not just the potential size of data sets (assuming that your application was used in a production environment), but also about the nature of the data itself, in particular, it’s structure.

c) Obviously, the two sorts of data that you used, relational and noSQL, are related to each other, since they are manipulated in a single app.  How did you manage their relationship?  In other words, where is the knowledge that represents their common or shared semantic meaning?  Is that information in one of the dbs?  Is it in part in both dbs?  Is it only in your code?  This last approach is a very poor design decision.

Issue c) does not refer to the meaning of the data in the individual dbs by themselves, or about the nature of  your overall app, but rather to the semantic relationship between the data in the two dbs.  For example, in a traditional relational db, we interrelate data by using PK/FK pairs across tables, and the db designer is strongly encouraged to put as much of the permanent meaning of the data in the tables, and not in the application code and SQL code that uses them.  But if we use two very different databases, we have to address this issue in some other way.  

Also, some people have been given permission to use two noSQL dbs and not a relational one.  You should adjust your answers accordingly.

This statement should only need to be a couple of double spaced pages long.

Thanks

Buzz

 

Category: Uncategorized