Tag: query

Feed: Recent Announcements. You can now use the AWS Elastic Beanstalk ListPlatformBranches API action that lists available Elastic Beanstalk platform branches and provides summary information about each platform branch. You can use the API action to query the platform state (Supported, Beta, Deprecated, Retired) of your Elastic Beanstalk environment. For more information on Platform Branch state, see Elastic Beanstalk Platforms Glossary in the AWS Elastic Beanstalk Developer Guide. For details about the ListPlatformBranches API action, see ListPlatformBranches in the AWS Elastic Beanstalk API Reference. See Release Notes for additional details ... Read More

Feed: AWS Big Data Blog. As the COVID-19 pandemic continues to threaten and take lives around the world, we must work together across organizations and scientific disciplines to fight this disease. Innumerable healthcare workers, medical researchers, scientists, and public health officials are already on the front lines caring for patients, searching for therapies, educating the public, and helping to set policy. At AWS, we believe that one way we can help is to provide these experts with the data and tools needed to better understand, track, plan for, and eventually contain and neutralize the virus that causes COVID-19.Today, we are ... Read More

Feed: Actian. Author: Pradeep Bhanot. There are times when financial markets trend up. There are times that markets trend down.  And then there are times that the markets go crazy and the only thing predictable is volatility. When markets encounter these volatile periods, financial services companies become highly reliant on data analytics to determine where the real market forces are coming from and determine how best to react. There are five key analytics capabilities that financial services companies need to perform effectively in a volatile market environment.Connected Data The more data you have available to analyze, the more accuracy you ... Read More

Feed: Neo4j Graph Database Platform. Author: Jocelyn Hoppa. At Neo4j, we’ve always been user-driven, and we know that many of you are dealing with increasingly complex questions and uncertain situations. One of our biggest user communities are developers and data scientists working for businesses that use advanced analytics and data science to improve predictions and drive better decision making. Because relationships are so predictive of behavior, we heard your collective call to simplify the methods of incorporating connected data into your workflows with robust, enterprise-grade features and scale. We appreciate your candid stories and collaboration, and we’ve used this to ... Read More

Feed: Planet MySQL; Author: Krunal Bauskar; By and large this would be a topic of interest for most of us including me when I started to explore this space. Before we dwell into the numbers let’s first understand some basic differences between 2 architectures. Beyond being CISC and RISC let’s look at the important differences from MySQL perspective. Strong vs Weak memory model (weak memory model needs proper memory barrier while writing lock-free code). Underlying hardware specific specialized instructions. For example: both now support crc32c hardware instructions but being low-level they are different ways to invoke them. For more differences ... Read More

Feed: R-bloggers. Author: rOpenSci - open tools for open science. After soliciting, reviewing, and publishing over 100 blog posts and tech notes by rOpenSci community members, we have created the rOpenSci Blog Guide for Authors and Editors to address many frequently asked questions and frequently given suggestions. Technically, we structured the content as a bookdown gitbook. It was Stef’s first foray into the glorious process of publishing a book with bookdown, and Maëlle’s second. And oh, we learned a lot. Stef (first-timer) 1. How to collaborate across timezones There is a 9-hour time difference between Maëlle and me for most ... Read More

Feed: Redis Labs. Author: Pieter Cailliau. The newly announced RedisGraph 2.0 module brings a number of improvements, including increased Cypher support, full-text search, and it enables graph visualization. Just as important, however, the latest version of RedisGraph delivers significant performance improvements: with latency improvements up to 6x and throughput improvements up to 5x. Let’s take a look at those performance gains and the benchmarks used to demonstrate them. When we released RedisGraph 1.0 back in November 2018, we shared benchmark results based on the k-hop neighborhood count query. The new RedisGraph 2.0 includes new features and functionalities that support more-comprehensive ... Read More

Feed: Redis Labs. Author: Pieter Cailliau. Redis is a noSQL database that enables users to store a variety of data in a variety of data structures. We saw a need for our customers to create highly connected data and derive insight by using graph technology. Originally released in 2018, RedisGraph is the result of that effort. RedisGraph is based on a unique approach and architecture that translates the Cypher query language to matrix operations executed over a GraphBLAS-based engine. By using sparse matrices to represent graphs and the power of GraphBLAS to process them, RedisGraph delivers a fast and efficient ... Read More

Feed: Planet PostgreSQL. By design, the out of the box configuration for PostgreSQL is defined to be a "Jack of All Trades, Master of None". The default configuration for PostgreSQL is fairly painstakingly chosen to ensure that it will run on every environment it is installed, meeting the lowest common denominator resources across most platforms.Because of this, it's always recommended that one of the first actions performed once an install of PostgreSQL is completed, would be to tune and configure some high-level settings. There are four high-level settings which will be discussed here: shared_buffers,  wal_buffers,  effective_cache_size, and maintenance_work_mem. Let's begin with shared_buffers ... Read More

Feed: Planet PostgreSQL. Write-Ahead Logs is a critical part of PostgreSQL, that ensures data durability. While there are multiple configuration parameters , there was no easy to monitor WAL activity, or what is generating it. New infrastructure to track WAL activity commit df3b181499b40523bd6244a4e5eb554acb9020ce Author: Amit Kapila Date: Sat Apr 4 10:02:08 2020 +0530 Add infrastructure to track WAL usage. This allows gathering the WAL generation statistics for each statement execution. The three statistics that we collect are the number of WAL records, the number of full page writes and the amount of WAL bytes generated. This helps the users who ... Read More