a few functional data sets, throughout conceivably extensive stretches of time, they will in general be significant degrees bigger than functional data sets; endeavour information distribution centres are projected to be many gigabytes to terabytes in size. The jobs are inquiry serious with for the most part specially appointed, complex questions that can get to a large number of records and play out a great deal of sweeps, joins, and totals. Inquiry throughput and reaction times are a higher priority than exchange throughput. To work with complex examinations and representation, the information in a stockroom is commonly displayed multidimensional. As indicated by P.Sarada Devi, V.Visweswara Rao and Raghavendra as in, Data stockroom is an assortment of heterogeneous information which can viably and effectively deal with the information from various data sets in a uniform design. Notwithstanding information warehousing ETL, numerous innovations, for example, ERP, SCM, SAP, BI apparatuses are utilized on the planet market for dealing with organized information productively and effectively. In request to deal with the enormous measure of organized, semi organized and unstructured information created by various interpersonal organization or ventures, Hadoop is being utilized. Hadoop is a system created as an Open Source Software dependent on papers distributed in 2004 by Google Inc. that arrangement with the \"Guide Reduce\" conveyed preparing and the \"Google File System\", a framework they had used to scale their information handling needs. HDFS is the capacity part of Hadoop. It's a conveyed document framework that is designed according to the Google File System paper. Documents in HDFS are put away across at least one squares, and each square is commonly 64 MB or bigger. Squares are recreated across numerous hosts in the Hadoop group to assist with accessibility and adaptation to internal failure. HDFS can store colossal measures of data, increase gradually and endure the disappointment of huge pieces of the capacity framework without losing information. Hadoop makes groups of machines and facilitates work among them. Groups can be worked with reasonable PCs. In the event that one comes up short, Hadoop keeps on working the group without losing information or intruding on work, by moving work to the leftover machines in the bunch. HDFS oversees capacity on the group by breaking approaching documents into pieces, called \"hinders,\" and putting away every one of the squares needlessly across the pool of workers. In the normal case, HDFS stores three complete duplicates of each document by replicating each part of three distinct workers. 5.5 SUMMARY Data warehousing is quicker and savvy when contrasted and Apache Hadoop. Unlike customary ETL devices, Hadoop perseveres the crude information and can be utilized to re-measure it over and over in an extremely effective way .Hadoop for the most part measure semi organized and unstructured information additionally, though Data Warehouse is most appropriate for handling just organized information productively. 101 CU IDOL SELF LEARNING MATERIAL (SLM)
Thus, the functional/conventional information bases are utilized to store an application explicit information relating to an Organization or Enterprise. This information is utilized for question purpose. But, to store huge measure of information contrasted with Traditional data set, which is additionally utilized for investigation reason, in view of which the business choices are made, Datawarehouse’s are kept up with. In contrast, to store Zettabytes of organized/unstructured powerful information, Hadoop circulated File frameworks are utilized. These are more effective and shortcoming open minded. The logical writing shows that the limits among purging and changing are regularly obscured from the phrased perspective. Therefore, a particular activity isn't in every case unmistakably appointed to one of these stages. This is clearly a conventional issue, however not a considerable one. We will embrace the methodology utilized by Hoffer and others to make our clarifications as clear as could really be expected. Their methodology expresses that purifying is basically pointed toward redressing information esteems, and change all the more explicitly oversees information designs. Part 10 talks about every one of the subtleties of the information organizing configuration stage. Part 3 arrangements with an early information distribution centre plan stage: reconciliation. This stage is vital in case there are heterogeneous sources to characterize a pattern for the accommodated information layer, and to explicitly change functional information in the information organizing stage. Relevant information is gotten from sources in the extraction stage. You can utilize static extraction when an information stockroom needs populating interestingly. Thoughtfully talking, this resembles a depiction of functional information. Gradual extraction, used to refresh information distribution centres consistently, holds onto the progressions applied to source information since the most recent extraction. Steady extraction is regularly founded on the log kept up with by the functional DBMS. If a timestamp is related with functional information to record precisely when the information is changed or added, it very well may be utilized to smooth out the extraction interaction. Extraction can likewise be source driven on the off chance that you can revamp functional applications to no concurrently tell of the progressions being applied, or on the other hand if you’re functional data set can execute triggers related with change exchanges for pertinent information. The information to be extricated is chiefly chosen based on its quality. Transformation is the centre of the compromise stage. It changes over information from its functional source design into a particular information stockroom design. In the event that you execute a three-layer design, this stage yields your accommodated information layer. Autonomously of the presence of an accommodated information layer, building up a planning between the source information layer and the information distribution centre layer is by and large made troublesome by the 102 CU IDOL SELF LEARNING MATERIAL (SLM)
presence of various, heterogeneous sources. If so, an intricate mix stage is required when planning your information distribution centre. It is evident that utilizing customary dialects, like SQL, to communicate these kinds of questions can be an undeniably challenging errand for unpractised clients. It is additionally evident that running these kinds of questions against functional information bases would result in an unsuitably long reaction time. The multidimensional model starts with the perception that the components influencing dynamic cycles are venture explicit realities, like deals, shipments, emergency clinic affirmations, medical procedures, etc. Examples of a reality relate to occasions that happened. For instance, each and every deal or shipment did is an occasion. Every reality is depicted by the upsides of a bunch of pertinent measures that give a quantitative portrayal of occasions. For model, deals receipts, sums dispatched, medical clinic affirmation expenses, and medical procedure time are measures. Clearly, an enormous number of occasions happen in run of the mill ventures—beyond any reasonable amount to break down individually. Envision putting them all into a n-dimensional space to assist us with rapidly choosing and figure them out. The n-dimensional space tomahawks are called investigation measurements, and they characterize alternate points of view to single out occasions. For instance, the deals in a store chain can be addressed in a three- dimensional space whose measurements are items, stores, and dates. As far as shipments are concerned, items, shipment dates, requests, objections, and terms and conditions can be utilized as measurements. Medical clinic affirmations can be characterized by the office date-patient mix, and you would have to add the kind of activity to group a medical procedure tasks. The idea of measurement offered life to the extensively utilized analogy of 3D shapes to address multidimensional information. As per this analogy, occasions are related with 3D shape cells and 3D square edges represent investigation measurements. If multiple measurements exist, the 3D square is known as a hypercube. Each block cell is given an incentive for each action. Figure 1-10 shows a natural portrayal of a block wherein the truth of the matter is a deal in a store chain. Its examination measurements are store, item and date. An occasion represents a particular thing sold in a particular store on a particular date, and it is portrayed by two measures: the amount sold and the receipts. This figure features that the 3D square is scanty—this implies that numerous occasions didn't really occur. Obviously, you can't sell each thing consistently in each store. 103 CU IDOL SELF LEARNING MATERIAL (SLM)
5.6 KEYWORDS Adaptive management- A deliberate way to deal with simply deciding and changes because of new data and changes in setting. Afforestation-Creation of timberland on regions not normally forested as of late. Agroforestry-Restoration and economical administration of existing rural land through combination of trees in the farming scene. Applied nucleation-Planting trees in little gatherings or 'cores' and dependence on seed-dispersal out from such cores to re-establish woods cover across the whole reclamation site. Assisted natural regeneration - Managing the course of regular timberland recovery to accomplish woodland biological system recuperation all the more rapidly, through mediations like fencing, weeding and improvement plantings. 5.7 LEARNING ACTIVITY 1. Create a session on Operational Database Systems. ___________________________________________________________________________ ___________________________________________________________________________ 2. Create a survey on Data Warehouse. ___________________________________________________________________________ ___________________________________________________________________________ 5.8 UNIT END QUESTIONS A. Descriptive Questions Short Questions 1. What is Enterprise Data Warehouse? 2. What is Data Mart? 3. Define Real time Data Warehouse? 4. Define Integrated Data Warehouse? 5. Write the meaning of Operational Database Systems? Long Questions 1. Explain the History on warehouse. 2. Elaborate the concept of data warehouse. 104 CU IDOL SELF LEARNING MATERIAL (SLM)
3. Examine the Characteristics of data warehouse. 4. Illustrate the Difference between Operational Database Systems and Data Warehouse. 5. Discuss on the advantages of data warehouse. B. Multiple Choice Questions 1. Which of the following is not a component of a data warehouse? a. Metadata b. Current detail data c. Lightly summarized data d. Component key 2. Which of the following is not a kind of data warehouse application? a. Information processing b. Analytical processing c. Data mining d. Transaction processing 3. What is data warehouse architecture is based on? a. Dbms b. Rdbms c. Sybase d. Sqlserver 4. Which supports basic OLAP operations, including slice and dice, drill-down, roll-up and pivoting. a. Information processing b. Analytical processing c. Data mining d. Transaction processing 5. What are the core of the multidimensional model is the which consists of a large set of facts and a number of dimensions. a. Multidimensional cube b. Dimensions cube c. Data cube 105 CU IDOL SELF LEARNING MATERIAL (SLM)
d. Data model Answers 1-c, 2-c, 3-b, 4-c, 5-b 5.9 REFERENCES References book Richard, E. W., & Paul, R. M., & Robert, J. W. (1983). Competitive Bidding and Proprietary Information. Journal of mathematical Economics. Ross, J.W., & Beath, C.M.,& Goodhue, D. L. (1996). Develop long-term competitiveness through IT assets. Sloan Management Review. Schlegel, K., & Sood, K. (2007). Business Intelligence Platform Capability Matrix. Textbook references Solberg Søilen, K. (2015). A place for Intelligence studies as a Scientific Discipline. Halmstad, Sweden: Journal of Intelligence Studies in Business. Turban, E., & Sharda, R., & Delen, D. (2010). Decision Support and Business Intelligence Systems (9th ed.). Upper Saddle River NJ: Prentice Hall Press. Tyson, K.W.M. (1986). Business intelligence: Putting it all together. Lombard: Leading Edge Publications. Website https://en.wikipedia.org/wiki/Warehouse http://www.ijetjournal.org/Volume1/Issue5/IJET-V1I5P5.pdf https://content.wisestep.com/data-warehousing-characteristics-functions-pros-cons/ 106 CU IDOL SELF LEARNING MATERIAL (SLM)
UNIT - 6 ARCHITECTURE FOR A DATA WAREHOUSE STRUCTURE 6.0 Learning Objectives 6.1 Introduction 6.2 Architecture for a Data Warehouse 6.3 Fact and Dimension Tables 6.4Data Warehouse Schemas 6.5 Summary 6.6 Keywords 6.7 Learning Activity 6.8 Unit End Questions 6.9 References 6.0 LEARNING OBJECTIVES After studying this unit, you will be able to: Appreciate the Architecture for a Data Warehouse. Illustrate the Fact and Dimension Tables. Explain the Data Warehouse Schemas. 6.1 INTRODUCTION For the principal assignment of information procurement, the information extraction, standard interfaces or doors are frequently utilized in business extraction apparatuses and exclusive extraction scripts. Albeit regularly disparaged, information extraction is perhaps the most tedious errands of datum stockroom advancement, uniquely when more established inheritance frameworks should be incorporated. Ordinarily, information removed from functional frameworks contains bunches of blunders, and should be first changed and cleaned prior to stacking it into the information distribution centre. Information esteems from functional frameworks can be erroneous, conflicting, indistinguishable or inadequate. Besides, various arrangements and portrayals might be utilized in the different functional frameworks. Especially, for the joining of outside information, information cleaning is a fundamental undertaking to get right and subjective information into the information 107 CU IDOL SELF LEARNING MATERIAL (SLM)
stockroom, and incorporates the accompanying errands: • convert information to the normal, interior distribution centre arrangement from an assortment of outer portrayals • distinguish and kill copies and unimportant information • change and enhance information to address esteems • accommodate contrasts between numerous sources, because of the utilization of homonyms , equivalent words or various units of estimation. In the wake of cleaning, information that comes from various sources and will be put away in a similar stockroom table should be consolidated and conceivably set into a typical degree of detail. Moreover, time relateddata is generally added to the stockroom information to permit the development of accounts. As referenced over, one of the principle qualities of an information stockroom is the creation and capacity of new base information. Consequently, past separating and incorporating existing functional information, inferred and amassed information should be determined utilizing fitting capacities or rules. At last, previously or during stacking information into the stockroom, further undertakings like separating, arranging, parcelling and ordering are frequently required. Populating the objective distribution centre is then performed utilizing a DBMS's mass information loader or an application with installed SQL. Figure 6.1: Data Warehouse The exceptional idea of stockroom information and access requires changed instruments for information stockpiling, question handling and exchange the executives. Complex questions and tasks including enormous volumes of information require unique access strategies, stockpiling constructions and inquiry preparing procedures. For instance, bitmap records and different types of join lists can be utilized to essentially decrease access time. Besides, since admittance to stockroom information is for the most part perused situated, complex simultaneousness control instruments and exchange the executives should be adjusted. Admittance to the information stockroom can likewise be speeded up by settling subsets of it in type of information stores. An information store is a chosen some portion of the information distribution centre which upholds explicit choice help application prerequisites of 108 CU IDOL SELF LEARNING MATERIAL (SLM)
an organization's specialization or topographical area. It generally contains basic recreates of stockroom segments or information that has been additionally summed up or gotten from base distribution centre information. Rather than running impromptu inquiries against a colossal information stockroom, information shops permit the productive execution of anticipated questions over a fundamentally more modest data set. The proposition of virtual information stockrooms is considered as an approach to quickly carry out an information distribution centre without the need to store and keep up with numerous duplicates of the source information. Virtual information stockrooms regularly give a beginning stage to associations to realize what end-clients are truly searching for. End- clients have the likelihood to straightforwardly get to ongoing source information utilizing progressed organizing abilities instruments. The disadvantages of this methodology contrasted with the traditional information stockroom approach. Today, a plenty of instruments, especially for explicit assignments of a DWS like information procurement, access and the board is accessible on the lookout. For the execution of a total DWS, a bunch of instruments should be incorporated to frame a substantial warehousing arrangement. A definitive joining objective is to keep away from interface issues. The pattern is towards \"open\" arrangements which offer the chance to join a few apparatuses in one DWS. For instance, the HP Open Warehouse is a structure for planning information distribution centres dependent on HP-and third-party equipment and programming parts. HP- clients can look over arrangements in regions such information extraction and change, social data sets, information access and announcing, OLAP, internet browsers applications and information mining. A further ongoing business sector pattern is the reception of information stores as an approach to utilize and explore different avenues regarding information stockroom innovation specifically offices. Connecting information distribution centre to the Internet acquires consideration since it permits organizations to stretch out the extent of stockroom to outside data. Up to this point, the exploration local area endeavours to take care of specific issues, generally utilizing notable ideas and examination results from other examination fields , . The most noticeable examination project, the WHIPS project at the University of Stanford, explores a wide range of information warehousing issues dependent on procedures of appeared sees. In Switzerland, the \"Kompetenzzentrum Data Warehousing Strategies\" DWS) at the University of St. Gallen centres, along with various organizations, at the advancement of an interaction model for the fruitful presentation of information warehousing in enormous organizations. Our work with regards to the SIRIUS project centres around the examination of methods for the steady invigorates. In the SMART task, we explore the plan and execution of a metadata the board framework for an information stockroom climate. Fostering an information stockroom framework is a really difficult and expensive movement, with the regular distribution centre costing in overabundance of USD 1 million. In any case, information warehousing has turned into a well-known movement in data frameworks improvement and the board. As per the statistical surveying firm Meta 109 CU IDOL SELF LEARNING MATERIAL (SLM)
Group, the extent of organizations carrying out information distribution centres detonated from 10% in 1993 to 90% in 1994, and the information warehousing business sector will grow from USD 2 billion out of 1995 to USD 8 billion out of 1998. Further developing admittance to data and conveying better and more exact data, is for an ever increasing number of organizations and inspiration for utilizing information stockroom innovation. An information distribution centre is a complicated framework that stores chronicled and combined information utilized for estimating, detailing, and information investigation. It includes gathering, purging, and changing information from various information streams and stacking it into reality/dimensional tables. An information stockroom addresses a subject-arranged, incorporated, time-variation, and non-unstable construction of information. Zeroing in regarding the matter instead of on activities, the DWH incorporates information from numerous sources giving the client a solitary wellspring of data in a predictable arrangement. Since it is non-unstable, it records all information changes as new passages without eradicating its past state. This component is firmly identified with being time- variation, as it tracks authentic information, permitting you to look at changes after some time. These properties assist organizations with making logical reports expected to consider changes and patterns. 6.2 ARCHITECTURE FOR A DATA WAREHOUSE Figure 6.1: Architecture of Data Warehouse 110 CU IDOL SELF LEARNING MATERIAL (SLM)
An information distribution centre is a structural build of a data framework that furnishes clients with current and chronicled choice help data that is difficult to access or present in customary functional frameworks. It is likewise an incorporated arrangement of items that empower the extraction and change of functional information to be stacked into a data set for end-client investigation and detailing. It as a rule contains chronicled information got from exchange information, yet it incorporates information from different sources. It isolates investigation responsibility from exchange responsibility and empowers an association to unite information from a few sources. This paper presents idea of information warehousing, engineering of information distribution centre and methods of information examination in information warehousing. Question and revealing, multidimensional, examination, and information mining run the range of being expert headed to investigator helped to information driven. As a result of this range, every one of the information examination techniques influences information demonstrating. An information distribution centre is a social data set that is intended for inquiry and examination instead of for exchange preparing. It generally contains recorded information got from exchange information, yet it can incorporate information from different sources. Notwithstanding a social data set, an information stockroom climate incorporates an extraction, transportation, change, and stacking arrangement, an online insightful preparing motor, customer investigation devices, and different applications that deal with the most common way of get-together information and conveying it to business clients. An information stockroom goes about as a unified store of an association's information. An information stockroom supplements a current functional framework and is in this manner planned and subsequently utilized in an unexpected way. An information stockroom gives the base to the amazing information examination procedures that are accessible today like information mining and multidimensional investigation, just as the more customary question and detailing. Utilizing these strategies alongside information warehousing can bring about simpler admittance to the data you need for more educated dynamic. Information warehousing gives an amazing way to deal with changing the huge measures of information that exist in these associations into valuable and solid data for finding solutions to their inquiries and to help the dynamic cycle. It is internationally acknowledged that data is an extremely amazing resource that can give critical advantages to any association and an upper hand in the business world. Associations have huge measures of information yet have thought that it is progressively hard to get to it and utilize it. This is on the grounds that it is in a wide range of organizations, exists on various stages, and lives in a wide range of document and data set designs created by various sellers. In this manner associations have needed to compose and keep up with maybe many projects that are utilized to remove, plan, and combine information for use by various applications for examination and detailing. This would normally require adjustment of the concentrate projects or advancement of new ones. This cycle is exorbitant, wasteful, and very tedious. Information warehousing offers a superior methodology 111 CU IDOL SELF LEARNING MATERIAL (SLM)
Information distribution centre Architecture is a plan that embodies every one of the features of information warehousing for an undertaking climate. Information warehousing is the production of a focal area to store complicated, decentralized endeavour information in a coherent unit that empowers information mining, business insight, and generally speaking admittance to all significant information inside an association. Information stockroom engineering is comprehensive of all announcing necessities, information the board, security prerequisites, band width prerequisites, and capacity necessities. We might need to alter your distribution centre’s engineering for various gatherings inside your association. You can do this by adding information shops, which are intended for a specific line of business. A model is the place where buying, deals, and inventories are isolated. In this model, a monetary examiner bay to break down verifiable information for buys and deals. Information shop is a sensible subset of an undertaking wide information distribution centre. For instance, an information distribution centre for a corporate store is developed gradually from individual, adjusted information shops managing separate branches of knowledge like item deals. Dimensional Data shops are coordinated by branch of knowledge like deals, money and advertising and facilitated information classification like client, item and area. These adaptable data stores permits information designs to react to business changes-product offering augmentations, new staff, obligations, consolidations, combinations, and acquisitions. An information distribution centre is worked to give a simple to get to wellspring of excellent information. It is a necessary evil, not simply the end. That end is commonly the need to perform investigation and dynamic using that wellspring of information. There are a few strategies for information investigation that are in like manner use today. They are question and announcing, multidimensional examination, and information mining. They are utilized to define and show question results, to break down information content by survey it according to alternate points of view, and to find examples and grouping credits in the information that will give further knowledge into the information content. The procedures of information examination can affect the sort of information model chose and its substance. Example: Company ABC is a body care retailer that’s struggling to gain repeat customers. They purchase data warehousing software and incorporate customer information from its point-of-sale systems (i.e. cash registers), website analytics, email lists, and feedback surveys. By placing all of this information in one place (and considering all points of data), their team is better able to analyse its customer journey in a more holistic way. Company ABC discovers that its products tend to open while being shipped, affecting reorders. By implementing necessary changes with their packaging team – and notifying 112 CU IDOL SELF LEARNING MATERIAL (SLM)
previous customers about these changes – Company ABC ensures better customer satisfaction. 6.3 FACT AND DIMENSION TABLES Star schema, which keeps one-to-numerous connections among measurements and a reality table, is generally acknowledged as the most practical information portrayal for dimensional examination. Real world DW composition, in any case, often incorporates many-to-numerous connections between a measurement and a reality table. Having those connections in a dimensional model causes a few troublesome issues, for example, losing the effortlessness of the star pattern structure, expanding intricacy in framing inquiries, and corrupting inquiry execution by adding more joins. In this way, it is alluring to address the many-to-numerous associations with right semantics while as yet keeping the design of the star outline. In this paper, we investigate many-to-numerous connections between a measurement table and a reality table in dimensional displaying. We represent six distinct methodologies and show the benefits and weaknesses of each. We propose two impromptu strategies that keep a star construction structure by renormalizing the measurements to stay away from many-to many connections. This strategy permits speedy question handling by utilizing a linked property with insignificant overhead. Different issues tended to are information excess, weighting factors, stockpiling necessities, and execution concerns The information stockroom is a coordinated store of information, created and utilized by a whole association. The information stockroom utilizes a set-up of devices that changes crude information into significant business data. This data portrays a perspective on a particular business interaction to recognize patterns and examples and fills in as an establishment for dynamic. The dimensional model is a sensible portrayal of a business interaction whose critical elements are client understandability, question execution, and versatility to change. Dimensional demonstrating is generally acknowledged as the suitable procedure for conveying information to end clients in an information distribution centre. The principle parts of a dimensional model are truth tables and measurement tables. A reality table contains estimations of the business or records occasions. A measurement table contains credits used to compel, gathering, or peruse the reality information. There are two essential benefits of utilizing a dimensional model in information stockroom conditions. Initial, a dimensional model gives a multidimensional examination space in social data set conditions; we are investigating real information utilizing measurements. Second, a common denormalize dimensional model has a straightforward outline structure, which rearranges end-user inquiry handling and further develops execution. The measurement tables contain countless properties, mirroring the subtleties of the business measures. Perusing is a client movement that investigates the connections between credits in a measurement table. The ascribes will fill in as line headers and limitations for these perspectives. It isn't unexpected to have more than 100 credits in a genuine application. Measurement tables are thought about wide thus. 113 CU IDOL SELF LEARNING MATERIAL (SLM)
Denormalization of measurement tables is an OK practice in information warehousing. A dimensional model with profoundly standardized measurement structure is known as a snowflake pattern. Any endeavours to standardize a measurement table into a progression of tables could decrease the perusing capacities of the client, bringing about more intricate inquiries and expanded recovery time. Our encounters with certifiable information stockroom advancement shows that perusing and gathering by questions are the two notable issues that drive the plan of information distribution centres. The reality table is the place where the mathematical estimations of the business measures are put away. These estimations or occasions are identified with each measurement table by unfamiliar keys. The reality table contains thousands, or even large number of lines of records. A normal inquiry will pack or concentrate an enormous number of records into a small bunch of columns utilizing conglomeration. Hence, the most helpful realities are numeric, ceaselessly esteemed, and added substance; Kimball considers this reason the sacred goal of dimensional information base plan. The grain of the reality table is a vital trademark. The grain is the degree of detail at which estimations or occasions are put away. It decides the dimensionality of the information stockroom and significantly impacts the size and on the other hand the exhibition. The objective in planning the information distribution centre model is to keep it easy to comprehend, easy to stack with functional information, and as quick as conceivable to inquiry. We might want to have amateur and experienced business investigators making reports, so the intelligent model should be not difficult to fathom. Most business examiners much of the time struggle discovering information in both exceptionally standardized plans and dynamic article plans. The compliment the dimensional model, the better for end-clients. The more perplexing the model, the more complicated will be the concentrate/change/load schedules to make and run. At long last, questions against the data set will run quicker if a negligible number of one-to-numerous connections and joins are available. To give clients the perspectives they need for investigation, the one-to-numerous connections among realities and measurements ought to be levelled into a progression of perspectives or determined tables. For example, the analyst might need to make a relapse model against determined to have the grain of the investigation being a solitary visit to the clinic. Thusly, each line should totally characterize an encounter with sections for explicit findings or segments that address gatherings of determinations. To meet the essential objective of engaging end clients to play out their own inquiries and examinations, the plan should adjust style in theoretical plan with understandability, convenience, and execution. Plan standards direct that one ought to recognize any dimensional property that has a solitary incentive for a singular reality table record. The creator can assemble outward from the grain of the reality table and relate however many measurements as the business interaction requests. Accordingly, measurement tables are commonly joined to the reality table with a one-to-numerous relationship. At the point when every one of the measurements are connected by one-to-numerous associations with the reality table, the diagram is known as a star composition. Be that as it may, true DW blueprint regularly incorporates many-to-numerous connections between a measurement and 114 CU IDOL SELF LEARNING MATERIAL (SLM)
a reality table. Having those connections in a dimensional model causes a few troublesome issues, for example, losing the star outline structure, expanding intricacy in shaping inquiries, and corrupting question execution by adding more joins. Along these lines, it is positive that we handle the many-to-numerous connections while as yet keeping the construction of the star outline. In this paper, we dissect many-to-numerous connections between a measurement table and a reality table in dimensional displaying. Despite the fact that there are some past investigations on the best way to address an information stockroom reasonable blueprint or how to infer/plan an information distribution centre mapping , the particular technique for dealing with many-to many connections is infrequently tended to. Two sources we found are books by Kimball et al. AndGiovinazzo. Not being fulfilled by those methodologies for our certifiable undertaking, we have played out an exhaustive report on the best way to deal with many-to-numerous connections. In this paper, we outline six unique methodologies and show the benefits and weaknesses of each. We propose two specially appointed strategies that keep a star pattern structure by renormalizing the measurement to stay away from many-to- numerous connections. These strategies permit us to rapidly deal with inquiries. Different issues that will be tended to incorporate information excess, weighting factors, stockpiling prerequisites, and execution concerns. The rest of this paper is coordinated as follows: Section 2 presents an inspiration model. Area 3 presents six methodologies and examines the benefits and impediments. Areas 4 presents a rundown table and Section 5 finishes up our paper. In the medical care charging measure, there are generally various findings for every understanding visit. A plan issue emerges in displaying a determination measurement that has a many to-numerous relationship with a reality table as displayed in Figure 1. We will investigate explicit information warehousing designs to examine this issue. We will use, as an outlined model, the patient-charging circumstance all through this paper to investigate the various arrangements. In Figure 1, the connection between the conclusion measurement and the billable patient experience truth table is delineated as a many-to-many. This considers the circumstance where a patient has more than one determination for each billable experience. Example: a Login fact with Customer, Website, and Date dimensions can be queried for “number of male’s age 19-25 who logged in to funsportsite.com more than once during the last week of September 2010, grouped by day.” Or a Date dimension could contain a hierarchy of year > quarter > month > week > date. A report displaying the number of website logins for 2009 by month could drill up to display logins by year, or drill down to display logins by day. 6.4 DATA WAREHOUSE SCHEMAS Two information demonstrating procedures that are pertinent in an information warehousing climate are ER displaying and Multidimensional demonstrating. Emergency room displaying produces an information model of the particular space of interest, utilizing two fundamental 115 CU IDOL SELF LEARNING MATERIAL (SLM)
ideas: elements and the connections between those elements. The ER model is a deliberation device since it very well may be utilized to comprehend and work on the equivocal information connections in the business world and complex frameworks conditions. An ER model is addressed by an ER outline, which utilizes three essential realistic images to conceptualize the information: element, relationship, and attribute Data Warehouse is characterized as \"a subject-arranged, coordinated, time-variation, non-unpredictable assortment of information on the side of the board's dynamic cycle\". Information warehousing is presently assuming a huge part in essential dynamic. It is acquiring significance step by step. It gives a multidimensional perspective on enormous measures of authentic information from functional sources, in this way providing valuable data for chiefs to further develop their business insight which has turned into a necessary piece of dynamic technique. It is an assortment of coordinated, subject oriented data sets intended to help the DSS work, where every unit of information is non-unstable and pertinent to some second on schedule. There are two structures for information the executives for example functional information bases and information stockroom. The functional information bases are the place where the information is placed in. Clients of this kind nearly manage each record in turn and they typically play out similar undertakings. The information stockroom is the place where we get the information out. Clients of this sort nearly manage set of column at a time and their inquiries necessitate that huge number of lines be brought into an answer set. The information put away in the stockroom is transferred from the functional frameworks like showcasing, deals, and so forth the information might go through a functional information store for extra activities before it is utilized in the DW for revealing. Dimensional demonstrating is the plan idea utilized by numerous information distribution centre fashioners to construct their information stockroom. Dimensional model is the fundamental information model utilized by numerous individuals of the business OLAP items accessible today on the lookout. Dimensional displaying names a bunch of strategies and ideas utilized in information distribution centre plan. It is viewed as not quite the same as substance relationship displaying. It is less difficult, more expressive and clearer than ER displaying. It is a strategy for conceptualizing and picturing information models as a bunch of measures that are depicted by normal parts of the business. It is particularly helpful for summing up and revising the information and introducing perspectives on the information to help information investigation. Dimensional demonstrating centres around numeric information like qualities, checks, loads, equilibriums, and occurrences. It doesn't really include a social data set. A similar displaying approach, at the coherent level, can be utilized for any actual structure, like multidimensional data set or even level records. Dimensional displaying consistently utilizes the ideas of realities andmeasurements. Realities are regularly numeric qualities that can be amassed and measurements are gatherings of orders and descriptors that characterize current realities. For instance, deals sum is a reality; timestamp, item, register, store, and so forth are components of measurements. Dimensional models are worked by business measure region, for example store deals, stock, claims, and so forth Since 116 CU IDOL SELF LEARNING MATERIAL (SLM)
the diverse business measure regions share some however not all measurements, proficiency in plan, activity, and consistency, is accomplished utilizing adjusted measurements, for example utilizing one duplicate of the common measurement across branches of knowledge. In this model, all information is contained in two sorts of tables called Fact Table and Dimension Table. Truth Table: In a Dimensional Model, Fact table contains the estimations or measurements or realities of business measures. In the event that your business cycle is Sales, an estimation of this business interaction, for example, \"month to month deals number\" is caught in the reality table. Notwithstanding the estimations, the solitary different things a reality table contains are unfamiliar keys for the measurement tables. The truth of the matter is a bunch of related information, contains scientific setting information and measures. It used to addresses business things or deals. A reality table is the focal table in a star pattern of an information distribution centre. A reality table stores quantitative data for investigation and is regularly denormalize. Assume an electronic shop sells its item. Hence, every deal is a reality that occurs and the reality table is utilized to record these realities. In information warehousing, a star pattern is the least complex type of dimensional model, where information is coordinated into realities and measurements. A star outline is the least complex type of a dimensional model, wherein information is coordinated into realities and measurements. A reality is an occasion that is tallied or estimated, like a deal or login. A measurement contains reference data about the reality, like date, item, or client. Star construction has turned into a typical term used to suggest a dimensional model. Data set creators have since quite a while ago utilized the term star outline to depict dimensional models on the grounds that the subsequent construction resembles a star. A star diagram is described by at least one exceptionally enormous truth tables that contain the essential data in the information stockroom, and various a lot more modest measurement tables, every one of which contains data about the passages for a specific characteristic in the reality table. The principle component of a star diagram is a reality table at the middle encompassed by dimensional tables; every one contains data about the sections for a specific property in the reality table. The snowflake pattern is an expansion of the star outline, where each mark of the star detonates into more focuses. In a star pattern, each measurement is addressed by a solitary dimensional table, though in a snowflake outline, that dimensional table is standardized into numerous query tables, each addressing a level in the dimensional progression. The snowflake outline design is a more intricate on the grounds that the dimensional tables are standardized. It is an upgrade of star pattern. It standardizes measurements to dispense with repetition. The disintegrated snowflake structure envisions the progressive design of measurements quite well. The snowflake model is simple for information modelers to comprehend and for data set fashioners to use for the investigation of measurements. The fundamental benefit of the snowflake pattern is the improvement in question execution because of limited plate stockpiling necessities and joining more modest query tables. The fundamental disservice of the snowflake diagram is the extra support endeavours required because of the expansion number of query tables. 117 CU IDOL SELF LEARNING MATERIAL (SLM)
6.5 SUMMARY At toward the end in this paper examine information stockroom mappings and various kinds of multidimensional blueprints, for example, star diagram, snowflake pattern and truth heavenly body. The upside of utilizing these constructions is that they are more straightforward and open, simple to peruse then E-R models. It is valuable for pithy and adjusting the information and introducing perspectives on the information to help information investigation. Information distribution centres separate investigation responsibility from exchange responsibility and empower an association to merge information from a few sources. Dimensional demonstrating is a coherent plan strategy for organizing information so that it's instinctive to business clients and conveys quick question execution. Information introduced to the business knowledge instruments should be grounded in effortlessness to have any possibility of accomplishment. Straightforwardness is a central necessity since it guarantees that clients can undoubtedly get data sets, just as permits programming to effectively explore data sets. The weighting factors produce a right added up to report. During the summation, the weighting factor for every finding key will be identified with each bill through the unfamiliar key found in the billable patient experience table. The weighting factor is fundamental when utilizing an extension execution to deliver right reports. Be that as it may, it isn't generally conceivable to support the weighting factors for every finding. In that case, it is feasible to tally the absolute analyses and produce a normal expense through extra plan measures. One strategy is add an extra property to the extension, call it numberofdiagnosis; along these lines, you could isolate your effect complete by this worth to create a normal expense for each conclusion. This savage power strategy detracts from the value of your choice help based reports. Consequently, it is prescribed to utilize this strategy just when the right estimation of the weighting factors isn't required. A significant advantage of this plan is there is no proper maximum cut-off, other than absolute potential findings. Although in this examination, we have drawn an upper line of twenty analyses, to meet the client necessities. The scaffold strategy, as you can notice, carries out a compound essential key for the extension table included finding bunch key and analysis key. It is feasible to discover a gathering of related conclusions on the grounds that the analysis bunch esteem is rehashed for each part line in a bunch of determinations. There might be other such many-to-many measurements identified with a similar reality table, and the heap times and question times can be anticipated to be extensive. 118 CU IDOL SELF LEARNING MATERIAL (SLM)
For example, there are numerous system codes and Diagnosis Related Group codes relegated to a solitary visit or patient bill. A DRG is a grouping of an emergency clinic stay as far as what wasn't right with and how was helped a patient. There are around 500 DRG codes, which are controlled by a program dependent on analyses and systems coded in a standard International Classification of Disease design and on tolerant traits like age, sex, and span of treatment. The DRG every now and again decides the measure of repayments, paying little heed to the really costs brought about. An emergency clinic visit is regularly coded by numerous frameworks, like Systematized Nomenclature of Medicine, Current Procedural Terminology, and others, all of what share a many-to-numerous relationship with the billable patient experience reality table. Considering the intricacy of the medical care charging framework, the plan and execution utilizing span tables will get very mind boggling However, we note that most business data set frameworks don't utilize B-tree type file for looking through when LIKE statement starts with a wild person. Subsequently, a productive string ordering or string search system will improve the question execution. To determine the issue of LIKE proviso, we can upgrade the non-positional model by joining the advantages of positional banner credits. Additional Boolean credits can be made for normal or continuous findings. See Table 6 for a model. Bitmap lists can be made for these Boolean ascribes to work with looking through dependent on these normal judgments. Uncommon or captivating findings could likewise be incorporated for explicit business knowledge purposes. The mixture strategy permits both example coordinating with the LIKE order and a list search through a predetermined number of Boolean fields. The fundamental benefit here is oblige the size of the measurement while permitting quick and productive questions by keeping up with the star mapping. Consider Table 6 to notice the value of this methodology. Most clients are keen on a sickness class or blend of classifications, not a solitary infection charging code. Numerous codes can be allotted that all show the presence of an infection. There might be upwards of 20 codes that all demonstrate the patient has some type of diabetes. The examiner, for detailing or relapse purposes, just necessities a field for diabetes that contains \"Valid\" or \"Bogus\". In On-line Analytical Processing plans clients can join sicknesses by basically choosing \"Yes\" across a progression of OLAP classifications. Pre-working out and putting away these bunches simplifies it for clients to inquiry the information base and for designers to make OLAP blocks. When each record in the conclusion measurement can be identified with one truth record, there exists a balanced connection between the tables. That is, we are making one measurement record for each new charging experience. The disadvantages in this 119 CU IDOL SELF LEARNING MATERIAL (SLM)
plan are three. To start with, most bills have less than 5 auxiliary findings, so there will be numerous invalid qualities. Second, inquiries across auxiliary determination fields will require different OR provisos, which are intricate to compose and ease back to run. In any case, this weakness can be settled utilizing the linked quality and LIKE proviso as we clarified in the past area. Third, it will take more capacity. In any case, the main benefit of this methodology is to keep up with the basic star mapping structure. Here, plan is more straightforward for the most part and simpler for experts not prepared in information displaying to comprehend to the detriment of huge stockpiling. In our undertaking, we embraced this C-2 strategy. Numerous clinical focuses will buy or download all fundamental conclusion codes and portrayals as level documents, then, at that point load this information into a data set table. We had the option to make the underlying finding measurement utilizing memorable heritage information. For each billable experience, a query is performed for the conclusion portrayal in a query table, the outcomes are arranged, and another record is embedded. For future cases records, a support capacity will question the analysis measurement to check whether the example as of now exists. On the off chance that the example doesn't exist, the query table is gotten to for a depiction and will refresh the measurement likewise. 6.6 KEYWORDS Composite provenance - The utilization of a blend of essentially neighbourhood provenance material with a modest quantity from far off however Eco geographically coordinated with provenances. Forest scene reclamation - Ongoing course of recapturing environmental usefulness and upgrading human prosperity across deforested or debased woods scenes. Framework species approach-Planting a blend of tree animal types, regular of the objective backwoods biological system, that catalyse woods recovery by concealing out herbaceous weeds and drawing in seed-scattering creatures Natural recovery - The course of regular backwoods regrowth, which can happen immediately following area deserting or be helped by human mediations. Nature-based solutions - Actions that include 'working with and improving nature to assist with tending to cultural objectives’. 6.7 LEARNING ACTIVITY 1. Create a session on Fact and Dimension Tables. 120 CU IDOL SELF LEARNING MATERIAL (SLM)
___________________________________________________________________________ ___________________________________________________________________________ 2. Create a survey on Architecture for a Data Warehouse. ___________________________________________________________________________ ___________________________________________________________________________ 6.8UNIT END QUESTIONS A. Descriptive Questions Short Questions 1. What is Star Schema? 2. What is Snowflake Schema? 3. Define Fact Constellation Schema? 4. Define Relationship model? 5. Write the meaning of Multidimensional model? Long Questions 1. Explain the Architecture for a Data Warehouse. 2. Elaborate the scope of Architecture for a Data Warehouse. 3. Illustrate the Dimension Tables. 4. Examine the Data Warehouse Schemas. 5. Discuss on the criticism of Data Warehouse Schemas. B. Multiple Choice Questions 1. What does business Intelligence and data warehousing is used for? a. Forecasting b. Data mining c. Analysis of large volumes of product sales data d. All of these 2. What does data warehouse contains that is never found in the operational environment? a. Normalized b. Informational c. Summary 121 CU IDOL SELF LEARNING MATERIAL (SLM)
d. Denormalized 3. Which are responsible for running queries and reports against data warehouse tables. a. Hardware b. Software c. End users d. Middle ware 4. What is the biggest drawback of the level indicator in the classic star schema is that is limits a. Flexibility b. Quantify c. Qualify d. Ability 5. What are designed to overcome any limitations placed on the warehouse by the nature of the relational data model. a. Operational database b. Relational database c. Multidimensional database d. Data repository Answers 1-b, 2-a, 3-d, 4-b, 5-a 6.9 REFERENCES References book Vercellis, C. (2013). Business Intelligence: Data mining and optimization for Decision Making (2nd ed.). Amirkabir University Press. Watson, H. J., & Wixom, H. (2007). Enterprise agility and mature BI capabilities. Business Intelligence Journal. White, C. (2005). The next generation of Business Intelligence: Operational BI. Information Management Magazine Textbook references 122 CU IDOL SELF LEARNING MATERIAL (SLM)
Wixom, B. & Watson, H. (2010). The BI-Based Organization. International Journal of Business Intelligence Research. Morse, Stephen, &David Isaac.(1998). Parallel Systems in the Data Warehouse: Upper Saddle River. NJ: Prentice-Hall PTR. Mattison, Rob. (1996) Data Warehousing Strategies, Technologies, and Techniques. New York: McGraw-Hill. Website https://www.researchgate.net/publication/220841965_An_Analysis_of_Many-to- Many_Relationships_Between_Fact_and_Dimension_Tables_in_Dimensional_Model ing/link/02e7e52bdb0e76ba25000000/download http://dspace.vpmthane.org:8080/jspui/bitstream/123456789/3171/1/Data%20Wareho use%20Architecture.pdf https://www.ijirae.com/volumes/Vol2/iss4/08.APAE10098.pdf 123 CU IDOL SELF LEARNING MATERIAL (SLM)
UNIT - 7 DATA CUBE STRUCTURE 7.0 Learning Objectives 7.1 Introduction 7.2 A Multidimensional Data Model 7.3 Data Cube Computation Methods 7.3.1 Multiway Array Aggregation for Full Cube Computation 7.3.2 BUC: Computing Iceberg Cubes from the Apex Cuboid Downward 7.3.3 Star-Cubing: Computing Iceberg Cubes Using a Dynamic Star-Tree Structure 7.3.4 Precomputing Shell Fragments for Fast High-Dimensional OLAP 7.4 Typical OLAP Operations 7.5 Summary 7.6 Keywords 7.7 Learning Activity 7.8 Unit End Questions 7.9 References 7.0 LEARNING OBJECTIVES After studying this unit, you will be able to: Appreciate the concept of Multidimensional Data Model. Illustrate the Data Cube Computation Methods. Explain the Precomputing Shell Fragments for Fast High-Dimensional OLAP. 7.1 INTRODUCTION In PC programming settings, an information 3D square is a multi-dimensional cluster of qualities. Regularly, the term data cube is applied in settings where these clusters are enormously bigger than the facilitating PC's fundamental memory; models incorporate multi- terabyte/petabyte information distribution centres and time series of picture information. The information 3D square is utilized to address information along some proportion of interest. For instance, in OLAP such measures could be the auxiliaries an organization has, the items the organization offers, and time; in this arrangement, a reality would be a business 124 CU IDOL SELF LEARNING MATERIAL (SLM)
occasion where a specific item has been sold in a specific auxiliary at a specific time. In satellite picture time series measures would be Latitude and Longitude arranges and time; a reality would be a pixel at a given space/time facilitate as taken by the satellite. Despite the fact that it is known as a block,information 3D square by and large is a multi-dimensional idea which can be 1-dimensional, 2-dimensional, 3-dimensional, or higher-dimensional. Regardless, every measurement addresses a different measure though the cells in the solid shape address current realities of interest. At times solid shapes hold just couple of qualities with the rest being vacant, for example unclear, some of the time most or all solid shape arranges hold a cell esteem. In the principal case such information are called meagre, in the second case they are called thick, in spite of the fact that there is no hard depiction between both. Information examination applications search for uncommon examples in information. They classify information esteems and patterns, separate measurable data, and afterward balance one classification with another. There are four stages to such information investigation: planning an inquiry that extricates important information from a huge data set, separating the totalled information from the data set into a document or table, picturing the outcomes graphically, and examining the outcomes and figuring another question. Perception apparatuses show information patterns, bunches, and contrasts. The absolute most intriguing work in representation centres around introducing new graphical illustrations that permit individuals to find information patterns and peculiarities. Large numbers of these perception and information investigation apparatuses address the dataset as a N-dimensional space. Perception devices render two and three-dimensional sub-sections of this space as 2D or 3D items. Shading and time add two additional measurements to the presentation giving the potential for a 5D showcase. A Spreadsheet application, for example, Excel is an illustration of an information perception/examination apparatus that is utilized generally. Information examination instruments frequently attempt to recognize a subspace of the Ndimensional space which is \"intriguing”. In this way, representation just as information investigation apparatuses do \"dimensionality decrease\" , frequently by summing up information along the measurements that are forgotten about. For instance, in attempting to dissect vehicle deals, we may zero in on the job of model, year and shade of the vehicles in deal. Subsequently, we overlook the contrasts between two deals along the elements of date of offer or vendor however examine the sums deal for vehicles by model, by year and by shading as it were. Alongside outline and dimensionality decrease, information investigation applications use develops like histogram, cross-arrangement, subtotals, roll-up and drill-down broadly. This paper analyses how a social motor can uphold proficient extraction of data from a SQL data set that coordinates with the above prerequisites of the perception and information examination. We start by talking about the important elements in Standard SQL and a portion of the merchant explicit SQL augmentations. Area 2 examines why GROUP BY neglects to enough address the 125 CU IDOL SELF LEARNING MATERIAL (SLM)
prerequisites. The Cube and the ROLLUP administrators are presented in Section 3 and we additionally examine how these administrators conquer a portion of the deficiencies of GROUP BY. Areas 4 and 5 examine how we can address and process the Cube. How do conventional social information bases fit into this multidimensional information investigation picture? How could 2D level records modelan N-dimensional issue? Moreover, how do the social frameworks support the capacity to help tasks over N-dimensional portrayal that are integral to representation and information investigation programs? We address every one of these two issues in this segment. The response to the main inquiry is that social frameworks model N-dimensional information as a connection with N-property spaces. For instance, 4-dimensional earth temperature information is ordinarily addressed by Weather. The initial four segments address the four measurements: scope, longitude, elevation, and time. Extra segments address estimations at the 4D focuses like temperature, pressing factor, dampness, and wind speed. Every individual climate estimation is recorded as another line of this table. Regularly these deliberate qualities are totals over the long run orspace. Execution of the information 3D square is a significant and logically fascinating issue with regards to On-Line Analytical Processing and has been the subject of a plenty of related distributions. Guileless execution strategies that register every hub independently and store the outcome are unfeasible, since they have outstanding reality intricacy as for the 3D shape dimensionality. To conquer this downside, a wide scope of strategies that give effective shape execution have been proposed, which utilize social, multidimensional, or diagram based information structures. Besides, there are a few different techniques that register and store inexact depictions of information solid shapes, forfeiting exactness for build-up. In this article, we centreon Relational-OLAP, following most of the endeavours up until now. We audit existing ROLAP techniques that carry out the information solid shape and distinguish six symmetrical boundaries/measurements that describe them. We place the current methods at the suitable focuses inside the issue space characterized by these boundaries and recognize a few bunches that the procedures structure with different fascinating properties. A cautious investigation of these properties prompts the ID of especially successful qualities for the space boundaries and demonstrates the potential for conceiving new calculations with better by and large execution. Execution of the information 3D square is one of the most significant, but \"costly,\" measures in On-Line Analytical Processing. It includes the calculation and capacity of the consequences of total questions gathering on all conceivable measurement property blends over a reality table in an information stockroom. Such precomputation and emergence of the 3D square is basic for working on the reaction season of OLAP questions and of administrators, for example, roll-up, drill-down, cut up, and turn, which use accumulation broadly . Appearing the whole shape is great for quick admittance to totalled information however may present impressive costs both in calculation time and away space. To adjust the 126 CU IDOL SELF LEARNING MATERIAL (SLM)
trade-off between question reaction times and 3D square asset prerequisites, a few proficient techniques have been proposed, whose review is the fundamental reason for this article. As a running model, consider a reality table R comprising of three measurements and one measure M. Figure 1b presents the relating 3D square. Each view that has a place with the information shape emerges a particular gathering by question as shown in Figure 1b. Obviously, in case D is the quantity of measurements of a reality table, the quantity of all conceivable gathering by questions is 2D, which suggests that the information shape size is dramatically bigger concerning D than the size of the first information. In run of the mill applications, this is in the request for gigabytes, so improvement of proficient information block execution calculations is amazingly basic. The information 3D square execution calculations that have been proposed in the writing can be divided into four principle classes, contingent upon the arrangement they use to process and store an information shape: Relational-OLAP techniques utilize customary appeared sees; Multidimensional-OLAP strategies utilize multidimensional clusters; Graph-Based strategies exploit particular charts that typically appear as tree-like information structures; at last, guess strategies exploit different in memory portrayals , acquired basically from insights. Our spotlight in this article is on calculations for ROLAP conditions, because of a few reasons: (a) Most existing distributions share this centre; (b) ROLAP strategies can be effectively fused into existing social workers, transforming them into incredible OLAP devices with little exertion; conversely, MOLAP and Graph-Based techniques build and store specific information structures, making them inconsistent, in any immediate sense, with traditional data set motors; (c) ROLAP techniques produce and store exact outcomes, which are a lot simpler to oversee at run time contrasted with approximations. 7.2 A MULTIDIMENSIONAL DATA MODEL A multidimensional model views data in the form of a data-cube. A data cube enables data to be modeled and viewed in multiple dimensions. It is defined by dimensions and facts. The dimensions are the perspectives or entities concerning which an organization keeps records. For example, a shop may create a sales data warehouse to keep records of the store's sales for the dimension time, item, and location. These dimensions allow the save to keep track of things, for example, monthly sales of items and the locations at which the items were sold. Each dimension has a table related to it, called a dimensional table, which describes the dimension further. For example, a dimensional table for an item may contain the attributes item name, brand, and type. A multidimensional data model is organized around a central theme, for example, sales. This theme is represented by a fact table. Facts are numerical measures. The fact table contains the names of the facts or measures of the related dimensional tables. 127 CU IDOL SELF LEARNING MATERIAL (SLM)
Table 7.1: Tabular and Dimensional Representation The use of data and correspondence advances acquired its firm spot in the regular daily existence of many organizations. Various experimental investigations record the positive effect of ICT on monetary development, efficiency, convenience and proficiency. One of key parts of the globalization is that it made complex data innovations moderate for countless organizations in the business climate. This pattern prompted an expansion sought after for specific arrangements, permitting investigation of colossal measures of information and revealing of patterns. These errands are principle motivation behind presence of a specific programming classification, usually known as Business Intelligence. The BI is anyway primarily an umbrella term for different instruments, innovations, structures, cycles, data sets and systems. These angles empower compelling administration and dynamic through top notch data and utilization of specific programming apparatuses. Following quite a while of relative lessening of the advancement in the field of BI, the worldwide financial emergency revealed new subjects of conversation among professionals and scientists. Albeit the capability of BI itself was obviously perceived, 2 primary issues emerged are as yet talked about. How might the thought behind the utilization of the BI be stretched out and how to guarantee the BI activities to climb to the next level, less expensive and at last much more reasonable for little and medium organizations? The primary issue is effectively tended to by applications from the field of Competitive Intelligence which is perceived as a replacement to the BI. These apparatuses will in general utilize new wellsprings of data to improve capability of conventional BI instruments. The subsequent issue is anyway tended to buy more fields. These fields share a centre thought – make the cycle deft and more client driven. Hence new teaches like dexterous venture the board, nimble information displaying, lithe information warehousing began to show up. The two fields develop a large part of the entire 128 CU IDOL SELF LEARNING MATERIAL (SLM)
exploration exertion that is presently identified with the BI and its application utilizing current data advances and data sources in organization's dynamic interaction. The two fields additionally share a similar work to consolidate likewise unstructured substance into the dynamic interaction to add significance with latest occasions in the general public and on the lookout. This paper centres around introducing an evaluation of a creative idea, as a piece of exploration exercises concerning the subsequent issue referenced. BI instruments are expected to supply key business clients with data that they really need. Data yield ought to be in appropriate construction and ought to be accessible on schedule – data with such boundaries is crucial to acquire significant business bits of knowledge. The most common way of building organization's BI framework should then accept steps that guarantee excellent data yields with most elevated incentive for the business client. The worldview in which the BI framework is utilized essentially on the leader level of organization's administration has changed. The new worldview includes use of BI devices even on strategic and functional degree of the board. Additionally clever techniques that emphasis on building the BI framework in more limited time, with lower costs, while tending to significant high need necessities are available in the current worldview. Today, the field of industry where the BI could be executed in is as of now not a restricting component. The flow driver of BI execution is its incentive for the business which made the BI significantly more inescapable. The new worldview likewise revealed a few holes in conventional philosophies which accounted for advancement in approaches that are now normalized in the business. Additionally, faster speed of business put more accentuation on the administration of prerequisites, since they can change in a real sense for the time being. BI task's partners ought to be educated how well are venture's prosperity measurements performing and if their own assumptions for undertaking are a positive outcome compare with the real condition of the venture. An approach should then accept techniques that cover addressing of these issues. Concerning these realities, most recent advancement in the plan and improvement of data frameworks currently affirmed advantages of preparation, creating and carrying out key pieces of data framework gradually. The \"spry development\" upholds gradual style of the plan and advancement cycle and offers a bunch of fascinating thoughts and rules that arrangement with issues of execution of time forced activities. Nonetheless, the lithe ought not to be treated as a simple equivalent word of quicker plan and improvement of the product. It ought to likewise be treated as a way of thinking of the entire course of preparation and executing activities during the time spent organization's improvement over the long run. This incorporates likewise the board and execution of changes in the organization and execution of strategic plans and functional undertakings. Their results would then be able to be reflected as changes in information models and these progressions ought to be in this manner painstakingly overseen. In this paper we manage one part of data framework's plan – the improvement of a multidimensional information model for a BI framework's information stockpiling. We attempt to introduce and survey a proposition of a creative way to deal with the plan of such information model. Our methodology ought to be material in the coordinated 129 CU IDOL SELF LEARNING MATERIAL (SLM)
situated course of the plan of BI framework's information model. Since the BI framework ought to reflect changes in business cycles and prerequisites identified with them, there are sure issues that ought to be covered at the theoretical degree of plan of the multidimensional information model. The reasonable level of the information model ought to be just about as adaptable as conceivable to permit consistent transformation to changes which happen frequently. Present status of calculated displaying is that the model is regularly made persistently and simultaneous with information stacking, getting to and other data set administration exercises. The possibility of our methodology squeezes into this assumption: it should offer versatility of the information model on one side with extraordinary and adaptable method of taking care of changes in key information esteems and on the opposite side with least explicit prerequisites in the field of information stacking. The lithe direction of the BI framework's information stockpiling configuration measure is essential to guarantee the framework to meet current necessities and presents important and noteworthy yields. This reality is likewise referenced by Tumbas and Matković who add that the coordinated direction being developed of PC frameworks additionally permits clients to change their prerequisites all the more oftentimes without genuine results. One of data framework's prosperity measurements is idealness and money of data. These viewpoints are vital since pertinence of the dynamic cycle relies for the most part upon the idealness and exactness of accessible data outputs1. The information, as a wellspring of business basic data, frequently involve history of changes in upsides of key business elements These progressions are likewise underlined as common changes in the field of information warehousing . Work with powerful method for catching these progressions and consolidate them in the decision-making system while keeping up with flexibility of the basic information model. The nature of basic information is a characteristic and vital forerunner of data quality. Additionally, an aberrant impact on framework's quality was demonstrated. These overall achievement measurements with other referenced angles total the image of requirements of generally data framework's prosperity. Our methodology remembers reasonable method for catching changes for characteristics' qualities since this is a significant stage during the time spent BI framework's information stockpiling plan. Overlooking following of changes in business measurements is referenced as a basic slip-up during the time spent plan of BI framework's information stockpiling. Likewise, a supposition on the superior of the BI framework is a significant issue that the undertaking group needs to manage prior to conveying the framework. This issue is likewise tended to in the appraisal of our proposed approach as this issue is usually referenced as one of commonplace parts of the framework quality, the two methodologies, for example the proposed one and the customary one depend on the translation of steps of the dimensional demonstrating by Ralph Kimball. This demonstrating procedure comprises of a bunch of steps that outcome into the choice of a pertinent arrangement of realities at an ideal degree of detail and scientific perspectives to permit multipurpose investigation of current realities. Scientific perspectives address substances of the truth that can be utilized for scientific purposes. Measurements with their 130 CU IDOL SELF LEARNING MATERIAL (SLM)
engaging properties andreality’s structure a multidimensional perspective on information. The multidimensional perspective on information addresses the ideal method of how the regular BI framework's client thinks while investigating execution of separate business measures. The part of time is one more significant part of the multidimensional perspective on information either for the scattering of changes in key information esteems yet in addition for the time related investigation of realities. Appropriate degree of detail of realities impacts ease of use of the information model by BI framework's clients and consequently it is one of the components that decide nature of the information model. Realities are utilized for insightful and further for arranging purposes as proportions of business measure execution. This load of parts of multidimensionality are normally applicable for our proposed approach since the way how BI framework's clients think during the examination of business measure execution doesn't change. Albeit the dimensional displaying permits choosing legitimate arrangement of measurements with additional assurance of their substance, the course of the plan of multidimensional information model can contrast altogether. The use of the dimensional displaying method generally results is the meaning of the construction and expected substance of a business cycle related multidimensional model. The multidimensional model is typically a semantic conceptual portrayal and additionally perception of the multidimensional perspective on information. Each subset of the multidimensional model is identified with explicit parts of particular business measure or sub process in which there is the longing to set up or work on present status of dynamic and execution investigation. The multidimensional model is steadily intensified with the information on recently obtained or correction of current business prerequisites which can be an uncomfortable undertaking. The multidimensional model is then gradually changed into the multidimensional information model. The multidimensional information model can take a type of a social construction or a pattern of classes and their connections. This is the consistent degree of displaying the information model of the multidimensional perspective on information. The change into the genuinely implementable structure is then a characteristic advance as far as testing and further utilization of such information model. The proposed approach upholds this load of referenced angles however it contrasts in the manner how the advancement of the data set mapping is dealt with. The fundamental distinction is standing out how the coherent level of the plan is performed. The sensible social portrayal of the multidimensional perspective on information is part based and it follows chosen standards of the anchor information displaying strategy. In this paper, we centre around a social information displaying approach, called the anchor information demonstrating. The anchor demonstrating is an information base displaying method that works with nimble improvement of a data set construction. It is previously centredon the improvement of the information model of an information stockroom as per the Inmon's methodology, regardless of whether the subsequent data set pattern isn't standardized into the third ordinary structure. Be that as it may, creators don't indicate the use of the method exclusively to assemble venture information distribution centre nor whether their 131 CU IDOL SELF LEARNING MATERIAL (SLM)
methodology is unseemly or difficult to use for the plan of the multidimensional information model. Anchor demonstrating depends on a limited arrangement of constructors and rules that are justifiable and simple to carry out in any social data set climate. The creators indicate that their methodology ought to bring a few advantages. In setting of the plan of the multidimensional information model, there is in particular the verifiable chance to foster the information model iteratively and gradually with simpler and more powerful worldly questioning, shortfall of invalid qualities, and reusability of diagram objects with related parts of capacity effectiveness. There is additionally better question execution expected which ought to be upheld by the presence of an inquiry enhancer's usefulness called the end of tables in a joins. Be that as it may, this usefulness isn't completely executed in each accessible information base administration framework as announced in. The information base mapping coming about because of the use of the anchor demonstrating strategy is an anchor pattern. The anchor mapping is an information base construction which comprises of a limited arrangement of anchors, ties, credits and in the long run hitches. Dynamic perception of these parts and their portrayal as a consistent social information model are portrayed in figure 1. The anchor pattern is a profoundly decayed data set mapping which is portrayed by undeniable degree of standardization. The anchor information base blueprint fulfils completely the fifth ordinary structure however the connection can likewise exist in the sixth typical structure which is an expansion of the fifth typical structure. The fifth typical structure is for the most part dependent on the decay of relations into additional unchangeable parts that can't be additionally deteriorated without losing any data contained in it. An Attribute or a Tie connection in the anchor diagram fulfils the suspicions of the sixth ordinary structure on the off chance that they contain extra transient legitimacy sign property. The worldly legitimacy property is anyway facultative and subsequently the anchor diagram can likewise somewhat fulfil the presumptions of the sixth ordinary structure. The time legitimacy property contains data on the time at which a particular worth of the quality began and similarly halted to be substantial with respect to the development of the whole element's state to which the trait coherently has a place. The requirement for the proof of changes is normally stressed as one of key components of an information distribution centre. Simple overwrite of the worth is anything but an ideal arrangement in the BI framework. In any case the framework would be unbendable and it would need future potential to assimilate both flat and vertical changes. 7.3 DATA CUBE COMPUTATION METHODS The proposed idea is expected to be a partner to the customary methodology which is by and large dependent on the development of a social multidimensional information model, regularly with a star or snowflake geography. The two methodologies, for example the proposed one and the customary one depends on the translation of steps of the dimensional demonstrating by Ralph Kimball. This demonstrating procedure comprises of a bunch of steps that outcome into the choice of a pertinent arrangement of realities at an ideal degree of 132 CU IDOL SELF LEARNING MATERIAL (SLM)
detail and scientific perspectives to permit multipurpose investigation of current realities. Scientific perspectives (for example measurements) address substances of the truth that can be utilized for scientific purposes. Measurements with their engaging properties (qualities) and reality’s structure a multidimensional perspective on information. The multidimensional perspective on information addresses the ideal method of how the regular BI framework's client thinks while investigating execution of separate business measures. The part of time is one more significant part of the multidimensional perspective on information for the scattering of changes in key information esteems yet in addition for the time related investigation of realities. Appropriate degree of detail of realities (the granularity or grain) impacts ease of use of the information model by BI framework's clients and consequently it is one of the components that decide nature of the information model. Realities are utilized for insightful and further for arranging purposes as proportions of business measure execution. This load of parts of multidimensionality are normally applicable for our proposed approach since the way how BI framework's clients think during the examination of business measure execution doesn't change. Albeit the dimensional displaying permits choosing legitimate arrangement of measurements with additional assurance of their substance (credits that provide spellbinding setting to realities with certain chain of importance), the course of the plan of multidimensional information model can contrast altogether. The use of the dimensional displaying method generally results is the meaning of the construction and expected substance of a business cycle related multidimensional model. The multidimensional model is typically a semantic conceptual portrayal and additionally perception of the multidimensional perspective on information. Each subset of the multidimensional model is identified with explicit parts of particular business measure or sub process in which there is the longing to set up or work on present status of dynamic and execution investigation. The multidimensional model is steadily intensified with the information on recently obtained or correction of current business prerequisites which can be an uncomfortable undertaking. The multidimensional model is then gradually changed into the multidimensional information model. The multidimensional information model can take a type of a social construction (with star or conceivably a snowflake geography) or a pattern of classes and their connections (the item situated way to deal with demonstrating the multidimensional perspective on information). This is the consistent degree of displaying the information model of the multidimensional perspective on information. The change into the genuinely implementable structure is then a characteristic advance as far as testing and further utilization of such information model. The proposed approach upholds this load of referenced angles however it contrasts in the manner how the advancement of the data set mapping is dealt with. The fundamental distinction is standing out how the coherent level of the plan is performed. The sensible social portrayal of the multidimensional perspective on information (for example social multidimensional information model) is part based and it follows chosen standards of the anchor information displaying strategy. 133 CU IDOL SELF LEARNING MATERIAL (SLM)
In this paper, we center on a social information displaying approach, called the anchor information demonstrating. The anchor demonstrating is an information base displaying method that works with nimble improvement of a data set construction. It is previously center around the improvement of the information model of an information stockroom as per the Inmon's methodology, regardless of whether the subsequent data set pattern isn't standardized into the third ordinary structure. Be that as it may, creators don't indicate the use of the method exclusively to assemble venture information distribution center nor whether their methodology is unseemly or difficult to use for the plan of the multidimensional information model. Anchor demonstrating depends on a limited arrangement of constructors and rules that are justifiable and simple to carry out in any social data set climate. The creators indicate that their methodology ought to bring a few advantages. In setting of the plan of the multidimensional information model, there is in particular the verifiable chance to foster the information model iteratively and gradually with simpler and more powerful worldly questioning, shortfall of invalid qualities, and reusability of diagram objects with related parts of capacity effectiveness. There is additionally better question execution expected which ought to be upheld by the presence of an inquiry enhancer's usefulness called the end of tables in a joins. Be that as it may, this usefulness isn't completely executed in each accessible information base administration framework as announced in. The information base mapping coming about because of the use of the anchor demonstrating strategy is an anchor pattern. The anchor mapping is an information base construction which comprises of a limited arrangement of anchors, ties, credits and in the long run hitches. Dynamic perception of these parts and their portrayal as a consistent social information model are portrayed in figure 1. The anchor pattern is a profoundly decayed data set mapping which is portrayed by undeniable degree of standardization. The anchor information base blueprint fulfils completely the fifth ordinary structure however the connection can likewise exist in the sixth typical structure which is an expansion of the fifth typical structure. The fifth typical structure is for the most part dependent on the decay of relations into additional unchangeable parts (mini relations) that can't be additionally deteriorated without losing any data contained in it. An Attribute or a Tie connection in the anchor diagram fulfils the suspicions of the sixth ordinary structure on the off chance that they contain extra transient legitimacy sign property. The worldly legitimacy property is anyway facultative and subsequently the anchor diagram can likewise somewhat fulfill the presumptions of the sixth ordinary structure. The time legitimacy property contains data on the time at which a particular worth of the quality began and similarly halted to be substantial with respect to the development of the whole element's state to which the trait coherently has a place. The requirement for the proof of changes is normally stressed as one of key components of an information distribution center (or by and large the information stockpiling of the BI framework). Simple overwrite of the worth is anything but an ideal arrangement in the BI framework. In any case the framework would be unbendable, and it would need future potential to assimilate both flat (information esteems) and vertical changes (structure). 134 CU IDOL SELF LEARNING MATERIAL (SLM)
7.3.1 Multiway Array Aggregation for Full Cube Computation The Multiway. exhibit conglomeration or basically Multiway strategy figures a full information solid shape by utilizing a multidimensional cluster as its essential information structure. It is a regular MOLAP approach that utilizations direct cluster tending to, where distension. values are gotten to by means of the position or list of their comparing cluster areas. Henceforth, Multiway can't play out any worth based reordering. an enhancement method. An alternate methodology is produced for the cluster based shape development, as follows— Partition the cluster into pieces. A piece is a sub cube that is sufficiently little to squeeze into the memory accessible for 3D square calculation. Piecing is a technique for partitioning A-measurement exhibit into little n-dimensional lumps, where each piece is put away as an item on a circle. The pieces are compacted to eliminate squandered space coming about because of void cluster cells. For example, \"piece ID + offset\" can be utilized as a cell addressing component to pack a scanty cluster structure and while looking for cells inside a lump. Such a pressure strategy is sufficiently incredible to deal with meagre 3D squares, both on plate and in .memory. Compute totals by visiting 3D shape cells. The request in which cells are visited can be advanced to limit the occasions that every cell should be returned to, in this way diminishing memory access and capacity costs. Try to take advantage of this requesting with the goal that halfway totals can be processed at the same time, and any superfluous returning to of cells is stayed away from. Since this piecing strategy includes \"covering\" a portion of the conglomeration calculations, it is alluded to as Multiway exhibit accumulation. It performs concurrent accumulation, that is, it registers totals all the while on various measurements. Example: “chunk ID + offset” can be used as a cell addressing mechanism to compress a sparse array structure and when searching for cells within a chunk. Such a compression technique is powerful enough to handle sparse cubes, both on disk and in .memory. 7.3.2 BUC: Computing Iceberg Cubes From the Apex Cuboid Downward The sixth typical structure then, at that point permits recognizing changes in property's estimations after some time on the worth degree of goal. This could be valuable in contrast with customary methodologies in which at times entire n-tuple should be rehashed or an exceptional history-following connection ought to be utilized to store changes in a particular property or an entire arrangement of traits. These methodologies are normally known as Slowly Changing Dimension and Rapidly Changing Dimensions calculations. The anchor demonstrating ought to be particularly helpful if there should arise an occurrence of fleeting questioning which is firmly identified with the advancement of information esteems in time. Anyway the fundamental advantages are normal in the field of dealing with RCDs for such there are normalized procedures including for example parting the measurement into 2 135 CU IDOL SELF LEARNING MATERIAL (SLM)
sections – one section changes some of the time and the other one changeregularly. The Anchor addresses normal substance legitimate social portrayal: a social table A (K#), with 1 section K where K is an essential key of A. The Attribute addresses a property of an anchor. Legitimate social portrayal: a social table Attr (K*, P), normally with 2 sections where K* is an essential key of Attr and a non-invalid unfamiliar key to separate anchor A (K#) on the double. The area of P is any non-invalid information type. Property can be historized, static, hitched static or tied historized, as per the particular mix of different ideas of pattern enhancement. As for the plan of the multidimensional information model, the historization is particularly fascinating as it by and large means expansion of a section which holds the data on worldly legitimacy of qualities. The connection Attr will then, at that point be reached out to Attr (K*, P, T) where the space of T is a non-invalid time information type and essential key of Attr is then a blend (K*, T). The Tie addresses relationship among two and more substances and it is an understood many-to many relationship constructor. Legitimate social portrayal: social table Tie (K*1,… , K*n), where n implies aggregate sum of related Anchors, and every Ki for I = {1,… , n} is an unfamiliar key to separate I-ith Anchor. Essential key of the Tie is a subset of Ki for I = {1, m} where m means aggregate sum of Anchors that are required to be a piece of the essential key of the Tie. As to the plan of the multidimensional information model there is a verifiable supposition that all connected measurements' essential keys ought to be utilized to particularly recognize every reality. We thusly expect that n=m and m will be equivalent to the aggregate sum of measurements in the dimensional model. Bunch parts and tied Attributes and Ties were not utilized in our example models since we at first needed to keep up with specific level of straightforwardness of the subsequent multidimensional information model. Accordingly this constructor won't be clarified, yet particular definite data on the utilization of the Knot is contained in. 7.3.3 STAR-CUBING: Computing Iceberg Cubes Using A Dynamic Star-Tree Structure Information 3D square calculation is perhaps the most fundamental however costly activities in datum warehousing. Past investigations have created two significant methodologies, hierarchical versus bottom up. The previous, addressed by the Multiway Array Cube calculation , totals at the same time on numerous measurements; in any case, it can't exploit Apriori pruning when registering ice sheet shapes . The last mentioned, addressed by two calculations: BUC and H-Cubing, registers the ice shelf 3D square base up and works with Apriori pruning. BUC investigates quick arranging and dividing procedures; though H- Cubing investigates an information structure, H-Tree, for shared calculation. In any case, none of them completely investigates multi-dimensional synchronous conglomeration. In this paper, we present another strategy, Star Cubing that coordinates the qualities of the past three calculations and performs conglomerations on numerous measurements all the while. It uses a star-tree structure, expands the concurrent accumulation techniques, and empowers the pruning of the gathering by's that don't fulfil the ice sheet condition. Our exhibition study 136 CU IDOL SELF LEARNING MATERIAL (SLM)
shows that Star-Cubing is exceptionally productive and beats every one of the past strategies in practically a wide range of information appropriations. Since the presentation of information warehousing, information 3D square, and OLAP, effective calculation of information blocks has been one of the centring focuses in research with various investigations detailed. The past investigations can be ordered into the accompanying classifications: (1) effective calculation of full or chunk of ice 3D squares with basic or complex measures, (2) particular emergence of perspectives, (3) calculation of compacted information blocks by estimation, like semi 3D shapes, wavelet solid shapes, and so on, (4) calculation of dense, diminutive person, or remainder 3D shapes, and (5) calculation of stream \"3D squares\" for multi-dimensional relapse examination. Among these classifications, we accept that the first, productive calculation of full or chunk of ice blocks, assumes a key part since it is a central issue, and any new strategy created here may unequivocally impact new advancements in different classes. The issue of 3D square calculation can be characterized as follows. In an n-measurement information 3D square, a cell a = (a1, a2, an, c) (where c is an action) is called an m-dimensional cell, if and just in case there are actually (m ≤ n) values among {a1, a2, an} which are not ∗. It is known as a base cell if m = n; else, it is a total cell. Given a base Cuboid, our errand is to figure an icy mass block, i.e., the arrangement of cells which fulfils an ice shelf condition or the full 3D shape in case there is no such condition. We first investigation the case that the action c is the tally of base cells, and min sup is the icy mass condition. Then, at that point we extend it to complex measures in Section 5. Past investigations have created two significant methodologies, hierarchical versus base up, for effective block calculation. The previous, addressed by the Multiway Array Cube calculation , totals at the same time on different measurements; in any case, it can't exploit Apriori pruning when figuring chunk of ice shapes. The last mentioned, addressed by two calculations: BUC and H-Cubing, processes the ice shelf 3D square base up and works with Apriori pruning. BUC investigates quick arranging and parcelling procedures; though H-Cubing investigates an information structure, H-Tree, for shared calculation. Nonetheless, none of them completely investigates multi- dimensional synchronous conglomeration. Would we be able to coordinate the strength of the past calculations and create a more productive cubing strategy? In this paper, another chunk of ice cubing calculation, Star Cubing, is proposed, which incorporates the hierarchical and base up 3D shape calculation and investigates both multi-dimensional conglomeration and the Apriori pruning. Another information structure, star-tree, is presented that investigates lossless information pressure and prunes foreboding cells utilizing an Apriori-like powerful subset choice system. Our presentation study shows that Star-Cubing beats the past cubing calculations in practically every one of the information appropriations. The surviving from the paper is coordinated as follows. In Section 2 the three significant calculations in block calculation are rethought. In Section 3, we propel the incorporation of the hierarchical and base up calculation, present the star-tree structure, and foster the Star-Cubing calculation. Our 137 CU IDOL SELF LEARNING MATERIAL (SLM)
presentation study is introduced in Section 4. A conversation on potential expansions is in Section 5, and we close our investigation in Section 6. 7.3.4 Precomputing Shell Fragments For Fast High-Dimensional Olap These points show either anticipated application yet in addition research capability of the proposed approach and resulting subjects to which we wish to centre our further examination. The calculated constructors that our methodology utilizes are reasonable with minimal starting learning exertion as well as permit their practically moment interpretation to the information base pattern of the multidimensional information model. The proposed approach can be utilized as an apparatus for the help of a nimble arranged plan technique or strategy for the multidimensional information model plan measure. The ease of use of the proposed approach begins the semantic/calculated degree of plan. It tends to be utilized to imagine anticipated type of the multidimensional perspective on information and its parts and accordingly upgrading correspondence with the clients. The subsequent information base mapping then, at that point displays seclusion qualities which permit to adjust the subsequent outline with less exertion or to operatively execute expansions of the multidimensional information model into the type of a data set pattern, as indicated by new or changed necessities. This load of perspectives can fill the holes in the examination and configuration measure where the fashioners of the BI framework's information model battle with the absence of apparatuses to convey and work together with clients all the more viably and to make the model in a more limited time-frame. The capacity to change the theoretical multidimensional model into the actually implementable blueprint all the more viably is one of key anticipated benefits of the proposed approach. The upgrade in semantic and reasonable expressivity of the anchor model is anyway one of worries that we additionally wish to address in our next research. Uniqueness of taking care of the RCD's are additionally conceivably helpful to circumstances where the quickly changing information on clients are utilized much of the time in logical reports. For sure there is more work to be made to keep up with extra small measurements that are generally used to settle presence of quickly changing properties of the Rcd's. Our proposed approach utilizes bound together historization technique which is anyway relevant for Attributes as well as for Fact Ties despite the fact that strategies like inevitable historization of realities are as of now known. The use of the historization for Attributes can anyway outperform the utilization of scaled down measurements and set up more successful method for taking care of Rcd's. The capability of the proposed approach goes further. The geography of the anchor blueprint is like the way how the columnar information store stores segments of the connection. The use of columnar information stores regularly adds to the nature of the BI framework and generally makes the questioning all the more remarkable. Anyway another data set arrangement ought to be overseen. The implied particularity of the Anchor mapping permits packing each Attribute independently which is additionally more impressive when the information is requested somehow or another. This load of referenced realities oblige lower hard plate input/yield 138 CU IDOL SELF LEARNING MATERIAL (SLM)
requests that are additionally referenced in the segment 5. Other than this the different pressure and requesting of each Attribute is effectively reachable with our answer and it thusly offers comparable potential as the use of the columnar information store. The primary distinction is that the current social information base arrangement doesn't need to be changed. Section situated enhancement highlights are as of now revealed in the most current 2012 variant of the Microsoft SQL Server and we wish to make further correlation additionally utilizing this new element and acquire inquiry execution testing results. 7.4 TYPICAL OLAP OPERATIONS OLAP stands for On-Line Analytical Processing. OLAP is a classification of software technology which authorizes analysts, managers, and executives to gain insight into information through fast, consistent, interactive access in a wide variety of possible views of data that has been transformed from raw information to reflect the real dimensionality of the enterprise as understood by the clients. OLAP implement the multidimensional analysis of business information and support the capability for complex estimations, trend analysis, and sophisticated data modelling. It is rapidly enhancing the essential foundation for Intelligent Solutions containing Business Performance Management, Planning, Budgeting, Forecasting, Financial Documenting, Analysis, Simulation-Models, Knowledge Discovery, and Data Warehouses Reporting. OLAP enables end-clients to perform ad hoc analysis of record in multiple dimensions, providing the insight and understanding they require for better decision making. Fundamentally, OLAP has a very simple concept. It pre-calculates most of the queries that are typically very hard to execute over tabular databases, namely aggregation, joining, and grouping. These queries are calculated during a process that is usually called 'building' or 'processing' of the OLAP cube. This process happens overnight, and by the time end users get to work - data will have been updated. OLAP Guidelines (Dr.E.F.Codd Rule) Dr E.F. Codd, the \"father\" of the relational model, has formulated a list of 12 guidelines and requirements as the basis for selecting OLAP systems: 139 CU IDOL SELF LEARNING MATERIAL (SLM)
Figure 7.1: OLAP Operations Multidimensional Conceptual View: This is the central features of an OLAP system. By needing a multidimensional view, it is possible to carry out methods like slice and dice. Transparency: Make the technology, underlying information repository, computing operations, and the dissimilar nature of source data totally transparent to users. Such transparency helps to improve the efficiency and productivity of the users. Accessibility: It provides access only to the data that is actually required to perform the particular analysis, present a single, coherent, and consistent view to the clients. The OLAP system must map its own logical schema to the heterogeneous physical data stores and perform any necessary transformations. The OLAP operations should be sitting between data sources (e.g., data warehouses) and an OLAP front-end. Consistent Reporting Performance: To make sure that the users do not feel any significant degradation in documenting performance as the number of dimensions or the size of the database increases. That is, the performance of OLAP should not suffer as the number of dimensions is increased. Users must observe consistent run time, response time, or machine utilization every time a given query is run. 140 CU IDOL SELF LEARNING MATERIAL (SLM)
Client/Server Architecture: Make the server component of OLAP tools sufficiently intelligent that the various clients to be attached with a minimum of effort and integration programming. The server should be capable of mapping and consolidating data between dissimilar databases. Generic Dimensionality: An OLAP method should treat each dimension as equivalent in both is structure and operational capabilities. Additional operational capabilities may be allowed to selected dimensions, but such additional tasks should be grantable to any dimension. Dynamic Sparse Matrix Handling: To adapt the physical schema to the specific analytical model being created and loaded that optimizes sparse matrix handling. When encountering the sparse matrix, the system must be easy to dynamically assume the distribution of the information and adjust the storage and access to obtain and maintain a consistent level of performance. Multiuser Support: OLAP tools must provide concurrent data access, data integrity, and access security. Unrestricted cross-dimensional Operations: It provides the ability for the methods to identify dimensional order and necessarily functions roll-up and drill-down methods within a dimension or across the dimension. Intuitive Data Manipulation: Data Manipulation fundamental the consolidation direction like as reorientation (pivoting), drill-down and roll-up, and another manipulation to be accomplished naturally and precisely via point-and-click and drag and drop methods on the cells of the scientific model. It avoids the use of a menu or multiple trips to a user interface. Flexible Reporting: It implements efficiency to the business clients to organize columns, rows, and cells in a manner that facilitates simple manipulation, analysis, and synthesis of data. Unlimited Dimensions and Aggregation Levels: The number of data dimensions should be unlimited. Each of these common dimensions must allow a practically unlimited number of customer-defined aggregation levels within any given consolidation path. With the end goal of evaluation of the proposed approach we utilized 10 normal dimensional models that are run of the mill in different business circumstances, as per Ralph Kimball. The table 6 in the informative supplement of the paper contains the outline of each of the 10 models. The quantity of realities is low since we needed to test the underlying idea on a more modest reproduced dataset yet with applicable design and substance. Subsequently measurements have differing measure of characteristics and furthermore number of individuals. The explanation of choice of such example is that we needed to incorporate a 141 CU IDOL SELF LEARNING MATERIAL (SLM)
more extensive example of normal circumstances and to set up the ground for additional exploration. Later on we might want to zero in on the conceivable use of the proposed approach in a particular business climate. The 10 chose multidimensional models were then changed into 2 structures, the conventional non-standardized pattern and the exceptionally standardized outline, the two variations of a social information base diagram. Compositions were executed into the climate of the Microsoft SQL Server 2008 R2 data set worker with following equipment arrangement: 2x CPU Intel XEON E5450 3GHz, 16 GB RAM. The noticed complete size of the Anchor pattern was anyway higher than the composition of the conventional variation. The least contrasts were identified for measurements of models that have a couple of traits. For greater measurements there was contrast from around 100 to 300 MB recognized, contingent upon the aggregate sum of measurements and traits in them. By the by even the most elevated contrast isn't extremely high likewise given the way that the limit of the present information stockpiles takes upsides of petabyte. The thing that matters is a consequence of the essential key qualities' duplication in each Attribute connection. Genuine examples of multidimensional information models were inaccessible during testing. Hence the substance of each model was part of the way made utilizing machine age of information and incompletely utilizing sets of test normal qualities, similar to last names, office names, item names, request states and so forth The age of the substance was controlled so that there are no measurements' individuals that don't compare to any reality. Likewise the consideration of right qualities in measurements was checked so we will actually want to configuration working questions for testing purposes For each dimensional model there were 10 special business questions planned. Business questions were adjusted from, or roused by the arrangement of comparative inquiries that are utilized in the TPC-DS benchmark. Each question re-enacts one circumstance in which a BI situation's client controls the interface to get the ideal data. Inquiries on a multidimensional dataset figure projections, or perspectives, of the basic information solid shape 2 http://www.tpc.org/tpcds/default.asp. All things considered the projections in the SQL explanation consider typically just a little piece of the aggregate sum of dimensional qualities and a more modest measure of lines because of the utilization of sifting predicates. Business questions were then converted into such inquiries utilizing Structured Query Language, with 2 renditions for every business question. The arrangement of inquiries contained examples of questions that included either all individuals from explicit measurement or an applicable chose piece of it. Likewise the quantity of reality columns included was not the equivalent. We utilized collection of execution measures by an important proportion of time or a business important class When testing the execution of a question, in principle, a trial doesn't come up short if all solicitations produce right answers and the condition of the test data set is unaltered after the execution of the entire trial . Subsequently we observed likewise the level of inquiry handling blunders during trials. All outcomes showed 0 % of mistakes so all trials were considered effective. Each inquiry was executed multiple times to stay away from critical mutilation of results by inevitable remote qualities. The open-source programming 142 CU IDOL SELF LEARNING MATERIAL (SLM)
Apache JMeter was utilized to test and recording aftereffects of question execution alongside the Microsoft SQL Server Management Studio 2008 programming The information we assembled from the inquiry execution testing incorporates 2 sorts of informational indexes for the two variations of the construction. The main informational collection contains 300 execution time results for every one of the 100 inquiries and each of the 10 models. These outcomes were then used to finish the subsequent informational index that contained related attributes for each question, that is, other than mean worth of execution season of each inquiry, additionally measure of joins needed by each question, coming about number of lines returned after the execution of each inquiry, absolute size of the yield and furthermore cardinality of every information object that was examined by the data set framework to get the ideal yield. 7.5 SUMMARY There are a few works managing displaying parts of the multidimensional information model plan measure all the more completely. Anyway no works managing the utilization of the anchor demonstrating or any comparative methodology that depends on undeniable level of the standardization in this field were found. In, there is the anchor demonstrating strategy presented yet concerning testing the questioning presentation the creators did execution trial of their fundamental idea just in correlation with results for the incorporated venture information distribution centre construction elective. This approach is anyway officially identified with the Inmon's \"Corporate Information Factory\" approach. This methodology was at that point completely investigated and surveyed in the past that lead to a proposal of a tighter relationship with R. Kimball's unadulterated information store and multidimensionality arranged methodology. The subsequent mixture approach and the last unadulterated methodology separately are the foundation for our methodology and furthermore for a few different works referred to. The primary intention in such mix of approaches is that the CIF approach based BI framework's information model isn't appropriate for impromptu questioning. The solid mark of the CIF arranged information model anyway lies in the field of information mining and normalized creation detailing. On the opposite side the Kimball's methodology is equipped for fulfilling needs of the impromptu examination of a lot of information. The typical difficulty is with supporting general assignments that need more standardized information structures. In, there is a proposition and conversation of a social pattern change idea which works with transformation of the information stockroom to changing information sources. The progressions in one or the other design or substance of the multidimensional 143 CU IDOL SELF LEARNING MATERIAL (SLM)
information base blueprint is anyway still a feasible examination subject. In, there is a methodology called MultiDimER recommended that is additionally a visual theoretical demonstrating language. Anyway the MultiDimER incorporates fascinating dimensional properties' order dealing with ideas that consider additionally development of the chain of command levels and measurement's substance. The MultiDimER approach utilizes progressive disintegration of properties as for conceivable change conduct. The approach is anyway not essentially surveyed in the paper. The proposition is anyway cutting-edge enough to be essentially relevant with extra and suitable meaning of execution details. We intend to advance our methodology with visual theoretical apparatuses for addressing staggered pecking orders in spite of the fact that we accept that an inflexible proper meaning of a progressive system isn't as significant subject since the approach of self-administration BI instruments. likewise proposes applied plan ideas that are focused on at the exhaustive formalization of a snowflake construction. Our methodology is truth be told an extraordinary type of the snowflake diagram which is in a more standardized star pattern. The creator’s present just proper appraisal of their methodology and the paper needs useful illustration of their proposed approach. Also implies for taking care of progressive systems are absent and propose a high level applied plan idea that considers formal plan of measurements and realities as well as changing types of progressive systems. The paper anyway needs useful assessment of the proposed approach and in spite of formal wealth of the reasonable model definition, it gives just hypothetical avocation of the idea. The defence doesn't present enough evidences whether such arrangement would be effectively implementable without genuine information and comprehension of the idea by fashioners however chiefly by clients. Condition of-craft of our proposed idea depends on basic and reasonable portrayal of constructors for the multidimensional information model parts with consistent coherent and furthermore calculated importance. Further expansions anyway ought not forfeit understandability for expanded conventional wealth. In, the proposition centres likewise around the reasonable demonstrating viewpoints including progressed formal meaning of displaying constructors. By and by no pecking order demonstrating perspectives are incorporated as in and furthermore the idea needs down to earth assessment – the methodology proposed in this paper anyway gives off an impression of being very widespread and extensible. Our methodology can likewise be utilized for the calculated degree of demonstrating with bound together arrangement of basically justifiable constructors. In any case, valuable ideas of successful taking care of changes in and representation of pecking orders are as yet absent – just changes in credits are now covered by the historization guideline. 144 CU IDOL SELF LEARNING MATERIAL (SLM)
Notwithstanding that we gave beginning assessment from the inquiry execution point of view which is significant for the assessment of conceivable applied displaying capacities and handiness too. However in spite of that, our outcomes ought to be treated as exploratory now with more examination to be led to demonstrate its adequacy and helpfulness practically speaking. The outcomes anyway show some reasonable potential for conceivable pragmatic utilization of the proposed approach and furthermore conceivable further examination subjects were at that point illustrated. Referenced papers present diverse exploration track inverse to another that ought to be likewise noted. This examination track implements use of article arranged information demonstrating standards and UML language to display underlying and furthermore fleeting development parts of the multidimensional information model. Papers,present novel methodologies that present intriguing theoretical plan standards for demonstrating the multidimensional information model. Anyway these works present no accurate execution testing results other than instances of conceivable utilization of their methodology and formal necessities assessment. Another worry with these proposed approaches is that the item situated methodology is ledge not ended up being fruitful or valuable enough in the field of supporting the multidimensional information model plan and implementation measure. Paper additionally follows the UML based exploration track yet the creators propose a methodology that adds answer for taking care of changes of information esteems in the item arranged multidimensional information model. This methodology is like our proposed approach in the part of taking care of the progressions in dimensional qualities. By the by our methodology isn't expected as a feature of the article arranged exploration track. The point of the paper was to introduce proposition of the test way to deal with the plan of the multidimensional information model. The methodology was evaluated from an inquiry execution time viewpoint. The outcomes show that concerning contrasts between inquiry execution time consequences of both evaluated data set pattern variations, our example of inquiries created measurably inconsequential various outcomes albeit the mean for the two examples was by 64 ms more regrettable for the Anchor outline variation the outcomes. The outcomes additionally showed that there was inconsistent measure of better and more awful performing questions for the Anchor diagram variation. The contrasts were anyway not high as a rule which is the consistent outcome of genuinely inconsequential distinction in outcomes. The data set diagram made by our proposed approach displays significant degree of standardization which has some normal advantages and furthermore potential downsides. Required higher measure of joins ended up being inconsequential corresponded with the mean question execution 145 CU IDOL SELF LEARNING MATERIAL (SLM)
time. Likewise the aggregate sum of lines handled during execution of the output activity demonstrated to have low connection with the mean inquiry execution time. Differences higher than 1 second were shown because of obsolete table insights in light of the fact that there were no eminent changes in inquiry execution plan structures. The aftereffects of complete I/O requests likewise showed that our methodology brings lower requests as far as required measure of plate activities regardless of the way that the measure of columns checked is at times higher. There might be different impacts that can impact inquiry execution results particularly in the event of incredibly complex questions. We intend to lead more exploration on these circumstances just as parts of historization that can fill in as a more compelling option in contrast to normal SCD and basically RCD calculations. The idea of our methodology clearly needs more confirmations of conceivable value albeit some of them were at that point laid out in the text. These future outcomes will assist us with completely supporting materialness of the proposed approach as far as its proficiency, adaptability and they will likewise perhaps introduce complex evidences of its adequacy for the field of the multidimensional information model plan measure. 7.6 KEYWORDS Sentiment Analysis-The extraction of words or expressions which pass on enthusiastic importance. For instance, the sentence \"The chicken curry was pungent and overrated\" demonstrates a negative feeling as \"overrated\" has an enthusiastic significance. Scraping-Scraping data is a programmed approach to visit a site, reorder the data elsewhere. Taxonomy-A controlled jargon coordinated in a various levelled way, or improved with equivalent words and non-progressive connections for example feline is a cat, is a warm-blooded creature, and so on Text And Data Mining - Text mining is the information examination of regular language works, utilizing text as a type of information. It is normal gotten together with information mining, the numeric investigation of information works, and alluded to as \"text and information mining\" or, essentially, \"TDM.\" Treebank-This is as corpus of linguistically parsed archives used to prepare TDM models. 7.7 LEARNING ACTIVITY 1. Create a session on Multidimensional Data Model. 146 CU IDOL SELF LEARNING MATERIAL (SLM)
___________________________________________________________________________ ___________________________________________________________________________ 2. Create a survey on Data Cube Computation Methods. ___________________________________________________________________________ ___________________________________________________________________________ 7.8 UNIT END QUESTIONS A. Descriptive Questions Short Questions 1. What is Multidimensional Data? 2. Write the full form of MOLAP? 3. Write the full form of ROLAP? 4. What is SQL? 5. How many dimensions does a data cube have? Long Questions 1. Explain the advantages of Data cube. 2. Illustrate the Computing Iceberg Cubes from the Apex Cuboid Downward. 3. Examine the functions of Data cube. 4. Discuss on the Precomputing Shell Fragments for Fast High-Dimensional OLAP. 5. Elaborate the Typical OLAP Operations. B. Multiple Choice Questions 1. Which is the branch of statistics deals with development of particular statistical methods? a. Industry statistics b. Economic statistics c. Applied statistics d. Applied statistics 2. Which of the following is true about regression analysis? a. Answering yes/no questions about the data b. Estimating numerical characteristics of the data c. Modelling relationships within the data 147 CU IDOL SELF LEARNING MATERIAL (SLM)
d. Describing associations within the data 3. Select the right option for the statement -Text Analytics, also referred to as Text Mining? a. True b. False c. Can be true or False d. Cannotbe determined 4. What is a hypothesis? a. A statement that the researcher wants to test through the data collected in a study. b. A research question the results will answer c. A statistical method for calculating the extent to which the results could have happened by chance. d. None of these 5. What is the cyclical process of collecting and analysing data during a single research study called? a. Interim analysis b. Inter analysis c. Inter item analysis d. Constant analysis Answers 1-d, 2-c, 3-a, 4-a, 5-a 7.9 REFERENCES References book Baskin, C. C., & Baskin, J. M. (2014). Seeds: Ecology, biogeography, and evolution of dormancy and germination (2nd ed.). Academic Press. Becknell, J. M.,& Kissing Kucek, L., & Powers, J. S. (2012). Aboveground biomass in mature and secondary seasonally dry tropical forests: A literature review and global synthesis. Forest Ecology and Management: 276, 88–95. https://doi.org/10.1016/j.foreco.2012.03.033. 148 CU IDOL SELF LEARNING MATERIAL (SLM)
Bellard, C.,& Cassey, P., & Blackburn, T. M. (2016). Alien species as a driver of recent extinctions. Biology Letters. https://doi. org/10.1098/rsbl.2015.0623. Textbook references Wyse, S. V.,& Dickie, J. B. (2017). Predicting the global incidence of seed desiccation sensitivity. Journal of Ecology. 1082–1093. https://doi.org/10.1111/1365- 2745.12725. Wyse, S. V., & Dickie, J. B. (2018). Taxonomic affinity, habitat and seed mass strongly predict seed desiccation response: A boosted regression trees analysis based on 17 539 species. Annals of Botany. Zahawi, R. A.,& Holl, K. D.,& Cole, R. J., & Leighton Reid, J. (2013). Testing applied nucleation as a strategy to facilitate tropical forest recovery. Journal of Applied Ecology Website https://www.researchgate.net/publication/2573080_Star- Cubing_Computing_Iceberg_Cubes_by_Top-Down_And_Bottom- Up_Integration/link/02e7e5233f842dec21000000/download http://dspace.vpmthane.org:8080/jspui/bitstream/123456789/3171/1/Data%20Wareho use%20Architecture.pdf https://www.ijirae.com/volumes/Vol2/iss4/08.APAE10098.pdf 149 CU IDOL SELF LEARNING MATERIAL (SLM)
UNIT - 8 DATA WAREHOUSE DESIGN STRUCTURE STRUCTURE 8.0 Learning Objectives 8.1 Introduction 8.2 Usage 8.3 Data Warehouse Implementation 8.3.1 Efficient Data Cube Computation: An Overview 8.3.2 Indexing OLAP Data: Bitmap Index and Join Index 8.3.3 Efficient Processing of OLAP Queries 8.3.4 OLAP Server Architectures: ROLAP versus MOLAP versus HOLAP 8.4 Data Generalization by Attribute Oriented Induction 8.4.1 Attribute-Oriented Induction for Data Characterization 8.4.2 Efficient Implementation of Attribute-Oriented Induction 8.4.3 Attribute-Oriented Induction for Class Comparisons 8.5 Summary 8.6 Keywords 8.7 Learning Activity 8.8 Unit End Questions 8.9 References 8.0 LEARNING OBJECTIVES After studying this unit, you will be able to: Appreciate the scope of Data Warehouse Implementation. Illustrate the Indexing OLAP Data: Bitmap Index and Join Index. Explain the OLAP Server Architectures: ROLAP versus MOLAP versus HOLAP. 8.1 INTRODUCTION In PC programming settings, an information block is a multi-dimensional exhibit of qualities. Regularly, the term data cube is applied in settings where these exhibits are enormously 150 CU IDOL SELF LEARNING MATERIAL (SLM)
Search
Read the Text Version
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 210
- 211
- 212
- 213
- 214
- 215
- 216
- 217
- 218
- 219
- 220
- 221
- 222
- 223
- 224
- 225
- 226
- 227
- 228
- 229
- 230
- 231
- 232
- 233
- 234
- 235
- 236
- 237
- 238
- 239
- 240
- 241
- 242
- 243
- 244
- 245
- 246
- 247
- 248
- 249
- 250
- 251
- 252
- 253
- 254
- 255
- 256
- 257
- 258
- 259
