Tag: row

Feed: Planet PostgreSQL. Windowing functions and analytics have been around for quite some time and many people already make use of this awesome stuff in the PostgreSQL world. Timeseries  are an especially important area in this context. However, not all features have been widely adopted and thus many developers have to implement functionality at the application level in a painful way instead of just using some of the more advanced SQL techniques.The idea of this blog is to demonstrate some of the advanced stuff so that more people out there can make use of PostgreSQL’s true power.Preparing data for analyticsFor ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Tamar Gal. Let’s explore the complexity and vulnerability of IT infrastructure and how to build a modern IT infrastructure monitoring solution, using a combination of time series databases with machine learning. iCloud recently joined Google, Facebook, Amazon on the list of major companies that have experienced massive cloud outages. Check out ZDNet’s series of articles detailing the outages. The outage caused disruptions to the likes of YouTube, Snapchat, and Gmail, among others. iCloud’s failure also affected all their third-party apps and ApplePay, which resounded globally. We have quickly embraced the cloud as more ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Answering this question is not easy. Like always, the best response is “it depends” ! But let’s try to give you all the necessary info the provide the most accurate answer. Also, may be fixing one single query is not enough and looking for that specific statement will lead in finding multiple problematic statements. The most consuming one The first candidate to be fixed is the query that consumes most of the execution time (latency). To identify it, we will use the sys schema and join it with events_statements_summary_by_digest from performance_schemato retrieve a real ... Read More

Feed: Hadoop Dev. Author: Nagapriya Tiruthani. Announcing the immediate availability of Db2 Big SQL on Cloudera’s platform, CDH v6.2.  Extending the recent support on CDH v5, Db2 Big SQL will now add support to Cloudera Distributed Hadoop (CDH) v6.2 platform along with Hortonworks Data Platform (HDP) v2.6 & v3.1. Db2 Big SQL is an advanced SQL engine optimized for advanced analytics in a Big Data environment. IBM infuses the power of industry leading Db2 in open source technologies for machine learning, interactive, adhoc and batch analytics use cases.  The core capabilites of a mature SQL engine brings enterprise SQL capabilies to Big Data platform ... Read More

Feed: Planet PostgreSQL. We have been writing blog posts about how to write simple extensions in C language and a little more complex one by Ibrar which were well received by PostgreSQL user community. Then we observed that many PostgreSQL users create simple triggers for small auditing requirements, and then feel the pain of trigger on transactions. So we were discussing how simple/lightweight and faster a trigger function is when written in C. Generally, Trigger functions are written in high-level languages like PlpgSQL, but it has a higher overhead during execution and it can impact the transactions – and thereby ... Read More

Feed: AWS Big Data Blog. Data lakes are an increasingly popular way to create a single repository to store and analyze both structured and unstructured data. AWS Lake Formation makes it easy for you to set up, secure, and manage data lakes. This post walks you through the creation and exploration of a data lake using Lake Formation:Creating the data lake o  Adding data to your data lake o  Creating catalog databases o  Adding tables from Amazon S3 to catalog databases Editing and adding metadata within the catalog o  Editing standard metadata o  Adding custom metadata Prerequisites For this post, ... Read More

Feed: R-bloggers. Author: Business Science. [This article was first published on business-science.io, 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. Wrangling Big Data is one of the best features of the R programming language, which boasts a Big Data Ecosystem that contains fast in-memory tools (e.g. data.table) and distributed computational tools (sparklyr). With the NEW dtplyr package, data scientists with dplyr experience gain the benefits of data.table backend. We saw a 3X speed ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Multi-Valued Indexes are going to change the way you think about using JSON data and the way you architect your data. Before MySQL 8.0.17 you could store data in JSON arrays but trying to search on that data in those embedded arrays was tricky and usually required a full table scan.  But now it is easy and very quick to search and to access the data in JSON arrays. Multi-Valued Indexes A Multi-Valued Index (MVI) is a secondary index defined on a column made up of an array of values.  We are all used ... Read More

Feed: CronJ. Author: Pavan Kalyan; Here, I’m going to explain to you how to quickly build out a beautiful interface for your applications with Flutter’s widget composition. If you haven’t tried Flutter yet, it’s Google’s new mobile UI SDK that can help you quickly build native iOS and Android apps from a single codebase. Widgets are the building block of any app built with Flutter, and their functionality spans from providing a framework for your entire app, like the scaffold widget, to accepting input, like text field does, or even animating an ink splash. Every widget has its own particular ... Read More

Feed: R-bloggers. Author: lortie. messy data can be your friend (or frenemy)Many if not most data clean up, tidying, wrangling, and joining can be done directly in R. There are many advantages to this approach – i.e. read in data in whatever format (from excel to json to zip) and then do your tidying – including transparency, a record of what you did, reproducibility (if you ever have to do it again for another experiment or someone else does), and reproducibility again if your data get updated and you must rinse and repeat! Additionally, an all-R workflow forces you to ... Read More