On Mar 9, 4:03=A0am, TheWoland <thewol...@[EMAIL PROTECTED]
> wrote:
> I have a number of "clients" which re****t with a string
> "client_id,client_model,0001001001", when the third part is a binary
> string containing client's status. Each client model can have various
> status message length and interpretation.
> For each of the locations in the status message, stands it's
> description and it's "im****tance level".
>
> Example:
> For model A:
> Bit location: 0 1 2 3
> Description: "General alarm" "Error no1" "Error no2" "Unit accessed"
> Im****tance: "Critical" "Major" "Minor" "None"
>
> For device B:
> Bit location: 0 1 2
> Description: "General alarm" "Error no1" "Unit accessed"
> Im****tance: "Critical" "Major" "None"
>
> What will be the best way to store this data into the database?
> Any help will be appreciated.
Let me paraphrase your question...
You're driving up to Manhattan from New Jersey, your transmission is
failing, your fuel gauge is showing empty, you've got a dead body in
your trunk. So you stop at the gas station and you ask the user group
- should I put in $10 of diesel or $8 kerosene in my car (that happens
to use regular unleaded)? Someone mentioned above that your structure
seemed denormalized... he was politely suggesting that the design is
completely wrong.
My suggestion is for you to read a good beginner book on SQL - Head
First SQL is not too bad. If you spent 3 days reading the book (or
another on database/database theory) you will reap huge benefits from
the investment.
|
