Data Hero 4 U: March 2018

Saturday, March 31, 2018

RavenDB Security Review: Findings and Details

DZone Database Zone

RavenDB Security Review: Findings and Details

RavenDB Security Review: Findings and Details

In January 2018, we asked Edge Security to do a thorough review of RavenDB security and cryptography usage. We wanted to get an outside expert opinion before the RTM release to make sure that we put out a system that is robust and secured.

As an aside, I strongly recommend doing such a thing on major version releases (at least) — especially if you need an expert opinion and security is certainly one area in which you want to have things verified.

Friday, March 30, 2018

ANALYZE TABLE Is No Longer a Blocking Operation

DZone Database Zone

ANALYZE TABLE Is No Longer a Blocking Operation

ANALYZE TABLE Is No Longer a Blocking Operation

In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503) created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and table definition cache content for supported storage engines (InnoDB, TokuDB, and MyRocks).

Why Is This Important?

In short, it is now safe to run ANALYZE TABLE in production environments because it won't trigger a situation where all queries on the same table stack are in the state "Waiting for table flush." Check this post for details on how this situation can happen.

Alaska Airlines makes shopping easier with faster flow of new e-commerce features

Data Videos

#Data -Alaska Airlines makes shopping easier with faster flow of new e-commerce features

AWS re:Invent 2017 - AWS Cloud9 のご紹介: Werner Vogels 基調講演 (日本語字幕)

Data Videos

#Data -AWS re:Invent 2017 - AWS Cloud9 のご紹介: Werner Vogels 基調講演 (日本語字幕)

Big Database (Part 1): Scalability

DZone Database Zone

Big Database (Part 1): Scalability

Big Database (Part 1): Scalability

Despite multiple challenger technologies (i.e. object-oriented databases), the relational databases from Oracle, IBM, and Microsoft have prevailed supreme for over 30 years.

This dominance has, however, been increasingly challenged by a new wave of technology solutions that started with database appliances from Teradata and Nettezza driven by big data requirements. This was followed by open-source NoSQL databases including HBase and Cassandra. Development continued with NewSQL databases including VoltDB and MemSQL, and finally, although not a database, Hadoop HDFS is providing a significant competition as a potential data store.

Thursday, March 29, 2018

Typecasting in SQL Could Force Database to Not Take Into Account Index or Sort Columns

DZone Database Zone

Typecasting in SQL Could Force Database to Not Take Into Account Index or Sort Columns

Typecasting in SQL Could Force Database to Not Take Into Account Index or Sort Columns

I faced this issue while working with Redshift. But it can be found in any SQL database engine.

Redshift is known as special column database that allows running queries in a parallel way to distribution and sort key. Of course, the most widely used sort key is the date and you should be really careful with it in queries. The sort key is associated only with a specific date/time format, so converting this field to any format will cause a huge drop in performance. Redshift has to convert all stored values to new format during query execution and new converted values have no sort index, so there are no advantages of the sort key.

Wednesday, March 28, 2018

How the Dallas Zoo is able to track its elephants

Data Videos

#Data -How the Dallas Zoo is able to track its elephants

Using the ArangoDB Swagger.io Interactive API Documentation

DZone Database Zone

Using the ArangoDB Swagger.io Interactive API Documentation

Using the ArangoDB Swagger.io Interactive API Documentation

ArangoDB can bundle its regular API documentation in Swagger.IO API description format. You can browse and explore it interactively via the ArangoDB web interface.

Working With the Swagger.io API Tool

Now you've loaded the Swagger.io API documentation, let's play with it. We're choosing a route that accepts a simple JSON post document. Executing a simple AQL query does so.

Tuesday, March 27, 2018

Introducing Azure IoT Central

Data Videos

#Data -Introducing Azure IoT Central

Scheduling Meetings With Neo4j

DZone Database Zone

Scheduling Meetings With Neo4j

Scheduling Meetings With Neo4j

One of the symptoms of any fast-growing company is the lack of available meeting rooms. The average office worker gets immense satisfaction to their otherwise mundane workday when they get to kick someone else out of the meeting room they booked. Of course, that joy can be cut short (along with their career) once realizing some unnoticed VIP was unceremoniously kicked out. It's not a super exciting use case, but today, I'm going to show you how to use Neo4j to perform some scheduling gymnastics.

