Tag: row

Feed: MemSQL Blog. Author: Eric Hanson. MemSQL is uniquely suited to real-time analytics, where data is being ingested, updated, and queried concurrently with aggregate queries. Real-time analytics use cases often are based on event data, where each separate event has a timestamp. It’s natural to interpret such a sequence of events as a time series. Prior to the 7.0 release, MemSQL delivered many capabilities that make it well-suited to time-series data management [Han19]. These include: a scaled-out, shared-nothing architecture that supports transactional and analytical workloads with a standard SQL interface, fast query execution via compilation and vectorization, combined with scale ... Read More

Feed: R-bloggers. Author: mark. [This article was first published on R – Mark van der Loo, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Version 0.1.3 of the lintools package was accepted on CRAN today. This version brings a few internal improvements and switches the testing suite to the tinytest test infrastructure. lintools is provides basic manipulations of linear systems of equalities and inequalities including: variable elimination (Gaussian elimination, Fourier-Motzkin elimination), Moore-Penrose pseudoinverse, ... Read More

Feed: R-bloggers. Author: Theo Roe. [This article was first published on r – Jumping Rivers, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Before we start anything, I’d like to mention that most of the hard work came from nsaunders and his great blog post Idle thoughts lead to R internals: how to count function arguments. Let’s get started. The aim of this blog is to capture the number of arguments present in ... Read More

Feed: Planet PostgreSQL. SQL is query a language that is usually pretty easy to read. However, if people don’t format their queries properly even SQL turn out to be a nightmare. That’s why developers often turn to an SQL beautifier to turn an ugly query into a nicely formatted string. Various tools are available on the web to achieve exactly that.Can the same thing be achieved using only PostgreSQL onboard tools? The answer is yes. This post will show you how to achieve that.How PostgreSQL handles viewsIn PostgreSQL a view is not stored as plain text. Instead, it is stored ... Read More

Feed: What's New. Author: Ryan Sleeper. The table and dot plot you see in my visualization are actually two separate sheets made to appear as one. When this is the case, by default, Tableau adds a scroll bar to each sheet. Not only does this take up space with a clunky gray scroll bar, the two scroll bars do not scroll to the same spot in unison. Needless to say, this can result in a horrible user experience and design. As with most things in Tableau, there is a hack for that. This is an ingenious trick I picked up ... Read More

Feed: SAS Blogs. Author: Rick Wicklin. Longitudinal data are used in many health-related studies in which individuals are measured at multiple points in time to monitor changes in a response variable, such as weight, cholesterol, or blood pressure. There are many excellent articles and books that describe the advantages of a mixed model for analyzing longitudinal data. Recently, I encountered an introductory article that summarizes the essential issues in a little more than five pages! You can download the article for free: "A Primer in Longitudinal Data Analysis", by G. Fitzmaurice and C. Ravichandran (2008), Circulation, 118(19), p. 2005-2010. The ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Hello dear MySQL Community ! As you know FOSDEM 2020 will take place February 1st and 2nd. After having received many, many requests we decided to organize for the 4th year in a row the pre-FOSDEM MySQL Day… with a big change, for this edition the event will be called “pre-FOSDEM MySQL Days” ! We have decided to extend that extra day related to the world’s most popular open source database to 2 days: 30th and 31st of January at the usual location in Brussels. We will also have the usual sessions track but ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Asim Kumar Sasmal. Post by Asim Kumar Sasmal, Senior Data Architect in the IoT Global Specialty Practice of AWS Professional Services and Saras Kaul, Senior Product Manager of AWS IoT SiteWise. [Before reading this post, read Part 1 and Part 2 in the series.] In Part 1 of this series, you learned how to model and ingest data from industrial sites in a secure, cost-effective, and reliable manner using AWS IoT SiteWise (in preview). In Part 2, you learned how to monitor key measurements and metrics of your assets in near-real time ... Read More

Feed: R-bloggers. Author: Fabian Dablander. [This article was first published on Fabian Dablander, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Causal inference goes beyond prediction by modeling the outcome of interventions and formalizing counterfactual reasoning. In this blog post, I provide an introduction to the graphical approach to causal inference in the tradition of Sewell Wright, Judea Pearl, and others. We first rehash the common adage that correlation is not causation. We ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; Replication MySQL supports what it calls replication filters. They allow to decide which tables are replicated, and which are not. They can be set on a slave to filter-in tables and databases: the slave will not replicate everything from the master, but only the specified databases and tables. Or they can filter-out tables and databases: the specified databases and tables will be ignored, everything else will be replicated. Or we can use a combination of in-filters and out-filters. And we can filter specific databases, specific tables, or patterns for table names (for example, all ... Read More