MIDTERMS_Database-2

Created by Miguel

MODELING AS A DESIGN TECHNIQUE
 Testing a physical entity before building it.  Communication with customers  Visualization  Reduction of complexity

1/28

TermDefinition
MODELING AS A DESIGN TECHNIQUE
 Testing a physical entity before building it.  Communication with customers  Visualization  Reduction of complexity
THREE TYPES OF MODEL
 class model  state model  interaction model
DEVELOPMENT STAGES
 System Conception  Analysis  System Design  Class Design  Implementation  Testing  Training  Deployment  Maintenance
How is it used in Civil Engineering
 Helps make better decisions.  Minimize or lessen mistakes  Improves efficiency and performance.  Organized database
Softwares used in DBMS
 Microsoft Excel  MS Project  Primavera  BIM System (AutoCAD, Revit, ArchiCAD etc.)
Role of Excel in Civil Engineering
 Applied in: Structural Design Material and Cost Estimation Project Scheduling  Automates computations using formulas.  Reduce manual calculation errors
Important Engineering Applications of Excel
 Quantity Takeoff and Material Estimation  Cost Estimation & Budgeting  Inspection & Test Plan
Other Uses of DBMS Software
 Business Applications  Education Sector  Healthcare  Banking & Finance
Advantages of Using DBMS
 Data Organization  Data Accuracy & Consistency  Easy Data Access  Better Decision-Making
Challenges in DBMS Implementation
 Data Quality Issues  Training Requirements  Scalability Concerns  System Integration
Key Features of automated information discovery
 Automation  Data Integration  Visualization  Pattern Recognition  User Accessibility
How Automated Data Discovery Works
 Collects data from multiple sources (databases, files, systems)  Organizes and prepares the data for analysis  Uses algorithms to detect patterns, identify trends, and find relationships  Display results using charts, graphs, and dashboards
Importance of Automated Data Discovery
 Saves Time  Improves Accuracy  Better Decision-Making  Handles Big Data  Increases Productivity
How does data warehousing work
 Extract  Transform  Load
Data Warehouse Architecture
 Top Tier  Middle Tier  Bottom Tier
Types of Data Warehousing
 Enterprise Data Warehouse (EDW)  Operational Data Store (ODS)  Data Mart
Key Features of data warehousing
 Centralized data storage  Historical data tracking  Fast query performance  Structured and organized data
Benefits/Advantage of using Data Warehouse
 Better decision-making  High-quality, clean data  Supports AI and analytics  Easy reporting and dashboards  Single source of truth
Drawbacks/Disadvantage of using Data Warehouse
 High Cost  Time Consuming Setup  Complexity  Not-Real Time (In some cases)  Maintenance Required
Uses of Data Mining
 Predicting customer behavior and trends  Fraud detection and prevention  Risk modeling and management  Market analysis and business decision making  Corporate performance analysis
Real World Applications Of Data Warehousing & Data Mining
 Concrete quality control  Construction project management  Structural health maintenance  Transportation engineering  Disaster risk management  Geotechnical engineering
OBJECTIVES OF WEB-CONS
 Improve Communication  Better Project Monitoring  Centralized Data Management  Increase Efficiency  Support Decision Making
SYSTEM FLOW
 User inputs data  Data Send to Server  Stored in Database  Results Displayed to user
DEVELOPMENT PROCESS
 Planning  Design  Coding  Testing  Deployment
FUNCTIONS OF WEB-BASED DEVELOPMENT SYSTEMS
 Project team development  Communications  Bidding Module  Information Control  Progress Control  Reprographic Module
FEATURES OF WEB-BASED DEVELOPMENT SYSTEMS
 Global Accessibly  Enhanced Collaboration  Efficiency and Accuracy  Real time progress tracking  High quality data management  Knowledge retention
ADVANTAGES OF WEB-BASED CONSTRUCTION SYSTEM
 Real Time Collaboration And Communication  Document Management And Accountability  Resource And Cost Efficiency
DISADVANTAGES OF WEB-BASED CONSTRUCTION SYSTEM
 Technical Vulnerability  Economic Burden  Human and Data Reliability