Hi Ivan,
Thank you very much, I tried to declare the namespace before but probably
did something stupid and it didn't work. Anyway it's working smoothly now!
We're dealing with huge collections and working with some ETL scripts, we
need to fine tune our sedna database because our project is growing fast and
soon we gonna have more than 10 million documents.
BTW, we were trying to make a composite index (using the same example), a
index based on "controle" and "estadoControle", is it possible? any tip on
doing this?
Thanks
On Wed, May 4, 2011 at 5:05 PM, Ivan Shcheklein <[email protected]>wrote:
> Hi Rodolfo,
>
>
> Most likely you forgot to declare default namespace. Something like this
> should help:
>
> declare default element namespace "
> http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd";;
> CREATE INDEX "control" ON
> collection("leitura-1")/registroDigitacao/documento BY
> controle AS xs:integer
>
>
>
> Ivan Shcheklein,
> Sedna Team
>
>
> Hello there,
>>
>> I have a collection named "leitura-1"
>>
>> documents has the following structure:
>>
>> <?xml version="1.0" standalone="yes"?>
>> <registroDigitacao xmlns="
>> http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd";>
>> <digitacao>
>>
>> <digitador>uid=isabel.sinena,dc=GP,dc=rh,dc=diretorio,dc=fortaleza,dc=ce,dc=gov,dc=br</digitador>
>> <dataDigitacao>2011-02-03T18:17:19</dataDigitacao>
>> <localDigitacao>200.223.251.139</localDigitacao>
>> </digitacao>
>> <leitura>
>> <id>1</id>
>> <instrumento>
>> <nome>Caderno A</nome>
>> <xmlSchema>viladomar-cadernoa.xsd</xmlSchema>
>> <projeto>
>> <id>1</id>
>> <nome>Vila do Mar</nome>
>> </projeto>
>> </instrumento>
>> </leitura>
>> <documento>
>>
>> <id>digitacao_1_Caderno_A_1_uid_isabel_sinena_dc_GP_dc_rh_dc_diretorio_dc_fortaleza_dc_ce_dc_gov_dc_br_1296757039</id>
>> <controle>4298</controle>
>> <estadoControle>Aberto</estadoControle>
>> <cd:estado xmlns:cd="
>> http://schemas.fortaleza.ce.gov.br/acao/controledigitacao.xsd
>> ">Aprovado</cd:estado>
>> <conteudo>
>> <formCadernoA xmlns="
>> http://schemas.fortaleza.ce.gov.br/habitafor/viladomar-cadernoa.xsd";>
>>
>> I'm trying the following:
>>
>> CREATE INDEX "control"
>> ON collection("leitura-1")/registroDigitacao/documento BY controle
>> AS xs:integer
>>
>> the following brings me nothing:
>> for $x in index-scan("control", 4298, "EQ") return $x
>>
>> any clue on what I'm doing wrong?
>>
>> thanks!
>>
>>
>> ------------------------------------------------------------------------------
>> WhatsUp Gold - Download Free Network Management Software
>> The most intuitive, comprehensive, and cost-effective network
>> management toolset available today. Delivers lowest initial
>> acquisition cost and overall TCO of any competing solution.
>> http://p.sf.net/sfu/whatsupgold-sd
>> _______________________________________________
>> Sedna-discussion mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>>
>
------------------------------------------------------------------------------
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
acquisition cost and overall TCO of any competing solution.
http://p.sf.net/sfu/whatsupgold-sd
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
