Database container
The present disclosure provides a database container configured to contain multiple data sources. A first command is received to add a new data source to the database container. In response, the new data source is created within the database container, where the database container acts as a parent such that the new data source inherits properties of the database container including a first set of access permissions. Display of the new data source is caused via the database container. The system receives a second command to link an existing data source residing outside the database container to the database container. In response, a view of the existing data source is created within the database container without containing the existing data source, causing the existing data source to retain a second set of access permissions different from the first set of access permissions.
1 . A non-transitory, computer-readable storage medium comprising instructions recorded thereon, wherein the instructions, when executed by at least one data processor of a system configured to manage a workspace application including multiple data sources, cause the system to:
receive a first command to add a new data source to a database container of the workspace application,
wherein the database container is configured to contain multiple data sources;
in response to the first command being received:
create the new data source within the database container,
wherein the new data source is contained within the database container,
wherein the database container acts as a parent to the new data source such that the new data source inherits properties of the database container including a first set of access permissions, and
wherein the workspace application enforces access to the new data source in accordance with the first set of access permissions;
cause display of the new data source via the database container;
receive a command to create a relation between the new data source and a second data source of the workspace application,
wherein the second data source is contained within the workspace application;
in response to the command to create the relation being received:
create the relation between the new data source and the second data source,
wherein creating the relation causes display of the second data source within a relation column of the new data source;
receive a second command to link an existing data source of the workspace application to the database container,
wherein the existing data source resides outside of the database container but within the workspace application; and
in response to the second command being received:
create a view of the existing data source within the database container without the existing data source being contained within the database container; and
cause the existing data source to retain a second set of access permissions different from the first set of access permissions,
wherein the workspace application enforces access to the existing data source in accordance with the second set of access permissions.
2 . The non-transitory, computer-readable storage medium of claim 1 , wherein the system is further caused to:
receive a request to delete the database container; and
in response to the request being received:
request confirmation to delete one or more data sources contained within the database container;
receive the confirmation to delete the one or more data sources; and
in response to the confirmation being received, delete the one or more data sources contained within the database container.
3 . The non-transitory, computer-readable storage medium of claim 1 , wherein the system is further caused to:
generate a recommendation to create the relation between the new data source and one or more data sources contained within the database container;
cause display of the recommendation; and
receive a selection of the second data source.
4 . The non-transitory, computer-readable storage medium of claim 1 , wherein the command to create the relation is a request to create a two-way relation between the new data source and the second data source, and wherein the system is further caused to:
cause the display of the second data source within the relation column of the new data source; and
cause display of the new data source within a relation column of the second data source.
5 . The non-transitory, computer-readable storage medium of claim 1 , wherein the first command to add the new data source to the database container is provided, as input, to an AI agent of the workspace application.
6 . The non-transitory, computer-readable storage medium of claim 1 , wherein the database container is a first database container, and wherein the system is further caused to:
receive a command to move the new data source to a second database container of the workspace application; and
in response to the command to move the new data source being received, cause the new data source to be removed from the first database container and contained within the second database container.
7 . The non-transitory, computer-readable storage medium of claim 1 , wherein the system is further caused to:
receive a command to move the existing data source to the database container; and
in response to the command to move the existing data source being received, cause the existing data source to be removed from outside the database container and to be contained within the database container.
8 . The non-transitory, computer-readable storage medium of claim 1 , wherein the system is further caused to:
change an access permission of the first set of access permissions of the database container,
wherein the first set of access permissions determines a corresponding set of access permissions of each data source contained within the database container; and
in response to the access permission being changed:
propagate the change of the access permission in the corresponding set of access permissions of each data source contained within the database container; and
forgo change of the access permission in the second set of access permissions of the existing data source to retain a different access permission from the first set of access permissions.
9 . A non-transitory, computer-readable storage medium comprising instructions recorded thereon, wherein the instructions, when executed by at least one data processor of a system, cause the system to:
receive a first command to add a new database to a database container of a workspace application,
wherein the database container is configured to contain multiple databases;
in response to the first command being received:
create the new database within the database container,
wherein the new database is contained within the database container,
wherein the database container acts as a parent to the new database such that the new database inherits a set of properties including a first set of access permissions of the database container, and
wherein the workspace application enforces access to the new database in accordance with the first set of access permissions; and
cause display of the new database via the database container;
receive a second command to link an existing database of the workspace application to the database container,
wherein the existing database resides outside of the database container but within the workspace application; and
in response to the second command being received:
create a view of the existing database within the database container without causing the existing database to be contained within the database container,
wherein creating the view of the existing database within the database container causes the existing database to retain a set of properties including a second set of access permissions different from the set of properties of the database container, and
wherein the workspace application enforces access to the existing database in accordance with the second set of access permissions.
10 . The non-transitory, computer-readable storage medium of claim 9 , wherein the system is further caused to:
receive a command to create a relation between the new database and a second database of the workspace application,
wherein the second database is contained within the workspace application; and
in response to the command to create the relation being received:
prompt for creation of the relation between the new database and one or more databases, the one or more databases including the second database;
receive an indication of selection of the second database from among the one or more databases; and
in response to the selection being received, create the relation between the new database and the second database,
wherein creating the relation causes display of the second database within a relation column of the new database.
11 . The non-transitory, computer-readable storage medium of claim 9 , wherein the system is further caused to:
receive a request to delete the database container; and
in response to the request being received:
prompt for confirmation to delete one or more databases contained within the database container; and
in response to the confirmation being received, delete the one or more databases contained within the database container.
12 . The non-transitory, computer-readable storage medium of claim 9 , wherein the first command to add the new database to the database container is provided, as input, to an AI agent of the workspace application.
13 . The non-transitory, computer-readable storage medium of claim 9 , wherein the database container is a first database container, and wherein the system is further caused to:
receive a command to move the new database to a second database container of the workspace application; and
in response to the command to move the new database to the second database container, move the new database from the first database container to within the second database container,
wherein, when moved, the new database is contained within the second database container.
14 . The non-transitory, computer-readable storage medium of claim 9 , wherein the system is further caused to:
receive a command to move the existing database to the database container; and
in response to the command to move the existing database to the database container, move the existing database from outside the database container to within the database container,
wherein, when moved, the existing database is contained within the database container.
15 . The non-transitory, computer-readable storage medium of claim 9 , wherein the set of properties of the database container is a first set of properties, the set of properties of the existing database is a second set of properties, and wherein the system is further caused to:
change a property of the first set of properties of the database container,
wherein a set of properties of each database contained within the database container mirrors the first set of properties; and
in response to the property being changed:
change a corresponding property of each database contained within the database container; and
forgo change to the corresponding property of the existing database.
16 . A method comprising:
receiving a first request to add a new database to a database container of a workspace application,
wherein the database container is a database that is configured to contain multiple databases;
in response to receiving the first request:
creating the new database to be contained within the database container,
wherein the new database inherits a first set of properties including a first set of access permissions of the database container, and
wherein the workspace application enforces access to the new database in accordance with the first set of access permissions;
receiving a second request to link an external database, located outside of the database container, to the database container; and
in response to receiving the second request:
creating a view of the external database within the database container without causing the external database to be contained within the database container; and
causing the external database to retain a second set of properties including a second set of access permissions different from the first set of properties,
wherein the workspace application enforces access to the external database in accordance with the second set of access permissions.
17 . The method of claim 16 , further comprising:
receiving a request to create a relation between the new database and a second database of the workspace application, the second database being contained within the workspace application; and
in response to the request to create the relation being received:
creating the relation between the new database and the second database; and
causing display of the second database within a relation column of the new database.
18 . The method of claim 16 , further comprising:
providing, as input, the first request to add the new database to the database container to an AI agent of the workspace application.
19 . The method of claim 16 , further comprising:
receiving a request to move the new database to a second database container of the workspace application; and
in response to receiving the request to move the new database to the second database container:
causing the new database to be removed from the database container and contained within the second database container.
20 . The method of claim 16 , wherein the external database is located outside of the workspace application.