Tag: Database

Feed: MemSQL Blog. Author: Eric Hanson. The limitations of a typical, traditional relational database management system (RDBMS) have forced all sorts of compromises on data processing systems: from limitations on database size, to the separation of transaction processing from analytics. One such compromise has been the “sharding” of various customer accounts into separate database instances, partly so each customer could fit on a single computer server – but, in a typical power law, or Zipf, distribution, the larger database don’t fit. In response, database administrators have had to implement semi-custom sharding schemes. Here, we describe these schemes, discuss their limitations, ... Read More

Feed: R-bloggers. Author: An Accounting and Data Science Nerd's Corner. Last week, we started a new course titled “Statistical Programming and OpenScience Methods”. It is being offered under the research program ofTRR 266 “Accounting for Transparency”and enables students to conduct data-based research so that others can contributeand collaborate. This involves making research data and methods FAIR(findable, accessible, interoperable and reusable) and results reproducible.All the materials of the course areavailable on GitHub together withsome notes in the README on how to use them for self-guided learning. The course is over-booked so running a normal introduction round was notfeasible. Yet, I was ... Read More

Feed: Planet PostgreSQL. It is well known that database design should be as simple as possible, and follow the normalization process. Except in some cases, sometimes, for scalability purposes. Partitioning might be used to help deal with large amount of data for instance. But what is a large amount of data? Do you need to pay attention to those scalability trade-offs now, or can you wait until later? How far can you go with a naive schema? To answer those questions, it might be best to estimate the evolution of the size of your database in the following months. Here’s ... Read More

Feed: Planet MySQL; Author: RoseHosting; In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS. A LAMP (Linux, Apache, MySQL, PHP) stack is a combination of open-source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL or MariaDB for data storage and management, and PHP for handling any dynamic content. Installing LAMP on Debian 9 is a straightforward task and should not take more than 10 minutes. Let’s start with the installation. Table of Contents Prerequisites: A ... Read More

Feed: Recent Announcements. Once you create tags for your RDS DB instances, you can separate RDS backup charges in AWS Cost Explorer according to the tags of the corresponding DB instances. When you view your Cost and Usage Report (CUR), you’ll find that the ResourceId for each RDS ChargedBackup line contains the name of the corresponding DB instance, and tags associated with the DB instance are marked in additional columns. Note that detailed backup charges have been activated as of October 8, 2019. Your RDS backup charges prior to this date will continue to show up as a single line ... Read More

Feed: Neo4j Graph Database Platform. Author: Mark Needham. Our team was in Ängelholm, Sweden this week, to spend some time working together which is rare as a distributed group. But especially also to run the very first Neo4j Online Developer Conference (NODES), with more than 50 sessions by speakers from 15 countries in 5 tracks. Thanks a lot to everyone who presented, contributed and helped. So we’re excited to make the first content available, Emils Keynote and announcements. In the Keynote he covered the impressive Neo4j community, Jim Webber showed a preview of 4.0 features, Michael spoke about Neo4j Labs ... Read More

Feed: Planet MySQL; Author: Continuent; Business-Critical MySQL using open source is free, right?Managed MySQL cloud services do not need database administrators, correct? Well… Think again – and watch the replay of this webinar with our partner Datavail hosted by Database Trends & Applications on whether free is good enough for business-critical MySQL database environments. Listen in as Srinivasa Krishna, MySQL Practice Leader at Datavail, and Eero Teerikorpi, CEO & Founder at Continuent discuss the pros and cons of the DIY approach vs getting professional help in. This webinar discusses the limitations and hidden costs of DIY solutions for business-critical MySQL; ... Read More

Feed: Planet MySQL; Author: Øystein Grøvlen; As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to POLARDB for MySQL. As discussed in the presentation, we observe that parallel range scans on secondary indexes does not scale very well in MySQL. This is old news. Mark Callaghan reported this several years ago, and this does not seem to have changed. In this blog post, I will investigate what effects using a multi-processor machine have on the scalability of parallel index range scans. I will run a variant ... Read More

Feed: Oracle Blogs | Oracle Blogs. Oh, #OOW19, where should I start? There were compelling sessions, brilliant people, and an entire playpen of puppies. But the most exciting part hands down was the technology and new concepts announced at the event, starting with this simple yet bold claim that kicked off Oracle OpenWorld 2019: Oracle is a people-focused, data-driven organization. This message was everywhere at the conference. I saw proof of it in the technology I was fortunate enough to experience and heard about it firsthand from customers already using it at their organizations. It was also evident at the ... Read More

Feed: AWS Big Data Blog. Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud that offers fast query performance using the same SQL-based tools and business intelligence applications that you use today. Many customers also like to use Amazon Redshift as an extract, transform, and load (ETL) engine to use existing SQL developer skillsets, to quickly migrate pre-existing SQL-based ETL scripts, and—because Amazon Redshift is fully ACID-compliant—as an efficient mechanism to merge change data from source data systems.In this post, I show how to use AWS Step Functions and AWS Glue Python Shell to orchestrate tasks ... Read More