Home Internet of Things Aerospace Apparel Energy Defense Health Care Logistics Manufacturing Retail

Top Eight Questions to Ask When Choosing a Data-Storage Strategy for Your IoT Solution

What should engineering directors or managers, when selecting a database, ask in order to ensure that all options have been considered?
By Jay Srinivasan

5. What's the expertise of your current (and near-future) team?
If all you have is a bunch of SQL developers, you're going to ruin their productivity by forcing them to use a NoSQL database—and vice versa. So ask yourself how quickly your team can switch and ramp up. Do you have the in-house database administrator (DBA) expertise to manage and support the developers as needed? Also, are you taking into account the new additions to your team that are in your recruiting pipeline? Get the most out of your database by pairing it with the right team.

6. What database dependencies can you accept—and what can you not accept?
Some database products come with an option to host yourself, while others are cloud-based solutions that are ready to use. Both have their pros and cons. In the former, you're dependent on an experienced DBA who can take responsibility for hosting and scaling your database as your business grows. In the latter, you're dependent on an external cloud provider, which naturally influences where your applications will be deployed. For example, if you choose Google Spanner, it might be more performant to run your applications on Google Cloud as well, so you don't have to pay for the latency or egress costs of network data.

7. What other pieces do you need to complete the story?
Once the database is selected, there is a lot to still decide based on how you want to use your data: What about caching? Do you need other services on top, like a memcache? How about visualizing the data in your database—do you need services like Tableau or Dundas? If so, do they integrate well with the database of your choice? Are you going to store all the data in the database, or are you considering moving older data to cheaper, cold storage such as AWS Redshift or Google BigQuery?

8. Finally, the big elephant in the room: what are the costs of licensing, developing and hosting?
A database that has a license fee of $100,000 a year may appear outrageous compared to an open-source alternative, but if the open-source option requires a dedicated DBA—whose typical salary is around $150,000—then is it really cheaper? There are also costs associated with hosting the database that you need to take into account that vary widely at different scale. For example, an option that's cheaper for the first 10 terabytes may not be cheaper once you reach the 100-terabyte range, as is evidenced by the analysis provided below, comparing five databases:

By understanding the needs of the solution and how a database will be used, you can be more comfortable that there will not be surprises down the line. It's important to think beyond the pure database technology and numbers to what you can expect in the future. Once you have your answers clear and your databases shortlisted, you can be confident in making the right choice.

Jay Srinivasan is the senior director of engineering at infiswift. He has more than 18 years of experience at Microsoft, Google and infiswift, building scalable distributed enterprise software, including the Software Load Balancer that powers all of Microsoft Azure. At infiswift, he serves as the senior director of engineering, and is responsible for the overall architecture of infiswift's IoT platform and vertically integrated solutions for solar and agriculture domains.

Login and post your comment!

Not a member?

Signup for an account now to access all of the features of RFIDJournal.com!

Case Studies Features Best Practices How-Tos
Live Events Virtual Events Webinars
Simply enter a question for our experts.
RFID Journal LIVE! RFID in Health Care LIVE! LatAm LIVE! Brasil LIVE! Europe RFID Connect Virtual Events RFID Journal Awards Webinars Presentations