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

Improved Functionality in dbForge Studio for SQL Server v5.5

By   /  August 9, 2017  /  Data Daily | Data News, Data Education, Database News, Database News, Articles, & Education, Education Resources For Use & Management of Data  /  No Comments

by Angela Guess A new press release reports, “Devart, a recognized vendor of professional database management software for developers and DBAs, announced the release of dbForge Studio for SQL Server v5.5 with such significant features as Executed SQL Statements History, Support for Surround SCM predefined template, SQL Server 2016 Service Pack 1 (SP1) and SQL […]

Read More →
Latest

SQL Support for UML Associations

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

Click to learn more about author Michael Blaha. The UML (Unified Modeling Language) is a popular Data Modeling notation that arose from the programming community, but it is also applicable to databases. The UML has a variety of models, one of which is the class model. The UML class model is essentially just a dialect […]

Read More →
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 →