![]() ![]() Maintain foreign keys to ensure referential integrity in database designs.ĭisplay mappings between logical entities and attributes to their implementation across physical designs.Īutomate model reviews and enforce high-quality data standards by validating for missing object definitions, unused domains, identical indexes and circular relationships. Represent master data and transactional concepts with multiple entities and relationships, such as products, customers, and vendors.Īllow creation of multi-leveled submodels, merge submodel properties across existing models and synchronize submodel hierarchies.Īssign a naming standards template to models, submodels, entities and attributes for automatic application between logical and physical models. Easily apply design changes with formulated alter code.ĭefine and enforce standard data elements, naming standards and reference values for use across and between data models.Įnable advanced, bidirectional comparisons and merges of model and database structures. Construct graphical models from existing database or schema, for both relational and big data platforms. Generate physical data models from existing database designs. Generate models from existing databases: With the reverse engineering process, pgModeler can create reliable models based upon existing databases. Extensive platform support is enabled through native and database-specific ODBC connections. Export models in five different ways: pgModeler can export the models to a SQL script, to a PNG image, to an SVG file, in the form of a data dictionary in HTML format, or directly to a PostgreSQL server. Access and manage models for multiple relational and big data platforms, both on premises and in the cloud. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |