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

11. 发明公开

EP2901285A1 A SYSTEM AND A METHOD FOR EXECUTING SQL BASIC OPERATORS ON COMPRESSED DATA WITHOUT DECOMPRESSION PROCESS 有权
标题翻译：系统和方法不用解压压缩数据的SQL营办商的执行
公开(公告)号：EP2901285A1
公开(公告)日：2015-08-05
申请号：EP13842661.4
申请日：2013-09-24
申请人： Sqream Technologies Ltd
发明人： VARAKIN, Kostya , GAL, Ami
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30404 , G06F17/30153 , G06F17/30442 , G06F17/30519
摘要： The present invention discloses a method for executing an SQL operator on compressed data chunk. The method comprising the step of: receiving SQL operator, accessing compressed data chunk blocks, receive e full set of derivatives of the compression scheme, check compression rules based on the compression scheme and relevant operator for approving SQL operation on compressed data and in case of approval applying respective SQL operator on relevant compressed data chunks.

12. 发明公开

EP1240604A4 A METHOD AND APPARATUS FOR IMPROVING THE PERFORMANCE OF A GENERATED CODE CACHE SEARCH OPERATION THROUGH THE USE OF STATIC KEY VALUES 有权
标题翻译：用于改善生产KODEPUFFERSUCHEDURCH的性能静态密钥值的使用方法和设备
公开(公告)号：EP1240604A4
公开(公告)日：2008-04-09
申请号：EP00989417
申请日：2000-12-22
申请人： BULL HN INFORMATION SYST
发明人： LEVINE DONALD P , WUNDERLIN ANNE MARIE , EGOLF DAVID A
IPC分类号： G06F17/30 , G06F12/08
CPC分类号： G06F17/30501 , G06F17/30404 , G06F17/30415 , G06F17/30433 , G06F17/3056 , Y10S707/954 , Y10S707/99932 , Y10S707/99933 , Y10S707/99938 , Y10S707/99942
摘要： A cache manager (202) of a relational database management system (RDBMS) (200) is able to bypass time consuming search operations through the use of a key memory structure and locate generated code segments within an SQL cache (202-10) within a minimun of time. The SQL cache (202-10) contains the generated code segments (202-10) used to execute SQL statements (100) as well as the structures and program logic used for maintaining the cache. The key memory structure is located in an area of memory utilized by the SQL runtime routines (201) in executing applications. The routines provide an interface between the application and the RDBMS.

13. 发明公开

EP3365785A1 EVENT BATCHING, OUTPUT SEQUENCING, AND LOG BASED STATE STORAGE IN CONTINUOUS QUERY PROCESSING 审中-公开
公开(公告)号：EP3365785A1
公开(公告)日：2018-08-29
申请号：EP16730951.7
申请日：2016-06-03
申请人： Oracle International Corporation
发明人： PARK, Hoyong , BISHNOI, Sandeep , DESHMUKH, Unmesh Anil , THUKKARAM, Prabhu
IPC分类号： G06F11/14
CPC分类号： G06F11/1471 , G06F9/542 , G06F11/1438 , G06F17/30088 , G06F17/30404 , G06F2201/805 , G06F2201/84
摘要： An event processing system is disclosed that processes events of an event stream, performs the recovery of events during system failure and preserves the state of the system reliably and accurately while achieving desired system performance. In an embodiment, the event processing system processes a first batch of events of a continuous input stream of events using a continuous query and generates an output stream of events related to an application. The event processing system identifies one or more operators of the continuous query and determines that an operator is a journaled operator. The event processing system generates a journaled snapshot of a current state of the system based on execution of the journaled operator on at least the first batch of events and stores the journaled snapshot of the current state of the system.

14. 发明公开

EP2977918A1 A SYSTEM AND METHOD FOR EXECUTING A SPARQL QUERY 审中-公开
标题翻译：系统VERFAHREN ZURAUSFÜHRUNGEINER SPARQL-ABFRAGE
公开(公告)号：EP2977918A1
公开(公告)日：2016-01-27
申请号：EP15175121.1
申请日：2015-07-02
申请人： Tata Consultancy Services Limited
发明人： Banerjee,, Snehasis , Mukherjee,, Debnath
IPC分类号： G06F17/30
CPC分类号： G06F17/30404 , G06F17/30392 , G06F17/30522 , G06F17/30528 , G06F17/30864
摘要： The present disclosure provides system and method for executing SPARQL query on a SPARQL engine. For executing the SPARQL query, a function may be instantly integrated with the SPARQL query which leads to extension of the SPARQL query. The extension may be achieved through a user friendly interface which may allow transparent integration of code (i.e., the function) in any language such as JAVA, C, C++ and the like, supporting a particular functionality. The system may integrate the code by addition of newly added code to the SPARQL library after validation. Further, the system may analyze the functionality associated with the code to optimize decision making of a user. The system may further support auto compilation and rating of the functions based on the user feedback and re-usability of the code working in a collaborative environment. Further the system may enable also enable to integrate external tools and web services.
摘要翻译：本公开提供了用于在SPARQL引擎上执行SPARQL查询的系统和方法。对于执行SPARQL查询，可以立即将功能与SPARQL查询集成，从而导致SPARQL查询的扩展。扩展可以通过用户友好的界面来实现，该界面可以允许以支持特定功能的任何语言（例如JAVA，C，C ++等）的代码（即，功能）的透明集成。验证后，系统可以通过添加新添加的代码到SPARQL库来集成代码。此外，系统可以分析与代码相关联的功能以优化用户的决策。该系统还可以基于在协作环境中工作的代码的用户反馈和可重用性来支持功能的自动编译和评级。此外，系统还可以使得能够集成外部工具和web服务。

