I recently asked my Twitter followers if they had good examples of queries, business questions that SQL can't do. It turns out a better question is "what SQL can't do easily", so I thought I'd share with everyone what I heard and found. Seth Grimes was the first one to provide an excellent answer with some informative examples - thank you, Seth! I also found very useful articles on typical SQL challenges such as avoiding multiple duplicate sets in your SQL results, and why NULLs create tons of headaches for SQL coders.
There's also a typical SQL challenge with ragged, sparse, unbalanced hierarchies and dimensions. For example, a retail store, a wholesaler or a distributor with thousands of products, and a manufacturer with thousands of parts often struggle with dissimilar data. A pencil in an office supply store does not have the same descriptive attributes (lead type, for example) as a calculator (scientific, financial, etc.) or an office chair (number of wheels, etc.). Or a tire in a car manufacturing supply chain does not have any common descriptive elements (rubber grade, width-to-height ratio) with gear boxes (automatic vs. manual, 4 or 5 speed, gear-to-gear ratios, etc). When looking for correlation between two entities (for example, what is a potential product quality issue that is making my sales go down?) in cases with disparate, dissimilar products (as in retail products or manufacturing parts), the same SQL query cannot work for all products or parts. One would be forced to write multiple SQL queries for each product or part type to find such a sales/quality relationship.
Among the biggest strategic questions facing eBusiness & Channel Strategy executives are how to make use of the growing potential of the mobile channel, how to integrate mobile phones into their company's multi-channel strategy, and how to meet customers' rising expectations for mobile services.
We have argued that, for most companies, mobile's time has come. Every company needs to have a mobile strategy in place, even if that strategy is to wait until specific things happen before making serious investments.
Most of the eBusiness & Channel Strategy executives that we work with are either directly responsible for, or closely involved in, their company's mobile strategy. So we would like your perspective -- and we'd like to help you benchmark your mobile strategy against that of your peers.
We invite you to take part in a short survey about your company's mobile strategy, your objectives, the metrics you use and the challenges that you face. You can take part in the survey here.
The survey takes less than 15 minutes to complete.
Individual responses will be kept strictly confidential and results only published in aggregate.
In return, we will give you a free executive summary of the survey results.
We're keen to get as wide a sample of industries and geographies as we can, so please feel free to forward this survey through your networks. If you are not familiar with your company’s mobile strategy, but know who is, please forward this survey to them.
I look forward to your perspectives. Thank you in advance for your time.
In my ongoing work with risk management professionals, I've been encouraged to see how quickly the role is growing in influence and responsibility in today's business environment (even though the drivers for that elevation are often disastrous). Along those lines, I read a great article this morning in StrategicRISK, discussing the window of opportunity for risk experts, aptly entitled Keep Your Eyes on the Prize.
The article quotes the Institute of Risk Management's deputy chairman, Alex Hindson, who says that top executives and boards of directors are looking for risk management guidance, and if risk experts in their organizations can't step up to fill that role in their "window of opportunity," it will be filled instead by auditors, finance professionals, or external consultants.
In my recent engagements with Forrester's clients in risk management, I've certainly seen a lot of interest and participation from other functions in the business - most notably audit and IT. And just last week, my colleague Craig Symons published a report explaining key issues in risk management for the CIO.
I'll soon have a client report out with interesting Forrester data about how SOA adoption continued apace during the Great Recession. In the meantime, Forrester partnered with TechTarget on a different SOA survey, primarily to TechTarget's readers, wherein we asked a wider range of SOA questions. The bottom line of all this data is that SOA is alive and well.
SOA's strong health is not a surprise (at least not to Forrester), but something else very interesting came out of the survey. To the question, "What is the most significant challenge you are facing with your SOA project/initiative?" the top response was not really about SOA. Instead, by a 2:1 margin over the next response, the biggest challenge was, "Designing how to do SOA in an integrated way with other initiatives (e.g., BPM, events, BI, rules, etc.)." (I describe this in more detail in a write-up over at SearchSOA.com -- you have to register to read the full article.)
In other words, people are realizing that, in a multi-technology world, siloed approaches to individual technology areas won't cut it. This is the fundamental insight driving Forrester's development of Digital Business Architecture (see Forrester report) and Business Capability Architecture (go to blog post or to another blog post).
Social technology, which includes blogs, microblogging (Twitter), social networking tools, and next-generation collaboration platforms, is a fundamental shift in how businesses use technology. As Forrester describes in Groundswell, your customers are becoming empowered through their use of these technologies, and your business must adapt to this changing relationship. And in our forthcoming book, Empowered, we examine how the people within your business are driving business impact through their use of these same technologies.
Grass-roots experimentation and use by your business’s staff is good – but real business impact is when your business adopts and uses these technologies. This requires your business execs to put in the frameworks, guidelines, coordination, and governance to maximize benefit while prudently managing risk.
Forrester is embarking on research to develop a Social Technology Maturity Benchmark that incorporates these steps. Because maturity will be an important issue for you in your role of charting your firm’s business technology strategy, we’d like your input on this. Colleagues in Forrester’s team serving Interactive Marketing professionals are conducting a survey of both business and IT leaders, including CIOs, Infrastructure and Operations professionals, Sourcing & Vendor Management professionals, and Enterprise Architecture professionals. Here is their introduction to this survey:
Some days ago at Forrester’s IT Forum in Lisbon (June 9-11) I gave a presentation together with my colleague Andy Bartels on the IT market recovery (we predict a 9.3% IT market growth in 2010) after two economically challenging years in 2008/9. In fact, we were making the point that the market rebound we currently see is not simply a recovery but the beginning of a new IT hyper growth phase fueled by a new wave of innovation.
A strong driver of this innovation is what we call Smart Computing at Forrester: the integration of physical world information into intelligent IT-supported business processes in 4 steps: Awareness (via new sensor technology), Analysis (with advanced BI solutions), Alternatives (including rules and process engines) and Action (in industry business applications), plus a 5th feedback loop of Auditability for tracking and learning.
A well-known example of smart computing solutions is smart metering in the Utilities industry. In another presentation in Lisbon, a colleague asked the audience, a room full with all the leading IT service companies, who all had an initiative running with smart metering – everyone in the room raised their hands. Then he asked who actually had more than 1-3 (pilot) projects running – and almost no one raised their hand.
Is smart metering just hype that everyone is jumping on or what is the reality of the lighthouse example of smart computing at this point in time?
Taking a step back, mobile phones have changed the way we live and communicate in the past 10 years. They’ve had a deep effect on society. At Forrester, we believe they’ll change the way companies do business in the next 10 years. Back in 2007, the iPhone created a market catalyst, not only in the way consumers use and perceive mobile phones but also in the way companies engage with their customers in the mobile environment. Since then, a growing number of companies have launched a mobile consumer presence and started to define a road map for their mobile products and services. Some of them are still testing and learning, while many companies are starting to integrate mobile in their corporate strategies, and others have already created dedicated mobile business units and plan to generate millions of €/$ per month in direct revenues. They follow different objectives — whether building brand loyalty, delivering added-value services in a multichannel experience, reducing costs, or acquiring new customers.
Groundswell technology comes to consumers first. At home, we get social, mobile, video, and cloud services pitched to us 24x7. Facebook, Android, iPad, Foursquare, Google, YouTube, Office Web Apps, Twitter. The list is endless and growing every single day. Empowering technologies like these will always come to consumers first. Why? Because it's a wide-open market. A single developer can build an application that changes the world from their broadband-connected bedroom.
All this technology puts tremendous power directly into the hands of your customers. Your customers often have more information than your sales team — or medical staff — does. They can also whack your brand from their smartphone, with video even, while waiting impatiently in line. They can get a recommendation from someone in their business network while listening to your pitch. Customers are empowered by information and connections. You'd better make sure you give customers better information than they can get elsewhere.
The only way to do that is to empower your employees to directly engage the needs and expectations of empowered customers. Only empowered employees can solve the problems of empowered customers.
Fortunately, your employees are not standing still. People are problem solvers. Left alone, your innovative employees (we call them HEROes — highly empowered and resourceful operatives) are building new solutions using these same groundswell technologies — and many others besides — to solve customer problems.
In fact, 37% of US information workers — employees that use computers for work — use do-it-yourself technology to get work done. Personal mobile devices. Unsanctioned Web sites like Skype or Google Docs or LinkedIn or Smartsheet.com. Unsanctioned software downloaded to a work computer.
Last week, I was in Washington working for HP at their Software Universe event. I moderated their customer press conference, had several strategy meetings with HP execs, continued my preview of a new product they’re planning, and even got to play golf with three of their execs. Life can be tough as an analyst!
In the press conference, attended by around 40 journalists from all continents, I encouraged five HP customers to talk about how they were innovating within IT: Neuberger Bergman, Seagate, McKesson, Blue Cross and Blue Shield of Florida, and CollabNet. My challenge as moderator was to help these spokespeople bring across their messages (not everyone is a public speaker) and ensure that there was some “news” for the journalists to write about. So I kicked off the session with a Forrester slide with these five trends/challenges in IT. Each customer then spoke to the trend that affected them the most:
Virtualization and "cloud" adoption adds to complexity of IT management
Continued pressure to prove the business value of IT
Automation of optimized processes within IT
Understand and measure IT delivery in business terms
Agile development brings Business, AppDev and IT Operations closer together and coordinated
Java's future is on my mind lately. Oracle's new ownership of Java prompts a series of "what will Larry do" questions. But more to the point, the research Mike Gualtieri and I have been doing on massively scaled systems makes me worry that Java technology has fallen behind the times.
This is not a "Java is dead" commentary but rather a discussion of issues as I see them. Java technology is alive and vitally important; we all must be concerned if its future direction isn't clear.
For me, Java's 2-gigabyte-per-JVM memory limitation symbolizes this gap. Volumes of application data are rising, but standard Java platforms still have a practical limitation of 2 GB of memory. I spoke with one customer that incorporates a search process into its app that alone requires 20 GB of memory. This customer employs servers with 6 GB of memory each but can only use this memory in 2 GB chunks, each chunk managed by a JVM in a scale-out architecture.
We've done pretty well with 2 GB JVMs until now. But as data volumes grow, this company (and others) are no longer well served by scale-out JVM architectures. Java technology should give shops the choice of scaling up the memory within an individual JVM as well. Why?