in-database analytics
In-database analytics is a technology that allows data processing to be conducted within thedatabase by building analytic logic into the database itself. Doing so eliminates the time and effort required to transform data and move it back and forth between a database and a separate analytics application.
An in-database analytics system consists of an enterprise data warehouse (EDW) built on ananalytic database platform. Such platforms provideparallel processing,partitioning,scalability and optimization features geared toward analytic functionality.
In-database analytics allows analyticaldata marts to be consolidated in the enterprise data warehouse. Data retrieval and analysis are much faster and corporate information is more secure because it doesn’t leave the EDW. This approach is useful for helping companies make better predictions about future business risks and opportunities, identify trends, and spot anomalies to make informed decisions more efficiently and affordably.
Companies use in-database analytics for applications requiring intensive processing – for example, fraud detection, credit scoring,risk management, trend and pattern recognition, andbalanced scorecard analysis. In-database analytics also facilitatesad hoc analysis, allowing business users to create reports that do not already exist or drill deeper into a static report to get details about accounts, transactions, or records.
See also:predictive analytics,association rules,data mining,business analytics,MapReduce
Related Terms
- What is a robo-advisor? Everything to know before using one
- A robo-advisor is a virtual financial advisor powered by artificial intelligence (AI) that employs an algorithm to deliver an ... See complete definition
- What is data curation?
- Data curation is the process of creating, organizing and maintaining data sets so people looking for information can access and ... See complete definition
- What is SAP BW (Business Warehouse)?
- SAP Business Warehouse (BW) is a model-driven data warehousing product based on the SAP NetWeaver ABAP platform. See complete definition
Dig Deeper on Business intelligence technology
- Exposing Six Big Backup Storage Challenges–Exagrid
- Can Backups Scale? The Vanishing Backup Window–Exagrid
- See More
- Computer Weekly – 23 July 2024: Serving up a GenAI experience at Wimbledon–TechTarget ComputerWeekly.com
- A Computer Weekly buyer's guide to graph databases–TechTarget ComputerWeekly.com
- Data and AI governance must team up for AI to succeed
AI applications won't produce reliable results -- and could create compliance and business ethics risks -- without strong data ...
- How to secure sensitive data when offboarding employees
Establish a multi-phased approach that turns a risky situation into a managed process with several departments working in ...
- Streaming specialist Redpanda adds governance to AI suite
New Agentic Data Plane features enable users to create a governance layer for agents and could help the vendor differentiate ...
- Compare Datadog vs. New Relic for IT monitoring in 2024
Compare Datadog vs. New Relic capabilities including alerts, log management, incident management and more. Learn which tool is ...
- AWS Control Tower aims to simplify multi-account management
Many organizations struggle to manage their vast collection of AWS accounts, but Control Tower can help. The service automates ...
- Break down the Amazon EKS pricing model
There are several important variables within the Amazon EKS pricing model. Dig into the numbers to ensure you deploy the service ...
- Box releases Box Extract, its AI metadata agent
Line-of-business Box users can now tag contracts, reports and other commonly used docs with plain-language instructions, which an...
- The top 6 content management trends in 2026
AI technology continues to shape the content management market. It underpins top trends in 2026, including generative AI, agentic...
- 12 content collaboration platforms for enterprises in 2026
When evaluating content collaboration platforms, business leaders have several options and must choose carefully to find one that...
- Click-to-launch tools pull apps through Oracle Cloud Infrastructure marketplace
Oracle has made it easier for customers to choose and launch third-party software onto its cloud. Now, the question is whether ...
- Willis develops app to put a personal touch back in voluntary benefits
Part two of a two-part article: Willis uses PeopleSoft 9.1 to bring back the personal feel to automated insurance selection for ...
- Willis develops app for real-time voluntary benefit selection
Part one of a two-part article: Willis uses PeopleSoft 9.1 to create real-time automated insurance selection for voluntary ...
- At TechEd, SAP continues to lay down the AI data foundation
New tools to speed up agentic AI development, open SAP platforms and provide access to data products were also touted as helping ...
- SAP pitches role-based Joule assistants as ERP work partners
New AI-driven applications for supply chain, procurement and CX also shared the spotlight as SAP strives to portray its broad ...
- There are '50 shades of clean core' for SAP customers
In this Q&A, Michael Lemashov and Denis Malov of JDC Group discuss the strategies for SAP customers to achieve a clean core and ...