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

1. 发明授权

US5875334A System, method, and program for extending a SQL compiler for handling control statements packaged with SQL query statements 失效
标题翻译：用于扩展SQL编译器以处理用SQL查询语句打包的控制语句的系统，方法和程序
公开(公告)号：US5875334A
公开(公告)日：1999-02-23
申请号：US548969
申请日：1995-10-27
申请人： Jyh-Herng Chow , You-Chin (Gene) Fuh , Nelson Mendonca Mattos , Brian T. Tran
发明人： Jyh-Herng Chow , You-Chin (Gene) Fuh , Nelson Mendonca Mattos , Brian T. Tran
IPC分类号： G06F9/45 , G06F17/30
CPC分类号： G06F17/30415 , G06F17/30433 , G06F8/427 , G06F8/433 , G06F8/443
摘要： This invention provides an integrated compiler for compiling SQL3 control statements having procedural, i.e., control, information packaged together with query, i.e., non-procedural, statements. A query extractor contained within the parser extracts the query statement from the control statement leaving a control skeleton. The query statement is processed as usual through a query compiler for generating executable plans with the exception that the name resolution function for resolving variables is modified for looking up local variables. This modification takes into account the mapping of local and host variables to create a unification of local and host variables. The control skeleton is processed through a control analyzer which generates a representation of the control flow and a scope and symbol table. The control analyzer also unifies the local and host variables. A plan synthesizer then takes as input the control flow information, symbol tables, and individual executable plans for the query statements and generates a meta-plan comprising a merger of a top level plan for the control skeleton and sub-plans representing the executable plans of the query statement. Therefore, this invention provides a uniform way of treating local and host variables, provides an efficient way of performing bind-in/bind-out processes, creates a single execution plan requiring only a single run-time interpreter, and requires minimum enhancements to existing SQL2 compilers. In addition, this invention enables the application of global optimization techniques for optimizing both the control aspects and query aspects of the original control statement.
摘要翻译：本发明提供了一种用于编译具有程序化即控制信息的SQL3控制语句的集成编译器，其中包含与查询（即非程序语句）一起打包的信息。解析器中包含的查询提取器从控制语句中提取查询语句，留下控制框架。查询语句通常通过用于生成可执行计划的查询编译器进行处理，但用于解析变量的名称解析功能被修改用于查找局部变量。此修改考虑了本地和主机变量的映射，以创建本地和主机变量的统一。控制骨架通过控制分析器进行处理，控制分析器生成控制流的表示以及范围和符号表。控制分析仪还统一了本地和主机变量。然后，计划合成器将查询语句的控制流信息，符号表和各个可执行计划作为输入，并生成包含控制框架的顶层计划的合并和表示可执行计划的子计划的元计划查询语句。因此，本发明提供了一种统一的方法来处理本地和主机变量，提供了一种执行绑定/绑定过程的有效方法，创建一个仅需要单个运行时解释器的单个执行计划，并且需要对现有的 SQL2编译器。另外，本发明能够应用全局优化技术来优化原始控制语句的控制方面和查询方面。

2. 发明授权

