Benefits
Direct Querying Without In-Memory Loading: DirectQuery allows Atoti to query external databases directly without loading data into memory first. This innovation supports major modern data warehouses and lake houses, such as Amazon Redshift, Google BigQuery, Microsoft Azure Synapse, Snowflake, and others.
Handling Large Datasets:
DirectQuery enables Atoti to target cloud-scale datasets that would otherwise not fit in memory. This allows users to analyze both historical and operational data side-by-side, leveraging a single framework for analytics without the need for extensive data shuffling.
Cost Efficiency:
DirectQuery helps reduce the TCO by optimizing how data is managed. It supports a hybrid approach, where hot data is loaded in-memory for fast access, while cold data remains in cost-effective storage, providing a balanced solution for different data access needs.
Simplified Data Management:
By integrating directly with existing data infrastructures, DirectQuery eliminates the need for additional data movement and duplication. This simplifies projects and accelerates deployment, allowing for true on-demand complex analytics and dynamic provisioning.
Scalability and Flexibility:
DirectQuery leverages the scalability of storage and compute resources offered by underlying external databases, while preserving Atoti’s capabilities for complex and fast last-mile analytics. This provides users with flexible and scalable analytics options across very large datasets.
Seamless Integration:
DirectQuery integrates smoothly with various environments, whether on-premises or in the cloud. It supports major cloud providers and on-premises databases, ensuring that Atoti can be easily deployed and maintained across different infrastructures.
Enhanced Modelling Capabilities:
The hybrid mode in DirectQuery allows for combining full in-memory and external-database queries within the same model. This expands the modeling capabilities, enabling users to make trade-offs on associated costs and achieve a comprehensive view by combining real-time and historical data.
Quick Deployment:
Projects can launch faster with DirectQuery, as it allows for plug-and-play deployment. Cubes start in minutes or even seconds because data does not need to be moved, opening new possibilities for rapid deployment of analytics.
Improved User Experience:
End users benefit from granular, detailed data access with an unlimited historical perspective, ensuring consistency, auditability, and ease of access. IT managers can optimize data loading strategies for cost-effectiveness and performance.
TESTIMONIALS
Trusted by the world’s financial institutions
“By embracing the power of Atoti on AWS Graviton for our Market and Credit risk applications, Nomura has achieved an unparalleled granular aggregation capability at a drastically reduced cost.”
“We turned to ActiveViam when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge that we couldn’t deal with in timely fashion.”
“Atoti FRTB was designed to address the new capital requirements outlined by the Federal Reserve Board in the US Basel III Endgame NPR and helped BNY Mellon effectively estimate the capital impact of the new regulation while responding to the US requirements within weeks of the NPR release.”
“ActiveViam came into play when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge.”
“No other vendor can do what ActiveViam does, not even close.”
“Atoti FRTB saved us a lot of time and resources from the bank’s internal development teams. Atoti FRTB in particular provided data format definition and with our experience working together with ActiveViam, they offered end-to-end deliveries from the beginning.”
“We can do things with Atoti that we were not able to do before. If something was incorrect, we needed to recompute the entire portfolio, now we just have to recompute the specific measures such as PnL on a small number of trades and Atoti does the aggregation on-the-fly for us.”
“That was the true benefit – to be able to drill down quickly within seconds to create a new report. The ability to look at all the different risks was a huge step for us, saving us a lot of time at every single end of the month.”
“Competition has increased in the new clearing landscape, with clearing members able to choose from more options and a growing array of offerings. By delivering effective, real-time risk management, CME Group can attract and service greater volumes. What’s more, because the technology reduces the total cost per trade, we can also remain cost-effective. As such, our new technology approach has had a significant impact on the business and will continue to do so in the future.”
“Atoti is about 20-to-100 times faster than our previous system.”
“By delivering effective, real-time risk management, CME Group can attract and service greater volumes.”
“Large scale, fast analytics are historically a very intensive use case especially if you want to deploy on your own hardware. Solutions like Atoti allow banks to take full advantage of the native cloud capabilities of Azure and improve drastically performance whilst keeping control over their costs.”
“If a clearing member exhibits abnormal trading patterns, or is exposed to sudden unexpected adverse market conditions, or even makes a mistake on the price of a trade, we can capture that as soon as it happens. The risk team can then call up a member and have them back out of a trade or otherwise adjust their portfolios if need be – so it’s good for us and it’s good for the members.”
“By embracing the power of Atoti on AWS Graviton for our Market and Credit risk applications, Nomura has achieved an unparalleled granular aggregation capability at a drastically reduced cost.”
“We turned to ActiveViam when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge that we couldn’t deal with in timely fashion.”
“Atoti FRTB was designed to address the new capital requirements outlined by the Federal Reserve Board in the US Basel III Endgame NPR and helped BNY Mellon effectively estimate the capital impact of the new regulation while responding to the US requirements within weeks of the NPR release.”
“ActiveViam came into play when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge.”
“No other vendor can do what ActiveViam does, not even close.”
“Atoti FRTB saved us a lot of time and resources from the bank’s internal development teams. Atoti FRTB in particular provided data format definition and with our experience working together with ActiveViam, they offered end-to-end deliveries from the beginning.”
“We can do things with Atoti that we were not able to do before. If something was incorrect, we needed to recompute the entire portfolio, now we just have to recompute the specific measures such as PnL on a small number of trades and Atoti does the aggregation on-the-fly for us.”
“That was the true benefit – to be able to drill down quickly within seconds to create a new report. The ability to look at all the different risks was a huge step for us, saving us a lot of time at every single end of the month.”
“Competition has increased in the new clearing landscape, with clearing members able to choose from more options and a growing array of offerings. By delivering effective, real-time risk management, CME Group can attract and service greater volumes. What’s more, because the technology reduces the total cost per trade, we can also remain cost-effective. As such, our new technology approach has had a significant impact on the business and will continue to do so in the future.”
“Atoti is about 20-to-100 times faster than our previous system.”
“By delivering effective, real-time risk management, CME Group can attract and service greater volumes.”
“Large scale, fast analytics are historically a very intensive use case especially if you want to deploy on your own hardware. Solutions like Atoti allow banks to take full advantage of the native cloud capabilities of Azure and improve drastically performance whilst keeping control over their costs.”
“If a clearing member exhibits abnormal trading patterns, or is exposed to sudden unexpected adverse market conditions, or even makes a mistake on the price of a trade, we can capture that as soon as it happens. The risk team can then call up a member and have them back out of a trade or otherwise adjust their portfolios if need be – so it’s good for us and it’s good for the members.”
“By embracing the power of Atoti on AWS Graviton for our Market and Credit risk applications, Nomura has achieved an unparalleled granular aggregation capability at a drastically reduced cost.”
“We turned to ActiveViam when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge that we couldn’t deal with in timely fashion.”
“Atoti FRTB was designed to address the new capital requirements outlined by the Federal Reserve Board in the US Basel III Endgame NPR and helped BNY Mellon effectively estimate the capital impact of the new regulation while responding to the US requirements within weeks of the NPR release.”
“ActiveViam came into play when we realized that the number of market data elements and risk sensitivities and the level of granularity we needed represented a volume of data so huge.”
“No other vendor can do what ActiveViam does, not even close.”
“Atoti FRTB saved us a lot of time and resources from the bank’s internal development teams. Atoti FRTB in particular provided data format definition and with our experience working together with ActiveViam, they offered end-to-end deliveries from the beginning.”
“We can do things with Atoti that we were not able to do before. If something was incorrect, we needed to recompute the entire portfolio, now we just have to recompute the specific measures such as PnL on a small number of trades and Atoti does the aggregation on-the-fly for us.”
“That was the true benefit – to be able to drill down quickly within seconds to create a new report. The ability to look at all the different risks was a huge step for us, saving us a lot of time at every single end of the month.”
“Competition has increased in the new clearing landscape, with clearing members able to choose from more options and a growing array of offerings. By delivering effective, real-time risk management, CME Group can attract and service greater volumes. What’s more, because the technology reduces the total cost per trade, we can also remain cost-effective. As such, our new technology approach has had a significant impact on the business and will continue to do so in the future.”
“Atoti is about 20-to-100 times faster than our previous system.”
“By delivering effective, real-time risk management, CME Group can attract and service greater volumes.”
“Large scale, fast analytics are historically a very intensive use case especially if you want to deploy on your own hardware. Solutions like Atoti allow banks to take full advantage of the native cloud capabilities of Azure and improve drastically performance whilst keeping control over their costs.”
“If a clearing member exhibits abnormal trading patterns, or is exposed to sudden unexpected adverse market conditions, or even makes a mistake on the price of a trade, we can capture that as soon as it happens. The risk team can then call up a member and have them back out of a trade or otherwise adjust their portfolios if need be – so it’s good for us and it’s good for the members.”