Data Science and Databases

Showing 1-8 of 96 results

Machines and Trust: How to Mitigate AI Bias

by Michael McKenna

Unwanted AI bias is already a widespread problem. Machine learning models can replicate or exacerbate existing biases, often in ways that are not detected until release. So what can be done about it?

13 minute readContinue Reading

Caching and Connection Handling in .NET: An Aspect-Oriented Programming Tutorial

by Marko Pađen

We reduce boilerplate with common OOP patterns, but often, the code overhead of using patterns is almost the same—if not bigger—than if we’d used boilerplate code in the first place. In aspect-oriented programming tutorial, we implement two functions (aspects) that allow for generic database connection management and caching. These allow us to mark methods that, when called, will automatically have the required functionally present in through IL weaving.

12 minute readContinue Reading

Oracle to SQL Server and SQL Server to Oracle Migration Guide

by Leonid Draginsky

Migrating in either direction between Microsoft SQL Server and Oracle Database? There are some significant pitfalls to be aware of...

11 minute readContinue Reading

Accelerate with BERT: NLP Optimization Models

by Jesse Moore

For a successful natural language processing project, collecting and preparing data, building resilient pipelines, and getting "model ready" can easily take months of effort even with the most talented engineers. But what if we could reduce the data required to a fraction? In this article, we’ll cover how transfer learning is making world-class models open source and introduce BERT (bidirectional encoder representations from transformers). BERT is the most powerful NLP “tool” to date. We’ll explore how it works and why it will change the way companies execute NLP projects.

6 minute readContinue Reading

How to Build a Role-based API with Firebase Authentication

by Joaquin Cid

Nearly every app requires an authorization system on top of an authentication system. We often need a fine-grained permissions model to allow only specific users to access certain resources while simultaneously restricting access for everyone else. In this tutorial, Toptal Freelance Firebase Developer Joaquin Cid teaches how to build just such a system. Called a role-based authentication, we’ll learn how to implement this system in an API using Node.js and Firebase.

13 minute readContinue Reading

Make Your App Profitable, Part 2 – Harnessing the Mobile Funnel

by Matthew Knippen

Subscription-based apps need a special approach when it comes to analytics. Learn how a variation on the traditional sales funnel helps you work with LTV, subscriber retention, and churn rates to make your app better—and more profitable.

10 minute readContinue Reading

An Intro to SQL Window Functions

by Neal Barnett

SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like "group by," have access to individual rows and can even add some of their attributes into the result set. In this article, Toptal Freelance SQL Developer Neal Barnett explains the benefits of SQL functions, describes when you’d use them, and gives you real examples to help with the concepts.

6 minute readContinue Reading

When Does it Make Sense to Use Google BigQuery?

by Maksym Goroshkevych

What do you do when you come across a dataset that’s simply too big to allow fast queries? Google BigQuery could be part of the solution, though it’s no silver bullet. In this article, Toptal Java Developer Maksym Goroshkevych explains how BigQuery can drastically improve query performance, and when you should and should not use it.

10 minute readContinue Reading

Join the Toptal® community.