Column Groups And Row Groups
   HOME

TheInfoList



OR:

In
table Table may refer to: * Table (database), how the table data arrangement is used within the databases * Table (furniture), a piece of furniture with a flat surface and one or more legs * Table (information), a data arrangement with rows and column ...
s and
matrices Matrix (: matrices or matrixes) or MATRIX may refer to: Science and mathematics * Matrix (mathematics), a rectangular array of numbers, symbols or expressions * Matrix (logic), part of a formula in prenex normal form * Matrix (biology), the ...
, a column group or row group usually refers to a
subset In mathematics, a Set (mathematics), set ''A'' is a subset of a set ''B'' if all Element (mathematics), elements of ''A'' are also elements of ''B''; ''B'' is then a superset of ''A''. It is possible for ''A'' and ''B'' to be equal; if they a ...
of columns or rows, respectively. Short names or notational names include col group or colgroup, and row group or rowgroup. They can have varying uses depending on context: * In mathematics, a partitioned matrix is an interpretation of a matrix as being broken down into submatrices which may be more precisely referred to as a collection of row groups and column groups * In web development, colgroup is a standard HTML attribute and an HTML event attribute, for example used for color formatting of entire columns in HTML tables. The colgroup tag acts as a "parent container of one or more elements". Rowgroup is another HTML attribute. * In
report A report is a document or a statement that presents information in an organized format for a specific audience and purpose. Although summaries of reports may be delivered orally, complete reports are usually given in the form of written documen ...
ing (including business reporting,
data reporting Data reporting is the process of collecting and submitting data. The effective management of any organization relies on accurate data. Inaccurate data reporting can lead to poor decision-making based on erroneous evidence. Data reporting is diff ...
and
financial reporting Financial statements (or financial reports) are formal records of the financial activities and position of a business, person, or other entity. Relevant financial information is presented in a structured manner and in a form which is easy to un ...
), colgroups and rowgroups can be used for constructing tables and matrices which dynamically adjusts the size of their columns and rows, respectively, by displaying the set of columns in the colgroup set (which again is a subset of the underlying data). * In reporting, colgroups and rowgroups can also be used for grouping of collapsible categories in the presentation of a table (with or without aggregation for the groups). One example of a use case may be if a table contains a lot of detailed information, but there is a want to display summarizing information of groups in the same table.


See also

*
Column (database) In a relational database, a column is a set of data values of a particular type, one value for each row of a table.The term "column" also has equivalent applications in other, more generic contexts. See e.g., Flat file database, Table (inf ...
* Group by (SQL) *
Row (database) In a relational database, a row or " record" or " tuple", represents a single, implicitly structured data Data ( , ) are a collection of discrete or continuous values that convey information, describing the quantity, quality, fact, s ...
*
Row and column vectors In linear algebra, a column vector with elements is an m \times 1 matrix consisting of a single column of entries, for example, \boldsymbol = \begin x_1 \\ x_2 \\ \vdots \\ x_m \end. Similarly, a row vector is a 1 \times n matrix for some , co ...
in mathematics * Row and column spaces in mathematics *
Table (database) In a database, a table is a collection of related data organized in Table (information), table format; consisting of Column (database), columns and row (database), rows. In relational databases, and flat file databases, a ''table'' is a set of da ...


References

Matrices (mathematics) Data modeling {{Database-stub