Let's start with what the data model looks like:

How to Save One Million Dollars on Databases

DZone Database Zone

How to Save One Million Dollars on Databases

How to Save One Million Dollars on Databases

Let’s talk databases. Why do we need databases rather than good old files? How are files inferior to databases, or rather, how are databases superior to files?

The answer is obvious. Databases are a more advantageously structured storage system. They allow transactions, queries, etc. That’s why we love databases. But sometimes we hate them, as well, because databases can cause headaches.

Start Using Co-Management Today When You #FlipTheSwitch

Data Videos

#Data -Start Using Co-Management Today When You #FlipTheSwitch

Monday, March 26, 2018

Marching Into Databases: What's Been Happening?

DZone Database Zone

Marching Into Databases: What's Been Happening?

Marching Into Databases: What's Been Happening?

It's time for another Database Zone monthly round-up! Last time, we focused on database DevOps, looking into how to make DevOps work for your database solution, how to integrate DevOps into your workflow, and more. In this article, we'll keep it simple and cover everything you need to know about databases from the past month, including the top database-related articles on DZone that you should check out, the top news that happened in the world of databases, DZone publications that dive deep into databases, and more. Let's get started!

Databases on DZone

These are the top five articles from the Database Zone from the past month. Check them out so you're up-to-date on the latest and greatest in database on DZone!

AWS Knowledge Center Videos: How do I create a Tape Gateway?

Data Videos

#Data -AWS Knowledge Center Videos: How do I create a Tape Gateway?

Sunday, March 25, 2018

Faster Databases Without Special GPU Technology

DZone Database Zone

Faster Databases Without Special GPU Technology

Faster Databases Without Special GPU Technology

Thanks to Pradeep Bhanot, Director of Product Marketing at Actian Corporation, for sharing his thoughts on the current state of database performance acceleration.

How are you and your company involved in databases?

Migrating to Cloud - Lessons from Netflix, Brought Up to Date

Data Videos

#Data -Migrating to Cloud - Lessons from Netflix, Brought Up to Date

Saturday, March 24, 2018

Apache Cassandra and ALLOW FILTERING

DZone Database Zone

Apache Cassandra and ALLOW FILTERING

Apache Cassandra and ALLOW FILTERING

An aspiring Cassandra engineer-apprentice was fiddling with a Cassandra cluster trying to fetch the data he needed. For a while, he was receiving strange responses from the server. But after hacking his way through the CQL, he finally received the response he was looking for. He felt so proud... For a moment. Then, out of nowhere, a senior engineer appeared next to him. She was looking at the apprentice with a mix of fear, anger, and disappointment.

"What have you done?! Have I not told you not to use ALLOW FILTERING in the queries?!"

Rio Tinto mines new frontiers of efficiency and agility in the cloud

Data Videos

#Data -Rio Tinto mines new frontiers of efficiency and agility in the cloud

Friday, March 23, 2018

FLUSH and LOCK Handling in Percona XtraDB Cluster

DZone Database Zone

FLUSH and LOCK Handling in Percona XtraDB Cluster

FLUSH and LOCK Handling in Percona XtraDB Cluster

In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling.

Introduction

Percona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time. Given this semantics, it is important to understand how Percona XtraDB Cluster executes statements regarding FLUSH and LOCK handling (that operate at node level).

Data Lakes on AWS

Data Videos

#Data -Data Lakes on AWS

Thursday, March 22, 2018

Edmunds: Event-Driven, Serverless, and Cost-Effective Enterprise Message Bus

Data Videos

#Data -Edmunds: Event-Driven, Serverless, and Cost-Effective Enterprise Message Bus

jOOQ, PostgreSQL, and Serverless: Java and Relational Data

DZone Database Zone

jOOQ, PostgreSQL, and Serverless: Java and Relational Data

jOOQ, PostgreSQL, and Serverless: Java and Relational Data

Azure PostgreSQL Service — as well MySQL Service — recently became GA, meaning many can now safely bring their databases (or create new ones) with all the benefits of a database service that easily allows provisioning, management, monitoring, scaling, back-up, and a lot more.

For developers, what really matters though is the ability to quickly spin a new PostgreSQL database instance, and quickly connect an application to it, without the need to download/install/configure PostgreSQL — although of course you can always use a local Docker image. What is really interesting in this case, of course, is that the database instance may be shared with other development team members.

