A Data Dictionary stores information about all user-defined objects in the database. It usually comes with utilities to cross-reference all system components to each other.
References
Questions tagged [data-dictionary]
187 questions
3
votes
2 answers
Caching large non-unicode dictionary in database?
I have a large dictionary (outputs as string in 366MB, ~383764153 line filetextfile) that I want to store in a database for fast access and to skip the computation time involved in populating the dictionary.
My dictionary consists of a dictionary of…
user1438003
- 6,603
- 8
- 30
- 36
2
votes
1 answer
SQLite data dictionary tables and columns
Can you tell us the names of all tables and table columns in the SQLite data dictionary?
Update:
I was using this information for a Basic4Android app I'm developing.
Here is the actual segment of coding I used:
' Create the PeopleToVisit table which…
Emad-ud-deen
- 4,734
- 21
- 87
- 152
2
votes
1 answer
How MySQL tables are opened? table_definition_cache, table_open_cache, .frm files and Data Dictionary: How are they related?
MySQL version: 5.7 Machine: Ubuntu 20.04
Recently, we were analysing the performance issues that can occur when increasing the number of tables in a schema. And during this, we came across 4 system variables that have impact on the performance:…
vasanths20
- 36
- 1
- 4
2
votes
1 answer
Select column_name from cols return nothing although column exists
i am trying to execute this statement in Oracle 9i. However it seems that the result set is empty although J am very sure that there are many columns with the name ID.
select * from cols where column_name like '%ID%';
Also, the following statement…
Oh Chin Boon
- 23,028
- 51
- 143
- 215
2
votes
1 answer
What uniquely identifies an index in Oracle?
Within the Oracle documentation, the (DBA|ALL)_INDEXES view has
OWNER The owner of the index
INDEX_NAME The name of the index
TABLE_OWNER The owner of the indexed object
TABLE_NAME The name of the indexed object
My question is what uniquely…
David Fletcher
- 305
- 1
- 7
2
votes
1 answer
Is the OWNER in ALL_CONSTRAINTS and ALL_CONS_COLUMNS the same as the table owner?
According to Oracle, the OWNER field in (ALL|USER|DBA)_CONSTRAINTS is the owner of the constraint. To relate back to the table that this constraint belongs to, this view provides TABLE_NAME, however to uniquely identify a table, I need both the…
David Fletcher
- 305
- 1
- 7
2
votes
1 answer
How do I write the table structure in Oracle from an existing schema?
I have so far figured out that to describe a table I can use the below:
select dbms_metadata.get_ddl('TABLE','','') from dual;
I also found that I can get a list of tables from the current user using the below…
