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

1. 发明授权

US09361407B2 SQL extended with transient fields for calculation expressions in enhanced data models 有权
标题翻译： SQL在扩展数据模型中用于计算表达式的瞬态字段扩展
公开(公告)号：US09361407B2
公开(公告)日：2016-06-07
申请号：US14020703
申请日：2013-09-06
申请人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
发明人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30554 , G06F17/3041 , G06F17/30418 , G06F17/30501 , G06F17/30507 , G06F17/30604 , G06F17/30979
摘要： A database language (e.g. SQL) is extended to define a transient field whose value is derived from data stored in a database. The value of the transient field is calculated by the database engine for consumption as needed by the application layer, for example as part of a particular data model. The value of the transient field may not be materialized as a persistent field in the underlying database table, or may be selectively materialized based upon a heuristic or hint. Certain embodiments may implement the transient field as a basic elaboration on standard SQL utilizing an identifier. Some embodiments may implement the transient field as an entity where SQL has been extended to accommodate concepts of a higher-level Entity Relationship Model (ERM). The use of constants and/or floating values (e.g. a current time) in connection with transient fields, is also disclosed.
摘要翻译：数据库语言（例如SQL）被扩展以定义其值从存储在数据库中的数据导出的瞬态字段。瞬态字段的值由应用层需要的数据库引擎计算消耗，例如作为特定数据模型的一部分。瞬态字段的值可能不会实现为底层数据库表中的持久字段，或者可以基于启发式或提示来选择性地实现。某些实施例可以使用标识符来将瞬态字段实现为标准SQL的基本说明。一些实施例可以将瞬态字段实现为已经扩展了SQL以容纳更高级实体关系模型（ERM）的概念的实体。还公开了与瞬态场有关的常数和/或浮动值（例如当前时间）的使用。

2. 发明申请

US20160117364A1 GENERATING IMPERATIVE-LANGUAGE QUERY CODE FROM DECLARATIVE-LANGUAGE QUERY CODE 有权
标题翻译：从宣言语言查询码生成语言语言查询码
公开(公告)号：US20160117364A1
公开(公告)日：2016-04-28
申请号：US14523832
申请日：2014-10-24
申请人： Saeed Jahankhani
发明人： Saeed Jahankhani
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , G06F17/3041
摘要： Innovations in the area of query processing for a database management system (“DBMS”) are presented herein. For example, for a database query, a query engine generates query code in an imperative language (such as a procedural, scripting language) based on query code in a declarative language (such as a structured query language). The query engine can embed the imperative-language query code in an intermediate representation of the database query, which is executed by the DBMS. In many instances (e.g., for non-linear operations of a database query), the imperative-language query code can be executed by the DBMS more quickly and efficiently than the original declarative-language query code. The DBMS returns results of the execution of the database query.
摘要翻译：本文介绍了数据库管理系统（“DBMS”）的查询处理领域的创新。例如，对于数据库查询，查询引擎基于声明式语言（例如结构化查询语言）中的查询代码，以命令式语言（例如过程式脚本语言）生成查询代码。查询引擎可以将命令式语言查询代码嵌入到DBMS执行的数据库查询的中间表示中。在许多情况下（例如，对于数据库查询的非线性操作），命令式语言查询代码可以由DBMS比原始的声明式语言查询代码更快速和有效地执行。 DBMS返回执行数据库查询的结果。

3. 发明授权

US09104724B2 Dynamic bridging of application and data servers 有权
标题翻译：动态桥接应用程序和数据服务器
公开(公告)号：US09104724B2
公开(公告)日：2015-08-11
申请号：US13798364
申请日：2013-03-13
申请人： SAP AG
发明人： Xiaowei Liu , Yingyu Chen
IPC分类号： G06F17/30
CPC分类号： G06F17/3043 , G06F17/3041
摘要： Described herein is a technology to facilitate dynamic bridging of an application server and a data server. In accordance with one aspect, a query script based on source code of an application is generated at the application server. The query script may include at least one placeholder that represents a dynamic term in the source code of the application. The query script may be processed by replacing the placeholder with a static term generated based on one or more values received during execution of the application. The query script is then executed to manage data at a data server.
摘要翻译：这里描述了一种促进应用服务器和数据服务器的动态桥接的技术。根据一个方面，在应用服务器上生成基于应用的源代码的查询脚本。查询脚本可以包括表示应用程序的源代码中的动态项的至少一个占位符。可以通过使用基于在应用程序执行期间接收到的一个或多个值生成的静态术语来替换占位符来处理查询脚本。然后执行查询脚本以管理数据服务器上的数据。

