Oracle database design and architecture

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • in-memory database

    An in-memory database is a type of analytic database designed to streamline the work involved in processing queries. 

  • virtual private database (VPD)

    A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table. 

  • flexfield

    In an Oracle environment, a flexfield is a database field that has flexibility built into it so that users can define reporting structures that are relevant to their specific organizations. 

  • E. F. Codd (Edgar F. "Ted" Codd)

    E. F. Codd (Edgar F. "Ted" Codd) formed the concepts for organizing and accessing data that are embodied in the relational database, the predominant approach to data organization in today's business world. 

  • extent

    An extent is a set of contiguous blocks allocated in a database. 

  • row

    In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity. 

  • splay tree

    A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database. 

  • field

    A field is an area in a fixed or known location in a unit of data such as a record, message header, or computer instruction that has a purpose and usually a fixed size. 

  • quad tree

    A quad tree is a method of placing and locating files (called records or keys) in a database. 

  • record

    In computer data processing, a record is a collection of data items arranged for processing by a program. 

  • See more Definitions on Oracle database design and architecture
About Oracle database design and architecture

Have a question about best practices for Oracle database design, configuration and table design? This section contains the tips and expert adivce for DBMS versions 8, 9i, 10g and 11g to help you out.