Academic name for associative array when used to pair column names with data
Date: Tue, 18 Mar 2014 19:47:26 -0700 (PDT)
Message-ID: <aeb0ea7b-3c6c-4003-9663-0a5d8f285a26_at_googlegroups.com>
I read Chris Date's book "An Introduction to Database Systems" where he uses the term "tuple" to describe what is commonly called a "row" in a database. What would the proper term be for an associative array of the column names paired with the data from a particular row (otherwise known as a hash)?
For example in Perl:
my _at_column_names = qw/color season sound/;
my _at_data = (
[ qw/blue fall loud/ ],
[ qw/red spring soft/ ],
[ qw/orange winter pin_drop/ ],
);
foreach my $tuple ( _at_data ) {
my %name_needed
What would be the proper name for the variable %name_needed? By proper name, I mean something along the lines of "tuple" rather than "hash" or "associative array" .
Mathematically it would look something like:
column_names: { a, b, c, d, e }
data:
{
{ 1x1, 1x2, 1x3, 1x4, 1x5 },
{ 2x1, 2x2, 2x3, 2x4, 2x5 },
{ 3x1, 3x2, 3x3, 3x4, 3x5 },
{ 4x1, 4x2, 4x3, 4x4, 4x5 },
{ 5x1, 5x2, 5x3, 5x4, 5x5 }
}
Specifically, what would you call a given pairing of the column names with a tuple from the data, e.g.
{ { a, 2x1 }, { b, 2x2 }, { c, 2x3 }, { d, 2x4 }, { e, 2x5 } }
Thanks ;-) Received on Wed Mar 19 2014 - 03:47:26 CET