IMPLEMENTATION OF DATA WAREHOUSE ON MATERIAL PRODUCT RATE ANALYSIS

ABSTRACT

The project entitled “Material Product Rate Analysis” deals with various levels of analysis.To study,analyze

the existing source databases of material management system.Collecting the Information   and           Business

Requirement and its specifications from the organisation.Study and understand the existing System information.

This Information becomes the basis for the rational decision making to  facilitate the decision making process.

The Decision support  system(DSS) was developed.

To interact with decision makers for analyzing their business plans and decision making the material management

company .Here we analyzed required Material needs for manufacturing the electronic devices and its order product

rate based measures.According to those measures the material management company maintains the systematic approach

to purchase (products) the material.The analysis process could start from the existing summary information of material

management company.According to that information we design the source database by using the erwin 4.0 tool generates the SQL

Schema for our required Erwin Designer tool.The Erwin 4.0 tool generates the sql Schema for our required ER-model and then loads the required data into the source Database.Now we are applying the Data ware housing concepts for the multiDimensional approaches  for designing the star schema of a cube, for  the multi Dimensional approaches for designing the star schema of a cube,for that we are using another tool is informatics.To define the ETL(extract,transform& load) process algorithm creating

cubes for multi-dimensional reports generation.

Then we implement the Online-Analytical process(OLAP)  for designing the business related reports to analyze (product rates)

total product rate,maximum product rate,minimum product rate and average product rate.

I  intend to do this project because my area of interest is in Dataware house.I am familiar about

the logics and terms related to dataware house.I am realy intrested in designing dataware house applications.

I just want to give some features regarding my project.

1)Provides update information about the issues with different status from high level to bottom level

2)Helps employees to complete the isuues with co-ordination and change the status  .

3)provides easy interaction between the employees and the administrators to know that the given

schedule is going smooth or not.

The technologies and tools used in my project are as follows

SOFTWARE   AND    HARDWARE  SPECIFICATIONS

operating systems :Windows 2000NT

The system will be built on windows compaitable environment.The application will be web based using Data Ware housing web technology tools.

DATA WARE HOUSING  TOOLS:

Designing Tool:-Erwin 4.1

ETL Tool:-informatica 7.1

OLAP Tool:-Cognos 6.6/Businessobject/Brio

Data Base:-oracle 9i

Hardware:-pentium 4 2.0 GHZ with 256 MB RAM

Functional requirements specifications:

Minimum system requirements to run the informatica server.

Informatica client:-

Operating system : windows 2000NT

Disk Space  : 40 MB

RAM  : 512 RAm

Data base connectivity: ODBC drivers

Informatica repository:

Operating system   :windows 2000nt/unix

Diskspace:  60 MB

RAM  :  512 MB

Data Base connectivity  : ODBC drivers

Informatica Client Tools and Infomatica server connections:

To connect informatica  client to the….

Repository database, need the  ODBC connection for each sorce database.

Target Databases,need ODBC connection for each target database.

Informatica server,TCP/IP .

the Informatica client uses two software layers to communicate with each source,and target ,

and repository database.

ODBC drivers : native database connectivity software

APPLICATIONS AND FUTURE SCOPE:

This project is developed to support concurrent request and it  has no manage  multiple

request simultaniously.It is useful to keep tract  of data very securable and it should

not create any data loses.It allows us to create  the administrator for a project and

he/she can assign new data mart roles to the registered  database on a project.

This project can also be used in BANK to study and analyse the existing source

database of a BANK.

BIBLIOGRAPHY

REFERENCES:-

1)GUPTA, I.S MUMICK,”MAINTENANCE OF MATERIALIZED VIEWS:PROBLEMS,

TECHNIQUIES,AND APPLICATIONS .”DATA ENG.BULLETIN ,VOL.18,NO.2,JUNE 1995.

2)KIMBALL,R.THE DATA WAREHOUSE TOOLKIT.JOHN WILEY,1996.

Delete:the virtue of forgetting in digital age

Remembering and forgetting,Storage of Data,Retrieving the Data,Power and Time,Panopticon(means -in global world internet is watching every one by means of camera’s are storage  ),Time/Decision, all these issues where discussed in a book called DELETE: THE VIRTUE OF FORGETTING IN DIGITAL AGE written by Viktor Mayer-Schonberger, Winner of the 2010 Don K. Price Award for Best Book in Science and Technology Politics, Section on Science, Technology, and Environmental Politics (STEP) by the American Political Science Association.

In the past the storage and retrieval of information  was limited. So if people want to remember they used to written down the things or they have to depend of human memory. As the time past, more and the more could me recorded, but retrieving the data in analogue world was still difficult.

Power and time:

There is a loss of power, as information about us is duplicated and reused , with or with out permission , and even negation of time . Among the issues are two terrifying possibilities, that perfect memory threatens reasons, abstract thought and the ability to make decision in the present, and that the reasons for retaining data now may seem sensible, but what if it should fall into the wrong hands in the future. Having clearly and concisely built a picture of the problem, form the early days of human history to the present, Mayer then turns to some potential solutions.

* Information privacy issues.

*Digital rights management.

*Effectively tuning search engines.

That is say, every piece of information, from files on your hard drive, thought your email and even your search terms and online purchase history is given an expiration date.  Up to this point we have been taken in, we are willing  to overlook the odd overstatement–information retrieval is easy for example.

After reading this book i came to point that most of the things which viktor mayer mentioned where right.

CLOUD COMPUTING

                                   CLOUD COMPUTING

Cloud ” computing – a relatively recent term, defines the paths ahead in computer science world. Being built on decades of research it utilizes all recent achievements in virtualization, distributed computing, utility computing, and networking.

LITERATURE REVIEW:-

CLOUD COMPUTING implies a service oriented architecture through offering softwares and platforms as services, reduced information technology overhead for the end-user, great flexibility, reduced total cost of ownership, on demand services and many other things. This paper is a brief survey based of readings on “cloud ” computing and it tries to address, related research topics, challenges Cloud computing is the next generation in computation. Maybe Clouds can save the world; possibly people can have everything they need on the cloud. Cloud computing is the next natural step in the evolution of on-demand information technology services and products. The Cloud is a metaphor for the Internet, based on how it is depicted in computer network diagrams, and is an abstraction for the

CONCLUSION:-

In this report we argue that what is cloud computing?

It is actually an application.which we run on our system

Without installing it.Does it have future?yes cloud computing have

Future because it reduces the total cost of ownership,on demand

Services and many more things.Possiblely people can have everything they

Need regarding information technology on cloud in future.

There fore by this we conclude that cloud computing have future.

REFERENCES:-

• [1]  by Jeffrey Hightower, Gaetano Borriello — 2001
• [2] by C. A. R. Hoare — 1969  University of Belfast
• [3] by George A. Miller,  Christiane Fellbum, Derek Gross, Katherine Miller — 1990 — International Journal of Lexicography
• [4] by Richard Beckwith 1990 — International Journal of Lexicography
• [5] by , Derek Gross, Katherine Miller — 1990 — International Journal of Lexicography
•  

Why did i opt for MSC COMPUTING

1)    Why did i opt for MSC COMPUTING

“Time and money never waits for a man”.

Hi this is madhu.I just chose MSc computing in order to

Build my career and have a bright future by securing job in

Micro soft Software company.It was my aim

And my parents and well wishers wish to

To pursue MASTERS in computer science to reach the

Peak of success.

“Failures  are stepping stones for success”

Yes i just belive this.

Hard work never  deceives man there is noo man

Who succeeded in one night

After long period of time and hard work they achieved

The peak of success.

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!