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

1. 发明授权

US06947945B1 Using an XML query language to publish relational data as XML 有权
标题翻译：使用XML查询语言将关系数据作为XML发布
公开(公告)号：US06947945B1
公开(公告)日：2005-09-20
申请号：US09531802
申请日：2000-03-21
申请人： Michael James Carey , Jayavel Shanmugasundaram , Eugene Jon Shekita , Narayana Iyer
发明人： Michael James Carey , Jayavel Shanmugasundaram , Eugene Jon Shekita , Narayana Iyer
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/30932 , G06F17/30941 , Y10S707/99943
摘要： A method for publishing relational data as XML by translating XML queries into queries against an relational database. Conversion of the relational database into an XML database is not required. Each relational table is mapped to a virtual XML document, and XML queries are issued over these virtual documents. An XML query is parsed and transformed into a language-neutral intermediate representation, which is a sequence of operations describing how the output document is derived from the underlying relational tables. The intermediate representation is then translated into an SQL query over the underlying relational tables and into instructions for a tagger. The SQL query is executed, and the SQL query results are then fed into the tagger, which follows tagger instructions to generate the marked up output.
摘要翻译：通过将XML查询转换为关系数据库的查询，将关系数据作为XML发布的方法。不需要将关系数据库转换为XML数据库。每个关系表映射到一个虚拟XML文档，并通过这些虚拟文档发出XML查询。解析XML查询并将其转换为语言中立的中间表示，它是描述输出文档如何从底层关系表导出的操作序列。然后将中间表示形式转换为基于关系表的SQL查询和标记器的指令。执行SQL查询，然后将SQL查询结果输入到标记器中，标签器遵循标记器指令生成标记输出。

2. 发明授权

US07043487B2 Method for storing XML documents in a relational database system while exploiting XML schema 失效
标题翻译：在关系数据库系统中存储XML文档同时利用XML模式的方法
公开(公告)号：US07043487B2
公开(公告)日：2006-05-09
申请号：US10331739
申请日：2002-12-28
申请人： Rajasekar Krishnamurthy , Jayavel Shanmugasundaram , Eugene Jon Shekita
发明人： Rajasekar Krishnamurthy , Jayavel Shanmugasundaram , Eugene Jon Shekita
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30896 , Y10S707/954
摘要： A method for storing XML documents in a relational database system while exploiting XML Schema information to capture information about types, inheritance, equivalence classes, and integrity constraints in the generated relational schema, enabling efficient querying. The invention simplifies complex XML schema types, translates the simplified XML schema types into relational tables, and then stores relations corresponding to each XML element in relational table rows. The simplification includes grouping all occurrences of a given element together, assembling two or more element types into element groups if the schema indicates that elements of those element types will occur the same number of times, and applying a number of transformation rules to the element groups. The translation includes constructing a type graph from the simplified schema, building an element graph for each global element in the simplified schema from the type graph, and generating relational tables from the element graph.
摘要翻译：一种用于在关系数据库系统中存储XML文档的方法，同时利用XML模式信息来捕获关于生成的关系模式中的类型，继承，等价类和完整性约束的信息，从而实现高效的查询。本发明简化了复杂的XML模式类型，将简化的XML模式类型转换为关系表，然后将对应于每个XML元素的关系存储在关系表行中。简化包括将给定元素的所有出现分组在一起，如果模式指示这些元素类型的元素将发生相同次数，并将多个变换规则应用于元素组，则将两个或多个元素类型组合到元素组中。翻译包括从简化模式构建类型图，从类型图构建简化模式中的每个全局元素的元素图，以及从元素图生成关系表。

3. 发明授权

