Register Here
  Call For Papers
  Hotel Info
  Power Panels
Untitled Document
2018 Platinum Sponsor

2018 Gold Sponsor

2018 Keynote Sponsor

2018 Tech Sponsor

2018 Pavilion Sponsor

2018 Partners

2018 Exhibitors

Untitled Document
2018 Media Sponsors

Untitled Document
2017 West
Premium Sponsors



Untitled Document
2017 West
Keynote Sponsor

Untitled Document
2017 West Exhibitors


Untitled Document
2017 West JETRO ×
Six Prefectures
of Japan
Pavilion Exhibitors

Untitled Document
2017 West Media Sponsors

Untitled Document
2017 East
Premium Sponsors





Untitled Document
2017 East Exhibitors

Untitled Document
2017 East Media Sponsors

Untitled Document
  Think Big – Now Think Even Bigger
  Join Us at Internet of Things at Cloud Expo, November 11-13,
at the Javits Center!

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 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 Internet of Things at Cloud Expo 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!

Delegates to Internet of Things at Cloud Expo will be able to attend eight separate, information-packed tracks:

  • Enterprise Cloud
  • Digital Transformation
  • The API Enterprise | Mobility & Security
  • DevOps | Containers & Microservices
  • Cognitive Computing | AI, ML, DL
  • Big Data | Analytics
  • IoT | IIoT | Smart Cities
  • Hot Topics | FinTech | WebRTC

There are 120 breakout sessions in all, with Keynotes, General Sessions, and Power Panels adding to three days of incredibly rich presentations and content.

We'll see you in New York!

Day 3 Keynote at @ThingsExpo | Chris Matthieu, CTO of Octoblu
In his keynote at @ThingsExpo, Chris Matthieu, Director of IoT Engineering at Citrix and co-founder and CTO of Octoblu, focused on building an IoT platform and company. He provided a behind-the-scenes look at Octoblu's platform, business, and pivots along the way (including the Citrix acquisition of Octoblu).
  Themes & Topics to Be Discussed

Consumer IoT
• Wearables
• Smart Appliances
• Smart Cars
• Smartphones 2.0
• Automation
• Smart Travel
• Personal Fitness
• Health Care
• Personalized Marketing
• Customized Shopping
• Personal Finance
• The Digital Divide
• Mobile Cash & Markets
• Games & The IoT
• The Future of Education
• Virtual Reality

Enterprise IoT
• The Business Case for
x IoT
• Smart Grids
• Smart Cities
• Smart Transportation
• The Smart Home
• M2M
• Authentication/Security
• Wiring the IoT
• The Internet of
x Everything
• Digital Transformation
x of Enterprise IT
• Agriculture
• Transportation
• Manufacturing
• Local & State
x Government
• Federal Government

IoT Developers | WebRTC Summit
• Eclipse Foundation
• Cloud Foundry
• Linux Containers
• Node-Red
• Open Source Hardware
• Ajax and the IoT
• Leveraging SOA
• Multi-Cloud IoT
• Evolving Standards
• WebSockets
• Security & Privacy
x Protocols
• GPS & Proximity
x Services
• Bluetooth/RFID/etc
• Nest Labs

The Top Keynotes, the Best Sessions, a Rock Star Faculty and the Most Qualified Delegates of ANY Internet of Things Event!

The future of computing lies in these things. As computing takes a much more active role in our lives it will at the same time become much more invisible. Internet of Things Expo will address the challenges in getting from where we are today to this future.
The high-energy event is a must-attend for senior technologists from CEOs on down – including CIOs, CTOs, directors of infrastructure, VPs of technology, IT directors and managers, network and storage managers, network engineers, enterprise architects, and communications and networking specialists.

@ThingsExpo Power Panel | The World's Many IoTs: Which Are the Most Important?
The Internet of Things is clearly many things: data collection and analytics, wearables, Smart Grids and Smart Cities, the Industrial Internet, and more. Cool platforms like Arduino, Raspberry Pi, Intel's Galileo and Edison, and a diverse world of sensors are making the IoT a great toy box for developers in all these areas. In this Power Panel at @ThingsExpo, panelists discussed what things are the most important, which will have the most profound effect on the world, and what should we expect to see over the next couple of years.
Benefits of Attending the Three-Day Technical Program
  LEARNexactly why Internet of Things is relevant today from an economic, business and technology standpoint.
  HEAR first-hand from industry experts the common issues and requirements for creating a platform for the Internet of Things.
  SEE what new tools and approaches the Internet of Things requires.
  DISCOVER how to drive a distributed approach to the Internet of Things, where applications move to the data.
  FIND OUThow the vast volumes of new data produced by the Internet of Things provides a valuable new source of business insight through advanced analytical techniques.
  MASTER how the ongoing development of smart cities, cars, and houses will enhance connectivity infrastructure.