Wednesday, March 21, 2018

3 Approaches to PostgreSQL Replication and Backup

DZone Database Zone

3 Approaches to PostgreSQL Replication and Backup

3 Approaches to PostgreSQL Replication and Backup

The Citus distributed database scales out PostgreSQL through sharding, replication, and query parallelization. For replication, our database as a service (by default) leverages the streaming replication logic built into Postgres.

When we talk to Citus users, we often hear questions about setting up Postgres high availability (HA) clusters and managing backups. How do you handle replication and machine failures? What challenges do you run into when setting up Postgres HA?

Introduction to Amazon S3

Data Videos

#Data -Introduction to Amazon S3

Instrumenting Your Node/Express Application: Viewing Your Data

DZone Database Zone

Instrumenting Your Node/Express Application: Viewing Your Data

Instrumenting Your Node/Express Application: Viewing Your Data

This post is the follow-up to Instrumenting Your Node/Express Application. Here we will begin to explore some of the data that is being stored in InfluxDB and build out a dashboard in Chronograf. If you haven't had a chance yet to begin instrumenting your Node.js applications, I recommend taking a look at my previous post to provide some context.

When I last left off, we had some data being collected and stored in InfluxDB, as we could see from querying the database:

Gaming studio learns what players want and delivers quickly with the cloud

Data Videos

#Data -Gaming studio learns what players want and delivers quickly with the cloud

Tuesday, March 20, 2018

AWS Australia & New Zealand - Meet our Professional Services Team

Data Videos

#Data -AWS Australia & New Zealand - Meet our Professional Services Team

Query Monitoring and the GDPR

DZone Database Zone

Query Monitoring and the GDPR

Query Monitoring and the GDPR

I’ve been reading the General Data Protection Regulation (GDPR) and discussing the ramifications of the beginning of enforcement with lots of people. The implications of it all are fascinating. The real serious issues remain primarily a business problem, with business defined solutions. However, there are technology issues that we need to think about. For example, performance metrics are going to be impacted by the GDPR.

Private Data and Monitoring Queries

First and foremost, let me say something I’ve said before. The vast majority of the focus around GDPR has to come from your business. Second, the bulk of your work and focus must be on ensuring core functionality in support of the GDPR. Third, the attack vectors and leaks for GDPR are not going to primarily be around something like monitoring. However, this is yet another place where you could be collecting private information that, in theory (because the lawyers have yet to speak), could be a location you need to deal with when addressing the requirement of the GDPR and related regulations.

Monday, March 19, 2018

AWS Knowledge Center Videos: How do I create a file gateway using AWS Storage Gateway?

Data Videos

#Data -AWS Knowledge Center Videos: How do I create a file gateway using AWS Storage Gateway?

Yelp: Reverse-Geocoding Businesses to Extract Detailed Location Information

DZone Database Zone

Yelp: Reverse-Geocoding Businesses to Extract Detailed Location Information

Yelp: Reverse-Geocoding Businesses to Extract Detailed Location Information

I've been playing around with the Yelp Open Dataset and wanted to extract more detailed location information for each business.

This is an example of the JSON representation of one business:

Sunday, March 18, 2018

Is SQL Server 2017 Stable?

DZone Database Zone

Is SQL Server 2017 Stable?

Is SQL Server 2017 Stable?

There I was, talking about upgrading to SQL Server 2017 at SQL Konferenz last month. Despite the title of the talk, I was not expecting such a question. But there it was: "Is SQL Server 2017 stable enough to use?"

I stopped. I wanted to laugh. And scream. And cry. I know there are no silly questions, but this one was close. I collected my thoughts and asked for clarification.

Saturday, March 17, 2018

Top 10 SQL Dialect Emulations Implemented in jOOQ (Part 1)

DZone Database Zone

Top 10 SQL Dialect Emulations Implemented in jOOQ (Part 1)

Top 10 SQL Dialect Emulations Implemented in jOOQ (Part 1)

The SQL standard is a nice thing. But it’s a standard. And as such, while it may provide good guidelines on how to implement some SQL features, most dialects deviate from it in one way or another (sometimes drastically; cheers, MySQL).