4. 发明授权

US09043315B2 Cooperative model between an application server and a database 有权
标题翻译：应用程序服务器和数据库之间的协作模型
公开(公告)号：US09043315B2
公开(公告)日：2015-05-26
申请号：US12980052
申请日：2010-12-28
申请人： Boris Gruschko , Christian Mohr , Martin Strenge , Reiner Singer , Rolf Hammer , Kai Baumgarten , Helmut Prestel , Sigrid Wortmann , Thomas Elvers , Veit Spaegele , Junhui Liu , Yu Su , Juan Ge , Sebastian Seifert , Jianfeng Yan , Philipp Grosse , Christoph Weyerhaeuser
发明人： Boris Gruschko , Christian Mohr , Martin Strenge , Reiner Singer , Rolf Hammer , Kai Baumgarten , Helmut Prestel , Sigrid Wortmann , Thomas Elvers , Veit Spaegele , Junhui Liu , Yu Su , Juan Ge , Sebastian Seifert , Jianfeng Yan , Philipp Grosse , Christoph Weyerhaeuser
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , G06F9/45558 , G06F17/30076 , G06F17/30292 , G06F17/3041 , G06F17/30424 , G06F17/30861 , G06F17/30914 , G06F2009/45595 , H04L67/10
摘要： Methods and apparatus, including computer program products, are provided for implementing a cooperative model between an application and a database. In one aspect, there is provided a computer-implemented method. The method may include receiving from an application a command to perform an operation at a database; accessing metadata representative of the application; configuring, based on at least the metadata, a result of the operation; and sending the configured result to shared memory accessible by the application. Related apparatus, systems, methods, and articles are also described.
摘要翻译：提供了包括计算机程序产品在内的方法和装置，用于实现应用程序和数据库之间的协作模型。一方面，提供了一种计算机实现的方法。该方法可以包括从应用程序接收在数据库执行操作的命令; 访问代表应用程序的元数据; 至少基于元数据配置操作的结果; 并将配置的结果发送给应用程序可访问的共享内存。还描述了相关装置，系统，方法和制品。

5. 发明授权

US08984018B2 Integrated application server and data server processes with matching data formats 有权
标题翻译：具有匹配数据格式的集成应用服务器和数据服务器进程
公开(公告)号：US08984018B2
公开(公告)日：2015-03-17
申请号：US13919921
申请日：2013-06-17
申请人： Meinolf Block , Martin Strenge , Christian Mohr , Boris Gruschko , Franz Faerber
发明人： Meinolf Block , Martin Strenge , Christian Mohr , Boris Gruschko , Franz Faerber
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , G06F9/45558 , G06F17/30076 , G06F17/30292 , G06F17/3041 , G06F17/30424 , G06F17/30861 , G06F17/30914 , G06F2009/45595 , H04L67/10
摘要： In one embodiment, the present invention includes a computer-implemented method comprising storing data in an application using an application custom data type and application custom data structure. The data is stored in a database using the application custom data type and the application custom data structure. In one embodiment, a request is sent to access the data from the application to the database. The data is retrieved from the database in response to the request in the application custom data type and the application custom data structure. In one embodiment, the data is sent from the database to a shared memory in the application custom data type and the application custom data structure and the data is retrieved by the application from the shared memory in the application custom data type and the application custom data structure.
摘要翻译：在一个实施例中，本发明包括计算机实现的方法，包括使用应用定制数据类型和应用定制数据结构在应用中存储数据。使用应用程序自定义数据类型和应用程序自定义数据结构将数据存储在数据库中。在一个实施例中，发送请求以将数据从应用程序访问到数据库。响应于应用程序自定义数据类型和应用程序自定义数据结构中的请求，从数据库中检索数据。在一个实施例中，数据从应用程序自定义数据类型和应用程序自定义数据结构中的数据库发送到共享存储器，应用程序从应用程序从应用程序自定义数据类型和应用程序自定义数据中的共享内存中检索数据结构体。

6. 发明申请