Lunch Power Panel | Microservices & IoT- Moderated by Jason Bloomberg
In this Power Panel at @DevOpsSummit, moderated by Jason Bloomberg, president of Intellyx, panelists Roberto Medrano, Executive Vice President at Akana; Lori MacVittie, Evangelist for F5 Networks; and Troy Topnik, ActiveState's Technical Product Manager; and Otis Gospodnetic, founder of Sematext; peeled 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 filling in your buzzword bingo cards.

Querying Queries
Querying Queries

This month I'd like to continue exploring ColdFusion 5 - this time concentrating on a radical new feature known as Query of Queries - a feature that lets you treat query results as if they were database tables. Intrigued? Read on.

Querying Queries
You've probably run into this one before - you retrieve data from a database, and then find that you need the same data again, just sorted differently. Or how about this one - you load an entire product catalog into the APPLICATION scope so as to avoid unnecessary database access, and then need a subset of that data which requires that you make another call to the database. In both examples, you're performing additional database operations to access data that you already have. In fact, the only reason you're going back to the database is to perform sorting or filtering, not because you actually need new data.

With Query of Queries you now have a new way to perform these operations, without having to make additional round-trips to the database server. And the best way to explain it is to look at some code:

<!--- Get all movies and expenses --->
<CFQUERY DATASOURCE="ows" NAME="MovieExpenses">
SELECT MovieTitle, SUM(ExpenseAmount) AS Expense
FROM Films, Expenses
WHERE Films.FilmID=Expenses.FilmID
GROUP BY MovieTitle
ORDER BY MovieTitle

<!--- Sort by expense --->
<CFQUERY NAME="MoviesByExpense" DBTYPE="query">
FROM MovieExpenses
ORDER BY Expense

The first query is a simple <CFQUERY>. It retrieves a list of movies from a table, along with the total expenses from a second table (using a join and an aggregate function). The results are sorted by MovieTitle, and returned as query MovieExpenses.

The second query is the interesting one. It has a DBTYPE of "query", and no DATASOURCE. When DBTYPE= "query", ColdFusion executes the query against another query, instead of against an actual data source. The SQL statement itself simply retrieves all data from a table named Movie-Expenses, and sorts the results by Expense. What is MovieExpenses if there is no DATASOURCE being used? It's the name of the first query - the second query is querying the first query instead of a database.

And all this is being processed by ColdFusion itself, not by a database. The second query is processed in ColdFusion, and ColdFusion returns the results itself.

Reusing Queries
And what about the second example above? This first query loads a movie list into a query in the APPLICATION scope:

<!--- Load movies in APPLICATION scope --->
FROM Films
Now how would you execute a search to find the movies that match user specified search text? Look at this next query:
<!--- Find matching movies --->
<CFQUERY NAME="MovieSearch" DBTYPE="query">
SELECT FilmID, MovieTitle
WHERE MovieTitle LIKE ''
Again, the DBTYPE here is "query", and no DATASOURCE is used. The SELECT statement retrieves data from the APPLICATION.Movies query and uses a WHERE clause to extract just the movies matching The result? A brand new query without ever having hit the database.

Working With Multiple Data Sources
Impressed? You should be. But wait, it gets better.

The previous examples all demonstrated code that eliminates unnecessary database calls. And as valuable as that is, this feature really shines in allowing you to perform queries that could not be performed at all with regular queries.

For example, suppose you had data in both Oracle and SQL Server, and wanted to combine the results. How would you do that? Well, prior to ColdFusion 5 you wouldn't have - there really was no way to query multiple data sources. And in ColdFusion 5? Well, look at this code:

<!--- Retrieve movies from SQL Server --->
SELECT FilmID, MovieTitle
FROM Films

<!--- Retrieve reviews from Oracle --->
SELECT FilmID, Review
FROM FilmReviews

<!--- Combine the results --->
<CFQUERY NAME="combined" DBTYPE="query">
SELECT MovieTitle, Review
FROM Movies, Reviews
WHERE Movies.FilmID=Reviews.FilmID
ORDER BY MovieTitle

There are three queries used in this operation - the first queries SQL Server, the second queries Oracle, and the third uses DBTYPE="query" to join the two prior queries into a single result set. The result? A combined query derived from data from disparate data sources.

Simple. And you can't do that with straight SQL.

And Not Just Database Queries Either
As you've seen, in ColdFusion 5, queries may be used as tables. And while all the examples used here have involved database queries, in fact, any queries may be used. Consider these possibilities:

  • Join a <CFLDAP> query and a <CFPOP> query so as to be able to loop through received e-mail along with information about the sender or the recipient.
  • Query a database using <CF-QUERY>, and then perform a Verity search using <CFSEARCH>, and join the results to simplify full text searching.
  • Retrieve messages with <CFPOP>, and join them to a database query based on sender, recipient, or an ID in the subject field.
