What You Learned in this Tutorial
During this tutorial:
• You created three separate views.
• You learned how to introspect the underlying physical data sources for selecting only the tables you needed for your modeling, and also to construct views.
• You created views to represent the activities of a particular department (Order, Purchase, or Sales) at ALPHA Manufacturing. Each department conducts its own business without having to share information with another department so the views represent internal organizational activities.
• You modeled the final, unified view from three individual views.
• You learned how to use a view as a building block in its own capacity. Because you can use a TDV database as any relational database, you can build any number or type of views you want until a view matches your business need and publish that view as a TDV database table. This task demonstrates the reusability of a view.
• You learned how to publish the composite view (CompositeView). The view was based on three separate views (ViewOrder, ViewSupplier and ViewSales). Published views are like virtual database tables and you can query them as you would the tables in a relational database.
There are many more modeling and publishing tasks you can perform using TDV, such as transforming data, creating procedures, publishing views and procedures as TDV databases and Web services, and setting up security.
For details on security and other modeling tasks, see the TDV User Guide.