But that doesn’t have to be a bad thing. Innovation is not driven by standards, but by individual vendors’ attempts to tackle a problem from a different perspective. And then, sometimes, the innovation becomes the standard. One example for this is Oracle’s very very interesting MATCH_RECOGNIZE feature, on which Markus Winand did an excellent presentation.

Beer matchmaker delivers innovation on tap

Data Videos

#Data -Beer matchmaker delivers innovation on tap

Friday, March 16, 2018

Tweaking RDS Database Performance and ElastiCache

DZone Database Zone

Tweaking RDS Database Performance and ElastiCache

Tweaking RDS Database Performance and ElastiCache

Tweaking Database Performance

An RDS database, or a SQL database in general, can only be scaled vertically. To scale a database vertically means to increase the resources of your database but you still have a single database. If the performance of your database becomes insufficient, you must increase the performance of the underlying hardware:

Keep in mind that you can't increase resources without limits. One of the largest RDS database instance types comes with 32 cores and 244 GiB memory. In comparison, an object store like S3 or a NoSQL-database like DynamoDB can be scaled horizontally without limits.

Cygames: Data Integration with Analytics Tools Using AWS Lambda, Amazon SQS, Amazon ECS [Japanese]

Data Videos

#Data -Cygames: Data Integration with Analytics Tools Using AWS Lambda, Amazon SQS, Amazon ECS [Japanese]

Thursday, March 15, 2018

Expressive Query Language in MongoDB 3.6

DZone Database Zone

Expressive Query Language in MongoDB 3.6

Expressive Query Language in MongoDB 3.6

MongoDB 3.6 turned out to be a major release, and brings in powerful features for MongoDB. This release is one step closer to the core mission at MongoDB to "make developers more productive."

With the release of MongoDB 3.6, fully expressive array updates are now supported. This feature was one of the most voted-on features and was also one of the most popular questions asked about on StackOverflow.

Catching up on Power BI updates (Tooltips, Hololens and more)

Data Videos

#Data -Catching up on Power BI updates (Tooltips, Hololens and more)

AWS Support and Trainline

Data Videos

#Data -AWS Support and Trainline

Wednesday, March 14, 2018

TRIADB: Associative Semiotic Hypergraph Database Framework

DZone Database Zone

TRIADB: Associative Semiotic Hypergraph Database Framework

TRIADB: Associative Semiotic Hypergraph Database Framework

TRIADB is a multi-perspective database framework based on unique and valuable, associative, semiotic, hypergraph technology and implemented on top of popular DBMSs. It is an add-on middleware with two parts: one part closely coupled with the physical layer of a data store and another more generic command line interface, closer to the application layer.

At a Glance

TRIADB is an innovative, multi-perspective database framework. It is a middleware that sits on top of suitable NoSQL/SQL data stores and enables them to easily perform integration, correlation, aggregation, and hypergraph exploration of multiple data resources. With TRIADB, you can turn a simple key-value store to a multi-model database or enhance the existing functionality of a graph database. TRIADB is founded on the principles of R3DM/S3DM associative, semiotic, and hypergraph technology pioneered by Dr. Athanassios I. Hatzis, the founder of HEALIS.

What’s New with AWS – Week of March 5, 2018

Data Videos

#Data -What’s New with AWS – Week of March 5, 2018

This Week in Neo4j: JavaScript CRUD Apps, Personalized Recommendation Engines, Graph Theory Tutorial

DZone Database Zone

This Week in Neo4j: JavaScript CRUD Apps, Personalized Recommendation Engines, Graph Theory Tutorial

This Week in Neo4j: JavaScript CRUD Apps, Personalized Recommendation Engines, Graph Theory Tutorial

Welcome to this week in Neo4j, where we round up what's been happening in the world of graph databases in the last seven days.

This week, we've got real-time food and event recommendation engines, a JavaScript OGM, a Neo4j Operational Dashboard, and more!

Tuesday, March 13, 2018

Investigating Problems With Ad-Hoc Queries Using SQL Monitor

DZone Database Zone

Investigating Problems With Ad-Hoc Queries Using SQL Monitor

Investigating Problems With Ad-Hoc Queries Using SQL Monitor

There is nothing wrong with the principle of using ad-hoc queries; one can use them occasionally and perfectly legitimately. However, when ad-hoc queries run as part of a process that does database operations iteratively, row by agonizing row, they can be one of the most unremitting ways of sapping the performance of a SQL Server instance. You need a range of weapons to hunt down this sort of error problem.

