database terms
Terms
undefined, object
copy deck
- JDBC
- java database connectivity, middleware that allows a webserver to talk to a database server
- linking table
- used in a many to many relationship, creates compound key with two foreign keys
- inverted tree
- Hierarchichal Model, with a parent, child relationship (root, node). Limited by 1 parent
- RDBMS
- relational database management systems.
- attribute
- field, column
- child
- structure of a hierachical datbase model, can have only 1 parent , network model (member) with multiple parents
- table
- group of rows, fields
- flat file
- model of database with a delimiter ex:Comma Separated Values
- record
- row, tuple
- index
- group of fields you can search by
- Perl
- programming language that allows web server to talk to database server, practical extraction and reporting language, command line
- ODBC
- microsoft owned middleware that allows a webserver to talk to a database server, object database connectivity
- PHP
- not full programming language that allows web serve to talk to database server, used to create API, scripting language
- Apache
- open source webserver
- field
- column attribute
- parent
- structure of a hierachical and network (owner)database model, can have children
- database
- organized files/records for a purpose
- ColdFusion
- database middleware that allows a webserver to talk to database server,open source
- query
- search
- primary key
- unique value for each record ideally every table must have, alphanumeric
- Javascript
- scripting language for browsers
- MS Access
- RDMS for microsoft
- foreign key
- required for 1-1 or 1-many relationships, not in every table
- SQL
- structured query language for all databases that allows you to build, design
- middleware
- one way a web server talks to a database server, type of API, part html part SQL example: coldfusion
- API
- application program interface, translator
- mySQL
- open source database management system