专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

11. 发明申请

US20060136469A1 Creating a logical table from multiple differently formatted physical tables having different access methods 有权
标题翻译：从具有不同访问方式的多个不同格式的物理表创建逻辑表
公开(公告)号：US20060136469A1
公开(公告)日：2006-06-22
申请号：US11016203
申请日：2004-12-17
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/00
CPC分类号： G06F17/30566 , G06F17/30427 , G06F17/30545
摘要： Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.
摘要翻译：本发明的实施例提供了构建数据库抽象模型的方法，该模型包括映射到逻辑表的逻辑字段。使用从多个不同格式的物理表提取的数据构建逻辑表。逻辑表允许存储在多个数据库中的逻辑相关数据显示为来自单个表的数据。维护存储在多个不同格式的数据库中的数据之间的关系，并且将包含映射到多个数据库的多个访问方法的逻辑字段替换为映射到逻辑表的单个访问方法。为数据库抽象模型定义的数据关系被修改以反映逻辑表。

12. 发明申请

US20060129945A1 Apparatus and method for pointer drag path operations 审中-公开
标题翻译：指针拖曳操作的装置和方法
公开(公告)号：US20060129945A1
公开(公告)日：2006-06-15
申请号：US11012907
申请日：2004-12-15
申请人： Richard Dettinger , Daniel Kolz , Shannon Wenzel
发明人： Richard Dettinger , Daniel Kolz , Shannon Wenzel
IPC分类号： G06F3/00 , G06F17/00
CPC分类号： G06F3/0486 , G06F9/451
摘要： An apparatus and method for a graphical user interface allow performing operations simply by dragging a first object over a second object. One or more attributes of the second object are effectively “picked up” by virtue of dragging over the second object. In this manner, the user interface is more friendly, more intuitive, and reduces the number of pointer clicks to implement a particular function, thereby enhancing the efficiency of the user.
摘要翻译：用于图形用户界面的装置和方法允许简单地通过在第二对象上拖动第一对象来执行操作。通过拖动第二对象，第二对象的一个或多个属性被有效地“拾起”。以这种方式，用户界面更友好，更直观，并且减少了指针点击次数以实现特定功能，从而提高了用户的效率。

13. 发明申请

US20060122977A1 Techniques for managing interdependent data objects 有权
标题翻译：用于管理相互依赖的数据对象的技术
公开(公告)号：US20060122977A1
公开(公告)日：2006-06-08
申请号：US11005436
申请日：2004-12-06
申请人： Mark Brodhun , Richard Dettinger , Daniel Kolz
发明人： Mark Brodhun , Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30604 , Y10S707/955 , Y10S707/99933
摘要： A method, system and article of manufacture for managing interdependent data objects and, more particularly, for managing modifications to at least one of a plurality of interdependent data objects. One embodiment provides a computer-implemented method of managing modifications to at least one of a plurality of interdependent data objects. The method comprises receiving a request for modification of a given data object having at least one dependent data object. The method further comprises accessing a directory of dependencies containing at least one record for each of the plurality of interdependent data objects including the at least one dependent data object. Each record describes an interdependency between at least two of the interdependent data objects. A record for the at least one dependent data object describes an interdependency between the given data object and the at least one dependent data object. Using the accessed directory of dependencies, the interdependency between the given data object and the at least one dependent data object is identified. On the basis that the identified interdependency presents a possible undesired consequence if the requested modification is performed, a predefined action is performed.
摘要翻译：一种用于管理相互依赖的数据对象的方法，系统和制品，更具体地，用于管理对多个相互依赖的数据对象中的至少一个的修改。一个实施例提供了一种管理对多个相互依赖的数据对象中的至少一个的修改的计算机实现的方法。该方法包括接收对具有至少一个依赖数据对象的给定数据对象的修改请求。该方法还包括：访问包含至少一个相关数据对象的多个相互依赖的数据对象中的每个的至少一个记录的依赖项目录。每个记录描述了至少两个相互依赖的数据对象之间的相互依赖关系。至少一个依赖数据对象的记录描述给定数据对象与至少一个从属数据对象之间的相互依赖关系。使用所访问的依赖目录，识别给定数据对象与至少一个从属数据对象之间的相互依赖关系。基于所确定的相互依赖性在执行所请求的修改时呈现可能的不期望的结果，执行预定义的动作。

14. 发明申请

US20060106776A1 Utilizing mathematical operations with abstract queries 审中-公开
标题翻译：利用抽象查询的数学运算
公开(公告)号：US20060106776A1
公开(公告)日：2006-05-18
申请号：US10992398
申请日：2004-11-18
申请人： Richard Dettinger , Daniel Kolz , Shannon Wenzel
发明人： Richard Dettinger , Daniel Kolz , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F16/2428
摘要： Methods, systems, and articles of manufacture are provided for composing abstract queries by referencing previously defined abstract queries and combining the queries based on mathematic operations, referred to as “query math”. Composing queries by performing query math, such as addition and subtraction, with whole abstract queries facilitates and encourages reuse of existing abstract queries.
摘要翻译：提供了方法，系统和制造文章，用于通过引用先前定义的抽象查询并组合基于数学操作的查询（称为“查询数学”）来组合抽象查询。通过执行查询数学（例如加法和减法）与整个抽象查询组合查询有助于并鼓励重用现有的抽象查询。

