Path: csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Mark Carroll Newsgroups: comp.programming Subject: Re: Terminological question: What is dataset in context of SQL? Date: Fri, 02 Oct 2015 09:47:50 +0100 Organization: none Lines: 20 Message-ID: <87zj01sll5.fsf@ixod.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Injection-Info: mx02.eternal-september.org; posting-host="1b3e5cba9e4d07a53741e6f3d1717925"; logging-data="8793"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+JHsLmPVkMDwz3eVn2pX/5" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux) Cancel-Lock: sha1:K/HIh2NRO2kMgpDsbEUcCO5Vusg= sha1:Go/bwPeEMzXgATZpBv2LvSjADVY= Xref: csiph.com comp.programming:5912 ram@zedat.fu-berlin.de (Stefan Ram) writes: > Victor Porton writes: >>Dataset are data from one SQL table or it is a dataset even in the case when >>we join several tables? > > In SQL proper, the word »dataset« has no meaning. > > It might have a meaning in some SQL-related software or culture. > > The data from an SQL table is called »table«. > > The result of a JOIN operation also is a table (a »derived table«). Thank you, that makes sense: I took a SyBase DB / relational calculus course years ago and have worked in recent years plenty with PostgreSQL and also some Oracle and I never ran into the term "dataset" in that context. -- Mark