Tag: allow

Feed: R-bloggers. Author: R on Jacob Long. It has been a long time coming, but my R packagepanelr is now onCRAN. Since I started work on itwell over a year ago, it has become essential to my own workflow and I hopeit can be useful for others. panel_data object class One key contribution, that I hope can help other developers, is the creation ofa panel_data object class. It is a modified tibble, which is itself amodified data.frame. panel_data frames are grouped by entity, so manyoperations (e.g., mean(), cumsum()) performed by dplyr’s mutate()are groupwise operations. The panel_data frame also works very ... Read More

Feed: Neo4j Graph Database Platform. Author: Jocelyn Hoppa. Editor’s Note: This presentation was given by Frederick Kagan and Sébastien Heymann at GraphConnect New York in October 2018.Presentation SummaryThe American Enterprise Institute (AEI) is an independently-funded nonprofit that uses unclassified information to understand ongoing conflicts in the Middle East, Africa and Europe to produce forecasts and policy recommendations.Like the intelligence community, and almost any large-scale business analysis team, the nonprofit had to solve problem of munging all their data together into a single interface. They found their solution with the combined power of Neo4j and Linkurious, even though they encountered some ... Read More

Feed: The Connector by Workato. Author: Hannah Herman; This piece is part of our Digital Change Agents Series – Bay Area. When a business process intersects with multiple teams’ systems, how do you go about making it more efficient? Erik Lopez, Senior Business Systems Manager at Lucidchart, suggests that—much like the dictionary—it’s all about definitions. With its intuitive and collaborative diagramming solution, LucidChart is a leading tool for thought mapping. It’s no surprise, then, that Lopez applies a similarly rigorous framework to all of his projects. “I provide the internal support our employees need so they can focus on the ... Read More

Feed: Microsoft Azure Blog. Author: Morgan Oslake. Optimizing compute resource allocation to achieve performance goals while controlling costs can be a challenging balance to strike especially for database workloads with complex usage patterns. To help address these challenges, we are pleased to announce the preview of Azure SQL Database serverless. SQL Database serverless (preview) is a new compute tier that optimizes price-performance and simplifies performance management for databases with intermittent and unpredictable usage. Line-of-business applications, dev/test databases, content management and e-commerce systems are just some examples across a range of applications that often fit the usage pattern ideal for SQL ... Read More

Feed: R-bloggers. Author: Pablo Seibelt. A new version of the package redshiftTools has arrived with improvements and it’s now available in CRAN! This package let’s you efficiently upload data into an Amazon Redshift database using the approach recommended by Amazon This package is helpful because otherwise uploading data with inserts in Redshift is super slow, this is the recommended way of doing replaces and upserts per the Redshift documentation, which consists of generating various CSV files, uploading them to an S3 bucket and then calling a copy command on the Redshift server, all of that is handled by the package ... Read More

Feed: Planet PostgreSQL. © xkcd.com under the Creative Commons License 2.5Functions defined as SECURITY DEFINER are a powerful, but dangerous tool in PostgreSQL.The documentation warns of the dangers:Because a SECURITY DEFINER function is executed with the privileges of the user that owns it, care is needed to ensure that the function cannot be misused. For security, search_path should be set to exclude any schemas writable by untrusted users. This prevents malicious users from creating objects (e.g., tables, functions, and operators) that mask objects intended to be used by the function.This article describes such an attack, in the hope to alert ... Read More

Feed: Microsoft Power BI Blog | Microsoft Power BI. Author: . We have an exciting release this month. On top of incremental improvements for several of our recent released features, such as the key influencers visual and our new filter pane, we also have a new performance analyzer pane. This new pane lets you get a behind the scenes view of what’s happening when your report is loading, which can help you optimize your report and improve your end user’s experience. Here’s the complete list of May updates: Reporting Analytics Modeling Visualizations Data connectivity Other For a summary of the ... Read More

Feed: R-bloggers. Author: R Views. Phillip (Armand) Bester is a medical scientist, researcher, and lecturer at the Division of Virology, University of the Free State, and National Health Laboratory Service (NHLS), Bloemfontein, South Africa Andrie de Vries is the author of “R for Dummies” and a Solutions Engineer at RStudio Recap In part 2 of this series, we discussed the PhyloPi pipeline for conducting routine HIV phylogenetics in the drug-resistance testing laboratory as a part of quality control. As mentioned, during HIV replication the error-prone viral reverse transcriptase (RT) converts its RNA genome into DNA before it can be integrated ... Read More

Feed: R-bloggers. Author: Achim Zeileis. Personalized treatment effects can be estimated easily with model-based trees and model-based random forests using the R package model4you. Citation Heidi Seibold, Achim Zeileis, Torsten Hothorn (2019). “model4you: An R Package for Personalised Treatment Effect Estimation.” Journal of Open Research Software, 7(17), 1-6. doi:10.5334/jors.219 Abstract Typical models estimating treatment effects assume that the treatment effect is the same for all individuals. Model-based recursive partitioning allows to relax this assumption and to estimate stratified treatment effects (model-based trees) or even personalised treatment effects (model-based forests). With model-based trees one can compute treatment effects for different strata ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: roger-rea; IBM Streams was first available on May 15, 2009, exactly 10 years ago today. Happy anniversary!From System S to Streams IBM Streams evolved from a five-year collaboration between IBM Research and the U.S. government. The original goals were to: Create a system to ingest unprecedented volumes of data Analyze data arriving at extremely high velocity Handle a variety of data, both structured and unstructured. You can glean some Streams history from the IBM Research pages for System S project. The “S” was short for Streams, to play off ... Read More