SQL Database Tables and Stored Procedures
Below are the data tables that you will find in either the TextClassification_R or TextClassification_Py databases after deployment.
| Table | Description |
|---|---|
| dbo.Label_Names | Names associated with each of the 20 labels |
| dbo.Metrics | Metrics for the trained model |
| dbo.Model | Trained model |
| dbo.News_Test | News items in the test set |
| dbo.News_To_Score | News items to score |
| dbo.News_Train | News items for training the model |
The following stored procedures are used in this solutions in either the TextClassification_R or TextClassification_Py databases:
| Stored Procedure | Description |
|---|---|
| dbo.evaluate | Evaluates the performance of the model |
| dbo.initial_Run_Once_R dbo.initial_Run_Once_Py | Runs the training workflow natively in SQL for this solution |
| dbo.score | Creates features on the fly for the testing set and makes predictions |
| dbo.train_model | Creates features on the fly for the training set and train the multiclass logistic regression model |
