The data model is critical, but far too often overlooked with system procurements, especially in the realm of cloud solutions when the database isn’t on your server. Here’s why.
The data foundation
Applications that are rich in structured data – think CRM, billing, accounting, HR, manufacturing or logistics solutions to name just a few – typically persist their data in a relational data model. The data model is the very foundation of a data-rich app and, like the foundation of a house, doesn’t change readily and requires a significant effort if changes are required. A major data model change requires a migration of data from the old to the new structure, which can be costly and disruptive. It may also demand a change to the application code that reads and writes data to and from the data model, again involving time, cost and disruption.
The balancing act
As well as being foundational, all data models are a compromise. No model can be perfect and each is a balancing act between simplicity and flexibility; the more flexible, the less simple. Most data models in transactional systems (i.e. those systems where data is entered regularly) are optimised for ease of input and maximum integrity of data. The pursuit of these virtues necessarily results in numerous related data entities (known as tables in most databases, or often objects in cloud solutions), the logic of which needs to be understood, especially if you’re planning to customise or integrate.
You must ensure that the balance struck by the data model in your chosen solution is sensible and matches the business rules of your organisation. For example, a billing solution may, for the sake of simplicity of data entry, structure its data such that an invoice always relates to a single parent order. If, however, your business issues periodic invoices that span multiple customer orders, you’ll either need to adapt your business practice to the solution, or opt for a more flexible tool. Either way, you’ll want to assess the time and cost implications of that at the evaluation stage, not during or after the system implementation.
Find a good data architect
Sophisticated data-rich systems may have many dozen or even hundreds of data entities, such that assessing the simplicity-vs-flexibility balance can be a major undertaking. For on-premise solutions, a knowledgeable DBA is often on hand to help, given that he/she will take responsibility for the installed database. But for cloud database apps, too often a DBA or data architect isn’t consulted at the evaluation stage. The good news is that the skills needed don’t change between the on-premise and cloud worlds, despite the fact that with the cloud app, direct access to the database tables isn’t typically allowed. The DBA or data architect you’ve relied on previously should be well up to the task of assessing a cloud data model.
Transparency vs IP protection
With packaged solutions, on-premise or cloud, some vendors may be unwilling to share details of the data model with you for reasons of intellectual property protection. A lack of transparency in this area should raise a red flag in your evaluation. Confident cloud vendors will share their data model with you, safe in the knowledge that the model alone is far from enough IP for you to reverse engineer their product. For example, salesforce.com openly shares their data models on their developer website, setting a minimum benchmark that you should expect.
Universal models
The other good news to note is that with relational databases having been around for decades, standard – or “universal” – data models have emerged for routine business functions and common industries. Universal data models are tried and tested over many years and hundreds of implementations, so provide an ideal blueprint against which to compare your cloud vendor’s offering. For example, if you’re buying an accounting solution, detailed universal models exist for handling the chart of accounts, transactional entries and the general ledger, so if your vendor’s solution deviates majorly from them, you’d be entitled to ask why. A wonderful source of universal data models is the range of books written by Len Silverston – bibles for data architects.
The data model is the core of your data-rich cloud solution, so I hope these tips will help you to ensure it’s up to scratch.
In the horse race of cloud computing, how do you pick the stayer from the nag? The stallion from the gelding?
When not constructing metaphors spanning equine sports and enterprise software (a pointless vocation with few prospects), in my day job I have the pleasure of helping clients navigate their way through the pre-race field of preening cloud vendors and their flighty solutions.
Invariably the clients’ IT departments furnish them with a dusted-off standard checklist for evaluating new software offerings, covering the usual points around functionality, usability, reliability, performance, security, support and the like. In the rapidly evolving world of cloud computing, however, these checklists, while definitely necessary, are insufficient.
Public cloud solutions are typically well presented, with the underlying technology shrouded in very pretty user interfaces and sophisticated APIs. With the application’s code and database being hosted elsewhere, and the purchase often made without the involvement of the IT department, it’s all too easy to omit the detailed design checks that have been routine in the evaluation of on-premise systems for decades. On a positive note, the constant enhancement paradigm offered by public cloud solutions (as opposed to the optional, infrequent upgrades of traditionally purchased software) presents a huge opportunity for customers to ride a wave of continual improvement if they choose the right vendors and products.
To meet these challenges, over the coming weeks I’ll detail here some important evaluation criteria aimed specifically to help with the procurement of cloud technologies. Armed with these tricks, you’ll improve the odds of placing your wager on the firm favourite every time.
I mentioned last week my impending appearance on Sky TV’s Technology Behind Business.
Thanks for everyone’s topical suggestions, of which I certainly mentioned a few in my responses. The 10 min segment can be seen on the website now so take a look.
We talked CRM, cloud, social media and customer service and I can only assume (until I see evidence to the contrary) that we were a huge ratings success.
Last week we announced that the test drive of Myriad Share for Financial Advisers is available. But even easier, take a look at this quick 3 minute demo to get an overview of some of its features. Go for full screen (click in the bottom right of the video) to get all the detail.
I’ve been invited to appear as a panellist on SkyTV’s Technology Behind Business. This episode is titled “Has CRM failed?”, which of course attracted me like a particularly appealing red rag to an already jumpy bull.
The show airs on the Sky News Business channel at 9:30pm (Australian east coast) on Friday 15 April, but is also repeated at 10am Saturday and 9:30am Sunday, and is available on the website afterwards. At the Friday night slot, we’re competing on cable with Ultimate Fighting and 60 Minute Makeover, so if we lose your interest, flick over and watch people’s faces get mangled in one of two different ways.
I’m not short of opinions on the topic of CRM, but if you have any killer points you think need an audience, I’d love to hear them, so feel free to drop me a line.
After a lot of hard work in recent months, I’m very proud to announce that Myriad Share for Financial Advisers is now available to test drive.
Myriad Share is a fully configured client portal to allow business to share key documents with clients. It’s built on the Force.com platform and comes with its own embedded Force.com licence, so you don’t need to be an existing Salesforce customer to get started.
Myriad Share for Financial Advisers takes the core functionality of Myriad Share and adds specific professional relationships and document workspaces, allowing an adviser’s client to share documents with their other professional consultants, such as their accountant and solicitor. It’s ideal for financial advice practices looking to add a lucrative value-add to their existing service offering.
We’re thrilled to have the product available and if you’re interested in a free trial, drop us a line or contact us here. Or if you’d like to test drive the demo version, just follow the instructions at http://bit.ly/myriadsharetestdrive.
Myriad Share for Financial Advisers is the first module of our financial advice practice management suite, so keep a lookout for further module announcements.
Philippa Yelland has published an article on cloud computing in the investment and superannuation industry in this month’s Investment Magazine.
It starts off a tad doomsday-esque with an image of a dark, ominous sky and the headline “Storms Gather in the Cloud” (OK, so a lot doomsday-esque), but when you read the fine print, the point is that cyber theft is a risk for any online system. Moreover, the major cloud vendors often have the most robust infrastructures because (a) they do it for a living; and (b) they’re under constant scrutiny by their enterprise clients. I chimed in briefly to challenge APRA’s recent focus on cloud and to suggest that their concerns are equally relevant to on-premise solutions, and to challenge that cloud is inherently the riskier proposition.
Have a read below. (We’ve even turned the magazine to the right page for you using Issuu‘s rather neat Flash component)
A further thought following my attendance at TechLines last week.
You’ll recall I mentioned James O’Loghlin’s lawn mower analogy. I thought it worth fleshing that out a little with reference to those most nebulous of cloud computing terms: private cloud and public cloud.
A private cloud approach to the lawn mower conundrum would be to build a better shed to house the mower, or perhaps to build a big shed that could store all of the household tools you own so as to free up some extra space in your house. Great, but it doesn’t change the fact that you still have to fix the mower when it breaks (and you’re hardly an expert on mower maintenance) and the mower will still depreciate over time; you still own the mower. Moreover, your ability as a lawn mower has plateaued at “average” and frankly, you’d rather be spending your time on the things you’re actually really good at, like watching reruns of Miami Vice (right from episode 1, when Crockett still had that sweet ’72 Ferrari Daytona Spyder).
A public cloud approach would be to turn the traditional lawn mowing paradigm on its head. Instead of each suburbanite in the neighbourhood owning a mower and mowing their own lawn, a public cloud mowing service would mow everyone’s lawn. The mowers would be experts in their field, with an inexplicable penchant for the noble art of grass topiary. The mowers would continually hone their skills and equipment further, allowing for not only faster, better mowing, but a range of related services, such as hedge-trimming, planting and advice on the latest techniques in lawn cultivation. The suburbanites would subscribe based on the size of lawn and frequency of required service, whilst the quality and breadth of results would far exceed the “average” level of the old approach. Most importantly, Miami Vice would be enjoyed right through until Crockett gets amnesia, forgets he’s undercover and nearly kills his partner Tubbs (surely the shark-jumping moment of the series).
So if you want to build a better shed, then fine. But be aware that there may be a more inspired option.
Last week I was invited by our friends at n2n communications to attend ZDNet Australia’s TechLines second broadcast, on the topic of cloud computing. TechLines is described as “a series of live broadcasts on top-of-mind tech issues facing today’s IT professionals” and was streamed live on ZDNet’s site. For those of us not involved day to day in the media, it had an element of glitz about it, what with TV cameras, support crew buzzing around and James O’Loghlin (of ABC’s New Inventors fame) as the host. In fact it may be the most glamorous event I’ve attended since I was privileged enough to be an audience member for the filming (before a live studio audience, no less) of an episode of Hey Dad in 1990. But I wistfully digress.
The event was high quality and the panellists were engaging, particularly Mark Pesce (who needs to be pretty engaging with a job title as bold as “Futurist”). Analogies were well employed to bring an ostensibly nerdy topic into the layperson realm. For example, James drew a parallel between cloud computing and his ownership of a lawn mower: he only uses it once a month, but owns it 365 days a year, whereas if there were a convenient way of simply obtaining its services for the few dozen hours each year that he actually needs them, he’d surely be better off.
The discussion migrated fairly quickly, though, from that consumer-led basis to an emphasis on private clouds. Perhaps it was due to the cloud vendor representation on the panel consisting only of Microsoft and IBM, but the discourse became a little bogged down in back-end IT efficiencies. Great fodder for CFOs and supply-side-focused CIOs, but largely ignoring the elephant in the room that is the consumer-led public cloud.
Let’s be clear. “Private cloud” is a flash name for restructuring your infrastructure arrangements, nothing more. It’s an incremental step and I get its appeal, but the consumer-led revolution that’s happening (that’s happened, in fact) in the public cloud is the real game changer.
I worry a little that whist some CIOs and management teams ponder over incremental change, their staff and customers are already leading the change by demanding that the usability, seamless upgrades, reliability and, frankly, enjoyment that they experience every day on Facebook, Google, Twitter and YouTube set the standard for enterprise computing. Of course, every corporate IT decision needs to be risk-conscious and make financial sense. But many of the leading cloud computing solutions, whilst hitting the ROI metrics for senior management, also provide rich, ever-improving features that can be a source of tremendous motivation and inspiration for users. With that can come productivity gains to eclipse even the biggest server move.
Did you miss Cloudstock? This first of its kind event brought the top cloud developers and the top cloud technologies together under one roof. If you missed a session, or if you weren’t able to come to Cloudstock, here is your chance to enjoy the event online.
Cloudstock was organized by Salesforce and the event drew a who’s who of cloud technology providers. There were 65+ sessions with a goal, “to bring the top cloud developers and the top cloud technologies together under one roof, to learn from each other, collaborate, innovate, and drive the future of cloud computing.”
The massive scale of the event makes it difficult to watch all the recorded sessions, so I’ve noted my favorite sessions below. Enjoy!
As well as being foundational, all data models are a compromise. No model can be perfect and each is a balancing act between simplicity and flexibility; the more flexible, the less simple. Most data models in transactional systems (i.e. those systems where data is entered regularly) are optimised for ease of input and maximum integrity of data. The pursuit of these virtues necessarily results in numerous related data entities (known as tables in most databases, or often objects in cloud solutions), the logic of which needs to be understood, especially if you’re planning to customise or integrate.
With packaged solutions, on-premise or cloud, some vendors may be unwilling to share details of the data model with you for reasons of intellectual property protection. A lack of transparency in this area should raise a red flag in your evaluation. Confident cloud vendors will share their data model with you, safe in the knowledge that the model alone is far from enough IP for you to reverse engineer their product. For example, salesforce.com openly shares their data models on their developer website, setting a minimum benchmark that you should expect.
Blog