Free Essay

Sumit

In: Computers and Technology

Submitted By mehtasumit11
Words 491
Pages 2
IS-624-201 CHAPTER 4 – SUMIT

4.2

The snowflake schema and fact constellation are both variants of the
Star schema model, which consists of a fact table and a set of dimension tables. The snowflake schema has normalized dimension tables, whereas the Fact constellation has a set of fact tables that share some common dimension tables. A Star net query model is a query model, which has set of radial lines emanating from a central point and each radial line represents one dimension and each point (called a “footprint”) along the line is consist a level of the dimension, and each step going out from the center represents a concept hierarchy of the dimension. The star net query model, is querying purpose and provides users with a global view of OLAP operations and helps in decision making.

a)
Three classes of schemas popularly used for modeling data warehouses are the star schema, the snowflake schema, and the fact constellations schema.

(b)

(c)

The operations to be performed are:
• Roll-up on time from day to year

• Slice for time=2004

• Roll-up on patient from individual patient to all

(d) To obtain the same list, write an SQL query assuming the data is stored in a relational database with the schema.

Fee (day, month, year, doctor, hospital, patient, count, charge)

4.4
a)

b)
The following OLAP operations should be performed:

•Roll-up on course from course id to department

• Roll-up on student from student id to university

•Dice on course, student with department=“CS” and university = “Big-University”

C) It contain
5^4 = 625 cuboids.

Q 4.5)
a)

b)
The specific OLAP operations to be performed are:

•Roll-up on date from date id to year

• Roll-up on game from game id to all

• Roll-up on location from location id to location name

• Roll-up on spectator from spectator id to status

• Dice with status=“students”, location name=“GM Place”, and year=2004

c) Bitmap indexing is useful for following reasons: * Low cardinality domain * Long location name can be represent by single bit * Vector representation for long cardinality dimension like “date”

4.8
a) Database like telephone billing company have huge and sparse data cube because it has to removed data in every few month because of detailed database and it’s very hard and expensive to maintain that database.
b)
To overcome sparse matrix problem we follow following steps: 1. Partition array based cube into chunks 2. Compress these chunks to remove cells which don’t have valid data 3. Minimize the visit time for cube cells 4. Sort and compute the planes of data cube in ascending order 5. Keep small plane into main memory and compute only one chuck for big plane

c) only compute those cells which have new data instead of whole cube because in incremental update it compute one chunk at a time and recomputed value propagated to higher cuboid.

Similar Documents

Premium Essay

Sumit

...GRAM : REGAPP PHONE 0512-2296088 Government of India Ministry of Labour & Employment Regional Directorate of Apprenticeship Training Udyog Nagar, Kanpur – 208022 JOINT INSPECTION REPORT (Under Section 27 & 29) (Apprenticeship Training under the Apprentices Act, 1961) Section – A 1. | Name & Address of the establishment Inspected/visited | Usha Martin Ltd 12/16 Nawal Ganj Agra. | 2. | Name & Designation of the Inspecting Officer of RDAT/DGET/SAA | 1.Sh.A.k Tyagi,ADT RDAT Kanpur.2.Sh.Phool Chandra,ACAAR(Jr.) RDAT Kanpur.3. Sh.Mukesh Kr. Yadav,Pricipal I.T.I Agra.4. Sh.Chandrabhan, Jr.AA Govt.I..T.I Agra. | 3. | Name & Designation of the Officers of the Estt. Who were associated with the Inspection | Ashwani Saxena (Personnel officer). | 4. | Name & Designation of the Head of the Estt. And Tel. No. | Mr.S.Bhowmick (Personnel Manager)Tel.No.:9319968880 | 5. | Name & Designation of the Officer Incharge of the Apprenticeship Training & Tel. No. | Mr.Kishor Singh,Diagnostic expert & Trainer.Tel.No.:8445445761. | 6. | Date of the last Inspection/Visit carried out and name of the concerned officers. | First Inspection | 7. | Working hours and days/week | 6 days/week 8 hours per day | 8. | Date of inspection | 17.01.2013 | Section:B 1. Recruitment of apprentices S. No. | Designated Trade | Seat located | Seat utilized | Fresher | Ex-ITIs | Short falls | Excess | Remarks | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8...

