资料汇入 [英] Data importing

问题描述

我正在一个项目中，我正在从几个外部数据源(即sybase，foxpro等)导入数据.我正在寻找一些建议，而不是像对待每条记录一样对其进行更新，而是在从源收集所有数据并执行所有必需的处理步骤之前，确定如何确定记录是否已更改. .有些表的行数超过一百万，并且每一行都需要在生产表中进行查找.我原本以为使用哈希值...从源中收集所有数据，然后计算一个哈希值，然后将生产表中的哈希值与生成的哈希值进行比较.如果不同，则进行更新，否则继续进行.根据我所做的研究，似乎每次生成的哈希值都不会相同.任何帮助都将非常有用！

谢谢！

Craig

I am working on a project in which I am importing data from several foreign data sources (i.e. sybase, foxpro, etc.). Rather than processing each record as if it has been updated, I am looking for some advice on how to determine if the record has changed prior to collecting all of the data from the source and going through all of the processing steps that are required... Some of the tables have upwards of a million rows and each row requires a lookup in the production table. I had originally thought of using a hash value... collecting all of the data from the source then computing a hash value, and comparing the hash in the production table to the one generated. If different, then update, else move on. From the research i did, it does not appear that the hash will be the same each time it gets generated.. Any help would be great!

Thanks!

Craig

推荐答案

您可以查看审计线索:

http://infocenter .sybase.com/help/index.jsp?topic =/com.sybase.help.ase_15.0.sag1/html/sag1/sag1864.htm [

You could look in to the audit trail:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sag1/html/sag1/sag1864.htm[^]

I don''t know anything about foxpro but I guess there is some audit trail there as well.

Good luck!

这篇关于资料汇入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！