This course will expand upon SQL as well as other advanced topics, including query optimization, concurrency, data warehouses, object-oriented extensions, and XML. Additional topics covered in this course will help you become more proficient in writing queries and will expand your knowledge base so that you have a better understanding of the field. Upon successful completion of this course, the student will be able to: write complex queries, including full outer joins, self-joins, sub queries, and set theoretic queries; write stored procedures and triggers; apply the principles of query optimization to a database schema; explain the various types of locking mechanisms utilized within database management systems; explain the different types of database failures as well as the methods used to recover from these failures; design queries against a distributed database management system; perform queries against database designed with object-relational extensions; develop and query XML files. (Computer Science 410)
This course covers concepts of computation used in analysis of engineering systems. It includes the following topics: data structures, relational database representations of engineering data, algorithms for the solution and optimization of engineering system designs (greedy, dynamic programming, branch and bound, graph algorithms, nonlinear optimization), and introduction to complexity analysis. Object-oriented, efficient implementations of algorithms are emphasized.
Subject:
Mathematics and Statistics, Science and Technology
Survey of information technology covering database modeling, design, and implementation with an emphasis on relational databases and SQL. Internet technologies: http, html, XML, SOAP, security. Brief introduction to components and middleware. Introduction to design and implementation of multi-tier architectures, benchmarks, and performance. Data networking protocols and technologies. Students complete project that covers requirements/design, data model, database implementation, web site, and system architecture.
This graduate seminar is taught in a lecture and lab exercise format. The subject matter is tailored to introduce Environmental Engineering students to the use and potential of Geographic Information Systems in their discipline. Lectures will cover the general concepts of GIS use and introduce the material in the exercises, and exercises will introduce students to the practical application of GIS.
The book The Fourth Paradigm: Data-Intensive Scientific Discovery examines the impact that software and massive amounts of distributed data have had on the sciences. Collaboration using new Web 2.0 tools is facilitating entirely new forms of research depending heavily on how well its researchers collaborate with one another, and with technologists, in areas of eScience such as databases, workflow management, visualization, and cloud computing technologies.
The book examines how technology is changing research in the follow areas: » Earth and Environment » Health and Wellbeing » Scientific Infrastructure » Scholarly Communication
The book is considered a tribute to the lifelong work of Jim Gray, a computer scientist best known for his work in transactional processing and database technologies.
This book is current, relevant and entirely open for use by anyone as long as they share the work in a similar fashion
You can now access government directly through the web. E-government in action. While studying this unit you look at the scope of e-government, the databases that are necessary, the use of biometrics in identification and verification of identity and assess the usability and accessibility of websites.
This course provides a general overview of databases, including topics such as database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. Upon successful completion of this course, the student will be able to: compare and contrast the database approach and the file system approach; explain what a database management system is as well as the various components; identify the various people involved in database management systems; explain the historical background of database management systems; compare the various database models; describe the functions of a database management system; explain the three-schema database architecture; describe what tables, indexes, and views are as well as discuss the differences among them; explain the entity-relationship model; develop an entity-relationship model based on user requirements; describe the relational database model; explain the process of normalization; convert an entity-relationship diagram to a set of normalized relations; explain referential integrity; identify how relational algebra is used to construct queries; describe and use data definition commands; describe and use data manipulation commands; explain how to join tables together for queries. (Computer Science 403)
This unit forms gives participants an understanding of the concepts behind database development, a sense of how database work can be applied to information projects and how to start thinking about the database planning process. It is primarily about developing an awareness of databases which can form a basis for future training in more practical aspects of database development work.
Extends the computing and geographic information systems (GIS) skills developed in 11.520 to include spatial data management in client/server environments and advanced GIS techniques. First half covers the content of 11.523, introducing database management concepts, SQL (Structured Query Language), and enterprise-class database management software. Second half explores advanced features and the customization features of GIS software that perform analyses for decision support that go beyond basic thematic mapping. Includes the half-semester GIS project of 11.524 that studies a real-world planning issue.
This class uses lab exercises and a workshop setting to help students develop a solid understanding of the planning and public management uses of geographic information systems (GIS). The goals are to help students: Acquire technical skills in the use of GIS software. Acquire qualitative methods skills in data and document gathering, analyzing information, and presenting results. Investigate the potential and practicality of GIS technologies in a typical planning setting and evaluate possible applications. The workshop teaches GIS techniques and basic database management at a level that extends somewhat beyond the basic thematic mapping and data manipulation skills included in the MCP core classes (viz.11.204 and 11.220). Instead of focusing on one thematic map of a single variable, students will concentrate on more open-ended planning questions that invite spatial analysis but will require judgment and exploration to select relevant data and mapping techniques, involve mixing and matching new, local data with extracts from official records (such as census data, parcel data and regional employment and population forecasts), utilize spatial analysis techniques such as buffering, address matching, overlays use other modeling and visualization techniques beyond thematic mapping, and raise questions about the skills, strategy, and organizational support needed to sustain such analytic capability within a variety of local and regional planning settings. Students seeking graduate credit should enroll in the subject 11.520; undergraduates should enroll in the subject 11.188. The subjects meet together and have nearly identical content.
No restrictions on your remixing, redistributing, or making derivative works.
Give credit to the author, as required.
Your remixing, redistributing, or making derivatives works comes with some
restrictions, including how it is shared.
Your redistributing comes with some restrictions. Do not remix or make
derivative works.
Copyrighted materials, available under Fair Use and the TEACH Act for US-based
educators, or other custom arrangements. Go to the resource provider to see
their individual restrictions.