Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Key Attribute An attribute (which[…]
Read moreLatest Posts
n-tier Software Architectures,”First two tiers are Client and Server. Sometimes an application server/web server/middle tier which runs apps and stores business rules (making for a total of 2 servers – application server and client server
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review. n-tier Software Architectures,”First two[…]
Read moreOpen Database Connectivity
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Open Database Connectivity Provides an[…]
Read moreSQL Server
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SQL Server A server on[…]
Read moreDB/DC System
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DB/DC System Integration of Database[…]
Read moreData Dictionary/Repository/Information Repository,”Stores information about schemas, constraints, design decisions, usage standards
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Data Dictionary/Repository/Information Repository,”Stores information about[…]
Read moreTypes of Data Manipulation Languages,”High Level/Set-at-a-time: Can be used on its own to concisely specify database operationsLow Level/Record-at-a-time: Must be embedded in a general-purpose programming language
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Types of Data Manipulation Languages,”High[…]
Read moreDBMS Languages,”Data Definition Language – A language used where no separation of levels exists; used to define conceptual and internal schemasWhen a separation does exist:1. Storage Definition Language: Specifies internal schema2. View Definition Language: Specifies user views and their mappings to conceptual schema (SQL often takes on this role, but usually the DDL is dominent)3. Data Manipulation Language: Perform insertions, retrievals, deletions
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DBMS Languages,”Data Definition Language –[…]
Read moreSchema Evolution,”The modification of a schema
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Schema Evolution,”The modification of a[…]
Read moreIntension/Extension
Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Intension/Extension The schema of the[…]
Read more