Tag: constraints

Feed: R-bloggers. Author: R on Notes of a Dabbler. Pyomo is a python based open-source package for modeling optimization problems. It makes it easy to represent optimization problems and can send it to different solvers (both open-source and commercial) to solve the problem and return the results in python. The advantage of pyomo compared to commercial software such as GAMS and AMPL is the ability to code using standard python syntax (with some modifications for pyomo constructs). Another open source package for modeling optimization problems is JuMP in Julia language.My goal in this blog is to see how far I ... Read More

Feed: Featured Blog Posts - AnalyticBridge. Author: Elise Devaux. In a general sense, synthetic data is information that is artificially generated, as opposed to collected from the real-world. But it’s important to note that synthetic data is used for a variety of purposes. As a result, there are several types of synthetic data with different properties depending on the use-cases. For instance, one scenario in which companies use synthetic data is the training of AI/ML models. Real-world data is sometimes expensive to collect, or simply hard to come by. If you take for instance self-driving vehicles, the development of software for autonomous ... Read More

Feed: Planet PostgreSQL. SQL and especially PostgreSQL provide a nice set of general purpose data types you can use to model your data. However, what if you want to store fewer generic data? What if you want to have more advanced server side check constraints? The way to do that in SQL and in PostgreSQL in particular is to use CREATE DOMAIN.This blog will show you how to create useful new data types which are commonly needed in many applications.CREATE DOMAIN: color codesThe first example is about color codes. As you can see not every string is a valid color ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; One of the most common errors encountered in the MySQL world at large is the infamous Error 1040: ERROR 1040 (00000): Too many connectionsERROR 1040 (00000): Too many connectionsWhat this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections.  Until connections are closed, no new connection will be accepted by the server.I’d like to discuss some practical advice for preventing this situation, or if you find yourself in it, how to recover.Accurately Tune the max_connections ParameterThis setting defines the maximum number of connections that ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; The TPCC workload "mystery" exposed in the following post was already clarified the last year, and I've presented explanations about the observed problem during PerconaLIVE-2019. But slides are slides, while article is article ;-)) So, I decided to take a time to write a few lines more about, to keep this post as a reference for further TPCC investigations.. The "mystery" is related to observed scalability issues on MySQL 8.0 under the given TPCC workload -- just that on the old aged DBT-2 workload (TPCC variation) I was getting much higher TPS when running ... Read More

Feed: Microsoft Azure Blog. Author: Michael Flanakin. Whether you're a new student, thriving startup, or the largest enterprise, you have financial constraints and you need to know what you're spending, where, and how to plan for the future. Nobody wants a surprise when it comes to the bill, and this is where Azure Cost Management + Billing comes in. We're always looking for ways to learn more about your challenges and how Azure Cost Management + Billing can help you better understand where you're accruing costs in the cloud, identify and prevent bad spending patterns, and optimize costs to empower ... Read More

Feed: Domo Blog. Author: Josh James. Some situations we encounter in life are scarier than others. COVID-19 has been one of those situations for me. Over the course of a distressing, three-day period in April, eight family members tested positive for the coronavirus. They’re all fine now, but for about 72 hours, I was worried sick. In a perfect world, we could all ride this crisis out by simply pushing the pause button on the responsibilities we’re accustomed to dealing with. But unfortunately, we can’t. We have to work—not only for our own financial wellbeing, but because the work many ... Read More

Feed: Actian. Author: Sampa Choudhuri. Artificial Intelligence (AI) is the core of the next wave of IT systems, and it is time to get ready. The past year has seen tremendous growth in the adoption of artificial intelligence systems to help companies improve operational insights and provide enhanced customer service experiences.  If you aren’t leveraging AI to support your business already, you should at least be investigating the possibilities.    Here are some steps you can take to establish a solid data foundation to support high-performance AIAdd more Data Sources Artificial Intelligence systems run on data.  They have tremendous ability to ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Ghida Ibrahim. Given the scale of its impact and the kind of alteration that it brought into our lives, COVID19 is one of the most unprecedented crises of our times. Although it is not the only pandemic that humanity has been through, COVID19 is occurring in the time of the fourth industrial revolution where everyone and everything is one click way, and where the excess of data and computing has allowed machines to be more intelligent than ever. In the age of deep tech and data, data science is definitely at ... Read More

Feed: R-bloggers. Author: R on OSM. In our last post, we took a quick look at building a portfolio based on the historical averages method for setting return expectations. Beginning in 1987, we used the first five years of monthly return data to simulate a thousand possible portfolio weights, found the average weights that met our risk-return criteria, and then tested that weighting scheme on two five-year cycles in the future. At the end of the post, we outlined the next steps for analysis among which performance attribution and different rebalancing schemes were but a few.For this post, we’ll begin ... Read More