Modelling data for a web application
I'm a HPCC beginner.
I sprayed multiple csv files using ECL and DFU and also have fetched the data using ECL record structure. I read that XML files can also be the input and that there is a JDBC driver too which supports read-only queries to the HPCC data.
In my Java-based web application, I'm currently using a MySQL database. It consists of several tables which have BLOB columns but the data arriving is huge and we have decided to switch to a HPCC for quick storage and retrieval.
My questions are as follows:
I sprayed multiple csv files using ECL and DFU and also have fetched the data using ECL record structure. I read that XML files can also be the input and that there is a JDBC driver too which supports read-only queries to the HPCC data.
In my Java-based web application, I'm currently using a MySQL database. It consists of several tables which have BLOB columns but the data arriving is huge and we have decided to switch to a HPCC for quick storage and retrieval.
My questions are as follows:
- How do insert my data directly into HPCC - I don't have any kind of file with me(csv, flat, xml etc.)?
- The BLOBs columns in the tables are the result of certain external operations which finish after the initial insert i.e the BLOBs are later 'updated' into the tables - how do I handle such a scenario in HPCC(ECL approach?)
- kaliyugantagonist
- Posts: 43
- Joined: Mon Jul 23, 2012 11:23 am
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests