术语问题 - 多个表中的相关记录集 [英] Terminology question - set of related records in multiple tables
问题描述
术语问题：
是否存在一组与几个表格中的密钥
值直接或间接相关的记录？例如，单个发票记录及其行
项记录 - 或 - 单个客户，客户的订单，订单行
这些订单，客户的发票，以及那些
发票的发票行。
我在想这个词可能是图表，但我是完全不确定。
谢谢，
Steve J
Terminology question:
Is there a term for a set of records related directly or indirectly by key
value in several tables? For example, a single invoice record and its line
item records -or- a single customer, the customer''s orders, the order lines
for those orders, the customer''s invoices, and the invoice lines for those
invoices.
I''m thinking the term might be graph, but I''m not at all certain of this.
Thanks,
Steve J
推荐答案
Steve Jorgensen写道：
Steve Jorgensen wrote:
术语问题：
是否存在一组与关键值直接或间接相关的记录几张桌子？例如，单个发票记录及其行项目记录 - 或者 - 单个客户，客户的订单，订单行
这些订单，客户的发票以及那些
发票的发票行。
我在想这个词可能是图表，但我完全不确定。
谢谢，
史蒂夫J
Terminology question:
Is there a term for a set of records related directly or indirectly by key
value in several tables? For example, a single invoice record and its line
item records -or- a single customer, the customer''s orders, the order lines
for those orders, the customer''s invoices, and the invoice lines for those
invoices.
I''m thinking the term might be graph, but I''m not at all certain of this.
Thanks,
Steve J
实体？
发票标题+发票项目=发票。
Entity?
Invoice Header + Invoice Items = Invoice.
2004年11月1日星期一08:36:03 +0000，Trevor Best< no **** @ besty.org.uk>写道：
On Mon, 01 Nov 2004 08:36:03 +0000, Trevor Best <no****@besty.org.uk> wrote:
Steve Jorgensen写道：
Steve Jorgensen wrote:
术语问题：
是否存在直接或间接相关的一组记录的术语按键值几个表中的值？例如，单个发票记录及其行项目记录 - 或者 - 单个客户，客户的订单，订单行
这些订单，客户的发票以及那些
发票的发票行。
我在想这个词可能是图表，但我完全不确定。
谢谢，
Steve J
Terminology question:
Is there a term for a set of records related directly or indirectly by key
value in several tables? For example, a single invoice record and its line
item records -or- a single customer, the customer''s orders, the order lines
for those orders, the customer''s invoices, and the invoice lines for those
invoices.
I''m thinking the term might be graph, but I''m not at all certain of this.
Thanks,
Steve J
实体？
发票标题+发票项目=发票。
Entity?
Invoice Header + Invoice Items = Invoice.
我正在寻找一个可以适用于任意复杂的
项目的术语，可能与他们之间的关系，但都受到限制
与某个键值的关系。它可以像发票及其行一样简单，也可以像支持多个独立公司的数据库中的一个
公司的虚拟架构一样复杂
，每个都有自己的产品目录，客户，发票等，
，不同公司的记录之间不允许重叠。
例如......
包含单个公司记录的记录集合以及适用于所有其他表格中的所有其他
记录该公司只有那家公司。
公司
* CompanyId
公司名称
产品
* ProductId
CompanyId
ProductName
（Unique CompanyId，ProductName）
/>
客户
* CustomerId
CompanyId
客户名号
（唯一CompanyId，客户名称）
发票
* InvoiceId
CompanyId
InvoiceNumber
（唯一CompanyId，InvoiceNumber）
InvoiceLine
* InvoiceLineId
CompanyId（部分）两个FK强制执行同一公司）
InvoiceId（部分FK到发票）
ProductID（部分FK到客户）
LineQty
UnitCost
I''m looking for a term that could apply to an arbitrarily complex set of
items, possibly with relationships among them, but all restricted by
relationship to a single key value somewhere. It could be as simple as an
invoice and its lines, or it could be as complex as a virtual schema for one
company in a database that supports multiple, independent companies
simultaneously, each with their own product catalog, customer, invoices, etc.,
and with no overlap allowed between records in different companies.
For example...
A collection of records comprising a single Company record and all other
records in all other tables that apply to that company and only that company.
Company
*CompanyId
CompanyName
Product
*ProductId
CompanyId
ProductName
(Unique CompanyId, ProductName)
Customer
*CustomerId
CompanyId
CustomerName
(Unique CompanyId, CustomerName)
Invoice
*InvoiceId
CompanyId
InvoiceNumber
(Unique CompanyId, InvoiceNumber)
InvoiceLine
*InvoiceLineId
CompanyId (part of both FKs to enforce same company)
InvoiceId (part FK to Invoice)
ProductID (part FK to Customer)
LineQty
UnitCost
从我的头脑中，
这是限制在元组的通用关系，其中CompanyID =
公司X
通用关系（所有关系的联合）是数据库在完全非正规化状态下看起来如何看待b $ b。 />
例如公司A有员工尼克和汤姆
公司B有员工杰里和斯科特
每家公司也都有一个地址。 />
在规范化的数据库中，你有一个表公司，对于员工和
表示地址
但是普遍关系会像这个
公司地址
EmpName
A 27 Middle St，Boston，MA，USA Nick
A 27 Middle St，Boston，MA，USA Tom
B 40 Edge St，波士顿，马萨诸塞州，美国Jerry
B 40 Edge St，波士顿，马萨诸塞州，美国Scott
所以你所描述的是通用关系的子集
来自对特定属性的特定值的选择。
例如，在这种情况下，公司= A。
问候，
Konstantinos
" Steve Jorgensen" <无**** @ nospam.nospam>在消息中写道
news：s1 ******************************** @ 4ax.com ...
From the top of my head,
this is the universal relation restricted to tuples where CompanyID =
Company X
The universal relation (union of all relations) is how the database would
look in a completely unormalized state.
for instance Company A has Employees Nick and Tom
CompanyB has Employees Jerry and Scott
Each company also has an address.
In a normalized database you would have a table Company, for Employees and
for Addresses
But the universal relation would be something like this
Company Address
EmpName
A 27 Middle St, Boston, MA, USA Nick
A 27 Middle St, Boston, MA, USA Tom
B 40 Edge St, Boston, MA, USA Jerry
B 40 Edge St, Boston, MA, USA Scott
So what you are describing is the subset of the universal relation that
results from a selection on a particular value of a particular attribute.
In this case where Company = A, for instance.
Regards,
Konstantinos
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:s1********************************@4ax.com...
2004年11月1日星期一08:36:03 +0000，Trevor Best< no **** @ besty.org.uk>
写道：
On Mon, 01 Nov 2004 08:36:03 +0000, Trevor Best <no****@besty.org.uk>
wrote:
Steve Jorgensen写道：
Steve Jorgensen wrote:
术语问题：
是否存在直接或间接相关的一组记录的术语关键
几个表的价值？例如，单个发票记录及其
行项目记录 - 或 - 单个客户，客户的订单，订单
这些订单的行，客户的发票，以及那些
发票的发票行。
我在想这个词可能是图表，但我完全不确定这个。
谢谢，
Steve J
Terminology question:
Is there a term for a set of records related directly or indirectly by
key
value in several tables? For example, a single invoice record and its
line
item records -or- a single customer, the customer''s orders, the order
lines
for those orders, the customer''s invoices, and the invoice lines for
those
invoices.
I''m thinking the term might be graph, but I''m not at all certain of
this.
Thanks,
Steve J
实体？
发票标题+发票项目=发票。
Entity?
Invoice Header + Invoice Items = Invoice.
我正在寻找一个可以适用于任意复杂的
项目的术语，可能与它们之间的关系，但所有受某种关键值限制的关系。它可以像发票及其行一样简单，也可以像支持多个独立公司的数据库中的一个公司的虚拟架构一样复杂
同时，每个都有自己的产品目录，客户，发票，
等，并且不同公司的记录之间不允许重叠。
例如...
包含单个公司记录的记录集合以及适用于该公司且仅适用于该公司的所有其他表格中的所有其他
记录。
公司
*公司名称
公司名称
产品
* ProductId
CompanyId
产品名称
（Unique CompanyId，ProductName）
客户
* CustomerId
CompanyId
客户名称
（独特的CompanyId，客户名称）
发票
* InvoiceId
CompanyId
InvoiceNumber
（独特的CompanyId，InvoiceNumber）
InvoiceLine
* InvoiceL ineId
CompanyId（执行同一公司的两个FK的一部分）
InvoiceId（部分FK到发票）
ProductID（部分FK到客户）
LineQty
UnitCost
I''m looking for a term that could apply to an arbitrarily complex set of
items, possibly with relationships among them, but all restricted by
relationship to a single key value somewhere. It could be as simple as an
invoice and its lines, or it could be as complex as a virtual schema for
one
company in a database that supports multiple, independent companies
simultaneously, each with their own product catalog, customer, invoices,
etc.,
and with no overlap allowed between records in different companies.
For example...
A collection of records comprising a single Company record and all other
records in all other tables that apply to that company and only that
company.
Company
*CompanyId
CompanyName
Product
*ProductId
CompanyId
ProductName
(Unique CompanyId, ProductName)
Customer
*CustomerId
CompanyId
CustomerName
(Unique CompanyId, CustomerName)
Invoice
*InvoiceId
CompanyId
InvoiceNumber
(Unique CompanyId, InvoiceNumber)
InvoiceLine
*InvoiceLineId
CompanyId (part of both FKs to enforce same company)
InvoiceId (part FK to Invoice)
ProductID (part FK to Customer)
LineQty
UnitCost
这篇关于术语问题 - 多个表中的相关记录集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
