会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 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
    • Unimark Holdings Limited
    • Song, Zhi Yong
    • G06F17/30
    • G06F17/30404G06F17/30427G06F17/30569Y10S707/99934
    • 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兼容结构化语言。