Click here to close now.

Welcome!

SAP Authors: Carmen Gonzalez, Pat Romanski, AppDynamics Blog, Elizabeth White, Liz McMillan

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
The 17th International Cloud Expo has announced that its Call for Papers is open. 17th International Cloud Expo, to be held November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, brings together Cloud Computing, APM, APIs, Microservices, Security, Big Data, Internet of Things, DevOps and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit your speaking proposal today!
17th Cloud Expo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Meanwhile, 94% of enterprises are using some form of XaaS – software, platform, and infrastructure as a service.
The Internet of Things is not new. Historically, smart businesses have used its basic concept of leveraging data to drive better decision making and have capitalized on those insights to realize additional revenue opportunities. So, what has changed to make the Internet of Things one of the hottest topics in tech? In his session at @ThingsExpo, Chris Gray, Director, Embedded and Internet of Things, discussed the underlying factors that are driving the economics of intelligent systems. Discover how hardware commoditization, the ubiquitous nature of connectivity, and the emergence of Big Data a...
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo in Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th 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 an...
All major researchers estimate there will be tens of billions devices - computers, smartphones, tablets, and sensors - connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades. With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo, June 9-11, 2015, at the Javits Center in New York City. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be
Container frameworks, such as Docker, provide a variety of benefits, including density of deployment across infrastructure, convenience for application developers to push updates with low operational hand-holding, and a fairly well-defined deployment workflow that can be orchestrated. Container frameworks also enable a DevOps approach to application development by cleanly separating concerns between operations and development teams. But running multi-container, multi-server apps with containers is very hard. You have to learn five new and different technologies and best practices (libswarm, sy...
SYS-CON Events announced today that DragonGlass, an enterprise search platform, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. After eleven years of designing and building custom applications, OpenCrowd has launched DragonGlass, a cloud-based platform that enables the development of search-based applications. These are a new breed of applications that utilize a search index as their backbone for data retrieval. They can easily adapt to new data sets and provide access to both structured and unstruc...
As the Internet of Things unfolds, mobile and wearable devices are blurring the line between physical and digital, integrating ever more closely with our interests, our routines, our daily lives. Contextual computing and smart, sensor-equipped spaces bring the potential to walk through a world that recognizes us and responds accordingly. We become continuous transmitters and receivers of data. In his session at @ThingsExpo, Andrew Bolwell, Director of Innovation for HP's Printing and Personal Systems Group, discussed how key attributes of mobile technology – touch input, sensors, social, and ...
WebRTC defines no default signaling protocol, causing fragmentation between WebRTC silos. SIP and XMPP provide possibilities, but come with considerable complexity and are not designed for use in a web environment. In his session at @ThingsExpo, Matthew Hodgson, technical co-founder of the Matrix.org, discussed how Matrix is a new non-profit Open Source Project that defines both a new HTTP-based standard for VoIP & IM signaling and provides reference implementations.
SYS-CON Events announced today that the "First Containers & Microservices Conference" will take place June 9-11, 2015, at the Javits Center in New York City. The “Second Containers & Microservices Conference” will take place November 3-5, 2015, at Santa Clara Convention Center, Santa Clara, CA. Containers and microservices have become topics of intense interest throughout the cloud developer and enterprise IT communities.
Buzzword alert: Microservices and IoT at a DevOps conference? What could possibly go wrong? In this Power Panel at DevOps Summit, moderated by Jason Bloomberg, the leading expert on architecting agility for the enterprise and president of Intellyx, panelists will peel away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud environment, and we must architect and code accordingly. At the very least, you'll have no problem fil...
Almost everyone sees the potential of Internet of Things but how can businesses truly unlock that potential. The key will be in the ability to discover business insight in the midst of an ocean of Big Data generated from billions of embedded devices via Systems of Discover. Businesses will also need to ensure that they can sustain that insight by leveraging the cloud for global reach, scale and elasticity.
The 4th International Internet of @ThingsExpo, co-located with the 17th International Cloud Expo - to be held November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA - announces that its Call for Papers is open. The Internet of Things (IoT) is the biggest idea since the creation of the Worldwide Web more than 20 years ago.
"People are a lot more knowledgeable about APIs now. There are two types of people who work with APIs - IT people who want to use APIs for something internal and the product managers who want to do something outside APIs for people to connect to them," explained Roberto Medrano, Executive Vice President at SOA Software, in this SYS-CON.tv interview at Cloud Expo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
In their session at @ThingsExpo, Shyam Varan Nath, Principal Architect at GE, and Ibrahim Gokcen, who leads GE's advanced IoT analytics, focused on the Internet of Things / Industrial Internet and how to make it operational for business end-users. Learn about the challenges posed by machine and sensor data and how to marry it with enterprise data. They also discussed the tips and tricks to provide the Industrial Internet as an end-user consumable service using Big Data Analytics and Industrial Cloud.
Sensor-enabled things are becoming more commonplace, precursors to a larger and more complex framework that most consider the ultimate promise of the IoT: things connecting, interacting, sharing, storing, and over time perhaps learning and predicting based on habits, behaviors, location, preferences, purchases and more. In his session at @ThingsExpo, Tom Wesselman, Director of Communications Ecosystem Architecture at Plantronics, will examine the still nascent IoT as it is coalescing, including what it is today, what it might ultimately be, the role of wearable tech, and technology gaps stil...
The explosion of connected devices / sensors is creating an ever-expanding set of new and valuable data. In parallel the emerging capability of Big Data technologies to store, access, analyze, and react to this data is producing changes in business models under the umbrella of the Internet of Things (IoT). In particular within the Insurance industry, IoT appears positioned to enable deep changes by altering relationships between insurers, distributors, and the insured. In his session at @ThingsExpo, Michael Sick, a Senior Manager and Big Data Architect within Ernst and Young's Financial Servi...
The Workspace-as-a-Service (WaaS) market will grow to $6.4B by 2018. In his session at 16th Cloud Expo, Seth Bostock, CEO of IndependenceIT, will begin by walking the audience through the evolution of Workspace as-a-Service, where it is now vs. where it going. To look beyond the desktop we must understand exactly what WaaS is, who the users are, and where it is going in the future. IT departments, ISVs and service providers must look to workflow and automation capabilities to adapt to growing demand and the rapidly changing workspace model.
Since 2008 and for the first time in history, more than half of humans live in urban areas, urging cities to become “smart.” Today, cities can leverage the wide availability of smartphones combined with new technologies such as Beacons or NFC to connect their urban furniture and environment to create citizen-first services that improve transportation, way-finding and information delivery. In her session at @ThingsExpo, Laetitia Gazel-Anthoine, CEO of Connecthings, will focus on successful use cases.
One of the biggest impacts of the Internet of Things is and will continue to be on data; specifically data volume, management and usage. Companies are scrambling to adapt to this new and unpredictable data reality with legacy infrastructure that cannot handle the speed and volume of data. In his session at @ThingsExpo, Don DeLoach, CEO and president of Infobright, will discuss how companies need to rethink their data infrastructure to participate in the IoT, including: Data storage: Understanding the kinds of data: structured, unstructured, big/small? Analytics: What kinds and how responsiv...