glossary - GLOSSARY application programming interface...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
A access plan —A set of instructions, generated at application compilation time, that is created and managed by a DBMS. The access plan predetermines the way an application’s query will access the database at run time. active data dictionary —A data dictionary that is automatically updated by the database management system every time the database is accessed, thereby keeping its information current. See also data dictionary . ActiveX —Microsoft’s alternative to Java. A specification for writing programs that will run inside the Microsoft client browser (Internet Explorer). Oriented mainly to Windows applications, it is not portable. It adds “controls” such as drop-down windows and calendars to Web pages. ActiveX Data Objects (ADO) —A Microsoft object framework that provides a high-level application- oriented interface to interact with OLE-DB, DAO, and RDO. ADO provides a unified interface to access data from any programming language that uses the underlying OLE-DB objects. ad hoc query —A “spur-of-the-moment” question. ADO.NET —The data access component of Microsoft’s .NET application development framework. The Microsoft .NET framework is a component-based platform for developing distributed, heterogeneous, and interoperable applications aimed at manipulating any type of data over any network under any operating system and programming language. alias —An alternative name given to a column or table in any SQL statement. ALTER TABLE —The SQL command used to make changes to table structure. Followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. American National Standards Institute (ANSI) —The group that accepted the DBTG recommendations and augmented database standards in 1975 through its SPARC committee. AND —The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It requires that all conditional expressions evaluate to true. anonymous PL/SQL block —A PL/SQL block that has not been given a specific name. application processor —See transaction processor (TP) . application programming interface (API) —Software through which programmers interact with middleware. Allows the use of generic SQL code, thereby allowing client processes to be database server-independent. associative entity —See composite entity . atomic attribute —An attribute that cannot be further subdivided to produce meaningful components. For example, a person’s last name attribute cannot be meaningfully subdivided into other name components; therefore, the last name attribute is atomic. atomicity —See atomic transaction property . atomic transaction property —A property of transactions that states that all parts of a transaction must be treated as a single logical unit of work in which all operations must be completed (committed) to produce a consistent database. attribute
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 21

glossary - GLOSSARY application programming interface...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online