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

21. 发明申请

US20060004740A1 Dynamic graphical database query interface 有权
公开(公告)号：US20060004740A1
公开(公告)日：2006-01-05
申请号：US11097800
申请日：2005-04-01
申请人： Richard Dettinger , Judy Djugash , Jeffrey Tenner , Hoa Tran
发明人： Richard Dettinger , Judy Djugash , Jeffrey Tenner , Hoa Tran
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , G06F17/30554 , Y10S707/99932 , Y10S707/99934 , Y10S707/99943
摘要： A graphical query interface provides visual feedback to a user during the construction of a query. In a first embodiment, the visual feedback helps the user determine the quality of the query as the query is being built. The relationship of columns in the database is graphically displayed to a user. When the user selects a column in the database, a filtered display mechanism displays only those columns or records that satisfy the portion of the query already constructed. In a second embodiment, the visual feedback eliminates some possible selections in the query tree due to previously-made selections that eliminate the eliminated selections as possibilities. In the second embodiment, the visual feedback mechanism may function according to data values in columns, and may also function according to known relationships between columns themselves.

22. 发明申请

US20050289123A1 Automated data model extension through data crawler approach 失效
标题翻译：通过数据抓取方式自动数据模型扩展
公开(公告)号：US20050289123A1
公开(公告)日：2005-12-29
申请号：US10877235
申请日：2004-06-25
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30864
摘要： Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.
摘要翻译：用于访问存储在多个数据源中的数据的方法，系统和制品。这样的方法使用自动化软件代理来维护可用于查询的数据源的集合。数据源可以全部驻留在单个本地网络中，或者可以分布在多个位置。通常，自动化软件代理根据定义的选择标准集搜索给定域中的附加数据源。在发现附加数据源之后，自动化软件代理配置查询应用程序以反映可用性附加数据源。此外，自动软件代理可以根据选择标准周期性地评估数据源的收集，并去除不再可用或不再满足选择标准的那些。

23. 发明申请

US20080033976A1 METADATA MANAGEMENT FOR A DATA ABSTRACTION MODEL 失效
标题翻译：数据摘要模型的元数据管理
公开(公告)号：US20080033976A1
公开(公告)日：2008-02-07
申请号：US11866559
申请日：2007-10-03
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner , Shannon Wenzel
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , G06F17/30926 , G06F17/30967 , G06F17/30997 , G16H40/20 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method, system and article of manufacture for managing metadata associated with a data abstraction model abstractly describing data in a database. One embodiment provides a method of managing metadata describing objects of a data abstraction model with logical fields that define abstract views of physical data in a database. The method comprises traversing a logical tree structure representing the data abstraction model. The logical tree structure has a plurality of nodes, each representing a logical field or a category of logical fields of the data abstraction model. The method further comprises identifying metadata describing logical fields or categories represented by the plurality of nodes. The identified metadata is stored in a queryable database. A user is allowed to query the database to identify objects in the data abstraction model that may be used to construct an abstract query.
摘要翻译：用于管理与抽象地描述数据库中的数据的数据抽象模型相关联的元数据的方法，系统和制品。一个实施例提供了一种管理使用定义数据库中的物理数据的抽象视图的逻辑字段来描述数据抽象模型的对象的元数据的方法。该方法包括遍历表示数据抽象模型的逻辑树结构。逻辑树结构具有多个节点，每个节点表示数据抽象模型的逻辑字段或逻辑字段的类别。该方法还包括识别描述由多个节点表示的逻辑字段或类别的元数据。所识别的元数据存储在可查询的数据库中。允许用户查询数据库以识别可用于构建抽象查询的数据抽象模型中的对象。

24. 发明申请

US20070294234A1 DYNAMIC DATABASE ACCESS VIA STANDARD QUERY LANGUAGE AND ABSTRACTION TECHNOLOGY 有权
标题翻译：动态数据库通过标准查询语言和抽象技术访问
公开(公告)号：US20070294234A1
公开(公告)日：2007-12-20
申请号：US11847246
申请日：2007-08-29
申请人： Richard Dettinger , Jeffrey Tenner
发明人： Richard Dettinger , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , Y10S707/99932 , Y10S707/99934 , Y10S707/99942
摘要： Methods, systems, and articles of manufacture that allow saved abstract queries to be referenced from within query statements constructed using standard query languages, such as Structured Query Language (SQL), are provided.
摘要翻译：提供了允许保存的抽象查询从使用标准查询语言构造的查询语句（如结构化查询语言（SQL））中引用的方法，系统和制品。

25. 发明申请

