Skip to main content

Data Warehouse and Warehousing || Basic To Advance Concepts

Image
By


DATA WAREHOUSE
Data warehouse is a collection of data that support decision making processes. It provide the following features are
·        Subject oriented
·        Consistent
·        Shows its evaluations over time
·        Non volatile
A data warehouse is a central location where consolidated data from multiple locations are stored. It is like a relational database design for analytical processing.

DATA WAREHOUSING
Data warehousing is the act of organizing data and storing data in a way so as to make its retrieval efficient and insightful. Also called data as the process of transferring  data into information. Is a collection of method, techniques, and tools to support knowledge workers to conduct data analysis that help with performing decision making process and improving information resources.

Labels:

Comments

Post a Comment

Thank you for comment.

Popular posts from this blog

Computer Fundamentals Important Questions For BCA Students

By
                                                                                                                                                                     UNIT-1   Q1 . Explain the block diagram of a computer system and describe the functions of each component in detail. Q2.   Describe the different generations of computers and discuss the major technological developments in each generation. Q3. Compare the different types of computers – micro, mini, mainframe, and supercomput...
Post a Comment
Read more

Computer Fundamentals Important Questions For BCA Students(One Liner)

By
 Q1. Who is called the Father of Computers?    Ans  Charles Babbage. Q2. What is processor speed measured in? Ans  Hertz (Hz), usually in GHz. Q3. What are registers? Ans Small high-speed memory locations inside the CPU. Q4. What is the full form of ALU? Ans Arithmetic Logic Unit. Q5. What is EPROM? Ans Erasable Programmable Read Only Memory. Q6. What does CD-R stand for? Ans Compact Disc – Recordable. Q7. What does DVD stand for? Ans Digital Versatile Disc. Q8. What is OCR? Ans Optical Character Recognition – reads printed text. Q9. What is OMR? Ans Optical Mark Recognition – reads marks on answer sheets or forms. Q10. What is MICR? Ans Magnetic Ink Character Recognition – used in bank cheques. Q11. What is a joystick? Ans  A pointing device used for gaming and simulation. Q12. What is a digitizer? Ans Converts drawings into digital data. Q13. What is a CRT monitor? Ans Cathode Ray Tube monitor – uses electron beams to display images. Q14. What is an LCD m...
Post a Comment
Read more

Computer Fundamentals MCQ Questions For BCA 1st sem. Students

By
  Q1.Which of the following is not a characteristic of a computer? a) Accuracy b) Diligence c) Intelligence d) Speed → Answer: c) Intelligence Q2.The first generation of computers used a) Transistors b) Vacuum tubes c) Integrated Circuits d) Microprocessors → Answer: b) Vacuum tubes Q3. Which of the following is a microcomputer? a) Laptop b) Mainframe c) Supercomputer d) Minicomputer → Answer: a) Laptop Q4. The ALU of a computer performs a) Logic and arithmetic operations b) Storage functions c) Data transfer d) Input-output operations → Answer: a) Logic and arithmetic operations Q5. The brain of a computer is: a) CPU b) Monitor c) Keyboard d) Hard Disk → Answer: a) CPU Q6. Which component interprets and executes instructions? a) Control Unit b) ALU c) Memory Unit d) Input Unit → Answer: a) Control Unit Q7. The speed of the processor is measured in a) Hertz b) Bits c) Bytes d) Seconds → Answer: a) Hertz Q8. Which of the following represents the fifth generation of computers? a) Vac...
Post a Comment
Read more