Regardless of how queries are created (by any tag, or even manually using the Query functions), ColdFusion can execute queries against them. And like any other queries, Queries of Queries may be cached, put into scopes, and even be queried against, again.

Why Query Queries?
So, why bother querying queries? There are several reasons (and no, individual query performance may not be one of them):

  • Joining different data sources
  • Executing SQL statements against nondatabase data
  • Reducing database load (by executing SQL statements in memory instead of hitting the database server)
  • Reducing network traffic (again, by not sending data back and forth unnecessarily)
And as for performance? Don't expect ColdFusion to process queries faster than a database server could. After all, database servers are finely tuned applications designed to do nothing but manipulate data; ColdFusion will never manipulate data as fast as a database server could. But having said that, by helping lower database load and network traffic, querying queries can indeed help overall system performance.

The ability to query queries is a radical and novel concept - and one that many ColdFusion developers have wanted (often without actually knowing what it is they really wanted). Used properly, this feature opens the doors to all sorts of new coding opportunities, and without having to learn any new tags or technologies at all.

About Ben Forta
Ben Forta is Adobe's Senior Technical Evangelist. In that capacity he spends a considerable amount of time talking and writing about Adobe products (with an emphasis on ColdFusion and Flex), and providing feedback to help shape the future direction of the products. By the way, if you are not yet a ColdFusion user, you should be. It is an incredible product, and is truly deserving of all the praise it has been receiving. In a prior life he was a ColdFusion customer (he wrote one of the first large high visibility web sites using the product) and was so impressed he ended up working for the company that created it (Allaire). Ben is also the author of books on ColdFusion, SQL, Windows 2000, JSP, WAP, Regular Expressions, and more. Before joining Adobe (well, Allaire actually, and then Macromedia and Allaire merged, and then Adobe bought Macromedia) he helped found a company called which provides automotive services (buy a car, sell a car, etc) over the Web. (including Stoneage) is one of the largest automotive web sites out there, was written entirely in ColdFusion, and is now owned by Auto-By-Tel.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1


I display all the records of a table in a form with input, drop down list, radio buttons, etc. I want the users to be able to make changes to several of the rows, then click "save" and all rows would be updated. I know how to update one row at a time, but multiple rows? How's about records from multiple related tables? Please help me.



When I use: select sum((IIF([M1]='Yes',1,0))) AS quest1

in a regular query, it works. But when I use the same code in a query of queries, it bombs. Do QofQ not work the same way that regular queries do?

Jon Woodroof
University of Tennessee

Hi. Can someone clear why the sql in QoQ is case sensitive? Even datetime comparison fails without uppercasing both sides of the equation. Why?? Just curious....


I have some troubles using the SQL statement SELECT ... WHERE ... NOT IN (SELECT ....) with Coldfusion 4.0. The second SELECT returns an error. My intention with the statement is finding the difference between 2 query's, there are a few number of records in query 1 which query 2 does not include. These are the records I want to work with. I've tried nested loops (doesn't work), Javascript (doesn't work), using the DELETE statement (is not supported). Please help me, thanks

Wim Maes

Ben could you please help with this..

My intention is to retrieve all worked hours for a user that they have worked and exclude the ones placed against a particular work type called flex leave.
I have the following:


select * from timesheet
where user_id = #session.user_id#


SELECT SUM(hours) as worked_hours
FROM get_user_timesheet
where work_type <> 1

Notes: work_type = 1 is specified as a flex leave

The query of query ignores the where clause and gives a total of the number of hours for the user
regardless of the type.

Please help

