Heterogeneous Database; What will you do?
-
Hello folks say for example you have a company with various branches; each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data; how would you go about it then? Some might go for heterogeneous databases tools; some others might suggest using SQLserver or any other DBMS for all DBs(will it handle that large data? isn't it very costly?); someone else might suggest going for a data warehouse? How would you go on about it?
-
Hello folks say for example you have a company with various branches; each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data; how would you go about it then? Some might go for heterogeneous databases tools; some others might suggest using SQLserver or any other DBMS for all DBs(will it handle that large data? isn't it very costly?); someone else might suggest going for a data warehouse? How would you go on about it?
AbrahamMOKDAD wrote:
each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data;
AbrahamMOKDAD wrote:
How would you go on about it?
Sql Express, one per branch, until they outgrow it. The "one" you're referring to could access the data it requires over some webservices from those database. Unless it's for reporting, then I'd simply go for a script that backups each database locally and then send that off once a day.
Bastard Programmer from Hell :suss:
-
Hello folks say for example you have a company with various branches; each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data; how would you go about it then? Some might go for heterogeneous databases tools; some others might suggest using SQLserver or any other DBMS for all DBs(will it handle that large data? isn't it very costly?); someone else might suggest going for a data warehouse? How would you go on about it?
Convince management to grow a set of balls and force through a decision on the data structure. The Branches do the same thing so make them do it the right way. Supporting this sort of wimpy management process is a complete disaster, you are either 1 organisation or you are not. There is however a strategy I have used when management cop out completely (also used when merging disparate systems). That is to define a reporting structure, this structure is set by management and the branches decide what they want to put in the report elements. It is complex, difficult and hugely expensive in both time and development cost and is difficult to support but hey if they can't make a decision then they have to pay for it. Sorry for the rant but I live with this every day, and yes I have called management on it!
Never underestimate the power of human stupidity RAH
-
Hello folks say for example you have a company with various branches; each branch implements its own database (each DB has its own structure and data); one wants to make use of all the databases in the branches and their data; how would you go about it then? Some might go for heterogeneous databases tools; some others might suggest using SQLserver or any other DBMS for all DBs(will it handle that large data? isn't it very costly?); someone else might suggest going for a data warehouse? How would you go on about it?