CETS468 Database Management

Course Information

• Course title: CETS468 Database Management in Construction Information Technology
• Course provider: ALL INSTITUTE OF TECHNOLOGY UNIVERSITY
• Course facilitator: Engr. Joden Sorila

Objectives

• Define information technology
• Differentiate computer and communications technology
• Learn application of information technology in civil engineering
• Discuss software applications in various civil engineering fields
• Define an information system
• Discuss basic components and functions of an information system
• Learn how information is managed in information systems
• Understand the basic principles of information systems in engineering

Information Technology

• (IT) in the 1960s and 1970s was used in specific applications, like banking and hospitals, to store data.
• The paradigm shift to computing has made IT a commonly used term in everyday life.
• IT defines an industry using computers, networks, software, programming, and other equipment to store, and retrieve information.
• Computer hardware and software have rapidly evolved, increasing accessibility and performance.
• Personal computers have become more affordable, leading to wider use.
• Software applications and tools like AutoCAD became critical for design, modeling, and drafting processes.
• Software like GIS is essential for spatially analyzing data, finding locations, enabling queries, and performing geographic overlays
• Remote sensing technology allows analyzing data from satellites or aircraft, especially useful for large areas and certain environments.

Computer Technology

• A programmable, multi-use machine that accepts raw information and processes it into usable data.
• Intended to enhance productivity and problem-solving.
• Computer Technology Includes hardware, software, internet, and storage devices.
• Hardware and software development has enhanced engineering capabilities and enabled the creation of 3-D models for projects

Communication Technology

• The act of transferring information between places, people, or groups.
• Traditional communication methods include telephones and postal services.
• Modern communication methods include email and video conferencing which enabled collaboration among different locations.
• Telecommunications technology uses electromagnetic devices for long-distance communication. A telecommunication system includes a transmitter, medium, a receiver involved elements.

Information Technology (IT) in Surveying

• Unfavorable sites, topography, and heavy equipment constraints can affect surveying projects.
• GIS (Geographical Information System) is a computer system to gather, manage, integrate, analyze, and display spatially referenced data.
• GIS used in locating suitable locations with relevant attributes and answering geographical queries.
• Remote Sensing technology interprets data from space, which is useful for very large areas at low costs. Useful for remote locations and for large scale analyses

Information Technology (IT) in Project Management

• IT supports planning, analysis, and control in project management.
• Project management software (e.g. Primavera) helps with project scheduling, workflow, and communication.
• Construction operations monitoring, time-money analysis, research, and standardization are key practices.
• Software (e.g., Primavera) allows easy dissemination of results, conversation with other projects, and standardization.

Database Management Systems (DBMS)

• Database Management Systems (DBMS) are software that stores, retrieves, and manages data.
• DBMS provides an interface between users and databases allowing users to create, read, update or delete data. Examples include MS Access, MySQL, and Oracle.

Information Systems in Construction

• Illustrates a typical flow of information within a construction environment.
• Data move across various parties involved. The roles of an engineer, purchaser, property custodian, and accounting/financial department in handling different segments of the project.

Exercises & Additional Notes

• Classroom exercise 1 involves grouping, identifying relevant database management software examples, identifying advantages and disadvantages, and submitting results using specific paper requirements.
• Classroom exercise 2 requires selecting one software type from design/modeling, surveying, and project management, listing five advantages and five disadvantages for each.