Tag: query

Feed: Featured Blog Posts - Data Science Central. Author: Dr. Moloy De. I was deputed to work at Lagos, Nigeria in 2011 to work for a telecom giant there. The project in hand was to develop customer analytics modules using SAS on customer's newly built Oracle data warehouse. We thought about developing following modules. Customer Churn Analysis Calculating Product Propensities Customer Lifetime Value Calculation Customer Segmentation Customer Churn Analysis: A subscriber was defined to have churned if he / she didn't make any revenue generating usage in past three months. Following this definition around 15% subscribers were found to have ... Read More

Feed: Planet PostgreSQL. Postgres has not global variables for PLpgSQL. This week I worked for one customer who had emulation of global variables based on temporary tables.Depends on usage, this implementation can be very slow - more due often using temporary tables, a pg_class, pg_attribute tables can bloat, and these functions are slower and slower. So don't use it. There are alternative, much better solution, based on custom configuration variables:Original code: CREATE OR REPLACE FUNCTION public.setvar(_varname text, _value text) RETURNS void LANGUAGE plpgsql 1 AS $function$ 2 begin 3 create temporary table if not exists variables(varname text unique, value text); ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Introduction             We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic . If you are looking for other articles on our ProxySQL Series : MySQL replication Read-Write Split up Replication Switchover using Proxysql And MHA HA for proxysql with keepalived Mirroring MySQL Queries Handling Resource expensive Queries Percona Cluster/MariaDB cluster(Galera) Read-Write Split. Amazon Aurora (RDS) ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; MySQL Server generates several logs that can help you monitor the activities of the server. However, once these logs are enabled, they can grow in size and start taking up too much disk space. This is why it’s important to have an automated way of archiving and preserving MySQL log files for a certain duration, as well as deleting the old ones. In this blog post, we describe some best practices for setting up and managing MySQL error logs, general logs and slow query logs for your MySQL deployments. Setting Up MySQL Server Logging Let’s ... 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: Planet PostgreSQL. PoWA 4 is available in beta. New remote mode! The new remote mode is the biggest feature introduced in PoWA 4, though there have been other improvements. I’ll describe here what this new mode implies and what changed in the UI. If you’re interested in more details about the rest of the changes in PoWA 4, I’ll soon publish other articles for that. For the most hurried people, feel free to directly go on the v4 demo of PoWA, kindly hosted by Adrien Nayrat. No credential needed, just click on “Login”. Why is a remote mode important ... 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: Featured Blog Posts - Data Science Central. Author: Andrii Gakhov. Here I want to present my new book on advanced algorithms for data-intensive applications named "Probabilistic Data Structures and Algorithms in Big Data Applications" (ISBN: 9783748190486). The detailed information about the book you can find at its webpage and below I give you some introduction to the topic this book is about. What are the probabilistic data structures and why do we need them? There is no doubt that a lot of data creates unbelievable opportunities to learn and opens new horizons for business. However, this also implies lots of ... 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: 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