Words: 1080 - Pages: 5

Free Essay

Tester

...Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not sumit this now.Do not...

Words: 486 - Pages: 2

Free Essay

String Reversal Program C

...Course Title Fundamentals of Algorithm * Write a function which take two integer constants and display the sum, multiplication. If both numbers are less than 100 otherwise if first number is less than 100 and second number is greater than 100 then perform the division. Please note that sum, multiplication and division logic should be in separate function. #include<stdio.h> #include<conio.h> int a,b,x,y; int sumIt(int x , int y ) { return x + y; } int multiplyIt(int x, int y) { return x * y; } int devideIt(int x, int y) { return y / x; } void displayIt(int a, int b) { if (a < 100 && b < 100) { printf("sum is %d",sumIt(a,b)); printf("\nproduct is %d",multiplyIt(a,b)); } else if (a < 100 && b > 100) { printf("Devision is %d",devideIt(a,b)); } else { printf("No condition matches so not performing any calcuclation."); } } void main() { printf("Enter value of a and b:"); scanf("%d %d",&a,&b); displayIt(a,b); getch(); } * Write a program which perform following on string data * Reverse * Small to caps * Caps to small * Find a character from string * Replace a character REVERSE: #include<stdio.h> int main(){ char str[50]; char rev[50]; int i=-1,j=0; printf("Enter any string : "); scanf("%s",str); while(str[++i]!='\0'); while(i>=0) rev[j++] = str[--i]; rev[j]='\0'; ...

Words: 366 - Pages: 2

Premium Essay

Summary Paper and Bibliography

...(Summary of Best Practices of Data Security) By Victoria Armstrong-Mensah A Paper Presented in Partial Fulfillment of the Requirements of QSM 358 November 23, 2014 Phone: 403-452-1200 E-mail: v.hackman@hotmail.com Professor: Prof Shamburg This paper summarizes other sources of data security we will present to our host companyExceltox to help them become better HIPAA compliant. Exceltox is currently minimally legally compliant as they are a new company – less than a year old. A breach would be costly in penalties and fines and could also risk the reputation of Exceltox. Title of Paper (same as title page) Begin your introduction to your paper here. The introduction should include a thesis statement defining the main topic of the paper. Three supporting points that will be discussed about the main topic are also introduced. APA requires that you double space the entire document. Be sure to indent the first line of each paragraph between five and seven spaces. All paragraphs should be at least 3 sentences. Supporting Point 1 (title case, use your own words) The first supporting point is detail starting in the second paragraph. Multiple paragraphs can be used for each supporting point discussion. Use library peer-reviewed cited sources to support your writing and add credibility to your writing. Each supporting point should have a unique peer-reviewed source. Use transitional statement at the end of the paragraph to transition to the...

Words: 677 - Pages: 3

Premium Essay

Bank of America and the Sec

...Bank of America Wardell Gordon Strayer University Professor Lateefah Muhammad June 15, 2014 Bank of America and the SEC The banking and securities establishment has been around virtually since the founding of this great nation. Right after the United States declared their independence from England they reformed and established a new way to bank and circulate money. From the start, the banking and securities industry have been working hand and hand. According to Sylla,” the sector that benefited most from early U.S. securities markets was banking. Banks in the United States, unlike most banks in other countries at the time, were corporations that raised their banking capital by issuing equity securities…active trading markets in the1790s.”(1998).This system was a ticking bomb for corruption from the beginning. There was little regulation the governed the securities industry. This sector was lawless like the Wild West. It left the door open for greedy bankers and brokers to steal and steal until almost everything was almost gone. These bankers and brokers was selling snake oil to vulnerable Americans. The SEC website states,” During the 1920s, approximately 20 million large and small shareholders took advantage of post-war prosperity and set out to make their fortunes in the stock market. It is estimated that of the $50 billion in new securities offered during this period, half became worthless.”(n.d.). This prelude to the catastrophic event called the Great Depression...