US07016915B2 Method for processing XML queries over relational data and meta-data using a relational database system 失效
标题翻译：使用关系数据库系统处理关系数据和元数据的XML查询的方法
公开(公告)号：US07016915B2
公开(公告)日：2006-03-21
申请号：US10331740
申请日：2002-12-28
申请人： Jayavel Shanmugasundaram , Eugene Jon Shekita
发明人： Jayavel Shanmugasundaram , Eugene Jon Shekita
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/30929 , Y10S707/954 , Y10S707/99943
摘要： A system, method, and computer program product for processing XML queries over relational data and meta-data using a relational database system. The invention runs a query to generate a view definition, so a regular query processor can handle queries on a mix of data and meta-data. Names of desired tables are data-dependent, so the invention represents a default XML view as an XML query over the relational tables, gets the table names and table data by recursively invoking the query processor (first by querying the catalog table, and then querying base data according to a new construct). The invention thus processes queries over table names in addition to table values.
摘要翻译：用于使用关系数据库系统处理关系数据和元数据的XML查询的系统，方法和计算机程序产品。本发明运行查询以生成视图定义，因此常规查询处理器可以处理对数据和元数据的混合的查询。所需表的名称依赖于数据，因此本发明将XML视图作为关系表的XML查询表示，通过递归调用查询处理器来获取表名和表数据（首先通过查询目录表，然后查询基础数据根据新的构造）。因此，本发明除了表值之外处理对表名的查询。

4. 发明授权

US06934712B2 Tagging XML query results over relational DBMSs 失效
标题翻译：在关系数据库管理系统上标记XML查询结果
公开(公告)号：US06934712B2
公开(公告)日：2005-08-23
申请号：US09810167
申请日：2001-03-19
申请人： Gerald George Kiernan , Jayavel Shanmugasundaram , Eugene Jon Shekita
发明人： Gerald George Kiernan , Jayavel Shanmugasundaram , Eugene Jon Shekita
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , G06F17/30595 , G06F17/30932 , G06F17/30941 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99943
摘要： A method for publishing relational data as XML by translating XML queries into queries against a relational database. Conversion of the relational database into an XML database is not required. Each relational table is mapped to a virtual XML document, and XML queries are issued over these virtual documents. An XML query is parsed and transformed into a language-neutral intermediate representation, which is a sequence of operations describing how the output document is derived from the underlying relational tables. The intermediate representation is then translated into an SQL query over the underlying relational tables. The intermediate representation is also used to generate a tagger graph, which the tagger runtime ‘walks’ to generate the tagged, structured XML output. Each of the nodes of the tagger graph are operators which perform processing on the results of the SQL query. The SQL query is executed, and the SQL query results are then provided to the tagger. The tagger runtime applies the operators of each node to the inputs at that node to produce the structured XML document as a query result, guided by the structure of the tagger graph.
摘要翻译：通过将XML查询转换为关系数据库的查询来将关系数据发布为XML的方法。不需要将关系数据库转换为XML数据库。每个关系表映射到一个虚拟XML文档，并通过这些虚拟文档发出XML查询。解析XML查询并将其转换为语言中立的中间表示，它是描述输出文档如何从底层关系表导出的操作序列。然后将中间表示形式转换为基础关系表中的SQL查询。中间表示也用于生成标记图，标记运行时“走”来生成标记的结构化XML输出。标记图中的每个节点都是对SQL查询结果执行处理的操作符。执行SQL查询，然后将SQL查询结果提供给标记器。标记运行时将每个节点的运算符应用于该节点的输入，以便通过标记器图的结构来指导结构化的XML文档作为查询结果。

5. 发明申请