15. 发明公开

EP2919132A1 Method for automatic generation of test data for testing a data warehouse system 审中-公开
标题翻译： Verfahren zur automatischen Erzeugung von Testdaten zum Testen eines数据仓库系统
公开(公告)号：EP2919132A1
公开(公告)日：2015-09-16
申请号：EP14158651.1
申请日：2014-03-10
申请人： periplus instruments GmbH & Co. KG
发明人： Ehmke, Dierk
IPC分类号： G06F17/30 , G06F11/36
CPC分类号： G06F17/30404 , G06F11/3668
摘要： A method for the automatic generation of test data for testing a data warehouse system is provided, comprising the steps of obtaining a source code of the data warehouse system to be tested, transforming the source code into an intermediate representation, analysing the intermediate representation to obtain a flow graph and a set of constraints associated with nodes of the flow graph, determining one or more flow paths in the flow graph, determining as combined constraints for each flow path the constraints associated with the nodes of the flow path combined by logical conjunction, and generating test data that meet the combined constraints of at least one of the one or more flow paths.
摘要翻译：提供一种用于自动生成用于测试数据仓库系统的测试数据的方法，包括以下步骤：获得要测试的数据仓库系统的源代码，将源代码转换为中间表示，分析中间表示以获得流程图和与流程图的节点相关联的一组约束，确定流程图中的一个或多个流动路径，确定与通过逻辑连接组合的流动路径的节点相关联的约束的每个流动路径的组合约束，以及生成满足所述一个或多个流动路径中的至少一个的组合约束的测试数据。

16. 发明公开

EP2386965A1 Performing complex operations in a database using a semantic layer 审中-公开
标题翻译：使用语义层在数据库中的复杂过程的实施
公开(公告)号：EP2386965A1
公开(公告)日：2011-11-16
申请号：EP11003923.7
申请日：2011-05-12
申请人： SAP AG
发明人： Faerber, Franz , Baeumges, Daniel , Mindnich, Tobias , Weyerhaeuser, Christoph
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30315 , G06F17/30404 , G06F17/30433 , G06F17/30471
摘要： The present invention includes a database with a semantic layer for performing standard SQL and complex operations custom to one or more application. In one embodiment the present invention includes receiving a data request from an application in a database, the data request specifying standard SQL operations and custom application operations to be performed for said application. The data request is processed in a semantic layer of the database. The semantic layer processes the standard SQL operations and the custom application operations and generates a logical execution plan comprising the standard SQL operations and the custom application operations. The logical execution plan is converted into a physical execution plan, which is executed by the database to generate a data result. The data result may be sent back to the application.
摘要翻译：本发明包括与用于定制的一个或多个应用程序中执行标准的SQL和复杂的操作的语义层的数据库。在一个实施方案，本发明包括从在应用数据库中的接收到的数据请求，该数据请求指定标准SQL操作和自定义应用程序的操作得以执行用于所述应用程序。数据请求在数据库中的一个语义层处理。语义层处理标准的SQL操作和自定义应用程序的操作和基因利率逻辑执行计划，包括标准的SQL操作和自定义应用程序的操作。逻辑执行计划被转换成物理执行计划，所有这一切都被数据库执行以产生一个数据结果。数据结果可以被发送回给应用程序。

17. 发明公开

EP2021952A1 VERFAHREN ZUM STEUERN EINES RELATIONALEN DATENBANKSYSTEMS 审中-公开
标题翻译： VERFAHREN ZUM STEUERN EINES RELATEDEN DATENBANKSYSTEMS
公开(公告)号：EP2021952A1
公开(公告)日：2009-02-11
申请号：EP07701305.0
申请日：2007-02-06
申请人： Mediareif Möstl & Reif Kommunikations- und Informationstechnologien OEG
发明人： MÖSTL, Matthias
IPC分类号： G06F17/30
CPC分类号： G06F17/30404 , G06F17/30433 , G06F17/30436 , G06F17/30587
摘要： The invention relates to a relational database system, wherein a request statement which is to be serviced and which comprises key words is initially analysed using a recursive transition network (RTN) and is converted into control commands. Said method comprises the following steps: the RTN is defined in a presetting step by forming RTN modules which are independent from one another, by means of an internal, oriented decision graph and optionally at least one recursive call function; one reference group, which is independent from the RTN modules and the elements thereof referring to the remaining decision graphs released from the first decision graph thereof, is formed; a reference execution step is used and the remaining decision graph that can prescribe the recursive call function, is transversed and an optimum access plan for the relational database system is generated.
摘要翻译：本发明涉及一种关系数据库系统，其中要被服务并且包括关键字的请求语句最初使用递归转换网络（RTN）被分析并被转换成控制命令。所述方法包括以下步骤：在预设步骤中通过形成彼此独立的RTN模块，借助于内部的，定向的决策图和可选的至少一个递归调用函数来定义RTN; 形成一个独立于RTN模块及其元素的参考组，其参考从其第一个决策图释放的剩余决策图; 使用参考执行步骤，并且可以规定递归调用函数的其余决策图被横截，并且生成用于关系数据库系统的最佳访问计划。