Often, unfortunately, the ill-treatment occurs only intermittently and follows no distinct pattern of behavior. There will be a sudden, seemingly random burst of ad-hoc queries that put too much load on the server and cause resource contention.

Monday, March 12, 2018

Amazon Chime Launches Usage-Based Pricing

Data Videos

#Data -Amazon Chime Launches Usage-Based Pricing

MySQL 8 vs. MariaDB: Comparison of Window Functions and CTEs

DZone Database Zone

MySQL 8 vs. MariaDB: Comparison of Window Functions and CTEs

MySQL 8 vs. MariaDB: Comparison of Window Functions and CTEs

Every MySQL database programmer should learn and apply the newly added MariaDB and MySQL window functions and common table expressions (CTEs) in their daily work. Both CTEs and window functions enable easy solutions to many query challenges that in prior releases have been difficult and sometimes impossible to surmount. Mastering these features opens the door to query solutions that are more robust, that execute faster, and that are easier to maintain over time than prior solutions using older techniques.

In our last article, we compared user roles in MySQL 8 vs. MariaDB. Today, we will compare window functions and common table expressions in both databases.

JSON Schema Validation and Expressive Query Syntax in MongoDB 3.6

DZone Database Zone

JSON Schema Validation and Expressive Query Syntax in MongoDB 3.6

JSON Schema Validation and Expressive Query Syntax in MongoDB 3.6

One of MongoDB’s key strengths has always been developer empowerment: by relying on a flexible schema architecture, MongoDB makes it easier and faster for applications to move through the development stages from proof-of-concept to production and iterate over update cycles as requirements evolve.

However, as applications mature and scale, they tend to reach a stable stage where frequent schema changes are no longer critical or must be rolled out in a more controlled fashion, to prevent undesirable data from being inserted into the database. These controls are especially important when multiple applications write into the same database, or when analytics processes rely on predefined data structures to be accurate and useful.

Sunday, March 11, 2018

Instrumenting Your Node/Express Application

DZone Database Zone

Instrumenting Your Node/Express Application

Instrumenting Your Node/Express Application

This post will walk through the steps to instrument a sample nodeJS/Express application, collecting our metrics with Telegraf, and storing them with InfluxDB. A subsequent post will cover the exploration of our data and building out a dashboard with Chronograf.

Why We Instrument

One thing I learned very quickly when getting into the application development scene is that applications in a development environment always seem to be all fine and dandy, but applications in production like to have problems. When your application is available to the whole wide world, you can be sure things will go wrong at times. Instrumenting your application affords you concrete evidence of the health of your application, allowing you to make smarter decisions for its progress over time and effectively handle issues that arise in a much more efficient manner.

Saturday, March 10, 2018

How Alaska outsmarts Mother Nature in the cloud

Data Videos

#Data -How Alaska outsmarts Mother Nature in the cloud

UNLINK: Speed Up Your Applications in Redis Labs

DZone Database Zone

UNLINK: Speed Up Your Applications in Redis Labs

UNLINK: Speed Up Your Applications in Redis Labs

Redis 4.0 brought an amazing feature to the Redis ecosystem: modules. Modules are a big shift in Redis — suddenly, it is an open landscape of custom data types and full-speed computation right inside Redis. But while most of the fanfare over this release focused on Modules, the new version also introduced a super important command that is a game changer in its own right: UNLINK.

