apache / apache/cloudberry-site
Doc: new docs demands from slack
- Dominant language
- TypeScript
- Stars
- 26
- Forks
- 42
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 7
Description
A colleague of mine asked the following questions:
My questions around a cloudberry DB that is used as a datawarehouse (OLAP applications, reporting/BI)
• any specific optimization options for analytical queries / aggregation functions
• best practices in the data model design (star/snowflake-schema; normalized vs. denormalized; redundancy issues)
• best practices in the configuration
• any thoughts on massive deletes
• any thoughts on doing outer joins of 10+ tables
• any specific recommendations regarding partioning, indexing, views/materialized views,...
[Slack Message](https://apache-cloudberry.slack.com/archives/C04CS0GN0S1/p1734530331444899?thread_ts=1734530331.444899&cid=C04CS0GN0S1)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the linked Slack thread and review the listed questions about analytical queries, data modeling, configuration, deletes, joins, partitioning, indexes, and views. The issue names no documentation file or test; done would require agreeing on scope and adding clear guidance that addresses the selected topics.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100