So recently, I had a client ask me to restructure his Database hierarchy which consisted mainly of changing table names and column names and creating cross-references to stop red locks.
He later emailed me about his 'program' no longer functioning: which the reason was simple, he hadn't updated the queries in his program.
This lead me to think about the integrity of the way we structure data rather than the integrity of the data itself: if the data changes, the view changes. If the structure changes, the program will no longer function.
Is it possible to create such a structure of data where the program can create its own decisions about the form of the data?
I am probably thinking 'futuristic' but if this was possible, would a web search be a possibility?
Add up the most common words, check the words appear in the definition, ect...
If my data was 'developer' id expect the program to recognise its a job role by searching the web and creating a decision based on the keywords, definition, word recurrence ect...