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

1. 发明授权

US09639542B2 Dynamic mapping of extensible datasets to relational database schemas 有权
公开(公告)号：US09639542B2
公开(公告)日：2017-05-02
申请号：US14339398
申请日：2014-07-23
申请人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
发明人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
IPC分类号： G06F17/30 , G06F19/28 , G06F19/00
CPC分类号： G06F17/30091 , G06F17/3012 , G06F17/30292 , G06F17/30315 , G06F17/30339 , G06F17/30864 , G06F17/30917 , G06F17/30952 , G06F17/30997 , G06F19/28 , G06F19/70
摘要： A text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Keys are retrieved from the content lines. For each key, a data type and a number from at least one metadata table is retrieved. Using a combination of each key and the corresponding data type and number, a column title is derived. Upon verification that the derived column title does not already exist, a column for each key is generated in a content table having a dynamic structure in a relational database schema. The column has the derived column title, a column type based on the corresponding retrieved data type, and the number of generated columns determined by the corresponding retrieved number. The retrieved value is mapped into the column associated with the corresponding key.

2. 发明授权

US09916313B2 Mapping of extensible datasets to relational database schemas 有权
公开(公告)号：US09916313B2
公开(公告)日：2018-03-13
申请号：US14339391
申请日：2014-07-23
申请人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
发明人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
IPC分类号： G06F7/00 , G06F17/30 , G06F19/28 , G06F19/00 , G06F17/00
CPC分类号： G06F17/30091 , G06F17/3012 , G06F17/30292 , G06F17/30315 , G06F17/30339 , G06F17/30864 , G06F17/30917 , G06F17/30952 , G06F17/30997 , G06F19/28 , G06F19/70
摘要： Data including a text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Metadata from the metadata lines is mapped to a plurality of metadata tables in a database that are formed according to a relational database schema using prefix parameters from each metadata line. Content from the content lines is mapped to a plurality of content tables in the database that are formed according to the relational database schema using the header line. A first subset of the content tables have a static structure and a second subset of the content tables have a dynamic structure. Related apparatus, systems, techniques and articles are also described.

3. 发明申请

US20150234870A1 DYNAMIC MAPPING OF EXTENSIBLE DATASETS TO RELATIONAL DATABASE SCHEMAS 有权
标题翻译：将可扩展数据库动态映射到关系数据库方案
公开(公告)号：US20150234870A1
公开(公告)日：2015-08-20
申请号：US14339398
申请日：2014-07-23
申请人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
发明人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
IPC分类号： G06F17/30
CPC分类号： G06F17/30091 , G06F17/3012 , G06F17/30292 , G06F17/30315 , G06F17/30339 , G06F17/30864 , G06F17/30917 , G06F17/30952 , G06F17/30997 , G06F19/28 , G06F19/70
摘要： A text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Keys are retrieved from the content lines. For each key, a data type and a number from at least one metadata table is retrieved. Using a combination of each key and the corresponding data type and number, a column title is derived. Upon verification that the derived column title does not already exist, a column for each key is generated in a content table having a dynamic structure in a relational database schema. The column has the derived column title, a column type based on the corresponding retrieved data type, and the number of generated columns determined by the corresponding retrieved number. The retrieved value is mapped into the column associated with the corresponding key.
摘要翻译：收到一个文本文件。文本文件以可扩展格式排列，并且包括多个元数据行，标题行和多个内容行。从内容行检索密钥。对于每个密钥，检索来自至少一个元数据表的数据类型和数字。使用每个键和相应的数据类型和数字的组合，导出列标题。在确认派生列标题不存在的情况下，在关系数据库模式中具有动态结构的内容表中生成每个密钥的列。该列具有派生列标题，基于相应检索数据类型的列类型，以及由相应检索号码确定的生成列数。检索到的值被映射到与相应键相关联的列中。

4. 发明申请

