Training data architects: designing and modeling information systems using ER / Studio
It is not the first generation of schoolchildren and students who have mastered the basics and subtleties of computer software development technologies using the example of Turbo Pascal, Delphi or RAD Studio. But the list of “academic” licenses intended for training IT specialties is not limited only to programming languages ​​and integrated development environments of applications. Today we will talk about one more of our product - Embarcadero ER / Studio and its application in the educational process
Database managers know how complex the processes of documenting, interpreting and achieving complete control over the corporate data environment are.
To solve these problems, many companies use Embarcadero ER / Studio - a comprehensive solution for visual database modeling, software engineering, business process modeling with support for various industry standards. It is an industry-leading data modeling and information architecture design that is used by a large number of the world's largest companies to discover, document and efficiently manage their information resources based on the data model and rebuild the data architecture in accordance with changing requirements.
')
For professionals in the field of work with data, ER / Studio is an effective, simple and convenient set of tools and tools for collaborating data management specialists that allows you to create and maintain large corporate databases and data warehouses. The functions provided in the system automate routine modeling tasks and allow you to visualize, therefore, more quickly understand, analyze and optimize the structure of large databases and data warehouses. Included in the reporting and interaction tools contribute to the application of organizational standards and the achievement of high levels of performance.
ER / Studio Enterprise is a complex product and includes the following tools:
The server model management system and the Internet portal make this solution an effective tool for sharing, documenting and publishing models and metadata in distributed teams.
ER / Studio Data Architect is an essential part of ER / Studio, a visual modeling application designed for independent logical analysis and design of data architecture, as well as for physical design and building database instances for specific DBMS.
ER / Studio Data Architect is recommended for use as a practical tool for teaching on topics related to databases and multidimensional information repositories.
Using the example of working with ER / Studio Data Architect, students will be able to master in practice:
Practice shows, and leading analytical companies predict a strengthening of this trend in the coming years, that the vast majority of companies use more than two different DBMS platforms in their work. And no matter what caused it - the presence of long-lived inherited databases or the company's initiatives to find and use corporate data as an organizational resource and asset, the IT world is very interested in having specialists and architects of the database well-prepared for work in multiplatform environments. It is with ER / Studio that the opportunities for training specialists of this level increase many times.
The most “full” feature of the edition is ER / Studio Enterprise. This edition is distinguished by the simultaneous support of almost all existing types of DBMS (including not necessarily relational ones), including all versions of the same DBMS. ER / Studio Enterprise also added tools for export / import and exchange of metadata with other modeling tools from leading manufacturers.
ER / Studio Enterprise is recommended for training specialists in managing large corporate databases and data warehouses.
In addition to the topics listed in the ER / Studio Data Architect section, this tool allows you to train:
For architects and software developers, ER / Studio Enterprise includes ER / Studio Software Architect, an object-oriented modeling tool for application architects that allows you to visually design and analyze complex software applications.
With the help of this tool, students will practically learn:
ER / Studio Enterprise also includes ER / Studio Business Architect - this is a conceptual modeling tool designed to simulate business processes and their use of data. The convenience of a graphical editor and the rich semantics of the BPMN standard allow ER / Studio Business Architect business users to model interactions between processes, people and data.
This tool allows students to study:
ER / Studio is based on fundamental technologies for describing and designing data, allowing not only to familiarize students with them, but also to demonstrate the whole range of related perspectives and modern technologies in the field of computer data processing in the range from mobile applications to global corporate management systems, including ER / Studio allows you to explore the support of enterprise-class strategic systems, including Teradata, Netezza and Greenplum, as well as the Big Data platform for Hadoop, giving a practical basis for students to learn theme "Big Data."
References:
ER / Studio description in Russian www.embarcadero.com/ru/products/er-studio
Description of editions of ER / Studio www.embarcadero.com/ru/products/er-studio/product-editions
Trial version downloads.embarcadero.com/free/er-studio
Database managers know how complex the processes of documenting, interpreting and achieving complete control over the corporate data environment are.
To solve these problems, many companies use Embarcadero ER / Studio - a comprehensive solution for visual database modeling, software engineering, business process modeling with support for various industry standards. It is an industry-leading data modeling and information architecture design that is used by a large number of the world's largest companies to discover, document and efficiently manage their information resources based on the data model and rebuild the data architecture in accordance with changing requirements.
')
For professionals in the field of work with data, ER / Studio is an effective, simple and convenient set of tools and tools for collaborating data management specialists that allows you to create and maintain large corporate databases and data warehouses. The functions provided in the system automate routine modeling tasks and allow you to visualize, therefore, more quickly understand, analyze and optimize the structure of large databases and data warehouses. Included in the reporting and interaction tools contribute to the application of organizational standards and the achievement of high levels of performance.
ER / Studio Enterprise is a complex product and includes the following tools:
- ER / Studio Data Architect,
- ER / Studio Business Architect,
- ER / Studio Software Architect,
- ER / Studio Repository, CONNECT.
The server model management system and the Internet portal make this solution an effective tool for sharing, documenting and publishing models and metadata in distributed teams.
ER / Studio Data Architect is an essential part of ER / Studio, a visual modeling application designed for independent logical analysis and design of data architecture, as well as for physical design and building database instances for specific DBMS.
ER / Studio Data Architect is recommended for use as a practical tool for teaching on topics related to databases and multidimensional information repositories.
Using the example of working with ER / Studio Data Architect, students will be able to master in practice:
- Principles and methods of database design,
- Using ER - diagrams of various notations for designing and visualizing structures of various types of databases, including relational ones
- Reconstruction (reverse engineering), analysis and optimization of existing databases.
- DB modeling at the logical level; Comparing objects of conceptual, logical and physical models and searching for correspondences inside them for viewing.
- Decomposition and merging models to simplify working with large models
- Modeling Multidimensional Data Warehouses for OLAP and BI Systems
- Designing Database Access Strategies
- Modeling constraints and dependencies both within the database and with elements of external systems
- Design and analysis of information exchange subsystems and ETL processes
- Designing a system for protecting information in a database, managing user rights to access a database
- Analyzing and evaluating the effectiveness of various database models.
- Use in the design of the database of modern methods of providing scalability
- Building physical implementations of models based on various DBMS platforms, taking into account database performance requirements
- Creating XML schemas from logical and physical models to use models in various projects, such as SOA
Practice shows, and leading analytical companies predict a strengthening of this trend in the coming years, that the vast majority of companies use more than two different DBMS platforms in their work. And no matter what caused it - the presence of long-lived inherited databases or the company's initiatives to find and use corporate data as an organizational resource and asset, the IT world is very interested in having specialists and architects of the database well-prepared for work in multiplatform environments. It is with ER / Studio that the opportunities for training specialists of this level increase many times.
The most “full” feature of the edition is ER / Studio Enterprise. This edition is distinguished by the simultaneous support of almost all existing types of DBMS (including not necessarily relational ones), including all versions of the same DBMS. ER / Studio Enterprise also added tools for export / import and exchange of metadata with other modeling tools from leading manufacturers.
ER / Studio Enterprise is recommended for training specialists in managing large corporate databases and data warehouses.
In addition to the topics listed in the ER / Studio Data Architect section, this tool allows you to train:
- More effective diagnostics and analysis of the impact of changes based on universal mappings, data transformation tracing, corporate data dictionary and comparison and merging technologies.
- Designing real-time data reuse and collaboration through effective model management at the corporate level and the ability to publish metadata.
- Effectively share information about data models across the enterprise through the use of reporting tools and publishing metadata.
- Modern and most productive ways to share data and metadata, document and publish it for distributed workgroups, advanced corporate collaboration features such as activities and discussion threads, alerts, and subscription and rating capabilities.
- Standardize and reuse items based on data dictionaries
- Methods of working together on interdependent business requirements, projects and data models in a collective modeling environment with strict adherence to the necessary standards.
- Integration and semantic linking of embedded business definitions using a centrally managed glossary, a single corporate registry of all available data sources.
For architects and software developers, ER / Studio Enterprise includes ER / Studio Software Architect, an object-oriented modeling tool for application architects that allows you to visually design and analyze complex software applications.
With the help of this tool, students will practically learn:
- Software architecture and model-based standards development.
- Industry standard templates.
- Indicators and audit models.
- Use UML 2.0 to visualize, construct, and document artifacts of distributed object systems.
ER / Studio Enterprise also includes ER / Studio Business Architect - this is a conceptual modeling tool designed to simulate business processes and their use of data. The convenience of a graphical editor and the rich semantics of the BPMN standard allow ER / Studio Business Architect business users to model interactions between processes, people and data.
This tool allows students to study:
- BPMN standard business process modeling using standard elements such as sequences, tasks, tracks.
- Conceptual modeling for top-down database design. Perform high-level conceptual modeling using subject areas, business units, interactions, and other elements.
- Use Reports (CRUD) for modeling business processes and data objects.
- Modeling business artifacts.
ER / Studio is based on fundamental technologies for describing and designing data, allowing not only to familiarize students with them, but also to demonstrate the whole range of related perspectives and modern technologies in the field of computer data processing in the range from mobile applications to global corporate management systems, including ER / Studio allows you to explore the support of enterprise-class strategic systems, including Teradata, Netezza and Greenplum, as well as the Big Data platform for Hadoop, giving a practical basis for students to learn theme "Big Data."
References:
ER / Studio description in Russian www.embarcadero.com/ru/products/er-studio
Description of editions of ER / Studio www.embarcadero.com/ru/products/er-studio/product-editions
Trial version downloads.embarcadero.com/free/er-studio
Source: https://habr.com/ru/post/200950/
All Articles