GTpB technology notes
From GTwM
Technology base
The technology 'GT portalBase' is a hosted software application allowing building of and reporting on databases
- Robustness:
- The underlying database is the enterprise class database PostgreSQL with a strong reputation for reliability, data integrity, and correctness
- Backups are performed hourly onsite, and daily/monthly offsite
- Performance: the database and application are highly scalable to quantity of data and number of concurrent users. Typical server response times for editing and reporting are in the millisecond range.
- Security:
- The web application is protected by SSL certificates for encryption of login credentials and all data transfer. A role/privilege system controls levels of access to each database table.
- An audit trail logs all report views/searches and edits of data, also providing statistics of these
- Features: all relational database SQL features can be used when generating reports including aggregates, calculations, inner and outer joins
- Availability: the application is available 24x7 over the internet and is accessible with a web browser
Detail regarding reporting and analysis functionality
- Understanding: Comprehension of data is aided by automatic colouring of cells based on aggregate statistics
- Graphs can be generated to total/sum/average/count etc. data on the fly
- Filtered data can be exported to spreadsheets
- Simple fast filtering: immediate (as-you-type) ad-hoc filtering and sorting can be performed to uncover patterns and categorisations
- Complex fast filtering: There are eight filtering methods for trained users to answer more complex questions
- Report building: For repetitive reports or to build in calculations, reports can be built in minutes by users with technical and/or business understanding
- Reports include set filters, calculations, sorting and aggregating
- Example uses would be histogram creation, gap analysis, exception reporting
