Synonym (database) (original) (raw)
In databases, a synonym is an alias or alternate name for a table, view, sequence, or other schema object. They are used mainly to make it easy for users to access database objects owned by other users. They hide the underlying object's identity and make it harder for a malicious program or user to target the underlying object. Because a synonym is just an alternate name for an object, it requires no storage other than its definition. When an application uses a synonym, the DBMS forwards the request to the synonym's underlying base object. By coding your programs to use synonyms instead of database object names, you insulate yourself from any changes in the name, ownership, or object locations. If you frequently refer to a database object that has a long name, you might appreciate being ab
| Property | Value |
|---|---|
| dbo:abstract | In databases, a synonym is an alias or alternate name for a table, view, sequence, or other schema object. They are used mainly to make it easy for users to access database objects owned by other users. They hide the underlying object's identity and make it harder for a malicious program or user to target the underlying object. Because a synonym is just an alternate name for an object, it requires no storage other than its definition. When an application uses a synonym, the DBMS forwards the request to the synonym's underlying base object. By coding your programs to use synonyms instead of database object names, you insulate yourself from any changes in the name, ownership, or object locations. If you frequently refer to a database object that has a long name, you might appreciate being able to refer to it with a shorter name without having to rename it and alter the code referring to it. Synonyms are very powerful from the point of view of allowing users access to objects that do not lie within their schema. All synonyms have to be created explicitly with the CREATE SYNONYM command and the underlying objects can be located in the same database or in other databases that are connected by. database links There are two major uses of synonyms: * Object invisibility: Synonyms can be created to keep the original object hidden from the user. * Location invisibility: Synonyms can be created as aliases for tables and other objects that are not part of the local database. When a table or a procedure is created, it is created in a particular schema, and other users can access it only by using that schema's name as a prefix to the object's name. The way around for this is for the schema owner creates a synonym with the same name as the table name. (en) |
| dbo:wikiPageExternalLink | https://archive.org/details/oraclesqlplsqlha0000pali |
| dbo:wikiPageID | 25753044 (xsd:integer) |
| dbo:wikiPageLength | 5562 (xsd:nonNegativeInteger) |
| dbo:wikiPageRevisionID | 1070480345 (xsd:integer) |
| dbo:wikiPageWikiLink | dbr:View_(database) dbc:Databases dbr:McGraw-Hill dbr:Table_(database) dbr:Database_schema dbr:DBMS dbr:Database dbc:Data_modeling dbr:Addison–Wesley dbc:Database_management_systems dbr:Apress dbr:O'Reilly_Media dbr:Oracle_Database dbr:Sequence |
| dbp:wikiPageUsesTemplate | dbt:Cite_book dbt:More_footnotes dbt:Short_description dbt:Clarify_span dbt:Databases |
| dct:subject | dbc:Databases dbc:Data_modeling dbc:Database_management_systems |
| gold:hypernym | dbr:Alias |
| rdf:type | dbo:Person yago:Abstraction100002137 yago:Arrangement105726596 yago:Code106355894 yago:CodingSystem106353757 yago:Cognition100023271 yago:Communication100033020 yago:DataStructure105728493 yago:DatabaseManagementSystem106588785 yago:PsychologicalFeature100023100 yago:Writing106359877 yago:WrittenCommunication106349220 yago:Software106566077 yago:Structure105726345 yago:WikicatDataStructures yago:WikicatDatabaseManagementSystems |
| rdfs:comment | In databases, a synonym is an alias or alternate name for a table, view, sequence, or other schema object. They are used mainly to make it easy for users to access database objects owned by other users. They hide the underlying object's identity and make it harder for a malicious program or user to target the underlying object. Because a synonym is just an alternate name for an object, it requires no storage other than its definition. When an application uses a synonym, the DBMS forwards the request to the synonym's underlying base object. By coding your programs to use synonyms instead of database object names, you insulate yourself from any changes in the name, ownership, or object locations. If you frequently refer to a database object that has a long name, you might appreciate being ab (en) |
| rdfs:label | Synonym (database) (en) |
| owl:sameAs | freebase:Synonym (database) yago-res:Synonym (database) wikidata:Synonym (database) https://global.dbpedia.org/id/4vTcZ |
| prov:wasDerivedFrom | wikipedia-en:Synonym_(database)?oldid=1070480345&ns=0 |
| foaf:isPrimaryTopicOf | wikipedia-en:Synonym_(database) |
| is dbo:wikiPageDisambiguates of | dbr:Synonym_(disambiguation) |
| is dbo:wikiPageWikiLink of | dbr:Synonym_(disambiguation) dbr:Database_schema |
| is foaf:primaryTopic of | wikipedia-en:Synonym_(database) |