Tag: SQL

Feed: R-bloggers. Author: Branden Dunbar. At Plotly, we are commonly asked about thematic maps — especially county-level choropleth maps. This style of map provides a visual illustration of variation across a geographic area. Some pertinent uses are population density, economic measurements, crime statistics, and election results. With Plotly, there are multiple ways to bring county-level choropleths to life. For example, using ggplotly or native plot_ly or plot_mapbox . . . For now, we will look at how to create the US electoral map using the ggplotly method. For more information concerning the plot_ly and plot_mapbox examples, checkout our R documentation library.   ... Read More

Feed: R-bloggers. Author: Peter Laurinec. Ensemble learning methods are widely used nowadays for its predictive performance improvement. Ensemble learning combines multiple predictions (forecasts) from one or multiple methods to overcome accuracy of simple prediction and to avoid possible overfit. In the domain of time series forecasting, we have somehow obstructed situation because of dynamic changes in coming data. However, when a single regression model is used for forecasting, time dependency is not the obstacle, we can tune it at current time of a sliding window. For this reason, in this post, I will describe you two simple ensemble learning methods ... Read More

Feed: R-bloggers. Author: R – Bio7 Website. 19.10.2017 I released a new version of Bio7 for MacOSX. (Screenshots: Bio7 with Dark theme enabled. Scrollbars are set to “When scrolling” in the preferences.) For an overview of the new features please consult the release notes of Windows and Linux here: Installation: Download and extract the installation file from http://bio7.org. If you start Bio7 a warning or error can occur because of the changes how Apple treats signatures! To allow Bio7 to start see this instructions for Yosemite and Sierra: OS X Yosemite: Open an app from an unidentified developer macOS Sierra: ... Read More

Feed: Hadoop Dev. Author: Nailah Bissoon. The intention of this blog is to outline the process that can be taken to clone a Big SQL database from one cluster to another. The procedure outlined here relies on taking an offline backup of the Big SQL database on one cluster and restoring it to another. The backup of the Big SQL database should be scheduled in off peak hours as it requires a database deactivation. Important – The two clusters must be identical with the same version of Big SQL, OS level, number of nodes and Big SQL configuration. At the ... Read More

Feed: R-bloggers. Author: David Smith. Taxis are plentiful and convenient in New York City, but the city is also served by a wide network of commuter bicycles (Citi Bikes). If you need to get from, say, the West Village to the Garment District, are you better off time-wise hailing a cab, or heading over to the nearest Citi Bike station? Data scientist Todd W. Schnieder crunched the number on travel times for both taxis and Citi Bikes to figure out which was better. Neither is universally the best, but for some trips taxis are most often the fastest, and for ... Read More

Feed: R-bloggers. Author: R Views. There are many ways to query data with R. This post shows you three of the most common ways: Using DBI Using dplyr syntax Using R Notebooks Background Several recent package improvements make it easier for you to use databases with R. The query examples below demonstrate some of the capabilities of these R packages. DBI. The DBI specification has gone through many recent improvements. When working with databases, you should always use packages that are DBI-compliant. dplyr & dbplyr. The dplyr package now has a generalized SQL backend for talking to databases, and the ... Read More

Feed: IDERA Community Blog; Author: Zoe Bell; While medical facilities are most at risk for a HIPAA violation, most organizations in the United States have to comply with the law and can be hit with civil and criminal penalties.Participate in our next Twitter Chat on November 29 at 11 AM CT with host K. Brian Kelley (@kbriankelley) as he leads a community discussion on meeting HIPAA compliance with your databases. What challenges are you having? What can you share that you wish you knew before you started your own efforts? Discuss this and more using #SQLChat. This #SQLChat will allow ... Read More

Feed: All - O'Reilly Media. Author: Greg Rahn. Clouds (source: Pexels) Check out Greg Rahn’s session, “Rethinking data marts in the cloud: Common architectural patterns for analytics” at the Strata Data Conference in Singapore, December 4-7, 2017, to learn how to architect analytic workloads in the cloud and the core elements of data governance. Early price ends October 20. Many of us are all too familiar with the traditional way enterprises operate when it comes to on-premises data warehousing and data marts: the enterprise data warehouse (EDW) is often the center of the universe. Frequently, the EDW is treated a ... Read More

Feed: All - O'Reilly Media. Author: Aditya Parameswaran. Gears (source: Pixabay) Check out “How Pirelli built a data science team from scratch,” a case study available on Safari, to learn more about how data science can enable business transformation. As practitioners who build data science tools, we seem to have a rather myopic obsession with the challenges faced by the Googles, Amazons, and Facebooks of the world—companies with massive and mature data analytics ecosystems, supported by experienced systems engineers, and used by data scientists who are capable programmers. However, these companies represent a tiny fraction of the “big data” universe ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . From MariaDB 10.3, setting the sql_mode system variable to Oracle causes the server to understand a subset of Oracle's PL/SQL language instead of the traditional MariaDB syntax for stored routines. This work is in progress. See MDEV-10142 and MDEV-10764 for the current status and subtasks. Providing compatibility for basic PL/SQL constructs - MDEV-10411 %TYPE in variable declarations - MDEV-10577 cursor%ROWTYPE in variable declarations - MDEV-12011 table%ROWTYPE in variable declarations - MDEV-12133 FOR loop statement - MDEV-10580 Implicit cursor FOR loop - MDEV-12098 Explicit cursor FOR LOOP - MDEV-10581 Cursors with parameters - ... Read More