Optimized storage and query of multi-value properties is enabled by generating a base table for single value properties associated with a user-defined schema and a number of row-based tables for each different type of multi-value properties. By combining multi-value properties into row-based tables or even into compatible type tables, a number of tables to be created for a database system such as SQL system is reduced at the same time optimizing create/read/update/delete operations.