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

1. 发明授权

US09710536B2 Method and system for validating data 有权
公开(公告)号：US09710536B2
公开(公告)日：2017-07-18
申请号：US13465329
申请日：2012-05-07
申请人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
发明人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F7/026 , G06F17/30563 , G06F17/30592
摘要： A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. A data validation is performed, the data validation being based on a matching relationship between MDS1 and S.

2. 发明申请

US20110246415A1 METHOD AND SYSTEM FOR VALIDATING DATA 失效
标题翻译：用于确认数据的方法和系统
公开(公告)号：US20110246415A1
公开(公告)日：2011-10-06
申请号：US13032681
申请日：2011-02-23
申请人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
发明人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
IPC分类号： G06F17/30
CPC分类号： G06F7/026 , G06F17/30563 , G06F17/30592
摘要： A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. Whether MDS1 matches S is determined. If MDS1 doesn't match S, then an OLAP inverse transformation is performed on MDS1 to generate an OLAP dataset (MDS2) and whether MDS2 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S, then an ETF inverse transformation is performed on MDS2 to generate an ETL dataset (MDS3) and whether MDS2 matches MDS1 and whether MDS3 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S and MDS3 does not match S, then whether MDS3 matches MDS2 is determined.
摘要翻译：一种验证数据的方法和系统。仓库数据是通过ETL转换模型转换源数据生成的。通过OLAP转换模型转换仓库数据生成数据立方体。从数据立方体生成报表数据集（MDS1）。从源数据生成参考数据集（S）。确定MDS1是否匹配S。如果MDS1与S不匹配，则在MDS1上执行OLAP逆变换以生成OLAP数据集（MDS2），并确定MDS2是否匹配S。如果MDS1与S不匹配，MDS2与S不匹配，则在MDS2上进行ETF逆变换，生成ETL数据集（MDS3），MDS2是否匹配MDS1，MDS3是否匹配S。如果MDS1与S不匹配，MDS2与S不匹配，MDS3与S不匹配，则确定MDS3是否匹配MDS2。

3. 发明申请

US20120221510A1 METHOD AND SYSTEM FOR VALIDATING DATA 审中-公开
标题翻译：用于确认数据的方法和系统
公开(公告)号：US20120221510A1
公开(公告)日：2012-08-30
申请号：US13465329
申请日：2012-05-07
申请人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
发明人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F7/026 , G06F17/30563 , G06F17/30592
摘要： A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. A data validation is performed, the data validation being based on a matching relationship between MDS1 and S.
摘要翻译：一种验证数据的方法和系统。仓库数据是通过ETL转换模型转换源数据生成的。通过OLAP转换模型转换仓库数据生成数据立方体。从数据立方体生成报表数据集（MDS1）。从源数据生成参考数据集（S）。执行数据验证，数据验证基于MDS1和S之间的匹配关系。

4. 发明申请

US20170212725A9 METHOD AND SYSTEM FOR VALIDATING DATA 审中-公开
公开(公告)号：US20170212725A9
公开(公告)日：2017-07-27
申请号：US13465329
申请日：2012-05-07
申请人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
发明人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F7/026 , G06F17/30563 , G06F17/30592
摘要： A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. A data validation is performed, the data validation being based on a matching relationship between MDS1 and S.

5. 发明授权

