Scope of Project:
– Need to have someone review our current Oracle DB architecture and db platform to develop alternative/supplemental data architectures to address the following needs:
– Address performance requirements to display information on web forms that contains data from several tables that need to be joined and/or data that requires aggregation.
– Address performance requirements to report (either on screen or hardcopy) information that contains data from several tables that need to be joined and/or data that requires aggregation.
– Address performance requirements for ad hoc report (either on screen or hardcopy) information that contains data from several tables that need to be joined and/or data that requires aggregation.
– Address performance requirements to perform data segmentation for direct mail campaign processing.
– Take advantage of OLAP capabilities provide in the JasperAnalysis product
– Would like to understand our options and receive recommendations on what data architectures would best given are needs described above
– Recommendations on cost effective approaches and tools to implement DA recommendations
– Is creating a data warehouse or warehouses needed
– How would we create them
– How would we manage them
– Keep them current
– Purge data information
– Do we need a data warehousing tool?
– Should we looking to other data management technologies like map reduced (Hadoop), NoSQL, etc.
– Do we need ETL tools or do we roll our own?
– What cost effective ETL tools are available
– Implement a POC that we can replication to address our varied needs.
