Welcome!

Machine Learning Authors: Liz McMillan, Pat Romanski, Yeshim Deniz, Elizabeth White, Leon Adato

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
In his session at 20th Cloud Expo, Mike Johnston, an infrastructure engineer at Supergiant.io, discussed how to use Kubernetes to set up a SaaS infrastructure for your business. Mike Johnston is an infrastructure engineer at Supergiant.io with over 12 years of experience designing, deploying, and maintaining server and workstation infrastructure at all scales. He has experience with brick and mortar data centers as well as cloud providers like Digital Ocean, Amazon Web Services, and Rackspace. H...
The question before companies today is not whether to become intelligent, it’s a question of how and how fast. The key is to adopt and deploy an intelligent application strategy while simultaneously preparing to scale that intelligence. In her session at 21st Cloud Expo, Sangeeta Chakraborty, Chief Customer Officer at Ayasdi, will provide a tactical framework to become a truly intelligent enterprise, including how to identify the right applications for AI, how to build a Center of Excellence to ...
You know you need the cloud, but you’re hesitant to simply dump everything at Amazon since you know that not all workloads are suitable for cloud. You know that you want the kind of ease of use and scalability that you get with public cloud, but your applications are architected in a way that makes the public cloud a non-starter. You’re looking at private cloud solutions based on hyperconverged infrastructure, but you’re concerned with the limits inherent in those technologies.
As businesses adopt functionalities in cloud computing, it’s imperative that IT operations consistently ensure cloud systems work correctly – all of the time, and to their best capabilities. In his session at @BigDataExpo, Bernd Harzog, CEO and founder of OpsDataStore, presented an industry answer to the common question, “Are you running IT operations as efficiently and as cost effectively as you need to?” He then expounded on the industry issues he frequently came up against as an analyst, and ...
SYS-CON Events announced today that Massive Networks 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. Massive Networks mission is simple. To help your business operate seamlessly with fast, reliable, and secure internet and network solutions. Improve your customer's experience with outstanding connections to your cloud.
DevOps is under attack because developers don’t want to mess with infrastructure. They will happily own their code into production, but want to use platforms instead of raw automation. That’s changing the landscape that we understand as DevOps with both architecture concepts (CloudNative) and process redefinition (SRE). Rob Hirschfeld’s recent work in Kubernetes operations has led to the conclusion that containers and related platforms have changed the way we should be thinking about DevOps and...
SYS-CON Events announced today that Datera, that offers a radically new data management architecture, has been named "Exhibitor" of 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. Datera is transforming the traditional datacenter model through modern cloud simplicity. The technology industry is at another major inflection point. The rise of mobile, the Internet of Things, data storage and Big...
Everything run by electricity will eventually be connected to the Internet. Get ahead of the Internet of Things revolution and join Akvelon expert and IoT industry leader, Sergey Grebnov, in his session at @ThingsExpo, for an educational dive into the world of managing your home, workplace and all the devices they contain with the power of machine-based AI and intelligent Bot services for a completely streamlined experience.
Because IoT devices are deployed in mission-critical environments more than ever before, it’s increasingly imperative they be truly smart. IoT sensors simply stockpiling data isn’t useful. IoT must be artificially and naturally intelligent in order to provide more value In his session at @ThingsExpo, John Crupi, Vice President and Engineering System Architect at Greenwave Systems, will discuss how IoT artificial intelligence (AI) can be carried out via edge analytics and machine learning techn...
FinTechs use the cloud to operate at the speed and scale of digital financial activity, but are often hindered by the complexity of managing security and compliance in the cloud. In his session at 20th Cloud Expo, Sesh Murthy, co-founder and CTO of Cloud Raxak, showed how proactive and automated cloud security enables FinTechs to leverage the cloud to achieve their business goals. Through business-driven cloud security, FinTechs can speed time-to-market, diminish risk and costs, maintain continu...
Existing Big Data solutions are mainly focused on the discovery and analysis of data. The solutions are scalable and highly available but tedious when swapping in and swapping out occurs in disarray and thrashing takes place. The resolution for thrashing through machine learning algorithms and support nomenclature is through simple techniques. Organizations that have been collecting large customer data are increasingly seeing the need to use the data for swapping in and out and thrashing occurs ...
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
As many know, the first generation of Cloud Management Platform (CMP) solutions were designed for managing virtual infrastructure (IaaS) and traditional applications. But that’s no longer enough to satisfy evolving and complex business requirements. In his session at 21st Cloud Expo, Scott Davis, Embotics CTO, will explore how next-generation CMPs ensure organizations can manage cloud-native and microservice-based application architectures, while also facilitating agile DevOps methodology. He wi...
From 2013, NTT Communications has been providing cPaaS service, SkyWay. Its customer’s expectations for leveraging WebRTC technology are not only typical real-time communication use cases such as Web conference, remote education, but also IoT use cases such as remote camera monitoring, smart-glass, and robotic. Because of this, NTT Communications has numerous IoT business use-cases that its customers are developing on top of PaaS. WebRTC will lead IoT businesses to be more innovative and address...
Blockchain is a shared, secure record of exchange that establishes trust, accountability and transparency across business networks. Supported by the Linux Foundation's open source, open-standards based Hyperledger Project, Blockchain has the potential to improve regulatory compliance, reduce cost as well as advance trade. Are you curious about how Blockchain is built for business? In her session at 21st Cloud Expo, René Bostic, Technical VP of the IBM Cloud Unit in North America, will discuss th...
While some vendors scramble to create and sell you a fancy solution for monitoring your spanking new Amazon Lambdas, hear how you can do it on the cheap using just built-in Java APIs yourself. By exploiting a little-known fact that Lambdas aren’t exactly single-threaded, you can effectively identify hot spots in your serverless code. In his session at @DevOpsSummit at 21st Cloud Expo, Dave Martin, Product owner at CA Technologies, will give a live demonstration and code walkthrough, showing how ...
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business – from apparel to energy – is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
Cloud adoption is often driven by a desire to increase efficiency, boost agility and save money. All too often, however, the reality involves unpredictable cost spikes and lack of oversight due to resource limitations. In his session at 20th Cloud Expo, Joe Kinsella, CTO and Founder of CloudHealth Technologies, tackled the question: “How do you build a fully optimized cloud?” He will examine: Why TCO is critical to achieving cloud success – and why attendees should be thinking holistically ab...
Internet of @ThingsExpo, 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 Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...
As more and more companies are making the shift from on-premises to public cloud, the standard approach to DevOps is evolving. From encryption, compliance and regulations like GDPR, security in the cloud has become a hot topic. Many DevOps-focused companies have hired dedicated staff to fulfill these requirements, often creating further siloes, complexity and cost. This session aims to highlight existing DevOps cultural approaches, tooling and how security can be wrapped in every facet of the bu...