We added more parameters for generating the HTML or PDF documentation. We renamed the virtual relation to relationship, and we refactored the menu.Īutomation Scripts for generating HTML or PDF Documentation In version 9 we added a text pane in the result pane: Whenever you design a collection, the collection validation rule gets updated. If not, we deduce the collection structure by introspecting a few documents. Whenever a validation rule is defined, we reverse engineer the collection structure using it. We do diagrams and schema validation rules for MongoDB. MySql, MariaDb, Oracle, SqlServer, AzureSQL, Snowflake, Redshift, Vertica, Sqlite, Exasol, SAPHana, GoogleBigQuery, Databricks, Cassandra Here are the current databases where this feature is implemented: This feature is available for all databases where we found a way to generate the table DDL. This allows us to reverse engineer all parameters, like collation, partition keys, etc., and more table-specific parameters - like temporal tables, etc. The tags can be used in the automation scripts, and in the logical design for the entity or field’s physical name. The DDL is generated using commands like ‘Show create table’, or using a dedicated procedure (SqlServer).īesides text, the table, column, and foreign keys can use key/value comment tags. Now, we are using a DDL parser that can reverse engineer the schema from the CREATE TABLE DDL statement. In the previous versions, we reverse-engineer the schema by reading the metadata from system tables.įor most of the databases, we call methods from the JDBC driver, and only for a few of them did we execute direct queries on the system tables. We continue to improve the logical design also in the upcoming releases. The logical model can be converted to a physical model and synchronized with the database. There are also supported different relation types: Sub-entities can be created by adding a field of type sub-entity to a table. The logical design is database-independent, with entities and sub-entities: 支持多種關聯式資料庫 (relational databases):PostgreSQL, SQL Server, MySQL, MariaDB, Oracle, DB2, Sybase, Informix SQLite 以及 NoSQL MongoDB, Cassandra, HBase, Hive
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |