17 March 2009

DBMS: Aggregate Data (Definitions)

"A group such as grouped data. For example, when aggregating data, we are grouping data. A common aggregate function is Avg (average). It looks at a group of data (an aggregate) and provides an average." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"Data resulting from processes that combine and summarize atomic data." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

[aggregate:] "Pertaining to a combination of multiple values." (Microsoft, "SQL Server 2012 Glossary", 2012)

"Data that is the result of applying a process to combine data elements collectively or in summary form. The SQL SELECT List does this very easily and offers quite a bit of dynamic control." (Michael M David & Lee Fesperman, "Advanced SQL Dynamic Data Modeling and Hierarchical Processing", 2013)

[aggregate operation:] "An operation on a data structure as a whole, as opposed to an operation on an individual component of the data structure" (Nell Dale & John Lewis, "Computer Science Illuminated, 6th Ed.", 2015)

[aggregated data] "Refers to data that has been scrubbed of any personally or entity identifiable information and then generally combined with similar information from other parties." (James R Kalyvas & Michael R Overly, "Big Data: A Businessand Legal Guide", 2015)

"Structured data that results from applying a process to more detailed data - data that is summarized or averaged." (Ciara Heavin & Daniel J Power, "Decision Support, Analytics, and Business Intelligence" 3rd Ed., 2017)

[data aggregate] "A collection of two or more data items that are treated as a unit." (IEEE 610.5-1990)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.