18. 发明公开

EP3343411A1 SQL AUDITING METHOD AND APPARATUS, SERVER AND STORAGE DEVICE 审中-公开
公开(公告)号：EP3343411A1
公开(公告)日：2018-07-04
申请号：EP17800997.3
申请日：2017-05-09
申请人： Ping An Technology (Shenzhen) Co., Ltd.
发明人： HOU, Song , WONG, Yeung
IPC分类号： G06F17/30
CPC分类号： G06F17/30404
摘要： A method of reviewing SQL includes: obtaining slow log data; extracting a SQL sentence to be reviewed and basic information matched with the SQL sentence from the slow log data; identifying and parsing the SQL sentence to obtain a parsed result; reviewing the parsed result and/or the basic information in accordance with review items in a preset review template one by one to obtain a review result; and generating a review result set according to the review result.

19. 发明公开

EP3301590A1 ALGEBRAIC DATA TYPES FOR DATABASE QUERY LANGUAGES 审中-公开
标题翻译：用于数据库查询语言的代数数据类型
公开(公告)号：EP3301590A1
公开(公告)日：2018-04-04
申请号：EP17179535.4
申请日：2017-07-04
申请人： Semmle Limited
发明人： SCHAEFER, Max , EYERS-TAYLOR, Alexander
IPC分类号： G06F17/30
CPC分类号： G06F17/30427 , G06F17/30342 , G06F17/30404 , G06F17/30513
摘要： Methods, systems, and apparatus, including computer programs encoded on computer storage media, for implementing algebraic data types in database query languages. One of the methods includes receiving an expression in a database query language, the expression having a programming language construct representing an algebraic data type, wherein the expression specifies two or more alternative subtypes. Respective domain relations are generated using definitions of each of the alternative subtypes within the expression. Unique domain identifiers are assigned among domain tuples belonging to each alternative subtype. A union relation is generated for the algebraic data type. Unique union identifiers are assigned for union tuples belonging to the union relation. Respective injector relations are generated for each of the alternative subtypes.
摘要翻译：包括在计算机存储介质上编码的计算机程序的方法，系统和装置，用于在数据库查询语言中实现代数数据类型。其中一种方法包括以数据库查询语言接收表达式，该表达式具有表示代数数据类型的编程语言结构，其中该表达式指定两个或更多个替代的子类型。使用表达式中每个替代子类型的定义来生成各个域关系。唯一的域标识符分配给属于每个备选子类型的域元组。为代数数据类型生成一个联合关系。唯一的联合标识符被分配给属于联合关系的联合元组。针对每个替代子类型生成相应的注射器关系。

20. 发明公开

EP2996048A1 Method and device for processing information 审中-公开
标题翻译： Verfahren und Vorrichtung zur Verarbeitung von Informationen
公开(公告)号：EP2996048A1
公开(公告)日：2016-03-16
申请号：EP14200683.2
申请日：2014-12-30
申请人： Baidu Online Network Technology (Beijing) Co., Ltd
发明人： Liang, Bian , Guo, Xie , Sun, Yongyi , Liu, Sheng , Zhang, Daoquan , Wang, Yuxian , Shi, Xiaofeng , Wang, Yong , Chen, Yujian , Li, Chengqi , Liu, Xiaolin , Zhu, Xujia , Ren, Feng
IPC分类号： G06F17/30
CPC分类号： G06F17/30483 , G06F17/30404 , G06F17/30427
摘要： The embodiments of the present invention provide a method for processing information, comprising: obtaining attribute information about a target field; obtaining, according to the attribute information about the target field, attribute information about the target field described in a first language; and sending the attribute information about the target field described in the first language to a query engine using the first language, so that the query engine obtains, according to the attribute information about the target field described in the first language, data corresponding to the target field; and the embodiments of the present invention also provide an apparatus for processing information. According to the technical solutions provided in the embodiments of the present invention, attribute information about a target field being automatically described in a language can be realized, so as to improve the query efficiency of data.
摘要翻译：本发明的实施例提供了一种处理信息的方法，包括：获取关于目标字段的属性信息; 根据关于目标字段的属性信息，获得关于以第一语言描述的目标字段的属性信息; 以及使用所述第一语言将关于所述第一语言描述的目标字段的属性信息发送到查询引擎，使得所述查询引擎根据关于所述第一语言描述的目标字段的属性信息，获得与所述目标对应的数据领域; 并且本发明的实施例还提供了一种用于处理信息的装置。根据本发明实施例提供的技术方案，可以实现以语言自动描述的关于目标字段的属性信息，从而提高数据的查询效率。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式