SIR Database Software
Application Development Software
Database Maintenance System
Data Management
Data Analysis
Home Software Support Download News Company  
Home
  Company Info
   Contact us
   Employment
  Software
  Capability Summary
  Availability
   Download SIR
   Documentation
  News
   Conference 2008
   Conference 2007
   Conference 2006
   Conference 2005
   Conference 2004
   Conference 2003
   User Stories
  Support
   Links
   Tips & Tricks
   Documentation

  Capabilities Summary

General

  • Relational Data Base
  • Application Builder
  • Internet Enabled
  • SQL
  • ODBC with SQL Server
  • Graphics
  • Spreadsheet Style Interface
  • Platform Interoperability
    • Windows 95/98
    • Windows NT
    • Linux (Intel)
    • SUN Solaris
    • OpenVMS (Alpha)
    • Unix (Various)
  • Help
    • Full on-line documentation
    • HTML based
    • Context Sensitive
    • Customisable

Relational Database

  • Data Dictionary
  • Case Structured Option
  • Supports large databases
    • 4095 record types
    • 4095 variables per record
    • 2 billion records a database
  • Supports large disk volumes
  • Multiple Databases
  • Security at record and variable level (31 levels)
  • Dynamic database definition
  • Valid values, Ranges
  • Missing Values
  • Automatic Data Input
  • Data verification
  • Value labels
  • Date and Time Support
  • Table Files
  • Recovery and Journalling
  • Concurrent Update

Application Builder

  • Creates portable applications
  • Fourth generation language with full program logic
  • Unlimited size of programs
  • Subroutines
  • Subprocedures
  • Suspend and Execute
  • Graphical user interface builder
  • Dialog and Menu Handling
  • Block Structured
  • Integrated with Database
  • More than 200 built in functions
  • Automatic generation of analyses and reports
  • Report Generator for simple and complex reports
  • File input for text and binary
  • File Output Types include:
    • ASCII
    • Binary
    • CSV
    • DBase®
    • HTML
    • MINITAB®
    • SAS®
    • SPSS®
  • Cross Tabulations
    • Nesting and Concatenation
    • One, two or three dimensions
    • Statistics
    • Quantiles
    • Row and Column Percents
    • HTML tables
  • Data Entry
    • Forms data entry
    • Interactive Update
    • Verification
    • Search
    • Default screens
  • Interface for C and Fortran

Internet Enabled

  • CGI interface from 4GL
  • Direct link to web servers
  • No scripting required
  • HTML output
  • Develop and test locally

SQL

  • Interactive Commands
  • Menu Interface
  • Retrieval, Update and Definition
  • ANSI Standard
  • Integrated with database

ODBC

  • Cross Platform SQL Server
  • Windows ODBC Driver
  • 4GL SQL Server Interface
  • 4GL ODBC Interface

Graphics

  • Windows Based
  • 2D and 3D Graphics
  • 35 Built In Formats
  • Analyse variables by categories
  • Produce frequency charts, scatter or line plots and statistics
  • Data in text format for other packages

Spreadsheet

  • Display data as spreadsheet
  • Direct access to database for update
  • Use in Application Builder for summary data
  • Save for Excel®
These pages are created and maintained with a SIR database application. Last updated 20:41 Tuesday 01 July 2008
SIR Pty Ltd 312 Mona Vale Road Terrey Hills 2084 NSW Australia. Phone: +61 2 9450 2354 / Fax: +61 2 9475 1430 / US Fax & Voicemail: 312 577 0388