Textual Data Definition Format - SuperCHANNEL
The Space-Time Research Textual Data Definition (TDD) standard allows you to create an SXV4 database based on data stored in text files, as opposed to connecting to a relational database. This can be useful in situations where data is not available in a database and so is extracted to TDD text files instead. It can also be slightly faster to channel from text-based sources, as this method avoids the performance overhead of connecting to an RDBMS.
This section describes the TDD format. You can use this information to convert your data into the TDD format for processing with SuperCHANNEL.
Files Required for a TDD
The TDD format is actually a directory of text files containing all the required information to define the database structure as well as the data itself. There are three types of file that contribute to a TDD:
| Control files | Define the layout of information in the data files. Learn more. |
|---|---|
| Registry tables | Perform the same function as registry tables in a relational database; the registry tables can be used to give SuperCHANNEL information about the design of the target database, such as which tables are fact tables, and which are classifications. Learn more. |
| Data files | Contain the actual data (i.e. the contents of the fact and classification tables). The structure of the data files is defined in the control files, but typically these will be comma separated or fixed width format files containing the table data, and saved as CSV (Comma Separated Values) files or TXT (text) files. |
Examples
There are some example TDD format files supplied with SuperCHANNEL. If you installed to the default location then the examples are located in C:\ProgramData\STR\SuperCHANNEL\examples.
| Household | A sample of some survey data.
|
|---|---|
| People | A sample database containing information about individuals.
|
Connecting to a TDD Source
Once you have converted your source data to the TDD format described here, you can use the supplied sctextdriver to connect to the TDD source. See Connecting to TDD Data Sources - SuperCHANNEL for more information.