Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.programming > #5908 > unrolled thread

Terminological question: What is dataset in context of SQL?

Back to article view | Back to comp.programming

Contents

  Terminological question: What is dataset in context of SQL? Victor Porton <porton@narod.ru> - 2015-09-30 23:59 +0300
    Re: Terminological question: What is dataset in context of SQL? Richard Heathfield <rjh@cpax.org.uk> - 2015-09-30 22:31 +0100
    Re: Terminological question: What is dataset in context of SQL? Mark Carroll <mtbc@bcs.org> - 2015-10-02 09:47 +0100

#5908 — Terminological question: What is dataset in context of SQL?

Terminological question:

Dataset are data from one SQL table or it is a dataset even in the case when 
we join several tables?

In other words, does the word "dataset" usually imply that we have data from 
just one table, not several tables?

-- 
Victor Porton - http://portonvictor.org

[toc] | [next] | [standalone]

#5909

On 30/09/15 21:59, Victor Porton wrote:
> Terminological question:
>
> Dataset are data from one SQL table or it is a dataset even in the case when
> we join several tables?
>
> In other words, does the word "dataset" usually imply that we have data from
> just one table, not several tables?


It depends on context. In the mainframe world, a "dataset" is either a 
file ("sequential dataset") or a collection of subfiles within one file 
("partitioned dataset"). In the Microsoft world, which is probably what 
you're asking about, "dataset" means a collection of one or more tables, 
AND any relationships between them, AND any internal working tables that 
the database uses to keep everything straight. In the computer science 
world at large, "dataset" just means "a bunch of data"!

-- 
Richard Heathfield
Email: rjh at cpax dot org dot uk
"Usenet is a strange place" - dmr 29 July 1999
Sig line 4 vacant - apply within

[toc] | [prev] | [next] | [standalone]

#5912

ram@zedat.fu-berlin.de (Stefan Ram) writes:

> Victor Porton <porton@narod.ru> 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

[toc] | [prev] | [standalone]

Back to top | Article view | comp.programming

csiph-web