| Home | Sign up! | Projects | Seminars | Research Notes | Today's Lecture | About |
 Member ID: 41

## Tushar Jain

Email
tusharjain_45@sify.com

Profile: I am pursuing B.A.(Business Administration) from Coastal Carolina University(U.S.) in collabration with Ansal Institute of Technology, Gurgaon. My keen interest is in developing my own algorithms and flowcharts for programming languages. Besides academics I take part in the practice session for improvement of cricket fielding. I also love to play kho-kho & badminton.

 Course Semester Grade Add New Course Database Systems Fall 2003 View Update Course Probability & Statistics Summer 2002 View Update Course Algorithm Design - II Spring 2002 View Update Course Algorithm Design - I Fall 2001 View Update Course

### Projects (1)

 Project ID: 32Course: Database SystemsTopic: OLAP in Data warehousingUpdate Project Description: The project on which I am working is based on applications of data warehousing, that is performed through OLAP (on line analytical processing). OLAP basically used to describe the analysis of complex data from data warehousing.The term stands for (On-Line Analytical Processing) Our definition is desgined to be short and easy to remember .The OLAP definition in just five key words: Fast Analysis of Shared Multidimensional Information ---- or ,FASMI for short. 1:Fast means that the system is targeted to deliever most response to users, within about five seconds, with the simplest analyses taking no more that one second and very few taking more than 20 seconds 2: Analysis means that the system can cope with any business logic and statistical analysis that is relevant for the application and the user. 3:Shared means that the system implements all the security requirements for confidentiality and ,if multiple write acess is needed concurrent update locking at an appropriate level. 4:Multidimensional means that system must provide a multidimensional conceptual of the data , including full support for hierarchies and multiple hierarchies. 5:Information is all of the data derived information needed, wherever much is relevant for the application. Features of OLAP: a)Multidimensional Conceptual View b)Intuitive Data Manipulation c)Acessibility:OLAP as a Mediator:In this OLAP engines as middleware, sitting between heterogeneous data sources and an OLAP front end.THE FEATURE(c) IS IMPORTANT. d)Treatment of missing Values e)Extraction of Mssing Values. Olap Survey:it has found that slow query response is consistently the most often---cited technical problem with OLAP products. The Codd Rules Dr.Codd was very well known as a respected database researcher from 1960s through the late 1980s ,his Olap rules proved to be controversial due to being vendor-sponsored;rather than mathmatically based. Special Features S: 1)Treatment of Non-Normalized Data: this refer to the integration between an OLAP engine and DENORMALIZED source data. 2)Storing OLAP Results:Keeping them Seperate from Source data. 3)Unlimited Dimensions&Aggregation Levels:Basically no product can posiibly comply with this feature, because there is no such thing as an unlimited entity on a limited computer. 4)Unrestricted Cross-Dimensional Operations: All the Calculations must be allowed across all dimensions, not just 'measures' dimensions.

### Seminars (1)

 Seminar ID: 33Course: Database SystemsTopic: Flexible ReportingUpdate Seminar Description: I will present a seminar on this topic. Basically flexible reporting is where the user requires reports: There are two types of Reprting a)Uniform Reporting Perfomance:This reporting performance be not sigificantly degraded by increasing the number of dimensions or database size.Infact it is suggest that increasing the number of dimensions or data size does not affect perfomance siginficantly in fully pre-calculated database. 2)Auotmatic Adjustment of Physical level:This basically where OLAP system adjust its physical schema automatically to adapt to the type of model,data volumes and sparsity.

### Research Notes (1)

 Research Note ID: 26Course: Database SystemsTopic: Cilent Server ArchitectureUpdate Research Note Description: OLAP product should be sufficiently intelligent that various, cilents could be attached with minimium effort and programming for integration this much tougher test. However if we agree this point then we should be aware that most vendors who claim compliance,do so wrongly.

Last updated on Friday, 28th November 2003, 09:27:53 AM.