About: Synonym (database)

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Synonym (database) Goto Sponge NotDistinct Permalink

An Entity of Type : yago:WikicatDatabaseManagementSystems, within Data Space : dbpedia.org associated with source document(s)
QRcode icon

http://dbpedia.org/describe/?url=http%3A%2F%2Fdbpedia.org%2Fresource%2FSynonym_%28database%29

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

Attributes	Values
rdf:type	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:label	Synonym (database) (en)
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)
dcterms:subject	Databases Data modeling Database management systems
Wikipage page ID	25753044 (xsd:integer)
Wikipage revision ID	1070480345 (xsd:integer)
Link from a Wikipage to another Wikipage	View (database) Databases McGraw-Hill Table (database) Database schema DBMS Database Data modeling Addison–Wesley Database management systems Apress O'Reilly Media Oracle Database Sequence
Link from a Wikipage to an external page	https://archive.org/details/oraclesqlplsqlha0000pali
sameAs	Synonym (database) Synonym (database) Synonym (database) Synonym (database)
dbp:wikiPageUsesTemplate	dbt:Cite_book dbt:More_footnotes dbt:Short_description dbt:Clarify_span dbt:Databases
has 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)
gold:hypernym	Alias
prov:wasDerivedFrom	wikipedia-en:Synonym_(database)?oldid=1070480345&ns=0
page length (characters) of wiki page	5562 (xsd:nonNegativeInteger)
foaf:isPrimaryTopicOf	wikipedia-en:Synonym_(database)
is Link from a Wikipage to another Wikipage of	Synonym (disambiguation) Database schema
is Wikipage disambiguates of	Synonym (disambiguation)
is foaf:primaryTopic of	wikipedia-en:Synonym_(database)

Faceted Search & Find service v1.17_git139 as of Feb 29 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 08.03.3331 as of Sep 2 2024, on Linux (x86_64-generic-linux-glibc212), Single-Server Edition (61 GB total memory, 38 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software