MIDTERMS_Database-1

Created by Miguel

Zachman’s Framework
it provides a systematic way to categorize and understand an organization's architecture.

1/32

TermDefinition
Zachman’s Framework
it provides a systematic way to categorize and understand an organization's architecture.
John Zachman
Creator of Zachman’s Frame work. in the 1980s while he was at ibm and has been updated several times since to remain relevant
The interrogatives
these are the six primitive questions used to view the enterprise: What, How, When, Who, Where, and Why.
Reification transformation
this tracks the transformation of an abstract idea into a real thing. Identification, definition, representation, specification, configuration and instantiation
Matrix Format
a 6 x 6 grid (table) with 36 cells composed of rows represents the stakeholder perspectives and columns as interrogatives
OBJECT ORIENTED MODELING AND DESIGN
method of analyzing and designing systems by representing real
OBJECT ORIENTED (OO)
means that we organize software as a collection of discrete objects that incorporate both data structure and behavior
IDENTITY
Identity means that data is quantized into discrete, distinguishable entities called objects.
CLASSIFICATION
means that objects with the same data structure (attributes) and behavior (operations) are grouped into a class.
INHERITANCE
is the sharing of attributes and operations among classes based on a hierarchical relationship.
POLYMORPHISM
means that the same operation may behave differently for different classes.
DEVELOPMENT PROCESS
is a structured set of activities used to create software or system in an organized and systematic way
Database Management System
is a software system used to store, organize, manage, and retrieve large amounts of engineering data efficiently.
Automated Data Discovery
is the process of automatically finding useful information from large datasets.
Data Warehouse
collects data from different sources into one central place, where it is organized for easy analysis.
Data Mining
process of extracting hidden, useful, and predictive information from large datasets by identifying patterns, relationships, and correlations.
Classification
builds models to sort data into different categories. The model is trained on data with known labels and is then used to predict labels for unknown data.
Regression
It is used to predict continuous values, like prices or temperatures, based on past data. There are two main types:
Clustering
It helps discover hidden patterns in the data by organizing objects into clusters where items in each cluster are more similar to each other than to those in other clusters
Association rule
generates rules from the data and uses them to build a model for predictions
Anomaly detection
aims to identify rare or unusual data instances that deviate significantly from the expected patterns.
Time series analysis
It focuses on analyzing and predicting data points collected over time.
Decision trees
Graphical models that use a tree
Neural networks
A type of machine learning inspired by the human brain's structure and function
Web Cons (Web Based Construction System)
a digital platform used to manage construction projects online. It allows engineers, contractors, and project managers to store, access, and share project information such as plans, schedules, reports, and updates in one centralized system.
System design
is the planning of the system, while the development process is the step
Front End
User Interface and displays the project status, reports and dashboards, the visible part of the sytem.
Back End
The part of the system that works behind the scenes to process data and commands.
Database/Data Storage
The place where all information is stored and organized
 class model
represents the static, structural, “data” aspects of a system.
 state model
represents the temporal, behavioral, “control” aspects of a system.
 interaction model
represents the collaboration of individual objects of a system.