Corrupted database

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Re: Corrupted database

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Web hosting with Sedna ?

Hi,

I am new to Sedna and it looks promising to me.

I was wondering if anybody knows of a web hosting company offering ready to use
servers with some combination of PHP and Sedna.

Many thanks in advance.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

Re: Web hosting with Sedna ?

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@...
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Results ranking

Hello,

I'm a newbie to Sedna and before I start playing with the look I would 
like whethere it can support me in realizing the following task.

I have a collection of XML documents (WSDLs---Web service definitions) 
formated with respected to a pre-defined stable schema. I need to 
execute (from PHP) search over XML documents. Search process includes:

  - full-text search over chosen XML elements
  - substring search over values of attributes of chosen XML elements

 From what I've read on your site this can be done with Sedna.

I wonder whether it also:
(1) scores relevance of matching XML documents and ranks them (in any way)
(2) allows navigating to identify (in matching document) XML elements 
with matched query terms and than navigating to parental/children nodes 
in XML structure
(3) provides a way to give more weight to some XML element types during 
relevance scoring.

Best regards,
Maciej

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

Re: Results ranking

Hello Maciej,

Sedna supports full-text search using dtSearch engine, so you will
need dtSearch license to use full-text search in Sedna.

dtSearch supports relevance ranking and giving more weight to some XML
elements. Note that ftindex-scan function returns matching elements in
arbitrary order (i.e. not sorted by relevance score), while
ftwindex-scan returns elements orderer by their score. Currently
there is no way to access relevance score values from XQuery in Sedna.

Since, ftindex-scan function returns a sequence of elements you can
easily add structural predicated to these results.

