Startup Idea: SQL Database Management Software
I worked on a project in which our database was based upon SQL. Adding information to our database was easy enough, but removing any entries was practically impossible.
I spent hours of research looking for ways to remove information from SQL-based databases, only to find that due to the structure of SQL, this is extremely difficult to do.
The principle is simple. SQL entries are based upon single blocks of data. For example, a telephoning company may keep a database containing the name and details of its costumers. If the company is using SQL, it is easy to add a "John Doe" a "Jane Smith." In such a case, Mr. John Doe and his respective details would be contained in a "John Doe." Ditto of Ms. Jane Smith. The problem is that, due to SQL's structure, removing the "John Doe" block from the database is extremely difficult and even endanger the integrity of every piece of data in the database.
I am told that professional programmers are able to perform this difficult task of removal. But it should be possible to design software that can recognize the structure of a SQL file and give a user the option to remove a block of data.