https://www.kinetica.com/assets/in-database-analytics-gpu-DmUs19_X.js

1const e="in-database-analytics-gpu",a="Advanced In-Database Analytics on the GPU",t="With Version 6.0, Kinetica introduces user-defined functions (UDFs), enabling GPU-accelerated data science logic to power advanced business analytics, on a single database platform. User-defined functions (UDFs) enable compute as well as data-processing, within the database. Such ‘in-database processing’ is available on several high-end databases such as Oracle, Teradata, Vertica and others, but this is the first time such functionality has been made available on a database that fully utilizes the parallel compute power of the GPU on a distributed platform. In-database processing in Kinetica creates a highly flexible means of doing advanced compute-to-grid analytics. This industry-first functionality stands to help democratize data science. Until now, organizations have typically needed to extract data to specialized environments to take advantage of GPU acceleration for data science workloads, such as machine learning and deep learning. Kinetica now makes it possible for sophisticated data science models to be developed and made available on the same database platform as is used for business analytics. How it Works UDFs and the associated orchestration API […]",s="2017-01-24",n="James Dilworth",i="https://kinetica-web-assets.s3.us-east-1.amazonaws.com/assets/blog/Screen-Shot-2017-01-23-at-10.49.13-PM.png",o=["Product Announcements"],r=`<p class="text-gray-600 leading-relaxed mb-4 text-lg font-medium">With Version 6.0, Kinetica introduces user-defined functions (UDFs), enabling GPU-accelerated data science logic to power advanced business analytics, on a single database platform.</p>
2
3<p class="text-gray-600 leading-relaxed mb-4">User-defined functions (UDFs) enable compute as well as data-processing, within the database. Such 'in-database processing' is available on several high-end databases such as Oracle, Teradata, Vertica and others, but this is the first time such functionality has been made available on a database that fully utilizes the parallel compute power of the GPU on a distributed platform. <a href="/product/in-database-analytics/" class="text-kinetica-600 hover:underline">In-database processing</a> in Kinetica creates a highly flexible means of doing advanced compute-to-grid analytics.</p>
4
5<p class="text-gray-600 leading-relaxed mb-4">This industry-first functionality stands to help democratize data science. Until now, organizations have typically needed to extract data to specialized environments to take advantage of GPU acceleration for data science workloads, such as machine learning and deep learning. Kinetica now makes it possible for sophisticated data science models to be developed and made available on the same database platform as is used for business analytics.</p>
6
7<h2 class="text-2xl font-bold text-gray-900 mt-8 mb-4">How it Works</h2>
8
9<p class="text-gray-600 leading-relaxed mb-4">UDFs and the associated orchestration API enable data to be processed with custom code that can draw on the power of distributed GPUs. UDFs have direct access to CUDA APIs, and can take full advantage of the distributed architecture of Kinetica. Because Kinetica is designed from the ground up to take full advantage of the GPU, users have an advanced mechanism for distributed computation.</p>
10
11<p class="text-gray-600 leading-relaxed mb-4"><img decoding="async" src="https://kinetica-web-assets.s3.us-east-1.amazonaws.com/assets/blog/Screen-Shot-2017-01-23-at-10.49.13-PM.png" alt="Kinetica UDFs" loading="lazy" class="rounded-lg shadow-md my-6 max-w-full h-auto float-right ml-6">UDFs are able to receive filtered data, do arbitrary computations, and then save output to a separate table. Such computations might include linear interpolation, anomaly detection, clustering, regressions, or risk simulations such as Monte Carlo analysis. The brute-force parallel compute power of the GPU delivers fast response which makes it more suitable for interactive analytics and experimentation.</p>
12
13<p class="text-gray-600 leading-relaxed mb-4">GPUs are particularly well suited for the types of vector and matrix operations foun

13d in machine learning and deep learning systems. With in-database processing, custom functions will be able to call machine learning/artificial intelligence libraries such as TensorFlow, BIDMach, Caffe, Torch and others to work directly on data within Kinetica.</p>
14
15<p class="text-gray-600 leading-relaxed mb-4">The orchestration API is available with C++ and Java bindings. Additional languages, such as Python will be available soon.</p>
16
17<h2 class="text-2xl font-bold text-gray-900 mt-8 mb-4">Why This Matters</h2>
18
19<p class="text-gray-600 leading-relaxed mb-4">As businesses move from deep analytics to predictive analytics, more and more operations stand to benefit from the parallel processing power of the GPU:</p>
20
21<img decoding="async" src="https://kinetica-web-assets.s3.us-east-1.amazonaws.com/assets/blog/Screen-Shot-2017-01-23-at-10.48.38-PM.png" alt="Progressive Value of GPU in Analytics" loading="lazy" class="rounded-lg shadow-md my-6 max-w-full h-auto">
22
23<p class="text-gray-600 leading-relaxed mb-4">For organizations requiring low-latency response to sophisticated analytics on large datasets, Kinetica's in-database functionality will offer more customization and significantly faster operations. Pre-existing custom code that currently operates in separate systems can often be quickly reconfigured to run in Kinetica. UDFs open up a world of options for automating processes and performing business calculations within the analytics platform.</p>
24
25<img decoding="async" src="https://kinetica-web-assets.s3.us-east-1.amazonaws.com/assets/blog/Screen-Shot-2017-01-23-at-10.44.52-PM-1024x981.png" alt="Data-science teams typically need to export data into specialized to build models. This is cumbersome, and invariably becomes difficult to make models available to the business." loading="lazy" class="rounded-lg shadow-md my-6 max-w-full h-auto">
26
27<p class="text-gray-600 leading-relaxed mb-4">With predictive analytics and more advanced data science workloads, organizations have often resorted to exporting data to specialized high-performance computing (HPC) systems staffed by data scientists, who can work on these more complex problems. These groups demand GPU acceleration for the performance benefits. Because deep learning algorithms run several times faster on a GPU compared to a CPU, learning times can be reduced from weeks to hours, or from hours to minutes. This performance boost is critical because such algorithms need to be tweaked, then trained, and the time to iterate adds up.</p>
28
29<p class="text-gray-600 leading-relaxed mb-4">Moving data to such specialized systems is cumbersome and slow, and it's common for data science to become disconnected from the business with no easy way to return models into production use.</p>
30
31<p class="text-gray-600 leading-relaxed mb-4">What if it were possible to bring the data science modeling and business analytics together on the same platform?</p>
32
33<p class="text-gray-600 leading-relaxed mb-4">This is what is now possible with in-database processing on Kinetica: BI and AI workloads can run together on the same <a href="/gpu-database/" class="text-kinetica-600 hover:underline">GPU-accelerated database platform</a>. Doing so eliminates the time and effort required to transform data and move it back and forth between a database and a separate data science system.</p>
34
35<img decoding="async" src="https://kinetica-web-assets.s3.us-east-1.amazonaws.com/assets/blog/Screen-Shot-2017-01-23-at-10.45.13-PM.png" alt="With In-database processing in Kinetica, data-science groups can develop models on the same database platform as business users." loading="lazy" class="rounded-lg shadow-md my-6 max-w-full h-auto">
36
37<p class="text-gray-600 leading-relaxed mb-4">This empowers business users to do more sophisticated analysis without resorting to code. Data science teams can develop and test gold-standard simulations and algorithms while making them directly available on the systems used by end users. Foreseeably, in addition to querying data and running a 'GROUP BY', users could also call a Monte Carlo simulation, or other custom algorithms, straight from their BI tools. In this way, Kinetica stands to democratize data science.</p>
38
39<h2 class="text-2xl font-bold text-gray-900 mt-8 mb-4">Who Benefits</h2>
40
41<p class="text-gray-600 leading-relaxed mb-4">In-database processing on Kinetica appeals to customers that want to make advanced and predictive analytics available to line of business users. For example, fraud detection, trade decisioning, risk management, trend and pattern recognition are all use cases that can benefit.</p>
42
43<p class="text-gray-600 leading-relaxed mb-4">Some use-cases we're currently involved with on include:</p>
44
45<ul class="list-disc pl-6 mb-4 space-y-2 text-gray-600">
46  <li><strong>Vehicle Design and Testing</strong> Vehicle manufacturers and sports teams now collects millions of data points from wind tunnel runs and testing. These are used in 1000s of calculations per run that typically take hours to process. UDFs will provide them the ability to perform on-demand calculations and adjust parameters in real time.</li>
47  <li><strong>Pricing and Risk Calculations</strong> Financial institutions are merging more and more sources of data and need to run ever more sophisticated risk management algorithms and return results pre trade. UDFs will enable a next generation risk management platform that will also enable real-time drill-down analytics and on-demand custom XVA library execution.</li>
48  <li><strong>Genomics Signaling</strong>

48 Pharma companies utilize genomics data to identify new signals and to accurately predict drug targets. Data is being ingested into Kinetica, Natural Language Processing (NLP) will be used to extract specific features and custom UDFs will be called to locate genome signals.<br>
49  Read More: <a href="http://www.informationweek.com/big-data/kinetica-uses-gpus-for-advanced-in-database-analytics/d/d-id/1327956" class="text-kinetica-600 hover:underline">InformationWeek : GSK Uses Kinetica for Simulation</a></li>
50</ul>
51
52<h2 class="text-2xl font-bold text-gray-900 mt-8 mb-4">Summary</h2>
53
54<p class="text-gray-600 leading-relaxed mb-4">User-defined functions and the orchestration API that enables in-database analytics are available on Kinetica 6.0, available now. Learn more about how to take maximum advantage of GPU accelerated in-database compute by talking with us. Just fill out the form below!</p>`,l={slug:e,title:a,excerpt:t,date:s,author:n,featuredImage:i,categories:o,body:r};export{n as author,r as body,o as categories,s as date,l as default,t as excerpt,i as featuredImage,e as slug,a as title};