I need to create a Dapp which stores information about companies in a private blockchain. There are different institutions that collect company information and then the information should be retrieved all together with the name of the company. I wanted to use a Ethereum private blockchain and I'm designing the solution now.
My first approach was to store things in a smart contract. The idea is to have an
addCompanyInfo function and then
getCompanyInfo. I found different problems with this approach:
1) Data structures aren't enough to create a whole system. If I want to add an auto-complete feature to the company field in the form I'll need to develop a search algorithm by myself, which isn't a big deal but it's something more that could fail.
2) If the data grows I'll need to page the information and query based on some fields and again, I'll need to do it by myself.
The question: is there any way to connect Ethereum to a database without loosing all the good things about blockchain? I mean that the content in the database should be as verified as the data in the arrays..