- BaseX-Talk - mailman.uni-konstanz.de

High cpu utilization
by Sateesh 15 Jul '13

15 Jul '13

Hi Basex, We have written a xquery which runs on a collection containing 600 xml files and the size of collection is 670MB.when we execute the xquery the CPU utilization is going up to 30-40% and as the number of hits that comes for executing this queries at a time will be around 20-40 because of high CPU utilzation for executing one query the processing speed of the remaning queries is getting delayed. Could you please check is some thing wrong in the query or do you have some suggestion which could improve the performance.Please find attachement of query and sample xml file. Thanks & regards Sateesh.A

2 3

sort bug
by Hans-Juergen Rennau 13 Jul '13

13 Jul '13

Dear Basex team, it seems to me that there is a little bug in the FLWOR sort. Code: for $i in 1 to 3 for $j in ('a', 'b', 'c') order by $i descending return concat($i, $j) Expected output: 3a 3b 3c 2a 2b 2c 1a 1b 1c Actual output: 3c 3b 3a 2a 2b 2c 1c 1b 1a Using the latest stable snapshot. Kind regards, Hans-Juergen

1 0

"XUDY0027 - Insert target must not be empty" with default namespaces
by Carlos MARCOS LAGUNAR 09 Jul '13

09 Jul '13

Hi, I'm working with latests BaseX distribution. The problem arises when I change from a specific namespace to a default namespace on the XML file. >From that moment on the insertion becomes messy, since some of them fail. Example: Here is the source XML that I insert into the newly created DataBase: <n:one xmlns:n="oneone"> <two /> </n:one> I execute then a xquery to insert a node into the empty tag "two": insert node <three/> into db:open("MyDB", "q471pa0lnovkfflso7ecsd6nj1.xml")/*:one/two In that case, I get a successful insertion: If I query the file (db:open("MyDB", "q471pa0lnovkfflso7ecsd6nj1.xml")/*:one) I get: <n:one xmlns:n="oneone"> <two> <three /> </two> </n:one> This is the normal behavior. The problem comes when I try to set that namespace as the default. So I create a new DataBase with the following XML: <one xmlns="oneone"> <two /> </one> When I try to execute the same xquery as before (insert node <three/> into db:open("MyDB", "q471pa0lnovkfflso7ecsd6nj1.xml")/*:one/two) I get the following error: rg.basex.core.BaseXException: Stopped at line 1, column 84: [XUDY0027] Insert target must not be empty I cannot understand then why the namespace affects the insertion this way :-/ I'm querying and insertion from a Java application by using JavaClient, although I guess this is not relevant here. Any help would be appreciated. Thank you and best regards, C. ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente pueden estar protegidos por secreto profesional. Si usted recibe este correo electronico por error, gracias por informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus. ------------------------------------------------------------------

3 3

memerhabalar ismim gamze yasim 25 bekarim hic evlenmedim aslen turkiyeliim
by Efsun 08 Jul '13

08 Jul '13

memerhabalar ismim gamze yasim 25 bekarim hic evlenmedim aslen turkiyeliim ama yurt disinda yasiyorum ben 2 yasindayken anem burdan evlilik yapti yunana geldik burdan evliliK yapti annem ve 23 seneden beri burda yasiyorum annem kanser hastasi ve ben uvey babamin yaninda kaliyorum o yuzden de kendi yuvami kurmak istiyorum ama bu ulkede degil turkiyede olmasini isterim dinimden musluman olarak birisiyle anlasabilecegim guven uyum saglayabilecegim birisi olsun yeter ve fazla bilgisayardan anlamadigim icin arkadasimin yardimiyla bu yoldan size ulasmak istedim beni tanimak ve ulasmak isterseniz iste telim sifir sifir uc sifir alti dokuz dort uc iki yedi dokuz dort sifir bes 00306943279405

1 0

XQuery for Scala
by Charles Foster 08 Jul '13

08 Jul '13

Dear Christian, Michael, Alexander, Dirk and all at BaseX + the BaseX community. I would like to introduce you to a new XQuery API for Scala users, the XQS API! Like a lot of great software, it's tight, so tight in-fact it's 209 lines long! Oh and it's built on top of the XQJ interfaces, so it's vendor neutral. The project is hosted at: https://github.com/fancellu/xqs This was written by and is maintained by Dino Fancellu [1] who is welcoming feedback. Kind Regards, Charles [1] http://www.dinofancellu.com

2 1

Re: [basex-talk] Base-X FLOWR Expressions Not Working?
by Dirk Kirsten 05 Jul '13

05 Jul '13

Hi Raj, I am responding to the mailinglist so that maybe other people can benefit from your question as well. This is not a BaseX bug, indeed it returns the correct result. The problem is with your query and the scope of your selection. The variable $i contains the whole document, so basically it does not iterate much. You are then filtering out each document, which does not have a country with the id f0_136. As the whole factbook.xml does have one such element, it is passed on and all the country names are returned. What you instead want to do is to iterate over each country, not over each document. So the following will work as expected: for $i in doc("etc/factbook.xml")/mondial/country where $i/@id = 'f0_136' return $i/name You can also simplify this using a predicate: for $i in doc("etc/factbook.xml")/mondial/country[@id = 'f0_136'] return $i/name or even doc("etc/factbook.xml")/mondial/country[@id = 'f0_136']/name Cheers, Dirk On 07/05/2013 10:01 AM, Rajabrata Chaudhuri wrote: > Hi Dirk, > > I was hoping you could help me with a problem. Based on our previous > discussion, I started experimenting with Base-X, but am having trouble > with even the basic FLOWR queries applying the "WHERE" clause, which for > some reason is always returning every node in the XML document. As an > example, I tried the factbook.xml that comes with the Base-X install > with the following query: > > for $i in doc("etc/factbook.xml") > where $i/mondial/country/@id = 'f0_136' > return $i/mondial/country/name > > > <name>Albania</name> > <name>Andorra</name> > <name>Austria</name> > <name>Belarus</name> > <name>Belgium</name> > <name>Bosnia and Herzegovina</name> > <name>Bulgaria</name> > <name>Croatia</name> > <name>Czech Rep.</name> > <name>Czech Republic</name> > <name>Denmark</name> > <name>Estonia</name> > <name>Faroe Islands</name> > <name>Finland</name> > <name>France</name> > ... > > The result is coming back with every country when it should just return > Albania. Can you help me with this? Is this some kind of Base-X bug, > because I am not sure what I am doing wrong here. > > Thanks > Raj -- Dirk Kirsten, BaseX GmbH, http://basex.org |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22