Presentation Slides
In his session at 21st Cloud Expo, Michael Burley, a Senior Business Development Executive in IT Services at NetApp, described how NetApp de...
When building large, cloud-based applications that operate at a high scale, it’s important to maintain a high availability and resilience to...
IoT & Smart Cities Stories
Bill Schmarzo, Tech Chair of "Big Data | Analytics" of upcoming CloudEXPO | DXWorldEXPO New York (November 12-13, 2018, New York City) today announced the outline and schedule of the track. "The track has been designed in experience/degree order," said Schmarzo. "So, that folks who attend the entire track can leave the conference with some of the skills necessary to get their work done when they get back to their offices. It actually ties back to some work that I'm doing at the University of San...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science," is responsible for setting the strategy and defining the Big Data service offerings and capabilities for EMC Global Services Big Data Practice. As the CTO for the Big Data Practice, he is responsible for working with organizations to help them identify where and how to start their big data journeys. He's written several white papers, is an avid blogge...
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more busine...
If a machine can invent, does this mean the end of the patent system as we know it? The patent system, both in the US and Europe, allows companies to protect their inventions and helps foster innovation. However, Artificial Intelligence (AI) could be set to disrupt the patent system as we know it. This talk will examine how AI may change the patent landscape in the years to come. Furthermore, ways in which companies can best protect their AI related inventions will be examined from both a US and...
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.
Chris Matthieu is the President & CEO of Computes, inc. He brings 30 years of experience in development and launches of disruptive technologies to create new market opportunities as well as enhance enterprise product portfolios with emerging technologies. His most recent venture was Octoblu, a cross-protocol Internet of Things (IoT) mesh network platform, acquired by Citrix. Prior to co-founding Octoblu, Chris was founder of Nodester, an open-source Node.JS PaaS which was acquired by AppFog and ...
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructure solutions deliver the adaptive architecture needed to manage this new data reality. Machine learning algorithms can better anticipate data storms and automate resources to support surges, including fully scalable GPU-c...
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...

2016 | 2015 | 2014 | 2013 | 2012
This week I had the pleasure of delivering the opening keynote at Cloud Expo New York. It was amazing to be back in the great city of New York with thousands of cloud enthusiasts eager to learn about the next step on their journey to embracing a cloud-first worldl."
How does Cloud Expo do it every year? Another INCREDIBLE show - our heads are spinning - so fun and informative."
Thank you @ThingsExpo for such a great event. All of the people we met over the past three days makes us confident IoT has a bright future."
One of the best conferences we have attended in a while. Great job, Cloud Expo team! Keep it going."


Who Should Attend?
Senior Technologists including CIOs, CTOs & Vps of Technology, Chief Systems Engineers, IT Directors and Managers, Network and Storage Managers, Enterprise Architects, Communications and Networking Specialists, Directors of Infrastructure.

Business Executives including CEOs, CMOs, & CIOs , Presidents & SVPs, Directors of Business Development , Directors of IT Operations, Product and Purchasing Managers, IT Managers.

Join Us as a Media Partner - Together We Can Enable the Digital Transformation!
SYS-CON Media has a flourishing Media Partner program in which mutually beneficial promotion and benefits are arranged between our own leading Enterprise IT portals and events and those of our partners.

If you would like to participate, please provide us with details of your website/s and event/s or your organization and please include basic audience demographics as well as relevant metrics such as ave. page views per month.

To get involved, email

@ThingsExpo Blogs
Having been in the web hosting industry since 2002, dhosting has gained a great deal of experience while working on a wide range of projects. This experience has enabled the company to develop our amazing new product, which they are now excited to present! Among dHosting's greatest achievements, they can include the development of their own hosting panel, the building of their fully redundant server system, and the creation of dhHosting's unique product, Dynamic Edge.
PCCW Global is a leading telecommunications provider, offering the latest voice and data solutions to multi-national enterprises and communication service providers. Our truly global coverage combined with local, on the ground knowledge has helped us build best in class connections across the globe; and especially in some of the remotest, hard-to-reach areas in exciting growth markets across Asia, Africa, Latin America and the Middle East.
NanoVMs is the only production ready unikernel infrastructure solution on the market today. Unikernels prevent server intrusions by isolating applications to one virtual machine with no users, no shells and no way to run other programs on them. Unikernels run faster and are lighter than even docker containers.
Digital Transformation Blogs
In his session at 21st Cloud Expo, Michael Burley, a Senior Business Development Executive in IT Services at NetApp, described how NetApp designed a three-year program of work to migrate 25PB of a major telco's enterprise data to a new STaaS platform, and then secured a long-term contract to manage and operate the platform. This significant program blended the best of NetApp’s solutions and services capabilities to enable this telco’s successful adoption of private cloud storage and launching of virtual storage services to its enterprise market.
Despite being the market leader, we recognized the need to transform and reinvent our business at Dynatrace, before someone else disrupted the market. Over the course of three years, we changed everything - our technology, our culture and our brand image. In this session we'll discuss how we navigated through our own innovator's dilemma, and share takeaways from our experience that you can apply to your own organization.
Founded in 2002 and headquartered in Chicago, Nexum® takes a comprehensive approach to security. Nexum approaches business with one simple statement: “Do what’s right for the customer and success will follow.” Nexum helps you mitigate risks, protect your data, increase business continuity and meet your unique business objectives by: Detecting and preventing network threats, intrusions and disruptions Equipping you with the information, tools, training and resources you need to effectively manage IT risk Nexum, Latin for an arrangement by which one pledged one’s very liberty as security...
"Calligo is a cloud service provider with data privacy at the heart of what we do. We are a typical Infrastructure as a Service cloud provider but it's been des...
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...