Dears, I want to design a database for a new system which we develop, the data should come from two different resources (two separated database from two different systems), one of them has a huge data (like transactions history), I’ve read about “columnar database” or “hybrid one”
and I think for the whole tables I will use row-based but for only one table say T1 (which is transaction history where I need specific columns from the original table) I will use column-based storage,
kindly note the reason: