|
 |
Web-based
No special hardware or software required
Quick and easy
set-up in as little
as one hour
|
Pricing based on
booking volume
Powerful
functionality
Unlimited technical support
|
Microsoft SQL Server 2000
Code streamlined by SQL Stored Procedures and SQL Triggers
Tested using real-time data and performance load scenarios
|
Ease of Use
64-bit key, unique to each client
Nightly data backups
Disaster Precautions & Recovery
|
|
|
A web-based group travel
software application, GroupMinder functions both as an
in-house and online reservation system. The in-house, or Intranet,
component manages customer, vendor, and reservations data that are input
by your agents, while the online, or Internet, component allows your
customers to independently book travel packages from your website.
|
Under development since late 2000, GroupMinder springs from the many
years of group travel experience of Joel Malnick and Sarah Twibell,
co-owners of Collegiate Athletic
Travel (CAT), a national leader in
sports travel management since 1972.
Since 1980, Malnick and Twibell have overseen and participated in the
design of several proprietary group reservation systems for CAT, as
well as a system for Great Times Out, an air-inclusive golf packaging
business they operated for ten years under the USAirways banner.
While these applications, all DOS based, served their purposes well
for the time, by the late 90’s, with the new Millennium approaching
and fresh solutions required, Malnick and Twibell decided to forego
yet another proprietary route. Instead, they licensed some existing “industry
developed” software.
In 2000, after two frustrating years working with two different applications
(neither of which had the functionality of CAT’s earlier systems),
Malnick and Twibell joined with Luis Melo, an experienced developer
of travel related web-based software, and Jen Bagshaw, CAT’s IT
and administrative manager, to design another new system for CAT. Using
the latest database and development technology, their goal was to provide
CAT with an up-to-date, fully integrated web-based marketing and group
reservation system (see “The Application”).
As development proceeded, the beta version of GroupMinder was introduced
to two free-lance travel directors (one of whom was a veteran ski tour
operator and the other a professional meeting planner) who assisted
CAT in managing its 2000-01 bowl season programs. At the same time,
several of CAT’s travel agent partners also used GroupMinder to
directly book their clients on CAT’s packages via the system’s “extranet”.
The consensus among these users was that GroupMinder was not only easy
to learn and use, but that it was the best group reservation application
any of them had ever seen--by far.
With this encouragement, the CAT principals and Melo decided to start
from scratch and re-engineer the infant system with an eye toward marketing
it to a broad spectrum of group travel providers, including: general
and specialty tour companies, motorcoach tour operators, charter package
wholesalers, group cruise specialists, meeting planners, and incentive
houses.
By the summer of 2002, version 1.0 of GroupMinder was ready for beta
testing and demonstration, and by end of the year, two companies in
addition to CAT were using the system. In 2003, Renae Greene, a 14-year
employee of CAT with strong computer application skills, and Nuno Olivera,
a recent CSI graduate of Glamorgan University in England joined the
GroupMinder effort-- Renae in training and support, and Nuno in development.
And, in 2004, Nancy Levitsky, formerly CAT’s operations manager
and Tour Coordinator for the Penn State Alumni Association, joined
the staff of GTT.
With its introduction at TRAMS Tech University 2005,
GroupMinder will be formally launched on a national level. In addition
to developing interfaces for ClientBase Plus and TRAMS Back Office,
further development of the system calls for adding cruise and meeting-specific
user interfaces, tour profit-loss accounting, simplified package building
and increased overall functionality.
|
The Intranet, which forms the functional core of the system, makes
it possible for your company to efficiently manage its customers and
vendors by enabling users to create and send e-brochures, make and modify
reservations, process payments, e-mail acknowledgements, and generate
reports -- all in a straightforward manner.
The Internet component, through the fusion of GroupMinder’s reservation
system with your company’s website, allows prospective customers to view and
book travel packages online. A clean, crisp presentation--complete with
page-by-page instructions and pop-up boxes that highlight package
features--creates an easy-to-follow booking format, which in turn, produces
immediate efficiencies for your company. Namely, clients can reserve a travel
package, have their credit card processed, and receive an instant
acknowledgement…all with no intervention from your staff. |
|
Groupminder’s principle functionality includes: |
|
|
| |
|
Detailed Customer Profile & Travel History |
| | |
GroupMinder stores and tracks detailed client information
for both households and individual household members.
This includes multiple addresses and phone numbers,
personal data (birth dates, anniversary,
etc.), credit card information, personal preferences
(non-smoking room, window seat), travel interests,
mailing history, trip history, and
much more. The client database is literally an electronic
filing cabinet, containing all the information you ever
wanted to know about your group travel customers.
|
|
Vendor Contact Files, Interaction Log & Booking History |
| | |
GroupMinder also stores and tracks detailed vendor
and individual contact information, including, name, address, phone
numbers, fax, e-mail and website address. An interaction log allows
you to track all your company’s communication with each vendor
contact. Most importantly, the vendor database keeps
a product history for each of your vendors. The system records detailed
information about
products purchased, including product type, dates
of use, quantity, cost, and commission structure.
|
|
Marketing System |
| | |
By interfacing with the client database, GroupMinder's
mailing system serves as a powerful marketing tool,
allowing you to use stored information about customer travel interests,
organization
affiliations, geographical location, and travel history
to do targeted print and electronic mailings with a simple click of
the mouse.
|
|
Easy Reservation Input, Confirmation, & Modification |
| | |
GroupMinder’s easy-to-use booking system
prompts and automatically advances your agents through the booking
of a new reservation, screen by screen, thereby minimizing input error.
Upon completion of the reservation process, agents can instantly confirm
clients' reservations via email or paper acknowledgements.
Likewise a simple process, modification of a reservation in most cases
requires just one click that takes agents directly to the appropriate screen.
Even when an entire reservation requires modification, i.e. adding another
participant or changing package selection, the procedure is quite simple.
|
|
Inventory Control |
| | |
GroupMinder maintains inventory control on all package
components, displaying real-time product availability throughout the
booking process. Further, when inventory is depleted, a product no
longer appears for sale, thus eliminating the possibility of overselling
your inventory.
|
|
Online Credit Card Processing
|
| | |
After completing a reservation, agents can process
a credit card payment through the booking system,
confirming approval while the client is on the phone.
|
|
Reports |
| | |
GroupMinder features over thirty reports, all with
various sorting options, allowing you to access the
information you need for vendors, accounting, and
on-site operations. Reports include:
Booking Source, Daily Receipts, Customer Payment
Detail, Revenue, Balance Due, Hotel Reconciliation,
Participant Master List, Name Badge List,
Rooming List, Transportation Manifest, Transportation
Manifest by Departure City, Optional Tours Manifest,
Package Components Inventory, Room Inventory,
Transportation Inventory, Hotel Vouchers, Tickets
List, Ticket Labels, Tour Packet Labels, Mailing
Labels, & Shipping Labels, and others.
|
|
Easy System Access by Third Party |
| | |
Because GroupMinder is web-based, you can easily
provide an affiliate third party, whether a travel
agency, social club, or association, access to select areas of your
system through what’s
called the Extranet. By allowing them to view data
and run reports, your ‘travel partners’ have access to
real-time information on joint projects--and, with no intervention
on the part of your staff.
The Extranet also opens the way for providing your
partners’ clients
or membership with the convenience of online registration
via their own websites.
|
| |
GroupMinder, with all its functionality, can be set up in just a matter
of hours, including at multiple company sites, and, with no special hardware
requirements. All you need is an Internet connection and a PC/Laptop
for GroupMinder to be at your fingertips--for use at the office, home
or an on-site venue.
|
|
|
|
The GroupMinder Application has been developed using the latest
programming languages and platform protocols.
Programming languages
Hosting platform
Server platform
Client platform
Database platform
Methodology
PROGRAMMING LANGUAGES
Six programming languages have been used in the development of GroupMinder
|
Coldfusion |
| |
Initially developed by Allaire, ColdFusion is a Web
server language that has become the industry standard
for web-based applications. As a “tag-based” language with HTML-like
characteristics, ColdFusion is especially well suited for the Web application
environment. Most significantly, its versatility has led to marked
reductions in development time. ColdFusion’s latest release,
MX (6.1), marketed under Macromedia, has led to improved server response
and speed, as well as to seamless integration with Flash.
|
|
SQL |
| | |
SQL (Structured Query Language) is the industry standard
programming language for database management and
data manipulation. The use of SQL allows for extremely fast and flawless
communication
with the databases that store the information for
the GroupMinder application.
|
|
XML |
|
| | |
XML (Extended Markup Language) enables
the definition, transmission, validation, and interpretation
of data between applications and organizations. XML
simplifies maintenance and management of complex data
structures, allowing intricate processes to be carried
out and completed with minimal database interaction.
XML further allows for the storage of data in complex,
relational database-table-like structures that enable
multi-step functions (such as making and managing a
reservation) to be carried out without storing temporary
data in the database. The use of XML in GroupMinder
balances the load that multi-step, complex processes
place on the system.
|
|
JavaScript |
| | |
A standard client-side language that is supported by
most browser platforms, Java Script is used extensively for validation
and data integrity. Java’s speed enables GroupMinder to both
run faster and be more interactive than applications built and based
exclusively on server-side functionality.
Dividing function load performed by any given page enables GroupMinder
to run faster on the server by eliminating back-and-forth error messages
between the server and the client until the proper format and data are
presented. To further enhance the capabilities of JavaScript, and also
minimize page load time, GroupMinder uses Regular Expressions to speed
up and simplify data validation.
|
|
Cascading
Style Sheets (CSS) |
|
| | |
Cascading Style Sheets allow dissociation
of data content and visual format. Content can be changed
without adversely affecting the format and vice-versa.
CSS falls under the aegis of compartmentalizing functionality
for the minimization and faster update of code. GroupMinder
also uses CSS in conjunction with JavaScript to achieve
more responsive pages and to produce Dynamic HTML (DHTML)
functionality.
|
|
HTML
|
| | |
Used extensively to provide layout and organization
of content in pages, HTML also provides page elements
that allow users to interact with the application and the databases.
|
|
HOSTING PLATFORM
GroupMinder is hosted by CFX Hosting, a Cisco Certified data center in
Louisville, Kentucky. CFX’S fault-tolerant infrastructure features N+1
redundancy to avoid service disruption. To ensure maximum redundancy and uptime,
CFX capabilities further include:
|
|
Bandwidth (Internet Connectivity) |
| | |
Bandwidth entering the data center is derived from
multiple DS-3connections (using BGP4 protocol) linked
in turn to an OC-48 backbone provided by UUNet and Sprint, the two
leaders in Internet
connectivity.
|
|
Data Backup |
| | |
Data is backed up nightly to an automated tape library
that can handle over 5 terabytes of data.
|
|
Routers and Switches |
| | |
Cisco Systems routers and switches connect the GroupMinder
servers to the Internet. Because the system was designed
for maximum uptime, all routers and switches have
built-in redundancy. In addition,
the data center backbone possesses the latest available
Gigabit Ethernet technology.
|
|
Electrical Power |
| | |
The data center sits on redundant power grids within
the city of Louisville, so the loss of even an entire
grid will not disrupt electrical service to the “center”. In-coming power
to the center is conditioned and delivered at consistent levels via
redundant UPS systems. In turn, these systems are backed-up by a diesel
generator that is tested monthly for reliability and which is capable
of producing enough power to maintain the data center for weeks.
|
|
Fire Suppression |
| | |
FM200 Dry Fire Suppression system tanks will immediately
extinguish any unlikely fires through dry chemicals
that, unlike water, will not damage hardware nor disrupt service.
|
|
HVAC |
| | |
Redundant Liebert heating, ventilation and cooling
units maintain room temperature and humidity inside
the data center at ideal conditions. Air is vented under the raised
floor and directed
through perforated panels. This allows maximum airflow
throughout the center and the equipment itself.
|
|
Security and Monitoring |
| | |
To gain access to the equipment within the data center, a person must
swipe an electromagnetic access card to enter the building, provide a
personal password, scan his or her hand through a scanner, and unlock
the appropriate cabinet with a key. All access inside and outside the
data center is monitored 24x7x365.
In addition to monitoring the movement of people throughout the data
center, we monitor our equipment, network utilization, latency, packet
loss, and service availability at the Network Operations Center (NOC).
Response to problems is immediate so that service is uninterrupted.
|
SERVER PLATFORM
GroupMinder uses two DELL high availability PowerEdge rack
servers, one for hosting the application (“application server”)
and the other for database storage (“database server”). This
separation helps minimize server load and shorten response time. The servers
have been optimized to accommodate periods of high resource demand and
have integrated RAID controllers and “hot” swappable, mirrored,
10,000 RPM, SCSI hard drives that prevent loss of service from a single
drive failure.
Both servers run Microsoft Windows 2000 “Advanced Server.” Additional
applications have been limited (ColdFusion to the “application” server
and SQL to the “database server”) to ensure maximum reliability
and minimum conflicts.
CLIENT PLATFORM
For the most efficient operation of the GroupMinder application, GTT makes the following recommendations:
|
|
Computer processor |
| | |
Should be Pentium II (or better)
with a minimum of 16 MB of ram. Hard drive space,
sound card and browser plug-in are not
required.
|
|
“Intranet” and “Extranet” portals |
| | |
Have been designed with a minimum of graphical embellishments to shorten
download times. Client computers accessing these portals
however should use Microsoft Internet Explorer 5.0 or higher.
a. For maximum speed and productivity a broadband connection
is best, but a 56K (unshared) modem connection will be sufficient.
b. Screen resolution should be maintained at 800 X
600 or higher with 256 colors or higher. “Cookies” must be
turned on, and browsers should be configured so that the newest version
of the page appears on each page visit.
|
|
“Internet” portal |
| | |
While either “Explorer” or “Netscape” may be
used as a system browser, it must be in version 5.0
or higher.
a. A 56K modem connection is sufficient, but a broadband
connection is recommended
b. Resolution of Client Internet machines should also
be kept at 800 X 600 with 16K color or higher. Cookies must be turned
on and browsers should be configured to get the newest version of the
page on every visit to a page.
|
DATABASE PLATFORM
For its database platform, GroupMinder uses Microsoft SQL
Sever 2000, a powerful database system that that maximizes system availability,
scalability, speed and security.
|
|
Availability |
| | |
With around-the-clock availability essential, SQL Server
2000 was developed to provide the highest level of dependability. DELL,
among other companies that rely heavily on SQL, has reported 99.9985
percent availability for an entire year.
|
|
Scalability |
| | |
Microsoft SQL Server 2000 Enterprise Edition scales
up to 64 gigabytes (GB) of RAM and up to 32 CPUs.
This can be used in conjunction with scale-out techniques, such as
Distributed Partitioned Views, to handle the largest data sets and transactional
loads.
|
|
Speed |
| | |
Currently, the world’s fastest database, “Server
2000” can handle up to 688,220 transactions per minute! On the
TPC-C performance list, SQL Server holds the number one position, four
of the top five, and five of the top 10 results.
|
|
Security |
| | |
SQL Server 2000 installs with a high level of security by default, taking
advantage of Microsoft Windows® 2000 integrated security. “Server
2000” also possesses sophisticated security features that include
powerful and flexible “role-based” security for server, database,
and application profiles; integrated tools for security auditing; and
support for complex file and network encryption.
|
METHODOLOGY
GroupMinder has been designed with seven key issues in mind:
|
|
Access |
| | |
GroupMinder is accessible from any Web terminal in the
world. This allows authorized users of the application to carry out
their assigned functions from multiple locations without costly setups
or geographically imposed limitations. This feature also allows multiple
offices or branches to interact with ease and to draw data from a central,
live, and always up-to-date location.
|
|
Speed |
| | |
GroupMinder code is streamlined to produce files that are as small as
possible and that download quickly. In addition, as many database interactions
as possible have been converted into “SQL Stored Procedures” to
both minimize the load on the Database servers and to reduce query-processing
time. All data integrity functions have also been converted into “SQL
Triggers considerably faster than page-coded queries.
GroupMinder also uses a proprietary form validation script (JavaScript)
that has reduced that component to 60% of its original size. This script
not only downloads faster but also redirects some of the load that could
potentially be placed on the Application Server and places it on the
client’s computer. This allows the server to be freed up for critical
functions, thereby enhancing response time.
All graphics used to enhance Groupminder’s navigation and user
interface have been manipulated and reduced to the smallest possible
file size. This results in faster loading pages.
|
|
Reliability |
| | |
To ensure reliability, GroupMinder has been extensively tested using
real-time data and performance load scenarios. By using only proven,
mainstream technologies together with components that integrate seamlessly,
GroupMinder functions well even in extreme, high demand situations.
GroupMinder uses all non-proprietary, plus some publicly unavailable
methods to speed up and diminish server load, helping to maximize both
server and system up-time.
|
|
Ease of Use |
| | |
GroupMinder components have been developed and organized with parallelism
in mind. Once a user becomes familiar with a single component, all other
components then become simultaneously familiar. As a result, users require
only minimal training to productively carry out their tasks.
Consistency is paramount to ease of use. All error, confirmation, and
notification messages have the same format and are displayed in the same
location. Special attention has been paid to establishing a consistent
nomenclature for all GroupMinder components.
|
|
Security |
| | |
GroupMinder uses proprietary technology that allows multiple users to
be created in the system. Users can be assigned rights based on their
needs and functions.
The system uses an audit feature to log actions by all users. Administrators
can consult the audit log to search for specific actions and any misuses
of the system.
All delete functions require confirmation to prevent accidental deletion
of any data.
System administrators can further enhance the security of the system
by requiring minimum character lengths for usernames and passwords and
also by configuring the system to periodically expire user passwords.
The system automatically prevents the user from reusing passwords and
also prevents multiple users from using a single username password combination.
A 64-bit key, unique to each client, serves to encrypt all sensitive
information stored in the database, thereby rendering the data unusable
through any unauthorized access.
Data transferred between client computers and application or database
servers is channeled through 128 bit SSL connections. Thus, if the data
were to be intercepted by unauthorized individuals, it would be encrypted
and therefore unusable.
|
|
Architecture & Upgrade Flexibility |
| | |
GroupMinder has been programmed in a shared component format. Pages
that carry out similar functions share components (ColdFusion Custom
Tags). Modifying a function requires changing only a single component.
All pages using that function will then automatically have access to
the updated version of the component.
The application has been mapped in easy-to-follow flow charts that facilitate
construction, understanding and problem solving, while carefully commented
programming allows code to be easily understood by other developers.
|
|
Disaster Precautions and Disaster Recovery |
| | |
GroupMinder is designed with the following disaster precautions and
disaster recovery measures in mind.
The application is served from high availability servers that are
over-engineered to withstand the highest loads.
Redundant components, including mirrored hard drives, redundant network
cards and redundant power supplies are used to help guard against component failure.
Three-tier architecture is used for load balancing of complex processes.
All code is written to make efficient use of the most available computing resources.
All servers are co-located at a “Cisco Certified” data center
that meets the highest security and availability standards.
On-site, nightly backups are implemented for all data.
A contract is in place with DELL that provides a 24x7/4-hour (their highest
level)response-time guarantee.
Additional off-site, nightly backup is available for a nominal fee upon request
through the resources of Collegiate Athletic Travel.
|
|
|
Download/see the TRAMS Tech U 2005 presentation. Click HERE
|
|
|