数据库条目之间的关系 [英] Relation between database-entries

问题描述

大家好。



我不知道如何解决以下问题：

我有多个表，每个表都填充了不同的条目。 （所有整数）



这有点像在实验中，表中添加了不同的值。

现在我想计算这些条目之间的关系。

每个entrie代表一定的迭代，每个表中的每次迭代都有一个entrie。



随着时间的推移，我可以构建图表并查看表格中不同条目之间的关系。



它不喜欢交易市场的指数，我想知道一张图表对另一个图表有多大影响。 （举个例子，我的数据库与这些无关）





谢谢

Hello everyone

I dont know how to solve the following problem:
I have multiple Tables, each filled with different Entries. (All Integers)

It's kinda like in an experiment, where different values are added into the table.
Now I want to calculate the relation between these entries.
Each entrie stands for a certain iteration and for each iteration in each table there is one entrie.

By time I could build charts and see the relation between different entries inside the tables.

It't like the index of an exchange market, I want to know how much one chart is influencing another. (Just an example, my database has nothing to do with these)


Thanks

推荐答案

请查看我对问题和我的问题的评论。您可能需要从数据库中提取所有数据库模式： http：//en.wikipedia。 org / wiki / Database_schema [ ^ ]。



不幸的是，据我所知，模式的反映不是任何SQL标准的一部分，而是依赖于特定的数据库服务器。您需要使用某个特定服务器或拥有（或创建）一些常见的抽象层。



请参阅：http://msdn.microsoft.com/en-us/library/kcax58fh%28v=vs.110%29.aspx [ ^ ]。



看看这些开源项目：

http://dbschemareader.codeplex.com [ ^ ]，

http://schemaspy.sourceforge.net [ ^ ]。



对不起，只有第一个项目是。 NET并用C＃编写，但第二个不是;它是用Java编写的，但它非常有趣;也许它可以给你一些好主意。

-SA

Please see my comment to the question and my questions. It's likely that you need to extract all the database schema from the database: http://en.wikipedia.org/wiki/Database_schema[^].

Unfortunately, to best of my knowledge, the reflection of the schema is not a part of any SQL standard and depends on the particular database server. You would need to work with some particular server or have (or create) some common abstraction layer.

Please see: http://msdn.microsoft.com/en-us/library/kcax58fh%28v=vs.110%29.aspx[^].

Look at these open-source projects:
http://dbschemareader.codeplex.com[^],
http://schemaspy.sourceforge.net[^].

Sorry, only the first project is for .NET and written in C#, but the second one is not; it is written in Java, but it is very interesting; maybe it can give you some good ideas.

—SA

为此使用连接< br $> b $ b

可以阅读加入博客

use joins for this

can read join blogs

这篇关于数据库条目之间的关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！