15. 发明申请

US20060047638A1 Cartesian product detection 审中-公开
标题翻译：笛卡尔乘积检测
公开(公告)号：US20060047638A1
公开(公告)日：2006-03-02
申请号：US10932709
申请日：2004-09-02
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F16/24542
摘要： A method, system and article of manufacture for query processing and, more particularly, for determining that Cartesian Products will occur in query results without executing corresponding queries. One embodiment provides a method for detecting Cartesian Products in query results. The method comprises identifying, from a query against one or more databases, joins between different tables of the one or more databases. Without executing the query against the one or more databases, it is determined on the basis of cardinalities of the identified joins whether a Cartesian Product will occur in a query result corresponding to the query.
摘要翻译：用于查询处理的方法，系统和制品，更具体地，用于确定笛卡尔乘积将在查询结果中发生而不执行相应的查询。一个实施例提供了一种在查询结果中检测笛卡儿积分的方法。该方法包括从针对一个或多个数据库的查询中识别一个或多个数据库的不同表之间的连接。在不执行针对一个或多个数据库的查询的情况下，基于所识别的联接的基数来确定在对应于查询的查询结果中是否将出现笛卡尔乘积。

16. 发明申请

US20060004749A1 Method and system for managing execution of data driven workflows 有权
标题翻译：用于管理数据驱动工作流的执行的方法和系统
公开(公告)号：US20060004749A1
公开(公告)日：2006-01-05
申请号：US10857722
申请日：2004-05-28
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Shannon Wenzel
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06Q10/06
摘要： Methods, articles of manufacture and systems for managing execution of workflows. One embodiment provides a computer-implemented method for managing execution of a data driven multi-step workflow. The method includes receiving input data for a step of the workflow and performing the step of the workflow on the input data to obtain a result set. Then, at least one rule is applied to the result set for determining whether one or more associated conditions are satisfied. The at least one rule defines the one or more associated conditions and an associated process. If the one or more associated conditions are satisfied, the associated process is performed on the result set.
摘要翻译：方法，制作工具和管理工作流执行的系统。一个实施例提供了一种用于管理数据驱动的多步骤工作流的执行的计算机实现的方法。该方法包括接收工作流步骤的输入数据，并对输入数据执行工作流的步骤以获得结果集。然后，至少一个规则被应用于结果集合以确定是否满足一个或多个相关联的条件。所述至少一个规则定义所述一个或多个相关联的条件和相关联的过程。如果满足一个或多个相关联的条件，则对结果集执行相关联的处理。

17. 发明申请

US20080091668A1 ABSTRACT QUERY PLAN 有权
标题翻译：摘要查询计划
公开(公告)号：US20080091668A1
公开(公告)日：2008-04-17
申请号：US11953935
申请日：2007-12-11
申请人： RICHARD DETTINGER , Daniel Kolz
发明人： RICHARD DETTINGER , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F17/30436 , G06F17/30474 , G06F17/30545 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： A method and apparatus, and article of manufacture are provided to process an abstract query of a database abstraction constructed over an underlying physical data storage mechanism. The database may comprise a single data source, or a federated source spanning multiple systems. Embodiments of the invention process an abstract query by generating an intermediate representation of the abstract query. In one embodiment, the intermediate representation comprises an abstract query plan. An abstract query plan includes a combination of elements from the data abstraction model and elements relating to the underlying physical data storage mechanism. Once generated, a back-end component may easily traverse the abstract query plan to generate an SQL statement (or other resolved query) corresponding to the abstract query. Further, once constructed, the abstract query plan provides a platform for many different optimizations that may be selected by a user or by the runtime component inspecting the abstract query plan prior to creating the resolved query.
摘要翻译：提供了一种方法和装置以及制造物品来处理在底层物理数据存储机构上构建的数据库抽象的抽象查询。数据库可以包括单个数据源或跨越多个系统的联合源。本发明的实施例通过生成抽象查询的中间表示来处理抽象查询。在一个实施例中，中间表示包括抽象查询计划。抽象查询计划包括来自数据抽象模型的元素和与底层物理数据存储机制相关的元素的组合。一旦生成，后端组件可以容易地遍历抽象查询计划以生成与抽象查询相对应的SQL语句（或其他已解析的查询）。此外，一旦构造，抽象查询计划为许多不同的优化提供了一个平台，可以由用户或运行时组件在创建解析的查询之前检查抽象查询计划来选择。

18. 发明申请

