About Data GovernanceData Glossary - F
Faceted Taxonomy
A faceted taxonomy is actually a set of taxonomies, called facets, each of which is a set of terms structured according to a specific type of information that applies to the set of objects being organized.
Fact
A finite piece of data of interest to the user of a larger set fo information. A fact is often numeric and additive. It's sorted in a fact table in a data warehouse..
Fact constellation
A database organizational schema where multiple fact tables share dimension tables. Since this model can be depicted in a shape that looks like a collection of stars, it is called a galaxy schema or fact constellation.
Fact Table
The central table in a star join schema, characterized by a composite key. The Fact Table contains two types of fields: The fields storing the foreign keys that connect each particular fact to the appropriate value in each dimension, and the fields storing the individual facts - such as number, amount, or price.
Federated Data
An approach to Data Architecture where information is stored in many locations, under the control and design of different groups, but is made available for enterprise uses and is subject to some enterprise rules. In a warehouse context, a he federated data warehouse approach supports the iterative development of a data warehousing system containing independent data marts.
Fiduciary
An individual, corporation or association entrusted with legal authority and duty to manage and invest assets for another party.
Fiduciary Trust/Responsibility
The power entrusted to a individual, corporation or association (fiduciary) to manage assets for another person (principal) beneficial to his/her interests.
FIFO
Short for "first in, first-out." A method of posting a transaction in first-in-first-out order. In other words, transactions are posted in the same order that the data producer entered them.
File Transfer Protocol (FTP)
A service that allows you to transfer files to and from other computers on the Internet.
Filter
A combination of attribute elements (fields - usually from a dimension) and/or metric qualifiers used to specify query constraints.
Filter
A saved set of chosen criteria that specify a subset of information. For example, a list of customers may be filtered to show only those whose last name begins with the letter A.
Financial Accounting Standards Board (FASB)
The FASB is a private body whose mission is to "establish and improve standards of financial accounting and reporting for the guidance and education of the public, including issuers, auditors and users of financial information." The FASB publishes the Generally Accepted Accounting Procedures (GAAP).FASB was created in 1973, replacing the Accounting Principles Board and the Committee on Accounting Procedure of the American Institute of Certified Public Accountants before it.
Financial Statement
A written report that quantitatively summarizes the financial status of an organization for a stated period of time. It includes an income statement and balance sheet that describes the flow of resources, profit or loss, and the distribution or retention of profits. Financial data flows through IT systems to end up on a financial statement.
First Normal Form
In Data Modeling, the result of normalizing to ensure that every attribute is dependent upon the key of an entity. In practice this is achieved by removing repeating groups and multi-valued attributes and modeling them as distinct entities.
Foreign Key
Column or combination of columns whose values are required to match a primary key in some other table.
Format
see data formatting
FTP
see File Transfer Protocol
Functional Requirements
Definitions of the fundamental actions that must take place in the software in accepting and processing the inputs and in processing and generating the outputs.
Copyright 2004-2008 The Data Governance Institute, LLC. All Rights Reserved
The site is brought to you in partnership with the Business Intelligence Network
