Reader small image

You're reading from  SQL Server 2017 Machine Learning Services with R.

Product typeBook
Published inFeb 2018
Reading LevelIntermediate
PublisherPackt
ISBN-139781787283572
Edition1st Edition
Languages
Right arrow
Authors (2):
Julie Koesmarno
Julie Koesmarno
author image
Julie Koesmarno

Julie Koesmarno is a senior program manager in the Database Systems Business Analytics team, at Microsoft. Currently, she leads big data analytics initiatives, driving business growth and customer success for SQL Server and Azure Data businesses. She has over 10 years of experience in data management, data warehousing, and analytics for multimillion-dollar businesses as a SQL Server developer, a system analyst, and a consultant prior to joining Microsoft. She is passionate about empowering data professionals to drive impacts for customer success and business through insights.
Read more about Julie Koesmarno

Tomaž Kaštrun
Tomaž Kaštrun
author image
Tomaž Kaštrun

Toma Katrun is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events. He is an avid coffee drinker who is passionate about fixed gear bikes.
Read more about Tomaž Kaštrun

View More author details
Right arrow

Fast batch prediction

As seen in the previous section, both the model training step and the prediction step call sp_execute_external_script, which invokes the R process. Real-time scoring and native scoring allow you to do predictions without invoking an R process. Therefore, these scoring methods improve the performance of prediction operations.

In addition, real-time scoring and native scoring let you use a machine learning model without having to install R. As long as you obtain a pretrained model in a compatible format and save it in an SQL Server database, you can call prediction operations easily.

Prerequisites

  • There is no prerequisite when using the PREDICT function in SQL Server 2017. More information about PREDICT...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
SQL Server 2017 Machine Learning Services with R.
Published in: Feb 2018Publisher: PacktISBN-13: 9781787283572

Authors (2)

author image
Julie Koesmarno

Julie Koesmarno is a senior program manager in the Database Systems Business Analytics team, at Microsoft. Currently, she leads big data analytics initiatives, driving business growth and customer success for SQL Server and Azure Data businesses. She has over 10 years of experience in data management, data warehousing, and analytics for multimillion-dollar businesses as a SQL Server developer, a system analyst, and a consultant prior to joining Microsoft. She is passionate about empowering data professionals to drive impacts for customer success and business through insights.
Read more about Julie Koesmarno

author image
Tomaž Kaštrun

Toma Katrun is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events. He is an avid coffee drinker who is passionate about fixed gear bikes.
Read more about Tomaž Kaštrun