Substring search is supported, though there's no way to speed it up
with indexes (unless it's prefix search).

Also note that ftindex-scan and similar functions are Sedna-specific
and are not defined in XQuery standard. Currently Sedna doesn't support XQuery
full-text search extensions or automatic use of indexes in queries.

Thursday, July 15, 2010, 5:33:20 PM, you wrote:

> Hello,

> I'm a newbie to Sedna and before I start playing with the look I would
> like whethere it can support me in realizing the following task.

> I have a collection of XML documents (WSDLs---Web service definitions)
> formated with respected to a pre-defined stable schema. I need to 
> execute (from PHP) search over XML documents. Search process includes:

>   - full-text search over chosen XML elements
>   - substring search over values of attributes of chosen XML elements

>  From what I've read on your site this can be done with Sedna.

> I wonder whether it also:
> (1) scores relevance of matching XML documents and ranks them (in any way)
> (2) allows navigating to identify (in matching document) XML elements 
> with matched query terms and than navigating to parental/children nodes
> in XML structure
> (3) provides a way to give more weight to some XML element types during
> relevance scoring.

> Best regards,
> Maciej

--

-- 
Best regards,
 Roman                            mailto:ignatich@...

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

[ sedna-Bugs-3031529 ] Error SE4211 under path with 2 bytes characters

Bugs item #3031529, was opened at 2010-07-19 10:58
Message generated for change (Tracker Item Submitted) made by goodluckfish
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3031529&group_id=129076

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: Sedna (development)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: chun chen (goodluckfish)
Assigned to: Nobody/Anonymous (nobody)
Summary: Error SE4211 under path with 2 bytes characters

Initial Comment:
version of Sedna - 3.3.55
operating system version - Windows 5.1.2600 (SP3.0) x86

When trying to create a database under path with 2 bytes characters, I got the ERROR SE4211.
2 bytes characters means Chinese or Japanese characters. Command lines :

  E:\publish\版本发布\sedna\bin>se_gov
GOVERNOR has been started in the background mode

E:\publish\版本发布\sedna\bin>se_cdb aaa
Creating a data base (it can take a few minutes)...
SEDNA Message: ERROR SE4211
Failed to create the database
Details: aaa

Cannot complete cleanup. Please stop Sedna and remove the following:
file   -  /cfg/aaa_cfg.xml
folder -  /data/aaa_files
Sorry for inconvenience.

E:\publish\版本发布\sedna\bin>

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3031529&group_id=129076

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

[ sedna-Bugs-3031529 ] Error SE4211 under path with 2 bytes characters

Bugs item #3031529, was opened at 2010-07-19 13:58
Message generated for change (Settings changed) made by shcheklein
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3031529&group_id=129076

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: General
Group: Sedna (development)
Status: Open
>Resolution: Accepted
>Priority: 3
Private: No
Submitted By: chun chen (goodluckfish)
>Assigned to: Ivan Shcheklein (shcheklein)
Summary: Error SE4211 under path with 2 bytes characters

Initial Comment:
version of Sedna - 3.3.55
operating system version - Windows 5.1.2600 (SP3.0) x86

When trying to create a database under path with 2 bytes characters, I got the ERROR SE4211.
2 bytes characters means Chinese or Japanese characters. Command lines :

  E:\publish\版本发布\sedna\bin>se_gov
GOVERNOR has been started in the background mode

E:\publish\版本发布\sedna\bin>se_cdb aaa
Creating a data base (it can take a few minutes)...
SEDNA Message: ERROR SE4211
Failed to create the database
Details: aaa

Cannot complete cleanup. Please stop Sedna and remove the following:
file   -  /cfg/aaa_cfg.xml
folder -  /data/aaa_files
Sorry for inconvenience.

E:\publish\版本发布\sedna\bin>

----------------------------------------------------------------------

>Comment By: Ivan Shcheklein (shcheklein)
Date: 2010-07-19 16:55

Message:
Hi Chun,

This is a known limitation of Sedna. For the moment the only workaround is
to use ASCII chars in path.

Technical comments for developers for further work on this issue:

1. On windows seems we have to define UNICODE (see MSND, Conventions for
Function Prototypes) and use wchar* for all system calls. Everywhere we
need we should translate Sedna's UTF-8 strings (like SEDNA_DATA) -> wchar
and backward.

2. On windows we should also explicitly use _wfopen instead of fopen, etc
... 

3. On Linux there is no "wfopen()" (just plain old "fopen()" will
suffice), but there *are* Unicode equivalents for each of the file read and
write APIs. Should we use them?

4. We should also check other supported platforms - OS X, Solaris, BSD.

5. As a temporary fix probably we may raise some exception on se_gov if
there are non ASCII chars?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3031529&group_id=129076

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion

Sedna in Firefox

Hello all!

I've just added an add-on for Firefox which uses Sedna; I'm calling it 
"XDIB" or "XML Database In a Browser". See 
https://addons.mozilla.org/en-US/firefox/addon/199900/ .

Basically, this lets any web developer, who is given permission by the 
user, to add XML content to Sedna (databases stored in Firefox's Profile 
folder by default, so that the data will not be lost whenever the 
extension may get updated) and then query it, update it, etc..

Actually, we've basically wrapped every command there is in Sedna 
(though removing "Sedna" from the methods in case this could become 
abstracted--sorry, no XQJ at the moment), though I haven't really tested 
anything besides loading XML and doing XQueries against data in a 
collection.

At the moment, the databases are accessible to any site which requests 
permission, as I wanted this to be the default behavior, since I think 
it should be up to users how they want their data shared, and not have 
their own data be locked in by a particular site, even if that site 
originated the storage of the data. The access is granted depending on 
whether read permissions, insert permissions, etc., are desired, and I 
really need to add the ability to specify which database one has 
permission to access, since for now, it is any one! (though it does ask 
permission at least).

I also hope to make the API available as special protocol links, so a 
link could trigger the view of certain content, and if my other add-on, 
Open URIs (at https://addons.mozilla.org/en-US/firefox/addon/162154/ ) 
is used together with this, one could link to locally stored by default, 
but fallback to an online site in case the user is visiting the site 
without this add-on installed. I like the idea of bookmarks that work 
offline, and which could do fancy queries, and trigger a download of the 
data (and subsequent auto-updates) if the data had not yet been 
downloaded. But that's not implemented at the moment...

I paid a friend to implement the C++ code which as part of an XPCOM 
component for Mozilla's Cross-Platform Component Object Model, among 
other things, lets JavaScript communicate with C++ so that people like 
me who do not know C++ can still write Firefox extensions or the like 
which interact with cool tools or libraries like Sedna, so my apologies 
if anything has been lost in translation as far as how the API is to be 
used (though I know it is working for XQueries at least--though I do 
need help on figuring out how Sedna can support UTF-8 if it uses "const 
char" as I understand that to be ASCII only; the component may need to 
be updated to support multi-byte strings).

And since my friend is a Windows guy, we've only compiled so far in 
Windows, but since this is supposed to be cross-platform, hopefully we 
can get this working on other systems as well.

As I mention on the add-on site, the API is of course very much new (not 
to mention there may well be problems in our code), so while we are 
whole-heartedly encouraging experimentation, please do not use this for 
critical content, nor depend on the API remaining frozen.

I have the off-hope that we could get XML databases to be part of HTML5; 
e.g., see the debate at 
http://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb/ 
or

http://hacks.mozilla.org/2010/06/comparing-indexeddb-and-webdatabase/comment-page-1/#comment-95595 
. My energy is fairly limited as far as what I can contribute, but I do 
hope to make piecemeal progress on this, and fully welcome anyone 
interested to offer their feedback, improvements, or whatever...  :) 
(I've cc'd myself if you wish to get in touch off-list to indicate you 
wish to be kept informed.)

best wishes,
Brett

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first

Re: Sedna in Firefox

Hi Brett,

First of all let me express appreciation of your great work!

It sounds sort of fantastik (wow, Firefox! everyone use Firefox these
days!). Unfortunately Sedna was never designed to be an embedable
database. Sedna launches and manages it's own processes (one master +
one process per db + one process per query session). Though I'd prefer
for a database that Firefox is using internally to be nicely wrapped
inside Firefox itself (no external processes, just a dll/so/dylib loaded
into Firefox process, database code sharing threads with the browser) a
bunch of external processes is just a minor inconvenience. However there
is more to come.

