Tag: data types

Feed: Redis Labs. Author: Madhukar Kumar. We just released a new version of Redis Enterprise – v5.4.2 and are happy to announce that we’ve added a much requested feature. One of the big highlights of this release is improved compatibility for active-active Redis (through CRDBs, or conflict-free replicated databases) COUNTER operations with open source Redis. Redis Enterprise 5.4.2 also contains other new features and capabilities, such as: Active-active Redis’ compatibility in Redis Enterprise 5.4.2 Prior to version 5.4.2, we treated COUNTERs as a different data type in Redis. In some scenarios, this created conflicts with the way users were used ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . MariaDB 10.3 is the current major stable version. The first stable release was in May 2018, and it will be supported until May 2023. For details on upgrading from MariaDB 10.2, see Upgrading from MariaDB 10.2 to 10.3. MariaDB Server 10.3 is included in MariaDB TX 3.0. Watch the webinar recording to learn more about the new features included in this release. The following lists the major new features in MariaDB 10.3: Implemented Features Syntax / General Features System-versioned tables (also known as AS OF) (MDEV-12894) Table Value Constructors (MDEV-12172) — GSoC ... Read More

Feed: Planet PostgreSQL. PREVIOUS POST When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post we’ll take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using pg_upgrade allows you, potentially, to minimize your downtime, an essential consideration for many organizations. It also allows you to perform a postgres upgrade with very minimal effort. In our previous posts, we discussed various methods and tools that can help us perform a PostgreSQL upgrade – (1) pg_dumpall, (2) pg_dump and ... Read More

Feed: Planet MySQL; Author: Ahmed Bouchefra; In this tutorial, you will learn about MySQL, how to create SQL databases, tables and various data types. Prerequisites You need to have MySQL server installed on your machine along with the MySQL client. Create DATABASE | Create schema in MySQL You can create a database in MySQL using the SQL instruction CREATE DATABASE . Open a new terminal and invoke the mysql client using the following command: $ mysql -u root -p Enter the password for your MySQL server when prompted. You can now execute SQL statments. Let's see an example of creating ... Read More

Feed: SAS Blogs. Author: Chris Hemedinger. This blog post could be subtitled "To Catch a Thief" or maybe "Go ahead. Steal this blog. I dare you."* That's because I've used this technique several times to catch and report other web sites who lift the blog content from blogs.sas.com and present it as their own. Syndicating blog content is an honorable practice, made possible by RSS feeds that virtually every blog platform supports. With syndicated feeds, your blog content can appear on someone else's site, but this always includes attribution and a link back to the original source. However, if you ... Read More

Feed: Neo4j Graph Database Platform. Author: Jocelyn Hoppa. Editor’s Note: This presentation was given by Wren Chan and Sidharth Goyal at GraphConnect New York in October 2017.Presentation SummaryUBS set out to create a real-time data lineage tool in response to the new BCBS 239 regulations, which developed new risk-reporting requirements for financial institutions. This new data governance platform is called the Group Data Dictionary, which tracks data from its origins and how it moves over time, which is an important function to help ensure data integrity.The UBS team originally built their governance platform in Oracle, but began the transition to ... Read More

Feed: Redis Labs. Author: Priya Balakrishnan. Last week at our annual Redis conference, the biggest topic of discussion was multi-model Redis. Just one year ago, Redis Labs’ founders, Ofer and Yiftach, talked about our support for multiple data models. At the time, we introduced Redis Streams, RedisGraph and extended support for Active-Active with tunable consistency models. Last week, we kicked things up a notch with the announcement of new Redis Modules that add significant capabilities to support time series data, artificial intelligence models and RedisGears, an in database programmability framework that connects all the models on the backend.  Our goal ... Read More

Feed: Cloud Data Transformation Software | Matillion. Author: Ed Thompson, CTO; The latest release of Matillion, version 1.38, includes a whole host of new components, new features, and enhancements to make Matillion better than ever before! Upgrade your instance today. For More information on how to upgrade, check out our blog on Best Practices for Updating your Matillion Instance.All Matillion ProductsNew ComponentsVersion 1.38 of Matillion introduces a new data staging component for all Matillion products:Sharepoint Query componentNew FeaturesWe are happy to introduce a host of new features that will make your user experience of Matillion even better!Project and Environment UI ... Read More

Feed: Planet MySQL; Author: Dave Stokes; The last blog entry was very popular and there were lots of requests for some introductory information on the spatial data types.  Well Known Text Or Binary I am going to use the GEOMETRY data type over POINT, LINESTRING, or POLYGON as it can store any of those three while the other three can only contain data matching their name (so POINT can holds only point data, etc.). The values are stored in an internal geometry format but it takes wither WKT or WKB formatted data.Those are Well-Known Text (WKT) or Well-Known Binary (WKB) ... Read More

Feed: Redis Labs. Author: Pieter Cailliau. Introduction Today we are happy to announce a preview version of RedisAI, in collaboration with Tensorwerk. RedisAI is a Redis module for serving tensors and executing deep learning models. In this blog post, we will walk you through the capabilities of this new module, what it enables and why we believe it’s a game changer for machine learning and deep learning (ML/DL) models. RedisAI came to light for two core reasons. First, because moving your data to a host that executes your artificial intelligence (AI) model is expensive, and every millisecond counts in today’s ... Read More