Re: Storing csv as string or individual floats
Posted by: Peter Brawley
Date: June 10, 2018 02:11PM

If each csv block is always accessed en bloc, storing comma-separated data like that is ok. But if particular values needed to be queried from it, it needs to be normalised, ie broken out into rows & columns.

As for files, it's usually more efficient to store the file on disk somewhere, and in the database store the path to the file.



Edited 1 time(s). Last edit at 08/27/2018 10:04AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Storing csv as string or individual floats
June 10, 2018 02:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.