Tag: INDEX

Feed: R-bloggers. Author: statcompute. After wrapping up the function batch_woe() today with the purpose to allow users to apply WoE transformations to many independent variables simultaneously, I have completed the development of major functions in the MOB package that can be usable for the model development in a production setting. The function batch_woe() basically is the wrapper around cal_woe() and has two input parameters. The “data” parameter is the data frame that we would deploy binning outcomes and the “slst” parameter is the list of multiple binning specification tables that is either the direct output from the function batch_bin or ... Read More

Feed: Blog – ArangoDB. Author: Christopher Woodward. When looking for a solution for your project, it is important to understand what makes each technology unique, what sets it apart. With ArangoDB that is its native multi-model approach including full graph database capabilities and I am going to explain the fundamental pieces of what that means. Using ArangoDB as a Graph Database If you are already familiar with the graph database concept, then you know that a graph consists of vertices (or nodes) connected via edges. Graph databases usually store edges connected to vertices directly at the vertex object. In ArangoDB ... Read More

Feed: Planet PostgreSQL. In the famous fairy tale the hedgehog wins the race against the hare because he uses his brain to outwit the much faster hare: Brain beats muscle. But is that always the case? And what if we combine the two virtues?The case at hand: Screening large sets of molecules for chemical simliarity. Since (sub)graph isomorphism searching faces some mathematical challenges because of nonpolynomial O - even if you can use a specialized index, like pgchem::tigress does - fast similarity searching based on binary fingerprints has gained popularity in recent years. I was tasked with evaluating a solution ... Read More

Feed: Redis Labs. Author: Keren Ouaknine. Background RediSearch is a distributed full-text search and aggregation engine on the top of Redis, allows users to execute complex search queries on their Redis dataset in an extremely fast manner. The unique architecture of RediSearch (implemented as a Redis module, written in C and built from the ground up on modern and optimized data-structures) allows it to be a true alternative to other search engines in the market when using it as a stand alone search engine for indexing and retrieval searchable data.When we first launched RediSearch we benchmarked it against popular search ... Read More

Feed: Planet MySQL; Author: Shahid shaikh; We all love Ajax, don’t we? And there is an obvious reason. Ajax is great for user experience. In this tutorial, I am going to build an application using Node.js that will let the user upload files using Ajax instead of conventional upload that requires a browser refresh action to see the change. LIVE DEMO DOWNLOADRecommended read : File uploads using node.js Our application : I am going to develop the same application as I have done in the last tutorial with some additional code changes which make it asynchronous or Ajax. #1 : ... Read More

Feed: Planet PostgreSQL. On 2nd of April 2019, Alvaro Herrera committed patch: Report progress of CREATE INDEX operations     This uses the progress reporting infrastructure added by , adding support for CREATE INDEX and CREATE INDEX CONCURRENTLY.   There are two pieces to this: one is index-AM-agnostic, and the other is AM-specific. The latter is fairly elaborate for btrees, including reportage for parallel index builds and the separate phases that btree index creation uses; other index AMs, which are much simpler in their building procedures, have simplistic reporting only, but that seems sufficient, at least for non-concurrent builds.   ... Read More

Feed: Planet PostgreSQL. Have you ever heard about cursors in PostgreSQL or in SQL in general? If not you should definitely read this article in depth and learn how to reduce memory consumption in PostgreSQL easily. Cursors have been around for many years and are in my judgement one of the most underappreciated feature of all times. Therefore it makes sense to take a closer look at cursors and see what they can be used for.The purpose of a cursor in PostgreSQLConsider the following example: test=# CREATE TABLE t_large (id int); CREATE TABLE test=# INSERT INTO t_large SELECT * FROM ... Read More

Feed: R-bloggers. Author: Rstats on Julia Silge. Since 2017 I have been an instructor for DataCamp, the VC-backed online data science education platform. What this means is that I am not an employee, but I have developed content for the company as a contractor. I have two courses there, one on text mining and one on practical supervised machine learning. About two weeks ago, DataCamp published a blog post outlining an incident of sexual misconduct at the company. The post was published one day after a group of over 100 instructors sent a letter to DataCamp saying that the way ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . For every timeless adage there is at least one mistaken thought that can become 'truth' simply by virtue of being repeated. Oracle is no exception to this phenomenon especially when single-column Primary Key indexes are involved. The conventional 'wisdom' discounts the use of histograms on such an index as unnecessary, and this presumes that the primary key has no 'holes' and has a continuous range of data. Very often reality flies in the face of that assumption; even with triggers and sequences, it is highly unlikely to find an unbroken, gap-free data ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Rosaria Silipo. I often tell my younger coworkers that the most boring way to start a blog post is, “This post is about …” — unless of course you rap it!   Yo! This post is about generating free text with a deep learning network particularly it is aboutBrick X6, Phey, cabe, make you feel soom the way (I smoke good!) I probably make (What?) More money in six months, Than what’s in your papa’s safe (I’m serious) Look like I robbed a bank (Okay Okay) I set it off like ... Read More