Data that describes other data or data structures.
2
votes
3answers
81 views
Looking for industry standard and/or tool to represent and export RDBMS metadata
Do you know of an industry standard that is designed to describe the metadata contents of a relational database (or part of it, such as tables, columns, etc.)?
Do you know if a tool exists that does ...
2
votes
1answer
50 views
User Password Expiry date
Is it possible to find my password expiry date without asking the DBA?
My user does not have privileges to view the DBA_USERS table. Also, I tried select * from USER_USERS table, but expiry_date is ...
1
vote
1answer
93 views
Storing metadata of various data types in a MySQL database
I am currently designing a MySQL database that will store a variety of documents in different digital formats (mostly docs, spreadsheets, and pdfs). Each document will have several metadata values ...
1
vote
1answer
47 views
Is it a best practice to contrast table and dependent view metadata to target which views to refresh?
We have non-indexed views created on vendor tables. When they change table structure or column definitions we run sp_refreshview as needed. What is the viability of a script to contrast the table ...
5
votes
3answers
495 views
Best way to store units in database
I have inherited a large (SQLServer) database with hundreds of columns that represent amounts of one thing or another. The units for these values (e.g. "gallons", "inches", etc) are stored in the ...
2
votes
1answer
85 views
Is there any reason that metadata should not be a part of my database schema?
By metadata I mean things such as:
the owner of an entity
permissions associated with an entity
the date and time of data entry
the surety of entered data
the format of a text attribute
descriptive ...
0
votes
0answers
75 views
CalDav: Is it possible to reproduce an subscripable .ics file in a database?
CalDAV is an WebDav extension specificaly designed for accessing iCalendar files (*.ics).
Those .ics files are subscribable as long as they are stored on a CalDav server. If the owner of that file ...
7
votes
1answer
1k views
How can I force SQL Server Management Studio to update metadata?
Metadata in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working.
Steps to ...
9
votes
2answers
358 views
SQL Server Filetable document properties
I'm using SQL Server 2012's Filetable to store documents and search them with Semantic Search.
I was wondering if there is a way to list all the document properties (meta data). There is a way to ...
2
votes
3answers
100 views
Field types for columns in a MySQL query
Is it possible to get the field type from a MySQL query, in the same way you can get it from a table with the SHOW COLUMNS command?
edit: i should clarify that a bit. I am aware that I can get the ...
2
votes
0answers
148 views
How to do automated archiving for a SQL Server database based on interpretation of database metadata?
I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing ...
3
votes
3answers
91 views
PostgreSQL equivalent of SQL Server SQL_VARIANT_PROPERTY
Does PostgreSQL have an equivalent function for determining column metadata?
Reference: SQL_VARIANT_PROPERTY
pg_typeof() appears to be close, but it does not show the precision and scale. Looking up ...
0
votes
0answers
56 views
Can LDAP authentication be integrated with Informatica Metadata Manager?
Is it possible to authenticate users in Informatica Metadata Manager using LDAP authentication? Please explain how if you have details or resources.
6
votes
3answers
412 views
How to document Oracle database?
I'm new to Oracle databases. I have used to SQL Server and the description fields (MS_Description) for tables and columns for documentation purposes. Is there an equivalent for Oracle? What is the ...
2
votes
3answers
2k views
Understanding Oracle's ALL_TAB_COLUMNS
I'm new to Oracle and database administration in general.
As context, I want to create a Java class that will give me the information I would get using DESC SOME_TABLE.
I cannot find any specific ...
2
votes
2answers
309 views
What could trigger that a login created from a certificate is not visible in metadata
I am trying to create a login and grant it rights to run and unsafe assembly but the check on server_principals does not return the login when it already exists. The script works perfectly fine on my ...
0
votes
1answer
925 views
How can primary keys in a Netezza table be indexed?
What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database.
...
3
votes
2answers
2k views
How can I get a list of column names and types from a resultset?
Say I get a resultset back from the following query:
select *
from sys.database_files;
For any given resultset, I want to be able to query the column names and types so I can then create tables to ...
3
votes
1answer
1k views
Copy complete structure of a table
Using some methods, when you create a copy of a table you lose indexes, PK, FK, etc. For example in SQL Server I can say:
select * into dbo.table2 from dbo.table1;
This is just a simple copy of the ...
15
votes
2answers
18k views
How do I list or search all the column names in my database?
I want to search for a string in the names of the columns present in a database.
I’m working on a maintenance project and some of the databases I deal with have more than 150 tables, so I'm looking ...
4
votes
2answers
5k views
How do I get a list of all the partitioned tables in my database?
How do I get a list of all the partitioned tables in my database?
Which system tables/DMVs should I be looking at?
6
votes
1answer
584 views
What's the difference between a v$ view and its dba_ equivalent?
What's the general difference between a v$ view and its dba_ equivalent? Take, for example, v$tablespace and dba_tablespaces.
1
vote
1answer
204 views
View metadata refresh in MySQL
Like other RDBMS, view meta data is stored at view creation time.
From CREATE VIEW in the MySQL docs
The view definition is “frozen” at creation time, so changes to the underlying tables ...
1
vote
1answer
82 views
Oracle SecureFile Compression
Where can I read database compression properties after the creation of an oracle database / tables? Is there a special view where the info is stored and can be retieved?
5
votes
2answers
848 views
Is there an Open Source Metadata Management Solution?
Is there an Open Source Metadata Management Solution? I'd like to create a Metadata Repository that will hold the details of the metadata of database schemas, tables and data items of hundreds of ...
4
votes
2answers
690 views
Database design for dynamic Meta fields of an entity that shall be queried intensively
I'm designing a database structure for a system at which an entity can have a dynamic set of user-defined meta attributes. The meta fields (e.g.: popularity, conversion etc.) and skill values (int, ...
2
votes
2answers
392 views
How to hide metadata from Postgres users?
I need to provide views-only access to some subset of a database, for use by report-writing tools. It's easy enough to use permissions to prevent access to the data in the underlying tables, but I ...
3
votes
2answers
282 views
Searching for a Data Dictionary for SQL or Oracle
I am looking for metadata specifications (data dictionary) for SQL Server and Oracle databases.
By metadata map, I mean a definitive description of what objects make up database model and their ...
