Introduction to Data WarehousingWritten by Exforsys.com
This tutorial starts with introduction to Data Warehousing, Defination of OLAP, difference between Data warehouse and OLTP Database, Objectives of data warehousing and data flow. Computerization of business processes; technological advances in transmission and storage of data; and powerful database management tools have opened up new possibilities of data manipulation and analysis. Business managers are eager to explore repositories of current and historical data to identify trends and patterns in wrap and hoof of business. They hope to mine data and use them for taking intelligent business decisions. In this context, industries are increasingly focusing on data warehousing, Online Analytical Processing (OLAP), and other related technologies. What's Difference ‘Data warehouse’ and ‘OLAP’ are terms which are often used interchangeably. Actually they refer to two different components of a decision support system. While data in a data warehouse is composed of historical data of organization stored for end user analysis, OLAP is a technology that enables a data warehouse to be used effectively for online analysis using complex analytical queries. The differences between OLAP and data warehouse is tabulated below for ease of understanding: Data Warehouse Data from different data sources is stored in a relational database for end use analysis
| | Creating the Right Skin TextureWritten by Ma. Carla Balattan
Making 3D imagery more lifelike/realistic in Photoshop need custom brushes that, as much as possible, conjure up skin texture like look of body hair, skin’s surface and it’s structure. Thanks to continuous creations of custom brushes collection in Adobe Photoshop, this purpose will be achieved. In article by Dave Nagel at http://photoshop.digitalmedianet.com/articles/viewarticle.jsp?id=27156-0, a new series of custom brushes that focus on creation of textures to be used in 3D imagery has been launched. The first selections were several brushes designed to simulate appearance of body hair. Such brushes would definitely give imagery more lifelike in appearance. They have aptly termed it as texture brushes.Skin texture brushes may not only end with having body hair simulation but also with other elements that may create effect of other skin textures like smooth skin or rough skin that vary from that with pock marks, pimples, scars and blemishes. It is then, exciting to note further development and expansion in custom brushes focusing on creation of right skin texture for more realistic imagery in Photoshop. Twenty (20) new texture brushes, covering skin textures called NagelSeries 20 are launched for generating a variety of skin textures. There is a custom brush for somewhat smooth skin to skin with freckles, blemishes and pock marks. According to Nagel, collection is fairly large, consisting of some pretty complex elements that allow you to build up skin textures rather than simply applying them as you might a pattern overlay. This variety allows for much more skin texture modifications and is very helpful specially when you’re painting on UV maps. In site, Nagel gave several examples of skin textures created using custom brushes using several different colors and blending modes. The examples were built up with deep blue base and a secondary deep red layer. Lighter skin tones were then, painted over to achieve desired effect on each. To strengthen details, color and linear dodges were used in brushes. Color and linear burns are also added.
|