Coshh database

From Castell Howell Foods

Jump to: navigation, search

To download any of the below files, you will need to use the username public and the password public


GT portalBase

industrial strength platform for business applications

use to rapidly prototype and develop data entry and reporting applications that work over the internet or a local network

username
password

login

How do I use it?

Use portalBase to create database web applications. It's most suited to those who understand in depth both technology and the business needs. People who are best placed to make use of an enterprise database flexibility and power, while appreciating the clear and pleasant user interface of a well designed web application.

Documentation

See User and administrator documentation

Download the brochure portalBase is a GT webMarque product, contact us for more help and advice

On the foundations

Building blocks provide the capacity for massive scalability of end applications if necessary but the portalBase aplication itself also has some nice technical features that anyone who's worked on large scale databases will appreciate, for example...

View cascading

If a view/report A has dependent reports B, C and D, they are automatically dropped and recreated when changes to A are made. There's no laborious manual process of dropping and re-creating multiple reports for a simple field addition.

Auto joins

Joins are automatically created (LEFT OUTER by default) where there are relations but you can still create completely custom joins on any field or calculation if you need to.

Deleting

Similarly, if you try to delete a table or view field that something else depends on, portalBase will tell you exactly where the dependencies are so you can solve them first.

More

Auto indexes (case insensitive where relevant), quick aggregates, advanced filters (e.g. newer than x months), built-in stats/audit trail and more mean that common app building tasks are taken care of leaving you to concentrate on design or quick prototyping.

Technology

portalBase is a web-based, usually hosted application.

The AJAX user interface works on Firefox (recommended), Internet Explorer 7+, Google Chrome and Safari browsers.

The server side software and data is usually run as a hosted service by us. However, if you wish to run your own version, it is platform agnostic, running on Linux or Windows.

A number of robust and scalable third party products are used by the server as a foundation for our innovations

The relational database behind the scenes on our server is the enterprise class database PostgreSQL.

Hibernate and Velocity provide stable frameworks for object storage and display.

We host at NTT Communications' London datacentre. Backups are made hourly and transferred offsite (to Manchester) daily.

A business analyst's view

Over the last 10 years the role of the Business Analyst has emerged as organisations grapple with the problem of how to ensure software development projects deliver applications that match the needs of their client.

Traditionally this role has involved defining requirements and recording these in a formal specification document. However there is a growing recognition of the problems inherent in this approach and a more agile approach involving prototyping is often seen as an viable alternative.

GT portalbase requires no programming skills and thus allows analysts to convert schemas into fully working web based prototypes in hours. The prototype is immediately available via the web for client review and feedback from various stakeholders can be incorporated into the product often in real time.

GTpB as a long term solution

For many organisations these "prototypes" may even suffice, as the PostgreSQL database underlying GTpB is highly scalable & robust.

For small organisations or applications GTpB therefore provides a cost effective, rapid, easy to use and robust web app. development tool.


Personal tools