Welcome!

Artificial Intelligence Authors: Pat Romanski, Yeshim Deniz, Liz McMillan, Zakia Bouachraoui, Elizabeth White

Blog Feed Post

PowerBuilder Goes NHL

 ** Hot News **


     At the last Ottawa Sybase User Group (OSUG) meeting we had a surprise guest presenter arranged by OSUG president Chris Pollach. This also included a demonstration of a special PowerBuilder application that was written to – you might not believe this – run and emulate any standard NHL Hockey Scoreboard. Yes, you read that correctly, interface to a very complicated score board hardware system. Obviously, this is not your average PowerBuilder application but one that long time PB enthusiast Chris Pollach likes to show case as Chris has always maintained that “you can build any type of Windows application using PowerBuilder”! To that end, Chris has proven that aspect over and over again with applications like multi-media players, Application / DB Server Monitors, SQL Extraction & Analysis utilities, DataWindow Changer, Code Commenter, MS-Agent, O/S System Resource Introspection, and many more bizarre applications that most people would not at first consider PowerBuilder for.

This system is another excellent example of what Roland Smith of TopWiz Software likes to say “Anything is possible given enough time, money and Mountain Dew”! In this case, we have Mr Jeff Courtice of CourByte Consulting Group Inc who pushed the outside envelope of what typical applications PowerBuilder developers might build. Jeff, a long time PB consultant in Canada’s National Capital area who has worked on elite PowerBuilder applications like Elections Canada System that runs all federal elections right across Canada - decided that he wanted to take a break from these high-end business systems and build something that he wanted PowerBuilder to solve. In his case, after being involved with minor hockey due to his son’s participation in the sport and Jeff’s frustration with dealing with the various scoring systems decided to “build a better mouse trap” in the form of more intelligent scoreboard application software!

A few years ago Jeff decided to start an application that would emulate a hockey scoreboard as he found in real life; as these systems can be quite varied, hard to learn for the novice, poorly documented as their operation and offer no proper training along with their products. To this end, Jeff built a PB application that would visually display the various popular scoreboards including their control panels. Then the application would guide the user through the mechanics of how that scoreboard worked and allowed the student to actually score a virtual game and see how the scoreboard would react to the various inputs. In a few months, Jeff had a basic emulation working of a typical scoreboard. With this early success, Jeff decided to continue his endeavour adding more scoreboard types and better simulations. Then, another revelation occurred to Jeff ... why not build his own scoreboard and challenge the actual manufactures of the current hardware! To this end, Jeff decided to build a new product called Time-Keeper Professional or TKP for short. Thus Timekeeper-PRO ( TKP) was born and is a software program developed in Powerbuilder 11.5 and SQL Anywhere 11 to run on a standalone computer in the timekeeper/scorekeeper’s booth in hockey games.  It will perform the role of expert timekeeper/scorekeeper where none exists.  Timekeeper-PRO was designed from the ground up to be a simple to use tool that would automatically make any timekeeper/scorekeeper an expert without having to know the myriad rules of hockey as they apply to off-ice officiating. Many seasoned PN developers do not realize that simple RS232 serial port communication can be accomplished in PB by using the FileOpen, FileRead and FileWrite built-in commands. You can actually open any PC’s COM port via the FileOpen command and then read and write data streams to any device listening on the port. Typical devices could be cash registers, RFID programmers, security systems and oh, of course – hockey scoreboards.

Anyone who has ever been involved in timekeeping and score-keeping in a hockey game when the game gets intense and there are many penalties being tracked concurrently knows that the job can get extremely difficult and pressure packed.  Timekeeper-PRO’s approach was to simplify the timekeeper/scorekeeper’s life is straightforward.  Simply enter data corresponding what the on-ice referees say and the software will do the rest without any knowledge of the rules.  Among many other features, TKP will automatically track offsetting penalties and will automatically determine such things as when an extra player is required to sit for another player’s penalty.  TKP will automatically generate the game-sheet thereby eliminating the need to hand scribe the information during the game.  TKP clearly displays time remaining for penalties that are not displayed on the scoreboard – ie – off setting penalties and it will automatically adjust them when necessary as goals are scored.  TKP also has an integrated communications component responsible for distributing near real-time game statistics to registered email recipients and to league websites.

Over the course of the TKP development process a separate initiative was undertaken to design and build a fully functioning and complete electronic scoreboard to be controlled by TKP.  This was undertaken as joint venture between the Ontario Centre of Excellence (OCE), Algonquin College and Courbyte Consulting Group.  As part of the College’s Electronics Technologist program, four electrical engineering students were tasked with the job of designing and building the scoreboard.  They were successful in their task and were awarded first place amongst all Ontario colleges participating in the OCE program.  In addition to building a full sized scoreboard (12’x5’ and 300 lbs), a mini-scoreboard was also designed and built to use as a proof of concept and also as a sales tool for displaying at trade shows where space is expensive and most often at a premium.

