Small white novice, for a business project starting from 0, how to design the data system?

A. the database system design
1. How to design the database system architecture, data layering?
2. How to design each table structure?
3. How to classify the fact table and dimension table design?
4. An indicator is designed as zipper table or event table?
5. How metadata management and data governance?

B. data system of the tool to select
1. At the same time, in addition to economic cost and when you choose a database which factor?
2. At the same time, with what kind of job tools (perl script, Datastage, Informatica, Kettle) and the scheduling tool (Control - M, Moia, or their construct platform for scheduling) what are the similarities and differences? What problems need to consider when the choice?

CodePudding user response:

You have what book or guide information can recommend?

CodePudding user response:

You this question for more extensive, can not speak clearly in a few words,

CodePudding user response:

I recommend a few books on database design:
Feeling Oracle core technology
Oracle specialist senior programming
The database principle
The data model resource manual
SQL anti-pattern
,,,,,,

CodePudding user response:

Tool, it is suggested that using DataStage

CodePudding user response:

This is clearly trained, professional questions,
I graduated kan class, only know suitable is the best