Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

What Are Some Database Use Cases?

DZone's Guide to

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.

· Database Zone
Free Resource

Running out of memory? Learn how Redis Enterprise enables large dataset analysis with the highest throughput and lowest latency while reducing costs over 75%! 

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:

Financial Services

  • Capital One migrated to the cloud reducing spend and masking PCI.
  • Deliver changes to the database in DevOps which is frequently terabytes of customer data. Make sure the data is protected and secure. For highly regulated environments, like financial services and healthcare, have good data management, structure, and best practices to meet regulations.
  • Asset management software solution for a car company that leases management lifecycle of assets deployed on prem migrating to the cloud. They’re using us to move and will use on prem. A European brokerage company must deal with regulatory risk management (RIFIR) for European regulatory requirements and trades analysis. SQL server needs to scale out as demand and data require.
  • Provide operational data stores for telcos, finance, gaming, and ad tech. High throughput with strict latency guidelines. Important for fraud detection in any industry because you have to be able to approve or deny the transaction in milliseconds. We also do micro-personalization for websites drawing a custom page based on what the consumer has done recently. Personalization solutions in retail, aviation (frequent flyers), and online gaming for CX and player engagement.
  • Most of our customers are in data-intensive industries like financial and insurance, healthcare, services, software and technology, education, energy and utilities, retail, so there are a lot of cutting-edge use cases going on there. Anything with IoT is interesting, such as the all the real-time data processing of RFIDs, sensors, RSS feeds, smart meters, and smart grids going on in the energy industry.
  • We are solving real-time risk control in:
    • Financial verticals: by looking at how transactions/users are connected to known blacklisted entities through what types of connections.
    • E-commerce personalized recommendation: by connecting users, products, categories, purchasing patterns.
    • Supply-chain logistics optimization: by connecting products, manufacturers, shipments, parts, and customers all in a single graph.

Healthcare

  • 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.
  • We work with a lot of different verticals. We support IoT platforms with Cassandra. We help accelerate clinical trials with real-time sensors.
  • We have customers using our product for a document search engine and another using it as a commercial IoT platform. HIPAA compliant demo to ingest EDI data to form a healthcare clearing house in a box for plan termination and patient data. There are opportunities with every business domain and every data domain.
  • Healthcare, financial services, telecommunications, and technology. Healthcare is able to take an outcome-based approach aligning doctors, patients, hospitals, and insurers to help prevent fraud, identify the right treatments, and optimize outcomes for an improved patient experience at a reduced cost. Medical device companies are changing how they approach business from machine provider to service provider with maintenance and management providing faster and cheaper service to their customer. Push updates to the machine to save on service calls and maintenance. MRI images can be shipped to the cloud and processed in five minutes. Obtain the images from all MRIs and use ML for better results analysis.
  • 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.

Retail

  • 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.

Other

  • 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

Running out of memory? Never run out of memory with Redis Enterprise databaseStart your free trial today.

Topics:
database ,use cases ,financial ,healthcare ,retail

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}