Skip to content

SelectDistinct.io

A tech blog about data, warehousing and analytics.

Tag: Data Quality

Plural Table Name(s)

October 8, 2020 / Matt / Leave a comment
Gears of plural table name

I recently had a discussion with a colleague about the naming of tables and whether or not a plural table name makes sense. The argument for pluralizing had two interesting, competing viewpoints for which I’d like to discuss and give my reasoning why I prefer the singular form.

“A sock drawer contains socks. You wouldn’t label your sock drawer ‘sock’.”

“It’s not a ‘drawer of socks’, it is a sock drawer.”

Two competing arguments for the plurality of naming conventions.

Firstly, I’d like to point out that “socks” is inherently plural as they come in a pair; I would argue that this alone negates the entire conversation. However, I still think it’s a common struggle when naming tables and objects.

The question is: Do you look at a table from a holistic point of view, the collection as a whole, or do you look at it from the view of the records within the table, which make up the collection?

Continue reading →

Recent Posts

  • Plural Table Name(s)
  • SQL | Find Patterns In A Dataset
  • When To Use A CTE – And When Not To
  • ETL, DDL, & Self-Documenting Code Generator
  • It’s Performance Review Time!

Categories

  • Business Objects Data Services
  • DBMS
  • Dimensional Design
  • Interview Questions
  • Javascript
  • JSON
  • Python
  • Random Thoughts
  • Reporting
  • SAP
  • SQL Foo
  • SSRS
  • Window Functions

Archives

  • October 2020
  • July 2019
  • June 2019
  • May 2019
  • November 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • March 2018
  • February 2018
  • December 2017
  • October 2017
  • September 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
Delivery by Matt Komyanek