PDF from CSE at Jawaharlal Nehru Technological University, Kakinada. Data ware house and data mining VIVA questions and answers 1. What is data. Following are top data ware house and data mining VIVA questions and answers. What is data warehouse? A data warehouse is a electronic storage of an. But, Data dictionary contain the information about the project information, graphs, abinito commands and server information. Download PDF.
|Language:||English, Spanish, Hindi|
|Genre:||Health & Fitness|
|Distribution:||Free* [*Registration Required]|
DWDM Viva Question - Download as PDF File .pdf), Text File .txt) or read online . (a)Iceberg Query Method (b)Data Analyzer (c)Intelligent Query answering. Download as PDF, TXT or read online from Scribd. Flag for Following are top data ware house and data mining VIVA questions and answers 2/29/ We provide the most desired book qualified Viva Questions And Answers Of Simple . and answers pdf. download: compiler design viva questions and answers pdf . dwdm lab viva questions and answers 6. dwdm anna university question.
What is ETL? ETL is a software which is used to reads the data from the specified data source and extracts a desired subset of data.
Next, it transform the data using rules and lookup tables and convert it to a desired state. Then, load function is used to load the resulting data to the target database.
What is VLDB? These are decision support systems which is used to server large number of users. What is real-time datawarehousing?
Real-time datawarehousing captures the business data whenever it occurs. When there is business activity gets completed, that data will be available in the flow and become available for use instantly.
What are Aggregate tables? Aggregate tables are the tables which contain the existing warehouse data which has been grouped to certain level of dimensions. It is easy to retrieve data from the aggregated tables than the original table which has more number of records.
This table reduces the load in the database server and increases the performance of the query. What is factless fact tables?
How can we load the time dimension? Time dimensions are usually loaded through all possible dates in a year and it can be done through a program. Here, years can be represented with one row per day. What are Non-additive facts? Non-Addictive facts are said to be facts that cannot be summed up for any of the dimensions present in the fact table.
If there are changes in the dimensions, same facts can be useful. What is conformed fact? What is Datamart?
A Datamart is a specialized version of Datawarehousing and it contains a snapshot of operational data that helps the business people to decide with the analysis of past trends and experiences. A data mart helps to emphasizes on easy access to relevant information. What is Active Datawarehousing? DWH contain many subject areas.
If there will be DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high level definitions. Metadata is data about data. What is the difference between dependent data warehouse and independent data warehouse? Subscribe to view the full document. The Hybrid datamart having source data from Operational systems or external files and central Datawarehouse as well.
Data discrimination is the comparison of the general features of the target class objects against one or more contrasting objects. What do you mean by web content mining? Web content mining refers to the discovery of useful information from Web contents. List some application of text mining.
Web structure mining studies the model underlying the link structures of the Web. What are frequent patterns? These are the patterns that appear frequently in a data set. It has been used for search engine result ranking and other Web applications.
What are different types of multimedia data? What is data characterization? Data Characterization is s summarization of the general features of a target class of data. What is spatial data mining? If there are n dimensions.
Distinct features of such as analysis include time-series data analysis. World Wide Web. A database that describes various aspects of data in the warehouse is called metadata. What do you mean by evolution analysis? Data evolution analysis describes and models regularities or trends for objects whose behavior change over time.
Why is association rule necessary? In data mining. What are the components of data mining? It is intended to identify strong rules discovered in database using different measures of interesting. What are data mining techniques? These data objects are called outliers. What are outliers? A database may contain data objects that do not comply with the general behavior or model of the data.
List the demerits of distributed data warehouse. Traditional data mining tools Dashboards Text mining tools All queries must be repeated.
What are the usage of metadata? Data Warehouse.
What are two types of data mining tasks? Descriptive task Predictive task List different data mining tools. Although this may include characterization. What is Data purging?
The process of cleaning junk data is termed as data purging. This usually happens when the size of the database gets too large. Purging data would mean getting rid of unnecessary NULL values of columns. If there are 3 dimensions. Follow me: Twitter Facebook http: What is the main goal of data mining? Prediction Apache Spark. List the typical OLAP operations. Masters in Information System. What are the characteristics of data warehouse? Integrated Non-volatile Subject oriented Time varient The support for a rule R is the ratio of the number of occurrences of R.
Specialized in Web Application technologies like reactjs. List the advantages of star schema. Free Download Notes and Books 2.
A data warehouse is a electronic storage of an Organization's historical data for the purpose of About Me reporting. Marketting etc.. C programming http: On the other hand. Operating System WordPress Data marts are generally designed for a single subject area..
A data warehouse helps to integrate data and store them historically so that we can analyze different aspects of business including. Search Technology BY: An organization may have data pertaining to different departments like Finance. For an example. Using Data mining. A data mining extension can be used to slice the data the source cube in the order as discovered by Cognitive Science data mining. System and Modeling A decision tree is a tree in which every node is either a leaf node or a decision node.
The decision tree is not affected by Automatic Data Preparation.
This algorithm can be used in the initial stage of software testing. Explain how to use DMX-the data mining query language. Data warehouse and Data But if I say.
This tree takes an input an object and outputs some decision. It is based on relational concepts and mainly used to create and manage the data mining models.
Web Security Custom rollup operators provide a simple way of controlling the process of rolling up a member to its parents values. Data Structures and Algor E.. Software Security 6. If there will be DHW of bank then there can be one data mart for accounts. Continuous data System Analysis and Desig can be considered as data which changes continuously and in an ordered fashion. Technically speaking. Design and Analysis of Alg Introduction to Information Rs QA http: These models help to identify relationships PHP between input columns and the predictable columns.
There is a third type of Datamart called Hybrid. Internet Technology These product.