wood burning stoves 2.0*
The moose likes MongoDB and the fly likes Database with dynamically created columns in C# with MongoDB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » MongoDB
Bookmark "Database with dynamically created columns in C# with MongoDB" Watch "Database with dynamically created columns in C# with MongoDB" New topic
Author

Database with dynamically created columns in C# with MongoDB

Johny Wyenski
Greenhorn

Joined: Sep 11, 2009
Posts: 21
Hello,

I am new to the world of non-relational database and I look for some advices on how to start.

I need to have table that represents system being optimized. It should have some columns with input data (some of those are common for all systems and some are specific for the system so I know all the columns I need to use not earlier than when I need to create first row in database) and output data (columns are always the same).

I need to be able to visualize the data being stored, i.e. dynamically search for rows where input parameters are known (for example first column is equal to abc and second column is between 15 and 20) to be able to receive corresponding output values (several last columns).

I thought about using MongoDB because it has the best support and is the most widely used non-relational database. Please enlight me if it is good choise or I need other NoMQL (which one?).

I have started with creating some simple code:



this is why I started wondering if it is good to use MongoDB or if I do something incorrectly. Definitely adding row as "first entity" is not OK because I would need something like ID here. And using foreach later is perhaps not needed at all, based on earlier lines of the code.

Class with data looks as follows:



Could you give me any suggestions how I should proceed with my case?

Best regards!

PS In order to avoid hidden crossposting - this post can be found at "Database with dynamically created columns in C#" in google group https://groups.google.com/forum/#!topic/mongodb-user/8Uw7YlLq0K4
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database with dynamically created columns in C# with MongoDB
 
Similar Threads
Passing array of objects......ResultSet
Jasper report - ireport but in java class - dynamic report using jasper report api
Jasper report - ireport but in java class - dynamic report using jasper report api
JDBC
Columns on JTable