Feature request: "Tagging" objects

[F. van Boven]

Hi, since our database is growing and growing, it would be nice to "group" certain functionality together. Something close to that is available by creating a customer Browser Folder. But I'd like it DB-wide.

Thoughts:

Make it possible to "Tag" an object (just like a move in YouTube for instance) e.g.:
- TABLE_CUSTOMER => "Crm, orders"
- TABLE_ORDERLINE => "orders, pricing"
- TABLE_PRICES => "pricing, product"

Extend the Browser using the tags:

-- <root node>
   |--  <project node>
        |----  <Dbobject node>
        |----  <Dbobject node>
        |----  <Dbobject node>
   |--  <project node>
        |---  <Dbobject node>
        |---  <Dbobject node>

 

[ScottMattes]

I am not sure that I understand.

How is your database growing? More applications? We have the approach here that each application is in a separate schema, so automatically they are separate.

Another thing that I have done is within the schema/application that I work in I have defined Object folders for parts of the overall application.

 

[Marco Kalter]

I have added this to the list of enhancement requests. Note however that you could already implement this with Query Based Browser Folders:

First you create an object tag table (and populate it with objects and tags):

create table OBJECT_TAGS
(
  TAG_OBJECT_OWNER VARCHAR2(30) not null,
  TAG_OBJECT_NAME  VARCHAR2(30) not null,
  TAG_NAME         VARCHAR2(30) not null
);
alter table OBJECT_TAGS
  add constraint object_tags_pk primary key (TAG_OBJECT_OWNER, TAG_OBJECT_NAME, TAG_NAME);
insert into object_tags values
('SCOTT', 'DEPT', 'DEPT_EMP_PROJECT');
insert into object_tags values
('SCOTT', 'EMP', 'DEPT_EMP_PROJECT');
insert into object_tags values
('SCOTT', 'BONUS', 'DEPT_EMP_PROJECT');
insert into object_tags values
('SCOTT', 'SALGRADE', 'DEPT_EMP_PROJECT');
commit;

Next, you create a query based folder with a where clause like this:

exists (select * from object_tags t
         where t.tag_object_owner = owner
           and t.tag_object_name  = object_name
           and t.tag_name = 'DEPT_EMP_PROJECT')

This folder will show all objects that exist in the object_tags table with the corresponding tag_name.

 

[ScottMattes]

I wanted to clarify my response:

I created Browser Filters (on the main menu click Tools and then Browser Filters...)

Now to go try what Marco suggested!!!!!!!!!

 

[ScottMattes]

Marco,
Way nice! I just used the Browser Folder idea to put all the Folders I don't usually use 'out of the way' by defining a 'Least Used' folder and making it the parent of the ones I don't usually use.