Tag: SQL

Feed: Featured Blog Posts - Data Science Central. Author: Vibhor Nigam. This post is a token of appreciation for the amazing open source community of Data Science, to which I owe a lot of what I have learned. For last few months, I have been working on a side project of mine to develop machine learning application on streaming data. It was a great learning experience with numerous challenges and lots of learning, some of which I have tried to share in here. This post is focused on how to deploy machine learning models on streaming data and covers all ... Read More

Feed: R-bloggers. Author: xi'an. I came across this question on X validated that wondered about one of our examples in Monte Carlo Statistical Methods. We have included a section on Laplace approximations in the Monte Carlo integration chapter, with a bit of reluctance on my side as this type of integral approximation does not directly connect to Monte Carlo methods. Even less in the case of the example as we aimed at replacing a coverage probability for a Gamma distribution with a formal Laplace approximation. Formal due to the lack of asymptotics, besides the length of the interval (a,b) which ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Today I am going to provide some details on the last item in my list of problems with Oracle's way of MySQL server development, maintenance of MySQL Manual. I stated that: "MySQL Manual still have many details missing and is not fixed fast enough. Moreover, it is not open source..." Let me explain the above:MySQL Reference Manual is not open source. It used to be built from DocBook XML sources. Probably that's still the case. But you can not find the source code in open repositories (please, correct me if I am wrong, I ... Read More

Feed: R-bloggers. Author: Anisa Dhana. In comparison with other statistical software (e.g., SAS, STATA, and SPSS), R is the best for data visualization. Therefore, in all posts I have written for DataScience+ I take advantage of R and make plots using ggplot2 to visualize all the findings. For example, previously I plotted the percentiles of body mass index in the NHANES 2005-2014 and got exactly same results as the paper published in JAMA. In this post, I will make a map of the prevalence of Alzheimer disease mortality by the state in the USA. The Centers for Disease Control and ... Read More

Feed: Blog. Author: Zoe Bell; We are excited to welcome Webyog into the Idera, Inc. family!In an effort to streamline all social media accounts, we are transitioning Webyog and Monyog social media handles over to IDERA. By following the IDERA handles, you will receive the latest Webyog product updates and announcements. And that’s not all! Everyone who follows @Idera_Software on Twitter between August 17, 2018 and August 31, 2018 will be entered to win an Amazon Tap! How to Participate: Log onto your Twitter account between August 17 and August 31 and follow @Idera_Software. You must be a new IDERA ... Read More

Feed: R-bloggers. Author: Jozef's Rblog. In this summertime post in the case4base series, we will look at useful tools in base R, which let us profile our code without any extra packages needed to be installed. We will cover simple and easy to use speed profiling, more complex profiling of performance and memory and, as always, look at alternatives to base R as well, with a special shout out to profiling integration in RStudio. Base function system.time returns the difference between two proc.time calls within which it evaluates an expression provided as argument. The simplest usage can be seen below: ... Read More

Feed: R-bloggers. Author: Thinking inside the box. A new RcppArmadillo release 0.9.100.5.0, based on the new Armadillo release 9.100.5 from earlier today, is now on CRAN and in Debian. It once again follows our (and Conrad’s) bi-monthly release schedule. Conrad started with a new 9.100.* series a few days ago. I ran reverse-depends checks and found an issue which he promptly addressed; CRAN found another which he also very promptly addressed. It remains a true pleasure to work with such experienced professionals as Conrad (with whom I finally had a beer around the recent useR! in his home town) and ... Read More

Feed: Planet big data. Author: David Smith. A monthly roundup of news about Artificial Intelligence, Machine Learning and Data Science. This is an eclectic collection of interesting blog posts, software announcements and data applications I've noted over the past month or so. Open Source AI, ML & Data Science News ONNX Model Zoo is now available, providing a library of pre-trained state-of-the-art models in deep learning in the ONNX format. In the 2018 IEEE Spectrum Top Programming Language rankings, Python takes the top spot and R ranks #7. Julia 1.0 has been released, marking the stabilization of the scientific computing ... Read More

Feed: R-bloggers. Author: . Topics and Categories in the Russian Troll Tweets I decided to return to the analysis I conducted for the IRA tweets dataset. (You can read up on that analysis and R code here.) Specifically, I returned to the LDA results, which looked like they lined up pretty well with the account categories identified by Darren Linvill and Patrick Warren. But with slightly altered code, we can confirm that or see if there’s more to the topics data than meets the eye. (Spoiler alert: There is more than meets the eye.) I reran much of the original ... Read More

Feed: Planet PostgreSQL. Citus has multiple different excutors which each behaving differently to support a wide array of use cases. For many the notion distributed SQL seems like it has to be a complicated one, but the principles of it aren’t rocket science. Here we’re going to look at a few examples of how Citus takes standard SQL and transforms it to operate in a distributed form so it can be parallelized. The result is that you can see speed up of 100x or more in query performance over a single node database. How do we know something is distributed ... Read More