SQL Server 2017 is bringing the new capability
to deploy Python based machine learning application in enterprise production environment
which is already running in SQL Server. This additional capability allows us to
bring any open source Python packages in SQL server to execute within T-SQL based stored procedures or codes.
Architecture - Python in SQL Server
Microsoft introduced sp_execute_external_script
which is a system stored procedure to execute external scripts. We can submit R
or Python script to this stored procedure in the secure manner. SQL server runs
this query with the help of external process called Launchpad which launches
this query and this concept is known as runtime launcher. After executing, it’s
connected back to SQL Server on the SQL Server satellite data channel. It’s working
as additional post process.
Python integration
in SQL Server
gives us the following key advantages-
Eliminate data movement with in-database machine
learning means you are free to do machine learning on the Python based compute
on the large datasets and there is no need to move your data into another
place.
Deploy your machine learning model and Python
scripts right in T-SQL stored procedure with will talk more about in the breath.
In this case, any app that can talk to SQL server and invoke with T-SQL stored
procedures without being aware or knowing that Python package or Python model
is running in the background.
It is allowing the performance and scale
advantages also. Database analytics integration in SQL Server 2016 introduced
new communication channel to exchange the data from SQL server to scripts which
are running inside SQL Server which is like columnar based compression channel,
it’s much faster than the ODBC. So, Python also uses the same integration
because SQL Server also has the in-memory column store indexes and in-memory
tables which are very highly recommended for large scale data analytics.
In addition of this integration, SQL Server 2017
is also bring the something called revoscalepy which is equalent to revoscaleR which
are not bonded by the memory or scale like that if we are doing the liner
regression on the billion rows of dataset then it’s really doable without any
memory limiting which means enterprise level scale grade.
Key scenarios which are enables by Python integration in SQL Server

Application developers are capable to operationalize
the Python code because it’s running inside the stored procedures and they do not
worry to care about that which version of Python is running inside T-SQL code.
We can say that intelligence is truly with the data and application developers do not
worry all about it.
In additional key benefit is for database administrator
where admin can choose to say that this kind of logins cannot use 5-6% CPU. So,
Python code cannot use 5-6% CPU. A dba can also see the database logs and views
to verify that who is executing the Python code as the regular part of the
database management.
Conclusion
Native integration of Python in SQL server for
in-database machine learning and the high-performance and distributed
statistical and machine learning functions from the RevoScaleR, RevoScalePy and MicrosoftML packages in
Microsoft R will be available as Python functions for use within SQL Server.
Reference - Microsoft blogs
Reference - Microsoft blogs
ReplyDeletePretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
Software testing course in chennai
Great Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
Members will be granted Data Science International Certification from UNIMAS after effectively clearing the online assessment. data science course in pune
ReplyDeleteThanks for taking the time to discuss this, I feel happy about it and love to learn more on this topic.
ReplyDeleteui ux design course in Chennai
ux design course in chennai
ui ux course in chennai
Web Designing Course in chennai
web designing training in chennai
AngularJS Training in Chennai
ccna course in Chennai
ui ux design course in Velachery
ui ux design course in T Nagar
ui ux design course in OMR
Well, the most on top staying topic is Data Science.Out of all, Data science course in Mumbai is making a huge difference all across the country. Thank you so much for showing your work and thank you so much for this wonderful article.
ReplyDeleteJust saying thanks will not just be sufficient, for the fantastic lucidity in your writing. I will instantly grab your articles to get deeper into the topic. And as the same way ExcelR also helps organisations by providing
ReplyDeleteData science course based on practical knowledge and theoretical concepts. It offers the best value in training services combined with the support of our creative staff to provide meaningful solution that suits your learning needs.
I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeletemachine learning course bangalore
Nice Post...I have learn some new information.thanks for sharing.
ReplyDeleteExcelR data analytics course in Pune | business analytics course | data scientist course in Pune
Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about
ReplyDeleteI would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own Blog Engine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. data science course
ReplyDelete
ReplyDeleteThe information provided on the site is informative. Looking forward more such blogs. Thanks for sharing .
Artificial Inteligence course in Thiruvananthapuram
AI Course in Thiruvanantapuram
Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDeleteData Science In Banglore With Placements
Data Science Course In Bangalore
Data Science Training In Bangalore
Best Data Science Courses In Bangalore
Data Science Institute In Bangalore
Thank you..
This is my first time visit here. From the tons of comments ExcelR Machine Learning Course Pune on your articles.I guess I am not only one having all the enjoyment right here!
ReplyDeleteThe job of carrying out the aforementioned tasks efficiently is in the hands of a data scientist. A data scientist is a person who is trained in this field. data science course syllabus
ReplyDeletevery informative blog
ReplyDeletedata science training in Pune
hello sir,
ReplyDeletethanks for giving that type of information. I am really happy to visit your blog.Leading Solar company in Andhra Pradesh
i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
ReplyDeleteData Scientist Course
The JavaScript for Beginners course aims to build an in-depth understanding of the various aspects of JS that are mandatory for understanding how JavaScript applications work. Topics covered : JavaScript arrays, functions, and objects, Conditionals, loops, and switch, Building applications with JavaScript. best SQL courses
ReplyDeleteI wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. python training london
ReplyDeletePositive site, where did u come up with the information on this posting? I'm pleased I discovered it though, ill be checking back soon to find out what additional posts you include. python course london
ReplyDeleteThis is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. python training london
ReplyDeleteYou have noted terribly interesting points ! ps tight web web site here. Best assignment provider in Malaysia
ReplyDeleteLook here for information on how to accomplish this task.Best Minecraft Servers
ReplyDelete