Words: 1522 - Pages: 7

Premium Essay

How Did the Indian National Congress Win Support and What Part Did It Play in Ending British Rule?

...How did the Indian National Congress win support and what part did it play in ending British rule? The Indian Independence Act of 1947 marked a watershed upon the history of India and imperialism, predicating the protracted, but evident, retreat of empire. A body of influences are readily available in providing a depth of understanding of the event; it is, however, the permeating legacy of the Indian national congress that has been routinely identified as a political organisation synonymous with the departure of empire and colonialism. The remit of this essay focuses our attention upon the development and narrative of the Indian National Congress, and the use of its political structure in exercising and mobilising nationalist sentiments throughout the Asian subcontinent. Although instrumental and inherently central to the discussion of Indian independence, one must retain an open and wider view of the multitude of pressures, from within and without, that ultimately led to British withdrawal. It would be prudent therefore to accommodate the international economic and political circumstances that restricted the manoeuvrability of the British following the Second World War, and its noticeable influence upon the retreat of imperialism, upon the wider discussion of the end of British rule. Although providing the structure of national identity, the degree to which the congress had a direct impact upon the redirection of imperial policy is subject to speculation. The narrative...

Words: 2567 - Pages: 11

Free Essay

Children

...been elected as Secretary General. Ramachandran polled 692 votes, defeating his rival Parvez Ahmed, the incumbent president who got 444 votes. Dikshit defeated Pushpendra Kulshreshtha, who has been occupying the post of the Secretary General for a record four time. Dikshit polled 626 votes as against 520 votes secured by Kulshreshtha. Anil Anand and Vineeta Pandey of DNA have been elected as Vice-Presidents, while Nadeem Ahmad Kazmi of NDTV is the new Treasurer of the Club. The elected members of the executive committee include Aarti Dhar, Aditi Nigam, Anoop Saxena, Avtar Negi, Dinesh K Tewari, Jagdish Yadav, Jomy Thomas, MK Tayal, Narendra Bhalla, Nitin A Gokhale, Rajeev Ranjan, Sanjay Singh, Sanjeev Upadhyay, Shambhu Nath Choudhary, Sumit Mishra, and Vijay Saluja. This year’s elections at the PCI assume significance as these were held under the supervision of a Court observer. Delhi High Court had appointed an observer to hold the elections after a suit filed by three members of the Press Club alleging that a number of persons were given membership of the Club in violation of the laid down procedures and that their names had figured in the voters’ list. The results were declared in the presence of the Court observer. Other major highlights of this year’s elections were that these were fought on the main plank of journalists versus...

Words: 350 - Pages: 2

Free Essay

Market Plan of Smirnoff Vodka

...Introduction When local markets mature and opportunities are not coming up as they used to, firms must reallocate their position and their strategy. Entering new markets offers advantages and developing opportunities. In order to achieve profitability Michael Porter established a 4 strategy matrix, three of which might be found very useful to a company that wishes to follow international headway (Michael Porter, 1980). Through this assignment Porter’s matrix and his proposals are about to be presented as a helpful tool for any enterprise that whishes development off its country’s borders. Two major companies, worldwide known for their products in beverage market segment are about to be analyzed as representative examples of their differentiative and cost leadership character. VIN and Spirit, a Swedish firm which was the creator of Absolut Vodka compared with Diageo, Smirnoff’s enterprise. VIN and Spirit Company without the basic knowledge of a global strategy, it managed to obtain one of the leading market beverage segments being also a very representative example of advertising and packaging differentiation (Vin & Spirit Annual report, 2007). The second company, DIAGEO is producing popular products ne of which is Smirnoff Vodka. Because of its well known products worldwide, Diageo does not concentrate on a specific product (DIAGEO Annual Report, 2007).Instead it uses very good organized mechanisms of production, promotion packaging and distribution with lowest cost...

Words: 3804 - Pages: 16

Premium Essay

History of Indian Sub Continent

