Oracle SQL Developer Data Modeler 4.0 使用手册

需积分: 10 119 浏览量更新于2024-07-20 收藏 2.45MB PDF 举报

"Oracle SQL Developer Data Modeler 用户指南，版本4.0，E48205-04，发布于2014年2月。该文档由Chuck Murray撰写，是Oracle公司的一款数据建模和数据库设计工具的使用手册，提供了一种环境来捕获、建模、管理和利用元数据。" Oracle SQL Developer Data Modeler 是一个强大的工具，专门用于数据建模和数据库设计。此工具的核心功能包括以下几个方面： 1. **概念建模**：在概念层面上，Data Modeler 允许用户创建业务实体和它们之间的关系，这些实体可以是组织中的部门、产品、客户等。这有助于理解数据的高层次结构，而无需涉及具体的数据库表结构。 2. **逻辑建模**：在此阶段，模型从概念层转化为更具体的逻辑结构，包括表、字段、主键、外键和其他约束。用户可以定义数据类型、长度、精度等属性，确保数据的一致性和完整性。 3. **物理建模**：在物理层，Data Modeler 考虑到特定数据库系统的特性，如索引、分区、存储选项等。它能生成针对不同数据库平台（如 Oracle、MySQL 等）的DDL（Data Definition Language）脚本，用于实际数据库的创建。 4. **逆向工程**：Data Modeler 可以从现有的数据库中提取模型，帮助用户理解现有结构或进行重构工作。这有助于维护和升级现有系统。 5. **数据模型管理**：工具提供了版本控制和比较功能，以便跟踪模型的变化并解决冲突。此外，还支持团队协作，让多个设计师可以同时处理同一个项目。 6. **元数据管理**：Data Modeler 支持元数据的导入和导出，使得数据模型可以在不同的系统和工具之间共享和集成。 7. **性能分析**：用户可以评估模型的性能，通过模拟查询来预测潜在的瓶颈，从而优化数据库设计。 8. **报告和图表**：提供多种报告和图表选项，方便用户可视化地展示模型，便于沟通和演示。 9. **兼容性**：与Oracle SQL Developer 整合，提供了一站式的数据库开发环境，支持多种数据库平台，不仅限于 Oracle 数据库。 10. **许可证和法律条款**：文档指出，软件及其相关文档受到版权保护，并受使用和披露限制的许可协议约束。使用该软件时应遵守许可协议规定，未经许可，不得进行反向工程、反编译或拆解。总而言之，Oracle SQL Developer Data Modeler 是一款全面的数据建模工具，旨在简化数据库设计过程，提高效率，并促进团队协作。其丰富的功能和对多种数据库系统的支持，使其成为数据库设计者和管理员的强大助手。

xvi

supersede or modify the terms of any separate license agreement you may have

executed with Licensor regarding such Contributions. 6. Trademarks.

This License does not grant permission to use the trade names, trademarks, service

marks, or product names of the Licensor, except as required for reasonable and

customary use in describing the origin of the Work and reproducing the content of the

NOTICE file. 7. Disclaimer of Warranty. Unless required by applicable law or agreed to

