Tag: INDEX

Feed: Featured Blog Posts - Data Science Central. Author: Vincent Granville. This resource is part of a series on specific topics related to data science: regression, clustering, neural networks, deep learning, decision trees, ensembles, correlation, Python, R, Tensorflow, SVM, data reduction, feature selection, experimental design, cross-validation, model fitting, and many more. To keep receiving these articles, sign up on DSC. 29 Statistical Concepts Explained in Simple English Self-Selection Bias Semantic Differential Scale: Definition, Examples Semi Interquartile Range / Quartile Deviation Sensitivity vs Specificity and Predictive Value Sequential Sampling: Definition, Advantages/Disadvantages Serial Correlation / Autocorrelation: Definition, Tests Shapes of Distributions: Definitions, Examples ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Vincent Granville. Monday newsletter published by Data Science Central. Previous editions can be found here. The contribution flagged with a + is our selection for the picture of the week. To subscribe, follow this link.   Featured Resources and Technical Contributions  Free Book: Statistics: New Foundations, Toolbox, and ML Recipes  30 Statistical Concepts Explained in Simple English - Part 15  Python Software for Clustering  Deep learning Data Sets for Every Data Scientist  The Divergence Index: A new polarization measure for ordinal categorical variables Comparing Classifiers: Decision Trees, K-NN & Naive Bayes  Unsupervised, k-means Clustering and ... Read More

Feed: R-bloggers. Author: Topics in R. A new version of my package packagefinder is available on CRAN. It has a lot of new features and comes with a YouTube tutorial. What is packagefinder? How does it benefit me? Currently, there are more than 14,000 R package contributions on CRAN providing R with an unparalleled wealth of features. The downside of the large and increasing amount of packages is that it becomes increasingly difficult to find the right tools to tackle a specific problem. Unfortunately, CRAN does not provide any good search functionality. packagefinder is designed to search for CRAN packages ... Read More

Feed: Oracle Blogs | Oracle Blogs. When Java Champion Mani Sarkar talks about technology, you think, “I’ll have what he’s having.” The prolific writer, speaker, and Java and JVM-based developer is a vibrant member of the London Java Community (LJC) as well as a passionate backer of open source projects such as Adopt OpenJDK. Although his day job focuses on strengthening teams, his interests include improving code quality and performance, implementing DevOps and machine learning, and more. Talking to Sarkar about productivity means tapping into the mother lode. Here is just a sampling of the many ways he suggests improving your Java code and ... Read More

Feed: Oracle Blogs | Oracle Blogs. Last week, Oracle was named to Corporate Responsibility Magazine’s 2019 100 Best Corporate Citizens list, which recognizes outstanding environmental, social and governance (ESG) transparency and performance amongst the 1,000 largest US public companies. Oracle ranked #41, up from #97 in 2018—a testament to the tremendous progress we have made in our global corporate citizenship efforts in the past year. “Good corporate citizenship means being intentional and thoughtful about the value we generate as a company—not only for our shareholders, but also for our people, our planet, and future generations,” says Oracle CEO Safra Catz ... Read More

Feed: Planet PostgreSQL. PREVIOUS POST At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is YES. The true meaning of hypothetical is imaginary but not real. We can try creating indexes that are imaginary for the PostgreSQL optimizer which don’t exist in reality. Let’s look at some detailed examples. How are hypothetical indexes helpful? The execution time of an SQL in most of the relational databases depends on the cost of the execution ... Read More

Feed: Planet MySQL; Author: HowToForge; Phorum is a PHP and MySQL based Open Source forum software. In this guide, we will guide you step-by-step through the Phorum installation process on the Fedora 30 operating system using Nginx as the web server, MariaDB as the database, and acme.sh and Let's Encrypt for HTTPS. Requirements Requirements for running Phorum are: Nginx PHP version 5.2 or greater MySQL version 5.0 or greater Prerequisites Fedora 30 operating system. A non-root user with sudo privileges. Initial steps Check your Fedora system version: cat /etc/fedora-release# Fedora release 30 (Thirty) Set up the timezone: timedatectl list-timezonessudo timedatectl set-timezone 'Region/City' Update your operating system packages (software). This is an important first step ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; C++ Array Tutorial With Example | Arrays in C++ Explained is today’s topic. Sometimes when writing code, we need to store a lot of data for any calculation, and for that in the usual way, we have to take that number of variables. Think once, is it logically possible if you are asked to give a summation of 10000 numbers and you have to take 10000 variable? The answer is obviously no. To overcome this situation, we have a concept Array. Content Overview C++ Array Tutorial With Example An array is the collection of ... Read More

Feed: Planet MySQL; Author: Federico Razzoli; A different type of index, for a different type of searchOne of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return the results relative to a certain tranche. The problem: OFFSET From a strictly functional point of view, pagination is not really a challenge. The syntax may vary a lot depending on the DBMS, but with MySQL and PostgreSQL you can do something like this: ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Ludovico Pinzari. In the statistical literature, for ordinal types of data, are known lots of indicators to measure the degree of the polarization phenomenon. Typically, many of the widely used measures of distributional variability are defined as a function of a reference point, which in some “sense” could be considered representative for the entire population. This function indicates how much all the values differ from the point that is considered “typical”. Of all measures of variability, the variance is a well-known example that use the mean as a reference point. However, ... Read More