- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 72 Insurance
- 537.2K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Oracle Tagging for Objects
It's more than comments, it consists in add indexable keywords that enable easily locate tables or other objects in database, like Mac OS and other systems allow to tag files.
The tags could have some kind of keyword for object use. For example: “Transactional”, “Report”, “Log”, “Backup”, “Auxiliary”, “Internal”, “Depracated” (for application purpose), etc.
Example of Syntax:
CREATE TABLE example (a NUMBER, b NUMBER) TAGS ('Transactional'[,…]);
CREATE SEQUENCE seq_exemp ON example TAGS ('Transactional');
CREATE INDEX idx_oltp ON example TAGS ('Transactional');
CREATE INDEX idx_report ON example TAGS ('Report');
SQL> SELECT OBJECT_NAME, OBJECT_TYPE, TAG FROM DBA_TAGS WHERE TAG=’Transactional’;
OBJECT_NAME OBJECT_TYPE TAG
------------- ---------- -------------
EXAMPLE TABLE TRANSACTIONAL
SEQ_EXEMP SEQUENCE TRANSACTIONAL
IDX_OLTP INDEX TRANSACTIONAL
And the TAGs could be reseted (erase all values and put new ones), added, removed, or replaced like:
ALTER INDEX idx_oltp INVISIBLE [RESET|ADD|REMOVE|REPLACE] TAGS('Deprecated');
These tags could be let “free to use”, so each development team, or company could implement his own tags. Pre-defined tags like suggested be created “by default”.
Companies can create tags for his developers like “TAGS ('Transactional', 'John');”. So this object will have the Tags for Transacional Object and is maintained by John. If John is leaving the company, is simply to list his “Objects” to make a KT to other teammates, or something like that.
Actually companies have lots of parallel controls for that.
And, I think, it’s a very useful not “linear” way to index/organize the objects that can helps in all development lifecycle and DBA (that occasionally have no access to application ER).