Hi Kumar
You can use a view as a table on your mappings, however I think you'll need
something else in your source databases to indicate which rows are news. If
your database is small enough, I recommend to copy the whole thing
everytime.
If rows are never updated or deleted on the source table, and it has a
primary key, syncronizing is easy: you just compare the list of values from
the source table'PK to the list of values you migrated to D2R, then migrate
the diff. If rows can be deleted on source, you'll need to delete them as
well.
When you got updates, things can get very hard/slow. Check for a column
that indicates the date of last update on that row; you'll need to compare
both the IDs as before and also this date. If you don't have such column,
create. If you can't mess with the source database, you'll have to resort
to store a MD5 of all columns and check for changes, and here's where
things get nasty.
Look for ETL techniques and tools (such as Pentaho Data Integration).
Good luck
--
diogo patrão
On Thu, Sep 5, 2013 at 4:09 AM, Ganesh kumar <ganeshkumar1...@gmail.com>wrote:
> Hi All,
>
> I am very new to this community.
> We are planning to use D2RQ to migrate data from our relational to a
> triplestore.
> Even though I can achieve this through a RDF dump, I need to load the data
> incrementally after the initial load.
>
> So I thought of having a SQL View or materialized view to store only the
> changes and use D2RQ to load data from here.
> My question is, does D2RQ provide the capability to load from the SQL
> Views/Materialized ??
> Or Do you guys have an alternate solution for this ?
>
> Your help is much appreciated.
>
>
> --
> *Warm Regards
> Ganesh
> *
>
>
> ------------------------------------------------------------------------------
> Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
> Discover the easy way to master current and previous Microsoft technologies
> and advance your career. Get an incredible 1,500+ hours of step-by-step
> tutorial videos with LearnDevNow. Subscribe today and save!
> http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
> _______________________________________________
> d2rq-map-devel mailing list
> d2rq-map-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
>
>
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58041391&iu=/4140/ostg.clktrk
_______________________________________________
d2rq-map-devel mailing list
d2rq-map-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
