Calgary is a list count data retrieval engine designed to perform analyses on large-scale databases containing millions of records. Calgary utilizes indexing methodology to quickly retrieve records. A database index is a data structure that improves the speed of data retrieval operations on a database table. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access to ordered records.
There is a 2^31 limit on the number of records in a Calgary Database (approximately 2 Billion). It is designed for a sweet spot of around 100-300 million records. When working with more than 300M records, the 64-bit version of the Alteryx engine is highly recommended.
Calgary tools provide the following functionality to load and filter Calgary databases:
The Calgary Loader tool enables you to create a Calgary database (*.cydb) from any Input file type. Each field contained in the Input file can be indexed to maximize the Calgary database performance.
The Calgary Input tool enables you to query a Calgary database.
The Calgary Join tool allows you to take an input file and perform joins against a Calgary database where an input record matches a Calgary database record based on specific join criteria.
The Calgary Cross Count tool enables you to aggregate data across multiple Calgary database fields to return a count per record group.
The Calgary Cross Count Append tool allows you to take an input file and append counts to records that join to a Calgary database where an input record matches a Calgary database record based on specific join criteria.
Take an input file and append counts to records that join to a Calgary database.
Aggregate data across multiple Calgary database fields to return a count per record group.
Enables users to query a Calgary database.
Take an input file and perform joins against a Calgary database.
Create a Calgary database (*.cydb) from any Input file type.