Course Outline no. 467
.Adobe Acrobat Reader required.
Printable (.pdf) version of
Course Outline no. 467 .
Adobe Acrobat Reader required.
For Whom Intended This course is for individuals who are involved in logistics inventory control or general database development. It is applicable to such areas as Defense, Manufacturing, Utilities, Electronics, Automotive, Medical, Telecommunications, Computers, Aerospace and Universities.
Brief Course Description The Large organizations may encounter problems with multiple database systems that use schema instances that lack interoperability and visibility. The source of this problem can frequently be traced back to organizational mergers and/or prior budget constraints that prevented the migration and merging of existing datasets. This then leads to a database instance with a standalone schema for each functional area of the organization. It is not uncommon to find a variety of database application server types (Oracle, SQL Server and MySQL) distributed among the functional areas of the organization.
Database schema aggregation provides a short and long term solution to this problem. Schema aggregation enables the organization to focus on the high value data sets by creating an optimized and amalgamated view of the data. This view is realized through traditional tables that hold ephemeral instances of the data that have been pulled from the source databases and transformed into the aggregate tables. The design of an aggregate schema provides an opportunity to sub-model the datasets that are currently organized by functional area into a comprehensive data hierarchy that avoids ambiguity.
In the short term, aggregation creates a unified data view while working with the existing database systems. In the long run it provides a road map for the eventual migration of the datasets to a global instance that requires less overhead to maintain.
Diploma Programs This course may be used as an optional course for any TTi specialist diploma program.
Prerequisites There are no definite prerequisites for this course. However, this course is aimed toward individuals involved in a related technical field. Supervisors are invited to telephone or e-mail TTi on prospective attendees’ backgrounds and needs.
Text Each student will receive a course workbook, including most of the PowerPoint slides used during the course presentation.
Course Hours, Certificate and CEUs Open courses meet seven hours per day. Upcoming presentation dates can be found on our current open course schedule. Class hours/days for on-site courses can vary from 14-35 hours over 2-5 days as requested by our clients. Upon successful course completion, each participant receives a certificate of completion and one Continuing Education Unit (CEU) for every ten class hours.
Printable (.pdf) version of course outline no. 467 ( Adobe Acrobat Reader required).
| Schedule | Instructors | On-Site | Register | Home |
Instructors · On-Site Courses · To Register · Open course schedule · For More Information · Home
© Technology Training, Inc. 2008
BJA 081007 new#/090429