如何学习数据库架构... Oracle

本文介绍了如何学习数据库架构... 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结合使用 [ ^ ].从数据库生成模型，您就有可以使用的数据库图. 在寻找免费工具时，我发现了一个 www.oracle/technetwork/developer-tools/datamodeler/overview/index.html [ ^ ].我似乎可以导入数据库.至少有一个关于它的演示.您可以使用Google搜索其他工具. 我不确定在某些原因无法访问数据库时可以做什么.手动分析可能是不得已的方法.自己在Visio之类的工具中绘制图表，或使用优质的旧铅笔和纸:) 希望该工具或实体框架可以有所帮助. 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 www.oracle/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.