sentence: properties and functions standard sql properties transbase supports all important functions of the sql standard : extensive transaction concept , complex queries with included subqueries , referential integrity ( primary keys , foreign keys , check constraints and others ) , set operations , updatable views , trigger , interface for c , c++ , java / jdbc , php , odbc export and import of data as well as database schema .