Malcolm G. Davis | 17 May 20:47 2014

Comparison between Sedna, eXist and BaseX?

While interesting, I am always skeptical of these types of analysis.

1. Tuning: 
a. Sedna is written in C/C++, the other 2 systems are Java based. Java based
systems always require some type of Java VM option tuning based on the
problem space.  
b. Sedna in a production environment also requires some tuning.  I have
spent effort in turning Sedna and eXistDb.  
c. Including tuning options (outside of indexing) is important.

2. Alternatives.
There are also other free options, such as DB2 express.  I've talked to
several people that prefer DB2 express for XQuery.

3. Test scenarios
a. Are the XQuery drivers equivalent?  Did you use REST for eXistDB & xBase
and not Sedna?  Sedna driver is lean and mean, REST has some inherit
overhead.

b.  All the documents are stored as separate documents?
What about the scenario of a single <Outletinfos> parent document with
Outletinfo documents as children?
I've pushed a single 2 GB XML document, with Outletinfo type documents as
children.

c.  What about batch updating?

d.  Is the full test suite available for review?

4. The project activity test
(Continue reading)

Marco van der Putten | 14 May 11:25 2014
Picon

Comparison between Sedna, eXist and BaseX

About a month ago, I’ve done some tests with Sedna, eXist and BaseX XML databases.

My employer has decided to share this with the community as a token of appreciation for the good work on these free products.

For those of you who are interested in the results, see: http://svds.aweta.local:8080/share/s/U3Rt4TQ1R-uR4ut8DVZRqg

 

Regards,

    Marco van der Putten

 

+-----------------------------------------------+

| Marco van der Putten                          |

| Aweta G&P BV              http://www.aweta.nl |

|                                               |

| P.O. box 17               Burg. Winkellaan 8  |

| 2630 AA Nootdorp          2631 HG Nootdorp    |

| Netherlands                                   |

| ++31-(0)886688000 (telephone)                 |

| ++31-(0)153107321 (fax)                       |

+-----------------------------------------------+

 

 

------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Kanchan Dokania | 5 May 11:59 2014
Picon

Which version of PHP is compatible with Sedna database? - Error in sedna.dll loading

Hi ,

I am getting the below error:

PHP Warning:  PHP Startup: sedna: Unable to initialize module\nModule compiled with module API=20060613, debug=0, thread-safety=1\nPHP    compiled with module API=20050922, debug=0, thread-safety=1\nThese options need to match\n in Unknown on line 0

Can you please tell me which version of PHP is compatible with Sedna database?

Thanks Kanchan
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
&#149; 3 signs your SCM is hindering your productivity
&#149; Requirements for releasing software faster
&#149; Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Kanchan Dokania | 4 May 18:46 2014
Picon

PHI API for Sedna

Hi,

Please tell me how to build sedna.dll library for php 5.5 and 5.1 in windows.

Thanks Kanchan
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Shiva Kumar | 4 Feb 09:21 2014

Need PHP Api for PHP5.4

Hi,

 

Where can I find PHP API for version 5.4, in sourceforge I can find only 5.2 & 5.3.

 

Please advice.

 

 

Regards

Shivakumar. T

Technical Lead

NXP Semiconductors

Manyata Embassy IT Park, Nagawara Village, Kasaba Hobli, Bangalore 560045

Tel: +91 80 40247859 , Mobile: +91 9980408114

Email: shiva.kumar <at> nxp.com, spider.tam.support-3arQi8VN3Tc@public.gmane.org, www.nxp.com

Skype: tshivakumar

 

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Andrei | 4 Dec 15:10 2013
Picon

Error, creating trigger

Нi all.
I have a problem when creating a very simple trigger:
1) CREATE DOCUMENT 'test1'
2) UPDATE INSERT <test /> into doc('test1')
3) CREATE TRIGGER "testtr"
BEFORE INSERT
ON doc("test1")//test
FOR EACH STATEMENT
DO
{
    (<test_trigger />);
}

Log text (event.log):
LOG   04/12/2013 17:49:57 (TRN RAVANA5 pid=12536 sid=48 trid=49)
[tr_functions.cpp:on_user_statement_begin:102]: User query:
---   CREATE TRIGGER "testtr"
---   BEFORE INSERT
---   ON doc("test1")//test
---   FOR EACH STATEMENT
---   DO
---   {
---       (<test_trigger />);
---   }
ERROR 04/12/2013 17:49:57 (TRN RAVANA5 pid=12536 sid=48 trid=49)
[XQueryDriver.cpp:sedna::XQueryDriver::emitErrors:87]: (XPST0003) It is a
static error if an expression is not a valid instance of the grammar defined
in A.1 EBNF. Details: at (1:320), syntax error, unexpected QName, expecting
"," or )
---           
ERROR 04/12/2013 17:49:57 (TRN RAVANA5 pid=12536 sid=48 trid=49)
[XQuerytoLR.cpp:build_subquery_qep:169]: (SE1003) Sedna internal error.
Details: Error on parsing internal subquery!
LOG   04/12/2013 17:49:57 (TRN RAVANA5 pid=12536 sid=48 trid=-1)
[tr_common_funcs.cpp:on_transaction_end:416]: Transaction has been ROLLED BACK