US5930795A Supporting dynamic tables in SQL query compilers 失效
标题翻译：在SQL查询编译器中支持动态表
公开(公告)号：US5930795A
公开(公告)日：1999-07-27
申请号：US786603
申请日：1997-01-21
申请人： Yao-Ching Stephen Chen , Jyh-Herng Chow , Roberta Jo Cochrane , Gene Y.C. Fuh , Nelson Mendonca Mattos , Mir Hamid Pirahesh , Jeffrey D. Richey , Brian Thinh-Vinh Tran , Tuong Chanh Truong
发明人： Yao-Ching Stephen Chen , Jyh-Herng Chow , Roberta Jo Cochrane , Gene Y.C. Fuh , Nelson Mendonca Mattos , Mir Hamid Pirahesh , Jeffrey D. Richey , Brian Thinh-Vinh Tran , Tuong Chanh Truong
IPC分类号： G06F17/30
CPC分类号： G06F17/30421 , G06F17/30474
摘要： A framework for a query compiler and run-time environment for resolving a table reference to a dynamic table that is first identified at run-time but is initially unknown at compile-time. A parser parses the table reference and creates a parsed representation for the table that identifies the type of dynamic table. A code generator creates executable plans containing run-time table object representations (TAOB), from the parsed representations, that contain the type of dynamic table. The TAOB is also extended to provide for parameters that are definable at run-time, including a table ID of the actual table entity being referenced. A routine is embedded in a run-time routine that checks the type of dynamic table in the TAOB and dispatches control to one of a plurality of corresponding routines, depending upon the type of dynamic table. The corresponding routines use the extended TAOB to dynamically link the table reference to the dynamic table, depending upon the type of dynamic table. Once the dynamic table has been linked to the table reference, query processing continues as if that table were a base or derived table.
摘要翻译：用于查询编译器和运行时环境的框架，用于解析对运行时首先标识但最初在编译时未知的动态表的表引用。解析器解析表引用，并创建用于标识动态表类型的表的解析表示。代码生成器从解析的表示形式创建包含运行时表对象表示（TAOB）的可执行计划，其中包含动态表的类型。 TAOB还被扩展以提供在运行时可定义的参数，包括被引用的实际表实体的表ID。例程被嵌入到运行时程序中，该运行时程序检查TAOB中的动态表的类型，并根据动态表的类型将控制调度到多个相应的例程之一。相应的例程使用扩展TAOB来动态地将表引用动态链接到动态表，这取决于动态表的类型。一旦将动态表链接到表引用，查询处理将继续进行，就像该表是基类或派生表一样。

3. 发明申请

US20120158492A1 METHOD AND SYSTEM FOR ATTENTION BASED ADVERTISEMENT INSERTION 审中-公开
标题翻译：基于注意的广告插入方法和系统
公开(公告)号：US20120158492A1
公开(公告)日：2012-06-21
申请号：US12970340
申请日：2010-12-16
申请人： Jerry Ye , Jyh-Herng Chow
发明人： Jerry Ye , Jyh-Herng Chow
IPC分类号： G06Q30/00
CPC分类号： G06Q30/0241 , G06Q30/0251 , G06Q30/0273
摘要： Disclosed is a method and system for providing attention based advertisement insertion within media content. By placing advertisements within media where there is the most user attention and interest, the system provides a more attractive audience to advertisers. This potentially leads to increased return of interest (ROI) on the advertisement. Additionally, this can enable the media to be comprised of fewer advertisements, and reduce advertisement related abandonment.
摘要翻译：公开了一种用于在媒体内容中提供基于关注的广告插入的方法和系统。通过将广告放置在最受用户关注和兴趣的媒体中，系统为广告商提供了更有吸引力的观众。这可能导致广告的兴趣回报率（ROI）增加。此外，这可以使媒体由较少的广告组成，并减少广告相关的放弃。

4. 发明授权

US07359873B2 Self-service catalog manager for stores implemented on a communications network 有权
标题翻译：在通信网络上实施的商店的自助服务目录管理器
公开(公告)号：US07359873B2
公开(公告)日：2008-04-15
申请号：US10800146
申请日：2004-03-11
申请人： Timothy Roberts , Jyh-Herng Chow , Sara Hicks , Jimmy R. Duvall
发明人： Timothy Roberts , Jyh-Herng Chow , Sara Hicks , Jimmy R. Duvall
IPC分类号： G06Q30/00
CPC分类号： G06Q30/06 , G06Q10/087 , G06Q30/0207 , G06Q30/0277 , G06Q30/0641
摘要： A computerized self-service platform assists merchants in creating and managing stores on a computer network. In one aspect, a system for managing a store includes a product database and an ecommerce storefront, with the ecommerce storefront referencing information in the product database. A product administration module (e.g., a catalog manager) allows the merchant to manage the product database on a self-serve basis. Separating the storefront from the product database can yield numerous advantages.
摘要翻译：计算机化的自助服务平台可帮助商家创建和管理计算机网络上的商店。一方面，用于管理商店的系统包括产品数据库和电子商务店面，电子商务店面引用产品数据库中的信息。产品管理模块（例如，目录管理器）允许商家在自助服务的基础上管理产品数据库。将店面与产品数据库分离可以产生许多优点。

