Welcome!

Machine Learning Authors: Elizabeth White, Yeshim Deniz, Liz McMillan, Pat Romanski, Ed Featherston

Related Topics: Machine Learning , Java IoT, Silverlight

Machine Learning : Blog Post

No New Skills or Training Required

Single developer builds tourism costing system’s web UI using basic VB6 skills

For more than a decade, Interface Systems Group (ISG) has been providing hospitality and travel solutions. The company focuses on medium size ERP solutions and projects for the hospitality sector, with a company's competitive advantage of their comprehensive solutions which provide CRM, Booking, Point-of-Sale, Event Management, Accounting, Inventory, Telephony, IVRS and integrated Websites, all under one roof.

ISG always looks to update and upgrade its ERP solutions to the latest technologies available. Dhruv is a tour costing system that was designed for a tour operator which provides custom-designed holidays to their clients. The product has been developed using Visual WebGui and uses MS SQL 2005 as the database. The solution integrates into the client's CRM that was developed by another vendor and uses PHP and MySQL. Most of the application is in 3-tier and uses NHibernate. 

Business needs
Each tour or holiday consists of various elements such as accommodation, travel, sightseeing, etc. Those details and their costs provided by suppliers are entered into the system which then automatically calculates the sell price for the holiday. The representative who uses the system can then book the holiday and collect the payment. These sales representatives formerly worked with Excel spreadsheets, which was often prone to user errors and, more importantly, the constant changes in pricing and costs often did not feed in correctly to the systems downstream (Accounts, CRM, MIS).

As a result there was a need for a system that would allow users to dynamically create packages while connected to the CRM (for client details). They sought a system that would allow the staffers to enter cost details with supplier information and present the quote. It also needed the ability to keep multiple versions for the same quotation and account for different currencies, as well as to keep track of any changes made to the itinerary and/or cost after it has been booked.

In addition, the system needed to use the company rules to compute a recommended selling price and allow conversion a quotation to a booking when required. On top of that, it had to be able to share information in real-time with MIS and Accounting so that any quote or order is updated in the system and any subsequent changes to price or cost are synchronized. In that case, it was necessary that the system be integrated into the existing web based CRM and served as a web application as well.

Since the application was intended to run online, performance was an important issue. Keeping waiting time under 5 seconds when moving between forms of the quotation or booking was a key factor to this data centric application which was specified to use grids wherever applicable. 

The Solution
With only minimal funds available, a single developer was allocated for the main part of this project. The developer, who had an extensive experience in developing in VB6, would have some support available from two additional developers with the business and data layers. Thus, a solution that would allow building web applications while utilizing the existing VB6 skills as much as possible was sought. Visual WebGui seemed the best fit as it allows building web applications using VB6-like development patterns. "Visual WebGui was easy to get acquainted and got me started with building an architectural plan within few working days. On execution it was satisfying to see a web application coming through faster than expected," said the CEO Rajeev Jha.

The smooth shift to Visual WebGui and building web applications was successful due to the native simplicity of Visual WebGui as well as the extensive support available from Visual WebGui.

With regards to integrating the application which uses MS SQL 2005 with the client's CRM and Database (written in PHP using MySQL) SOA methods were discussed. But it was eventually decided to integrate by sharing the database schema with each other and usage of temporary tables. e.g. Both systems get the data in read-only mode for pick-up/lookup, but use temporary tables to allow for updating each other's database. 

Benefits
Completing the development of the web based tour costing system according to the original specifications was made possible due to Visual WebGui's Windows over Web approach that allowed developing a web application using VB6-like development paradigms. This was crucial since the single developer allocated to the project was a desktop developer, experienced in VB6 and had practically no web development experience at all. 

"Not only did the Visual WebGui VB6-like development experience contribute to achieving a web application which would have been difficult or impossible to do otherwise, but it was also done fairly easy," said Rajeev Jha.  He also added that "the ease of designing a web page in Visual WebGui is unmatched to any other web solution I have evaluated." The amount of time this exact project would have taken using ASP.net cannot even be estimated due to the developer's lack of experience in developing web. It is certain however, that the development time would have been significantly longer. "The overall development process took a bit longer than what it would have taken with WinForms, but in the end I got a web application!" said Rajeev Jha.