To find out if you can use the UNLINK command, run INFO from redis-cli. The response will tell you all about your server. In the first section (#Server), there should be a line called redis_version. If this value is greater than 4.0, you're ready to use the UNLINK command. All versions of Redis Enterprise 5.0+ and all new subscriptions of Redis Enterprise Cloud should be able to use the UNLINK command. Not all providers of Redis keep up-to-date, so it's good to check the version before you change any code.

Friday, March 09, 2018

Mining Application Express Data Dictionary Views: Find Unconditional Processes

DZone Database Zone

Mining Application Express Data Dictionary Views: Find Unconditional Processes

Mining Application Express Data Dictionary Views: Find Unconditional Processes

I ran into a problem yesterday on the Oracle Dev Gym (offering quizzes, workouts, and classes on Oracle technologies). A number of rows of data were incorrectly deleted. I was able to use Flashback Query to restore them (thank you, thank you, Flashback Query!). Crisis averted.

But how did this come about?

Kaplan Education and AWS Competency Partner, Datavail

Data Videos

#Data -Kaplan Education and AWS Competency Partner, Datavail

Thursday, March 08, 2018

AWS Summit London June 2017 Keynote

Data Videos

#Data -AWS Summit London June 2017 Keynote

Simplifying Existing Workflows

DZone Database Zone

Simplifying Existing Workflows

Simplifying Existing Workflows

Jason Harmon, Chief Platform Officer at Typeform, shares his thoughts on ways that developers can simplify and enhance overall productivity. Typeform is a Barcelona-based company that combines the experience of real-life conversations with the data collection capability of web forms.

For developers, productivity can remain stagnant due to a lack of integration tools and processes. And for those constantly working against deadlines, it’s common for user experience (UX) to get overlooked.

Active-Active Application Architectures with MongoDB: Part 1

DZone Database Zone

Active-Active Application Architectures with MongoDB: Part 1

Active-Active Application Architectures with MongoDB: Part 1

Introduction

Determining the best database for a modern application to be deployed across multiple data centers requires careful evaluation to accommodate a variety of complex application requirements. The database will be responsible for processing reads and writes in multiple geographies, replicating changes among them, and providing the highest possible availability, consistency, and durability guarantees. But not all technology choices are equal. For example, one database technology might provide a higher guarantee of availability while providing lower data consistency and durability guarantees than another technology. The tradeoffs made by an individual database technology will affect the behavior of the application upon which it is built.

Unfortunately, there is limited understanding among many application architects as to the specific tradeoffs made by various modern databases. The popular belief appears to be that if an application must accept writes concurrently in multiple data centers, then it needs to use a multi-master database - where multiple masters are responsible for a single copy or partition of the data. This is a misconception and it is compounded by a limited understanding of the (potentially negative) implications this choice has on application behavior.

VMware: Building VMware Cloud on AWS

Data Videos

#Data -VMware: Building VMware Cloud on AWS

Wednesday, March 07, 2018

The Ins and Outs of Becoming an Oracle DBA

DZone Database Zone

The Ins and Outs of Becoming an Oracle DBA

The Ins and Outs of Becoming an Oracle DBA

At the heart of every corporation, there is a server that holds all the necessary information that the business needs to run. Around the world, there is no business that can survive without record-keeping. From SMBs to larger corporations, they all work on the server that houses information about their clients and the orders they are handling. From basic to advanced information such as employee databases, transportation databases, and accounts, all records are housed in a single server. And none of the records get mixed up. These servers are complex data warehouses.

Preparing for a Career in Oracle Is Not Difficult

Building a career in Oracle is not difficult because there are various institutes available to provide certification courses. But Oracle database administration courses are not easy. You need good knowledge of other areas, too, like system administration, networking, hardware, and some basic knowledge of SQL and PL/SQL.

What’s New with AWS – Week of February 19, 2018

Data Videos

#Data -What’s New with AWS – Week of February 19, 2018

Tuesday, March 06, 2018

AWS for Retail Data Analytics

Data Videos

#Data -AWS for Retail Data Analytics

Exploring Azure Cosmos DB With Gremlin Graph Database

DZone Database Zone

Exploring Azure Cosmos DB With Gremlin Graph Database

Exploring Azure Cosmos DB With Gremlin Graph Database

In this article, we will learn about Azure Cosmos DB. We'll get started with creating an Azure Cosmos DB account with the Graph API. Also, we'll create a graph database and collections using Azure Portal.

Prerequisite Microsoft Azure subscription Overview

Azure Cosmos DB is Microsoft's globally distributed, multi-modal database with scale at the click of a button. Because it's multi-modal, it supports document, table, and graph values together in a single database.

Monday, March 05, 2018

How the Automation of a Benchmark Framework Keeps Pace With the Dev Cycle at InfluxData

DZone Database Zone

How the Automation of a Benchmark Framework Keeps Pace With the Dev Cycle at InfluxData

How the Automation of a Benchmark Framework Keeps Pace With the Dev Cycle at InfluxData

The team at InfluxData needed to review benchmark data on InfluxDB during their development cycle to ensure any new changes continue to improve performance. However, using the existing benchmarking framework, InfluxDB-comparison, was manual and time-consuming and not used consistently. To change this, InfluxData asked the team at Bonitoo to enhance the benchmark framework to easily incorporate new use cases, add new versions of the software quickly and easily and provide benchmark data on a cadence that works for the development (daily, weekly, monthly) cycle.

In this recorded webinar, the team from Bonitoo shares how they were able to accomplish this as well as build automation into the existing framework. In addition, they share the benchmark results generated from the framework that highlights how performant a time series database like InfluxDB is compared to the latest versions of products like MongoDB, Cassandra, Elasticsearch, and OpenTSDB.

How Tusimple Is Revolutionizing the Autonomous Commercial Trucking Company

Data Videos

#Data -How Tusimple Is Revolutionizing the Autonomous Commercial Trucking Company

Visualizing the Amazon Neptune Database With KeyLines

DZone Database Zone

Visualizing the Amazon Neptune Database With KeyLines

Visualizing the Amazon Neptune Database With KeyLines

In November 2017, Amazon launched a limited preview of Amazon Neptune, a hosted graph database service with an engine optimized for storing billions of relationships and querying the graph with milliseconds of latency. This new service lets developers focus more on their applications and less on database management.

What’s special about Neptune is that it supports two different open standards for describing and querying data:

Saturday, March 03, 2018

MySQL 8.0 vs. MariaDB: Comparison of Database Roles

DZone Database Zone

MySQL 8.0 vs. MariaDB: Comparison of Database Roles

MySQL 8.0 vs. MariaDB: Comparison of Database Roles

In our last article, we had a look at MySQL 8 and mentioned new features available with it. However, some of those features are already in MariaDB and have been for a while. We will here compare database roles in both server dialects.

The Purpose of Database Roles

It’s common for numerous users within an organization to share the same database privileges. A role bundles a number of privileges together so that the DBA can set the privileges for a group of users all at once rather than having to set each user’s privileges individually.

Friday, March 02, 2018

How to Use SQL Complete for T-SQL Code

DZone Database Zone

How to Use SQL Complete for T-SQL Code

How to Use SQL Complete for T-SQL Code

I was recently working on a project with several stored procedures, functions, and scripts in T-SQL, and I was wondering if there were tools that could help me code faster and generate code automatically.

After Googling and downloading some tools, I decided to check SQL Complete. The experience was fantastic — I could code faster, easily modify and refactor code, and check function definitions. And it generated a lot of code automatically. I reduced typo errors and synaxis errors and I could focus on the logic of the code instead of small format details that the tool could handle easily.

AWS Innovate | Build an AI-powered Twitter Bot with Python, AWS Lambda & Amazon SageMaker (Ses 2)

Data Videos

#Data -AWS Innovate | Build an AI-powered Twitter Bot with Python, AWS Lambda & Amazon SageMaker (Ses 2)

An Appreciation of UI Developers From a Database Developer

DZone Database Zone

An Appreciation of UI Developers From a Database Developer

An Appreciation of UI Developers From a Database Developer

From what I can tell, JavaScript developers write much more complicated code to handle much more challenging requirements than I do with my SQL and PL/SQL programming in the Oracle Database.

I am quite certain that JavaScript developers feel this sentiment even more strongly. People like me (veterans of multiple decades of database-centric application development) are seen as dinosaurs using ancient, uncool technologies.

Helix Case Study - Amazon Web Services (AWS)

Data Videos

#Data -Helix Case Study - Amazon Web Services (AWS)

Thursday, March 01, 2018

Properly Getting Into Jail: Counting Inmates and Other Hard Problems

DZone Database Zone

Properly Getting Into Jail: Counting Inmates and Other Hard Problems

Properly Getting Into Jail: Counting Inmates and Other Hard Problems

In prison, the notion of counting people is sacred. This is probably because the whole point of having a prison is to keep the people you put in there inside, and that means that you count inmates multiple times a day.

The dirty secret, however, is that you almost never get to that perfect occupancy number, where all the inmates that are registered to a particular block are actually in that block. In most cases, you have at least a few that are outside the block (court dates, medical issues with offsite care, visitations, outside work, etc.).

Subscribe to: Posts (Atom)