Tag: Database

Feed: MemSQL Blog. Author: Floyd Smith. Analyst firm 451 Research has come up with new research that sees a bright future for HOAP – hybrid operational and analytical processing. The report is titled 451 Perspective: A HOAP-ful future for hybrid operational and analytical processing. This new type of processing has received several different names, from different analyst firms and consultancies: By any of these names, this new style of data processing – which unifies transactions and operational analytics, including many data warehousing-type functions – is widely believed to have a bright future. And MemSQL is right in the middle of ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: kevin-oliver; Two of the greatest challenges faced by organizations today are the rising volume of data and the lack of  confidence to act on the insights this data reveals. Fortunately, there are AI-fueled data management solutions that directly address these two challenges to make data simple and accessible.Databases should be both powered by AI and built for AI, meaning they use embedded AI capabilities to improve their day-to-day functionality (powered by AI), while also being able to support AI initiatives throughout the entire business (built for AI). For example, ... Read More

Feed: Blog – Hazelcast. Author: Vladimir Schreiner. Tech conferences and meetups have been canceled or postponed across the world. To make the situation a little bit more pleasing for everybody who misses them, Hazelcast has started a series of virtual tech meetups. Please join us on Thursdays, starting April 2nd. Always at 3:30pm CET/ 7:30am PDT / 10:30am EDT / 2:30pm GMT. The list of topics: Streaming in the world of legacy applications (Vladimir Schreiner) Date: Thursday, April 2, 2020 Join: https://hazelcast.com/resources/tech-talk-streaming-in-the-world-of-legacy-applications/ A practical introduction to CDC (Change Data Capture). Architecture, trade-offs, tooling, and demos. There are common themes when ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that anyone can implement – with no guesswork required.Depending on the version of MySQL you are running, some of the default values used in this post may differ from your install, but the premise is still largely the ... Read More

Feed: Matillion. Author: Julie Polito; Want the very best Matillion ETL experience? Each new version of Matillion ETL is better than the last. Make sure you are on the latest version to take advantage of the new features, new components, and improvements. In this blog, find out about the new components, features, and improvements introduced in Matillion ETL v1.44.  New and updated data source components Box component (new) and Data Transfer component (update)  Box contains a lot of data files, most commonly CSV files and spreadsheets. This component will tell you what data exists within the Box and help you ... Read More

Feed: Matillion. Author: Julie Polito; We’ve updated all of our Matillion ETL base operating systems on your virtual machine (VM) to use a CentOS Operating System, Apache Tomcat version 8.5.51 and an internal Postgres database. This will be available for all new spin-ups of Matillion ETL across all platforms and products from version 1.44 onwards. In-place upgrades, that is, updates performed either using the ‘Update’ button from the Admin Menu or manually via ‘yum’, will mean the VM will remain on your existing Operating System and version of Tomcat. Therefore we recommend that you spin up a new instance and ... Read More

Feed: Planet MySQL; Author: FromDual; On StackExchange for Database Administrators I recently have seen a question which attracted my interest.The question puzzled me a bit because the answer seems too easy. Further the question was not so clear. An all theses factors smell dangerous... About time - was, is and will be How can I find out if the database "was" shutdown slowly? This is quite easy: Look into your MySQL Error Log and there you will find a log sequence similar to the following: 2020-03-30T08:03:36.928017Z 0 [System] [MY-010910] [Server] /home/mysql/product/mysql-8.0.19-linux-glibc2.12-x86_64/bin/mysqld: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.Ups! ... Read More

Feed: R-bloggers. Author: Nagdev. [This article was first published on R – Hi! I am Nagdev, 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. As a data scientist, I always seek to learn about out new tools and techniques. Although research papers are a great resource to learn, they are mostly either theoretical or lack in hands on explanation. Blogs are a great way to learn if you like me. They are concise, ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . There are several ways to move data between SQL Server and MariaDB. Here we will discuss them and we will highlight some caveats. Moving Data Definition from SQL Server to MariaDB To copy an SQL Server data structures to MariaDB, one has to: Generate a CSV file from SQL Server data. Modify the syntax so that it works in MariaDB. Run the file in MariaDB. Variables That Affect DDL Statements DDL statements are affected by some server system variables. sql_mode determines the behavior of some SQL statements and expressions, including how strict ... Read More

Feed: Redis Labs. Author: Guy Royse. Like many software engineers, I enjoy a good game of Dungeons & Dragons. I love powering up my character and facing increasingly more powerful foes. Doing this right requires gold and experience. And the best way to get those things is a good old-fashioned dungeon crawl. If you need some context on D&D, this video might help. The short but overly simplified version: in D&D you explore underground complexes, fight monsters therein, and take their gold. Unfortunately, dungeons aren’t set up for the convenience of adventurers like us. Sometimes the monster is challenging but ... Read More