Best way to save this data?

Question

I was just assigned to update the old website, and I can move it from the old archaic system to drupal. The only problem is that it stores the real estate system and a lot of data. Currently, all information is stored in one table, the identifier is a house, and then everything else is a key / value pair. There are 243 keys per property, in the system 23840 units. As you can imagine, the system is slow and complex to query.

I do not think that a table with 243 rows would be a very good idea and probably worse than the current situation. I did some investigation, and here is what I found out:

• Missing data does not indicate a value of 0, data is combined from two unique sources / formats. Some guessing is involved. I do not control the data source.
• There are 4 keys that are common to all estates, all values ​​look like what is usually searched for and can be indexed
• There are 10 keys that are in the range [90-100]%
  • 8 of them are information about who sells it and its address.
  • The other two seem to belong to the range below
• There are 80 keys in the range [80-90]%
  • This range, apparently, mainly applies only to the types of rooms and the number of houses (for example, bedroom_possible, bathrooms, family_room_3rd, etc.).
  • This range also includes small information, such as school districts, one or two pieces of data at.
• 179 , [0-80]%, .
• , ( ).

- , , , /.

?

Answer 1

• Estate n - 1

• 1--1

• 1--1

• 1 - n

(dynamic?) id/key/value

Answer 2

- , , . , , , , , .

, differnt (, , , , , , ), 20% . null.

, , , , . XML- , , ?

. , , 1-1, . - , . JUst , .

Answer 3

-. , , . suck .