CBSE Class 12 Informatics Practices Advanced Database Technologies Notes

Download CBSE Class 12 Informatics Practices Advanced Database Technologies Notes in PDF format. All Revision notes for Class 12 Informatics Practices have been designed as per the latest syllabus and updated chapters given in your textbook for Informatics Practices in Standard 12. Our teachers have designed these concept notes for the benefit of Grade 12 students. You should use these chapter wise notes for revision on daily basis. These study notes can also be used for learning each chapter and its important and difficult topics or revision just before your exams to help you get better scores in upcoming examinations, You can also use Printable notes for Class 12 Informatics Practices for faster revision of difficult topics and get higher rank. After reading these notes also refer to MCQ questions for Class 12 Informatics Practices given our website

Revision Notes for Class 12 Informatics Practices Advanced Database Technologies

Class 12 Informatics Practices students should refer to the following concepts and notes for Advanced Database Technologies in standard 12. These exam notes for Grade 12 Informatics Practices will be very useful for upcoming class tests and examinations and help you to score good marks

Advanced Database Technologies Notes Class 12 Informatics Practices


Advanced Database Technologies



The term data warehouse was coined with the definition of Inmon: "A warehouse is a subjectoriented, integrated, time variant and non-volatile collection of data in support of management's decision making process" . Characteristics of DW

• Subject-oriented : Means that all relevant data about a subject is gathered and stored as a single set in a useful format. Information is presented according to specific subjects or areas of interest.

• Time-variant : Means that the data warehouse contains a history of the subject, as well as current information. It may be long-term data from five to ten years in contrast to the 30 to 60 day time..

• Non-volatile : Means stable information, Information is consistent; Data in the database is never over-written or deleted once committed.

• Integrated : Stored in a globally acceptable fashion with consistent naming conventions, measurements, encoding structures, and physical attributes, though underlying operational systems store the data differently;

Data Warehouse Architecture:
• Warehouse database server: Which is almost always a relational DBMS; rarely flat files.

• OLAP servers:- Which may either be a ROLAP or MOLAP

– Relational OLAP (ROLAP): Extended relational DBMS that maps operations on multidimensional data to standard relational operations.

– Multidimensional OLAP (MOLAP): Special purpose server that directly implements
multidimensional data and operations.

• Clients:-The Users or the client of Data warehouses are various Query and reporting tools, Analysis
tools and Data mining tools (e.g., trend analysis, prediction)

Processors in Datawarehouse server
   – Massively parallel processing, a computer configuration that is able to use hundreds or thousands of CPUs simultaneously.

   – Symmetric multi-processing is a computer configuration where many CPUs share a common operating system, main memory and disks. They can work on different parts of a problem at the same time



Steps involved in creating a Datawarehouse
• Data extraction
• Data cleaning, also called data cleansing or scrubbing,
• Data transformation
• Convert from legacy/host format to warehouse format
• Load
• Sort, summarize, consolidate, compute views, check integrity, build indexes, partition
• Refresh
• Propagate updates from sources to the warehouse

• Data warehouses enhance end-user access to a wide variety of data.
• Decision support system users can obtain specified trend reports, e.g. the item with the most sales in a
particular area within the last two years.
• Data warehouses can be a significant enabler of commercial business applications.

Data Mining
• Definition
 Data mining, the extraction of hidden predictive information from large databases

 The nontrivial extraction of implicit, previously unknown, and potentially useful information from data" and "the science of extracting useful information from large data sets or databases".

• Techniques used in Data Mining: -

Artificial neural networks

Genetic algorithms

Decision trees

Nearest neighbor method

Rule induction

Evolution of Datamining

CBSE Class 12 Informatics Practices Advanced Database Technologies Study Notes

Please refer to attached file for CBSE Class 12 Informatics Practices Advanced Database Technologies Study Notes

Books recommended by teachers

More Study Material