Oracle database design and architecture

Email Alerts

Register now to receive 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
  • Oracle TimesTen In-Memory Database

    The Oracle TimesTen In-Memory Database is an in-memory relational database in which all data is located in random access memory (RAM). 

  • 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. 

  • 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.