5. 发明授权

US07174327B2 Generating one or more XML documents from a relational database using XPath data model 有权
标题翻译：使用XPath数据模型从关系数据库生成一个或多个XML文档
公开(公告)号：US07174327B2
公开(公告)日：2007-02-06
申请号：US10062127
申请日：2002-01-31
申请人： Hoang K. Chau , Isaac Kam-Chak Cheng , Josephine Miu Cheng , Suet Mui Chiu , Jyh-Herng Chow , Michael Leon Pauser , Jian Xu
发明人： Hoang K. Chau , Isaac Kam-Chak Cheng , Josephine Miu Cheng , Suet Mui Chiu , Jyh-Herng Chow , Michael Leon Pauser , Jian Xu
IPC分类号： G06F17/30
CPC分类号： G06F17/30917 , Y10S707/99931 , Y10S707/99933 , Y10S707/99934
摘要： A technique is provided for generating one or more XML documents from a relational database using the XPath data model. Data stored on a data storage device that is connected to a computer is transformed. Initially, a document object model tee is generated using a document access definition, which defines the mapping between an XML tree structure and relational tables. The document object model tree is traversed to obtain information to retrieve relational data. The relational data is mapped to one or more XML documents.
摘要翻译：提供了一种用于使用XPath数据模型从关系数据库生成一个或多个XML文档的技术。存储在连接到计算机的数据存储设备上的数据被转换。最初，使用文档访问定义来生成文档对象模型tee，该定义定义了XML树结构和关系表之间的映射。遍历文档对象模型树以获取信息以检索关系数据。关系数据映射到一个或多个XML文档。

6. 发明授权

US06421656B1 Method and apparatus for creating structure indexes for a data base extender 失效
标题翻译：用于为数据库扩展器创建结构索引的方法和装置
公开(公告)号：US06421656B1
公开(公告)日：2002-07-16
申请号：US09324826
申请日：1999-06-02
申请人： Josephine M. Cheng , Jyh-Herng Chow , Jian Xu
发明人： Josephine M. Cheng , Jyh-Herng Chow , Jian Xu
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： A method and apparatus using an extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. The extender has “conditional select” functionality, “conditional select” functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. The extender also has a set of user defined functions for creating one or more indexes for structured documents stored in the relational database system using already created B+ tree index structures implemented in the database system to support the indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.
摘要翻译：公开了一种用于计算机实现的关系数据库系统的扩展器的方法和装置，用于存储，查询和检索结构化文档。扩展器提供新的抽象数据类型，并且包括用于在内部存储，查询和检索结构化文档的多个用户定义的功能，例如作为基于字符的大对象（CLOB），或外部地在平面文件或URL中。扩展器具有“条件选择”功能，“条件选择”功能基于驻留在扩展器内的用户定义的功能，其被应用于数据库系统中的结构化查询中的投影。扩展器还具有一组用户定义的功能，用于为存储在关系数据库系统中的结构化文档创建一个或多个索引，使用在数据库系统中实现的已创建的B +树索引结构来支持索引。该方法包括用于对结构化文档进行索引并用于实现关系数据库内的结构索引的标签计数系统。

7. 发明授权

