NoSQL - solutions. No SQL ? Choosing a non-relational database; why we migrated from MySQL to MongoDB « Boxed Ice Blog. SQL to Mongo Mapping Chart. In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB. The following table presents the various SQL statements and the corresponding MongoDB statements. The examples in the table assume the following conditions: Create and Alter The following table presents the various SQL statements related to table-level actions and the corresponding MongoDB statements. For more information, see db.collection.insert(), db.createCollection(), db.collection.update(), $set, $unset, db.collection.ensureIndex(), indexes, db.collection.drop(), and Data Modeling Concepts.
Insert The following table presents the various SQL statements related to inserting records into tables and the corresponding MongoDB statements. For more information, see db.collection.insert(). Select The following table presents the various SQL statements related to reading records from tables and the corresponding MongoDB statements. NoSQL. The Apache Cassandra Project. Introduction to NoSQL by Martin Fowler. Apache Mahout: Scalable machine learning and data mining. Camel: CSV.
The CSV Data Format uses Apache Commons CSV to handle CSV payloads (Comma Separated Values) such as those exported/imported by Excel. Options Marshalling a Map to CSV The component allows you to marshal a Java Map (or any other message type that can be converted in a Map) into a CSV payload. An example: if you send a message with this map... ... through this route ... ... you will end up with a String containing this CSV message Sending the Map below through this route will result in a CSV message that looks like foo,bar Unmarshalling a CSV message into a Java List Unmarshalling will transform a CSV messsage into a Java List with CSV file lines (containing another List with all the field values).
An example: we have a CSV file with names of persons, their IQ and their current activity. We can now use the CSV component to unmarshal this file: The resulting message will contain a List<List<String>> like... Marshalling a List<Map> to CSV Available as of Camel 2.1 File Poller of CSV, then unmarshaling.