...PAPER 28 THE HISTORY OF THE INDIAN SUBCONTINENT FROM THE LATE EIGHTEENTH CENTURY TO THE PRESENT DAY READING LIST: 2012-13 C. A. Bayly cab1002@cam.ac.uk 1 The History of The Indian Subcontinent From The Late Eighteenth Century To The Present Day A fifth of the world's population lives in the Indian subcontinent. While today the region’s place in the global world order is widely recognised, this is in fact only the most recent chapter in a longer history. This paper offers an understanding of the part played by the Indian subcontinent role and its people in the making of the modern world. From the decline of the great empire of the Mughals and the rise of British hegemony, to the rise of nationalism, the coming of independence and partition, the consolidation of new nation states despite regional wars and conflicts, and the emergence of India as the largest democracy in the world, this paper is a comprehensive and analytical survey of the subcontinent's modern history. The dynamic and complex relationships between changing forms of political power and religious identities, economic transformations, and social and cultural change are studied in the period from 1757 to 2007. In normal circumstances students will be given 6 supervisions in groups of 1 or 2. Key themes and brief overview: The paper begins by examining the rise of British power in the context of economic developments indigenous to southern Asia; it analyses the role played by Indian polities and social groups...

Words: 11803 - Pages: 48

Free Essay

Front Page

...days (d) 101/2 days 5. A does 20% less work than B. If A can finish a piece of work in 7 1 /2 hrs..Then B can finish it in (a) 5 hrs (b) 51 /2 hrs (c) 6 hrs (d) 61 /2 hrs 6.A work twice as fast as B. If both of them can together finish a piece of work in 12 days ,then b alone can do it in ? (a) 24 days (b) 27 days (c) 36 days (d) 48 days 7. A take 50% more time B to complete a work. If together they takes 18 days to finish it . How much time shall b take to do it alone? (a) 30 days (b) 35 days (c) 40 days (d) 45 days 8.Sumit is twice as good workman as Amit. Sumit finished a piece of work in 3 hours less than Amit. In how many hours...

Words: 1688 - Pages: 7

Premium Essay

Social Studies

...Social Studies School Based Assessment Outline School Based Assessment. This is an evaluation conducted by the school while the social studies course is still in process. Candidates are required to conduct a guided research and document their findings your teacher/ other appropriate persons will guide you throughout the process. You MUST do your own work; it should not be done for you. Punishment will be administered to candidates in which it can be proven that they have plagiarized other persons work. The First draft must be handed in to your teacher NO later than the third week in November this will be corrected and returned. FINAL drafts must be handed in by the FIRST week in February. **WARNING** Do NOT hand in your drafts a few days before the deadline and pressure your teacher to mark and return it immediately to suit your needs. You will not be accommodated except in extraordinary circumstances, speak with your teacher if there is a problem. Be disciplined, MEET YOUR DEADLINES. If you hand in a research that your teacher has never seen before, this may be to your disadvantage and you may not get the marks you deserve. Tasks The S.B.A. is marked out of 40. This values 20% of the total marks. Your report must be between 1000 – 1200 words in length, this should include appropriate graphs and charts . Each task is allotted a certain number of marks. If you miss (omit) a task, the marks cannot be allotted (the...

Words: 1502 - Pages: 7

Free Essay

Cgi Question and Answer

...Those Who are going for CGI , on 9th May 2015 Sample Placement papers for CGI Aptitude sample paper for CGI - placement paper Q. Every day a driver comes to pick up a man at his office at 6pm. One day the man gets free early and rather than waiting for the driver, he starts walking for home at 4:30pm. The man meets the driver on the way and then reaches home 30minutes earlier than usual. What is the usual time that man takes to reach home from the office? Q. What is the distance travelled by a ball that falls from a height of 8 mts and each time it bounces half the distance back? Q. What is the height of the cone of diameter 12 cm that is formed after melting a sphere of 6 cm diameter? Q. A can work three times as B can work. If A takes 60 days less than B to complete the same task, calculate the number of days when both A and B start working together on the same day. a) 25 days b) 20 days c) 22 and 1/2 days d) 24 days Q. A boy has Rs 3 in total. If he wins, he gains 1 Rupee and if he looses, he has to loose 1 Rupee. The boy may lose only 5 times in the game and if he earns 5 Rs, he has to quit the game. Find the number of ways of the possibilities. Q. A and B decide to speak truth or lie on a day. Another person asks A if he is saying truth or lie. B listens to A whatever he answers. Now the person asks B what A had told. B replies as “ A has told that he is a liar”. What does B say? a) Truth b) Truth when A lies c) Lie d) Cannot be determined Q. What is the...

