Tag: task

Feed: Planet MySQL; Author: Michael McLaughlin; There are many ways to test and edit files. A lot of developers only use their favorite Integrated Developer Environment (IDE) but I find testing script files within the scope of a pipelined set of scripts much faster. The ability to edit a script from within the MySQL Command-Line Interface (CLI) or MySQL Shell would be nice but unfortunately, doesn’t exist. Here’s my quick edit and test script technique from your present working directory: Assume you create a task.sql test file, like: SELECT user() AS "Current User"G You can edit with vi or emac ... Read More

Feed: R-bloggers. Author: dtholmes@mail.ubc.ca. [This article was first published on The Lab-R-torian, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. Introduction This is the first of what I am hoping are a number of posts on different machine learning classifiers. The subject matter is not lab medicine but the methodology applies to any similar project. For example, maybe you want to classify the text of a general internal medicine consult into its subspecialty ... Read More

Feed: R-bloggers. Author: George Mount. [This article was first published on George J. Mount, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. When many hear “data analytics” these days, they think of graphical user interface (GUI)-driven business intelligence (e.g. Tableau), data warehousing (e.g. Snowflake), or data preparation (e.g. Alteryx) platforms. These tools have their place (some more than others) in the analytics stack. But rather than focus on these tools in my book ... Read More

Feed: Planet PostgreSQL. A hierarchical query is built upon parent-child relationship, the relationship exist in the same table or view. The relationship dictates that each child can have one parent while a parent can have many children. Hierarchical query is a SQL query that handles data of hierarchical model i.e. an organisation structure where every employee has one manager and one manager who is also an employee can have many employees in his reporting, another example is a family tree where one person can only have one parent while a person can have many children. There are many examples where ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Olha Zhydik. Limitations on physical interactions throughout the world have reshaped our lives and habits. And while the pandemic has been disrupting the majority of industries, e-commerce has been thriving. This article covers how reinforcement learning for dynamic pricing helps retailers refine their pricing strategies to increase profitability and boost customer engagement and loyalty.  In dynamic pricing, we want an agent to set optimal prices based on market conditions. In terms of RL concepts, actions are all of the possible prices and states, market conditions, except for the current price of the product or service ... Read More

Feed: CIO. Author: . Already in 2021, we’ve seen enterprise tech acquisitions in hardware, software, and services that have topped $1 billion — although so far there’s nothing to rival the two blockbuster deals announced in 2020, Salesforce.com’s $27.7 billion offer for Slack and AMD’s $35 billion bid for Xilinx, both of which have yet to close.The pace of acquisitions will increase in 2021, according to two-thirds of company executives, bankers, and other dealmakers surveyed by Morrison & Foerster last December. That’s the most optimistic forecast in almost seven years, according to the law firm.The enterprise software and services landscape ... Read More

Feed: Planet MySQL; Author: Alena Subotina; Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable. Renaming Tables Method There is a way to perform this task quite easily. In fact, MySQL version 5.5 (and later) has InnoDB Storage Engine as the default ... Read More

Feed: AWS Big Data Blog. This is a blog post co-written by Karl Platz at Isentia. In their own words, “Isentia is the leading media monitoring, intelligence and insights solution provider, helping top-performing communication teams make sense of the world’s conversations in real-time.” Isentia is a publicly listed (ASX:ISD) media monitoring and intelligence company that provides software as a service (SaaS) tools used by over 35,000 people each day across eight countries in Australia and Southeast Asia. They process data in multiple languages from 6 million sources, including websites, radio, print, broadcast, blogs, social media, and many others. Their customers ... Read More

Feed: Planet PostgreSQL. Visualizing spatial data is an important task. In this mini-tutorial, you will learn how to quickly visualize OpenStreetMap (OSM) data with PostGIS and QGIS. The idea is to get you started as fast as possible, and to make the most out of your data.Installing QGISQGIS is freely available as Open Source software and can be used free of charge. It is a powerful tool to edit and visualize spatial data which is ideally stored in a PostGIS-enabled PostgreSQL database.First, download QGIS from the official website.Once the package has been downloaded, you can simply follow the installation instructions ... Read More

Feed: AWS Architecture Blog. Scaling based on Amazon Simple Queue Service (SQS) is a commonly used design pattern. At AWS Professional Services, we have recently used a variant of this pattern to achieve highly parallel computation for larger customers. In fact, any use case with a tree-like set of entities can use this pattern. It’s useful in a workflow where all nodes between the root and leaves must be processed rapidly and in parallel. Some use cases would be database parent-child records or graph relationships. Let us explore a couple of example scenarios, both hypothetical (COVID contact tracing) and real ... Read More