What Are Some Database Use Cases?
What Are Some Database Use Cases?
The 3 most frequently mentioned industries were financial services, healthcare, and retail. However, it is agreed that there are database applications for every industry.
Join the DZone community and get the full member experience.Join For Free
Download the Altoros NoSQL Performance Benchmark 2018. Compare top NoSQL solutions – Couchbase Server v5.5, MongoDB v3.6, and DataStax Enterprise v6 (Cassandra).
To gather insights on the state of databases today, and their future, we spoke to 27 executives at 23 companies who are involved in the creation and maintenance of databases.
We asked these executives, "What are real world problems you, or your clients, are solving with databases?" Here's what they told us:
- Maxwell Health is a healthcare provider with an app on AWS EC2 S3 storage using MongoDB as their next generation database. We provide enterprise backup and recovery which helps Maxwell meet HIPPA requirements. Prior to this Maxwell was using manual scripting which was inefficient and did not scale. Backup windows were not able to keep up and the S3 storage costs were very high with all of the replicated data. We provided ongoing backup with single-click repair-free recovery and no time needed to restore along with semantic deduplication. This reduced backup storage cost by 90% and generated a 300% ROI in one year.
- Interoperability with EMRs and ERPs. Sensor devices on the edge. Information from the sensors helps to see trends and update predictive models for predictive maintenance. Integrate with manufacturing, healthcare to provide the ultimate patient experience using real-time data. Stanley Healthcare has a line of business with medical equipment for hospitals to tie with EMRs and locations (equipment management location). Put sensors in the patient badge in ER tie to their medical record and monitor vital signs. Track room availability. Optimize patient flow. See what best practices are to optimize patient flow.
- Spans spectrum — different vertical use cases. IMHE is using analytics of health data to correlate demos with infections to obesity. The solution helped them get their data into the White House by compressing a large data set so it would fit on a laptop.
- Context — graphs bring a richness of understanding. eBay's shop bot engages in a digital conversation. There’s a knowledge graph behind AI. Telia, a Swedish cable company, is able to map home features with people and devices in households to support new functionality. Marriott Hotels is doing real-time pricing across all properties micro-optimizing pricing.
- The real-world problem I was always trying to solve was availability. As digital services become mission critical -- and mainstream -- a new architecture is needed to eliminate downtime. At Amazon, we had to build Dynamo to be multisite so it could survive a datacenter outage without causing downtime to amazon.com, where downtime was directly correlated to losses of millions of dollars. Likewise, Cassandra was also built to be multi-site to survive East or West Coast datacenter outages at Facebook. Building resilient services is a higher priority than performance in today’s always-on, connected world. I’m more likely to abandon a site or stop using a service if it incurs frequent outages than if it’s a fraction of a second slower.
- An owner of multiple malls is beginning to see the value of real-time data and insights so they can push notifications to customers while they’re in the mall. Online gaming and retail is analyzing behavior using AI/ML to observe betting and shopping patterns to stop bettors getting in over their heads and recommending specific products to customers. You must have speed, scale, and security without compromise. If apps are going to survive, they must have high performance, scale, and security which all demand greater data management. Tiered data management with most data in memory and the rest in a persistent state which can be requested as needed.
- An online retailer is receiving guidance on the best price in the marketplace based on real-time analysis of 300 million items with the competition across multiple geographies. Logistics and planning for airlines, package delivery, and trucking. Financial services companies are doing risk analytics.
- U.S. Postal Service tracking the entire mail distribution system. PG&E integrating seven different lines of business into a single database for a single view of the enterprise and the customer.
- Ability to do background upgrades before you shut down the current system. How to manage data growth. Plan for warehousing so old data doesn’t cause performance problems. Figure out how to handle more data so it does not cause performance degradation. Determine the need to build a data warehouse.
- The customer wants to get apps out quickly and uses IBM Urban Code to do so but this neglects the database. Using our solution, DBAs don’t have to spend their weekends and nights monitoring. Helped NBC Universal go from five-week to two-week sprints after they were able to automate database release.
- We store and analyze human experiential and learning data. We use distributed databases to offer immediate insight to customers, leveraging rich logical queries and real-time data push to browsers.
- Security compliance considerations. What do I need to audit and prevent? Get into standard regulations like PCI, HIPAA, SOX, GDPR, NIST, DISA-STIG. Tools for auditing and security policy.
- MongoDB different between relational schema and schema-less. Support databases across client stores with different shapes of data. NoSQL databases allow you to work with dynamic data sets. Representation of data in NoSQL is more like what’s coming in and out of the API. Fundamental shift with document first data in the business intelligence space.
- We see a wide range of adoption in every industry. Used for accounting, enterprise resource planning, supply chain management, human capital management. Industry specific for multiple verticals that can process, scale, be available, and be secure.
- We’re working with clients all over the world and in every industry to help them overcome challenges and meet business goals through our database solutions and strategies.
What are some interesting use cases you are seeing with databases today?
Here’s who we talked to:
- Emma McGrattan, S.V.P. of Engineering, Actian
- Zack Kendra, Principal Software Engineer, Blue Medora
- Subra Ramesh, VP of Products and Engineering, Dataguise
- Robert Reeves, Co-founder and CTO and Ben Gellar, VP of Marketing, Datical
- Peter Smails, VP of Marketing and Business Development and Shalabh Goyal, Director of Product, Datos IO
- Anders Wallgren, CTO and Avantika Mathur, Project Manager, Electric Cloud
- Lucas Vogel, Founder, Endpoint Systems
- Yu Xu, CEO, TigerGraph
- Avinash Lakshman, CEO, Hedvig
- Matthias Funke, Director, Offering Manager, Hybrid Data Management, IBM
- Vicky Harp, Senior Product Manager, IDERA
- Ben Bromhead, CTO, Instaclustr
- Julie Lockner, Global Product Marketing, Data Platforms, InterSystems
- Amit Vij, CEO and Co-founder, Kinetica
- Anoop Dawar, V.P. Product Marketing and Management, MapR
- Shane Johnson, Senior Director of Product Marketing, MariaDB
- Derek Smith, CEO and Sean Cavanaugh, Director of Sales, Naveego
- Philip Rathle, V.P. Products, Neo4j
- Ariff Kassam, V.P. Products, NuoDB
- William Hardie, V.P. Oracle Database Product Management, Oracle
- Kate Duggan, Marketing Manager, Redgate Software Ltd.
- Syed Rasheed, Director Solutions Marketing Middleware Technologies, Red Hat
- John Hugg, Founding Engineer, VoltDB
- Milt Reder, V.P. of Engineering, Yet Analytics
Opinions expressed by DZone contributors are their own.