US08219520B2 Method and system for validating data 失效
标题翻译：验证数据的方法和系统
公开(公告)号：US08219520B2
公开(公告)日：2012-07-10
申请号：US13032681
申请日：2011-02-23
申请人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
发明人： Xue C. Li , Xiao J. Fu , Xue F. Gao , Xin Xin
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F7/026 , G06F17/30563 , G06F17/30592
摘要： A method and system for validating data. Warehouse data is generated by transforming source data via an ETL transformation model. A data cube is generated by transforming the warehouse data via an OLAP transformation model. A report dataset (MDS1) is generated from the data cube. A reference dataset (S) is generated from the source data. Whether MDS1 matches S is determined. If MDS1 doesn't match S, then an OLAP inverse transformation is performed on MDS1 to generate an OLAP dataset (MDS2) and whether MDS2 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S, then an ETF inverse transformation is performed on MDS2 to generate an ETL dataset (MDS3) and whether MDS2 matches MDS1 and whether MDS3 matches S is determined. If MDS1 doesn't match S and MDS2 does not match S and MDS3 does not match S, then whether MDS3 matches MDS2 is determined.
摘要翻译：一种验证数据的方法和系统。仓库数据是通过ETL转换模型转换源数据生成的。通过OLAP转换模型转换仓库数据生成数据立方体。从数据立方体生成报表数据集（MDS1）。从源数据生成参考数据集（S）。确定MDS1是否匹配S。如果MDS1与S不匹配，则在MDS1上执行OLAP逆变换以生成OLAP数据集（MDS2），并确定MDS2是否匹配S。如果MDS1与S不匹配，MDS2与S不匹配，则在MDS2上进行ETF逆变换，生成ETL数据集（MDS3），MDS2是否匹配MDS1，MDS3是否匹配S。如果MDS1与S不匹配，MDS2与S不匹配，MDS3与S不匹配，则确定MDS3是否匹配MDS2。

6. 发明申请

US20120169713A1 AUTOMATICALLY GENERATING REPORTS MATCHING USER INTERESTS REPRESENTED IN A DYNAMICALLY ADJUSTED USER INTEREST ANALYTIC MODEL 有权
标题翻译：自动生成报告与动态调整用户兴趣分析模型中表示的用户兴趣相匹配
公开(公告)号：US20120169713A1
公开(公告)日：2012-07-05
申请号：US12984121
申请日：2011-01-04
申请人： Xue F. Gao , Anh Q. Lu
发明人： Xue F. Gao , Anh Q. Lu
IPC分类号： G06T15/00
CPC分类号： G06Q10/0637
摘要： A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.
摘要翻译：一种用于自动生成与动态调整的用户兴趣分析模型（UIAM）中表示的用户兴趣相匹配的报告的方法和程序产品。基于用户访问商业智能应用程序生成多维表达式（MDX）查询。基于初始用户访问，通过在第一组UIAM项目中包括第一组用户兴趣的表示来构造基于立方体的UIAM。基于立方体的UIAM被转换为基于数据仓库的UIAM。基于随后的用户访问，更新UIAM项目以表示第二组用户兴趣，并且调整UIAM项目分数以指定用户访问指示频率和最近的用户兴趣。检测到数据仓库中的数据更新。生成代表由具有最高k分数的更新的UIAM项目表示的用户兴趣的报告。

7. 发明授权

US08515897B2 Automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model 有权
标题翻译：在动态调整的用户兴趣分析模型中自动生成与用户兴趣相匹配的报表
公开(公告)号：US08515897B2
公开(公告)日：2013-08-20
申请号：US12984121
申请日：2011-01-04
申请人： Xue F. Gao , Anh Q. Lu
发明人： Xue F. Gao , Anh Q. Lu
IPC分类号： G06F17/30
CPC分类号： G06Q10/0637
摘要： A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.
摘要翻译：一种用于自动生成与动态调整的用户兴趣分析模型（UIAM）中表示的用户兴趣相匹配的报告的方法和程序产品。基于用户访问商业智能应用程序生成多维表达式（MDX）查询。基于初始用户访问，通过在第一组UIAM项目中包括第一组用户兴趣的表示来构造基于立方体的UIAM。基于立方体的UIAM被转换为基于数据仓库的UIAM。基于随后的用户访问，更新UIAM项目以表示第二组用户兴趣，并且调整UIAM项目分数以指定用户访问指示频率和最近的用户兴趣。检测到数据仓库中的数据更新。生成代表由具有最高k分数的更新的UIAM项目表示的用户兴趣的报告。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式