Basic introduction to ERStudio
The official version of ERStudio is a set of model-driven data structure management and database design products that help enterprises discover, reuse and document data assets. Through regressible database support, the data structure has the ability to completely analyze existing data sources, and high-quality database structures can be designed and implemented according to business needs. Easy-to-read visual data structures enhance communication between business analysts and application developers. ER/Studio Enterprise also enables business and task teams to collaborate through a central repository.
ERStudio software features
ER/Studio Data Architect (ER/Studio DA) is a visual data modeling tool that can not only design and build physical databases for individual platforms, but also analyze and design logical data structures on different platforms. ER/StudioData Architect's powerful, multi-tiered design environment is ideal for database administrators, developers and data architects to build and maintain large and complex database applications. It also facilitates cross-enterprise metadata consolidation, reporting and Reuse. ER/Studio DA's continuously improved interface and intuitive and simple features make the release more efficient and easier to use, completely solving the complex problems that data modeling and CASE tools have faced in the past decade or more. This application allows you to easily establish, understand and manage the life cycle of core database design and business metadata within your enterprise.
ERStudio function introduction
1. Visual Data Lineage (visual data lineage)
Visualize where data is, how it flows and changes across the enterprise, giving users automated and flexible processing and richer metadata.
2. LDAP integration
An automated way to manage user repository access through LDAP and Active Directory integration, reducing the need to replicate user account changes across the repository security layer.
3. Enterprise architecture support
Add business process modeling and conceptual modeling to the tool's existing data modeling capabilities through EA/Studio, providing enterprise-grade data architecture support.
4. Attribute-level sub-model
This feature allows users to select specific attributes that they want to appear in each child model, making it easier for companies to manage complex models where a specific set of attributes for a specific entity is only available to a certain audience.
5. Extended DBMS support
With support for Sybase IQ 12.5 and Microsoft SQL Server 2008, ER/Studio now supports data modeling tools from all major database management systems, giving users the flexibility to work with any database type
6. Other major new features
Support for the latest database management systems (DBMS) such as Sybase IQ 12.5 and Microsoft SQL Server 2008, Lightweight Directory Access Protocol (LDAP) integration, attribute-level submodels, and object-level comparison tags.
ERStudio software highlights
1. Can be used to design and build individual platform physical databases
2. Ability to analyze and design logical data structures on different platforms
3. The multi-tier design environment is very helpful for database administrators, developers and data architects to build and maintain large and complex database applications. It also helps with the consolidation, reporting and reuse of metadata across enterprises.
4. The continuously improved interface and intuitive and simple features make the release more efficient and easier to use, completely solving the complex problems that data modeling and CASE tools have faced in the past decade or more.
5. It can be easily established within the enterprise to understand and manage the life cycle of core database design and business metadata.
6. Through regressible database support, the data structure has the ability to completely analyze existing data sources, and design and implement high-quality database structures according to business needs.
ERStudio relationship description
1. identifying relationship: 1 to many
The primary key of the parent entity is the foreign key (FK1) of the child entity, and FK1 is the primary key
2. no identifying, mandatory relationship: 1 to many
The primary key of the parent entity is the foreign key (FK1) of the child entity, and FK1 is not empty.
3. no identifying, optional relationship: 1 to many
The primary key of the parent entity is the foreign key (FK1) of the child entity, and Fk1 can be empty.
4. one-to-one relationship: 1 to 1.
The primary key of the parent entity is the foreign key (FK1) of the child entity, and FK1 can be empty.
5. non-specific relationship: many-to-many
(Relationship not recommended) The parent entity and child entity have a many-to-many relationship. In fact, ER studio will automatically generate an intermediate table.
ERStudio installation method
1. Download the ERStudio official version software package from Huajun Software Park, unzip it and find the ERStudio_Setup.exe installation program, click next
2. Click the "Next" button to enter the "License Agreement" page. You must agree to the agreement to continue the installation. It is strongly recommended that you close all other running programs before installation.
3. You need to enter the name of the company. Enter it in the second column and click next.
4. You will be prompted for an installation address. You can save the software to the following address: C:Program Files (x86)EmbarcaderoERStudio8.0
5. Please specify a repository server
The installer cannot detect any existing Embarcadero repository servers on the network. If you wish to specify a Repository Server for use with ER/Studio, please enter the server name as follows "[NONE]"
6. Check Create a desktop shortcut to create a shortcut on your desktop.
7. You can also choose the accessory items created during the installation process, such as creating a shortcut: ERStudio8.0
8. Please select the default symbols and visual styles
Please select the default symbol type used in your ER/Studio models, as well as the type to apply the visual style. These settings can be modified later in ER/Studio
9. Here is the software installation content viewing interface. Click install to start the installation.
10. When the following prompt appears, it means that the installation of ERStudio has ended. You can click Finish to exit.
ERStudio update log
1. Fix bugs in the previous version
2. Optimize some functions
Huajun editor recommends:
ERStudio has always been commonly used by most netizens, and its dominance in the minds of netizens can be seen. It is strongly recommended that users download ERStudio and use it. Come to Huajun Software Park to download it. In addition, there areFuture list pricing,Fang Guanjia ERP real estate agency management software,Southern total station transmission software,Aiyifang login platform,Changfeng rental softwareAvailable for download.
it works
it works
it works