Timekeeper-PRO has now been extensively tested at the junior hockey level where the frequent need for tracking multiple penalties and goals is prevalent.  Timekeepers that have assisted in the testing of this revolutionary new product have been amazed at the power of the product and often are heard to say “that it’s about time a product like this was developed to make timekeeping and score keeping a less onerous task”. Jeff has now decided that not only does he have a product that can easily control any major commercial scoreboard system – he now has actual scoreboard hardware that he estimates could be built at a fraction of the price many commercial systems are priced at today. To this end, Jeff is now talking to potential electronic manufactures that might be interested in taking on his design.

The latest version of TKP has even grown the functionality further by allowing the application to post the current hockey game statistics to the internet where Jeff has another PB application that can display the current game vitals on his website, email parents who cannot attend that their son or daughter has scored a goal and even print out official game reports that can be sent into the various hockey leagues. Jeff also has a “ton” more ideas for this unique PowerBuilder application for sure and OSUG members were exceptionally impressed with his system. Even SAP Sybase Technical Evangelist John Strano in attendance at the last OSUG meeting was also suitably impressed over Jeff’s scoreboard application.

For more information on the TKP application, have a look at the YouTube video of the actual TKP application in action at http://www.youtube.com/watch?v=XNleZ2gqUdM. To experience the actual TKP training emulator application, have a look at this YouTube video: http://www.youtube.com/watch?v=VPUboSNegSI
Also, feel free to drop Jeff an email as well for more information on TKP (http://www.timekeeperpro.ca) or to just cheer him on in this unique endeavour!



Regards ... Chris



Read the original blog entry...

More Stories By Chris Pollach

Chris Pollach is a Senior Consultant with over 30 years experience in Systems and Software Analysis, Development, Maintenance and Technical Support, mainly in the areas of GUI Design, MS-Windows Programming, Java / .NET Programming, Wireless, Application / Web Server Design & Programming, Object Oriented Development Tools and Methodologies, Data Base, Data Communications and Network application development. He has participated in numerous technical, planning and management roles, as well as consulted and educated in these fields for a diverse clientele. He is also the owner of “Software Tool & Die Inc.” a company dedicated to provide custom software and education solutions on Object Oriented business systems.

As an educator, Chris is certified to teach PowerBuilder (first in Canada), MS-SQLServer, Sybase’s Enterprise Application Studio and EAServer integrated application/web development environment. He is former Certified SilverStream developer (CSSD) and current Certified PowerBuilder Developer – Associate / Professional (CPD-P) as well as a Certified Sybase Tools Instructor (CSI).

Chris has written numerous articles in various popular personal computer magazines, newsletters and is the author of the PowerGuide and PowerExpert products as well as the STD Foundation Classes. Currently, Chris has developed a Foundation Class library for Sybase's PocketBuilder, SAP's PowerBulder and EAServer products and now Appeon Web & mobile products that integrates JSP or ASP web development, Section 508 / CLF web standards and mobile applications. A new Web Service framework has also been released for IIs to support PowerBuilder based web service NVUO's!

Chris recently became a 2nd Degree Black in the TaeKwonDo martial art and has developed a Martial Art multimedia study guide using the Component-One “Doc2Help” and Sybase PowerBuilder products. Since the fall of 2004 he became a TaeKwonDo instructor for the City of Ottawa’s Goulbourn program. He has also been certified with the World TaeKwonDo Federation (February 2005 - 1st Dan and October 2008 - 2nd Dan).

Chris was awarded the Sybase “Innovation and Achievement” award for 2005 as voted for by the International Sybase User Group (ISUG). This award was presented for innovations to the PocketBuilder mobile development product, contributions to the PowerBuilder News groups and support of the Ottawa Sybase User Group.

To round his management and leadership skills, Chris is the former president of the Kiwanis Club of Goulbourn and still volunteers his time with the service clubs in his area. He is also the coordinator of the Ottawa Sybase User group and a certified NAUI scuba instructor. For the last three years, Chris has been voted onto the ISUG Board of Directors and holds the position of "Director - North American User Groups".

IoT & Smart Cities Stories
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
Discussions of cloud computing have evolved in recent years from a focus on specific types of cloud, to a world of hybrid cloud, and to a world dominated by the APIs that make today's multi-cloud environments and hybrid clouds possible. In this Power Panel at 17th Cloud Expo, moderated by Conference Chair Roger Strukhoff, panelists addressed the importance of customers being able to use the specific technologies they need, through environments and ecosystems that expose their APIs to make true ...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
In an era of historic innovation fueled by unprecedented access to data and technology, the low cost and risk of entering new markets has leveled the playing field for business. Today, any ambitious innovator can easily introduce a new application or product that can reinvent business models and transform the client experience. In their Day 2 Keynote at 19th Cloud Expo, Mercer Rowe, IBM Vice President of Strategic Alliances, and Raejeanne Skillern, Intel Vice President of Data Center Group and G...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
DXWorldEXPO LLC announced today that ICC-USA, a computer systems integrator and server manufacturing company focused on developing products and product appliances, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City. ICC is a computer systems integrator and server manufacturing company focused on developing products and product appliances to meet a wide range of ...
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a m...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need to realize their goals. Sponsors of DXWorldEXPO | CloudEXPO benefit from unmatched branding, profile building and lead generation opportunities.