Resumen
This article reports on the refined but strategic information needed by Ryder System Inc. It's an international logistics and transportation company with more than 160,000 vehicles, 45,000 employees, 13,000 commercial customers, and revenues worth $5 billion. Ryder's centralized decision support was provided through software languages APL, Focus, QMF, EDA SQL, C++, and Cobol along with a corporate information center. Ryder's complete data warehousing architecture defined the relationships among the enterprise data model, warehousing workflow, data repository, tools, warehouse metadata and data definition standards. Management responsibilities, team roles and skills, external support requirements, and warehouse project workflow's were all formally documented as the warehousing team expanded. The data warehouse architecture is now managed using the enterprise data model as a guide to designing and supporting project integration. According to Ryder's data administration standards, the data is integrated by standardizing the structures, relationships, names, definitions, and business codes. The integrated result saves time and creates high-quality information deliverables for the warehouse as well as for end users. Higher-quality decision support was achieved because the integrated environment reduced manual tasks, increased development speed, visualized the process and left time for multiple corrective iterations.