ER/studio的最基础操作:创建数据库模型,生成oracle的sql文件

今天刚接触了下ER/Studio 问了怕以后忘记,现在先记录下。 :P
1.进入ER/Studio,然后创建一个model。
2.右键点击左侧树结构中Main Model下面Entities,选择New Entity,创建一张表
3.在Attributes标签下,点击Add创建你的列。(default Column Name为列名),如果想要设置主键的话把下方右侧的“Add to Primary Key”勾选上。
4.如果表与表之间要有外键关联。要用下图上的图标,方向:先点父表,再点子表
5.最后我们把建好的model变为sql。右键点击右侧树结构的Logical,选择第二个“Generate Physical Model..”然后点击yes。填入第一个text中的要给此physical model起的名字,然后选中下拉框你要的数据库,例如“oracle 11g”。其他的不用管,直接next-->finish。这样就在右侧会出现你创建的physical model结构
6.选中你要导出sql的physical model,点击最上方菜单栏的“Datebase”项,选择第二个“Generate Datebase..”,然后选择你要把sql文件存储的位置。点击next-->finish,就可去相应路径下找到XXX.sql
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Data Modeling Made Simple with Embarcadero ER/Studio Data Architect: Adapting to Agile Data Modeling in a Big Data World Build a working knowledge of data modeling concepts and best practices, along with how to apply these principles with ER/Studio. This second edition includes numerous updates and new sections including an overview of ER/Studio's support for agile development, as well as a description of some of ER/Studio's newer features for NoSQL, such as MongoDB's containment structure. You will build many ER/Studio data models along the way, applying best practices to master these ten objectives: Know why a data model is needed and which ER/Studio models are the most appropriate for each situation Understand each component on the data model and how to represent and create them in ER/Studio Know how to leverage ER/Studio's latest features including those assisting agile teams and forward and reverse engineering of NoSQL databases Know how to apply all the foundational features of ER/Studio Be able to build relational and dimensional conceptual, logical, and physical data models in ER/Studio Be able to apply techniques such as indexing, transforms, and forward engineering to turn a logical data model into an efficient physical design Improve data model quality and impact analysis results by leveraging ER/Studio's lineage functionality and compare/merge utility Be able to apply ER/Studio's data dictionary features Learn ways of sharing the data model through reporting and through exporting the model in a variety of formats Leverage ER/Studio's naming functionality to improve naming consistency, including the new Automatic Naming Translation feature. This book contains four sections: Section I introduces data modeling and the ER/Studio landscape. Learn why data modeling is so critical to software development and even more importantly, why data modeling is so critical to understanding the business. You will learn about the newest features in ER/Studio (including features on big data and agile), and the ER/Studio environment. By the end of this section, you will have created and saved your first data model in ER/Studio and be ready to start modeling in Section II! Section II explains all of the symbols and text on a data model, including entities, attributes, relationships, domains, and keys. By the time you finish this section, you will be able to 'read' a data model of any size or complexity, and create a complete data model in ER/Studio. Section III explores the three different levels of models: conceptual, logical, and physical. A conceptual data model (CDM) represents a business need within a defined scope. The logical data model (LDM) represents a detailed business solution, capturing the business requirements without complicating the model with implementation concerns such as software and hardware. The physical data model (PDM) represents a detailed technical solution. The PDM is the logical data model compromised often to improve performance or usability. The PDM makes up for deficiencies in our technology. By the end of this section you will be able to create conceptual, logical, and physical data models in ER/Studio. Section IV discusses additional features of ER/Studio. These features include data dictionary, data lineage, automating tasks, repository and portal, exporting and reporting, naming standards, and compare and merge functionality. Table of Contents SECTION I Foundation CHAPTER 1 Data Model Overview CHAPTER 2 ER/Studio Functionality CHAPTER 3 ER/Studio Landscape SECTION II Data Model Objects CHAPTER 4 Entities CHAPTER 5 Submodels CHAPTER 6 Attributes and Domains CHAPTER 7 Relationships SECTION III Conceptual, Logical, and Physical Data Models CHAPTER 8 Conceptual Data Models CHAPTER 9 Logical Data Models CHAPTER 10 Physical Data Models SECTION IV Additional ER/Studio Features CHAPTER 11 Data Dictionary CHAPTER 12 Data Lineage CHAPTER 13 Importing, Exporting, Printing, and Reporting CHAPTER 14 Naming Standards CHAPTER 15 Compare/Merge Utility CHAPTER 16 Features for Agile Teams and Continuous Improvement APPENDIX A References APPENDIX B Answers to Exercises APPENDIX C Glossary APPENDIX D ER/Studio Commands Quick Reference
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值