Hi!
On Nov 30, 2008, at 1:43 PM, Roland Bouman wrote:
I am guessing this should read "CSV is *table* level locking for
UPDATE and DELETE..."?
Yes :)
1) Does data loading need to be JOINABLE?
In the scenario I am thinking of, yes. The scenario is scanning a
large stream of rows, and using values from the stream to look up keys
in a number of relatively small, well indexed tables. (If it helps at
all - the idea is to have something to conveniently load a star schema
directly from a CSV file. Each row from the CSV file would ultimately
result in one row in a fact table, but instead of inserting the values
from the CSV file, we'd be inserting integer key values that we looked
up in dimension tables).
You have lost me here :)
3) Do you want to be able to update it from within the database?
Well it would nice to be able to dump a large set to CSV by writing it
to a CSV table. But update as in, modify an existing row - that is not
what I would be holding my breath for.
UPDATE and DELETE on rows are what make the CSV engine overly
complicated.
Keep in mind, CSV was done just as an example. I've been surprised at
how many folks have turned out to find it useful (but then people find
new uses for blackhole all the time as well).
Well, IMO, there are indeed good tools external to the database to do
all this stuff. Exchanging data through a storage engine in this
manner would merely be a convenience feature.
Unless it was for performance? Loading data is something that is a low
hanging fruit for us to do. Though in the end it is very dependent on
the engine.
Cheers,
-Brian
Kind regards,
Roland
Cheers,
-Brian
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
--
Roland Bouman
http://rpbouman.blogspot.com/
--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/ <-- Me
http://tangent.org/ <-- Software
_______________________________________________________
You can't grep a dead tree.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
