Slide 22
Slide 22 text
NETSPECTIVE
www.netspective.com 22
Old way to architect:
Monolithic RDBMS-based data warehouse
The centralized clinical data warehouse (CDW)
model, where a massive multi-year project
creates a monolithic relational database that all
analytics will run off was fine when retrospective
reporting is what defined analytics. This old
architecture won’t work in modern predictive
analytics and mobile-centric requirements.
Better way to architect:
Service-oriented databases on RDBMS/NoSQL
• Drive transactional ACID-based data
requirements to RDBMS and consider column-
stores, document-stores, and network-stores for
other kinds of data
• Break relationships between data and store
lookup, transactional, predictive, scoring, risk
strat, trial associated, retrospective, identity,
mortality ratios, and other types of data based on
their usage criteria not developer convenience
• Use translucent encryption and auto-de-
identification of data to make it more useful
without further processing
• Design for decentralized sync’ing of data (e.g.
mobile, etc.) not centralized ETL
Move to service-oriented (de-identifiable) data
Don’t assume all your data has to go into a giant data warehouse