US20150074140A1 SQL EXTENDED WITH TRANSIENT FIELDS FOR CALCULATION EXPRESSIONS IN ENHANCED DATA MODELS 有权
标题翻译：用于在增强数据模型中计算表达式的瞬态字段扩展的SQL
公开(公告)号：US20150074140A1
公开(公告)日：2015-03-12
申请号：US14020703
申请日：2013-09-06
申请人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
发明人： Daniel Hutzel , Timm Falter , Stefan Baeuerle
IPC分类号： G06F17/30
CPC分类号： G06F17/30554 , G06F17/3041 , G06F17/30418 , G06F17/30501 , G06F17/30507 , G06F17/30604 , G06F17/30979
摘要： A database language (e.g. SQL) is extended to define a transient field whose value is derived from data stored in a database. The value of the transient field is calculated by the database engine for consumption as needed by the application layer, for example as part of a particular data model. The value of the transient field may not be materialized as a persistent field in the underlying database table, or may be selectively materialized based upon a heuristic or hint. Certain embodiments may implement the transient field as a basic elaboration on standard SQL utilizing an identifier. Some embodiments may implement the transient field as an entity where SQL has been extended to accommodate concepts of a higher-level Entity Relationship Model (ERM). The use of constants and/or floating values (e.g. a current time) in connection with transient fields, is also disclosed.
摘要翻译：数据库语言（例如SQL）被扩展以定义其值从存储在数据库中的数据导出的瞬态字段。瞬态字段的值由应用层需要的数据库引擎计算消耗，例如作为特定数据模型的一部分。瞬态字段的值可能不会实现为底层数据库表中的持久字段，也可能会根据启发式或提示进行选择性实现。某些实施例可以使用标识符来将瞬态字段实现为标准SQL的基本说明。一些实施例可以将瞬态字段实现为已经扩展了SQL以容纳更高级实体关系模型（ERM）的概念的实体。还公开了与瞬态场有关的常数和/或浮动值（例如当前时间）的使用。

7. 发明申请

US20150032678A1 OPTIMAL PERSISTENCE OF A BUSINESS PROCESS 有权
标题翻译：业务流程的最佳持续时间
公开(公告)号：US20150032678A1
公开(公告)日：2015-01-29
申请号：US14514901
申请日：2014-10-15
申请人： International Business Machines Corporation
发明人： Abhinay R. Nagpal , Sri Ramanathan , Sandeep Ramesh , Gandhi Sivakumar , Matthew B. Trevathan
IPC分类号： G06N3/08
CPC分类号： G06N3/084 , G06F17/3041 , G06F17/30607 , G06N3/08 , G06Q10/06
摘要： Aspects of the invention provide for automatically selecting optimal fetch settings for business processes as a function of database query load and relational context by monitoring usage of a data retrieval point with respect to a defined unit of work. A multilayer feed-forward neural network is used to predict, as a function of training sets composed of historical data generated by the monitored usage of the data retrieval point, a future value of a data size of results from an eager fetch setting for the data retrieval point. The eager fetch is automatically revised to a lazy fetch setting in response to determining that the future data size value of the eager fetch setting results is larger than a permissible memory resource threshold.
摘要翻译：本发明的方面提供了通过监视关于定义的工作单元的数据检索点的使用来自动地选择作为数据库查询负载和关系上下文的函数的业务处理的最佳提取设置。使用多层前馈神经网络来预测由数据检索点的监视使用产生的历史数据组成的训练集的函数，来自数据的急切取出设置的结果的数据大小的未来值检索点。响应于确定急切取出设置结果的未来数据大小值大于允许的存储器资源阈值，急速提取被自动修改为延迟获取设置。

8. 发明申请

US20130282680A1 Integrated Application Server and Data Server Processes with Matching Data Formats 有权
公开(公告)号：US20130282680A1
公开(公告)日：2013-10-24
申请号：US13919921
申请日：2013-06-17
申请人： Meinolf Block , Martin Strenge , Christian Mohr , Boris Gruschko , Franz Faerber
发明人： Meinolf Block , Martin Strenge , Christian Mohr , Boris Gruschko , Franz Faerber
IPC分类号： G06F17/30
CPC分类号： G06F17/30569 , G06F9/45558 , G06F17/30076 , G06F17/30292 , G06F17/3041 , G06F17/30424 , G06F17/30861 , G06F17/30914 , G06F2009/45595 , H04L67/10
摘要： In one embodiment, the present invention includes a computer-implemented method comprising storing data in an application using an application custom data type and application custom data structure. The data is stored in a database using the application custom data type and the application custom data structure. In one embodiment, a request is sent to access the data from the application to the database. The data is retrieved from the database in response to the request in the application custom data type and the application custom data structure. In one embodiment, the data is sent from the database to a shared memory in the application custom data type and the application custom data structure and the data is retrieved by the application from the shared memory in the application custom data type and the application custom data structure.

