Skip to content

Commit cfa1d5e

Browse files
committed
Updated ODBC article for content perf
1 parent 431ee58 commit cfa1d5e

3 files changed

Lines changed: 18 additions & 9 deletions

File tree

.openpublishing.redirection.json

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -42945,6 +42945,11 @@
4294542945
"redirect_url": "/sql/machine-learning/tutorials/python-ski-rental-linear-regression-deploy-model",
4294642946
"redirect_document_id": false
4294742947
},
42948+
{
42949+
"source_path": "docs/machine-learning/r/save-and-load-r-objects-from-sql-server-using-odbc.md",
42950+
"redirect_url": "/sql/machine-learning/data-exploration/save-and-load-r-objects-from-sql-server-using-odbc",
42951+
"redirect_document_id": true
42952+
},
4294842953
{
4294942954
"source_path": "docs/linux/sql-server-linux-develop-use-ssms.md",
4295042955
"redirect_url": "/sql/linux/sql-server-linux-manage-ssms",

docs/machine-learning/r/save-and-load-r-objects-from-sql-server-using-odbc.md renamed to docs/machine-learning/data-exploration/save-and-load-r-objects-from-sql-server-using-odbc.md

Lines changed: 12 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -4,21 +4,21 @@ description: The RevoScaleR package includes serialization and deserialization f
44
ms.prod: sql
55
ms.technology: machine-learning-services
66

7-
ms.date: 04/15/2018
7+
ms.date: 04/21/2020
88
ms.topic: how-to
99
author: dphansen
1010
ms.author: davidph
11-
ms.custom: seo-lt-2019
11+
ms.custom: contperf-fy21q4
1212
monikerRange: ">=sql-server-2016||>=sql-server-linux-ver15"
1313
---
14-
# Save and load R objects from SQL Server using ODBC
14+
# Use ODBC to save and load R objects in SQL Server Machine Learning Services
1515
[!INCLUDE [SQL Server 2016 and later](../../includes/applies-to-version/sqlserver2016.md)]
1616

17-
SQL Server R Services can store serialized R objects in a table and then load the object from the table as needed, without you having to re-run the R code or retrain the model. This ability to save R objects in a database is critical for scenarios such as training and saving a model, and then using it later for scoring or analysis.
17+
Learn how to use the **RevoScaleR** package to store serialized R objects in a table and then load the object from the table as needed with [SQL Server Machine Learning Services](../sql-server-machine-learning-services.md). This can be used when training and saving a model, and then use it later for scoring or analysis.
1818

19-
To improve performance of this critical step, the **RevoScaleR** package now includes new serialization and deserialization functions that greatly improve performance, and store the object more compactly. This article describes these functions and how to use them.
19+
To improve performance, the **RevoScaleR** package now includes new serialization and deserialization functions that improve performance and store the object more compactly.
2020

21-
## Overview
21+
## RevoScaleR package
2222

2323
The **RevoScaleR** package now includes new functions that make it easier to save R objects to SQL Server and then read the objects from the SQL Server table. In general, each function call uses a simple key value store, in which the key is the name of the object, and the value associated with the key is the varbinary R object to be moved in or out of a table.
2424

@@ -40,7 +40,7 @@ By default, any object that you call from R to move to SQL Server is serialized
4040

4141
- `rxListKeys` lists as key-value pairs all the available objects. This helps you determine the names and versions of the R objects.
4242

43-
For detailed help on the syntax of each function, use R help. Details are also available in the [ScaleR reference](/r-server/r-reference/revoscaler/revoscaler).
43+
For detailed help on the syntax of each function, use R help. Details are also available in the [ScaleR reference](/machine-learning-server/r-reference/revoscaler/revoscaler).
4444

4545
## How to store R objects in SQL Server using ODBC
4646

@@ -109,4 +109,8 @@ This procedure demonstrates how you can use the new functions to load a model fr
109109

110110
```R
111111
infertLogit2 <- rxReadObject(ds, "logit.model")
112-
```
112+
```
113+
114+
## Next steps
115+
116+
+ [What is SQL Server Machine Learning Services?](../sql-server-machine-learning-services.md)

docs/machine-learning/toc.yml

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -247,7 +247,7 @@ items:
247247
- name: R
248248
items:
249249
- name: Load R objects using ODBC
250-
href: ../machine-learning/r/save-and-load-r-objects-from-sql-server-using-odbc.md
250+
href: ../machine-learning/data-exploration/save-and-load-r-objects-from-sql-server-using-odbc.md
251251
- name: Predictive modeling with R
252252
href: ../machine-learning/r/data-exploration-and-predictive-modeling-with-r.md
253253
- name: Create multiple models using rxExecBy

0 commit comments

Comments
 (0)