search

StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
8.85k stars 1.77k forks source link

Support for Schemas within Databases for Logical Separation #36740

Closed AsaiWiz closed 4 months ago

AsaiWiz commented 10 months ago

Introduction of Schemas within Databases:

Function: Implement the capability to create and use schemas within a StarRocks database, allowing for a hierarchical organization of data objects (like tables, views, and functions). Schemas would act as namespaces or containers within a database to group related objects. Pros: Improved Organization: Schemas will enable better organization of data objects, making databases more manageable and navigable. Enhanced Security and Access Control: With schemas, it becomes easier to assign and manage permissions at a more granular level, improving security. Facilitates Multi-tenant Environments: Schemas are ideal for multi-tenant applications, allowing different tenants to operate in separate namespaces within the same database. Better Resource Management: Logical separation can lead to more efficient resource management and optimization. Cons: Increased Complexity: Introducing schemas adds a layer of complexity to database design and management. Potential Overhead: Implementing and maintaining schemas might introduce additional overhead, especially in terms of performance and resource utilization. Migration Challenges: Existing users might face challenges migrating to the new structure, especially if their current setup is extensive and complex. Conclusion:

The introduction of schemas within databases in StarRocks would be a significant enhancement, offering better data organization, security, and management. This feature would align StarRocks with other major database systems that already support this functionality, thus broadening its appeal and utility to a larger set of users and use cases. Implementing this feature would be a substantial step forward in enhancing the overall capabilities and user experience of StarRocks.

github-actions[bot] commented 4 months ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!

AsaiWiz commented 2 months ago

!