SYSTEMS AND METHODS FOR DATA STORAGE AND RETRIEVAL
    3.
    发明公开
    SYSTEMS AND METHODS FOR DATA STORAGE AND RETRIEVAL 审中-公开
    系统和方法用于存储和检索

    公开(公告)号:EP2024812A2

    公开(公告)日:2009-02-18

    申请号:EP07762161.3

    申请日:2007-05-14

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30424 G06F17/30404

    摘要: Systems and methods for storing and accessing data. A query language statement may reference a plurality of data sets and a plurality of algebraic relations between the data sets may be composed from the query language statement. The algebraic relations may be used to define new data sets and to optimize access to data sets. A store of algebraic relations may be accumulated over time. Alternative collections of algebraic relations may be generated and evaluated to determine an optimized collection of algebraic relations to use in calculating and providing a requested data set. The optimization may be performed using the algebraic relations rather than retrieving underlying data sets from storage. As a result, optimization may be performed at processor speeds to minimize the amount of time required for data to be retrieved from slower storage.

    System and method for accessing cobol data with a cobol compatible structured query language
    4.
    发明公开
    System and method for accessing cobol data with a cobol compatible structured query language 失效
    系统与Verfahren zum Zugriffen auf Cobol Daten mit einer Cobol compatibelen SQL

    公开(公告)号:EP0753819A1

    公开(公告)日:1997-01-15

    申请号:EP95304837.8

    申请日:1995-07-11

    发明人: Song, Zhi Yong

    IPC分类号: G06F17/30

    摘要: A system (10) and method enabling use of a COBOL compatible structured query language (CCSQL) to manipulate data stored in a COBOL data file (90), which is in a non-first normal, hierarchical format. Initially, a dictionary generator subsystem (68) creates a corresponding dictionary (74) for each COBOL data file (90). In the dictionary (74), the NF 2 hierarchical logical relationship between the items and attributes (hierarchical nature) of each item of a COBOL data file are defined. Thereafter, whenever a new COBOL data file is produced, a corresponding dictionary is generated. When a user enters a request in the CCSQL format to query a COBOL data file, the request is parsed. The definitions in the dictionary are used by the CCSQL kernel (78) to manipulate the data in response to the user's query. A command interpreter (64) processes the request to determine the appropriate data manipulation to apply and initiates a CCSQL kernel request that carries out the intended action, with reference to the corresponding dictionary (74). For example, the request may require that certain items from a COBOL data file be extracted to produce a report (82). Because the hierarchical logical relationships between the items in the COBOL data are defined in the corresponding dictionary, a CCSQL report generator subsystem can produce the report using data extracted from the COBOL data file in accordance with criteria provided by the user, but without converting the data in the COBOL data files to a 1NF. COBOL programs with embedded CCSQL commands are preprocessed to convert the CCSQL commands to a COBOL compatible structured language that uses the dictionaries to access data referenced in the COBOL data files.

    摘要翻译: 一种能够使用COBOL兼容结构化查询语言(CCSQL)来操纵存储在COBOL数据文件(90)中的数据的系统(10)和方法,所述COBOL数据文件(90)处于非第一正常分级格式。 最初,字典生成器子系统(68)为每个COBOL数据文件(90)创建相应的字典(74)。 在字典(74)中,定义了COBOL数据文件的每个项目的项目与属性(层次性质)之间的NF <2>分层逻辑关系。 此后,每当产生新的COBOL数据文件时,生成相应的字典。 当用户以CCSQL格式输入查询COBOL数据文件的请求时,会对该请求进行解析。 字典中的定义由CCSQL内核(78)用来响应用户的查询来操纵数据。 命令解释器(64)处理请求以确定适当的数据操作,以参考对应的字典(74)来应用并发起执行预期动作的CCSQL内核请求。 例如,请求可能要求提取来自COBOL数据文件的某些项目以产生报告(82)。 因为COBOL数据中的项目之间的层次逻辑关系在相应的字典中定义,所以CCSQL报告生成器子系统可以使用根据用户提供的标准从COBOL数据文件中提取的数据生成报告,但不转换数据 在COBOL中的数据文件到1NF。 具有嵌入式CCSQL命令的COBOL程序被预处理,以将CCSQL命令转换为使用字典访问COBOL数据文件中引用的数据的COBOL兼容结构化语言。

    DATABASE MANAGEMENT DEVICE AND METHOD THEREFOR

    公开(公告)号:EP3343396A1

    公开(公告)日:2018-07-04

    申请号:EP16838935.1

    申请日:2016-07-07

    IPC分类号: G06F17/30

    摘要: [Problem to be Solved]
    To obtain data in which a plurality of pieces of knowledge is linked with a simple data structure.
    [Solution]
    Plural element group data linking data 58 have a plural element group uppermost element data ID of plural element group data 50 in a field 42, an element-associated data ID in a field 43, and a focus attribute ID in a field 44. When a search request specifying a master element data ID is given, element data including the master element data are extracted, the plural element group data linking data 58 including the extracted data ID are extracted, the plural element group data 50 specified by the extracted plural element group data linking data are extracted, and element data linked to the plural element group data 50 are extracted.

    Filtering data from a database
    10.
    发明公开
    Filtering data from a database 审中-公开
    过滤器数据库

    公开(公告)号:EP2902926A1

    公开(公告)日:2015-08-05

    申请号:EP14290023.2

    申请日:2014-01-31

    IPC分类号: G06F17/30

    摘要: Filtering data from a database includes obtaining, at a persistence layer, a administrator defined filter based on criteria of a user, receiving, from the user, a request to obtain data from a database, and filtering, through an API, the data from the database based on the request and the administrator defined filter to create filtered data.

    摘要翻译: 从数据库过滤数据包括基于用户的标准在持久层获得管理员定义的过滤器,从用户接收从数据库获得数据的请求,以及通过API过滤来自数据库的数据 数据库根据请求和管理员定义的过滤器来创建过滤数据。