-
公开(公告)号:US20070192343A1
公开(公告)日:2007-08-16
申请号:US11357402
申请日:2006-02-16
IPC分类号: G06F7/00
CPC分类号: G06F17/30442 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99944
摘要: A method is disclosed for modeling application-level objects in terms of join graphs defined over tables containing structured data residing in a relational database. In accordance with the disclosed metamodel, each object is modeled logically as a join graph. A query received from an application that requests the return of objects meeting certain conditions is reformulated to refer to the metamodel. The metamodel includes an index structure having a plurality of indexes and a set of join conditions that specify relationships between the indexes. Some series of join conditions form join paths, such that each join path originates on an anchor table and ends on a table corresponding to one of the plurality of indexes. The metamodel further includes at least one view representing a subgraph of the join graph having at least one anchor table as a key.
摘要翻译: 公开了一种用于根据驻留在关系数据库中的包含结构化数据的表定义的连接图来对应用程序级对象进行建模的方法。 根据所公开的元模型,每个对象被逻辑地建模为连接图。 从请求返回满足某些条件的对象的应用程序接收到的查询被重新配置为引用元模型。 元模型包括具有多个索引的索引结构和指定索引之间的关系的一组连接条件。 一些连接条件的一系列形成连接路径,使得每个连接路径起始于锚定表,并且结束于与多个索引之一相对应的表。 元模型还包括表示具有至少一个锚表作为关键字的连接图的子图的至少一个视图。
-
公开(公告)号:US20070136323A1
公开(公告)日:2007-06-14
申请号:US11302855
申请日:2005-12-13
申请人: Thomas Zurek , Stefan Dipper , Stefan Unnebrink , Klaus Nagel , Erich Marschall , Franz Faerber , Guenter Radestock , Christian Bartholomae
发明人: Thomas Zurek , Stefan Dipper , Stefan Unnebrink , Klaus Nagel , Erich Marschall , Franz Faerber , Guenter Radestock , Christian Bartholomae
IPC分类号: G06F7/00
CPC分类号: G06F17/30592 , Y10S707/99943
摘要: Systems and techniques for mapping data structures in a data processing environment to help ensure the accessibility of stored information. In one implementation, an article includes a machine-readable medium storing instructions. The instructions are operable to cause one or more machines to perform operations. The operations include receiving a first data storage schema in which a characteristic in a first dimension table is mapped by a first table and a second table and generating a second data storage schema. The first table maps the characteristic to a first object that include attributes to which time information is irrelevant to data processing activities and the second table maps the characteristic to a second object that include attributes to which time information is relevant to data processing activities. The second data storage schema includes a fact table including at least some facts drawn from the first data storage schema and a second dimension table that includes at least some characteristics drawn from at least one of the first object and the second object.
摘要翻译: 用于在数据处理环境中映射数据结构的系统和技术,以帮助确保存储信息的可访问性。 在一个实现中,物品包括存储指令的机器可读介质。 该指令可操作以使一个或多个机器执行操作。 操作包括接收第一数据存储模式,其中通过第一表和第二表映射第一维表中的特征,并生成第二数据存储模式。 第一表将特征映射到第一对象,其包括时间信息与数据处理活动无关的属性,第二表将特征映射到第二对象,第二对象包括时间信息与数据处理活动相关的属性。 第二数据存储模式包括包括从第一数据存储模式中提取的至少一些事实的事实表以及包括从第一对象和第二对象中的至少一个绘制的至少一些特征的第二维度表。
-
公开(公告)号:US20070073658A1
公开(公告)日:2007-03-29
申请号:US11239720
申请日:2005-09-29
IPC分类号: G06F17/30
CPC分类号: G06F17/30501 , Y10S707/99933
摘要: A query having multiple parts may be processed to form an intermediate results set. This intermediate results set may be partitioned into a plurality of groups. Thereafter, the groups may be sorted into a plurality of containers so that each container contains data sufficient to calculate one requested result in the multipart query. Related techniques, apparatuses, systems, and computer program products are also described.
摘要翻译: 可以处理具有多个部分的查询以形成中间结果集。 该中间结果集可以被划分成多个组。 此后,组可以被分类成多个容器,使得每个容器包含足以在多部分查询中计算一个请求结果的数据。 还描述了相关技术,装置,系统和计算机程序产品。
-
-