topic Re: Data modeling in App Development

Data modeling

jumiprado — Sat, 16 Nov 2024 07:14:24 GMT

Hi guys, i have a serious problem with My data, i have 22 tables from informix database where each table have two or more fields equals like clientID, CaseFile_Id, AreaId...

I have CaseFile_historic, CaseFile_actual, Grouped_CaseFiles.

When i requested the keys fields the it area gave me indexs fields.

When i load the data i have synthetic keys,

How can i made a Good data model?

Re: Data modeling

Thiago_Justen_ — Wed, 21 Nov 2018 12:31:02 GMT

There are many things you can do. I suggest you theses aproaches:

MASTERTABLE (LINK TABLE or Concatenated FACT Table)

Resolve synthetic keys

Synthetic keys vs. AutoNumber() (- concatenation)