Movatterモバイル変換


[0]ホーム

URL:


Jump to content
WikipediaThe Free Encyclopedia
Search

Database object

From Wikipedia, the free encyclopedia
Defined object used to store or reference data
Not to be confused withObject database.

Adatabase object is a structure for storing,managing and presenting application- or user-specificdata in adatabase. Depending on thedatabase management system (DBMS), many different types of database objects can exist.[1][2] The following is a list of the most common types of database objects found in mostrelational databases (RDBMS):

  • Tablespace, storage space for tables in a database
  • Tables, a set of values organized into rows and columns
  • Indexes, a data structure providing faster queries (at the expense of slower writing and storage to maintain the index structure)
  • Views, a virtual table that is made as it is queried
  • Synonyms, alternate names for a table, view, sequence or other object in a database
  • Stored procedures anduser-defined functions
  • Triggers, procedures which are run automatically based on specific events
  • Constraints, a constraint on thedomain of anattribute
  • User accounts, schemas and permissions

Database objects are permanent,[3] which means that they remain in their form as long as they are not explicitlychanged or deleted. Application- or user-specific database objects in relational databases are usually created withdata definition language (DDL) commands, which in SQL for example can beCREATE,ALTER andDROP.[4][5]

Rows ortuples from thedatabase can represent objects in the sense ofobject-oriented programming, but are not considereddatabase objects.[6]

References

[edit]
  1. ^"Database Objects".docs.oracle.com (SQL Language Reference). Oracle. Retrieved2023-07-05.
  2. ^Randolph West; et al. (2023-05-23)."sys.all_objects (Transact-SQL)". Microsoft. Retrieved2023-07-05.
  3. ^Sprachen für Datenbanken. Informatik-Fachberichte. Vol. 72. 1983. p. 185.doi:10.1007/978-3-642-69297-0.ISBN 978-3-540-12733-8 – via link.springer.com.
  4. ^Rahul Awati (June 2022)."Data Definition Language (DDL)".techtarget.com. TechTarget. Retrieved2023-07-10.
  5. ^"Generating DDL statements for database objects".ibm.com (DB2 Version 9.7 for Linux, UNIX, and Windows). International Business Machines Corporation. 2021-03-01. Retrieved2023-07-10.
  6. ^Relationale Datenbanken und SQL in Theorie und Praxis. EXamen.press. 2012. p. 41.doi:10.1007/978-3-642-28986-6.ISBN 978-3-642-28985-9 – via link.springer.com.
Versions
Keywords
Related
ISO/IEC SQL parts
Main
Languages
Security
Design
Programming
Management
Lists of
See also
Types
Concepts
Objects
Components
Functions
Related topics
Retrieved from "https://en.wikipedia.org/w/index.php?title=Database_object&oldid=1261383114"
Categories:
Hidden categories:

[8]ページ先頭

©2009-2025 Movatter.jp