“1 Overview Master Data Management refers to key reference information about customers, products, vendors, employees, organisational units, accounts, etc. Master Data Management is about bringing the multiple variances of the key data elements into a single harmonised data set so that everyone has the same view of the world. Once harmonised this key data is needed by an organisation at an operational level and from a leadership perspective. It allows consistent answers to management questions… The council had recently implemented a Customer Service Centre in partnership with Pearson eGovernment Solution which is supported by a SAP Customer Relationship Management (CRM) System. The CRM system holds data on the Council’s customers and properties. Each back office department within the Council also holds the same customer and property data multiple times in differing formats and differing states of completeness/accuracy in the many IT systems that support the delivery of services across the organisation. The Problem: • Data on a single customer/property is held multiple times in the same system. • Data on a single customer/property is maintained in multiple systems in multiple formats. • Data on a single customer/property is going to be held in varying degrees of accuracy and consistency. • The Council needs to understand the relationship that a customer has with the property in order to improve service delivery. • It is not possible to deliver truly joined up service delivery if each of the departments/services are using different instances of the Master Customer. The Solution: • Bring the multiple customer/property data sets together, using MDM cleanse and match each data into two distinct Master Data sets the customers, property and establish a relationship/link between them…. 2.1 Project Objectives The purpose of this document is to define the scope Phase 1 of this project so that a total fixed price can be calculated enabling LBS to make a checkpoint Go/go decision for this project. The project will decide whether to proceed on the merits on the benefit is realised in Phase 1 alone, therefore the deliverables in Phase 1 must be achievable and provide sufficient business benefit. Project Objectives: To obtain a complete master data set for customers and properties within Southwark. To provide a system for maintaining (and where required establishing) the relationships between customers and properties. To realise operational efficiencies in the maintenance of Master Data. To provide the infrastructure for ID Management/Authentication for customer self-service through Government Connect. To provide the capability for a 360 degree view of the customer within the Data Warehouse. 3. Project Scope 3.1 …It it should be understood that the scope of this project is to build the basis for developing a consistent master data set for the entire organisation. It should not be assumed that this initial project would encompass all the business process changes required. This project will not be implemented in a big bang approach but rather through an iterative process solving a specific business need… Outline Phase 1 Deliverables Must Have: 1) Infrastructure & environment setup of MDM components in the current LDS landscape 2) Configuration/ Development of the property data model/scheme in MDM for Southwark properties to define… 3) Configuration/Development of the customer data model/scheme in MDM for Customers… 4) Data consolidation identification & merging definition… 5) Data Cleansing & consolidation of data imported from LBS Strategic applications: 6) Data rules, validation duplication definition 7) People property linkage & integration in the MDM Data model 8) Import customer data from the following 4 strategic applications for Southwark Master customer data set: eReg… CRM… NNDR… iWorld… 9) Import property data from the following 4 strategic applications for Southwark Master property data set: LLPG… CRM… iWorld… 16) Definition of MDM user roles & authorisations… Would Like To Have: 18) Using the cleansing and de-duplicating functionality of MDM merge where possible all duplicate customer records and reassign service tickets…”
“IBM will provide the following assistance services… under this Order to help you implement phase 1 of your project known as the "Master Data Management (MDM) project" which aims to prepare an application that is able to provide a master cross reference index in order to give you a joined up view of person and property across your 5 [source] systems…”
“We are moving swiftly ahead with the implementation of our MDM project but I am concerned about the non-involvement of Orchard information systems, especially as we are close to procuring hardware for the Accential [sic] part of the implementation. Having had conversations with Serco and Orchard, it has been made obvious that we need to engage with Orchard ASAP. I have tentatively agreed to have Simon [Leventhal] come down for technical discussion on data and sizing end of this week… James [Orrom], please arrange and confirm and make sure all the relevant people at present. Serco will not be going ahead with procurement of any hardware until we have a complete picture of the whole infrastructure. Also, could we confirm the current state of Orchard contract? Where is the hold-up? Southwark”
“I’m starting to get to grips with what is going on at Southwark and spent Friday with Orchard, the supplier of the matching product they have here, Arcindex. I have to say I was a little disturbed at what I was shown, there is no real user interface for resolving matches, and a very limited one for searching. The matching strategy they employ means you have to do several match passes to identify all the matches for a record, which we both know requires far more manual effort to produce a clean index. Basically the way it works is once an exact match is found for a record in a match run it starts and doesn't look for any further matches, potential or exact. They also have not got any production Web services available yet to support integration…oh no, not that one again. On the plus side, their matching rules seem to be far more flexible than MultiVue’s, they can do date range matches, nicknames etc, although I've not had chance yet to put it to a test to see how well it does the job. They have used IBM, datastage as the basis for their matching engine, so in theory it should work. I never thought I'd say this, but based on what I've seen so far, MultiVue, at present, is a more advanced product. Anyway, I would like to take your offer up and come for a visit. It would be really useful to show Alison & Mike what a proper matching product looks like -I’m assuming Initiate has a decent UI [User Interface] to enable the resolution of matches? Given you and Mike are both on crutches, when would be a good time to come and visit you?”
“Just to confirm, the current short term plan plan [sic] for the ‘keep Orchard and enhancement it’ option is 1) Alison to supply strategy/Vision statement for MDM going forward beyond phase 1, to enable us to consider how we want to use Orchard in the longer term 2) Clare to produce a list of the evaluation criteria by end of tomorrow to give to Orchard, taking into account know [sic] gaps, Alison vision and Brent tender document. Objective being to use this document as a basis to identify gaps in the product, cost out these gaps in terms of Orchard Cost, our time and how long it will take to deliver and hence gain a better understanding as to how much it will cost to get Arcindex to do what we want to do. 3) Meeting with Orchard on 16th July, to start the above gap assessment process 4) Agree next steps and timeframe We will need to cost the other options as well…”
“View old matches generated from a particular match run: exact, potential and non-matches with the ability to resolve potential matches on screen by the click of a button. Full details of the two records performing the match must be available to allow the user to make a judgement as to whether to match the records or not without navigating away to another screen. Also require to be able to enter notes against a potential match for cases where it cannot be immediately resolved… Resolving Matches For a match run need to be able to view: -exact matches i.e. matches that score above a threshold -possible match clients/business -unmatched clients/businesses”
“…One thing to mention is that a lot of the functionality etc is delivered in combination with Orchard and IBM software, so where Orchard may not have the capability, the requirement is delivered by IBM! If you have a minute I can explain more about this…”
"The Arcindex product in its current form does not adequately support the MDM function that LBS is planning to put in place, both from an operational and technical point of view. At the time of purchase, it was known that Arcindex did not support integration to other applications and some budget was put aside to enable this to occur in the second phase of the project. The product was recently reviewed and was found to be deficient in a number of other areas…namely the user interface, which seriously impacts the implementation of the first phase of the MDM project. The tool is currently focused more towards the technical user, with a strong knowledge of SQL and is not designed to support the manual resolution of a high volume of potential matches which inevitably there will be with LBS records. The approach to identifying matches is also of some concern, the matching cycle for a record stops once an exact match is found rather than continuing to find all the possible matches for a record. This [area] will need further analysis and testing to fully assess the gravity of the issue.” She identified certain mandatory application requirements which included "potential matches" and a mandatory integration requirement for the products to be able "to accept records in real time from source systems to maintain the index concerned"
“Had a successful day yesterday, we loaded with the majority of records from the extract file, matched it and found a significant number of exact matches i.e. record duplicates. I’m still analysing the results, but should be able to pass a report to you of records requiring attention by the end of next week. As mentioned before, this will by no means be a list of all the duplicates you have, due to current limitation in the matching application and a lack of time and resources, however it should certainly improve your dataset on what it is at present.”
“Business is engaged and supportive of the MDM initiative, however the proposed MDM programme does not have a specific business sponsor although some individual projects do; Hardware framework is in place to support and MDM environment and the data integrity team required to manage the operational management of MDM has been designed and approved; There are a number of significant gaps in the functionality provided by the existing MDM solution procured to support MDM project phase 1, mainly due to a lack of definition of MDM’s requirements and defining strategic programme of work; MDM’s scope was incomplete and integration of MDM to other systems was not fully considered; Data integration strategy and infra structure required to support the strategy needs to be defined. In light of these findings, it is recommended that LBS procure a new solution ‘fit for’ purpose." The draft review also identified that QualityStage provided by IBM was “the matching engine used by Arcindex to match the loaded data files.”
“Workshop Findings • Determine if there is a feasible solution to support Southwarks MDM’s requirements with the current Web Sphere modules purchased purchased The current solution will not support realtime integration nor will it support any matching capabilities as QualityStage (the matching engine) requires a front-end to invoke its matching capabilities. In order to support any matching capabilities a new matching tool would need to be purchased or Arcindex would need to be enhanced. Datastage and ProfileStage could be retained to support the extraction of data from source systems in batch to the database of the matching tool… • Clarification of whether Websphere modules are functionally appropriate to support Southwark’s realtime integration needs The version of Datastage implemented only supports batch transactions, in order to support event triggered transactions it will be necessary to purchase a product called CDC at an additional cost…” • Determine if there is a feasible solution to support Southwarks MDM’s requirements with the current Web Sphere modules purchased purchased The current solution will not support realtime integration nor will it support any matching capabilities as QualityStage (the matching engine) requires a front-end to invoke its matching capabilities. In order to support any matching capabilities a new matching tool would need to be purchased or Arcindex would need to be enhanced. Datastage and ProfileStage could be retained to support the extraction of data from source systems in batch to the database of the matching tool… • Clarification of whether Websphere modules are functionally appropriate to support Southwark’s realtime integration needs The version of Datastage implemented only supports batch transactions, in order to support event triggered transactions it will be necessary to purchase a product called CDC at an additional cost…”
“In light of the above facts or failure of IBM to resolve this matter and fulfil its obligation under Contractual Agreement with the Council, failure of which is a breach of contract, the Councils right to terminate the Contract and commence legal proceedings against IBM for damages and costs will become exercise and will within the next 7 day [sic]”
“The Councils [sic] is therefore terminating the Contract and commencing legal proceedings against IBM in order to recover the costs and damages for Contractual breach within the next 7 working days, unless we receive an adequate response.”
“This Order specifies all the variables necessary for the completion of an ICT Goods and Associated Services contract”
“IBM will supply the following Third Party Software: Orchard’s arcindex - Person & Property Database under Orchard’s Software Licence Term’s defined in Appendix A”
“These services will be provided by Orchard and will involve the installation and configuration of the software on the licensed environments. Orchard will provide services to enable implementation of the master database project. Implementation will involve training and transfer of arcindex skills (including data standardisation, matching and administration) to key Southwark personnel with the objective of Southwark being in a position to go live with the software and ultimately be self-sufficient once the transfer of skills is complete. Further details are defined in Appendix C. 89. By Paragraph 1.3, Orchard was to "have an ongoing responsibility to provide arcindex software support in accordance with Orchard’s Support and Maintenance agreement as defined in Appendix B. Paragraph 1.4, entitled "Contractor’s Responsibilities" stated: “IBM will assist you by providing the resources as set out in the Charges section 6.”
“arcindex one-time charge……£57,000.00 ”
"Any warranties and indemnities relating to the Program specified in Clause 1.1 are the responsibility of the vendor. The vendor will provide the warranty in Programs in related Services in accordance with the License terms in Appendix A of this Order. There are no additional IBM warranties, and any implied condition or warranty of merchantability or fitness for purpose are excluded.” 81. Above the signatures on the order the following appears: “By signing below you agree that the Order specifies all the information necessary for the completion of an ICT Goods and Associated Services contract and we agree that a contract has been formed using the terms and conditions in the Model contract, augmented by the information provided in the Order, such information being replicated or referenced in that statement.” 82. Appendix A related to Orchard’s licence, relevant parts of which are as follows: “1.1 Orchard hereby grants to the Customer a non-exclusive perpetual licence to use the Software on the terms and conditions contained herein… 6.1 Orchard undertakes that, provided it is operated in accordance with Orchard’s instructions, the Software will be virus free, and will perform in accordance with the specification (Appendix D). Orchard does not guarantee that the Software is free of minor errors not materially affecting such performance. 6.2 The Customer acknowledges that the Software has not been prepared to meet its individual requirements. Orchard shall not be liable for any failure of the Software to provide any facility not specified in the specification. 6.3 Except as specifically set out in this Agreement, Orchard has made no commitment to develop, modify or enhance the Software to meet the individual requirements of the Customer. Where Orchard agrees after the date of this Agreement to carry out any additional software development, including but not limited to any such development identified during the course of implementation as a "go-live" requirement, the specification must be agreed between the Customer and Orchard no later than 20 weeks before the Software is scheduled to "go live"… 8.1 Title, copyright and all other proprietary rights in the Software and the Documentation and all parts and copies thereof shall remain invested in Orchard” The "
“A key requirement for the Customer is to be able to effectively manage multiple relationships between their properties and population. This was highlighted during initial application demonstrations. This functionality is now available in the Software.” 84. Appendix D although entitled "Application features" is referred to in Paragraph 6.1 of Appendix A of the specification. Although no breach of Appendix D is pleaded, it does identify broadly what is to be provided by Arcindex: “Oracle with Web browser front-end and utilising the Java programming technology. A single view of customers/addresses that exists in many different corporate databases. The single view enables the storage of all back-end reference codes to that person/property in one location. . The ability to bulk-match data from many back-end corporate applications into a master database. . Matching of data by using matched passes that allow sub-setting of potential matches. . Facilities to enable successful matching between datasets that have very different ways of storing data. . Keep a history of when individual data sets were matched to each other-whether this is by way of an initial bulk match into the database or by a periodic update. . Allow non-matching incoming data records to be manually reviewed by an administrator and be manually matched into the database. . The customer can build up extensive matching algorithms by using fuzzy matching and uncertainty word comparisons. Weightings are used to allow a threshold to be set, thus enabling cut-off points to be set that will accept or reject potential matches. . Extensive data searching facilities with access to comprehensive SQL based searching.”
“2.1 This Contract governs the overall relationship of the Contractor and a Customer with respect to the supplier of the Ordered Goods and the provision of the Ordered Services. The Customer has ordered the Ordered Goods specified in Schedule 2-2 and the Contractor shall supply those Ordered Goods: 2.1.1 in accordance with the provisions of this Contract if those Ordered Goods are to be sold by the Contractor and purchased by the Customer; and 2.1.2 in accordance with the provisions of this Contract and any other terms and conditions as are agreed between the Customer and the Contract and any third party (if any) if those Ordered Goods are to be leased to the Customer. 2.2 The Contractor shall supply the Ordered Goods and provide Ordered Services in accordance with the provisions of this Contract… 12.1 The Contractor warrants and represents that: 12.1.5 the Ordered Goods (and all components thereof) and the Ordered Services are: of satisfactory quality; in conformance with the relevant specifications set out in this Contract, relevant Order and the manufacturer’s specifications and documentation; and free from material programming errors and material defects in design, manufacture or materials throughout the applicable warranty period, as specified in the catalogue…” 12.3 Except as expressly stated in this Contract, all warranties and conditions, whether express or implied by statute, common law or otherwise (including fitness for purpose) are hereby excluded to the extent permitted by law. 33.2 Neither the Customer nor the Contractor has relied upon any representation or promise except as expressly set out in this Contract. of satisfactory quality; in conformance with the relevant specifications set out in this Contract, relevant Order and the manufacturer’s specifications and documentation; and free from material programming errors and material defects in design, manufacture or materials throughout the applicable warranty period, as specified in the catalogue…”
“For the purposes of this Act, the quality of goods includes their state and condition and the following (among others) are in appropriate cases aspects of the quality of goods— (a) fitness for all the purposes for which goods of the kind in question are commonly supplied, (b) appearance and finish, (c) freedom from minor defects, (d) safety, and (e) durability.” (a) fitness for all the purposes for which goods of the kind in question are commonly supplied, (b) appearance and finish, (c) freedom from minor defects, (d) safety, and (e) durability.”
“1 (1) This Act applies to contracts of sale of goods made on or after (but not to those made before)1 January 1894 . 2 (1) A contract of sale of goods is a contract by which the seller transfers or agrees to transfer the property in goods to the buyer for a money consideration, called the price. 14 (1) Except as provided by this section and section 15 below and subject to any other enactment, there is no implied [term] about the quality or fitness for any particular purpose of goods supplied under a contract of sale. (2) Where the seller sells goods in the course of a business, there is an implied term that the goods supplied under the contract are of satisfactory quality… (2B) [set out earlier in this judgment]. (2C) The term implied by subsection (2) above does not extend to any matter making the quality of goods unsatisfactory— (a) which is specifically drawn to the buyer’s attention before the contract is made, (b) where the buyer examines the goods before the contract is made, which that examination ought to reveal… (3) Where the seller sells goods in the course of a business and the buyer, expressly or by implication, makes known— (a) to the seller, or (b) where the purchase price or part of it is payable by instalments and the goods were previously sold by a credit-broker to the seller, to that credit-broker, any particular purpose for which the goods are being bought, there is an implied [term] that the goods supplied under the contract are reasonably fit for that purpose, whether or not that is a purpose for which such goods are commonly supplied, except where the circumstances show that the buyer does not rely, or that it is unreasonable for him to rely, on the skill or judgment of the seller or credit-broker. 61 (1) In this Act, unless the context or subject matter otherwise requires,— “goods” includes all personal chattels other than things in action and money…” (a) which is specifically drawn to the buyer’s attention before the contract is made, (b) where the buyer examines the goods before the contract is made, which that examination ought to reveal… (a) to the seller, or (b) where the purchase price or part of it is payable by instalments and the goods were previously sold by a credit-broker to the seller, to that credit-broker, “goods” includes all personal chattels other than things in action and money…” 95. A preliminary question to consider is whether the Arcindex Contract was a contract for the sale of goods at all. That involves a consideration first as to whether under Section 2(1) there was to be a "transfer" of "property in goods" and secondly whether "goods" were being sold. I have formed the view that there was here no “transfer” of property in goods for the purposes of the 1979 Act. The Order talks about IBM "supplying" the Arcindex software "under Orchard’s Software Licence Terms defined in Appendix A" and there is a money consideration (£67,000 ). What was provided by IBM was in effect a licence from Orchard to Southwark to use the software and, therefore, there is no transfer of property. Although the licence is expressed by Appendix A to be a "perpetual licence", this is said to be a licence "on the terms and conditions contained" in Appendix A. Some of these other terms in Appendix A point strongly to there being no transfer of property in the software. Clause 8.1 specifically talks about "title, copyright and all other proprietary rights in the Software” remaining vested in Orchard. Because copyright is identified as a specific right being retained, the use of the words "title" and "other proprietary rights" suggests strongly that ownership rights are retained. The termination provision in Clause 10 requires Southwark to return at Orchard’s request or destroy all copies, forms and parts of the software covered by the licence. Again that points to property in the software remaining all the time with Orchard. The licence was subject to other restrictions; for instance by Clause 3 of Appendix A it could only be used by Southwark and any "commercial partners". The software by Clause 7 was not to be modified without Orchard’s consent. 96. It is therefore unnecessary to decide whether software can be “goods” for the purposes of the 1979 Sale of Goods Act. There is no binding authority which Counsel or I have been able to find on this topic. However, my view, which is necessarily obiter, is that in principle software could be "goods" within the meaning of that Act. I base this view on the following: (a) Although a CD (compact disc) with nothing on it is worth very little, there is no restriction in the Sale of Goods Act on any goods being excluded from the Act by reason of their low value. CDs are physical objects and there is no reason why they should not be considered as goods. (b) The fact that a CD is impressed with electrons to add functions and values to it simply gives a CD a particular attribute. Thus, if a customer buys a music CD with a Beethoven symphony or a Mumford & Sons album on it, it must be "goods” and it should, if new, be of satisfactory quality. There can be no difference if the CD contains software. (c) The definition of "goods" is expressed to be an inclusive rather than an exclusive one. Put another way, the Act is not excluding anything which might properly be considered as goods. It follows that "goods" are not simply "personal chattels", although a music or software CD may also fall into the category of being a personal chattel. 97. So far as this issue is concerned, one will need always to examine the contractual terms pursuant to which the customer acquires the software. If, as here, it is simply a licence to use that is being granted albeit for a money consideration, there may be no transfer of property. In principle, a licence to use, if that is all it is, may well not transfer any property or title in the goods in question. However, if the arrangement between the parties can be said to involve the transfer of property to the buyer, I see no reason why in principle software that is so transferred can not be "goods" for the purposes of the Act. There is in reality only one authority by way of an obiter remark against this view. In St Albans City and District Council v International Computers[1996] 4 All ER 481 , Sir Iain Glidewell said: “…in order to answer the question, however, it is necessary to distinguish between the programme and the disc carrying the programme. In both theSale of Goods Act 1979 section 61 and the Supply of Goods and Services Act personal chattels other than things in action and money…”
“7. We agree that a major purpose of the project was to improve data quality and remove duplicates. The de-duplication within a single database was a reasonable objective. 8. From the results of the tests that were run at Southwark, we agree that a better mechanism of resolving duplicates would have helped… 10. ProfileStage and DataStage were not used in the test runs done by Southwark in August 2007. 11. ProfileStage would have given information about Southwark’s data and allowed improvement of the matching. We agreed that the matching rules used for the test could have been improved… 12. Some data cleansing could have been conducted in DataStage but not de-duplication, which requires matching of records which is a function of QualityStage… 14. Southwark did not use QualityStage directly for the tests - only through ArcIndex. In other words the user interface to QualityStage was that provided by ArcIndex. Using it this way, Southwark was limited to the functions supported by ArcIndex. 15. As far as we can tell, ArcIndex functions as described in the ArcIndex User Manual and we agree as to how it works and which of the functions relevant to the case it does or does not do. 16. A tool can assist in de-duplication by finding identical or similar records in a database. Whereas identical or near identical can be automatically regarded as duplicates, records that are just similar need to be reviewed before they can be considered as duplicates. It is the latter similar records or potential matches that lead to clerical review. 17. ArcIndex supported a clerical review process to allow the review/resolution of unresolved matches (and unhandled data) but the only way to review potential matches was to read a textual report which could be viewed on screen or printed out. 18. The textual report produced during the test runs in the whole CRM was large but we agree that the amount that needed to be reviewed could have been reduced by manipulation of the rules, for example by setting pass 1 tight (corresponding to definite duplicates/exact matches) and pass 2 loose (corresponding to potential matches). [Note 2 stated that this was "the situation using ArcIndex for de-duplication".] 19. We also agreed that, if the matching rules are set loose to catch potential matches in ArcIndex, it would be necessary to sort out false duplicates before going any further. 20. We also noted that, if the data is of very poor quality, it may not be possible to resolve potential duplicates and this would not be a criticism of the systems.” 100. They also agreed that the SAP Brief is not a detailed requirements specification and that Southwark had not documented detailed requirements prior to February 2007 (Paragraphs 22 and 23). At Paragraphs 25 to 31, the experts accepted that QualityStage had a user interface and that QualityStage could have been used to produce lists of matches, potential matches and non-matches, in report form, an Excel spreadsheet or in a database format. 101. There is no evidence and indeed no suggestion that any of the software, either Websphere or Arcindex, was badly manufactured or installed. The real complaint is that in two respects Arcindex was not fit for purpose. The only two respects ultimately relied upon by Southwark are that there was no effective or proper facility for identifying and dealing with potential matches in the data which Arcindex would address or process and that there was no effective security provision. 102. The answer to all this primarily lies in the determination of what the relevant Southwark personnel identified and communicated to IBM and Orchard as Southwark's requirements for the software (and other services) which they wished to procure from IBM. 103. I have already made it clear that Southwark simply has not proved on a balance of probabilities that the SAP Brief was provided to IBM on the basis that the rather generalised requirements which it contains were and remained Southwark’s requirements for the software and related services project which Southwark embarked on with IBM. This is of some importance because clearly initially Southwark was looking for a complete “MDM System” from SAP prior to IBM’s involvement and even initially when Southwark approached IBM. It was only when Southwark made it clear that they could not afford the£1.5m to£2m price tag which IBM indicated for a complete system that Southwark lowered its sights at least so far as IBM and Orchard were concerned. Whereas the goal remained one of ultimately achieving an MDM system, it seems likely that the requirements for the IBM procurement were significantly less than those for a full system procurement. 104. There is the clearest evidence which I accept that the Southwark team in 2006 carried out a detailed investigation mostly into Arcindex. They received the Arcindex User Guide and White Paper and had at least two if not more detailed demonstrations of what Arcindex could provide. The team was an intelligent one well versed in IT matters and they gave every impression that they fully understood what it was that Arcindex could and would provide. I am led inexorably to the factual conclusion that the Southwark team in 2006 and at all times up to the arrival of Ms Troy was wholly satisfied that Arcindex met its requirements and reflected exactly what it wanted. Southwark has chosen to call as witnesses not one of the five or six people who were intimately involved on behalf at Southwark prior to the advent of Ms Troy. Any one of Messrs Katz, Orrom, Nuttall, Currey and Ojejinmi or Ms Leahy could have provided useful evidence one way or the other about what the communicated pre-contract requirements were but the Court has not been provided with the benefit of their evidence. As I have already said, I do not draw a negative inference as such that they would have given evidence unhelpful to Southwark. However, the evidence from the IBM witnesses and Mr Leventhal points very clearly towards the conclusion referred to above. The very facts that Mr Katz did not record in any contemporaneous documents in 2006 or 2007 that he was in any way dissatisfied with what IBM and Orchard had provided, and that in August 2007 he expressed his gratitude amongst others to IBM for what they had done up to the time that he signed off on the project, particularly in the context of the contents of his End of Project Report, corroborates the conclusion. 105. The experts accept at Paragraph 15 of their joint report that "ArcIndex functions as described in the ArcIndex User Manual”
"you got exactly what you asked for”. That is essentially what has happened in Southwark’s case. 106. The main complaint relating to potential matches stems from Ms Troy’s belief and experience that an MDM system should have a relatively easy to operate method of identifying potential matches. I accept that a primary purpose was de-duplication of the information. That undoubtedly involves finding a way of identifying matches or duplicates so that, for instance, a Mr A Smith who appears on five different records will show up as giving rise to 5 matches, four of which can be identified as duplicates and in effect removed so that there is left one master or golden record for Mr A Smith. It is common ground between the experts, and I accept, that Arcindex should usually be used with data which has already been standardised and cleansed and that then, sometimes by trial and error initially, rules or criteria are fixed in Arcindex for the reception of the cleaned up data. That will produce only two categories: matches and non-matches. There is no separate category as such for potential matches, that is a category of records which do not satisfy the rules or criteria for matches, but which are sufficiently close to merit a clerical review by a human being. However, there was, as the experts said in their Joint Report and indeed in evidence, a number of ways of identifying by way of Arcindex what might fall into the category of "potential matches”. The first is that set out in Paragraph 18 of the Joint Report which involves in effect doing two runs or passes. The first pass would involve the setting of sufficiently tight rules so that only matches or duplicates were found; as Paragraph 19 of the Joint Reports indicates, those matches would then be dealt with so that on the next run or pass they would not show up as matches. The second run would then involve setting looser rules so that a second and different batch of (albeit less certain) matches were identified. These would be potential matches which would need to be the subject matter of a clerical review. Another way of identifying potential matches would be to carry out a review of the textual report either on-screen or as printed out. That review could be tailored so that the reviewers were on the lookout for certain types of closely related information. The names for instance would or could be shown in alphabetical order and that would make a review easier. I accept that this latter approach would have taken substantial human resources at least initially; once the information had removed the duplication from it (the de-duplication initially involving substantial resources), the systems would be rational and only contain single entries for people and places so that later work of de-duplication would involve much less human resource. Of course, the Southwark team recognised that Southwark would have to “cut its cloth” to fit its budgetary constraints. 107. Mr Katz effectively said in his End of Project report that the Websphere and Arcindex software would have provided Southwark with operational benefits from data cleaning, standardisation and matching which Southwark did not currently have and that the project was closed down before any of these benefits could be realised. On any account, Arcindex, if operated sensibly and properly with cleansed and standardised information, would have been of substantial use to Southwark because, at the very least, it could be used to identify and take out a vast amount of duplicated or matching information which would effectively de-clog the source systems and avoid or reduce in a substantial measure the risk of errors being made in the treatment of people and premises. 108. In my judgement, Southwark got by way of Arcindex exactly what its then team knew that they were getting and what it decided that it wanted and needed within its budgetary constraints. It follows from my findings that I am satisfied on a balance of probabilities that Arcindex as supplied by Orchard to Southwark was of satisfactory quality and suitable not only generally but also for the specific purposes which Southwark’s personnel had identified to IBM and Orchard as their requirements. 109. The reality is, now recognised by both experts, that QualityStage was able to provide even what Ms Troy latterly from Southwark’s standpoint believed Arcindex did not provide but should have provided, namely an ability to identify and produce three lists of records, matches, potential matches and non-matches. Subject to one factual conundrum, I would have no doubt that, even if a better provision for potential matches could have been required within Arcindex, it could not be considered to be unsuitable in the context that related software provided by IBM, namely QualityStage, could and would provide that better facility. The factual conundrum relates to the workshop of3 October 2007 at which there was effectively unchallenged evidence that "there was no feasible solution to support the Claimants’ MDM requirements with the current WebSphere modules purchased” (as set out in Ms Troy's witness statement at Paragraph 86). It remains unclear, even if one accepts this evidence at face value, what was being referred to as the Claimants’ "
“Definition of user roles and authorizations”