-
公开(公告)号：US20150066839A1
公开(公告)日：2015-03-05
申请号：US14298750
申请日：2014-06-06
发明人： Cassio S. DOS SANTOS , Kunjavihari M. KASHALIKAR , Jean-Claude Mamou , Kishore Patel , Rong Qu , Hong X. Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30294 , G06F17/30418
摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.
-
公开(公告)号：US11341135B2
公开(公告)日：2022-05-24
申请号：US16804103
申请日：2020-02-28
IPC分类号： G06F16/24 , G06F16/2453 , G06F16/21
摘要： An approach is provided for optimizing data fetching. A query employing a method to fetch data from a JSON document is received. An amount of time required to execute the query and a number of nested layers in a traversal of the JSON document required to fetch the data are determined. Based on the amount of time and the number of nested layers, a cost associated with an execution of the query is calculated. The cost is determined to exceed a threshold value. Responsive to the determination that the cost exceeds the threshold value and using historical query patterns and historical query execution times, a schema of the JSON document is re-designed. The data is fetched from the JSON document using the re-designed schema.
-
公开(公告)号：US20210271678A1
公开(公告)日：2021-09-02
申请号：US16804103
申请日：2020-02-28
IPC分类号： G06F16/2453 , G06F16/21
摘要： An approach is provided for optimizing data fetching. A query employing a method to fetch data from a JSON document is received. An amount of time required to execute the query and a number of nested layers in a traversal of the JSON document required to fetch the data are determined. Based on the amount of time and the number of nested layers, a cost associated with an execution of the query is calculated. The cost is determined to exceed a threshold value. Responsive to the determination that the cost exceeds the threshold value and using historical query patterns and historical query execution times, a schema of the JSON document is re-designed. The data is fetched from the JSON document using the re-designed schema.
-
公开(公告)号：US09720960B2
公开(公告)日：2017-08-01
申请号：US14298750
申请日：2014-06-06
发明人： Cassio S. Dos Santos , Kunjavihari M. Kashalikar , Jean-Claude Mamou , Kishore Patel , Rong Qu , Hong X. Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30294 , G06F17/30418
摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.
-
公开(公告)号：US09342555B2
公开(公告)日：2016-05-17
申请号：US14015105
申请日：2013-08-30
发明人： Cassio S. Dos Santos , Kunjavihari M. Kashalikar , Jean-Claude Mamou , Kishore Patel , Rong Qu , Hong X. Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30294 , G06F17/30418
摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.
摘要翻译： 从视图定义生成视图模式，其中视图模式包括通过将视图定义中的一个或多个对象查询转换成一个或多个关系查询而创建的一个或多个关系视图。 通过以下方式从视图定义生成报告设计模式：创建一个或多个与视图模式的一个或多个关系视图对应的报表，并扩展一个或多个主键约束和一个或多个主键约束的报表 外键限制。 通过对报告设计模式进行逆向工程来生成报告模型，其中报告模型包括一个或多个主键约束和一个或多个外键约束。 使用报告模型生成报告，其中报告包括一个或多个主键约束和一个或多个外键约束。
-
公开(公告)号：US20150066975A1
公开(公告)日：2015-03-05
申请号：US14015105
申请日：2013-08-30
发明人： Cassio S. DOS SANTOS , Kunjavihari M. KASHALIKAR , Jean-Claude Mamou , Kishore Patel , Rong Qu , Hong X. Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30294 , G06F17/30418
摘要： A view schema is generated from a view definition, wherein the view schema includes one or more relational views that are created by translating one or more object queries in the view definition into one or more relational queries. A report design schema is generated from the view definition by: creating one or more report tables that correspond to the one or more relational views of the view schema and extending the one or more report tables with one or more primary key constraints and one or more foreign key constraints. A reporting model is generated by reverse engineering the report design schema, wherein the reporting model includes the one or more primary key constraints and the one or more foreign key constraints. A report is generated using the reporting model, wherein the report includes the one or more primary key constraints and the one or more foreign key constraints.
摘要翻译： 从视图定义生成视图模式，其中视图模式包括通过将视图定义中的一个或多个对象查询转换成一个或多个关系查询而创建的一个或多个关系视图。 通过以下方式从视图定义生成报告设计模式：创建一个或多个与视图模式的一个或多个关系视图对应的报表，并扩展一个或多个主键约束和一个或多个主键约束的报表 外键限制。 通过对报告设计模式进行逆向工程来生成报告模型，其中报告模型包括一个或多个主键约束和一个或多个外键约束。 使用报告模型生成报告，其中报告包括一个或多个主键约束和一个或多个外键约束。
-
-
-
-
-
搜索结果
6 条记录 (耗时 0.018 秒)
