| Author |
XML data inside Ultralite database ?
|
|
| handheldmaster 2006-03-16, 7:28 am |
| Using 9.0.2 any hints on how-to store XML data inside the udb files ? Does
it have any xml features like its big daddy ASA ? export into xml or import
from xml client-side
| |
| Greg Fenton 2006-03-16, 7:28 am |
| handheldmaster wrote:
> Using 9.0.2 any hints on how-to store XML data inside the udb files ? Does
> it have any xml features like its big daddy ASA ? export into xml or import
> from xml client-side
No. You can store information as a LONG VARCHAR, but there are no
functions in UL to support manipulating that XML data.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| handheldmaster 2006-03-16, 9:23 am |
|
> handheldmaster wrote:
>
> No. You can store information as a LONG VARCHAR, but there are no
> functions in UL to support manipulating that XML data.
>
Ok think can use the .NET compact framework XML api's + Ultralite.NET; so in
combination generate the XML using Dataset objects.
Do you think the data will bloat ? meaning if stored in plain ultralite udb
or in xml file. Thinking xml is going to take more space as ultralite does
any compression etc ?
| |
| Tom Slee 2006-03-16, 9:23 am |
| handheldmaster wrote:
>
> Ok think can use the .NET compact framework XML api's + Ultralite.NET; so in
> combination generate the XML using Dataset objects.
>
> Do you think the data will bloat ? meaning if stored in plain ultralite udb
> or in xml file. Thinking xml is going to take more space as ultralite does
> any compression etc ?
>
>
You can use the .NET APIs to persist data as XML, perhaps using the
DataAdapter. This does lead to some bloat because (a) the DataAdapter
makes a separate copy in memory of an entire result set, and (b) the XML
format itself will be verbose.
The DataReder is more efficient than the DataAdapter as it doesn't make
the separate copy of the complete result set. I don't know how the
DataReader fits in with .NET Compact Framework XML API's though.
UltraLite is efficient at how it stores data (eg, a small-enough integer
takes only one byte of storage, even though an integer is a 4 byte object).
You can export and import from XML on the desktop using command-line
tools (ulxml) but I guess this is not what you are looking for.
Tom Slee
iAnywhere Solutions
| |
| Tom Slee 2006-03-16, 9:23 am |
| handheldmaster wrote:
>
> Ok think can use the .NET compact framework XML api's + Ultralite.NET; so in
> combination generate the XML using Dataset objects.
>
> Do you think the data will bloat ? meaning if stored in plain ultralite udb
> or in xml file. Thinking xml is going to take more space as ultralite does
> any compression etc ?
>
>
You can use the .NET APIs to persist data as XML, perhaps using the
DataAdapter. This does lead to some bloat because (a) the DataAdapter
makes a separate copy in memory of an entire result set, and (b) the XML
format itself will be verbose.
The DataReder is more efficient than the DataAdapter as it doesn't make
the separate copy of the complete result set. I don't know how the
DataReader fits in with .NET Compact Framework XML API's though.
UltraLite is efficient at how it stores data (eg, a small-enough integer
takes only one byte of storage, even though an integer is a 4 byte object).
You can export and import from XML on the desktop using command-line
tools (ulxml) but I guess this is not what you are looking for.
Tom Slee
iAnywhere Solutions
| |
| Michael Thode 2006-03-16, 1:23 pm |
| Ultralite won't do any compression of any XML stored in a long varchar
column. The space used should be similar to a file.
Mike
"handheldmaster" <abc@456.com> wrote in message
news:44197a43$1@foru
ms-1-dub...
>
> Ok think can use the .NET compact framework XML api's + Ultralite.NET; so
> in combination generate the XML using Dataset objects.
>
> Do you think the data will bloat ? meaning if stored in plain ultralite
> udb or in xml file. Thinking xml is going to take more space as ultralite
> does any compression etc ?
>
| |
| Greg Fenton 2006-03-16, 1:23 pm |
| Michael Thode wrote:
> Ultralite won't do any compression of any XML stored in a long varchar
> column. The space used should be similar to a file.
But if you use .NET to pull the XML apart and store the data contained
therein in UltraLite, I would expect the UL solution to use MUCH less
storage space.
XML has its uses....but it is a dog especially in the handheld/wireless
world where resources are scarce, slow and expensive.
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
|
|
|
|