2 1

Manufacturer-PAC&CMC Used in Drilling Fluids/Zouping Fuhai Technology development Co., Ltd
by daisy＠mes-hpmc.com 04 Jul '13

04 Jul '13

Dear Sir or Madam, Glad to hear that you are in the market for PAC and CMC. This is Daisy from Zouping Fuhai Technology development Co., Ltd. Two of our best-selling products will be introduced to you today. Product Description 1. CMC(Carboxymethyl cellulose) ,PAC(Polyanionic cellulose) purity>99.5% 2. Free sample 3. High quality and reasonable price. 4. ISO9001, ISO22000(HACCP) CMC and PAC OIL-DRILLING GRADE can be widely used in Oil drilling, which have good water loss control capability, PAC product is a kind of effective water loss controller and viscosifier with high mud yield, strong salt resistance and temperature tolerance. In oil industry, Qidong® PAC&CMC is used in large quantities, usually to thicken drilling mud. These fluids serve to carry the solids cut by the drilling bit back to the surface. Any questions or suggestions will be appreciated. FREE SAMPLES will be sent for your evaluation! Please note that our company is integrated with manufacturing and selling, which makes us able to arrange for the production the moment we receive your order. We look forward to your reply. Best regards, Daisy Lu Sales Manager Zouping Fuhai Technology development Co., Ltd Tel: +86-532-58979309 Fax: +86-532-86934525 E-mail: daisy(a)mes-hpmc.com Web: www.mes-hpmc.com

1 0

Performance doc vs db
by Andy Bunce 03 Jul '13

03 Jul '13

Hi, Looking to compare the performance of BaseX on a number of machines I have been running the Xmark queries [1]. Query 11 seems to be one that causes the most stress. I then compared the performance executing query 11 against an xml file on the filesystem compared with importing it into a database and timing the query against the database: * Running from a database 36sec * Running from a file 9secs The xml was generated using xmlgen /f 0.1 /o test.xml This does not seem right to me. I was expecting the database to be faster. /Andy [1] http://www.ins.cwi.nl/projects/xmark/Assets/xmlquery.txt

3 3

Invitation: I AM LOOKING FOR ROMANCE @ Sun 30 Jun 2013 12:00 - 13:00 (sallymore02@gmail.com)
by Sally Moore 30 Jun '13

30 Jun '13

You have been invited to the following event. Title: I AM LOOKING FOR ROMANCE I AM LOOKING FOR ROMANCE My name is Sally Moore, I came acrose your profile when i was searching for a life partner I was inspired to send you a massage and ask you for friendship. As you know that having a prophesy of love over somebody there most be odds around the corner, but no matter the odds, love survive all odds. I am a girl who's love story is intresting. I am responsible, romantic and courageous. I belive, with good mind you have to admit my request Please recontact me with my e-mail address at......( sallymoore21(a)yahoo.com ) so I can send my picture and tell you more about myself. Yours Love Miss Sally When: Sun 30 Jun 2013 12:00 – 13:00 Ouagadougou Calendar: sallymore02(a)gmail.com Who: (Guest list has been hidden at organiser's request) Event details: https://www.google.com/calendar/event?action=VIEW&eid=aGhpZ21xZDRhYzYxdmQ3O… Invitation from Google Calendar: https://www.google.com/calendar/ You are receiving this courtesy email at the account basex-talk(a)mailman.uni-konstanz.de because you are an attendee of this event. To stop receiving future notifications for this event, decline this event. Alternatively, you can sign up for a Google account at https://www.google.com/calendar/ and control your notification settings for your entire calendar.

1 0

limiting time or space resources in calls to xquery:eval() ?
by C. M. Sperberg-McQueen 29 Jun '13

29 Jun '13

I'm contemplating the construction of an interface for advanced or dedicated users of a database, with a text box in which they type their queries as XQuery modules. (Non-advanced and non-dedicated users will make do with a variety of pre-defined queries; this interface is intended to provide an open-ended query interface for the few users who will need it.) One issue that arises is security: any use of an eval() function opens the door to code injection attacks. For now, I'm inclined to think that BaseX's rule that xquery:eval() does not accept updating expressions suffices to protect the database from harm. Parsing the query and declining potentially harmful queries is also a possibility, if I can persuade myself I can distinguish harmful from harmless queries. (Comments and advice on this topic welcome, even though it's not the focus of this question.) A second issue is resource usage. Imagine a hostile user who writes a query designed to tie up the server for a long time and consume a lot of memory. Or imagine a non-hostile but naive user who unintentionally concocts an extremely expensive query. Is there a way to put a call to eval() (or any call to the BaseX HTTP server) into some kind of box and specify limits on the amount of CPU time, the amount of clock time, and/or the amount of storage to be available for its evaluation? Michael -- **************************************************************** * C. M. Sperberg-McQueen, Black Mesa Technologies LLC * http://www.blackmesatech.com * http://cmsmcq.com/mib * http://balisage.net ****************************************************************

4 7