Loading...
You are here:  Home  >  'SQL'
Latest

Looker Answers Big Data Questions in an ‘Instant’

By   /  June 15, 2017  /  Big Data News, Big Data News, Articles, & Education, Data Daily | Data News, Data Education, Education Resources For Use & Management of Data  /  No Comments

by Angela Guess According to a recent press release, “Looker today announced Instant Insight, which allows anyone to instantly and securely analyze their data without waiting for help from an analyst – no coding or SQL is necessary. Instant Insight is available today to all Looker customers seeking to instantly understand their data. ‘When you’re […]

Read More →
Latest

Utilizing Multiple Data Stores and Data Models: Is Polyglot Persistence Worth It?

By   /  June 7, 2017  /  Big Data Articles, Big Data News, Articles, & Education, Data Architecture Articles, Data Architecture News, Articles, & Education, Data Articles | Data Science, Business Intelligence, & More, Data Education, Data Modeling Articles, Data Modeling News, Articles, & Education, Database Articles, Database News, Articles, & Education, Education Resources For Use & Management of Data  /  No Comments

Polyglot Persistence is a process for storing data in in the best database available, no matter the data model and data storage technology. This process is based on the understanding different data stores will handle certain types of data better than others. Polyglot Persistence is, unfortunately, not available for easy “downloading”, but must designed for […]

Read More →
Latest

Kinetica Brings GPU Acceleration with SQL to Tableau

By   /  June 6, 2017  /  Big Data News, Big Data News, Articles, & Education, Data Daily | Data News, Data Education, Education Resources For Use & Management of Data, Enterprise Information Management, Information Management News  /  No Comments

by Angela Guess A new press release states, “Kinetica, provider of the fastest GPU-accelerated database, today announced the availability of native integration with Tableau allowing users to simultaneously ingest, explore, analyze, and visualize data within milliseconds to make critical decisions and find efficiencies, lower cost, generate new revenue, and improve customer experience. ‘We are excited […]

Read More →
Latest

Data Exploration in R – Part I

By   /  May 3, 2017  /  BI / Data Science Blogs, BI / Data Science News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Database Blogs, Database News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  No Comments

With the analytics work I’ve been involved with over the last 15 years, I estimate that 70% of the effort has been devoted to data access/integration/wrangling/curation, about 20% focused on data exploration, and the remaining 10% fitting algorithms/models. SQL and the open source platforms R and Python have been primary computation platforms, and now provide […]

Read More →
Latest

Surrogate Keys: Paving the Way for Graph / NoSQL Data Models

By   /  April 3, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]

Read More →
Latest

DataScience Releases Grunion, a Patent-Pending Query Optimization Tool

By   /  March 20, 2017  /  BI / Data Science News, BI / Data Science News, Articles, & Education, Big Data News, Big Data News, Articles, & Education, Data Daily | Data News, Data Education, Education Resources For Use & Management of Data  /  No Comments

by Angela Guess A recent press release reports, “DataScience, Inc., today announced the release of Grunion, a patent-pending query optimization, translation, and federation framework built on top of Apache Calcite and integrated into Apache Spark. Designed to bridge the gap between data science and engineering teams by removing the need to manually translate code from […]

Read More →
Latest

Homicide and Violent Crime in Chicago – a First Look at the Data with R

By   /  March 1, 2017  /  BI / Data Science Blogs, BI / Data Science News, Articles, & Education, Big Data Blogs, Big Data News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Database Blogs, Database News, Articles, & Education, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click to learn more about author Steve Miller. A recent article in Atlantic highlights what had been emerging locally for over a year: Chicago suffered a disturbingly sharp spike in homicides in 2016, after a smaller but still noticeable surge in 2015. This at a time when other large cities like New York and Los Angeles […]

Read More →
Latest

Important Big Data Additions to the R Analyst’s Toolchest

By   /  February 1, 2017  /  BI / Data Science Blogs, Big Data Blogs, Big Data News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Database Blogs, Database News, Articles, & Education, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click to learn more about author Steve Miller. After my partner read my last blog, Frequencies in R — Part 2, where I used R’s data.table and dplyr packages to construct performant frequencies procedures on an in-memory 27M+ row, 30 attribute data.table, he asked if I’d compared my results with the equivalent functionality of R’s MonetDB.R package. I have […]

Read More →
Latest

Debugging Complex SQL Queries

By   /  January 25, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  2 Comments

Click to learn more about author Michael Blaha. We favor the offloading of application logic to SQL queries. Developers can save time, effort, and reduce mistakes by substituting SQL for programming code. This leads to lengthy and complex SQL that must be debugged. It is common to write a SQL query that initially fails to execute. […]

Read More →
Latest

SQL versus NoSQL Databases: A Review of Key Themes

By   /  January 19, 2017  /  Big Data Articles, Big Data News, Articles, & Education, Data Articles | Data Science, Business Intelligence, & More, Data Education, Data Modeling Articles, Data Modeling News, Articles, & Education, Database Articles, Database News, Articles, & Education, Education Resources For Use & Management of Data  /  No Comments

Non-relational databases (aka NoSQL), in many different variations, have become a popular database model for handling Big Data. They use two novel concepts, making them different from earlier, “classical” database models. The concepts having so much impact are horizontal scaling, spreading out the storage and work, and eliminating the use of “Structured Query Language” (SQL) […]

Read More →