US20150234842A1 Mapping of Extensible Datasets to Relational Database Schemas 有权
标题翻译：将可扩展数据集映射到关系数据库模式
公开(公告)号：US20150234842A1
公开(公告)日：2015-08-20
申请号：US14339391
申请日：2014-07-23
申请人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
发明人： Srinivasan Kumar , Anja Bog , Kannan Avudai , Enakshi Singh
IPC分类号： G06F17/30 , G06F19/28
CPC分类号： G06F17/30091 , G06F17/3012 , G06F17/30292 , G06F17/30315 , G06F17/30339 , G06F17/30864 , G06F17/30917 , G06F17/30952 , G06F17/30997 , G06F19/28 , G06F19/70
摘要： Data including a text file is received. The text file is arranged in an extensible format and includes a plurality of metadata lines, a header line, and a plurality of content lines. Metadata from the metadata lines is mapped to a plurality of metadata tables in a database that are formed according to a relational database schema using prefix parameters from each metadata line. Content from the content lines is mapped to a plurality of content tables in the database that are formed according to the relational database schema using the header line. A first subset of the content tables have a static structure and a second subset of the content tables have a dynamic structure. Related apparatus, systems, techniques and articles are also described.
摘要翻译：收到包含文本文件的数据。文本文件以可扩展格式排列，并且包括多个元数据行，标题行和多个内容行。来自元数据行的元数据被映射到使用来自每个元数据行的前缀参数的根据关系数据库模式形成的数据库中的多个元数据表。来自内容行的内容被映射到数据库中根据使用标题行的关系数据库模式形成的多个内容表。内容表的第一个子集具有静态结构，内容表的第二个子集具有动态结构。还描述了相关设备，系统，技术和物品。

5. 发明授权

US09626421B2 ETL-less zero-redundancy system and method for reporting OLTP data 有权
公开(公告)号：US09626421B2
公开(公告)日：2017-04-18
申请号：US12234497
申请日：2008-09-19
申请人： Hasso Plattner , Anja Bog , Jan Schaffner , Jens Krueger , Alexander Zeier
发明人： Hasso Plattner , Anja Bog , Jan Schaffner , Jens Krueger , Alexander Zeier
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30477 , G06F17/30315 , G06F17/30377 , G06F17/30584 , G06F17/30592 , G06F17/30595
摘要： A system includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in said column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in said column format. In this manner, the system is able to generate up-to-date reports without the need for extraction, translation and loading procedures.

6. 发明申请

US20090240663A1 ETL-Less Zero-Redundancy System and Method for Reporting OLTP Data 有权
标题翻译： ETL-Less零冗余系统和报告OLTP数据的方法
公开(公告)号：US20090240663A1
公开(公告)日：2009-09-24
申请号：US12234497
申请日：2008-09-19
申请人： Hasso Plattner , Anja Bog , Jan Schaffner , Jens Krueger , Alexander Zeier
发明人： Hasso Plattner , Anja Bog , Jan Schaffner , Jens Krueger , Alexander Zeier
IPC分类号： G06F17/30
CPC分类号： G06F17/30477 , G06F17/30315 , G06F17/30377 , G06F17/30584 , G06F17/30592 , G06F17/30595
摘要： In one embodiment the present invention includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column-oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in said column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in said column format. In this manner, an embodiment of the present invention is able to generate up-to-date reports without the need for extraction, translation and loading procedures.
摘要翻译：在一个实施例中，本发明包括关系数据库管理系统组件和面向列的数据处理组件。关系数据库系统组件以行格式存储数据库信息。列列数据处理组件以列格式存储数据库信息。响应于数据库更新请求，关系数据库管理系统组件更新以行格式存储的数据库信息; 关系数据库管理系统组件通知数据库更新请求的面向列的数据处理组件; 并且面向列的数据处理组件更新以所述列格式存储的数据库信息。响应于查询请求，面向列的数据处理组件基于以所述列格式存储的数据库信息生成查询响应。以这种方式，本发明的实施例能够生成最新的报告，而不需要提取，翻译和加载过程。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式