US20120158495A1 INVENTORY ALLOCATION IN ADVERTISING SYSTEMS 审中-公开
标题翻译：广告系统中的存货分配
公开(公告)号：US20120158495A1
公开(公告)日：2012-06-21
申请号：US12972941
申请日：2010-12-20
申请人： Jayavel Shanmugasundaram , Datong Chen , Sumanth Jagannath , Erik Vee , Ramana Yerneni
发明人： Jayavel Shanmugasundaram , Datong Chen , Sumanth Jagannath , Erik Vee , Ramana Yerneni
IPC分类号： G06Q30/00
CPC分类号： G06Q30/0251
摘要： A network based advertisement system includes a supply forecasting system configured to select, from a campaign log database, data that defines a plurality of contracts. Each contract specifies requirements that include contract target audience information and a number of impressions. For each contract, the supply forecasting system identifies one or more opportunity samples with characteristics that match contract target audience information of the contract. Each opportunity sample is associated with a weight that corresponds to a number of opportunities with similar characteristics. An optimizer associates the opportunity samples with the contract and then determines whether the opportunity samples are associated with other contracts. The optimizer then limits the number of opportunities associated with the samples that are allocatable to the contract based at least in part on a function of requirements of other contracts associated with the one or more samples.
摘要翻译：基于网络的广告系统包括供应预测系统，其被配置为从活动日志数据库中选择定义多个合同的数据。每个合同规定了包含合同目标受众信息和多次展示次数的要求。对于每个合同，供应预测系统识别具有与合同的合同目标受众信息匹配的特征的一个或多个机会样本。每个机会样本与对应于具有类似特征的机会的数量相关联。优化器将机会样本与合同相关联，然后确定机会样本是否与其他合同相关联。优化器然后至少部分地基于与一个或多个样本相关联的其他合同的要求的函数来限制与可分配给合同的样本相关联的机会的数量。

6. 发明申请

US20120004980A1 INVENTORY MANAGEMENT AND SERVING WITH BUCKET TESTING IN GUARANTEED DELIVERY OF ONLINE ADVERTISING 审中-公开
标题翻译：库存管理和服务于保证在线广告交付中的BUCKET测试
公开(公告)号：US20120004980A1
公开(公告)日：2012-01-05
申请号：US12829915
申请日：2010-07-02
申请人： Tarun Bhatia , Jayavel Shanmugasundaram
发明人： Tarun Bhatia , Jayavel Shanmugasundaram
IPC分类号： G06Q30/00
CPC分类号： G06Q30/02 , G06Q30/0243 , G06Q30/0247 , G06Q30/0277
摘要： Techniques are provided to facilitate bucket testing in connection with guaranteed delivery online advertising associated with an online advertising marketplace. Operating policies are established for each of the buckets, in which the operating policies for each of the buckets differ. Bucket controller programming logic is used in implementation of the operating policies. Allocation and serving of advertisements is facilitated in accordance with the operating policies.
摘要翻译：提供了技术来促进与在线广告市场相关联的保证传送在线广告的桶测试。为每个桶建立操作策略，其中每个桶的操作策略不同。铲斗控制器编程逻辑用于实施运行策略。根据经营政策，促进了广告的分配和服务。

7. 发明授权

US07921103B2 Adaptive materialized view selection for databases 有权
标题翻译：适用于数据库的物化视图选择
公开(公告)号：US07921103B2
公开(公告)日：2011-04-05
申请号：US12143710
申请日：2008-06-20
申请人： Chris Olston , Jayavel Shanmugasundaram , Sandeep Pandey
发明人： Chris Olston , Jayavel Shanmugasundaram , Sandeep Pandey
IPC分类号： G06F17/00
CPC分类号： G06F17/30457
摘要： Techniques described herein adaptively select materialized view fragments for persistent maintenance. During an interval of time, the selected fragments are persistently maintained in the database system, while the other non-selected fragments are not persistently maintained as materialized view fragments. Over time, the composition of the set of selected fragments may change. As queries are executed in the database system over an interval of time, statistics including the frequency of access of each currently selected fragment during that interval are generated. At the start of the next interval of time, based on these statistics, some currently selected fragments may be unselected. Some currently non-selected fragments of one or more candidate materialized views may be selected based on the statistics. For the next interval, the newly unselected fragments cease to be persistently maintained as materialized view fragments, while the newly selected fragments begin to be persistently maintained as materialized view fragments.
摘要翻译：本文描述的技术自适应地选择用于持续维护的物化视图片段。在一段时间间隔内，所选择的片段被持久地维护在数据库系统中，而其他未选择的片段不会被持久地维护为物化视图片段。随着时间的推移，所选择的片段的组合可能会改变。当查询在一段时间内在数据库系统中执行时，生成包括在该间隔期间每个当前选择的片段的访问频率的统计信息。在下一个时间间隔开始时，基于这些统计信息，可以取消选择一些当前选择的片段。可以基于统计来选择一个或多个候选物化视图的一些当前未选择的片段。对于下一个时间间隔，新的未选择的片段不再被持久地维护为物化视图片段，而新选择的片段开始被持续地保留为物化视图片段。