in writing, Licensor provides the Work (and each Contributor provides its

Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF

ANY KIND, either express or implied, including, without limitation, any warranties or

conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR

A PARTICULAR PURPOSE. You are solely responsible for determining the

appropriateness of using or redistributing the Work and assume any risks associated

with Your exercise of permissions under this License. 8. Limitation of Liability. In no

event and under no legal theory, whether in tort (including negligence), contract, or

otherwise, unless required by applicable law (such as deliberate and grossly negligent

acts) or agreed to in writing, shall any Contributor be liable to You for damages,

including any direct, indirect, special, incidental, or consequential damages of any

character arising as a result of this License or out of the use or inability to use the Work

(including but not limited to damages for loss of goodwill, work stoppage, computer

failure or malfunction, or any and all other commercial damages or losses), even if

such Contributor has been advised of the possibility of such damages. 9. Accepting

Warranty or Additional Liability. While redistributing the Work or Derivative Works

thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty,

indemnity, or other liability obligations and/or rights consistent with this License.

However, in accepting such obligations, You may act only on Your own behalf and on

Your sole responsibility, not on behalf of any other Contributor, and only if You agree

to indemnify, defend, and hold each Contributor harmless for any liability incurred by,

or claims asserted against, such Contributor by reason of your accepting any such

warranty or additional liability. END OF TERMS AND CONDITIONS Appendix: How

to Apply Apache License to Your Work To apply the Apache License to your work,

attach the following boilerplate notice, with the fields enclosed by brackets "[]"

replaced with your own identifying information. (Don't include the brackets!) The text

should be enclosed in the appropriate comment syntax for the file format. We also

recommend that a file or class name and description of purpose be included on the

same "printed page" as the copyright notice for easier identification within third-party

archives. Copyright [yyyy] [name of copyright owner] Licensed under the Apache

License, Version 2.0 (the "License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or

agreed to in writing, software distributed under the License is distributed on an "AS

IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either

express or implied. See the License for the specific language governing permissions

and limitations under the License.

Log4j 1.2.9

This program contains Log4j 1.2.9, which has the following associated attribution text:

Foundation. All rights * reserved. * * Redistribution and use in source and binary

forms, with or without * modification, are permitted provided that the following

conditions * are met: * * 1. Redistributions of source code must retain the above

Redistributions in binary form must reproduce the above copyright * notice, this list of

conditions and the following disclaimer in * the documentation and/or other materials

provided with the * distribution. * * 3. The end-user documentation included with the

xvii

redistribution, * if any, must include the following acknowledgment: * "This product

includes software developed by the * Apache Software Foundation (Link1 /)." *

Alternately, this acknowledgment may appear in the software itself, * if and wherever

such third-party acknowledgments normally appear. * * 4. The names "Apache" and

"Apache Software Foundation" must * not be used to endorse or promote products

derived from this * software without prior written permission. For written *

permission, please contact apache@apache.org. * * 5. Products derived from this

software may not be called "Apache", * nor may "Apache" appear in their name,

without prior written * permission of the Apache Software Foundation. * * THIS

SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED *

WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES

* OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE *

DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION

OR * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,

* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT

NOT * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;

LOSS OF * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER

CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,

STRICT LIABILITY, * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)

ARISING IN ANY WAY OUT * OF THE USE OF THIS SOFTWARE, EVEN IF

ADVISED OF THE POSSIBILITY OF * SUCH DAMAGE. *

===============================================================

===== * * This software consists of voluntary contributions made by many *

individuals on behalf of the Apache Software Foundation. For more * information on

the Apache Software Foundation, please see * <Link2 />. * * Portions of this software

are based upon public domain software * originally written at the National Center for

Supercomputing Applications, * University of Illinois, Urbana-Champaign. */

POI 2.5.1

This program contains POI 2.5.1, which has the following associated attribution text:

The following applies to all products licensed under the Apache 2.0 License: You may

not use the identified files except in compliance with the Apache License, Version 2.0

(the "License.") You may obtain a copy of the License at

http://www.apache.org/

. A

copy of the license is also reproduced below. Unless required by applicable law or

agreed to in writing, software distributed under the License is distributed on an "AS

IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either

express or implied. See the License for the specific language governing permissions

and limitations under the License. Apache License Version 2.0, January 2004 Link2 /

TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1.

Definitions. "License" shall mean the terms and conditions for use, reproduction, and

distribution as defined by Sections 1 through 9 of this document. "Licensor" shall mean

the copyright owner or entity authorized by the copyright owner that is granting the

License. "Legal Entity" shall mean the union of the acting entity and all other entities

that control, are controlled by, or are under common control with that entity. For the

purposes of this definition, "control" means (i) the power, direct or indirect, to cause

the direction or management of such entity, whether by contract or otherwise, or (ii)

ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial

ownership of such entity. "You" (or "Your") shall mean an individual or Legal Entity

exercising permissions granted by this License. "Source" form shall mean the preferred

form for making modifications, including but not limited to software source code,

documentation source, and configuration files. "Object" form shall mean any form

resulting from mechanical transformation or translation of a Source form, including

but not limited to compiled object code, generated documentation, and conversions to

other media types. "Work" shall mean the work of authorship, whether in Source or

xviii

Object form, made available under the License, as indicated by a copyright notice that

is included in or attached to the work (an example is provided in the Appendix

below). "Derivative Works" shall mean any work, whether in Source or Object form,

that is based on (or derived from) the Work and for which the editorial revisions,

annotations, elaborations, or other modifications represent, as a whole, an original

work of authorship. For the purposes of this License, Derivative Works shall not

include works that remain separable from, or merely link (or bind by name) to the

interfaces of, the Work and Derivative Works thereof. "Contribution" shall mean any

work of authorship, including the original version of the Work and any modifications

or additions to that Work or Derivative Works thereof, that is intentionally submitted

to Licensor for inclusion in the Work by the copyright owner or by an individual or

Legal Entity authorized to submit on behalf of the copyright owner.

For the purposes of this definition, "submitted" means any form of electronic, verbal,

or written communication sent to the Licensor or its representatives, including but not

limited to communication on electronic mailing lists, source code control systems, and

issue tracking systems that are managed by, or on behalf of, the Licensor for the

purpose of discussing and improving the Work, but excluding communication that is

conspicuously marked or otherwise designated in writing by the copyright owner as

"Not a Contribution." "Contributor" shall mean Licensor and any individual or Legal

Entity on behalf of whom a Contribution has been received by Licensor and

subsequently incorporated within the Work. 2. Grant of Copyright License. Subject to

the terms and conditions of this License, each Contributor hereby grants to You a

perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright

license to reproduce, prepare Derivative Works of, publicly display, publicly perform,

sublicense, and distribute the Work and such Derivative Works in Source or Object

form. 3. Grant of Patent License. Subject to the terms and conditions of this License,

each Contributor hereby grants to You a perpetual, worldwide, non-exclusive,

no-charge, royalty-free, irrevocable (except as stated in this section) patent license to

make, have made, use, offer to sell, sell, import, and otherwise transfer the Work,

where such license applies only to those patent claims licensable by such Contributor

that are necessarily infringed by their Contribution(s) alone or by combination of their

Contribution(s) with the Work to which such Contribution(s) was submitted. If You

institute patent litigation against any entity (including a cross-claim or counterclaim in

a lawsuit) alleging that the Work or a Contribution incorporated within the Work

constitutes direct or contributory patent infringement, then any patent licenses

granted to You under this License for that Work shall terminate as of the date such

litigation is filed. 4. Redistribution. You may reproduce and distribute copies of the

Work or Derivative Works thereof in any medium, with or without modifications, and

in Source or Object form, provided that You meet the following conditions: (a) You

must give any other recipients of the Work or Derivative Works a copy of this License;

and (b) You must cause any modified files to carry prominent notices stating that You

changed the files; and (c) You must retain, in the Source form of any Derivative Works

that You distribute, all copyright, patent, trademark, and attribution notices from the

Source form of the Work, excluding those notices that do not pertain to any part of the

Derivative Works; and (d) If the Work includes a "NOTICE" text file as part of its

distribution, then any Derivative Works that You distribute must include a readable

copy of the attribution notices contained within such NOTICE file, excluding those

notices that do not pertain to any part of the Derivative Works, in at least one of the

following places: within a NOTICE text file distributed as part of the Derivative

Works; within the Source form or documentation, if provided along with the

Derivative Works; or, within a display generated by the Derivative Works, if and

wherever such third-party notices normally appear. The contents of the NOTICE file

are for informational purposes only and do not modify the License. You may add Your

own attribution notices within Derivative Works that You distribute, alongside or as

an addendum to the NOTICE text from the Work, provided that such additional

xix

attribution notices cannot be construed as modifying the License. You may add Your

own copyright statement to Your modifications and may provide additional or

different license terms and conditions for use, reproduction, or distribution of Your

modifications, or for any such Derivative Works as a whole, provided Your use,

reproduction, and distribution of the Work otherwise complies with the conditions

stated in this License. 5. Submission of Contributions.

Unless You explicitly state otherwise, any Contribution intentionally submitted for

inclusion in the Work by You to the Licensor shall be under the terms and conditions

of this License, without any additional terms or conditions. Notwithstanding the

above, nothing herein shall supersede or modify the terms of any separate license

agreement you may have executed with Licensor regarding such Contributions. 6.

Trademarks. This License does not grant permission to use the trade names,

trademarks, service marks, or product names of the Licensor, except as required for

reasonable and customary use in describing the origin of the Work and reproducing

the content of the NOTICE file. 7. Disclaimer of Warranty. Unless required by

applicable law or agreed to in writing, Licensor provides the Work (and each

Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT

WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied,

including, without limitation, any warranties or conditions of TITLE,

NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR

PURPOSE. You are solely responsible for determining the appropriateness of using or

redistributing the Work and assume any risks associated with Your exercise of

permissions under this License. 8. Limitation of Liability. In no event and under no

legal theory, whether in tort (including negligence), contract, or otherwise, unless

required by applicable law (such as deliberate and grossly negligent acts) or agreed to

in writing, shall any Contributor be liable to You for damages, including any direct,

indirect, special, incidental, or consequential damages of any character arising as a

result of this License or out of the use or inability to use the Work (including but not

limited to damages for loss of goodwill, work stoppage, computer failure or

malfunction, or any and all other commercial damages or losses), even if such

Contributor has been advised of the possibility of such damages. 9. Accepting

Warranty or Additional Liability. While redistributing the Work or Derivative Works

thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty,

indemnity, or other liability obligations and/or rights consistent with this License.

However, in accepting such obligations, You may act only on Your own behalf and on

Your sole responsibility, not on behalf of any other Contributor, and only if You agree

to indemnify, defend, and hold each Contributor harmless for any liability incurred by,

or claims asserted against, such Contributor by reason of your accepting any such

warranty or additional liability. END OF TERMS AND CONDITIONS APPENDIX:

How to apply the Apache License to your work. To apply the Apache License to your

work, attach the following boilerplate notice, with the fields enclosed by brackets "[]"

replaced with your own identifying information. (Don't include the brackets!) The text

should be enclosed in the appropriate comment syntax for the file format. We also

recommend that a file or class name and description of purpose be included on the

same "printed page" as the copyright notice for easier identification within third-party

archives. Copyright [yyyy] [name of copyright owner] Licensed under the Apache

License, Version 2.0 (the "License"); you may not use this file except in compliance

with the License. You may obtain a copy of the License at Link3 Unless required by

applicable law or agreed to in writing, software distributed under the License is

distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF

ANY KIND, either express or implied. See the License for the specific language

governing permissions and limitations under the License. Oracle must give recipients

a copy of this license (doc).

剩余169页未读，继续阅读

qxpengbj

粉丝: 0
资源: 1

Oracle SQL Developer Data Modeler 4.0 使用手册

Toad Data Modeler使用手册

ERWin标准操作手册.ppt

toad中文手册

toad data modeler中文手册怎么

aiifusion erwin data modeler下载

erwin data modeler 2020 r1 (64-bit) 12275

fsdm erwin庐 data modeler file

Datablau Data Modeler

navicat data modeler

navicat data modeler 3

最新资源