criteria for data ware house
Answers
Cloud Vendors: Redshift Is in the Lead. ...
Scalability. ...
Reliability. ...
Usability, Security, and Integration. ...
Supported Data Types. ...
Backup and Recovery. ...
Ecosystem
Manageable - Through minimal support tasks requiring DBA/System Administrator intervention. It should provide a single point of control to simplify system administration. You should be able to create and implement new tables and indexes at will.
Complete and Integrated The toolset should be comprehensive across the spectrum of eventual requirements for data and its access.
Interoperable - Integrated access to the web, Microsoft Office, internal networks, and corporate mainframes.
Scalable The ability to handle increasing data sizes and workloads with simple additions to the architecture, as opposed to the increases requiring a rearchitecture
Affordable Proposed solution (hardware, software, services, required customer support) providing a low total cost of ownership (TCO) over a multi-year period.
Proven and Supported You dont want to risk a critical decision regarding a fundamental underpinning of the data warehouse environment on an unproven solution.
Flexible - Provides optimal performance across the full range of models with large numbers of tables. Look for proven ability to support multiple applications from different business units, leveraging data that is integrated across business functions and subject areas.
User Accessible, Compatibilities and interoperability with data access tools that provide a wide range of user-friendly access options.