There are many problems that can arise when you develop your own database storage engine. At first, it may seem simple to just store the information you need in a flat file and let it grow as you develop and use your application. Unfortunately, feature creep can easily cause complications to this design. Let’s say that your application has been released and is currently being utilized by your customers. One common new requirement is now a need to use that same data store in the file for Business Intelligence purposes but there is no ability for this file to be loaded into any commercially available BI tools like Microsoft Excel, SAP Business Intelligence, Tableau, and others. In order to facilitate this, you need to now develop a way for these tools to connect to your internally developed system. You could contact that BI application developer and work with them to implement your database in their tool or you could spend time developing an industry standard connection interface like ODBC, JDBC or ADO.NET. Both of these options will require time and monetary investment, easily ballooning your initial costs and reducing or removing your cost savings by not using a commercial database like RDM.
We have built a tool that calculates the cost of building your own database management system (DBMS) – click the button below to calculate the cost of your project.