US20060294081A1 METHODS, SYSTEMS AND ARTICLES OF MANUFACTURE FOR ABSTACT QUERY BUILDING WITH SELECTABILITY OF AGGREGATION OPERATIONS AND GROUPING 失效
标题翻译：方法，系统和制造方法，用于具有可选择性的聚合操作和分组的ABSTQUAL QUERY BUILD
公开(公告)号：US20060294081A1
公开(公告)日：2006-12-28
申请号：US11469001
申请日：2006-08-31
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30412 , G06F17/30489 , Y10S707/99932 , Y10S707/99933
摘要： Methods, systems and articles of manufacture for query building with selectability of aggregation operations and grouping. Abstract queries are composed on the basis of a data abstraction model abstractly describing data in the database. The abstract queries may include result criterions and aggregation operations to be performed with respect to the result criterions for generating aggregation information. An object is generated containing query entities and allowing a user to selectively (i) generate an executable query corresponding to the abstract query inclusive of the aggregation operation and aggregation logic; and (ii) resolve the abstract query to the individual entities contained in the object exclusive of the aggregation operation and aggregation logic.
摘要翻译：用于查询构建的方法，系统和制品，具有聚合操作和分组的可选性。抽象查询是在抽象地描述数据库中的数据的数据抽象模型的基础上组成的。抽象查询可以包括关于生成聚合信息的结果标准要执行的结果标准和聚合操作。生成包含查询实体的对象，并允许用户选择性地（i）生成与包括聚合操作和聚合逻辑在内的抽象查询相对应的可执行查询; 和（ii）将抽象查询解析为不包含聚合操作和聚合逻辑的包含在对象中的各个实体。

26. 发明申请

US20060190434A1 Query rebinding for high-availability database systems 有权
标题翻译：高可用性数据库系统的查询重新绑定
公开(公告)号：US20060190434A1
公开(公告)日：2006-08-24
申请号：US11064717
申请日：2005-02-24
申请人： Richard Dettinger , Daniel Kolz , Jeffrey Tenner
发明人： Richard Dettinger , Daniel Kolz , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , Y10S707/99933
摘要： A method, system and article of manufacture for query processing and, more particularly, for managing execution of queries with respect to different data sources. The different data sources may be logically represented by one or more data abstraction models. One embodiment comprises receiving a first abstract query against physical data in a first data source. The first abstract query has one or more result fields configured to return requested data from the first data source. In response to receiving the first abstract query and determining that the first abstract query is configured for retrieving data from the first data source, it is detected whether the first data source is available. If the first data source is unavailable, a second abstract query against physical data in a second data source containing at least a portion of the requested data is created on the basis of the first abstract query. The second abstract query has one or more result fields configured to return at least the portion of the requested data from the second data source. The second abstract query is executed against the second data source to obtain at least the portion of the requested data.
摘要翻译：用于查询处理的方法，系统和制品，更具体地，用于管理关于不同数据源的查询的执行。不同的数据源可由逻辑上由一个或多个数据抽象模型表示。一个实施例包括接收针对第一数据源中的物理数据的第一抽象查询。第一抽象查询具有一个或多个结果字段，其被配置为从第一数据源返回所请求的数据。响应于接收到第一抽象查询并确定第一抽象查询被配置为从第一数据源检索数据，检测第一数据源是否可用。如果第一数据源不可用，则基于第一抽象查询创建针对包含所请求数据的至少一部分的第二数据源中的物理数据的第二抽象查询。第二抽象查询具有一个或多个结果字段，其被配置为至少从第二数据源返回所请求的数据的一部分。针对第二数据源执行第二抽象查询以获得所请求数据的至少一部分。

27. 发明申请

US20060155692A1 Dealing with composite data through data model entities 有权
公开(公告)号：US20060155692A1
公开(公告)日：2006-07-13
申请号：US11360353
申请日：2006-02-23
申请人： Richard Dettinger , Jennifer LaRocca , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Jennifer LaRocca , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30398 , Y10S707/962 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936 , Y10S707/99942 , Y10S707/99952
摘要： The present invention is generally directed to a system, method and article of manufacture for accessing data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs conversion of an abstract query (i.e., a request for results or a request to modify data) into a form that can be used against a particular physical data representation. Abstract and/or physical queries are transformed according to model entities which define a relationship between logical fields of the data repository abstraction layer.

28. 发明申请

