IFC SQLite Project

[ReD_CoDE]

IFC for relational databases - ifcSQL

The idea behind storing IFC-data in a database: [%C3%AEfcSQL2_Bock] What could be a way to store IFC-data in a relational database? Strategy no. 1: Store every IFC-File in a binary large object field. (-) no advantage over files (-) not searchable (-) no rule checking Strategy no. 2: Store every IFC-STEP-line in a text-field. (-) not searchable (-) no rule checking Strategy no. 3: Store every not abstract Entity-classes (over 600) in its own table. Same with enumerations. (+) high…

Store, modify and retrieve ifc-data with ifcSQL

This is a picture of a prototype of ifcSQL: [ifc_SQL_tables_Bock_part1] [ifc_SQL_tables_Bock_part2] [ifc_SQL_tables_Bock_part3] (A) The table in namespace (schema) “ifcDocumentation” is currently a placeholder for aditional html-Documentation of Entities, Types, etc. (B) The tables in namespace “ifcInstance” contains ifc-data from many projects or libraries with rule-control by DML-trigger. The table EntityVariableName is used for storing variables of programming-code like IfcScript from @j…