MySQL, Java, JSP, Servlet, SSH, Tomcat Web Hosting Blog

Materialized view A physically preconstructed view of data containing data copied into the materialized view. Materialized views can be highly efficient in read-only environments and are often used for replication, distribution and in data warehouses. Metadata The tables and the fields defining the structure of the data; the data about the data. Method The equivalent to a relational database stored procedure, except that it executes on the data contents of an object, within the bounds of that object. Microsoft Windows The Microsoft Windows operating system. Multi-valued dependency A field containing a comma-delimited list or collection of some kind. A collection could be an array of values of the same type. Those multiple values are dependent as a whole on the primary key, the whole meaning the entire collection in the comma-delimited list. Each individual value is not dependent on the primary key. Nested query A query executed from within another query. In theory, queries can be nested up to any number of hierarchical layers. The only limitation is on complexity and the abilities of the programmer. Network A system of connected computers. A local area network (LAN) is contained within a single company, in a single office. A wide area network (WAN) is generally distributed across a geographical area even globally. The Internet is a very loosely connected network, meaning that it is usable by anyone and everyone. Network database model Essentially a refinement of the hierarchical database model. The network model allows child tables to have more than one parent, thus creating a networked-like table structure. Multiple parent tables for each child allow for many-to-many relationships, in addition to one-to-many relationships. Non trivial multi-valued dependency A multi-valued dependency with more than two fields in the table. (See Multi valued dependency.) Non-identifying relationship The child table is not dependent on the parent table, such that the child table includes the parent table primary key as a foreign key, but not as part of the child table s primary key. In other words, the parent record does not require, that a related record, exists in the child table. A foreign key field can contain a NULL value, and it can t be a part of the primary key because a primary key requires uniqueness. Normal Forms The steps contained within the process of Normalization. Normal Forms are cumulative, such that a database model in 3rd Normal Form is in both 2nd and 1st Normal Forms, but not Boyce-Codd (can be the same as 3rd Normal Form), 4th, 5th Normal Form, or Domain Key Normal Form. Normalization The process of simplifying the structure of data. Normalization increases granularity and Granularity is the scope of a definition for any particular thing. The more granular a data model is, the easier it becomes to manage, up to a point, depending, of course, on the application of the database model. NOT NULL constraint A constraint that implies a field must have a value placed into it; otherwise, an error is returned. 413 Glossary
Visit our web design programs services for an affordable and reliable webhost to suit all your needs.