The ability of foxpro 2.6 for windows to perform cross tabulation
![the ability of foxpro 2.6 for windows to perform cross tabulation the ability of foxpro 2.6 for windows to perform cross tabulation](https://cdn.dos.zone/original/2X/c/cc4b2543047e9866a34606b5537bbd0e945d6a14.png)
- THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION FULL
- THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION PRO
- THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION PROFESSIONAL
The fields found in the database are listed in Table 1 (see Appendix 1). Fields are boolean, textual, numeric or "general" (a FoxPro description of a field for graphics and other visual data) according to the type of information regis-tered. There are 244 fields associated with each record, coding for information dealing with phonology, semantics, grammar, usage, iconicity, regional variation, notation, translation equivalents in English, and the educa-tional and religious background of users of the sign.
![the ability of foxpro 2.6 for windows to perform cross tabulation the ability of foxpro 2.6 for windows to perform cross tabulation](https://images.slideplayer.com/15/4706092/slides/slide_2.jpg)
Indeed, virtually every record is referenced to at least one other record in at least one field, while hundreds of records are cross referenced to up to six other records in several fields. There are, however, extensive cross references between most records in various fields. Though FoxPro is a relational database program, the Auslan database does not truly exploit this potential and thus is relatively "flat" and simple. It has approximately 6,600 records 2.1 Structure of the database (relational or flat) The Auslan lexical database is a FoxPro (version 2.6) document. It is now in press and I refer the reader to this paper.
![the ability of foxpro 2.6 for windows to perform cross tabulation the ability of foxpro 2.6 for windows to perform cross tabulation](https://www.qualtrics.com/m/assets/support/wp-content/uploads/2018/12/cross-tab-23.png)
A background paper discussing this very issue was presented the Hamburg Workshop on Multimedia Dictionaries and at the Intersign Workshop on Sign Language Lexical Databases (Hamburg University). These principles should accord with general lexicographic principles and be understandable and acceptable to any linguist and lexicographer. These dictionaries have caused me to seriously rethink what linguists and sign lexicographers should and should not record in lexical databases (and, subsequently, dictionaries) and how this information should be recorded. As mentioned above, I have produced two generalist dictionaries of Auslan in book format as well as a CD-ROM dictionary.
THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION FULL
Unless otherwise stated, the lexical database referred to in this paper is the full FoxPro database, as it existed in 1997 and early 1998, which served as the basis of the Auslan dictionaries.Ī full description of a sign language lexical database must entail a discussion of the criteria according to which signs are selected for inclusion in the database and the status or ranking individual sign records are given within that database (e.g., as lexical signs, stems, variants, and so on).
![the ability of foxpro 2.6 for windows to perform cross tabulation the ability of foxpro 2.6 for windows to perform cross tabulation](https://upload.wikimedia.org/wikipedia/commons/0/01/Lazarus_1.0_Carbon.png)
Not only does the new expanded database have more entries, it also has a new video field based on the CD-ROM data set.
THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION PRO
The third Auslan lexical database has only recently been created (in 1999) by exporting from FoxPro 2.6 an updated and expanded form of the first database into a new FileMaker Pro 4.0 format. In particular, the interface exploited the thousands of cross references that had been established between signs in the database (i.e., between numerous records and fields).
THE ABILITY OF FOXPRO 2.6 FOR WINDOWS TO PERFORM CROSS TABULATION PROFESSIONAL
Professional programmers who produced the commercial CD-ROM gave this restricted database an additional video field to complement the line graphic of each sign record as well as designing a unique user interface to navigate through the database. It was used as the data set for the CD-ROM "Signs of Australia ( Johnston 1997, 1998). The second database is a restricted subset of some 4,000 signs from the first. Data was exported from this to create the Auslan dictionary-"Signs of Australia"-in book form ( Johnston 1998). The first is the source database of some 6,600 signs created for the Auslan dictionary project. In effect, there are now three lexical databases of Auslan. Over a fifteen year period, it has grown from a relatively small "database" of some hundreds of signs stored as paragraphs and then as tabular records in a word processing program (the earliest versions of Microsoft Word), to a relational database in FileMaker Pro 4.0 with over 7,000 records (each having hundreds of fields). The lexical database of Australian Sign Language (henceforth Auslan) was begun in 1984. Trevor Johnston (Newcastle, Australia) Trevor Johnston, University of Newcastle, Newcastle, Australia The lexical database of AUSLAN (Australian Sign Language) 1.0 IntroductionĢ.1 Structure of the database (relational or flat)Ģ.5 Notation and transcription methods usedģ.0 Data exchange: Compatibility with other databasesĤ.0 The future: Compatible databases or a "universal" database?Īppendix 1: Table of fields in Auslan lexical database