如何学习数据库架构... Oracle [英] How to study database schema... Oracle

问题描述

我在Oracle中有一个具有前端和后端的应用程序.
但是，到目前为止，我只提供了Oracle制作的数据库模式.没有前端.我如何研究这种模式..我所看到的只是表，视图触发器等.也没有可用的数据库图，这样我就可以看到如何链接不同的表...请指导...

I have a application with front end and backend in Oracle.
However, as of now i am just provided with database schema made in Oracle. No front end. How do i study this schema.. all i see is tables,views triggers...etc.. also no database diagram is available so that i can see how different tables are linked... Please guide...

推荐答案

如果您使用的是Visual Studio 4.0(不确定3.5)，并且您有足够的权限访问数据库，则可以将Entity Framework用于它.在此页面上进行了说明将实体框架与Oracle Data Provider for .NET结合使用 [ ^ ].从数据库生成模型，您就有可以使用的数据库图.

在寻找免费工具时，我发现了一个 http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html [

If you are using Visual Studio 4.0 (not sure about 3.5) and you have enough right to access the database, you could use the Entity Framework for it. It is discribed on this page Use Entity Framework with Oracle Data Provider for .NET[^]. Generate a model from the database and you have a database diagram you could use.

While searching for a free tool I found this one http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html[^]. I looks like it is possible to import a database. At least there is a demo about it. You could Google to search for other tools.

I''m not sure what you could do when there is some reason that you can''t reach the database. Analysing it manually could be a last resort. Draw the diagram yourself in a tool like Visio or use good old pencil and paper :)

Hopefully the tool or entity framework could be of help.

这篇关于如何学习数据库架构... Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！