Feed: R-bloggers. Author: Peter's stats stuff - R. I recently read the high quality book Global Inequality by Branko Milanovic. When reading this sort of thing, I often find I can increase my engagement with a topic by playing around with the data myself. In this day and age, this is much more likely to be possible than a couple of decades back! I remember when I first studied development economics, typing into Lotus 123 the data from tables in the back of a World Development Report. These days to get the same data we just fire up R and ... Read More

Feed: R-bloggers. Author: John Johnson. So the goal here is to focus back on Greenville County and have even more granularity. I look at median house prices near Greenville and then overlay the park data downloaded earlier. This time, for the Census data, I use the tidycensus package that came out recently. Furthermore, instead of using ggplot2 to create a static map, I use the leaflet package to create an interactive map, and, furthermore integrate data from disparate sources in a convenient way.The local parks file can be found here courtesy of a small group of dedicated volunteers and an ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.57. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 5.5.57 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: Scott Noyes; 1. Watch the parentheses. It's: ST_GeomFromText('POLYGON((outerRing), (innerRing), (innerRing), ...)') The inner rings are optional. If you have just the outer ring, then it's still: ST_GeomFromText('POLYGON((outerRing))') and not: ST_GeomFromText('POLYGON(outerRing)') 2. Polygons have to start and end at the same point. 3. Watch the commas. Rings are comma-delimited sets of of whitespace-delimited coordinate pairs: x1 y1, x2 y2, x3 y3, x4 y4 not:x1 y1 x2 y2 x3 y3x1, y1, x2, y2, x3, y3, x4, y4(x1, y1), (x2, y2), (x3, y3)or other variations on that theme. Share this: ... Read More

Feed: Planet MySQL; Author: Dave Stokes; I am starting a series of videos on the MySQL Document Store. The Document Store allows those who do not know Structured Query Language (SQL) to use a database without having to know the basics of relational databases, set theory, or data normalization. The goal is to have sort 2-3 minute episodes on the various facets of the Document Store including the basics, using various programming languages (Node.JS, PHP, Python), and materializing free form schemaless, NoSQL data into columns for use with SQL. The first Episode, Introduction, can be found here. Please provide feedback ... Read More

Feed: Planet MySQL; Author: MariaDB; The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.2.7 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB! ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This Log Buffer Edition covers Oracle, SQL Server and MySQL.Oracle:12.2 New Feature: the FLEX ASM disk group part 2Oracle ASM in Azure corruption – follow upSet-based processingADF 12c BC Proxy User DB Connection and Save Point ErrorEnabling A Modern Analytics PlatformSQL Server:Batch SSIS pkg execution from Business Intelligence Development StudioFind Database Connection Leaks in Your ApplicationTroubleshooting CPU Performance on VMwareSQLskills Wait Types Library now shows SentryOne dataPowerShell Tool Time: The Tool FrameworkMySQL:Installing Zabbix into Azure using a MySQL PaaSStreaming Global Cyber Attack Analytics with Tableau and PythonThread Statistics and High Memory UsageOn slave_parallel_workers ... Read More

Feed: Planet MySQL; Author: Baron Schwartz (xaprb); Mon, Jul 10, 2017 in Databases Humor The removal of the query cache in MySQL 8.0 improves user experience and has been celebrated by many members of the MySQL community. With this good news, obviously, Hitler isn’t happy. (Parody Video). I'm Baron Schwartz, the founder and CEO of VividCortex. I am the author of High Performance MySQL and lots of open-source software for performance analysis, monitoring, and system administration. I contribute to various database communities such as Oracle, PostgreSQL, Redis and MongoDB. More about me. Comments ... Read More

Feed: What's New. Author: Marissa Michelotti. You already know Tableau is great for exploring and analyzing data, but did you know you can also use Tableau to create a robust project management tool? All you have to do is build a Gantt chart. Looking for a project management viz template? Download this Gantt chart workbook: To refresh your memory, Gantt charts display a series of horizontal lines that track completed work over time. The chart type was invented in 1910 by Henry Gantt, a mechanical engineer and management consultant. He was called on to create a data view for the ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: HAN Lijun.   By JIANG Buxing, Data Scientist  Multidimensional analysis, commonly called OLAP, is an interactively data analysis process that performs operations, including rotation, slice and dice, drilldown etc., on a data cube. The structure of its back-end computation is simple, as shown by the following SQL: SELECT D,..., SUM(M), ... FROM C WHERE D'=d' AND ... GROUP BY D,... The statement aggregates some measures by some dimensions. C is a data cube, D,… represents dimensions to be selected, and M,… represents measures to be aggregated. Except for SUM, we can ... Read More