❔ Organize database for central replica of applications data
Hi,
my company has developed a SCADA software that acquires data from our customers machines and allows further analysis on them. The software and its database are deployed at the customer's site.
Now we'd like to setup a central replica of all the data stored at our customers SCADA systems in order to better understand how our customers work.
However I'm not sure about how should I organize the database:
As of now the database knows nothing about customers: for example, all the "production orders" listed in the related table of a given customer are implicitly associated to customer itself. This allows me to use an integer field "production order id" as key of the "production order" table, and scan it efficiently.
However now I need to store informations from multiple customers at our central database.
The only thing that comes up to my mind is to add to the "production order" table a "customer" column, and make the pair <production order id, customer> the key of the table.
However this way indexing should be less efficient as far as I know.
Is this the correct way to handle something like this?
Thanks
1 Reply
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.