Using Visual WebGui allowed the company to easily bind data especially since the VB6 developer had never used controls in a data-bound way. "I was aware that in ASP.Net it is needed to bind custom classes to the control, but had heard it is quite painful. Luckily, with Visual WebGui I didn't have to implement it since I didn't directly develop in ASP.Net. As a result, I found data-binding to be fairly simple and to work well with Visual WebGui," commented Rajeev Jha.

One of the key requirements and concerns with building the solution as a web based application was performance and response time as it was being compared internally to a similar desktop application. In addition, the system uses an ORM (NHibernate) which added to the performance concerns. Due to the Visual WebGui runtime, the deployed product performs well over the original "Keeping waiting time under 5 seconds" requirement and overall shows great results in terms of performance with approximately 20 concurrent users at the moment.

More Stories By Josh Litvin

Yaniv Yehuda is the Co-Founder and CTO of DBmaestro, an Enterprise Software Development Company focusing on database development and deployment technologies. Yaniv is also the Co-Founder and the head of development for Extreme Technology, an IT service provider for the Israeli market. Yaniv was a captain in Mamram, the Israel Defense Forces computer centers where he served as a software engineering manager.

@CloudExpo Stories
As you move to the cloud, your network should be efficient, secure, and easy to manage. An enterprise adopting a hybrid or public cloud needs systems and tools that provide: Agility: ability to deliver applications and services faster, even in complex hybrid environments Easier manageability: enable reliable connectivity with complete oversight as the data center network evolves Greater efficiency: eliminate wasted effort while reducing errors and optimize asset utilization Security: imple...
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, will discuss how by using...
In this strange new world where more and more power is drawn from business technology, companies are effectively straddling two paths on the road to innovation and transformation into digital enterprises. The first path is the heritage trail – with “legacy” technology forming the background. Here, extant technologies are transformed by core IT teams to provide more API-driven approaches. Legacy systems can restrict companies that are transitioning into digital enterprises. To truly become a lead...
DevOps at Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to w...
SYS-CON Events announced today that Daiya Industry will exhibit at the Japanese Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Ruby Development Inc. builds new services in short period of time and provides a continuous support of those services based on Ruby on Rails. For more information, please visit https://github.com/RubyDevInc.
When it comes to cloud computing, the ability to turn massive amounts of compute cores on and off on demand sounds attractive to IT staff, who need to manage peaks and valleys in user activity. With cloud bursting, the majority of the data can stay on premises while tapping into compute from public cloud providers, reducing risk and minimizing need to move large files. In his session at 18th Cloud Expo, Scott Jeschonek, Director of Product Management at Avere Systems, discussed the IT and busine...
As businesses evolve, they need technology that is simple to help them succeed today and flexible enough to help them build for tomorrow. Chrome is fit for the workplace of the future — providing a secure, consistent user experience across a range of devices that can be used anywhere. In her session at 21st Cloud Expo, Vidya Nagarajan, a Senior Product Manager at Google, will take a look at various options as to how ChromeOS can be leveraged to interact with people on the devices, and formats th...
First generation hyperconverged solutions have taken the data center by storm, rapidly proliferating in pockets everywhere to provide further consolidation of floor space and workloads. These first generation solutions are not without challenges, however. In his session at 21st Cloud Expo, Wes Talbert, a Principal Architect and results-driven enterprise sales leader at NetApp, will discuss how the HCI solution of tomorrow will integrate with the public cloud to deliver a quality hybrid cloud e...
Is advanced scheduling in Kubernetes achievable? Yes, however, how do you properly accommodate every real-life scenario that a Kubernetes user might encounter? How do you leverage advanced scheduling techniques to shape and describe each scenario in easy-to-use rules and configurations? In his session at @DevOpsSummit at 21st Cloud Expo, Oleg Chunikhin, CTO at Kublr, will answer these questions and demonstrate techniques for implementing advanced scheduling. For example, using spot instances ...
The next XaaS is CICDaaS. Why? Because CICD saves developers a huge amount of time. CD is an especially great option for projects that require multiple and frequent contributions to be integrated. But… securing CICD best practices is an emerging, essential, yet little understood practice for DevOps teams and their Cloud Service Providers. The only way to get CICD to work in a highly secure environment takes collaboration, patience and persistence. Building CICD in the cloud requires rigorous ar...
SYS-CON Events announced today that Yuasa System will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Yuasa System is introducing a multi-purpose endurance testing system for flexible displays, OLED devices, flexible substrates, flat cables, and films in smartphones, wearables, automobiles, and healthcare.
The session is centered around the tracing of systems on cloud using technologies like ebpf. The goal is to talk about what this technology is all about and what purpose it serves. In his session at 21st Cloud Expo, Shashank Jain, Development Architect at SAP, will touch upon concepts of observability in the cloud and also some of the challenges we have. Generally most cloud-based monitoring tools capture details at a very granular level. To troubleshoot problems this might not be good enough.
Companies are harnessing data in ways we once associated with science fiction. Analysts have access to a plethora of visualization and reporting tools, but considering the vast amount of data businesses collect and limitations of CPUs, end users are forced to design their structures and systems with limitations. Until now. As the cloud toolkit to analyze data has evolved, GPUs have stepped in to massively parallel SQL, visualization and machine learning.
Organizations do not need a Big Data strategy; they need a business strategy that incorporates Big Data. Most organizations lack a road map for using Big Data to optimize key business processes, deliver a differentiated customer experience, or uncover new business opportunities. They do not understand what’s possible with respect to integrating Big Data into the business model.
When it comes to cloud computing, the ability to turn massive amounts of compute cores on and off on demand sounds attractive to IT staff, who need to manage peaks and valleys in user activity. With cloud bursting, the majority of the data can stay on premises while tapping into compute from public cloud providers, reducing risk and minimizing need to move large files. In his session at 18th Cloud Expo, Scott Jeschonek, Director of Product Management at Avere Systems, discussed the IT and busine...
Enterprises have taken advantage of IoT to achieve important revenue and cost advantages. What is less apparent is how incumbent enterprises operating at scale have, following success with IoT, built analytic, operations management and software development capabilities – ranging from autonomous vehicles to manageable robotics installations. They have embraced these capabilities as if they were Silicon Valley startups. As a result, many firms employ new business models that place enormous impor...
SYS-CON Events announced today that Dasher Technologies will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Dasher Technologies, Inc. ® is a premier IT solution provider that delivers expert technical resources along with trusted account executives to architect and deliver complete IT solutions and services to help our clients execute their goals, plans and objectives. Since 1999, we'v...
SYS-CON Events announced today that Taica will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Taica manufacturers Alpha-GEL brand silicone components and materials, which maintain outstanding performance over a wide temperature range -40C to +200C. For more information, visit http://www.taica.co.jp/english/.
Recently, REAN Cloud built a digital concierge for a North Carolina hospital that had observed that most patient call button questions were repetitive. In addition, the paper-based process used to measure patient health metrics was laborious, not in real-time and sometimes error-prone. In their session at 21st Cloud Expo, Sean Finnerty, Executive Director, Practice Lead, Health Care & Life Science at REAN Cloud, and Dr. S.P.T. Krishnan, Principal Architect at REAN Cloud, will discuss how they b...
We all know that end users experience the Internet primarily with mobile devices. From an app development perspective, we know that successfully responding to the needs of mobile customers depends on rapid DevOps – failing fast, in short, until the right solution evolves in your customers' relationship to your business. Whether you’re decomposing an SOA monolith, or developing a new application cloud natively, it’s not a question of using microservices – not doing so will be a path to eventual b...