GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → arvindshmicrosoft → YelpDatasetSQL

arvindshmicrosoft / YelpDatasetSQL

Licence: other
Working with the Yelp Dataset in Azure SQL and SQL Server

Programming Languages

TSQL
950 projects

Labels

machine-learningsql-servergraphtext-analysisyelpmssqlt-sqlyelp-datasetyelp-challengemulti-class-classificationr-serverazuresqldbyelp-dataset-analysisazuresql

Projects that are alternatives of or similar to YelpDatasetSQL

tsql-scripts
Transact-SQL scripts and gists
Stars: ✭ 35 (+118.75%)
Mutual labels:  sql-server, mssql, t-sql
Dbatools
🚀 SQL Server automation and instance migrations have never been safer, faster or freer
Stars: ✭ 1,742 (+10787.5%)
Mutual labels:  sql-server, mssql
Dbt Sqlserver
dbt adapter for SQL Server and Azure SQL
Stars: ✭ 41 (+156.25%)
Mutual labels:  sql-server, mssql
bizbook-server
The repository of bizbook server web api project
Stars: ✭ 45 (+181.25%)
Mutual labels:  sql-server, mssql
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+113450%)
Mutual labels:  sql-server, mssql
React Express Fullstack
Full stack (mostly unopinionated) starter pack with React+Redux and Expressjs
Stars: ✭ 23 (+43.75%)
Mutual labels:  sql-server, mssql
Node Mssql
Microsoft SQL Server client for Node.js
Stars: ✭ 1,951 (+12093.75%)
Mutual labels:  sql-server, mssql
Securitydriven.tinyorm
.NET micro ORM done right.
Stars: ✭ 281 (+1656.25%)
Mutual labels:  sql-server, mssql
SQLServerTools
This repo is the home of various SQL-Server-Tools
Stars: ✭ 28 (+75%)
Mutual labels:  sql-server, t-sql
Reservation-System
Airline Reservation System is an online Airline Ticket Reservation Application built using Windows Forms, C#, MS SQL Server.
Stars: ✭ 18 (+12.5%)
Mutual labels:  sql-server, mssql
BETL-old
BETL. Meta data driven ETL generation using T-SQL
Stars: ✭ 17 (+6.25%)
Mutual labels:  sql-server, t-sql
Tiberius
TDS 7.4 (mssql / Microsoft SQL Server) async driver for rust
Stars: ✭ 154 (+862.5%)
Mutual labels:  sql-server, mssql
sp who3
The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.
Stars: ✭ 49 (+206.25%)
Mutual labels:  sql-server, t-sql
uzbekistan-regions-data
Full Database of regions Uzbekistan available in JSON, SQL & CSV Format All Regions, Districts & Quarters with Latin, Cyrillic and Russian versions. (Районы (туманы) Республики Узбекистан и Города областного (республиканского) подчинения)
Stars: ✭ 46 (+187.5%)
Mutual labels:  sql-server, mssql
xelogstash
Send SQL Server Extended Events to Logstash, Elastic Search, or JSON
Stars: ✭ 22 (+37.5%)
Mutual labels:  sql-server, mssql
sync-client
SyncProxy javascript client with support for all major embedded databases (IndexedDB, SQLite, WebSQL, LokiJS...)
Stars: ✭ 30 (+87.5%)
Mutual labels:  sql-server
rita
Website, documentation and examples for RiTa
Stars: ✭ 42 (+162.5%)
Mutual labels:  text-analysis
HurdleDMR.jl
Hurdle Distributed Multinomial Regression (HDMR) implemented in Julia
Stars: ✭ 19 (+18.75%)
Mutual labels:  text-analysis
SimpleSqlExec
Lightweight command-line utility to execute queries on SQL Server in place of SQLCMD
Stars: ✭ 20 (+25%)
Mutual labels:  sql-server
DWKit
DWKit is a Business Process Management System based on .NET Core and React
Stars: ✭ 121 (+656.25%)
Mutual labels:  mssql
View All Similar Projects ➔

This sample code shows how to import and work with the Yelp Dataset (https://www.yelp.com/dataset/) using the Microsoft SQL family of products and services. Tested with Azure SQL DB and with SQL Server 2019

Please first review the terms of use and documenation for the Yelp dataset at https://www.yelp.com/dataset/documentation/main

Your use of these sample T-SQL scripts is also subject to standard license terms and legal terms documented in each script

The following techniques are demonstrated in this set of samples:

  • How to import the JSON data provided as part of the Yelp Reviews dataset into Azure SQL / SQL Server
  • In-database graph comprising of nodes (corresponding to users) and edges (representing the friendship between two users). Once the graph is constructed, we show how to query it using the MATCH predicate and finding shortest path between nodes
  • A few "beyond SQL" queries which leverage full-text indexes and spatial query support
  • In-database Machine Learning services (specifically R) to perform multi-class classification of restaurant food category based on text in the review; and for fun we also show how to build a word cloud from the text in the restaurant reviews - SQL Server only for now
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].