US20080082564A1 TIMELINE CONDITION SUPPORT FOR AN ABSTRACT DATABASE 有权
标题翻译：时间线条件支持抽象数据库
公开(公告)号：US20080082564A1
公开(公告)日：2008-04-03
申请号：US11951675
申请日：2007-12-06
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30 , G06F17/00
CPC分类号： G06F17/30551 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942
摘要： Embodiments of the invention relate data retrieved from the logical fields of an abstract database using a timeline. The logical fields specified by a database abstraction model are extended to include attributes that specify where data corresponding to a logical field occurs on a timeline. Query results may be displayed by ordering query results as points (for an event) or segments (for a duration) on the timeline. Further, query processing techniques disclosed by the present invention allow users to include temporal operators such as “before,” “after,” “during,” and “within” in an abstract query. Temporal operators provide users with the ability to include temporal relationships in an abstract query, without having to construct a complex conditional expression from more primitive logical operators (e.g., “ands” and “ors”).
摘要翻译：本发明的实施例涉及使用时间线从抽象数据库的逻辑字段检索的数据。由数据库抽象模型指定的逻辑字段被扩展为包括指定在时间轴上发生对应于逻辑字段的数据的属性的属性。可以通过将查询结果作为时间轴上的点（对于事件）或段（持续时间）排序来显示查询结果。此外，本发明公开的查询处理技术允许用户在抽象查询中包括诸如“之前”，“之后”，“期间”和“内部”之类的时间运算符。时间运算符为用户提供了在抽象查询中包含时间关系的能力，而无需从更原始的逻辑运算符（例如“和”和“ors”）构造复杂条件表达式。

19. 发明申请

US20080071760A1 TRANSFORMATION OF A PHYSICAL QUERY INTO AN ABSTRACT QUERY 审中-公开
标题翻译：将物理查询转换为抽象查询
公开(公告)号：US20080071760A1
公开(公告)日：2008-03-20
申请号：US11947628
申请日：2007-11-29
申请人： Richard Dettinger , Daniel Kolz
发明人： Richard Dettinger , Daniel Kolz
IPC分类号： G06F17/30
CPC分类号： G06F16/24526 , Y10S707/99934 , Y10S707/99935
摘要： Embodiments of the invention provide methods, systems and articles of manufacture for transforming a physical query (e.g., written in SQL) into an abstract query than can be run against an abstract database described by a database abstraction model. In one embodiment, the transformation occurs as a multiple step process: first, transformation of the physical query into an intermediate representation, such as an abstract query plan, and second, transformation of the intermediate representation into an abstract query. There are thousands upon thousands of existing physical (e.g., SQL) queries. Rather than just abandon these existing queries in favor of an abstract database, embodiments of the present invention provide for reverse query processing, that is, for creating an abstract query of the abstract database from a physical query (e.g., an SQL query) of the physical database underlying the abstraction.
摘要翻译：本发明的实施例提供了用于将物理查询（例如，以SQL编写）转换成抽象查询的方法，系统和制品，而不是可以针对由数据库抽象模型描述的抽象数据库运行。在一个实施例中，转换以多步骤过程发生：首先，将物理查询转换为诸如抽象查询计划的中间表示，以及第二，将中间表示转换为抽象查询。有成千上万的现有物理（例如SQL）查询。而不是简单地放弃这些现有的查询以支持抽象数据库，本发明的实施例提供反向查询处理，即，用于从所述抽象数据库的物理查询（例如，SQL查询）创建抽象数据库的抽象查询基础抽象的物理数据库。

20. 发明申请

US20070083514A1 System and method for protecting sensitive data 有权
标题翻译：用于保护敏感数据的系统和方法
公开(公告)号：US20070083514A1
公开(公告)日：2007-04-12
申请号：US11246792
申请日：2005-10-07
申请人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
发明人： Richard Dettinger , Janice Glowacki , Daniel Kolz , Padma Rao , Marci Sperber , Shannon Wenzel
IPC分类号： G06F7/00
CPC分类号： G06F21/6245 , G06F17/3053 , G06F21/6227
摘要： A method, system and article of manufacture for protecting sensitive data in databases and, more particularly, for managing access to sensitive data in a database. One embodiment comprises receiving a query against the data in the database comprising at least (i) a result field specification, and (ii) a sorting instruction. The method further comprises retrieving a result set from the database, and filtering the retrieved result set on the basis of predefined filtering rules to remove selected data from a selected result field of at least one data record included with the retrieved result set. The filtered result set is sorted according to the sorting instruction to produce the sorted result set, whereby the sorting is done independently of the removed selected data so that the sorted result set places the at least one data record at a position which is non-indicative of a value of the removed selected data.
摘要翻译：一种用于保护数据库中敏感数据的方法，系统和制品，更具体地说，用于管理对数据库中的敏感数据的访问。一个实施例包括接收关于数据库中的数据的查询，其包括至少（i）结果字段规范和（ii）排序指令。该方法还包括从数据库检索结果集，并且基于预定义的过滤规则对检索的结果集进行过滤，以从包含在检索结果集中的至少一个数据记录的选定结果字段中移除所选数据。根据分类指令对滤波后的结果集进行排序，以产生排序结果集，由此排序独立于所移除的所选数据进行，使得分类结果集将至少一个数据记录放置在非指示位置的已删除选定数据的值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式