Welcome!

Artificial Intelligence Authors: Yeshim Deniz, Elizabeth White, Pat Romanski, Liz McMillan, William Schmarzo

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".

@ThingsExpo Stories
SYS-CON Events announced today that MIRAI Inc. 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. MIRAI Inc. are IT consultants from the public sector whose mission is to solve social issues by technology and innovation and to create a meaningful future for people.
SYS-CON Events announced today that TidalScale, a leading provider of systems and services, 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. TidalScale has been involved in shaping the computing landscape. They've designed, developed and deployed some of the most important and successful systems and services in the history of the computing industry - internet, Ethernet, operating s...
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
Join IBM November 1 at 21st Cloud Expo at the Santa Clara Convention Center in Santa Clara, CA, and learn how IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Cognitive analysis impacts today’s systems with unparalleled ability that were previously available only to manned, back-end operations. Thanks to cloud processing, IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Imagine a robot vacuum that becomes your personal assistant tha...
SYS-CON Events announced today that TidalScale 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. TidalScale is the leading provider of Software-Defined Servers that bring flexibility to modern data centers by right-sizing servers on the fly to fit any data set or workload. TidalScale’s award-winning inverse hypervisor technology combines multiple commodity servers (including their ass...
As hybrid cloud becomes the de-facto standard mode of operation for most enterprises, new challenges arise on how to efficiently and economically share data across environments. In his session at 21st Cloud Expo, Dr. Allon Cohen, VP of Product at Elastifile, will explore new techniques and best practices that help enterprise IT benefit from the advantages of hybrid cloud environments by enabling data availability for both legacy enterprise and cloud-native mission critical applications. By rev...
Infoblox delivers Actionable Network Intelligence to enterprise, government, and service provider customers around the world. They are the industry leader in DNS, DHCP, and IP address management, the category known as DDI. We empower thousands of organizations to control and secure their networks from the core-enabling them to increase efficiency and visibility, improve customer service, and meet compliance requirements.
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
SYS-CON Events announced today that N3N will exhibit at SYS-CON's @ThingsExpo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. N3N’s solutions increase the effectiveness of operations and control centers, increase the value of IoT investments, and facilitate real-time operational decision making. N3N enables operations teams with a four dimensional digital “big board” that consolidates real-time live video feeds alongside IoT sensor data a...
Amazon is pursuing new markets and disrupting industries at an incredible pace. Almost every industry seems to be in its crosshairs. Companies and industries that once thought they were safe are now worried about being “Amazoned.”. The new watch word should be “Be afraid. Be very afraid.” In his session 21st Cloud Expo, Chris Kocher, a co-founder of Grey Heron, will address questions such as: What new areas is Amazon disrupting? How are they doing this? Where are they likely to go? What are th...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, will lead you through the exciting evolution of the cloud. He'll look at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering ...
Digital transformation is changing the face of business. The IDC predicts that enterprises will commit to a massive new scale of digital transformation, to stake out leadership positions in the "digital transformation economy." Accordingly, attendees at the upcoming Cloud Expo | @ThingsExpo at the Santa Clara Convention Center in Santa Clara, CA, Oct 31-Nov 2, will find fresh new content in a new track called Enterprise Cloud & Digital Transformation.
SYS-CON Events announced today that NetApp has been named “Bronze Sponsor” 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. NetApp is the data authority for hybrid cloud. NetApp provides a full range of hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. Together with their partners, NetApp emp...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
Most technology leaders, contemporary and from the hardware era, are reshaping their businesses to do software. They hope to capture value from emerging technologies such as IoT, SDN, and AI. Ultimately, irrespective of the vertical, it is about deriving value from independent software applications participating in an ecosystem as one comprehensive solution. In his session at @ThingsExpo, Kausik Sridhar, founder and CTO of Pulzze Systems, will discuss how given the magnitude of today's applicati...
As popularity of the smart home is growing and continues to go mainstream, technological factors play a greater role. The IoT protocol houses the interoperability battery consumption, security, and configuration of a smart home device, and it can be difficult for companies to choose the right kind for their product. For both DIY and professionally installed smart homes, developers need to consider each of these elements for their product to be successful in the market and current smart homes.
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, 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. Avere delivers a more modern architectural approach to storage that doesn't require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbui...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
SYS-CON Events announced today that Avere Systems, a leading provider of hybrid cloud enablement solutions, 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. Avere Systems was created by file systems experts determined to reinvent storage by changing the way enterprises thought about and bought storage resources. With decades of experience behind the company’s founders, Avere got its ...
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...