I'm creating a database for UFO sightings and would appreciate some feedback or suggestions. Yes I know, strange topic.
Some background info so that the problem is understood:
I'm extracting data from several large UFO database catalogs, news articles, and other miscellaneous sources, so that the data can be queried, and the user pointed toward the original resources.
I'm up to about 250 data points that need to be searchable. Things like UFO shape, external light colors, internal light colors, surface characteristics, sound, direction, altitude, estimated speed, etc...
The problem is that I can't normalize the database like would typically be done, because an advanced query would create too many table joins. In my experience, too many joins makes the query very ineffecient - unless someone has a suggestion about that, as I am not a database expert.
So I have one table with 250 or so fields. But the query length gets hard to manage.
Some of the fields are related, such as external light colors. Multiple colors may apply, so there are about 17 fields for external light colors that are coded either 'Y' or 'N'
What I need feedback on:
Trying to make the table more manageable, I thought about coding related fields into one, such as external light colors mentioned above. Example: 1 for true and 0 false for each color, so you would end up with one field with a string of 17 ones and zeros. As long as the query structure matches the input structure, they should match for queries. Kind of like a hashed password value. Any thoughts on why would work, not work, or have any suggestions?
Any feedback much appreciated. Thanks!