Loading...
You are here:  Home  >  'SQL'
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 →
Latest

NuoDB 2.6 Delivers Elastic SQL Database for Scaling On-Demand Cloud Applications

By   /  January 18, 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 According to a new press release, “NuoDB, the elastic SQL database company for cloud applications, today released NuoDB 2.6 to enable customers to elastically scale out their modern cloud applications as part of their digital transformation efforts. With formal support for active-active database deployments across Amazon Web Services (AWS) Availability Zones, NuoDB […]

Read More →
Latest

New Survey Reveals True Picture of DevOps for the Database

By   /  December 26, 2016  /  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, “DevOps is moving into the mainstream – that’s a major finding from a new survey by Redgate Software among SQL Server professionals. The State of Database DevOps Survey involved over 1,000 people from companies across the globe, and the respondents included database administrators, IT directors and developers. […]

Read More →
Latest

A Review of Different Database Types: Relational versus Non-Relational

By   /  December 21, 2016  /  Big Data Articles, Big Data News, Articles, & Education, Conference and Webinar Communities, Data Articles | Data Science, Business Intelligence, & More, Data Conference Communities - Learn, Share, Review, Data Education, Database Articles, Database News, Articles, & Education, Education Resources For Use & Management of Data, Enterprise Data World Conference Community  /  No Comments

Relational databases are also called Relational Database Management Systems (RDBMS) or SQL databases. Historically, the most popular of these have been Microsoft SQL Server, Oracle Database, MySQL, and IBM DB2. The RDBMS’s are used mostly in large enterprise scenarios, with the exception of MySQL, which is also used to store data for Web applications. All […]

Read More →
Latest

Be Careful with Derived Data

By   /  December 5, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  2 Comments

Click here to learn more about author Michael Blaha. We often perform database reverse engineering as part of our consulting work. We have found that it’s common for databases to contain derived data. Derived data is data that can be computed from other base data. Often, the storing of derived data is a mistake and […]

Read More →