[x3d-public] Open Asset Import Library download | SourceForge.net

[doug sanden]

John,
Thanks very much John, you probably saved me several weeks of doing the wrong thing sometime in the future. I'll put nosql/couchdb/mongodb and HDF5 on my reading list.
-Doug

_
>
> Thing, not think.
>
..
>>
>>
>> John,
>> I'm not a database guru, but I've always wondered:
>> Q1. how is x3d -or xml, or any branchy tree data- stored in a database?
>> -- a) an entire scene as a blob?
>
> Generally in Oracle it's stored as an xml type so you can do XPath in
> sql. I don't know implementation details. I suspect serialized DOM to
> blob however.
>> -- b) each node type in a separate table, with columns representing
> fields (about 256 node types->256+ tables?)
>
> Try to come up with a SQL query to output XML and you will see why
> other means are chosen.
>
>> -- c) few more general tables like nodes, scalar fields, MF fields,
> parentNode+field/child, parentMFField+index/child
>
> We did something like this with HDF5. Essentially you create tables
> around the document and then use ETL to populate the tables.
>
>> - is there a way to generate a table layout automatically using XSLT
> for x3d?
>
> I'm not sure why you would want to when you can use NoSQL. No tables
> necessary.
>
>> Q2. how is the parser/loader generator related to ETL? (I see ETL
> often, I think it means extract, transform, load)
>
> ETL breaks up documents into relational form.
>
> Generally branchy trees are stored in the database as JSON these days
> I'd say. But I only have experience with CouchDB and MongoDB.
>> Thanks,
>> -Doug
>>
>>>
>>> While it may be good to look at an example XML loader, I think it
> may be worth looking at some kind of parser/loader generator if not
> already present in assimp. I’ve built one of these as an ORM for an
> Oracle database a long time ago. It essentially maps interfaces. I
> think Altova MapForce may help with this, but I’m not sure of the
> license or portability of produced code. What I’m thinking of is some
> kind of metaprogramming. With metaprogramming comes schema and XSLT or
> DSSSL. What is the potential possibility for converting XML X3D to
> another XML format which assimp does import? How well does X3D ->
> Collada -> Assimp work? What is generating the desire for a direct
> importer?
>>>
>>> John
>>>> On May 25, 2015, at 12:52 AM, Don Brutzman
> <brutzman at nps.edu<mailto:brutzman at nps.edu>> wrote:
>>>>
>>>> Thanks for looking at this John, and for comments Doug & Max.
>>>>
>>>> I would think that either Interchange Profile would be a good start.
>>>>
>>>> Looking through existing assimp converters to see which might best
> be adapted would seem to be smart.
>>>>
>>>> Potentially with a little planning, anyone who pursues this might
> structure it to work for either ClassicVRML or XML encoding.
>>>>
>>>> Found this thread about assimp and vrml on their forums. Some
> people offered consulting services.
>>>> https://sourceforge.net/p/assimp/discussion/817653/thread/fd2f667c/
>>>>
>>>> XML syntax might be a faster way in, if another XML-based format
> was used. Several are listed here:
>>>>
>>>> Importer-specific notes
>>>> http://assimp.sourceforge.net/lib_html/importer_notes.html
>>>>
>>>> I've started a Projects Wish List page where we might list more
> things like this. Initial ideas discussed during the VR Hackathon.
> Additions and improvements welome!
>>>>
>>>> http://www.web3d.org/projects-wish-list
>>>>
>>>> all the best, Don
>>>> --
>>>> Don Brutzman Naval Postgraduate School, Code USW/Br
> brutzman at nps.edu<mailto:brutzman at nps.edu>
>>>> Watkins 270, MOVES Institute, Monterey CA 93943-5000 USA +1.831.656.2149
>>>> X3D graphics, virtual worlds, navy robotics
> http://faculty.nps.edu/brutzman
>>>
>>
>> _______________________________________________
>> x3d-public mailing list
>> x3d-public at web3d.org<mailto:x3d-public at web3d.org>
>> http://web3d.org/mailman/listinfo/x3d-public_web3d.org