会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Efficiently updating rows in a data warehouse
    • 有效地更新数据仓库中的行
    • US08868484B2
    • 2014-10-21
    • US12832084
    • 2010-07-08
    • Nitin Aggarwal
    • Nitin Aggarwal
    • G06F17/30
    • G06F17/30592G06F17/30377
    • An aspect of the present invention facilitates efficient updating of rows in a data warehouse. In one embodiment, a sequence of identifiers is allocated to rows of data elements received earlier, and then inserted along with the received data elements in a table according to the defined by the sequence of identifiers. On receiving data elements as updates to the rows having associated identifiers, the received data elements are sorted according to the order of the associated identifiers and updates of the rows are performed successively in the sorted order of identifiers. According to another aspect, the above features are performed when (target) fact/dimension tables in the data warehouse are sought to be updated based on transformations/computations performed on data in other (source) fact/dimension tables.
    • 本发明的一个方面有助于有效地更新数据仓库中的行。 在一个实施例中,将标识符序列分配给先前接收的数据元素的行,然后根据由标识符序列定义的接收到的数据元素一起插入到表中。 在接收到具有相关联标识符的行的更新的数据元素时,根据相关标识符的顺序对接收的数据元素进行排序,并且以排序的标识符顺序连续执行行的更新。 根据另一方面,当基于对其他(源)事实/维度表中的数据执行的变换/计算,寻求数据仓库中的(目标)事实/维度表被寻求更新时执行上述特征。
    • 9. 发明授权
    • Techniques for transforming and loading data into a fact table in a data warehouse
    • 将数据转换和加载到数据仓库中的事实表中的技术
    • US08352458B2
    • 2013-01-08
    • US12116693
    • 2008-05-07
    • Nitin Aggarwal
    • Nitin Aggarwal
    • G06F17/30
    • G06F17/30489G06F17/30563G06F17/30592
    • Techniques for transforming records prior to loading the records into a data warehouse in an efficient manner. In one embodiment, instead of using lookup transformations, a database operation such as an outer join operation is used to transform records stored in a fact staging table to add foreign keys to the records corresponding to the dimension tables that are associated with a fact table in a data warehouse to which the records are to be loaded. Since the outer join operation is memory intensive, a determination is made as to which dimension tables from the multiple dimension tables associated with the fact table are suitable, from a performance perspective, for the outer join operation. Only those suitable dimension tables are outer joined to the fact staging table to add the foreign keys for the outer joined dimension tables to the fact staging table records. Lookup transformations may be used to add foreign keys to the fact staging table records for the non-suitable dimension tables. The transformed fact records with the foreign keys may then be loaded into the fact table in the data warehouse.
    • 在将记录以有效的方式加载到数据仓库之前转换记录的技术。 在一个实施例中,代替使用查找变换,使用数据库操作(诸如外连接操作)来转换存储在事实暂存表中的记录,以将外键添加到对应于与事实表相关联的维度表的记录 要加载记录的数据仓库。 由于外部联接操作是内存密集型的,因此从外部连接操作的性能角度确定来自与事实表相关联的多个维度表的哪些维度表是适合的。 只有那些合适的维度表外部连接到事实暂存表,以将外部连接的维度表的外键添加到事实暂存表记录中。 查找转换可用于将外键添加到非合适维度表的事实暂存表记录中。 可以将具有外键的转换后的事实记录加载到数据仓库中的事实表中。
    • 10. 发明申请
    • TECHNIQUES FOR TRANSFORMING AND LOADING DATA INTO A FACT TABLE IN A DATA WAREHOUSE
    • 将数据转换和加载到数据仓库中的表格的技术
    • US20090281985A1
    • 2009-11-12
    • US12116693
    • 2008-05-07
    • Nitin Aggarwal
    • Nitin Aggarwal
    • G06F17/30
    • G06F17/30489G06F17/30563G06F17/30592
    • Techniques for transforming records prior to loading the records into a data warehouse in an efficient manner. In one embodiment, instead of using lookup transformations, a database operation such as an outer join operation is used to transform records stored in a fact staging table to add foreign keys to the records corresponding to the dimension tables that are associated with a fact table in a data warehouse to which the records are to be loaded. Since the outer join operation is memory intensive, a determination is made as to which dimension tables from the multiple dimension tables associated with the fact table are suitable, from a performance perspective, for the outer join operation. Only those suitable dimension tables are outer joined to the fact staging table to add the foreign keys for the outer joined dimension tables to the fact staging table records. Lookup transformations may be used to add foreign keys to the fact staging table records for the non-suitable dimension tables. The transformed fact records with the foreign keys may then be loaded into the fact table in the data warehouse.
    • 在将记录以有效的方式加载到数据仓库之前转换记录的技术。 在一个实施例中,代替使用查找变换,使用诸如外连接操作之类的数据库操作来转换存储在事实暂存表中的记录,以将外键添加到对应于与事实表相关联的维度表的记录 要加载记录的数据仓库。 由于外部联接操作是内存密集型的,因此从外部连接操作的性能角度确定来自与事实表相关联的多个维度表的哪些维度表是适合的。 只有那些合适的维度表外部连接到事实暂存表,以将外部连接的维度表的外键添加到事实暂存表记录中。 查找转换可用于将外键添加到非合适维度表的事实暂存表记录中。 可以将具有外键的转换后的事实记录加载到数据仓库中的事实表中。