Systems | Development | Analytics | API | Testing

Video: Database Optimization

Most modern web applications are heavily reliant on persisting data with relational databases, and so it’s no surprise that a large part of application performance monitoring relates to keeping an eye on database performance to ensure that our SQL queries are as efficient as possible. With this in mind, Scout features a Database Addon module, and in this video we are going to take a closer look at what it has to offer.

How to work with databases

To start working with a MySQL, PostgreSQL, Oracle or MSSQL database, all you need to do is to select our Database connector. We have already learned from the short video on credentials that there are quite a few fields to fill in when you need to connect to a database for the first time. The data you see me enter here is merely from our test database.

The New Urgency to Transform to a Platform Business Model

The current situation has precipitated an intense acceleration of digital transformation. The future was always uncertain, but is now ever more so. Companies that run platform business models are proving to be relatively resilient during this uncertain time, and are likely to emerge stronger than ever. APIs are critical to these companies, and many traditional businesses are starting to adopt a platform strategy not only to survive, but to thrive.

Genomics analysis with Hail, BigQuery, and Dataproc

At Google Cloud, we work with organizations performing large-scale research projects. There are a few solutions we recommend to do this type of work, so that researchers can focus on what they do best—power novel treatments, personalized medicine, and advancements in pharmaceuticals.

Building a genomics analysis architecture with Hail, BigQuery, and Dataproc

We hear from our users in the scientific community that having the right technology foundation is essential. The ability to very quickly create entire clusters of genomics processing, where billing can be stopped once you have the results you need, is a powerful tool. It empowers the scientific community to spend more time doing their research and less time fighting for on-prem cluster time and configuring software.

How to Extend Your ERP

ERP systems enable businesses to bring together and manage core processes and technologies under one system. But the truth is, an out-of-the-box ERP system rarely fits a business perfectly, and even if it does, it is only temporary. A business’s challenges, needs, and strategies change and grow over time, and its tools must too. When an ERP’s functionality does not fully meet your business’s needs, it’s time to think about extending it.

How Marketers Can Drive ROI from Customer Data Platforms

As first-party customer data continues to explode, companies have struggled to make it actionable for personalization, advanced analytics, and other business purposes. As a result, customer data platforms that consolidate and activate known customer information have emerged to help companies generate ROI from their data. At present, nearly 80% of marketing organizations already have a customer data platform or are developing one.

Ritual Improves Retention With a Modern Data Stack

A brittle ETL pipeline, a mix of different code languages and degrading warehouse performance inhibited customer retention analysis. With a modern data stack, Ritual has a 95% reduction in data pipeline issues, a 75% reduction in query times, and a threefold increase in data team velocity. By empowering the business with data, the business has seen a sustained improvement in retention.