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

[doug sanden]

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?
-- b) each node type in a separate table, with columns representing fields (about 256 node types->256+ tables?)
-- c) few more general tables like nodes, scalar fields, MF fields, parentNode+field/child, parentMFField+index/child
- is there a way to generate a table layout automatically using XSLT for x3d?

Q2. how is the parser/loader generator related to ETL? (I see ETL often, I think it means extract, transform, load)
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> 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
>> Watkins 270, MOVES Institute, Monterey CA 93943-5000 USA +1.831.656.2149
>> X3D graphics, virtual worlds, navy robotics http://faculty.nps.edu/brutzman
>