...MEMORANDUM TO BOB HENDERSON TO: Bob Henderson, CIO for the City of Big Valley, California DATE: XX FROM: XX SUBJECT: Recommendation for Big Valley’s ERP alternatives ------------------------------------------------- Big Valley faced a strategic decision with its primary enterprise resource planning (ERP) applications. There were three alternatives under consideration: continue with Oracle, new support provider and new ERP system. All had varying levels of risk, associating with various pros and cons. I recommend new ERP system, specifically Government E-Management Solutions (GEMS). Reasons for choosing GEMS: * GEMS had a relatively low cost. GEMS was a tier II ERP solution. Therefore, it was relatively inexpensive to purchase, implement and maintain. Compared with the other options, GEMS did have the lowest annual maintenance fee which would save a lot of money in the future. * GEMS offered a property management system that Big Valley may want to consider leveraging. a. According to the administrative report of Vancouver, Canada, the property information may constitute 80% to 90% of the city’s data. Thus the capability of managing this information efficiently should be an important feature to consider when we selecting the ERP solution for a city. The property management system offered by GEMS allowed the city to issue invoices and collect payment for multiple utility services, business licenses, permits, inspection notices and property taxes. And this...
Words: 501 - Pages: 3
...counter. When she had agreedto accept the promotion to Category Director last year, she had no idea that the pressures ofthis job would be so enduring. The last six months had seemed like one long, dull headache. Since the initiation of the CPFR pilot program, it seemed that Valley, their supplier, had been making all the demands in this relationship. Wasn’t the customer supposed to be the one who was always right? Gordon eased into the chair next to her and immediately noticed the weary, pained look on her face. As Vice President of Supply Chain Operations for Texan Foods for the last 9 years, he had learned a lot about dealing with employee and customer frustrations. The CPFR pilot with Valley had tested his resolve as well. Valley’s CPFR team was unhappy with the small performance gains – and the occasional significant losses – that the program had delivered for the 34 SKUs that had been included in the pilot. Valley had wanted a more comprehensive level of collaboration from the very first day, and they were sure that Gordon was withholding information from them that would allow their small company to realize greater cost savings sooner. Always taking a conservative approach to new initiatives, Gordon had been adamant that the...
Words: 12339 - Pages: 50
...counter. When she had agreedto accept the promotion to Category Director last year, she had no idea that the pressures ofthis job would be so enduring. The last six months had seemed like one long, dull headache. Since the initiation of the CPFR pilot program, it seemed that Valley, their supplier, had been making all the demands in this relationship. Wasn’t the customer supposed to be the one who was always right? Gordon eased into the chair next to her and immediately noticed the weary, pained look on her face. As Vice President of Supply Chain Operations for Texan Foods for the last 9 years, he had learned a lot about dealing with employee and customer frustrations. The CPFR pilot with Valley had tested his resolve as well. Valley’s CPFR team was unhappy with the small performance gains – and the occasional significant losses – that the program had delivered for the 34 SKUs that had been included in the pilot. Valley had wanted a more comprehensive level of collaboration from the very first day, and they were sure that Gordon was withholding information from them that would allow their small company to realize greater cost savings sooner. Always taking a conservative approach to new initiatives, Gordon had been adamant that the pilot program would only take a...
Words: 12334 - Pages: 50
...This page intentionally left blank Te n t h E d i t i o n MODERN DATABASE MANAGEMENT Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcano Director of Marketing: Patrice Lumumba Jones Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Operations Specialist: Ilene Kahn Senior Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia © vuifah Manager, Visual Research: Karen Sanatar Permissions Project Manager: Shannon Barbe Media Project Manager, Editorial: Denise Vaughn Media Project Manager, Production: Lisa Rinaldi Supplements Editor: Kelly Loftus Full-Service Project Management: PreMediaGlobal Composition: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2011, 2009, 2007, 2005, 2002...
Words: 193467 - Pages: 774
...MODERN DATABASE MANAGEMENT / JfFFREY A. HOFFER . Warehousing Success 426 Data Warehouse Architectures 428 Generic Two-Level Architecture 428 Independent Data Mart Data Warehousing Environment 426 429 C O NTENTS Dependent Data Mart and Operational Data Store Architecture: A Three-Level Approach Logical Data Mart and Real-Time Data Warehouse Architecture 432 Three-Layer Data Architecture 435 Role of the Enterprise Data Model 435 Role of Metadata 436 Some Characteristics of Data Warehouse Data Status Versus Event Data 437 Transient Versus Periodic Data 438 An Example of Transient and Periodic Data 438 Transient Data 438 Periodic Data 439 Other Data VVarehouse Changes 440 The Reconciled Data Layer 441 Characteristics of Data after ETL 441 The ETL Process 442 Extract 442 Cleanse 444 Load and Index 446 Data Transformation 447 Data Transformation Functions 448 Record-Level Functions 448 Field-Level Functions 449 More Complex Transformations 451 Tools to Support Data Reconciliation 451 Data Quality Tools 451 Data Conversion Tools 452 Data Cleansing Tools 452 Selecting Tools 452 The Derived Data Layer 452 Characteristics of Derived Data 452 The Star Schema 453 Fact Tables and Dimension Tables 453 Example Star Schema 454 Surrogate Key 455 Grain of Fact Table 456 Duration of the Database 456 Size of the Fact Table 457 Modeling Date and Time 458 Variations of the Star Schema 458 Multiple Fact Tables 458 Factless Fact Tables...
Words: 80097 - Pages: 321