Embedable database must be lean. For the standalone database it is ok to
consume 90% of avalible memory. Anyway the entire computer may be
dedicated to the task of running that particular database. Obviously
embedable database is not the main task running on the computer, but
just the oposite!

Sedna memory usage is configurable but if given less than 100Mb RAM
Sedna slows down considerably. Of course the amount of RAM neccessary to
achieve adequite performance depends on the complexity of the queries
used. It is quite reasonable to expect that queries executed against the
XML database embeded inside Firefox won't be complex ones so probably we
could use less memory.

Finally there are issues with the data file. Well, just one ISSUE. The
data file size. It starts at 100Mb and grows in 100Mb increments. These
numbers are configurable as well. But don't expect to tune it down to
1Mb or so :)  The data representation used internally was not designed
to be space-efficient. Basically Sedna manages storage in 64Kb blocks.
By design distinct named XML elements must live in distinct blocks (it
makes queries like doc("aaa")/foo/bar really fast). So even not so
complex XML document can easily consume hundreds of blocks. There are
certain techniques that helps to reduce the number of blocks used ([a]
redesigning data to utilize fewer distinct named elements or [b] storing
documents with similar structure together) but I doubt that end users
will be willing to learn and apply these techniques.

And lastly the concept of "distinctly named XML elements living in
distinct blocks" was an oversimplification. It is not just the element
name that counts but the complete path from the document root. For
instance book/section/title and book/section/figure/title occupy
distinct blocks. You may see Sedna is not great at storing XML markup
(count the number of say <a>-s in average HTML page; how many <a>-s
share the same path from the document root?).

Over are the bad news.

Now comes some good ones.

