Knowledge

Database catalog

Source 📝

219: 260: 164: 253: 279: 284: 118: 91:
follow this, even if they implement other aspects of the SQL standard. For an example of database-specific
246: 52: 36: 196: 130: 16:
Document with definitions of database objects such as base tables, views, synonyms and value ranges
84: 48: 160: 124: 64: 218: 60: 56: 44: 108: 96: 32: 180: 230: 153: 273: 113: 68: 40: 88: 226: 92: 28: 24: 127:, central location where metadata definitions are stored and maintained 83:
standard specifies a uniform means to access the catalog, called the
80: 182:
CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online
234: 197:"Databasekatalog | QualiWare Center of Excellence" 152: 67:product that documents the database's content and 254: 8: 261: 247: 143: 63:, and user groups are stored. It is an 133:, a database created to store metadata 7: 215: 213: 14: 217: 1: 121:, a W3C standard for metadata 233:. You can help Knowledge by 155:Systems Development Handbook 151:Paul C. Tinnirello (1999). 301: 212: 31:in which definitions of 185:, Microsoft Corporation 119:Data Catalog Vocabulary 229:-related article is a 27:instance consists of 95:access methods, see 131:Metadata repository 85:INFORMATION_SCHEMA 242: 241: 125:Metadata registry 292: 263: 256: 249: 221: 214: 207: 206: 204: 203: 193: 187: 186: 177: 171: 170: 158: 148: 33:database objects 21:database catalog 300: 299: 295: 294: 293: 291: 290: 289: 280:Database theory 270: 269: 268: 267: 211: 210: 201: 199: 195: 194: 190: 179: 178: 174: 167: 150: 149: 145: 140: 109:Data dictionary 105: 97:Oracle metadata 77: 17: 12: 11: 5: 298: 296: 288: 287: 285:Database stubs 282: 272: 271: 266: 265: 258: 251: 243: 240: 239: 222: 209: 208: 188: 172: 165: 142: 141: 139: 136: 135: 134: 128: 122: 116: 111: 104: 101: 87:, but not all 76: 73: 15: 13: 10: 9: 6: 4: 3: 2: 297: 286: 283: 281: 278: 277: 275: 264: 259: 257: 252: 250: 245: 244: 238: 236: 232: 228: 223: 220: 216: 198: 192: 189: 184: 183: 176: 173: 168: 166:0-8493-9822-3 162: 159:. CRC Press. 157: 156: 147: 144: 137: 132: 129: 126: 123: 120: 117: 115: 112: 110: 107: 106: 102: 100: 98: 94: 90: 86: 82: 74: 72: 70: 66: 62: 58: 54: 50: 46: 42: 38: 34: 30: 26: 22: 235:expanding it 224: 200:. Retrieved 191: 181: 175: 154: 146: 114:Data lineage 78: 69:data quality 65:architecture 53:value ranges 20: 18: 37:base tables 274:Categories 202:2024-09-28 138:References 89:databases 75:Standards 43:(virtual 227:database 103:See also 93:metadata 49:synonyms 35:such as 29:metadata 25:database 57:indexes 163:  45:tables 225:This 61:users 41:views 23:of a 231:stub 161:ISBN 79:The 81:SQL 47:), 276:: 99:. 71:. 59:, 55:, 51:, 39:, 19:A 262:e 255:t 248:v 237:. 205:. 169:.

Index

database
metadata
database objects
base tables
views
tables
synonyms
value ranges
indexes
users
architecture
data quality
SQL
INFORMATION_SCHEMA
databases
metadata
Oracle metadata
Data dictionary
Data lineage
Data Catalog Vocabulary
Metadata registry
Metadata repository
Systems Development Handbook
ISBN
0-8493-9822-3
CREATE VIEW (Transact-SQL) in SQL Server 2008 Books Online
"Databasekatalog | QualiWare Center of Excellence"
Stub icon
database
stub

Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.