Which field or theory deals with table mathematics?

Click For Summary

Discussion Overview

The discussion revolves around identifying the mathematical field or theory that pertains to tables, metadata, and table functions. Participants explore whether this topic falls under group theory, linear algebra, or is more aligned with computer science and relational databases.

Discussion Character

  • Exploratory
  • Debate/contested
  • Technical explanation

Main Points Raised

  • Tunc inquires if group theory is the appropriate field for studying tables and their functions.
  • Another participant suggests that tables are merely arrangements of data without a deeper mathematical theory.
  • A participant mentions linear algebra as a relevant field for matrices and proposes a parallel for tables and analytical functions.
  • Discussion includes typical analytical table functions like aggregation and distribution, emphasizing the role of attributes and metadata in structuring tables.
  • Participants note that the concept of information content in tables could be better understood through relational databases rather than traditional mathematics.
  • Some argue that the topic leans more towards computer science, despite its mathematical underpinnings.
  • A later reply suggests that abstract algebra and concepts from group theory might have some relevance, though the connection is considered weak.

Areas of Agreement / Disagreement

Participants express differing views on whether the study of tables belongs to mathematics or computer science, with no consensus reached on a specific mathematical field that addresses the topic comprehensively.

Contextual Notes

There are unresolved assumptions regarding the definitions of terms like "information content" and the applicability of mathematical theories to the structure and function of tables.

finaquant
Messages
8
Reaction score
0
Hello all

I am a new member here. I've found this forum today by chance.

My question is, which theory or field of math deals with tables, meta data and table functions? Is it group theory?

Regards
Tunc
 
Mathematics news on Phys.org
Could you be more specific?

Tables are convenient arrangements of mathematical data or calculations.

I'm not sure if there is a deeper theory than that.
 
For example, the field of math "linear algebra" deals with matrices and matrix functions; matrix multiplication, inverse matrix, eigenvectors and so on, in the context of linear equations.

I mean a field of math like "linear algebra" for tables and analytical table functions.

* There are typical analytical table functions like aggregation and distribution.

* Tables have in principle numbers and attributes; attributes add structure and combination logic to tables. Without attributes tables would be like matrices.

* Tables have meta-data that define the relationships between fields of tables.

As an example, consider following mathematical problem:

We have two sets of tables:

Set1: {t1, t2}
Set2: {t3, t4, t5}

Question:

Does the information content of Set1 contain the information content of Set2?

... where we define information content as follows:

If we can derive all the tables of Set2 by applying the available table functions on tables in Set1 (considering also meta data relationships) we can say:

Information content of Set1 contains information content of Set2.

Which field of math deals with such problems?

Tunc
 
AFAIK, what you're asking is not a part of mathematics, but is probably studied in courses that have to do with relational databases.
 
This sounds more like computer science than math. I'm sure it uses many techniques from mathematics, but I can't imagine anyone really being interested in this outside of computer science.
 
It sounds like you are searching for a discussion on topics like mapping with a little seasoning from abstract algebra (rings, fields, and such).
 
Thank you for the comments. The topic should possibly be covered by group theory:
http://en.wikipedia.org/wiki/Group_theory
http://dogschool.tripod.com/

As I understand, abstract algebra is also a part of group theory.

I find it surprising that computer scientists haven't yet developed a sound theory for information content of tables. It would have applications in many fields including statistical data analysis and business analytics.

Tunc
 
finaquant said:
Thank you for the comments. The topic should possibly be covered by group theory:
http://en.wikipedia.org/wiki/Group_theory
http://dogschool.tripod.com/

As I understand, abstract algebra is also a part of group theory.

Groups are a object study within algebra. That said, your question has a tenuous connection to group theory at best.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 22 ·
Replies
22
Views
4K
Replies
4
Views
3K