US06304866B1 Aggregate job performance in a multiprocessing system by incremental and on-demand task allocation among multiple concurrently operating threads 失效
标题翻译：通过多个并发操作线程中的增量和按需任务分配在多处理系统中综合工作性能
公开(公告)号：US06304866B1
公开(公告)日：2001-10-16
申请号：US08884602
申请日：1997-06-27
申请人： Jyh-Herng Chow , John Frederick Hornibrook , Bruce Gilbert Lindsay , Geoffrey Peddle , Eugene Jon Shekita , Amit Somani , Surendra Kumar Verma , Honesty Cheng Young
发明人： Jyh-Herng Chow , John Frederick Hornibrook , Bruce Gilbert Lindsay , Geoffrey Peddle , Eugene Jon Shekita , Amit Somani , Surendra Kumar Verma , Honesty Cheng Young
IPC分类号： G06F1730
CPC分类号： G06F9/505 , G06F2209/5017 , Y10S707/99932 , Y10S707/99933
摘要： In a multiprocessing system, multiple concurrently operating task execution units are operated to perform an aggregate task by using incremental and on-demand sub-task allocation. A command is received to perform a machine-executed task divisible into multiple sub-tasks, i.e., an “aggregate task”. A granularity is then established, for dividing the aggregate task into sub-tasks. Preferably, the granularity is not too large to permit potentially uneven sub-task allocation, and not too small to incur excessive overhead in allocating sub-tasks. Having established the granularity, multiple task execution units are independently operated on-demand to sequentially self-allocate and execute sub-tasks of the aggregate tasks. Each sub-task is sized according to the established granularity. Operating “on-demand”, each task execution unit sequentially allocates and executes one sub-task at a time, then proceeding to the next unexecuted sub-task. Thus, the multiprocessing system operates like multiple people drinking water from a common glass through individual straws—although each drinker works independently, all finish simultaneously, thus completing the aggregate task as expeditiously as possible.
摘要翻译：在多处理系统中，通过使用增量和按需子任务分配来操作多个并发操作任务执行单元来执行聚合任务。接收到用于执行可分为多个子任务（即，“聚合任务”）的机器执行任务的命令。然后建立粒度，将聚合任务划分为子任务。优选地，粒度不是太大，不能允许潜在的不均匀的子任务分配，并且不太小，在分配子任务时不会产生过多的开销。建立粒度后，多个任务执行单元按需独立运行，顺序自动分配和执行总任务的子任务。每个子任务的大小根据建立的粒度。每个任务执行单元按“按需”运行，一次顺序分配并执行一个子任务，然后进行到下一个未执行的子任务。因此，多处理系统通过个人吸管，像普通玻璃饮水一样运作，虽然每个饮酒者独立工作，但是同时完成，从而尽可能快地完成总体任务。

8. 发明授权

US08611675B2 Confusion matrix for classification systems 有权
标题翻译：分类系统混淆矩阵
公开(公告)号：US08611675B2
公开(公告)日：2013-12-17
申请号：US11644172
申请日：2006-12-22
申请人： Jyh-Herng Chow , Byron Dom , Dao-I Lin
发明人： Jyh-Herng Chow , Byron Dom , Dao-I Lin
IPC分类号： G06K9/62
CPC分类号： G06K9/6253
摘要： Techniques are described herein for generating and displaying a confusion matrix wherein a data item belonging to one or more actual classes is predicted into a class. The classes in which the data item may be predicted (the “predicted classes”) are ranked according to a score that in one embodiment indicates the confidence of the prediction. If the data item is predicted into a class that is one of the top K ranked predicted classes, then the prediction is considered accurate and an entry is created in a cell of a confusion matrix indicating the accurate prediction. If the data item is not predicted into a class that is not one of the top K ranked predicted classes, then the prediction is considered inaccurate and an entry is created in a cell of a confusion matrix indicating the inaccurate prediction.
摘要翻译：本文描述了用于生成和显示混淆矩阵的技术，其中属于一个或多个实际类的数据项被预测为类。可以根据在一个实施例中指示预测的置信度的分数对可以预测数据项目的类别（“预测类别”）进行排名。如果数据项目被预测为属于顶级K级预测类别之一的类别，那么该预测被认为是准确的，并且在混合矩阵的小区中创建表示准确预测的条目。如果数据项目未被预测为不属于顶级K级预测类别的类别，那么该预测被认为是不准确的，并且在混淆矩阵的小区中创建一个表示不准确预测的条目。

