Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Appendix

Glossary - F

fact table

fat client

File DSN

flat file

foreign key

FTP

 

Appendix

 

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

 

fact table
  • A single child table in a data warehouse containing potentially repetitive information, surrounded by parent tables (dimension tables) that are used to provide keyed retrievals of unique rows from the child table;
  • The main table in a star schema containing metrics used for aggregations and codes that are linked to dimension tables, used to access descriptive information for the codes.
fat client
  • See thick client.
File DSN
  • in ODBC, a file level data source name.
flat file
  • a file structure where data items are stored line by line in a two- dimensional array.
foreign key
  • See child key
FTP
  • File Transfer Protocol; a client/server protocol that allows a user on one computer to transfer files to and from another computer over a TCP/IP network.

 

 

 

Top