The construction of a warehouse using data from DuPont Pharmaceutical’s Clinical Pharmacokinetics Group with the SAS/Warehouse Administrator product is described herein. Data sources incorporated into the pharmacokinetic warehouse existed in multiple formats (Oracle, Excel, SAS data sets, etc) and were represented by numerous individual files, rather then few large files. In most cases, the da...

In Data Warehousing, Extraction-Transformation-Loading (ETL) are the key tasks that are responsible for the extraction of data from several sources, their cleansing, customization and insertion into data warehouse [10]. More specifically ETL tools are category of specialized tools with the task of dealing with data warehouse cleaning and loading problems. These task are very critical in every d...

The effective analysis and understanding of huge amount of mobility data have been a hot research topic in the last few years. In this paper, we introduce Mob-Warehouse, a Trajectory Data Warehouse which goes a step further to the state of the art on mobility analysis since it models trajectories enriched with semantics. The unit of movement is the (spatio-temporal) point endowed with several s...

Jacobson et al. [JKSH13] hypothesized that the local coherency of the generalized winding number function proposed in that work could be used to correctly determine consistent facet orientations in polygon meshes. We report on an approach to consistently orienting facets in polygon meshes by minimizing the Dirichlet energy of generalized winding numbers. While the energy can be concisely formul...

Active data warehousing is rapidly changing the landscape for deployment of decision support solutions. The trend toward actionable business intelligence demands that capabilities for tactical and event-driven decision-making be supported in addition to traditional uses of the data warehouse for strategic decision-making. The resulting challenges to deliver extreme service levels in the areas o...

Data warehouse systems are used for decision-making purposes. The Online Analytical Processing (OLAP) tools are commonly used to query and analysis of results on such systems. It is complex task for non-technical users (executives, managers etc.,) to query the data warehouse using OLAP tool keeping in view the schema knowledge. For such data warehouse users, a natural language interface is a vi...

in this paper, a facility location problem of distribution systems, as one of the important and strategic issues in supply chain management, has been studied in a three-level supply chain under a stochastic condition. for this purpose, a two-stage mathematic model has been proposed for the location-allocation problem of distribution systems with regard to backup facilities for disrupting wareho...

Data warehouses are complex systems consisting of many components which store highlyaggregated data for decision support. Due to the role of the data warehouses in the daily business work of an enterprise, the requirements for the design and the implementation are dynamic and subjective. Therefore, data warehouse design is a continuous process which has to reflect the changing environment of a ...

Data warehouse architectural choices and optimization techniques are critical to decision support query performance. To facilitate these choices, the performance of the designed data warehouse must be assessed. This is usually done with the help of benchmarks, which can either help system users comparing the performances of different systems, or help system engineers testing the effect of vario...

Quantitive evaluations show that many data warehouse projects fail at an alarming rate, wasting all the time, money, and effort spent on them. Cost overruns and schedule delays are attributed in large part, to problems associated with requirements. Therefore, a crucial success factor for the implementation of data warehouse systems is efficient requirements management. In this paper we introduc...