9. 发明授权

US08386474B2 Generation of query language parameter file 有权
标题翻译：生成查询语言参数文件
公开(公告)号：US08386474B2
公开(公告)日：2013-02-26
申请号：US12276588
申请日：2008-11-24
申请人： David M. Mobbs , Pierre-Emmanuel Gros
发明人： David M. Mobbs , Pierre-Emmanuel Gros
IPC分类号： G06F7/00
CPC分类号： G06F17/3041
摘要： Some aspects include determination of a data structure including a plurality of query language configuration parameters and at least two values associated with each of the plurality of query language configuration parameters, and generation, based on the data structure, of a first structured language query associated with a first value associated with one of the plurality of query language configuration parameters, and a second structured language query associated with a second value associated with the one of the plurality of query language configuration parameters. Also included are determination of a first expected query result associated with the first structured language query and a second expected query result associated with the second structured language query, query of a data source with the first structured language query and the second structured language query, reception of a first query result associated with the first structured language query and a second query result associated with the second structured language query, determination that the first query result matches the first expected query result and that the second query result does not match the second expected query result, and addition, to a query language configuration parameter file associated with the data source, of the one of the plurality of query language configuration parameters in association with the first value.
摘要翻译：一些方面包括确定包括多个查询语言配置参数的数据结构和与多个查询语言配置参数中的每一个相关联的至少两个值，以及基于数据结构生成与第一结构化语言查询相关联的第一结构化语言查询与所述多个查询语言配置参数之一相关联的第一值以及与所述多个查询语言配置参数中的一个相关联的第二值相关联的第二结构化语言查询。还包括确定与第一结构化语言查询相关联的第一预期查询结果和与第二结构化语言查询相关联的第二预期查询结果，具有第一结构化语言查询和第二结构化语言查询的数据源的查询以及第二结构化语言查询与第一结构化语言查询相关联的第一查询结果和与第二结构化语言查询相关联的第二查询结果，确定第一查询结果与第一预期查询结果匹配，并且第二查询结果与第二预期查询不匹配结果并添加到与数据源相关联的查询语言配置参数文件中，与第一个值相关联的多个查询语言配置参数之一。

10. 发明申请

US20120144388A1 Database Access for Native Applications in a Virtualized Environment 有权
标题翻译：虚拟化环境中本地应用程序的数据库访问
公开(公告)号：US20120144388A1
公开(公告)日：2012-06-07
申请号：US12961221
申请日：2010-12-06
申请人： John Kurian , Ajay Sood , Hariharan N. Venkitachalam
发明人： John Kurian , Ajay Sood , Hariharan N. Venkitachalam
IPC分类号： G06F9/455
CPC分类号： G06F9/45504 , G06F17/3041
摘要： A database may be accessed by creating a virtualized environment on a computer system and instantiating a driver for a database within the virtualized environment. A first execution thread within the virtualized environment is created and a first unique identifier is associated with the first execution thread within the driver for the database. A first connection to the database is then opened from within the first execution thread using the first unique identifier. A first native program containing embedded structured query language (SQL) statements is executed within the first execution thread and the first native program is provided with access to said database using the first connection to said database.
摘要翻译：可以通过在计算机系统上创建虚拟化环境并在虚拟化环境中为数据库实例化驱动程序来访问数据库。虚拟化环境中的第一执行线程被创建，并且第一唯一标识符与数据库的驱动程序内的第一执行线程相关联。然后使用第一个唯一标识符从第一个执行线程中打开到数据库的第一个连接。在第一执行线程内执行包含嵌入式结构化查询语言（SQL）语句的第一本地程序，并且通过与所述数据库的第一连接向第一本机程序提供对所述数据库的访问。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式