Case Studies | Database

Hotel-Inntell, Inc - Lynfield, MA    Next Case Study >

Business Need:
Hotel-Inntel is subscription service that gathers and disseminates information on the “meetings” industry (for hotels, caterers, etc who want to sell their location or services to large conferences, seminars, corporate events, etc). Hotel-Intel’s goal is to provide “comprehensive meeting industry information, on demand, that enables you to make faster, more informed decisions to positively impact your company's bottom line. Hotel-Intel.com, formerly known as Boston Reader Board, has been the premier resource for competitive meetings intelligence in the Boston Metro area since 1989. We strive to leverage the efficiencies of technology to give you more control of the type of data you want to see in concise and detailed reports via the Internet.” When SilverSwitch first connected with President and Founder Joe Rogan, the business was using a sluggish, barely working Cold Fusion web application (that had been in development for over 1 year)

Solution:
SilverSwitch designed Hotel-Intel’s website and state of the art web-based Database and reporting software. In several weeks time, we converted a sluggish, barely working Cold Fusion web application (in development for over 1 year) into a 3-tier high performance ASP.NET web application. In addition to converting the code, we normalized the database (>800K records), indexed the tables, created relationships and stored procedures. As a result, reports that were timing out previously now run in less than 1 second. We have continued to support and develop new functionality for the application. Hotel-Intel continues to receive accolades from their clients for the usability and performance of the application.


Technologies
Intranet-based application that utilizes the following technologies.
- Microsoft ASP.NET AJAX - Development Technology
- Microsoft IIS - Web server
- Microsoft SQL - DB backend

Three tiered application solution:
- Presentation Tier - HTML/CSS/Telerik (MS IIS Web Server)
- Business Logic Tier - Visual Basic
- Database Tier - Microsoft SQL