What i'm doing wrong here?
SEDNA version is 3.5.161 (32bit Release)
System: Windows 6.1.7601 (SP1.0) x86

Thank you for your advice.

------------------------------------------------------------------------------
Sponsored by Intel(R) XDK 
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Matteo Faralli | 26 Nov 17:47 2013
Picon

Sedna DB Export

Hi,
i'm using export function to backup my xml sedna db and migrate on another server.
I've 263.939 xml document inside and now, after 36 hours the export log (export_log.txt)
is reporting this:

Exporting document 10790 of 263939 [declare option se:output "indent=no"; doc("0a6fe2e8e404a52c7ee5a2d8acc2c7b11d7e2973ad8c8adc60edcdf9dd0d329b","CERVED_FULL")]...done

Why is it so slow? Is this normal? My db size is 400GB. Is there another way to backup and migrate my db to another sedna db (on other machine) without waiting a week?

Thank you
Matteo
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
rajkumar | 17 Nov 04:02 2013
Picon

Sedna+php+nginx - Request for a tutorial

Hi

    I am trying to get an operational site similar to the "Demo" site on Sedna, with canned queries and the
option 
of advanced users entering their own valid XPATH query. 
For this I would like to use the following software and this is on an iMac running OSX-10.6.8 with gcc-4.6.0. 

1) nginx version: nginx/1.5.6
    I have downloaded the sources, compiled it and am able to run it on my localhost with no problems at
all. 
2) PHP version-5.5.6
    I have downloaded the latest version, compiled and installed it and able to use it with no problems at
all. 
3) I have download, compile and have Percona running as you can see below:
    ./mysqld --help
      ./mysqld  Ver 5.6.14 for osx10.6 on x86_64 (MySQL Community Server (GPL))
      Copyright (c) 2009-2013 Percona LLC and/or its affiliates

   Please note that I have this fully working on my localhost, and am able to insert, delete and view the data
in Percona via php with no problems. 

   I am happy with this architecture as long as the data could be loaded into Percona and fits into the RDBMS
model. 

   I have downloaded sedna-3.5.161 and have it running with no problems and played around with it
from the command line with no problems. 

   I have compile php-api-2.3.1 and have the sedna.la and sedna.so files available. 

   I have lots of XML files with I need to load into Sedna and have a site similar to the DEMO on the Sedna
site using php. 

   Please let me know how to configure or what conf files have to be changed to get the
Sedna+php+nginx working. I have searched for help on google as much as I could, but did not find any. 

   If you could send me a short how-to to get this operational, I would appreciate it very much. 

Regards
RJR

------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Matteo Faralli | 12 Nov 16:11 2013
Picon

Question about INDEX creation and Performance

Hi,
i'm using Sedna DB XML, i've installed and configured the application in a CentOS system on a phisical machine with 32GB RAM and 1 TB of Hard-disk.

My actual DB-Collection contains 130Gb of XML and the Sedna configuration is:

<?xml version="1.0" standalone="yes"?>
<db>
   <name>cerved_test</name>
   <bufs_num>32000</bufs_num>
   <max_log_files>60</max_log_files>
   <tmp_file_initial_size>6000</tmp_file_initial_size>
   <upd_crt>0.25</upd_crt>
</db>

This is a part of XML i want to index (xml is contained in a Collection):

<?xml version="1.0" encoding="ISO-8859-1"?>
<s2xResponse>
    <s2xStatus Reload="N">
    <s2xData>[XML-NODES]</s2xData>
    <s2xInfo>[XML-NODES]</s2xInfo>
    <s2xDocument>[XML-NODES]</s2xDocument>
    <IfisInfo>
        <insert_date>20131023</insert_date>
        <ndg>231459</ndg>
        <group_id>231459</group_id>
        <fiscal_code>07530530018</fiscal_code>
        <document_date>-</document_date>
        <hash_key>-</hash_key>
        <is_last>true</is_last>
    </IfisInfo>

</s2xResponse>


I've tried to create some indexs on dark-green keys to increase
performance in query execution:

CREATE INDEX "bs_index_ndg" 
ON collection("CERVED_FULL")/s2xResponse//IfisInfo BY ndg
AS xs:string 
USING "bstrie" &

CREATE INDEX "bs_index_fc" 
ON collection("CERVED_FULL")/s2xResponse//IfisInfo BY fiscal_code
AS xs:string 
USING "bstrie" &

CREATE INDEX "bs_index_last" 
ON collection("CERVED_FULL")/s2xResponse//IfisInfo BY is_last
AS xs:string 
USING "bstrie" &


I'm using a heavy query to test performance:

for $a in collection('CERVED_FULL')/s2xResponse
where $a/IfisInfo/is_last/text() = "true" and (
      $a/IfisInfo/ndg/text() = "value1" or
      $a/IfisInfo/ndg/text() = "value2" or
      ...
      ...
      ...
      [~4000 OR value conditions]
)
return
        <Response>
              <Key1></Key1>
              <Key2></Key2>
              <Key3></Key3>
        </Response>

This query give me result in ~240 seconds, the same time before and after index creation.

Is something wrong in my INDEX creation?
Is there any configuration parameter i can change to increase performance?

Every day i load ~100 new xml document on db and the same query, with the same number of OR condition (identical query), lose some time in execution,
so i think is an INDEX problem.

Any suggestions?

Thank you very much
Matteo
------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most 
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Jacobson, Miranda | 18 Oct 23:05 2013

se_term problem

I am trying to use se_term –query to load an initial schema into my database. I am having a problem with the syntax. I have tried several combinations but I always get an error. Here is what my command is

 

se_term -query "Load ‘Initialize_DB.xml’ ‘VOLCANO_DB’" VOLCANO_DB

 

This is the error I get

 

It is a static error if an expression is not a valid instance of the grammar defined in A.1 EBNF.

Details: at (1:6), syntax error, unexpected String Literal, expecting end of file or statement separator

 

Load 'Initialize_DB.xml' 'VOLCANO_DB'

 

If I use se_term –file and have the same Load command in the file it works fine but when I try to do it like this I get an error.

 

What I am doing wrong?

Thanks,

 

Miranda Jacobson

 


----------------------------------------------------------------------------------
NOTICE: The information contained in this electronic message and any attachments to this message may contain information that is privileged, confidential, or is otherwise protected by work product immunity. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, use, copying, and/or disclosure of its contents is strictly prohibited. If you have received this message in error, please notify us immediately by either replying to this message or calling Volcano Corporation at +1 (800) 228-4728 and, deleting this message from your computer.   ­­  
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
Jocelyn Raymond | 20 Sep 01:13 2013
Picon
Picon

Fwd: Sedna-discussion Digest, Vol 82, Issue 7

Hi Sedna Team,
Last April you said (see below) that you added a function called:  doc-available('doc','col') into the development code.  I know the change hasn't made it to the stable release yet (Your site still shows sedna-3.5.161 for stable release).  We are still currently running with sedna-3.5.161 but we are starting to need "badly" the doc-available('doc','col') function.
Would you consider your current development stable (sedna-3.6.132)?  I compared the PPFnDocAvailable.cpp code with older one and noticed quite few changes.  So I am not sure if the current development source code is stable at the moment.

Just to be sure, when I execute the following on our current version (3.5.161) I get:
se_term -query "doc-available('1379606095513','app')" student-awards

SEDNA Message: ERROR XPST0017
It is a static error if the expanded QName and number of arguments in a function call do not match the name and arity of a function signature in the static context.
Details: at (1:1), unknown function {http://www.w3.org/2005/xpath-functions}doc-available/2

In the meantime, I will try to download the source and compile it on our development linux server.
Again, many Thanks to the sedna Team.
Jocelyn
--
Team Lead
ISBD
Office of the Registrar
University of Alberta
780.492.3874




>
>  On Sat, Apr 13, 2013 at 1:17 PM, Ivan Shcheklein <shcheklein-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>wrote:
>
>> Hi Jocelyn, Jose
>>
>>  Release won't be available very soon. For now, you can download and use
>> the latest development build:
>>
>>  http://modis.ispras.ru/FTPContent/sedna/development/
>>
>>  It's stable enough to be used in production. Still, I recommend to try
>> it first on your workload in a sandbox. And (as you always should do)
>> backup your data.
>>
>>  This version contains fn:doc-available with two arguments. You should
>> use it instead of doc("$documents") to check if the document is in the
>> specified collection or not. Note! This function call puts read lock on the
>> collection.
>>
>>  Note, use se_exp to move data to that build.
>>
>>  Ivan Shcheklein,
>> Sedna Team
>>
>>
>>   On Fri, Apr 12, 2013 at 11:48 PM, Jocelyn Raymond <jraymond-yfeSBMgouQgsA/PxXw9srA@public.gmane.org
>> > wrote:
>>
>>>  Is it possible to have the fn:doc-available() function made as a new
>>> sedna stable release (e.g. sedna-3.5.162-bin-linux-x64.sh  currently it
>>> is: sedna-3.5.161-bin-linux-x64.sh)?  If so, when can we expect to have
>>> it?
>>> Thank you,
>>> Jocelyn Raymond
>>>
>>>  --
>>> Team Lead
>>> Information Systems
>>> Office of the Registrar
>>> University of Alberta
>>> 780.492.3874
>>>


End of Sedna-discussion Digest, Vol 82, Issue 7
***********************************************


------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Gmane