US20060074953A1 Metadata management for a data abstraction model 失效
公开(公告)号：US20060074953A1
公开(公告)日：2006-04-06
申请号：US10955467
申请日：2004-09-30
申请人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner , Shannon Wenzel
发明人： Richard Dettinger , Daniel Kolz , Richard Stevens , Jeffrey Tenner , Shannon Wenzel
IPC分类号： G06F17/30
CPC分类号： G06F17/30392 , G06F17/30926 , G06F17/30967 , G06F17/30997 , G16H40/20 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A method, system and article of manufacture for managing metadata associated with a data abstraction model abstractly describing data in a database. One embodiment provides a method of managing metadata describing objects of a data abstraction model with logical fields that define abstract views of physical data in a database. The method comprises traversing a logical tree structure representing the data abstraction model. The logical tree structure has a plurality of nodes, each representing a logical field or a category of logical fields of the data abstraction model. The method further comprises identifying metadata describing logical fields or categories represented by the plurality of nodes. The identified metadata is stored in a queryable database. A user is allowed to query the database to identify objects in the data abstraction model that may be used to construct an abstract query.

29. 发明申请

US20060020582A1 Method and system for processing abstract derived entities defined in a data abstraction model 审中-公开
标题翻译：用于处理在数据抽象模型中定义的抽象派生实体的方法和系统
公开(公告)号：US20060020582A1
公开(公告)日：2006-01-26
申请号：US10897353
申请日：2004-07-22
申请人： Richard Dettinger , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F16/248 , G06F16/2428
摘要： A method, apparatus and article of manufacture for utilizing an abstract derived entity are disclosed. An abstract derived entity is a data object present in an abstract data model that may be referenced by other entities in the abstract data model as though it were a relational table present in a physical data source. In one embodiment, an abstract data model provides data access independent of the manner in which the data is physically represented in a set of physical data sources. In addition, an abstract derived entity may be used to provide aggregate data joined with other non-aggregate data. Aggregate data values are calculated from the column of a relational table, or other sets of input data. In one embodiment, an abstract derived entity may describe a describe relational table comprising a set of aggregate data used to form a column of the relational table joined to other columns formed from the sets of input data specified by the abstract derived entity. The resulting abstract derived table may be queried as though it were an actual relational table stored in a physical data source.
摘要翻译：公开了一种利用抽象派生实体的方法，装置和制品。抽象派生实体是呈现在抽象数据模型中的数据对象，其可以被抽象数据模型中的其他实体引用，就像它是物理数据源中存在的关系表一样。在一个实施例中，抽象数据模型提供独立于在一组物理数据源中物理表示数据的方式的数据访问。此外，抽象派生实体可用于提供与其他非汇总数据连接的汇总数据。汇总数据值根据关系表列或其他输入数据集计算。在一个实施例中，抽象派生实体可以描述描述关系表，其包括用于形成连接到由抽象派生实体指定的输入数据组形成的其他列的关系表的列的聚合数据集合。所得到的抽象派生表可以被查询，就像它是存储在物理数据源中的实际关系表一样。

30. 发明申请

US20060020580A1 Method and system for providing aggregate data access 有权
标题翻译：提供聚合数据访问的方法和系统
公开(公告)号：US20060020580A1
公开(公告)日：2006-01-26
申请号：US10897333
申请日：2004-07-22
申请人： Richard Dettinger , Richard Stevens , Jeffrey Tenner
发明人： Richard Dettinger , Richard Stevens , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30595
摘要： A method and apparatus for defining and processing aggregate data is disclosed. Using database abstraction techniques, a set of logical fields may be used to compose queries of a set of underlying physical data sources. In one embodiment, a logical field may represent an aggregate data value calculated from the elements appearing in a column of a relational table in an underlying physical data source. The elements may be divided into to subsets to calculate multiple aggregate values. An abstract derived entity is a data object present in a database abstraction model that may be accessed as though it were a relational table contained in an underlying physical data source. In one embodiment, columns of the table defined by the abstract derived entity may be populated with aggregate data values joined to other data as specified by a composition rule included in the definition of the abstract derived entity.
摘要翻译：公开了一种用于定义和处理聚合数据的方法和装置。使用数据库抽象技术，可以使用一组逻辑字段来构成一组底层物理数据源的查询。在一个实施例中，逻辑字段可以表示从出现在底层物理数据源中的关系表的列中的元素计算的聚合数据值。元素可以分为子集，以计算多个聚合值。抽象派生实体是存在于数据库抽象模型中的数据对象，可以被访问，就像它是包含在底层物理数据源中的关系表一样。在一个实施例中，由抽象派生实体定义的表的列可以填充与由包括在抽象派生实体的定义中的组合规则指定的其他数据连接的聚合数据值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式