Sedna is continually developed. The idea to refine data storage hovered
for a long time. I guess we can address the abovementioned issues in
some time.

And I must say the opportunity to get Sedna into Firefox is pretty
exciting! Achieving the really WIDE adoption of XML database is so much
important for the XML database community.

wbr,
mejedi

On Mon, 2010-07-19 at 22:36 +0800, Brett Zamir wrote:
> Hello all!
> 
> I've just added an add-on for Firefox which uses Sedna; I'm calling it 
> "XDIB" or "XML Database In a Browser". See 
> https://addons.mozilla.org/en-US/firefox/addon/199900/ .
> 
> Basically, this lets any web developer, who is given permission by the 
> user, to add XML content to Sedna (databases stored in Firefox's Profile 
> folder by default, so that the data will not be lost whenever the 
> extension may get updated) and then query it, update it, etc..
> 
> Actually, we've basically wrapped every command there is in Sedna 
> (though removing "Sedna" from the methods in case this could become 
> abstracted--sorry, no XQJ at the moment), though I haven't really tested 
> anything besides loading XML and doing XQueries against data in a 
> collection.
> 
> At the moment, the databases are accessible to any site which requests 
> permission, as I wanted this to be the default behavior, since I think 
> it should be up to users how they want their data shared, and not have 
> their own data be locked in by a particular site, even if that site 
> originated the storage of the data. The access is granted depending on 
> whether read permissions, insert permissions, etc., are desired, and I 
> really need to add the ability to specify which database one has 
> permission to access, since for now, it is any one! (though it does ask 
> permission at least).
> 
> I also hope to make the API available as special protocol links, so a 
> link could trigger the view of certain content, and if my other add-on, 
> Open URIs (at https://addons.mozilla.org/en-US/firefox/addon/162154/ ) 
> is used together with this, one could link to locally stored by default, 
> but fallback to an online site in case the user is visiting the site 
> without this add-on installed. I like the idea of bookmarks that work 
> offline, and which could do fancy queries, and trigger a download of the 
> data (and subsequent auto-updates) if the data had not yet been 
> downloaded. But that's not implemented at the moment...
> 
> I paid a friend to implement the C++ code which as part of an XPCOM 
> component for Mozilla's Cross-Platform Component Object Model, among 
> other things, lets JavaScript communicate with C++ so that people like 
> me who do not know C++ can still write Firefox extensions or the like 
> which interact with cool tools or libraries like Sedna, so my apologies 
> if anything has been lost in translation as far as how the API is to be 
> used (though I know it is working for XQueries at least--though I do 
> need help on figuring out how Sedna can support UTF-8 if it uses "const 
> char" as I understand that to be ASCII only; the component may need to 
> be updated to support multi-byte strings).
> 
> And since my friend is a Windows guy, we've only compiled so far in 
> Windows, but since this is supposed to be cross-platform, hopefully we 
> can get this working on other systems as well.
> 
> As I mention on the add-on site, the API is of course very much new (not 
> to mention there may well be problems in our code), so while we are 
> whole-heartedly encouraging experimentation, please do not use this for 
> critical content, nor depend on the API remaining frozen.
> 
> I have the off-hope that we could get XML databases to be part of HTML5; 
> e.g., see the debate at 
> http://hacks.mozilla.org/2010/06/beyond-html5-database-apis-and-the-road-to-indexeddb/ 
> or 
>
http://hacks.mozilla.org/2010/06/comparing-indexeddb-and-webdatabase/comment-page-1/#comment-95595 
> . My energy is fairly limited as far as what I can contribute, but I do 
> hope to make piecemeal progress on this, and fully welcome anyone 
> interested to offer their feedback, improvements, or whatever...  :) 
> (I've cc'd myself if you wish to get in touch off-list to indicate you 
> wish to be kept informed.)
> 
> best wishes,
> Brett
> 
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Sedna-discussion mailing list
> Sedna-discussion@...
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first