We need to have reporting / analytical database for our application. Our application will have reporting and analytical capability against these database. What i understand from CB analytics is that it will have a separate node for reporting replicating the same operational tables. My operational tables are not highly denormalized. And it is not suited to build reporting large data with filters, aggregations and grouping no way it could be used for slicing the data by dimensions against facts as we do in DW.
Can any one help with the approach or directions usually need to be taken in the context of nosql and CB analytics.
To improve cost normalization taking CRM application with centralized data management.
Eg-contacts table(physical layer) what if analysis.data validator for any changes in the system.
Business rules keep changing and it costs more if you map one on one.
There’s a schematic in data modeling for web-based information system and I did read top down,bottom up approach and sandwich in guru99 for application server.
I did join these three approaches for better understanding.
If needed please go through database layers of abstraction(diagram) along with real time examples.
Logic gates and architecture in Computer architecture organization for logic layer,DLC,UML and application layer.
Can you be more concrete? I am not concerned about the physical layer.
Can you please relate to the industry practice in today’s world ?. This is not helping answering the question.
To me Document, collection etc are logical.
How would i design schema for an analytical database. I am not talking about big data.
I am talking about the analytical db schema for my operational tables.? I understand that in a relational world you may go with highly denormalized tables or you go with dimensions and facts which is more structured.
What are the approaches CB customer generally follow? any design patterns etc.
We have customer centric design
2.customer relational database
4.polls and ballots
5.report anonymous web address for IT compliance
7.access to authorized person or persons
9.voip or mobile usage