
OLAP queries can interfere
with OLTP workloads which
can have an impact on the
transactional flow.
Side effects
Cross database joins are
also not easy and typically
span multiple transactional
domain boundaries.
Cross database joins
Background
Demand for new efficient mechanisms to create a near real-time replica of
a transactional database into an analytical database is growing.
Traditional transactional
database replicas are not
suitable for analytical
workloads (OLAP).
Scalability
2
文档被以下合辑收录
评论