Ivan Shcheklein <shchekl...@...> writes:
>
>
> Hi Alexander,Please, provide us some details:1. Structure of your database.2.
Queries/updates you run.3. Event logs (SEDNA_HOME/data/event****.log) files.Ivan
Shcheklein,Sedna Team
Hi Ivan
The general database structure is a follows:
<SimulationData>
<Simulation>
<id>0</id>
<Batch>
<id>0</id>
<Run>
<id>0</id>
<Step>
<id>0></id>
...
</Step>
</Run>
...
</Batch>
...
</Simulation>
...
</SimulationData>
SimulationData nodes contain a list of Simulation nodes, which contain a list of
Batch nodes. Batch nodes conatin a list of Run nodes, and finally Run nodes
contain a list of Step nodes.
The vast majority of all inserts are within individual Step nodes. So my insert
queries would look as follows (this is an example)
UPDATE
insert ( something ) into
doc("SimulationDB")/SimulationData/Simulation[id=3]/
Batch[id=0]/Run[id=1]/Step[id=12]
"something" above could be a number of different things. Here are two short
examples
<Trade>
<quantity>105</quantity>
<price>99.920000000000002</price>
<active_id>8</active_id>
<passive_id>2</passive_id>
<registration_timer>23</registration_timer>
</Trade>
<Order>
<id>1</id>
<price>99.920000000000002</price>
<quantity>105</quantity>
<is_bid>1</is_bid>
<is_market>0</is_market>
<order_time>1</order_time>
<owner_id>2</owner_id>
<registration_timer>4</registration_timer>
</Order>
although many inserts would be much larger in size
As for event log files, there are quite a few of those (just under 50000).
Which ones should I send and how?
------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing.
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