8. 发明申请

US20100094881A1 SYSTEM AND METHOD FOR INDEXING SUB-SPACES 审中-公开
标题翻译：用于索引子空间的系统和方法
公开(公告)号：US20100094881A1
公开(公告)日：2010-04-15
申请号：US12242748
申请日：2008-09-30
申请人： Chad Brower , Ramana Yerneni , Erik Vee , Serguei Vassilvitskii , Jayavel Shanmugasundaram
发明人： Chad Brower , Ramana Yerneni , Erik Vee , Serguei Vassilvitskii , Jayavel Shanmugasundaram
IPC分类号： G06F17/30 , G06Q30/00 , G06F7/08
CPC分类号： G06Q30/0241 , G06F16/9535 , G06Q30/02
摘要： The present invention is directed to systems and methods for identifying compatible advertisement contracts to satisfy an advertisement opportunity. The systems and methods include receiving a number of attribute values associated with a user accessing a network-based location. The systems and methods include sorting an index of lists for a plurality of advertisement contracts on the basis of a number of contract term values. The systems and methods include traversing the index of lists to return a set advertisement contracts compatible with the number of attribute values associated with the user. The systems and methods include selecting a given advertisement contract from the set of advertisement contracts compatible with the number of attribute values associated with the user. The systems and methods include presenting an advertisement associated with the given advertisement contract on a display viewable by the user accessing the network-based location.
摘要翻译：本发明涉及用于识别兼容的广告合同以满足广告机会的系统和方法。系统和方法包括接收与访问基于网络的位置的用户相关联的多个属性值。系统和方法包括基于合同项数量的数量来排序多个广告合同的列表索引。系统和方法包括遍历列表的索引以返回与与用户相关联的属性值的数量兼容的集合广告合同。系统和方法包括从与用户相关联的属性值的数量兼容的广告合同集合中选择给定的广告合同。所述系统和方法包括在由用户访问基于网络的位置可见的显示器上呈现与给定广告合同相关联的广告。

9. 发明申请

US20100082424A1 OFFLINE OPTIMIZATION OF ONLINE PROCESSES 审中-公开
标题翻译：离线优化在线流程
公开(公告)号：US20100082424A1
公开(公告)日：2010-04-01
申请号：US12242393
申请日：2008-09-30
申请人： Ramana Yerneni , Chad Brower , Srinivasan Rajagopal , Jayavel Shanmugasundaram , Erik Vee
发明人： Ramana Yerneni , Chad Brower , Srinivasan Rajagopal , Jayavel Shanmugasundaram , Erik Vee
IPC分类号： G06Q30/00
CPC分类号： G06Q30/02 , G06Q30/0244 , G06Q30/0277
摘要： Subject matter disclosed herein relates to a system for managing online resources, and in particular, to a system using an offline process to optimize the management of such online resources.
摘要翻译：本文公开的主题涉及用于管理在线资源的系统，特别涉及使用离线过程来优化这种在线资源的管理的系统。

10. 发明授权

US07107255B2 Self join elimination through union 失效
公开(公告)号：US07107255B2
公开(公告)日：2006-09-12
申请号：US09887759
申请日：2001-06-21
申请人： Gerald George Kiernan , Jayavel Shanmugasundaram
发明人： Gerald George Kiernan , Jayavel Shanmugasundaram
IPC分类号： G06F17/30
CPC分类号： G06F17/30466 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： A query optimization technique that determines whether a query includes a self join that is transitively derived through table expressions having UNION operators. If so, the query is simplified to eliminate the table expressions and to reduce the query to an equivalent query over tables.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式