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

Say No More: Verbal Data Models

By   /  November 20, 2017  /  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  /  3 Comments

Click to learn more about author Thomas Frisendal. ”Nudge nudge, wink wink, say no more, say no more”. Says British Eric Idle in the third Monty Python’s Flying Circus episode, “How to Recognise Different Types of Trees From Quite a Long Way Away” from 1969. Indeed, it should not be necessary to say more, once […]

Read More →
Latest

Driving Greater SQL Scalability and Flexibility with Machine Learning

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

It’s time to dispel some myths surrounding SQL. That’s the message from MemSQL, a scalable real-time Data Warehouse that is designed to ingest and transform millions of events of data per day, while simultaneously analyzing billions of rows of data using standard SQL. As that description makes clear, there’s no reason to believe that there’s […]

Read More →
Latest

SAS, R, and Python for Analytics

By   /  November 1, 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

Click to learn more about author Steve Miller. I did a short consulting gig last year with a company that was building an analytic app driven largely from a web-based data repository. The data were stored as a collection of SAS data sets which “customers” would subset by uploading SAS data step and proc SQL […]

Read More →
Latest

Knowledge Maps – Structure Versus Meaning

By   /  October 18, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  4 Comments

Click to learn more about author John Singer. We are at an inflection point in the process of designing and building computerized systems.  Let’s be honest – even with the explosion of new data technologies we are still building the same unit record processing systems from the 60’s, although with a bit more sophistication than an […]

Read More →
Latest

My Last Blog: Data Models, SQL, UML, and Database Design

By   /  October 16, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, 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 to learn more about author Michael Blaha. This will be the last blog I write for DATAVERSITY® as I am dealing with health issues. I have cancer but am fortunate to be receiving excellent medical care. With treatment my prognosis is good, but this affects my free time. Hence this will be my last […]

Read More →
Latest

SQL Support for UML Generalizations

By   /  September 1, 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. This blog continues last month’s UML theme. Last month we discussed UML associations. Now we’ll discuss UML generalizations. The UML (Unified Modeling Language) is a popular modeling notation that arose from the programming community, but it is also applicable to databases. The UML has a variety of […]

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