Words: 4227 - Pages: 17

Premium Essay

Ms Economis

...Simulation Homework 2 (Due Date: April 29, 2016 @ 10:00 p.m) Sumit Kunnumkal Indian School of Business, Hyderabad, India 500032 Important Note: Submit the homework through the LMS website as a word document. Submit the excel sheet(s) that shows your simulation model along with your homework submission. Include a separate excel sheet for every simulation question and name the excel sheet according to the question number. Please be sure to follow the below instructions when building your simulation model. 1. Clearly indicate the steps in all your simulation models – what random variables form the input and what are their distributions, what is the output that you are measuring and the functional relation between the output and the input random variables. 2. In all your simulations, set the number of trials to 1000 and the seed as 1. Set the sampling type as Monte Carlo and the generator as Mersenne Twister. You are expected to follow the ISB Honor Code for the homework and case submissions. Question 1: The revenues and costs at ABC company vary from month to month and can be modeled as random variables. ABC estimates (based on past data) that its sales, cost of goods sold (COGS), marketing costs, administrative costs and miscellaneous costs for the month of January have the following distributions: January figures Sales COGS Marketing cost Administrative cost Miscellaneous cost Normal(2225,150) Uniform(870, 910) Triangular (90, 93, 96) Triangular...

Words: 548 - Pages: 3

Free Essay

Suzuki

...Top of Form Bottom of Form Explore Zoom    1. Perception of the environment – It is worthwhile to take a deeper look into theenvironmental factors that severely affect the organization due to its closeentanglement with various issues. The political is probably the most unstable factor asthe government decides to continuously slash tax rates on various commodities andthe debate rages on the approval of FDI in the automobile sector.The economic scenario has been highly volatile with easy availability of finance,incentives from the government, policies and duties and taxes. The technologicalfactor deeply affects the organization as this is a highly technically influenced productand has a direct effect on the productivity of the firm and its workers. In the legalenvironment, the country has relatively high import duties and has a weighted taxreduction of upto 150% on in-house RnD activities. 2. Choice of Strategy - The strategy includes to counter increasing competition andfalling market share in the small car segment, increase yearly manufacturing capacity, build new research and development facility, increase annual production capacity totwo million mark in five years, setting a precedent for automakers countrywide andincreasing penetration in the rural segment are some of the strategies adopted by theorganization. 3. Selection of technology - In order to face the onslaught of increasing competitionmanagers today look for ways to use information technology as a...

Words: 1955 - Pages: 8

Free Essay

Organization Leadership in Apple

...SK Shinde b. Salman Khursheed c. Veerappa Moily d. None of these 7. What is the percentage stake acquired by Arcelor Mittal in Uttam Galva Steel in a deal worth 422 crores recently? a. 21 per cent b. 23 per cent c. 25 per cent d. 29 per cent 8. The amount invested by the Venture Capital fi rms in around 92 deals in India by the end of 2009 is? a. $345 million b. $475 million c. $550 million d. $640 million 9. Subir Raha who passed away recently, was an outstanding public service executive and headed one of the major oil companies of India. Identify the name of the organisation that he headed a. IOC b. ONGC c. BPCL d. HPCL 10. The name of the recently appointed disinvestment secretary of India is … a. Ashok Chawla b. Sumit Bose c. Sunil Mitra d. Krishna Kumar Goyal 11. Which veteran journalist has been appointed as the chairman of the Prasar Bharti recently. a. Vir Sanghvi b. N. Ram c. Mrinal Pandey d. Pravin Swami 12. Name the...

Words: 1807 - Pages: 8