9. 发明申请

US20050065856A1 Self-service catalog manager for stores implemented on a communications network 有权
标题翻译：在通信网络上实施的商店的自助服务目录管理器
公开(公告)号：US20050065856A1
公开(公告)日：2005-03-24
申请号：US10800146
申请日：2004-03-11
申请人： Timothy Roberts , Jyh-Herng Chow , Sara Hicks , Jimmy Duvall
发明人： Timothy Roberts , Jyh-Herng Chow , Sara Hicks , Jimmy Duvall
IPC分类号： G06Q30/00 , G06F17/60
CPC分类号： G06Q30/06 , G06Q10/087 , G06Q30/0207 , G06Q30/0277 , G06Q30/0641
摘要： A computerized self-service platform assists merchants in creating and managing stores on a computer network. In one aspect, a system for managing a store includes a product database and an ecommerce storefront, with the ecommerce storefront referencing information in the product database. A product administration module (e.g., a catalog manager) allows the merchant to manage the product database on a self-serve basis. Separating the storefront from the product database can yield numerous advantages.
摘要翻译：计算机化的自助服务平台可帮助商家创建和管理计算机网络上的商店。一方面，用于管理商店的系统包括产品数据库和电子商务店面，电子商务店面引用产品数据库中的信息。产品管理模块（例如，目录管理器）允许商家在自助服务的基础上管理产品数据库。将店面与产品数据库分离可以产生许多优点。

10. 发明授权

US06519597B1 Method and apparatus for indexing structured documents with rich data types 失效
标题翻译：用于索引具有丰富数据类型的结构化文档的方法和设备
公开(公告)号：US06519597B1
公开(公告)日：2003-02-11
申请号：US09324499
申请日：1999-06-02
申请人： Josephine M. Cheng , Jyh-Herng Chow , Gene Y. C. Fuh , Jian Xu
发明人： Josephine M. Cheng , Jyh-Herng Chow , Gene Y. C. Fuh , Jian Xu
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , Y10S707/99943
摘要： An extender for a computer-implemented relational database system is disclosed for storing, querying, and retrieving structured documents. The extender provides a new abstract data type and includes a plurality of user defined functions for storing, querying, and retrieving structured documents internally, as character-based large objects (CLOB), or externally, in flat files or URLs, for example. A method and apparatus using an extender having a “conditional select” functionality is further disclosed for querying structured documents. The “conditional select” functionality is based on user defined functions residing within the extender being applied to a projection in a structured query in the database system. A method and apparatus using an extender having a set of user defined functions is further disclosed for creating one or more indexes for structured documents stored in the relational database system. The method uses the set of functions to create the indexes and uses already created B+ tree index structures implemented in the database system to support the indexes. A method and apparatus using an extender is further disclosed for creating and supporting structure indexes. The method includes a tag counting system for indexing structured documents and for implementing the structure indexes within the relational database.
摘要翻译：公开了一种用于计算机实现的关系数据库系统的扩展器，用于存储，查询和检索结构化文档。扩展器提供新的抽象数据类型，并且包括用于在内部存储，查询和检索结构化文档的多个用户定义的功能，例如作为基于字符的大对象（CLOB），或外部地在平面文件或URL中。进一步公开了使用具有“条件选择”功能的扩展器的方法和装置，用于查询结构化文档。 “条件选择”功能基于驻留在扩展器内的用户定义的功能，其被应用于数据库系统中的结构化查询中的投影。进一步公开了使用具有一组用户定义的功能的扩展器的方法和装置，用于创建一个或者用于存储在关系数据库系统中的结构化文档的更多索引。该方法使用一组函数来创建索引，并使用在数据库系统中实现的已创建的B +树索引结构来支持索引。进一步公开了一种使用扩展器的方法和装置，用于创建和支持结构索引。该方法包括用于对结构化文档进行索引并用于实现关系数据库内的结构索引的标签计数系统。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式