Improving Public Infrastructure A Study Of Guyana

Using PPP Model to improve public infrastructure: A study of Guyana Foreign Direct Investment and Private Investments need adequate public infrastructure; which can be facilitated through greater Public Private Partnership within Guyana. If only we knew more about the determinants of investment! But, unfortunately, our knowledge in this direction is still very meager. One might well ask, what is wrong with the theory of investment? Or, perhaps, what is wrong with the subject matter itself! For one thing, this variable, -- the pivot of modern macroeconomics -- has apparently lived a somewhat nomadic life among the various chapters of economic theory. Perhaps it has not stayed long enough in any one place. Perhaps it has been†¦show more content†¦Consequently, the government of Guyana has realized the need for greater public private investments and consequently has favored the Public-Private Partnership (PPP) model of financing many major infrastructural projects in an attempt to close this gap of inefficient infrastructure. Moreover, Guyanaâ €™s investment climate took a downward turn in 2013 as political gridlock and infighting hampered the country’s development efforts on several fronts. Notwithstanding this, the government continued to encourage foreign investment, but has had limited success in attracting that investment outside of the gold mining sector. Perceptions of corruption, inefficient government and inadequate infrastructure among others remain barriers to attracting foreign investment. Centered on the existing literature from published works such as books, journals and articles; this study highlights Keynesian theory on investments, as well as assess and apply the Kuznets Model by using the Kuznets curve to analyze and explain the relationship between infrastructure development and GDP per capita. Additionally, this study will also highlights the success factors for implementation which includes Political Will and political consensus, PPP Unit, the right vision, Good Governance and Continuity. It will also compiles a framework for cross analysis with the three (3 Case studies) PPP cases in Guyana, and checks for the relevancy of each variables based on

The Extent to Which Labor Unions Can Influence Human...

THE EXTENT TO WHICH LABOR UNIONS CAN INFLUENCE HUMAN RESROUCE PRACTICES IN BAHRAIN BY AFAF ABDUL AZIZ OPEN UNIVERSITY MALAYSIA THE EXTENT TO WHICH LABOR UNIONS CAN INFLUENCE HUMAN RESOURCE PRACTICES IN BAHRAIN BY AFAF ABDUL AZIZ Project Paper Submitted in Partial Fulfillment of the Requirement for the Degree of Master of Human Resources Open University Malaysia (May 2010) ABSTRACT Labor unions are legal organizations that consists of a group of workers who have banded together to bargain with employers on behalf of workers. The primary role of labor unions is to fight for better rights, working condition, wages, hours and benefits for workers. On the other hand side, management always introduces and implements†¦show more content†¦Introduction................................................................................................................................. 1 1.1 Background of the study ....................................................................................................... 1 1.2 Problem statement................................................................................................................. 2 1.3 Objectives of the study.......................................................................................................... 2 1.4 Significance of the study.................................................... ................................................... 3 1.5 Limitation of the study.......................................................................................................... 3 2. Literature review......................................................................................................................... 4 2.1 Introduction to industrial relations........................................................................................ 4 2.3 Trade unions.......................................................................................................................... 5 2.3.1 What is a

Functionalists View of Education free essay sample

Functionalists look at how society works in a scientific way to see how it works. They have similar ideas about education too. There are three main functions. The first is socialisation. Education is a source of secondary socialisation. It helps to teach young people values, norms equality and achievement. Schools are the main part of a child’s day and therefore influence them greatly. The second is learning skills. When in education, you learn a number of skills such as numeracy and literacy. This has now been made compulsory to ensure young people are getting the best qualification of their ability. This will result in them getting the grades they need and having jobs best suited to them. The final one is the allocation of roles. There is said to be a fair system which allocates the right people for the right job. This is all based on their skills and qualification. We will write a custom essay sample on Functionalists View of Education or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page Therefore, everyone has a fair opportunity. Durkheim is a sociologist who compared schools to a miniature society. He believed that social solidarity, social order and meritocracy are learned through education to make people function right through society. Social solidarity happens when the children are made to work in a team or because they wear uniforms. If helps us feel like we belong in the community. However, it also makes people feel less of an individual and more of a group and responsibility is then taken away from them as they feel there are a number of people responsible for wrong doing. The second is social order. There is a hierarchy in schools which shows us some people are more important. Durkheim suggested that schools area small society. The final point is meritocracy. Schools provide us with a chance to learn the skills we need to earn a desirable job. They pass on the ideas of division of labour and such things. This is when role allocation takes place. It sorts out people to the jobs they are best suited. Another functionalist is Parsons. He saw schools as the main way to set norms and values through society. He sees that school and the things we learn will apply to society. It also helps us to become ready for our future in a wider society. He explains how meritocracy takes place. Children who work hard get the best jobs and are rewarded for this. The other children are then encouraged to work harder. Therefore, schools are competitive. However, Parsons was criticised because he didn’t conduct any practical research. Therefore, his theories cannot be tested. Also, he doesn’t take into account the negative things in society such as racism. The final sociologists with a functionalist view that I will cover are Davis and Moore. They believe that the education system is unequal but because society is full of inequalities. They believe that because inequalities exist, it is for the good of society. However, this is not the case. An example of this is that white and black people are treated unequal and this is not good for society. By people seeing a person of different colour skin to them, they may act racist and this is now illegal. Further criticisms are that functionalists fail to explain how or why society changes. Functionalists base there theories on a society that doesn’t change. However, this is not the case. Also, people in society don’t necessarily share the same values in life. Social groups from the same society have different values. Functionalists argue that education passes on the norms of society to create value consensus, however it may be difficult to create value consensus because various social groups will have a different value. Marxist believe that middle-class children are most likely to achieve higher grades and therefore achieve jobs which are seen as ‘middle-class’ jobs. Middle class people have the money and lives which are likely to carry them on through higher education and achieve the skills needed for better paying jobs. This view contradicts the functionalists view but it is great view with evidence through everyday life. Therefore, this is a criticism.

Nationalism and Liberalism of the French Revolution Essay Sample free essay sample

In 1948 the people of Europe grew weary of the corruptness and economic jobs within their authoritiess. France was the first to move and shortly the remainder of Europe followed. Metternich one time said that â€Å"When France sneezes the remainder of Europe gimmicks cold† . Austria was another state that was non pleased with their authorities and position of societal categories. The drive force behind the revolutions in Europe was the political orientations of patriotism and liberalism. Patriotism is the pride in one’s ain national group based on civilization linguistic communication and history. and frequently led to the desire for an independent political province ( notes / McKay 691 ) . Liberalism is the political orientation of equality and autonomy. Liberals besides sought after â€Å"equality before the jurisprudence every bit good as single freedoms such as freedom of the imperativeness. freedom of address. freedom of assembly. and freedom of arbitrary apprehen sion ( McKay 691 ) . France and Austria’s premature revolutions hurting for political reform. We will write a custom essay sample on Nationalism and Liberalism of the French Revolution Essay Sample or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page fueled by patriotism and liberalism. ended every bit rapidly as they began. The revolutionists of France and Austria both wanted the same three things ; a constitutional authorities. independency and fusion of national groups. and an terminal to serfdom ( notes ) . Liberals were unhappy in Austria because the Austrian authorities was reactionist and started interrupting up broad establishments as they were formed. Liberals were non pleased by this because. since the industrial revolution people started believing for themselves. The people of Austria did non desire their authoritarian authorities to maintain doing corrupt Torahs that did non assist the state as a whole. Liberals in France and Austria wanted a fundamental law naming for a new authorities because most of the citizens could non vote. The jurisprudence in France stated that in order for you to vote you must have land. The bulk of the in-between on the job category rented flats which shut them out from all authorities determinations and elections. To an extent Patriotism was a factor in both revol utions but more so in the Austrian revolution. When the Hungarian radical leaders tried to unite all of the states that made up the land of Hungary the minority groups. the Croats. Serbs. and Romanians. thought that was unbearable ( McKay 709 ) . Each group felt that it should be its ain district to regulate its people the manner they want. In world these groups of minority’s thought of patriotism. more or less individual handedly disbanded the Austrian revolution. The people of France and Austria wanted political alteration. In France under Louis Philippe’s â€Å"bourgeois monarchy† there was a great trade of corruptness and statute law straight for Philippe’s involvements. When Louis Philippe refused to reform the elections and when he forbid the great feast to take topographic point. workers and pupils barricaded the streets demanding a new authorities ( McKay 707 ) . In response Philippe ordered the National Guard to take a base. but the National Guard broke ranks and joined in the rebellion ( McKay 707 ) . After a successful putsch d’etat a 10 adult male commission drafted France’s new fundamental law doing France a democratic democracy. The intent of this is so that all male citizens could take part and hold a say in authorities. This made giving the right to vote to all work forces possible. While the revolution in France was looking positive. Hungary besides decided to follow suit and demand political alteration. Magyars demanded â€Å"national liberty. full civil autonomies. and cosmopolitan suffrage† ( McKay 709 ) . When the monarchy did non answer a full graduated table rebellion broke out. Middle category workers and pupils decided to arise by constructing roadblocks in the streets. Under great force per unit area Ferdinand gave in to the revolutionary’s demands by assuring â€Å"reforms and a broad constitution† ( McKay 709 ) . These political alterations were short lived though. Difference in political positions on how the new authoritiess should be run was the start of the unraveling for both France and Austria. In France there was a difference in positions between the two alliances. the moderate broad republicans and the extremist Republicans ( McKay 707 ) . The extremist Republicans were committed to some kind of societal authorities plan that would assist the hapless out of their wretchedness and desperation. On the other manus there were the broad Republicans that opposed any kind of societal plans. Due to increasing unemployment Louis Blanc proposed a government-sponsored workshop to be established to assist help the unemployment job. The workshops were put into consequence and even though no 1 liked these workshops they did assist the employment crisis. On June 22nd the national workshops were liquidated which caused a major struggle to interrupt out ( McKay 707 ) . This clip the probationary author ities had the ground forces on their side and ended the contending fleetly. â€Å"In topographic point of a generous democratic democracy. the Component Assembly completed a fundamental law having a strong executive† ( McKay 707 ) which was precisely what the revolutionists did non desire in the first topographic point ; which efficaciously ended the Gallic revolution. The Austrian revolution that started in Hungary was weakened because of â€Å"conflicting national aspirations† ( McKay 709 ) . As stated before the fundamental law that was pushed through by the Hungarian radical leaders. was non appealing to the minority groups of Hungary. The original monarchy used this struggle to allow the two sides eat each other so that Archduchess Sophia could recover the original monarchy’s power ( McKay 709 ) . A breakthrough conflict was won on June 17th when an ground forces barraged Prague and killed 1000s of working category revolutionists. The old monarchy got the minority nationalities of Hungary to turn on the radical authorities and get rid of it ( McKay 712 ) . Once the radical authorities was wiped out Archduchess Sophia’s boy was crowned Emperor of Austria. â€Å"Thus the finding of the Austrian nobility and the trueness of its ground forces were the concluding ingredients in the victory of reaction and licking of revolution † ( McKay 712 ) .

Human Relations Approach free essay sample

The human relations (HR) approach identifies that the workforce may not all be interested in money as a main motivator but appreciation and job satisfaction is just as if not more important than financial. As highlighted in Herzberg’s research the salary would merely be a â€Å"launch pad† for the motivation of the employee, with recognition and achievement being a main factor for motivation. The HR approach also supports that idea that employee and employer relationships should be formal as well as informal. Under the scientific and classical approaches to management the employees will very much feel like cattle in the sense that all the managers would be concerned with is profitability and productivity. The workers would be left unappreciated, depressed and probably bored with their jobs. Therefore through the failure of the classical approach the HR approach came about. Elton Mayo was an influential person in the development of the HR approach. We will write a custom essay sample on Human Relations Approach or any similar topic specifically for you Do Not WasteYour Time HIRE WRITER Only 13.90 / page He used the Hawthorne Plant of the Western Electric Company (1924-32) as a basis to test his theories. These experiments were dubbed the Hawthorne Studies. It consisted of four main stages:- ? The illumination experiments ?The relay assembly experiments ?The interviewing programme ?The bank wiring observation room The illumination experiments focused on the effect of different intensity of lighting on the productivity. These experiments were however inconclusive, as the experimental groups production varied with no relation to the level of lighting. This prompted an investigation into the work force rather than the environment. The relay assembly experiments focused on this, in this experiment they took 6 workers and put them in a similar work environment. Hours of work were changed, rest periods were introduced as were refreshments. A friendly workplace was created and Productivity drastically increased. The next phase of his work was an interview stage where employees were interviewed about their personal problems and issues they had in an open atmosphere. All the interviews were kept confidential. It could be said that this stage developed modern day HR approach. It became clear that the relationship between worker and employer was important. The information gained in these interviews was used to improve working conditions and supervision. The final experiment was the bank wiring observation room. Groups of 14 men were observed and it was found that they formed their own informal organisations. Also natural leaders emerged. These organisations developed standards of work, and the pressure on individuals from the groups was more motivational than financial incentives.

2 Easy Examples of the Law of Conservation of Mass

2 Easy Examples of the Law of Conservation of Mass SAT / ACT Prep Online Guides and Tips Chemistry is an important subject that you’ll definitely need to know if you’re planning to pursue a chemistry or other science major in college. One thing you should be familiar with is the law of conservation of mass.What is it? And how is it used in chemistry? Keep reading to learn what the law of conservation of mass is and how it came to be. We will also give you some law of conservation of mass examples to help you understand the concept better. What Is the Law of Conservation of Mass? First off, exactly what is the law of conservation of mass? This law states that in a closed system, matter can neither be created nor destroyed- it can only change form. Put differently, the amount, or mass, of matter in an isolated system will always be constant regardless of any chemical reactions or physical changes that take place. (Note that an isolated or closed system is one that does not interact with its environment.) This law is important in chemistry, particularly when combining different materials and testing the reactions between them. In chemistry, the law of conservation of mass states thatthe mass of the products (the chemical substances created by a chemical reaction) will always equal the mass of the reactants (the substances that make the chemical reaction). Think of it as being similar to balancing an algebraic equation. Both sides around an equal sign might look different (for example, 6a + 2b = 20), but they still represent the same total quantity. This is similar to how the mass must be constant for all matter in a closed system- even if that matter changes form! But how does the law of conservation of mass work? When a substance undergoes a chemical reaction, you might assume that some or even all of the matter present is disappearing, but, in actuality, it's simply changing form. Think about when a liquid turns into a gas. You might think that the matter (in this case, the liquid) has simply vanished. But if you were to actually measure the gas, you'd find that the initial mass of the liquid hasn’t actually changed.What this means is that the substance, which is now a gas, still has the same mass it had when it was a liquid (yes- gas has mass, too!). What Is the History Behind the Law of Conservation of Mass? Though many people, including the ancient Greeks, laid the scientific groundwork necessary for the discovery of the law of conservation of mass, it is French chemist Antoine Lavoisier (1743-1794) who is most often credited as its discoverer. This is also why the law is occasionally called Lavoisier’slaw. Lavoisier lookin' proud of his discovery. In the late 1700s, Lavoisier proved through experimentation that the total mass does not change in a chemical reaction, leading him to declare thatmatter is always conserved in a chemical reaction. Lavoisier’s experiments marked the first time someone clearly tested this idea of the conservation of matter by measuring the masses of materials both before and after they underwent a chemical reaction. Ultimately, the discovery of the law of conservation of mass was immensely significant to the field of chemistry because it proved that matter wasn’t simply disappearing (as it appeared to be) but was rather changing form into another substance of equal mass. What Are Some Law of Conservation of Mass Examples? Law of conservation of mass examples are useful for visualizing and understanding this crucial scientific concept. Here are two examples to help illustrate how this law works. Example 1: The Bonfire/Campfire One common example you’ll come across is the image of a bonfire or campfire. Picture this: you’ve gathered some sticks with friends and lit them with a match. After a couple of toasted marshmallows and campfire songs, you realize that the bonfire, or campfire, you've built has completely burned down. All you’re left with is a small pile of ashes and some smoke. Your initial instinct might be to assume that some of the campfire's original mass from the sticks has somehow vanished. But it actually hasn’t- it’s simply transformed! In this scenario, as the sticks burned, they combined with oxygen in the air to turn into not just ash but also carbon dioxide and water vapor. As a result, If we measured the total mass of the wooden sticks and the oxygen before setting the sticks on fire, we'd discover that this mass is equal to the mass of the ashes, carbon dioxide, and water vapor combined. Example 2: The Burning Candle A similar law of conservation of mass example is the image of a burning candle. For this example, picture a regular candle, with wax and a wick. Once the candle completely burns down, though, you can see that there is definitely far less wax than there was before you lit it. This means that some of the wax (not all of it, as you’ve likely noticed with candles you’ve lit in real life!) has been transformed into gases- namely,water vapor and carbon dioxide. As the previous example with the bonfire has shown, no matter (and therefore no mass) is lost through the process of burning. Recap: What Is the Law of Conservation of Mass? The law of conservation of mass is a scientific law popularized and systematized by the 18th-century French chemist Antoine Lavoisier. According to the law,in an isolated system, matter cannot be created or destroyed- only changed.This means that the total mass of all substances before a chemical reaction will equal the total mass of all substances after a chemical reaction. Simply put, matter (and thus mass) is always conserved, even if a substance changes chemical or physical form. Knowing this scientific law is important for the study of chemistry, so if you plan to get into this field, you'll definitely want to understand what the law of conservation of mass is all about! What’s Next? Are there other science topics you want to review? Then you're in luck! Our guides will teach you loads of useful topics, fromhow to convert Celsius to Fahrenheit, to what the density of water is, to how to balance chemical equations. Need help identifying stylistic techniques in a book you're reading for English class? Let our comprehensive list of the most important literary deviceslend you a hand!

Natural Disaster and Economic Growth Essay Example | Topics and Well Written Essays - 1250 words

Natural Disaster and Economic Growth - Essay Example This essay provides an comprehensive analysis of the economic impact of earthquakes on the performance of the country`s economy, both in the long and in the short run. Natural disasters are detrimental to the economic growth of the countries that face the disaster. The extent and severity of the effect of natural disasters vary across countries, but, the basic impact is not heterogeneous. The great Hanshin-Awaji earthquake hit Japan and it had brought tremendous damage to the country in terms of economic growth of the economy and the social structure. The city of Kobe was the worst sufferer in this disaster. Japan was already a developed nation when the disaster had stricken the country. Research by scholars acknowledges that the disaster had caused â€Å"devastating damage to the economic landscape of southern-central Japan† But, at the same time the results of investigation show that the earthquake made people realize the fact that capital formation is an important element of economic growth in the country. In the long run, level of well being of the survivors of the disaster depends on the rate at which capital is accumulated in the economy. Research results show that the impact of the disaster fades with time and the rate of development of the economy plays a major role in the standard of living of its people Although natural disasters are occurring with increasing frequency and are creating potentially devastating impact on the economies that face it, the economic cause of the disaster has not yet been accurately deciphered. ... Victims show the tendency to adapt with the new circumstances with the passage of time. A subsequent research shows the result of investigation into â€Å"the extent to which the earthquake enhanced the investment in social capital through participation in community activity† (Yamamura, 2013, p. 1). After facing the huge loss to life and property as a result of the earthquake, the people of Japan expressed greater consciousness regarding the importance of social capital. Comparing the data collected between the years 1991 and 1996, it has been found that people were more inclined to make investment in social capital in 1996 than they were in 1991 (Skidmore and Toya, 2002). This significantly increased the rate of investment in social capital by the residents of Kobe. However, rate of investment by the people living in the cities near Kobe did not show any noteworthy change. From this phenomenon the author has inferred that the impact of the disaster decreases with distance; th e effect of the disaster is lesser in the minds of the people that stay far away from the origin of disaster (Yamamura, 2010). Although natural disasters are occurring with increasing frequency and are creating potentially devastating impact on the economies that face it, the economic cause of the disaster has not yet been accurately deciphered. There have been several studies on the medium and long term impact of the disasters on the prospects of development of the countries. According to the works by Cavallo, Powell and Becerra (2010) long term effects of natural disasters from the economic point of view are not understood well. In general, literature existing in this sphere of research shows lack of theory and empirical evaluation of the mechanisms that

You must submit an essay describing an ethical dilemma you have faced

You must submit an describing an ethical dilemma you have faced and how you resolved it - Essay Example In the early period of my career, I worked in one of the accounting firms. Being new in the profession, I worked as a subordinate employee, though with significant roles in the firm. However, my ethical dilemma arose when one of the senior managers in our department asked to me deliberately make a false recording. I was to alter the dates of some important transactions in the organization. Immediately the senior manager stated the request, I declined initially. The argument of my senior manager was that if I altered the dates, this would be of great benefit to the firm. The profits of the firm would increase, as the transaction will be identified under a different calendar year, and that would be beneficial to the company. I was responsible recording transactions in different financial years. For this reason, the senior manager had no other person to approach except me. In order to get me to accept this idea and perform as per his wish, the senior manager promised to give me a bonus. He also promised that upon acting on his demands, I would be considered for recognition in future performance review in the firm. Nonetheless, like any other employee that wishes to succeed in their career, I did not make a decision immediately after the senior manager had mentioned all the privileges that I would be entitled to. This incident thus is an ethical dilemma, since as a subordinate employee, questions of â€Å"should I† or should I not† lingered on my mind. I knew altering the records was ethically wrong. However, thinking of the benefits that I would be entitled to made me to hesitate on making a decision. Since I am a supporter of ethics in organizations, I decided to take considerable time, and ensure that I came up with the right decision that would not exhibit any selfishness in me, anger the senior manager, or which would not result in a tainted image for me as an individual employee, and for the organization. This was

Campbell Soup Essay Example for Free

Campbell Soup Essay Campbell Soup Company (CSC) was a diversified food processor known for its strong brands and product quality. One of its products is produce ready-to-serve soups for customer who is not able to make soup. Formerly, Campbells products spread all over 3 segments of condensed soups, ready-to-serve soups and dry soup, and it is considering to expand its product to microwavable soups to make customer more convenient for preparing soup without container. The following figure showed the foundation of CSC. CSC used its engineering support and diversified production line to support customers with convenient, good taste and quality food. CSC is a decentralized company; its strategy is to diversify its business to product several products, and expand its marketing share. Something behind the diversified production line, used to support its operating system, is its CIRT and CCID department. Those are charged with process RD, product development, packaging and engineering systems. CSC used production line for its operating system. The advantage of it is to reduce WIP among the process, and it required high quality and stable operating system to avoid the unexpected shut down. Symptom CSC is developing a new product of microwavable soup, which is assigned to Plastigon line in the early 1980s. However, the Plastigon line is taking so long for result. Because of this, Elsner was assigned to resolve Plastigons technical problems and make Campbells engineering more effective and efficient. Problem 1.Conflict between organization and development process From the current CSCs product development process of task forces, we know CSC would appoint the appropriate engineer from any department in charge of the new process. The advantage of this way is more flexible and superior because everyone has the suitable skill in charge of the new process.  However, there is no clear assignment of who is responsible to run this project team. That caused nobody took it to be their obligation, they actually wanted less and less to be involved. Their position was, Wait until its a proven process and then CSC will be ready to accept the line for their operation. Otherwise, coordination between engineers form various groups was difficult because often the engineers were not at the plant at the same time. Even when some were present, they had their own tests to run and not usually were not interested in running the line as a whole. This situation caused the other problem that the problem of the other part of production line would occur when the problem of one part was resolved due to incoordination among all parts. 2.Production process As we know, the production process which CSC used is production line, which can be described the products are manufacturing as a continuous flow. Production line requires standard and stable process with good quality to avoid occurring shut-down. If one part was shut-down, that would influence other parts. Suggestion Aiming at conflict between organization and development process, the problem is due to the structure of organization is different from development process. The organization is decentralized, but RD is centralized. However, because different product has different feature, RD should have different knowledge and experiment in charge in different product. For example, microwavable soup can be used by microwave, so it requires different material, and RD has to consider the different point and set up a suitable process for it. At this point, I suggest CSC decentralizes its RD into different product. When CSC decides to produce a new product, they should take appropriate engineers from RD, and make a subgroup for the new product. After that, set up a pilot for this group who is responsible for this production line, and integrate whole engineers. Engineers have different expertise in their area, so how to coordinate them to devote their  knowledge to this production line is also a crucial point. The duty of the pilot is to lead this group and responsible for proving this process. Using this way, the subgroup has to transfer to the new plant, which would reduce the transit times by using centralization. Furthermore, engineers would run their part at the same time, which would improve the efficiency of the process. Second, CSC used production line for its process; however, it would make whole process shut-down if any part was in trouble. Otherwise, the most parts of this process are made by human resources. The efficiency of each person decides the efficiency of whole process. If workers have different efficiency, that would cause the process not continuous. It means idol time would occur between each part. To resolve this problem, I suggest CSC change its process from production line to job-shop. Although job-shop would produce more WIP, the influence would be reduced by using this way, and the process would not entirely shut down. That makes the whole process produce smoothly, and standard. Furthermore, aiming at the point of the most parts of this process is made by human resources. I suggest CSC should prepare Quality System Document and on-the-job training program with handbook which can help workers to familiar with whole process and operation soon. If training program and handbook are more detailed, workers are easy to find answers from them for their questions without the instruction of supervisor, and help them become skillful operators.

Definition and Features of Monopoly and Competition

Definition and Features of Monopoly and Competition Definition of Monopoly Monopoly is a well defined market structure where there is only one seller who controls the entire market supply, as there are no close substitutes for his product and there are no barriers to the entry of rival producers. This sole seller in the market is called â€Å"monopolist†. The term monopolist is derived from the Greek word â€Å"mono†, meaning â€Å"single†, and â€Å"polist† meaning seller. Thus the monopolist may be defined as the sole seller of a product which has no close substitutes. The monopolist is faced by a large number of competing buyers for his product. Evidently monopoly is the antithesis of competition on. In a monopoly market, the producer, being the sole seller, has no direct competitors in either the popular or technical sense. Thus, the monopoly market model is the opposite extreme of competition. Features of Monopoly The features of a monopoly are: The monopolist is the sole producer in the market. Thus, under monopoly, firm and industry are identical. There are no closely competitive substitutes for the product. So the buyers have no alternative or choice. They have either to buy the product or go without it. Monopoly is a complete negation of competition. A monopolist is a price maker and not a price taker. In fact his price fixing power is absolute. He is in a position to fix the price for the product, as he likes. He can vary the price from buyer to buyer. Thus in a competitive industry, there is a single ruling price, while in a monopoly, there may be differentials. A monopoly firm itself being the industry, it faces a downward-sloping demand curve for its product. That means it cannot sell more output unless the price is lowered. A pure monopolist has no immediate rivals due to certain barriers to entry in the field. There are legal, technological, economic or natural obstacles which may block the entry of new firms. Since a monopolist has a complete control over the market supply in the absence of a close or remote substitute for his product, he can fix the price as well as quantity of be sold in the market. Abuses of Monopoly Though a monopolist has complete freedom in determining his own price, there are some limits to his power. These are listed below: The demand curve of a monopolist slopes downwards. This is shown as demand curve DD of the monopolist in Figure. On such a curve, a monopolist cannot choose both Price and Output to be sold. He has to determine one of these quantities. If he chooses higher price P1 he has to be satisfied with smaller sales of quantity Q1. If he prefers larger output Q2 he will have to charge lower price P2. The second constraint on monopoly power arises out of the income and willingness of consumers. If the monopolist attempts to charge a price as high as Pn his sales fall to zero. So even though a monopolist has complete freedom to charge any high price this freedom is restricted by the consumer’s ability to purchase goods. Finally, monopoly power also depends upon elasticity of the demand curve. If the demand curve is rigid or less elastic the monopolist has a greater degree of control. As the demand curve becomes more flexible or flatter the monopolist’s control starts declining. This can be explained with the help of Figure. In the figure there are two demand curves. DD1 is rigid or less flexible showing greater monopoly control. DD2 is flatter or more flexible and depicts a lower degree of monopoly control. On rigid demand curve DD1 if the monopolist increases the price from P to P1 the fall in the quantity sold is as small as QQ1. On the flatter demand curve DD2 with the same rise in price, a fall in the quantity sold is as large as NN1. In case of a flexible demand curve there is a danger that even at a higher price, the total revenue of a monopolist may be smaller. This has been further explained in the table below: PRICE RIGID DEMAND D1 TOTAL REVENUE TR1 FLEXIBLE DEMAND D2 TOTAL REVENUE TR2 2 6 12 20 40 4 5 20 8 32 6 4 24 5 30 A monopolist attempts to raise his price from 2 to 4 to 6. As a result of this quantity demanded goes on falling. Yet in the case of Rigid Demand D1, with a fall in the demand from 6 to 5 to 4 Total Revenue TR1 increases from 12 to 20 to 24. With the Flexible Demand condition D2 the quantity demanded falls sharply from 20 to 8 to 5 causing Total Revenue TR2 to fall from 40 to 32 to 30. Hence the slope or the degree of flexibility of the demand curve governs the degree of monopoly power Monopoly market is restrictive and hence considered as an evil form of market. Monopoly is also a source of wastage. It underutilizes productive capacity and reduces Consumer’s Surplus. Underutilization of capacity may cause some workers to remain unemployed. These and other shortcomings can be analyzed and explained with the help of a comparative diagram. We find both competitive and monopoly equilibrium positions marketed by point e1 and e2 respectively. A competitive firm produces output Q1 and sells at price P1. A monopolist produces smaller output Q2 (Q2P1). Competition allows only normal profits to a firm as part of the average cost of production. A monopolist earns extra monopoly profits of the size CSRP2. Under competition output is produced at point e1 which is the lowest point on the average cost line. Therefore competition makes fuller utilization of the productive capacity. Under monopoly output is produced at point S which is on the falling phase of AC. This shows underutilization of the productive capacity. Finally, the size of the Consumer’s Surplus under competition is as large as De1P1 while that under monopoly is only DRP2. Hence under monopoly there is higher price, lower output, underutilization of productive capacity or wastage of resources and reduction in Consumer’s Surplus. Differences between Monopoly,  Equilibrium Competitive Equilibrium There are typical differences between the two types of market models their equilibrium positions. A comparative account of their differences is presented below: The demand curve of a competitive firm for its product is perfectly elastic. It is a horizontal straight line. It implies that the firm can sell any level of out put at the ruling market price. While the demand curve of the monopolistic for his product is relatively inelastic, it is a downward sloping curve. It suggests that the monopolist can sell more output only by lowering the price. To a competitive firm, price is given in the market. So at this price, average and marginal revenue will be the same. Hence, AR MR curves coincide and are represented through the demand curve which is a horizontal straight line. In the case of a monopoly, the downward sloping demand curve represents the AR curve. The MR curve also slopes downwards but it lies below the AR curve. If it is linear, then it lies half the distance between the price-axis and the demand curve. Under both perfect competition and monopoly, the equilibrium output is set at the point of equality between MC and MA. The competitive firm attains equilibrium only when the MC curve intersects the MR curve below. Thus, it is essential that MC must be rising at and near the equilibrium output. In fact, the falling cost curves caused by increasing returns to scale are incompatible with competitive equilibrium output, for the firm’s MR curve being horizontal, the falling MC curve can never lead to a competitive equilibrium position because as the firm will be inclined to expand its size until it becomes so large that its AR and MR curves ultimately begin to fall in order to cut the continuously falling MC curve. This means that the firm will become so large that competition will become imperfect and the individual firm would be in a position to influence the price of its product by altering its own output. In short, perfect competition will cease to exist when a firm increases i ts output to a very large extent in order to attain equilibrium under falling cost conditions. It may, therefore, be concluded that increasing returns to scale or a continuously downward sloping MC curve perfect competition are incompatible. It follows, thus, that a major difference between competitive equilibrium monopoly equilibrium is that while in the case of the former, the MC curve of the firm must be rising at or near the equilibrium level of output, in the case of the latter, this is not essential. A monopoly firm can attain equilibrium under any state of returns to scale or cost conditions, whether constant, rising or falling. The fundamental condition of monopoly equilibrium that must be satisfied is: MC=MR, and the MC curve must intersect the MR curve from below (yet it need not necessarily be rising). Again, when we compare the equilibrium conditions of the two models, we find that the fundamental rule of profit maximization is the same, i.e., equating MC with MR, the characteristic difference lies with respect to price as average revenue and MC. Under perfect competition, price=AR=MR; thus, at equilibrium output, MC=price. In monopoly, on the other hand MRMC. In a perfect normal equilibrium condition of a firm under competition in the long run only, normal profit is realized. In the case of a monopoly, excess monopoly profit can be earned even in the long-run. In fact, the positive difference between price and MC in a monopoly gives excess profit. In the long run, when the competitive firm gets only normal profit, it operates at the minimum point of the LAC curve. Hence the competitive firm tends to be of optimum size. A monopoly firm, on the other hand, attains equilibrium at the falling path of the AC curve, which means it doesn’t utilize its plant capacity to the full extent. The â€Å"excess capacity† in a monopoly firm thus causes it to be of less than optimum size. Usually, the monopoly price tends to be higher while the monopoly output smaller than that under perfect competition. A direct comparison of price and output under monopoly and competition is however difficult because a competitive firm is just a part of the industry as a whole, while a monopoly firm is an industry itself. MONOPOLY EQULIBRIUM UNDER DIFFERENT COST CONDITIONS Firms under all market condition achieve equilibrium at a point where MC=MR and MC is increasing or MC>MR if an additional unit is produced. Under Perfect competition this is possible only if the firm is operating with increasing cost i.e. marginal cost curve is sloping upward. Equilibrium cannot be determined if the marginal cost is decreasing or constant. Equilibrium is possible only in fig A where both necessary and sufficient conditions are fulfilled, whereas in B only the necessary condition is fulfilled and in C neither necessary nor sufficient conditions are satisfied. Unlike perfect competition, equilibrium of a monopoly is possible under increasing constant and decreasing cost as shown in Figure FIGURE shows equilibrium of a monopoly firm with increasing cost. The firms AC and MC curves are sloping upward. MC cuts MR at E. Here MC=MR and for any additional production MC>MR. Therefore firm A reaches equilibrium at point E. TR=OQ1 TP. TC=OQ1SN. Pie=NSTP Figure B, the firm reaches equilibrium at point E1 under constant cost. At point E1 MC=MR and thereafter MC>MR therefore the firm stops its production. At E1. TR=OQ2T1P1. TC=OQ2E1N1. Therefore Pie=N2S2T2P2 Figure C explains the equilibrium under decreasing cost. Equilibrium output is determined at point E2. Where MC=MR and MC>MR for any additional output. TR=OQ3T2P2. TC=OQ3S2N2 Therefore Pie=N2S2T2P2 The firm however will not be able to decide its output if under decreasing cost its marginal cost is always below the MR curve as shown in the figure. Fig shows the indetermination of Equilibrium under decreasing cost. Here the MC is all the times below MR hence it is not possible to determine the Equilibrium output. However the case shown in the above diagram may not be practical as the marginal cost cannot continuously decline and become zero. CONTROL OF MONOPOLY Evaluating the economic effects of pure monopoly or partial monopoly form the standpoint of society as a whole, on income distribution, price, output, resource allocation, technological advancement, distribution of economic power, it has been commonly observed that there are more evils aspects than benefits in a monopolistic industry as compared to a competitive industry. THE FOLLOWING POINTS MAY BE ENLISTED IN THIS CONTEXT: The monopoly price is generally higher than the competitive price. Evidently, the consumer is exploited under a monopoly. Output under monopoly is restricted with a view to earning the maximum economic profits. Thus, there is inefficient allocation of resources in a monopolistic industry. It entails waste of excess capacity. Only in a competitive industry there can be optimum utilization of existing plant capacity .In short, under a monopoly a higher price is charged, a smaller output is produced the system of allocation of resources is inferior to that under perfect competition. Usually, excess profit is reaped by a monopoly firm even in the long run. A purely competitive firm, on the other hand reaps just a normal profit in the long run. By virtue of their control over market supply, monopolists can export high prices to make substantial economic profits .Excessive price charged by the monopolists is regarded as a â€Å"PRIVATE TAX† on consumers. On account of high profiteering by the monopolists, society’s income distribution tends to be unequal unjust .The owners of monopoly business tend to become richer at the cost of the consumers. Big monopoly houses may acquire concentration of economic power ion their hands which also endangers political democracy in the country. A monopolist is supposed to be very conservative in the matter of innovation technological advancement .Since there is no threat of competition from rivals in a monopoly market, the firm has no impulse to develop new products or introduce new techniques in production. The monopolist is satisfied with the status quo. In fact sometimes monopolists may buy up new scientific inventions patents destroy them so to avoid rivalry. They do so in order to save loss arising from the sudden obsolescence of existing plant machinery. This tactic obviously obstructs technical progress of the country. Monopoly monopolistic competition tend to aggravate the problem of unemployment due to under allocation of resources. The actual production frontier of the country is kept unduly much below its potential level. This results in a low pace of economic growth in creating poverty in the midst of plenty Monopoly firm quite often resort to unfair practices like price discrimination or cut throat competition infringement of trade marks of rivals .etc with a view to eliminating or killing potential rivals in the market. Many big monopoly houses have tended to spread political economic corruption. It has been alleged that some political parties even govt. officials in India always have a soft corner for certain big business houses. METHODS OF CONTROL They are as follows: Restriction on entry of new firms Restriction on output Monopolists hold on price determination MEASURES OF CONTROL They are as follows: Legislative measures Promotion of competition Consumers resistance Publicity drive Control of price output Fiscal measures Nationalization Co-operative movement Misconceptions about Monopoly Pricing Profits It is commonly alleged that a monopolist can charge a very high price and earn high profits because he has the control over market supply and is a price-maker. This is really not so. A monopolist cannot determine price on the basis of his supply alone. He has to consider the demand aspect as well. In fact, the monopoly price is determined by the relative strength of the forces of demand and supply. Again, while determining the equilibrium price and output, the monopolist is interested in maximum sale because he wants to maximise total profits and not unit profits. So if the demand is slack, he will have to set a low price corresponding to profit maximising condition : MC = MR. Again, it is also erroneous p take it for granted that the monopolists price is always higher than the competitive price. It, in fact, depends on various considerations. If the demand is highly inelastic, while the supply is under conditions of increasing costs, ben the monopolist will restrict output in order to produce at a lower cost anchearn a higher profit. Under these circumstances, obviously, the monopoly price will be very high compared to the competitive price. For example, private monopoly is socially harmful in respect of production and sale of essential agricultural commodities like food-grains for which the demand is highly inelastic while the supply is under increasing costs on account of the law of diminishing returns operating on land. If, on the other hand, the demand is highly inelastic, but the supply is under increasing returns or decreasing costs condition, the monopoly price would tend to be nearer the competitive price. In such cases, monopoly can be socially tolerated. For instance, in producing comforts and luxury items, if a private monopolist invests huge capital, thereby enjoying the economies of scale so that he may supply goods at a low price at a competitive rate, then, such monopoly can be tolerated. Again, when there is a very limited market for a product, a monopolist can supply it at a lower price on account of its low cost of production due to large-scale economies than what is feasible in a competitive market by a large number of firms producing the goods on a small-scale. The competitive market price in such a case will tend to be high because though P AC, under competition, the AC itself tends to be high due to lack of economies of scale and the small-scale of production adopted by each firm . If, however, there is a monopoly which has to cater to the entire market, it would resort to a large-scale production. Hence, the output will be produced at a much lower cost, so even if the monopolist sets a higher price than AC for the sake of high profit, it may relatively turn out to be lower than that of the competitive firm. Similarly, it is also incorrect to say that the monopolist can always earn abnormally high monopoly profit due to his advantageous position in the market. In many cases, demand and cost situation may not be very favourable to the monopolist, so that he cannot make profits. In the long run, the monopolist may be under the threat of new entry in his line of production, so that he may resort to price limit which gives him a lower profit but not a high maximum profit. Potential competition thus serves as a significant constraint on the behaviour of the monopolist. Again, in some cases, the demand situation may be such that the demand curve or the average revenue curve in the long run may be just tangent to the LAC curve. In this case, the monopolist would earn only a normal profit (see Fig. to understand the situation). In Fig., the monopolist decides an equilibrium output OM, and charges PM price. Since the AR curve is tangent to the LAC curve at point P, Price = Average Revenue = Average Cost. Hence, the monopolist simply earns a normal profit. The only difference between such normal-profit monopoly equilibrium and competitive equilibrium is that the monopolist is producing at less than optimum size, i.e., at a higher average cost, while a competitive firm, earning normal profit, would be producing at a minimum average cost, i.e., it has an optimum size. In other words, under monopoly, even though there is just a normal profit earned, there is unutilised capacity of the plant and resources, while in a competitive firms equilibrium, the normal capacity is fully utilised. Anyway, it can be concluded from the above discussion that the monopolist cannot always earn high monopoly profits. Again, the monopolist in the long run should earn at least normal profits, otherwise he cannot survive. A monopolist finding the cost situation much above the demand consideration in the long run has no alternative but to wind up his business.

Language Usage in Huckleberry Finn

Jims dialogues, we can clearly see that he has troubles with English, he often makes grammatical and spelling errors. From this I concluded that Jim is most probably uneducated, I do think that he's not stupid though because up to this point In the book Mark Twain have showed how Jim uses his logic, for instance when Jim was arguing about Solomon, we can clearly see how he used his logic in criticizing the story. Therefore from the language Mark Twain uses we can understand that Jim Is uneducated but he's not stupid although he book doesn't literally say so.Racism: Mark Twain repeatedly used the word ‘Niger' In the book to describe how In the town where It took place, everyone uses the word ‘Niger' casually, from old ladles to Houck himself uses the word very casually. This shows how at that time, dark skinned people are very discriminated by the white. They are treated as slaves, up to the point where they will sell them in exchange for money. From the words that Mark Tw ain used in describing the society, we can clearly see that slavery and racism both re still an on going thing.If we compare this to today, it is completely different, people are now forbidden to say the word ‘Niger' and dark skinned people are way more respected. Faking Huckleberry Fin's own death: In the chapter in which Huckleberry Finn faked his own death, although Mark Twain didn't exactly tell us what he was going to do, but we were able to conclude that he was up to something. Through the language that the author used to describe this action we can see that he's not stupid, he uses a lot of his logic.

Endosymbiotic Theory Essay

The endosymbiotic theory explains the evolution of the eukaryotic cell and eukaryotic organelles by phagocytocis of small prokaryotic cells. This theory states that some of the organelles in today’s eukaryotic cells were once prokaryotic bacteria. In this theory, the first eukaryotic cell was probably an amoeba-like nucleated (probably DNA in a nucleoid region not an actual nucleus) prokaryotic cell that got nutrients by phagocytosis (engulfing nutrients or other cells) Some of these unicellular amoeba-like organisms engulfed prokaryotic cells that somehow were not digested within the organism. In the process of being engulfed the smaller cells would have been wrapped in membrane from the larger cell, today we see double membranes in mitochondria and chloroplasts.  The symbiotic relationship was beneficial because the host cell would have provided essential nutrients to the engulfed prokaryotic cell in exchange the smaller prokaryotic cell used these nutrients to synthesize ATP molecules, this ATP was used as an energy source by the host cell. The smaller prokaryotic cell was given a safe environment as well as receiving nutrients from the larger host cell. The small prokaryotic cell developed a symbiotic (mutually beneficial) relationship with the host cell. This smaller prokaryotic cell would eventually become mitochondria or chloroplasts. Mitochondria would have been formed when bacteria capable of aerobic respiration were ingested by a much larger cell. Chloroplasts formed when photosynthetic bacteria were ingested. They eventually lost their cell wall and much of their DNA because they were not of benefit within the host cell. Mitochondria and chloroplasts cannot grow outside their host cell in normal conditions because they now depend on the cell for protection and nutrients. The reason we do not see this type of symbiotic relationship today is because conditions are much different now then they were on earth millions of years ago when this symbiotic event first took place. Scientists can support the endosymbiotic hypothesis because the characteristics of energy organelles are so similar to those of prokaryotes. Energy organelles have their own set of genetic information it is not found  enclosed in a nucleus but a circular ring in a nucleoid region just like prokaryotic DNA. Mitochondria and chloroplasts have their own ribosomes this would imply that at one time energy organelles were able be self sufficient. Both organelles have a double membrane, a remnant of ancient endosymbiotic event. Also when a cell divides by mitosis the energy organelles replicate the same way as do prokaryotic bacteria, by binary fission. Mitochondria and chloroplasts are about the same size as prokaryotic cells. The DNA of these energy organelles is different from the DNA found in the cells nucleus. There is some evidence of bacterial DNA in these energy organelles that suggests that long ago they were once prokaryotic cells. Biology, Neil A. Campbell & Jane B. ReeceBenjamin Cummings; 7th Edition, 2006Investigating Biology, Neil A Campbell & Jane B.ReeceBenjamin Cummings; 6th Edition 2007

Free Essays on The Olympic Games

It’s a test of strength. It’s a test of honor. It’s the Olympic Games. The Games are a long played tradition adapted from the early Greek civilization. Athletes come together to compete in athletic events, such as wrestling and javelin, for honor and grace for the country they represent. Today, the Olympic Games are just a little different than in ancient times. Now, athletes do not take as much honor in just competing and for love of the game as they do for winning. Some athletes resort to doping, which is using illegal drugs to increase the strength and capability of oneself. This is an increasing problem among athletes, and eventually will lead to serious health risks. Another difference is that today there are much more events, and anyone from a country can compete, not just free men who speak Greek. Also, in ancient times, the Games were always held at the city Olympia, as now they move to different cities every four years. Even though there are these differences, there is still honor in the Games today. The history of the Olympic Games reaches back very far. The first Games were held in the year 776 B.C. It was a very simple contest with the events just being the sprint. Later on, more events were added, such as discus, javelin, wrestling, and long jump. The Games became very important to the people. They would even stop wars so that they could compete in the Games. Soon, the games became very evolved adding sports such as boxing, pankration, the pentathlon, and chariot races. The first recorded winner was Koroibos (www.aafla.org). The Byzantine emperor Theodosius in 394 A.D soon abolished the Games. When the Games were revived, they were brought back as the modern Olympic Games in 1896. The person responsible for bringing back the Games is the Baron Pierre de Coubertin. Coubertin was involved in sports as a child and he felt the Olympics would promote understanding and friendship among nations (w... Free Essays on The Olympic Games Free Essays on The Olympic Games It’s a test of strength. It’s a test of honor. It’s the Olympic Games. The Games are a long played tradition adapted from the early Greek civilization. Athletes come together to compete in athletic events, such as wrestling and javelin, for honor and grace for the country they represent. Today, the Olympic Games are just a little different than in ancient times. Now, athletes do not take as much honor in just competing and for love of the game as they do for winning. Some athletes resort to doping, which is using illegal drugs to increase the strength and capability of oneself. This is an increasing problem among athletes, and eventually will lead to serious health risks. Another difference is that today there are much more events, and anyone from a country can compete, not just free men who speak Greek. Also, in ancient times, the Games were always held at the city Olympia, as now they move to different cities every four years. Even though there are these differences, there is still honor in the Games today. The history of the Olympic Games reaches back very far. The first Games were held in the year 776 B.C. It was a very simple contest with the events just being the sprint. Later on, more events were added, such as discus, javelin, wrestling, and long jump. The Games became very important to the people. They would even stop wars so that they could compete in the Games. Soon, the games became very evolved adding sports such as boxing, pankration, the pentathlon, and chariot races. The first recorded winner was Koroibos (www.aafla.org). The Byzantine emperor Theodosius in 394 A.D soon abolished the Games. When the Games were revived, they were brought back as the modern Olympic Games in 1896. The person responsible for bringing back the Games is the Baron Pierre de Coubertin. Coubertin was involved in sports as a child and he felt the Olympics would promote understanding and friendship among nations (w...

Lance Armstrong Case Study Essays

Lance Armstrong Case Study Essays Lance Armstrong Case Study Essay Lance Armstrong Case Study Essay There are a plethora of different Issues that have surfaced since the retirement of Lance Armstrong. Although Lance was looked at as one of the most influential and decorated athletes of all-time, things have changed since evidence has been brought up that prove Lance Armstrong is guilty of doping. Many athletes have been found guilty of doping and things alike, but, Lance Armstrong, a cancer survivor was looked to as a role model to many different types of people such as: children, teenagers, athletes, adults, cancer survivors, basically any person who knows who he is. Since these allegations arose back in 2010, he has lost many followers and offended many other cancer survivors, with what the world looks at as cheating. Lance Armstrong Is the spokesperson for his own organization, the Lance Armstrong Foundation (ALFA). The ALFA Is known for their bracelets which over 65 million of these were sold, making his organization very well known and well respected. When Armstrong came out of retirement and returned to professional cycling In 2009, the ALFA revenues increased from $32. 6 million in 2008 to $41. 7 million in 2009 (Maybe Its About the Bike, peg. 2). Also, the Sports Illustrated writer Selene Roberts reported four massive accusations about Armstrong, all of which are plenty enough reason to force the public to look at Armstrong as a disgrace and a cheater. She even referenced the similarities between his and Roger Clemens doping scandals. For a personal perspective, Lance Armstrong has always been considered a hero. He was a man who did not let cancer deny him from getting back on his bike and winning any biking titles. Unfortunately for Mr.. Armstrong, he ruined his image and will probably never be able to regain such a strong relationship with his admirers ever again. There Is no reason why Lance should have allowed himself to compete knowing he was galling an unfair advantage. What Is even more unjust about the situation is the fact that after 60 Minutes aired an interview with his former teammate, Tyler Hamilton. Hamilton, one of Armstrongs former USPS teammates, publicly stated that he had first-hand knowledge that Armstrong had doped in the dead-up to at least three of his Tour De France victories (Maybe Its About the Bike, peg. 2). Its almost disturbing that even after such a valuable source threw Lance under the bus he could still proclaim his innocence. There is no soft spot for anyone who allows themselves to rob hundreds of athletes for what they have also worked day and night for. Most of which, worked hard and kept the illegal substances out of their bodies. It Is my belief that Lance Armstrong was rightfully stripped of his titles, and should never be allowed to compete again. Many supporters might argue that he ad cancer and deserved create a more even playing field for himself. This Is not the case, If Lance Armstrong, one of the greatest athletes of all time, wanted to be remembered forever he should have thought about the consequences before he cantata. For Torture policy, all professional sports are on ten relent track, all tentacles need to be tested, no matter whom they are; nobody should have anything to hide. Sports are a lot more spectacular knowing that all the athletes are 100% natural, and have made it to where they are because of hard work; not a needle.

Gender discrimination in East Asia Essay Example | Topics and Well Written Essays - 1500 words

Gender discrimination in East Asia - Essay Example Burying a newborn child because that is female, limiting the access of women to education, work and health, burying the wife of a person who dies are some common examples of gender discrimination in East Asia. Violence against women leads to robbing the aspiration and self-esteem of women which possess life-long psychological cost. In East Asia, female’s admission in primary school is as lower as 26% than male students. Such statistics are also observed in health sector. The ratio of female to male in population is worsening in areas like Central and North Asia, South Asia and Countries of Pacific Islands. In many East Asian countries, out of every 10 girls, one dies due to limited access to health and out of 50, one woman dies during delivery and pregnancy. Gender discrimination not only brings problems for female population of a country but also affects the social and economic development of a country. There is huge economic and social cost behind the ramifications of gender discrimination. Blocking the access of females to health and education is not only unfavorable for economic growth and social welfare but also becomes obstacle in the path of labor force participation and human capital development. Women’s silence and inability to practice their civil rights deprive them from having social participation and this phenomenon also obstructs economic growth. Thesis Statement This paper postulates that governments of East Asian countries must take step forward to eradicate the employment gender inequalities in all sectors of the economy. Point of Support 1- Huge Social and Economic Cost There is huge economic and social cost behind gender discrimination. Discrimination hinders women’s participation in social and economic activities, reduces productivity and distracts resources. According to a recent survey, higher female participation and increased employment among women increases the output and growth of that region as shown in the mentio ned table. Source: (World Bank, World Development Indicators Washington D.C., 2006) The above table reveals that from 1990 to 2004, the greatest effect has been on Malaysia, Indonesia and India, where the participation of female labor is lowest of all. These estimations reflect the opportunity cost that has been incurred on gender discrimination. The concept of working women is very common in the economy of United States, and the growth of United States is thereby higher than all the other mentioned countries. Lack of participation of women in political, legal, economic, social and other activities hinder the growth of economy. In a country where both male and female population is working, it seems to grow more profoundly than the country where only male population is working. Let us take an example of a family. A family where both parents are working will generate double income, but a family where only father is working, incurring expenditures of the entire family and meeting expen ses from single income, it will be difficult to recover all the expenses. Point of Support 2- Psychological Cost Gender discrimination poses life-long threats to women’s expertise, self-esteem and capabilities. It not only restricts their opportunities but also spoils aspirations of women. It sabotages their mentality of building self-direction and competence. The unnecessary restrictions which are imposed on women make them clinically depressive and produce a state of helplessness. Such factors compel women to contribute into global burden of illness. Another life-long resentment is that of an unwanted pregnancy which is then transferred to the child. In regions where there is not any

MS Project and Team Leadership Assignment Example | Topics and Well Written Essays - 750 words

MS Project and Team Leadership - Assignment Example Identifying and eliminating unnecessary spending is the need of the hour and can take us back on track. Together we need to explore all possible avenues to limit spending and even change the financial strategies if required. As you all know failure to stick to the budget can seriously hinder the project and have negative effects on the organization as well. Usually high performance is linked with increase in productivity and better and speedy results. A high performance team is one in which every member strives to achieve better results, is capable of solving problems faster and readily adapts to change. On the other hand, one poor performer in a team can take the whole team down and lower the productivity (De Dreu & Weingrate, 2003; Shepperd, 1993). It is said that the performance of an employee depends directly on motivation and the attitude of the employee (Akanbi, 2011). Sometimes an otherwise capable team member underperforms because he is uncertain of his roles and responsibilities and does not know what is expected of him (Coutu, 2009). This lack of clarity reflects on the work. In such cases the leader should explain the role clearly and then discuss with the team member what the priorities should be. Leaders can help such team members through consistent feedback. Feedback helps the team members to identify their goals and direction. For instance in case of this project, if the team member is not clear about the overtime policies than the overtime plan he designs will not be acceptable. Lack of motivation is another reason why a team member may underperform (Davidson et al, 2005). In such cases the underperformer can be improved through carefully targeted training. The leader must understand that no two employees can be motivated the same way. Some team members get motivated when treated as an equal. Leaders can motivate such team members by

Graphic Design Industry and the Willingness to Foster Creativity for Dissertation

Graphic Design Industry and the Willingness to Foster Creativity for People with Fine Motor Skills Disability - Dissertation Example In the past, the design discipline belief for the traditional graphic design professionals was aligned to serve only able-bodied students and professionals. Evidently, this was due to the belief that all design starts from traditional drawing skills. The teaching strategies of the past were mostly structured in a way that favored physical exertion from a full bodied person while significantly ignorant on the needs of people with disabilities. However, in the contemporary world, there have been increased efforts and innovation to accommodate the needs of persons with disabilities.(Needs cited from original paper or from writers notes) In this regard, there have been an increased acceptance and adaption to suit the needs of people with disabilities in different sectors such as education, production, athletics and many more. For example, in the world of athletics, persons with disabilities have been able to compete on an equal footing with other full bodied athletes. A perfect example i s the former athletics champion with most medals, Heinz Frei from Sweden. former 200m paralympic champion, Oscar Pistorius, also known as the ‘blade runner’ for his use of prosthetic legs in racing (Edington, & Duffy, 1996). In order for learners to make an impact in the world, it is foremost the prerogative of the educators to teach and guide them in the correct process. In this regard, educators are the foundational block for students affording them the ability to go out and give voice to those who need it. (AIGA & Chap, 2006, p.1) Consequently, it creates a critical issue between education and complementing laws and policies such as the Individuals with Disabilities Education Act.

Individual Final Project Essay Example for Free

Individual Final Project Essay When it comes to the topic of diversity and what is has taught me I really think of a few things. Diversity has really taught me a lot about myself as well as tolerance to others around me. Really there is nowhere in the world today that diversity is not present or has not had some sort of effect on our society as a whole. All in all I think that diversity really just means being different than others in various ways. I think if the United States never had any instances of diversity we would be a pretty boring and simple society. Many of our great minds of today as well as the past where very unique and diverse individuals. Without any type of diversity we would be exactly alike there would be nothing different about each other. The world would be plain and boring as well. I like to think that without any type of diversity the world would be without any type of color or texture as if we were in a 50’s TV show. We are different in race, gender, age, sexuality, religion and a whole lot of other things. There will be certain things that we have in common and some things that we don’t have in common. In order to understand someone I believe you need to get to know them better. You need to understand what makes them happy and what really works their nerves. There are so many cultures out here that we really don’t know anything about. It is good to learn about the different cultures that are out here. By learning from the different cultures we are able to see the things that we do that are in common with our culture and the things that are done differently from us. Some things that we do for fun might be something that they don’t approve of. Nowadays people take certain things for granted while in another culture they enjoy it and not abuse it. There are a lot of different things that I have found out about my race. As I was reading back over some of the chapters I see that â€Å"the marriage of a White person and an African American would have been illegal in 22 other states† back in the 1960’s. (Chapter 1 Racial and Ethnic Groups) That is something that I really did not know and was really shocked to find out as well. I did learn an interesting fact about African Americans however. It was interesting to lear n that not all African Americans were brought over here to the United States as slaves or that they were the only slaves. It is a common mistake made that America had only Black† slaves. There were many Europeans sent here as indentured servants. They had to work off the trip to America and also some were sent here because of debts and had to work them off. Irish Immigrants were also thought of as lower than slaves. The Japanese and Chinese were both used as slaves and many lost their live building our railroad system. You also must remember there were Blacks who owned slaves. One of the largest Plantation houses in the South was owned by a Free Black Woman. Not all blacks were slaves it is just the way it has been portrayed in History books. As far as trends in the area of immigration I would have to say I agree with the info in the reading material. After looking over the reading material from Chapter 1 there is a pie chart of the population for the years 2010 and 2050. In the chart the prediction for the U.S. population for 2050 states that there will be more Hispanics than there was in the 201 0 chart. There will be a decrease in the White Non-Hispanics and the African Americans stays about the same percentage. Although the United States is heavily populated I say that the Hispanics will have overpopulated many of the other races. The United States really has a lot to deal with in the area of diversity and its people. Discrimination is one of the major challenges that we will face because we can’t seem to get along and treat others like we are supposed to be or want to be treated ourselves. I think that the United States will be a lot better if we could all get along and really have a better understanding of the others around us and those who came before us. Like I stated earlier the United States was built on a premise that we are the ultimate dream and welcome people from all over the world. Hopefully maybe one day that will come true but that remains to be seen today and in the future years as well. Prejudice is another challenge that the United States faces due to the diversity of the people and those set in their ways. Stereotyping is another challenge that we face today as well as the past years as well. These things are in my opinion very much taught and passed down from generation to generation. All three of these challenges are serious and need to be stopped because they are all inappropriate in many ways and just plain mean and spiteful. There are plenty more challenges out here that we face on a day to day basis but we have to start somewhere. When it comes to having a diverse society I think there are really several benefits. There really are so many different benefits that we can have. Being that we are so diverse we will inherit a lot of things such as the different foods that all the different cultures have to offer. Each culture has something different than what the other cultures have. Each individual has something different to offer to our society. Being diverse is something special because we can each learn something new from one another. There are different dances, music; we all celebrate different holidays and a whole bunch of other things. The society that we live in has so much to offer and we are too blind to really see what is happening. At times I think the media does a good job of portraying people wrongly and it teaches us to stereotype them as well. We are so quick to judge others rather than getting to know them based on what we have seen or have heard from others. We really need to do a better job and find the best way to foster a good climate of acceptance for those around us and different than we are. It all starts with simply acting in a good civilized manner at all times. â€Å"Cultural pluralism is a term used when smaller groups within a larger society maintain their unique cultural identities, and their values and practices are accepted by the wider culture.† I think as long as we treat everyone they way that we want to be treated then we would be better off. It is really as simple as that and there is no better way to put it. We mainly need to learn to get along and stop all this bickering in addition to the other altercations that are currently going on in this world. The media can be a great to ol when it comes to teaching about diversity as well as a way to portray people in the wrong sense as well. The media perpetuates stereotyping and prejudice a lot sometimes whether it be on the radio or on the television set as well. An example of stereotyping would be portraying all black males as being in different gangs or some type of hoodlum. In Reality the percentage of blacks that are in gangs is not as high as told. In fact not all young black males are in a gang or even gang affiliated for that matter. Take the Treyvon Martin case for example. The thing was so blown out of proportion due to the fact he was a young black male walking around at night with a hoodie on. The media portrays this as a gang member and to some degree it could be the reason he was killed. The hysteria created simply caused Mr. Zimmerman to overreact thus causing him to shoot this teen and cause outrage in the black community. Usually when the television portrays blacks or even Hispanics for that matter it is usually a story about either murder or. You hardly see them advertise anything about a Caucasian doi ng anything unless it is some sort of celebrity or perhaps some weird random story taking place in Alabama or any of the southern states. You really have to do a search for them because I assume they don’t think it is important. It is so much prejudice going on out here in this world until it really doesn’t make any sense. I wish we could all get alone but sometimes that seems impossible. The media really needs to do a better job of providing a better sense of diversity and how we perceive others. I think that the media should help the viewers to understand that not everything you hear or see is really true. If there was a course for everyone to take to let them know that they need to investigate on what they hear or see. Television stations and radio stations need to start appreciating diversity. Diversity is beautiful and needs to be recognized more often. If it was not for diversity we would be all plain and boring. We as a country really need to do better when it comes to the topic of diversity. I wish that we could all get along and be treated as equals but that is simply not going to happen anytime soon. There are still a lot of prejudiced people out here in this world and sadly not a lot has changed over the years. I have had the displeasure of being around some people that were prejudice and it really makes me sad for them. To think that people are so single minded and set in their ways is pretty sad. I don’t really know how we as individuals and the United States work together to reduce prejudice but we need to start somewhere. I think classes such as cultural diversity are a good way to start but there is no way to make people think outside the box. We need to have more educational television shows that will increase the appreciation for diversity. We also need more television shows that can help us to reduce prejudice because it is a serious subject that needs to be addressed. I think when it comes to changing my ways or my behavior there is a few things I can do. I think that if I change my behavior to be more inclusive and pluralistic I would need to think about certain things before I act on them. By simply putting a little more thought into things can simply create a better outcome. I think that I need to get to know other people in different cultures and learn more about what they do and how they function. By getting to know other people in the other cultures will really help me to understand them rather judging them before actually knowing what they are about.

Religion In America, 1492-1790 :: essays research papers

Religion in the New World exploded into the land with the colonization of thousands of immigrants. It played an important role in the development of thought in the West. Religion was one of the first concepts to spark the desires of people from other countries to emigrate to the new lands. While many religions blossomed on the American shores of the Atlantic, a basic structure held for most of them, being predominantly derived from Puritanism. Jamestown, the first permanent English settlement, showed the link the new settlers had to God when Sir Thomas Dale said the following in 1610: Be not dismayed at all For scandall cannot doe us wrong, God will not let us fall. Let England knowe our willingnesse, For that our work is good; Wee hope to plant a nation Where none before hath stood. (Morison, pg. 89) Originally, when Christopher Columbus landed on the shores of America en route to Asia, he was not interested in discovering new lands. Most Europeans at the time were looking for a way to get at the oldest part of the Old World, the East Indies. An ocean route was sought to the countries that were believed to contain riches beyond European comprehension, thus avoiding having to pay hundreds of miscellaneous middlemen involved with trade, also making for a shorter journey. These motivations were accompanied by the desire to convert the heathen to Christianity, which had been declining since the rise of Islam. By uniting some of the Western Asian countries with Christianity, Europeans hoped to form a formidable team against the Turks and recover the valuable Holy Land (Morison, p.55). Columbus was sure that God had sent him to complete this task and that he was destined to carry the good Christian ways to heathen lands. A Spanish settlement was made in 1609 named Santa Fe in what is now New Mexico (Curti, p.167). Hundreds of thousands of Pueblo Indians were then converted to Christianity. At the same time, across the country, England was establishing its first settlement at Jamestown. Originally the English, who colonized alongside the French, saw settlements in the New World as strictly trading posts, but they soon realized the valuable opportunities that lay in the virgin lands of America, such as cotton, tobacco, and several other agricultural products that could not be found anywhere else. Many of England’s problems could be solved in America, and so colonization began. When the earliest settlers came, England had the responsibility to continue the Protestant Church, and prevent the Catholic Church from converting the entire Native American population of North America (Morison, p.105) A potential Protestant refuge could be based there in the threat of civil wars or a change of religion. Religion In America, 1492-1790 :: essays research papers Religion in the New World exploded into the land with the colonization of thousands of immigrants. It played an important role in the development of thought in the West. Religion was one of the first concepts to spark the desires of people from other countries to emigrate to the new lands. While many religions blossomed on the American shores of the Atlantic, a basic structure held for most of them, being predominantly derived from Puritanism. Jamestown, the first permanent English settlement, showed the link the new settlers had to God when Sir Thomas Dale said the following in 1610: Be not dismayed at all For scandall cannot doe us wrong, God will not let us fall. Let England knowe our willingnesse, For that our work is good; Wee hope to plant a nation Where none before hath stood. (Morison, pg. 89) Originally, when Christopher Columbus landed on the shores of America en route to Asia, he was not interested in discovering new lands. Most Europeans at the time were looking for a way to get at the oldest part of the Old World, the East Indies. An ocean route was sought to the countries that were believed to contain riches beyond European comprehension, thus avoiding having to pay hundreds of miscellaneous middlemen involved with trade, also making for a shorter journey. These motivations were accompanied by the desire to convert the heathen to Christianity, which had been declining since the rise of Islam. By uniting some of the Western Asian countries with Christianity, Europeans hoped to form a formidable team against the Turks and recover the valuable Holy Land (Morison, p.55). Columbus was sure that God had sent him to complete this task and that he was destined to carry the good Christian ways to heathen lands. A Spanish settlement was made in 1609 named Santa Fe in what is now New Mexico (Curti, p.167). Hundreds of thousands of Pueblo Indians were then converted to Christianity. At the same time, across the country, England was establishing its first settlement at Jamestown. Originally the English, who colonized alongside the French, saw settlements in the New World as strictly trading posts, but they soon realized the valuable opportunities that lay in the virgin lands of America, such as cotton, tobacco, and several other agricultural products that could not be found anywhere else. Many of England’s problems could be solved in America, and so colonization began. When the earliest settlers came, England had the responsibility to continue the Protestant Church, and prevent the Catholic Church from converting the entire Native American population of North America (Morison, p.105) A potential Protestant refuge could be based there in the threat of civil wars or a change of religion.

? Analyses and Compare the Physical Storage Structures and Types of Available Index of the Latest Versions of: 1. Oracle 2. Sql Server 3. Db2 4. Mysql 5. Teradata

Assignment # 5 (Individual) Submission 29 Dec 11 Objective: To Enhance Analytical Ability and Knowledge * Analyses and Compare the Physical Storage Structures and types of available INDEX of the latest versions of: 1. Oracle 2. SQL Server 3. DB2 4. MySQL 5. Teradata First of all define comparative framework. Recommend one product for organizations of around 2000-4000 employees with sound reasoning based on Physical Storage Structures Introduction to Physical Storage Structures One characteristic of an RDBMS is the independence of logical data structures such as  tables,  views, and  indexes  from physical storage structures.Because physical and logical structures are separate, you can manage physical storage of data without affecting access to logical structures. For example, renaming a database file does not rename the tables stored in it. The following sections explain the physical database structures of an Oracle database, including datafiles, redo log files, and control f iles. Datafiles Every Oracle database has one or more physical  datafiles. The datafiles contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the datafiles allocated for a database.The characteristics of datafiles are: * A datafile can be associated with only one database. * Datafiles can have certain characteristics set to let them automatically extend when the database runs out of space. * One or more datafiles form a logical unit of database storage called a tablespace. Data in a datafile is read, as needed, during normal database operation and stored in the memory cache of Oracle. For example, assume that a user wants to access some data in a table of a database. If the requested information is not already in the memory cache for the database, then it is read from the appropriate atafiles and stored in memory. Modified or new data is not necessarily written to a datafile immediately. To reduce the amount of disk access and to increase performance, data is pooled in memory and written to the appropriate datafiles all at once, as determined by the  database writer process (DBWn)  background process. Control Files Every Oracle database has a  control file. A control file contains entries that specify the physical structure of the database. For example, it contains the following information: * Database name * Names and locations of datafiles and redo log files * Time stamp of database creationOracle can  multiplex  the control file, that is, simultaneously maintain a number of identical control file copies, to protect against a failure involving the control file. Every time an  instance  of an Oracle database is started, its control file identifies the database and redo log files that must be opened for database operation to proceed. If the physical makeup of the database is altered, (for example, if a new datafile or redo log file is created), then the control file is autom atically modified by Oracle to reflect the change. A control file is also used in database recovery. Redo Log FilesEvery Oracle database has a set of two or more  redo log files. The set of redo log files is collectively known as the redo log for the database. A redo log is made up of redo entries (also called  redo records). The primary function of the redo log is to record all changes made to data. If a failure prevents modified data from being permanently written to the datafiles, then the changes can be obtained from the redo log, so work is never lost. To protect against a failure involving the redo log itself, Oracle allows a  multiplexed redo log  so that two or more copies of the redo log can be maintained on different disks.The information in a redo log file is used only to recover the database from a system or media failure that prevents database data from being written to the datafiles. For example, if an unexpected power outage terminates database operation, then data in memory cannot be written to the datafiles, and the data is lost. However, lost data can be recovered when the database is opened, after power is restored. By applying the information in the most recent redo log files to the database datafiles, Oracle restores the database to the time at which the power failure occurred.The process of applying the redo log during a recovery operation is called  rolling forward. Archive Log Files You can enable automatic archiving of the redo log. Oracle automatically archives log files when the database is in  ARCHIVELOG  mode. Parameter Files Parameter files contain a list of configuration parameters for that instance and database. Oracle recommends that you create a server parameter file (SPFILE) as a dynamic means of maintaining initialization parameters. A server parameter file lets you store and manage your initialization parameters persistently in a server-side disk file.Alert and Trace Log Files Each server and background proces s can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, while other information is for Oracle Support Services. Trace file information is also used to tune applications and instances. The alert file, or alert log, is a special trace file. The alert file of a database is a chronological log of messages and errors. Backup Files To restore a file is to replace it with a backup file.Typically, you restore a file when a media failure or user error has damaged or deleted the original file. User-managed backup and recovery requires you to actually restore backup files before you can perform a trial recovery of the backups. Server-managed backup and recovery manages the backup process, such as scheduling of backups, as well as the recovery process, such as applying the correct backup file when recovery is needed . A database  instance  is a set of memory structures that manage database files. Figure 11-1  shows the relationship between the instance and the files that it manages.Figure 11-1 Database Instance and Database Files Mechanisms for Storing Database Files Several mechanisms are available for allocating and managing the storage of these files. The most common mechanisms include: 1. Oracle Automatic Storage Management (Oracle ASM) Oracle ASM includes a file system designed exclusively for use by Oracle Database. 2. Operating system file system Most Oracle databases store files in a  file system, which is a data structure built inside a contiguous disk address space. All operating systems have  file managers that allocate and deallocate disk space into files within a file system.A file system enables disk space to be allocated to many files. Each file has a name and is made to appear as a contiguous address space to applications such as Oracle Database. The database can creat e, read, write, resize, and delete files. A file system is commonly built on top of a  logical volume  constructed by a software package called a  logical volume manager (LVM). The LVM enables pieces of multiple physical disks to be combined into a single contiguous address space that appears as one disk to higher layers of software. 3. Raw device Raw devices  are disk partitions or logical volumes not formatted with a file system.The primary benefit of raw devices is the ability to perform  direct I/O  and to write larger buffers. In direct I/O, applications write to and read from the storage device directly, bypassing the operating system buffer cache. 4. Cluster file system A  cluster file system  is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content. In an Oracle RAC environment, a cluster file system makes shared storage appears as a file system shared by many computers in a clustered env ironment.With a cluster file system, the failure of a computer in the cluster does not make the file system unavailable. In an operating system file system, however, if a computer sharing files through NFS or other means fails, then the file system is unavailable. A database employs a combination of the preceding storage mechanisms. For example, a database could store the control files and online redo log files in a traditional file system, some user data files on raw partitions, the remaining data files in Oracle ASM, and archived the redo log files to a cluster file system. Indexes in OracleThere are several types of indexes available in Oracle all designed for different circumstances: 1. b*tree indexes – the most common type (especially in OLTP environments) and the default type 2. b*tree cluster indexes – for clusters 3. hash cluster indexes – for hash clusters 4. reverse key indexes – useful in Oracle Real Application Cluster (RAC) applications 5. bi tmap indexes – common in data warehouse applications 6. partitioned indexes – also useful for data warehouse applications 7. function-based indexes 8. index organized tables 9. domain indexesLet's look at these Oracle index types in a little more detail. B*Tree Indexes B*tree stands for balanced tree. This means that the height of the index is the same for all values thereby ensuring that retrieving the data for any one value takes approximately the same amount of time as for any other value. Oracle b*tree indexes are best used when each value has a high cardinality (low number of occurrences)for example primary key indexes or unique indexes. One important point to note is that NULL values are not indexed. They are the most common type of index in OLTP systems. B*Tree Cluster IndexesThese are B*tree index defined for clusters. Clusters are two or more tables with one or more common columns and are usually accessed together (via a join). CREATE INDEX product_orders_ix O N CLUSTER product_orders; Hash Cluster Indexes In a hash cluster rows that have the same hash key value (generated by a hash function) are stored together in the Oracle database. Hash clusters are equivalent to indexed clusters, except the index key is replaced with a hash function. This also means that here is no separate index as the hash is the index. CREATE CLUSTER emp_dept_cluster (dept_id NUMBER) HASHKEYS 50; Reverse Key IndexesThese are typically used in Oracle Real Application Cluster (RAC) applications. In this type of index the bytes of each of the indexed columns are reversed (but the column order is maintained). This is useful when new data is always inserted at one end of the index as occurs when using a sequence as it ensures new index values are created evenly across the leaf blocks preventing the index from becoming unbalanced which may in turn affect performance. CREATE INDEX emp_ix ON emp(emp_id) REVERSE; Bitmap Indexes These are commonly used in data warehouse app lications for tables with no updates and whose columns have low cardinality (i. . there are few distinct values). In this type of index Oracle stores a bitmap for each distinct value in the index with 1 bit for each row in the table. These bitmaps are expensive to maintain and are therefore not suitable for applications which make a lot of writes to the data. For example consider a car manufacturer which records information about cars sold including the colour of each car. Each colour is likely to occur many times and is therefore suitable for a bitmap index. CREATE BITMAP INDEX car_col ON cars(colour) REVERSE; Partitioned IndexesPartitioned Indexes are also useful in Oracle datawarehouse applications where there is a large amount of data that is partitioned by a particular dimension such as time. Partition indexes can either be created as local partitioned indexes or global partitioned indexes. Local partitioned indexes mean that the index is partitioned on the same columns and wit h the same number of partitions as the table. For global partitioned indexes the partitioning is user defined and is not the same as the underlying table. Refer to the create index statement in the Oracle SQL language reference for details. Function-based IndexesAs the name suggests these are indexes created on the result of a function modifying a column value. For example CREATE INDEX upp_ename ON emp(UPPER(ename((; The function must be deterministic (always return the same value for the same input). Index Organized Tables In an index-organized table all the data is stored in the Oracle database in a B*tree index structure defined on the table's primary key. This is ideal when related pieces of data must be stored together or data must be physically stored in a specific order. Index-organized tables are often used for information retrieval, spatial and OLAP applications.Domain Indexes These indexes are created by user-defined indexing routines and enable the user to define his or h er own indexes on custom data types (domains) such as pictures, maps or fingerprints for example. These types of index require in-depth knowledge about the data and how it will be accessed. Indexes in Sql Server Index type| Description| Clustered| A clustered index sorts and stores the data rows of the table or view in order based on the clustered index key. The clustered index is implemented as a B-tree index structure that supports fast retrieval of the rows, based on their clustered index key values. Nonclustered| A nonclustered index can be defined on a table or view with a clustered index or on a heap. Each index row in the nonclustered index contains the nonclustered key value and a row locator. This locator points to the data row in the clustered index or heap having the key value. The rows in the index are stored in the order of the index key values, but the data rows are not guaranteed to be in any particular order unless a clustered index is created on the table. | Unique| A unique index ensures that the index key contains no duplicate values and therefore every row in the table or view is in some way unique.Both clustered and nonclustered indexes can be unique. | Index with included columns| A nonclustered index that is extended to include nonkey columns in addition to the key columns. | Full-text| A special type of token-based functional index that is built and maintained by the Microsoft Full-Text Engine for SQL Server. It provides efficient support for sophisticated word searches in character string data. | Spatial| A spatial index provides the ability to perform certain operations more efficiently on spatial objects (spatial data) in a column of the  geometry  data type.The spatial index reduces the number of objects on which relatively costly spatial operations need to be applied. | Filtered| An optimized nonclustered index especially suited to cover queries that select from a well-defined subset of data. It uses a filter predicate to index a portion of rows in the table. A well-designed filtered index can improve query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. | XML| A shredded, and persisted, representation of the XML binary large objects (BLOBs) in the  xml  data type column. | SQL Server Storage StructuresSQL Server does not see data and storage in exactly the same way a DBA or end-user does. DBA sees initialized devices, device fragments allocated to databases, segments defined within Databases, tables defined within segments, and rows stored in tables. SQL Server views storage at a lower level as device fragments allocated to databases, pages allocated to tables and indexes within the database, and information stored on pages. There are two basic types of storage structures in a database. * Linked data pages * Index trees. All information in SQL Server is stored at the page level. When a database is created, all spaceAllocated to it is divid ed into a number of pages, each page 2KB in size. There are five types of pages within SQL Server: 1. Data and log pages 2. Index pages 3. Text/image pages 4. Allocation pages 5. Distribution pages All pages in SQL Server contain a page header. The page header is 32 bytes in size and contains the logical page number, the next and previous logical page numbers in the page linkage, the object_id of the object to which the page belongs, the minimum row size, the next available row number within the page, and the byte location of the start of the free space on the page.The contents of a page header can be examined by using the dbcc page command. You must be logged in as sa to run the dbcc page command. The syntax for the dbcc page command is as follows: dbcc page (dbid | page_no [,0 | 1 | 2]) The SQL Server keeps track of which object a page belongs to, if any. The allocation of pages within SQL Server is managed through the use of allocation units and allocation pages. Allocation Pages Space is allocated to a SQL Server database by the create database and alter database commands. The space allocated to a database is divided into a number of 2KB pages.Each page is assigned a logical page number starting at page 0 and increased sequentially. The pages are then divided into allocation units of 256 contiguous 2KB pages, or 512 bytes (1/2 MB) each. The first page of each allocation unit is an allocation page that controls the allocation of all pages within the allocation unit. The allocation pages control the allocation of pages to tables and indexes within the database. Pages are allocated in contiguous blocks of eight pages called extents. The minimum unit of allocation within a database is an extent.When a table is created, it is initially assigned a single extent, or 16KB of space, even if the table contains no rows. There are 32 extents within an allocation unit (256/8). An allocation page contains 32 extent structures for each extent within that allocation unit. Each extent structure is 16 bytes and contains the following information: 1. Object ID of object to which extent is allocated 2. Next extent ID in chain 3. Previous extent ID in chain 4. Allocation bitmap 5. Deallocation bitmap 6. Index ID (if any) to which the extent is allocated 7. StatusThe allocation bitmap for each extent structure indicates which pages within the allocated extent are in use by the table. The deallocation bit map is used to identify pages that have become empty during a transaction that has not yet been completed. The actual marking of the page as unused does not occur until the transaction is committed, to prevent another transaction from allocating the page before the transaction is complete. Data Pages A data page is the basic unit of storage within SQL Server. All the other types of pages within a database are essentially variations of the data page.All data pages contain a 32-byte header, as described earlier. With a 2KB page (2048 bytes) this leaves 2016 bytes for storing data within the data page. In SQL Server, data rows cannot cross page boundaries. The maximum size of a single row is 1962 bytes, including row overhead. Data pages are linked to one another by using the page pointers (prevpg, nextpg) contained in the page header. This page linkage enables SQL Server to locate all rows in a table by scanning all pages in the link. Data page linkage can be thought of as a two-way linked list.This enables SQL Server to easily link new pages into or unlink pages from the page linkage by adjusting the page pointers. In addition to the page header, each data page also contains data rows and a row offset table. The row-offset table grows backward from the end of the page and contains the location or each row on the data page. Each entry is 2 bytes wide. Data Rows Data is stored on data pages in data rows. The size of each data row is a factor of the sum of the size of the columns plus the row overhead. Each record in a data page is assi gned a row number. A single byte is used within each row to store the row number.Therefore, SQL Server has a maximum limit of 256 rows per page, because that is the largest value that can be stored in a single byte (2^8). For a data row containing all fixed-length columns, there are four bytes of overhead per row: 1. Byte to store the number of variable-length columns (in this case, 0) 1 byte to store the row number. 2. Bytes in the row offset table at the end of the page to store the location of the row on the page. If a data row contains variable-length columns, there is additional overhead per row. A data row is variable in size if any column is defined as varchar, varbinary, or allows null values.In addition to the 4 bytes of overhead described previously, the following bytes are required to store the actual row width and location of columns within the data row: 2 bytes to store the total row width 1 byte per variable-length column to store the starting location of the column wi thin the row 1 byte for the column offset table 1 additional byte for each 256-byte boundary passed Within each row containing variable-length columns, SQL Server builds a column offset table backward for the end of the row for each variable-length column in the table.Because only 1 byte is used for each column with a maximum offset of 255, an adjust byte must be created for each 256-byte boundary crossed as an additional offset. Variable-length columns are always stored after all fixed-length columns, regardless of the order of the columns in the table definition. Estimating Row and Table Sizes Knowing the size of a data row and the corresponding overhead per row helps you determine the number of rows that can be stored per page.The number of rows per page affects the system performance. A greater number of rows per page can help query performance by reducing the number of ages that need to be read to satisfy the query. Conversely, fewer rows per page help improve performance for c oncurrent transactions by reducing the chances of two or more users accessing rows on the same page that may be locked. Let's take a look at how you can estimate row and table sizes. Fixed-length fields with no null values.Sum of column widths overhead- The Row Offset Table The location of a row within a page is determined by using the row offset table at the end of the page. To find a specific row within the page, SQL Server looks in the row offset table for the starting byte address within the data page for that row ID. Note that SQL Server keeps all free space at the end of the data page, shifting rows up to fill in where a previous row was deleted and ensuring no space fragmentation within the page.If the offset table contains a zero value for a row ID that indicates that the row has been deleted. Index Structure All SQL Server indexes are B-Trees. There is a single root page at the top of the tree, branching out into N number of pages at each intermediate level until it reaches the bottom, or leaf level, of the index. The index tree is traversed by following pointers from the upper-level pages down through the lower-level pages. In addition, each index level is a separate page chain. There may be many intermediate levels in an index.The number of levels is dependent on the index key width, the type of index, and the number of rows and/or pages in the table. The number of levels is important in relation to index performance. Non-clustered Indexes A non-clustered index is analogous to an index in a textbook. The data is stored in one place, the index in another, with pointers to the storage location of the data. The items in the index are stored in the order of the index key values, but the information in the table is stored in a different order (which can be dictated by a clustered index).If no clustered index is created on the table, the rows are not guaranteed to be in any particular order. Similar to the way you use an index in a book, Microsoft ® SQL Serverâ„ ¢ 2000 searches for a data value by searching the non-clustered index to find the location of the data value in the table and then retrieves the data directly from that location. This makes non-clustered indexes the optimal choice for exact match queries because the index contains entries describing the exact location in the table of the data values being searched for in the queries.If the underlying table is sorted using a clustered index, the location is the clustering key value; otherwise, the location is the row ID (RID) comprised of the file number, page number, and slot number of the row. For example, to search for an employee ID (emp_id) in a table that has a non-clustered index on the emp_id column, SQL Server looks through the index to find an entry that lists the exact page and row in the table where the matching emp_id can be found, and then goes directly to that page and row. Clustered IndexesA clustered index determines the physical order of data in a table . A clustered index is analogous to a telephone directory, which arranges data by last name. Because the clustered index dictates the physical storage order of the data in the table, a table can contain only one clustered index. However, the index can comprise multiple columns (a composite index), like the way a telephone directory is organized by last name and first name. Clustered Indexes are very similar to Oracle's IOT's (Index-Organized Tables).A clustered index is particularly efficient on columns that are often searched for ranges of values. After the row with the first value is found using the clustered index, rows with subsequent indexed values are guaranteed to be physically adjacent. For example, if an application frequently executes a query to retrieve records between a range of dates, a clustered index can quickly locate the row containing the beginning date, and then retrieve all adjacent rows in the table until the last date is reached. This can help increase the perf ormance of this type of query.Also, if there is a column(s) that is used frequently to sort the data retrieved from a table, it can be advantageous to cluster (physically sort) the table on that column(s) to save the cost of a sort each time the column(s) is queried. Clustered indexes are also efficient for finding a specific row when the indexed value is unique. For example, the fastest way to find a particular employee using the unique employee ID column emp_id is to create a clustered index or PRIMARY KEY constraint on the emp_id column.Note  Ã‚  PRIMARY KEY constraints create clustered indexes automatically if no clustered index already exists on the table and a non-clustered index is not specified when you create the PRIMARY KEY constraint. Index Structures Indexes are created on columns in tables or views. The index provides a fast way to look up data based on the values within those columns. For example, if you create an index on the primary key and then search for a row of data based on one of the primary key values, SQL Server first finds that value in the index, and then uses the index to quickly locate the entire row of data.Without the index, a table scan would have to be performed in order to locate the row, which can have a significant effect on performance. You can create indexes on most columns in a table or a view. The exceptions are primarily those columns configured with large object (LOB) data types, such as  image,  text,  and  varchar(max). You can also create indexes on XML columns, but those indexes are slightly different from the basic index and are beyond the scope of this article. Instead, I'll focus on those indexes that are implemented most commonly in a SQL Server database.An index is made up of a set of pages (index nodes) that are organized in a B-tree structure. This structure is hierarchical in nature, with the root node at the top of the hierarchy and the leaf nodes at the bottom, as shown in Figure 1. Figure 1: B-t ree structure of a SQL Server index When a query is issued against an indexed column, the query engine starts at the root node and navigates down through the intermediate nodes, with each layer of the intermediate level more granular than the one above. The query engine continues down through the index nodes until it reaches the leaf node.For example, if you’re searching for the value 123 in an indexed column, the query engine would first look in the root level to determine which page to reference in the top intermediate level. In this example, the first page points the values 1-100, and the second page, the values 101-200, so the query engine would go to the second page on that level. The query engine would then determine that it must go to the third page at the next intermediate level. From there, the query engine would navigate to the leaf node for value 123.The leaf node will contain either the entire row of data or a pointer to that row, depending on whether the index is clustered or nonclustered. Clustered Indexes A clustered index stores the actual data rows at the leaf level of the index. Returning to the example above, that would mean that the entire row of data associated with the primary key value of 123 would be stored in that leaf node. An important characteristic of the clustered index is that the indexed values are sorted in either ascending or descending order.As a result, there can be only one clustered index on a table or view. In addition, data in a table is sorted only if a clustered index has been defined on a table. Note:  A table that has a clustered index is referred to as a  clustered table. A table that has no clustered index is referred to as a  heap. Nonclustered Indexes Unlike a clustered indexed, the leaf nodes of a nonclustered index contain only the values from the indexed columns and row locators that point to the actual data rows, rather than contain the data rows themselves.This means that the query engine must t ake an additional step in order to locate the actual data. A row locator’s structure depends on whether it points to a clustered table or to a heap. If referencing a clustered table, the row locator points to the clustered index, using the value from the clustered index to navigate to the correct data row. If referencing a heap, the row locator points to the actual data row. Nonclustered indexes cannot be sorted like clustered indexes; however, you can create more than one nonclustered index per table or view.SQL Server 2005 supports up to 249 nonclustered indexes, and SQL Server 2008 support up to 999. This certainly doesn’t mean you should create that many indexes. Indexes can both help and hinder performance, as I explain later in the article. In addition to being able to create multiple nonclustered indexes on a table or view, you can also add  included columns  to your index. This means that you can store at the leaf level not only the values from the indexed column, but also the values from non-indexed columns. This strategy allows you to get around some of the limitations on indexes.For example, you can include non-indexed columns in order to exceed the size limit of indexed columns (900 bytes in most cases). Index Types In addition to an index being clustered or nonclustered, it can be configured in other ways: * Composite index:  An index that contains more than one column. In both SQL Server 2005 and 2008, you can include up to 16 columns in an index, as long as the index doesn’t exceed the 900-byte limit. Both clustered and nonclustered indexes can be composite indexes. * Unique Index:  An index that ensures the uniqueness of each value in the indexed column.If the index is a composite, the uniqueness is enforced across the columns as a whole, not on the individual columns. For example, if you were to create an index on the FirstName and LastName columns in a table, the names together must be unique, but the individual n ames can be duplicated. A unique index is automatically created when you define a primary key or unique constraint: * Primary key:  When you define a primary key constraint on one or more columns, SQL Server automatically creates a unique, clustered index if a clustered index does not already exist on the table or view.However, you can override the default behavior and define a unique, nonclustered index on the primary key. * Unique:  When you define a unique constraint, SQL Server automatically creates a unique, nonclustered index. You can specify that a unique clustered index be created if a clustered index does not already exist on the table. * Covering index:  A type of index that includes all the columns that are needed to process a particular query. For example, your query might retrieve the FirstName and LastName columns from a table, based on a value in the ContactID column.You can create a covering index that includes all three columns. Teradata What is the Teradata R DBMS? The Teradata RDBMS is a complete relational database management system. With the Teradata RDBMS, you can access, store, and operate on data using Teradata Structured Query Language (Teradata SQL). It is broadly compatible with IBM and ANSI SQL. Users of the client system send requests to the Teradata RDBMS through the Teradata Director Program (TDP) using the Call-Level Interface (CLI) program (Version 2) or via Open Database Connectivity (ODBC) using the Teradata ODBC Driver.As data requirements grow increasingly complex, so does the need for a faster, simpler way to manage data warehouse. That combination of unmatched performance and efficient management is built into the foundation of the Teradata Database. The Teradata Database is continuously being enhanced with new features and functionality that automatically distribute data and balance mixed workloads even in the most complex environments.Teradata Database 14  currently offers low total cost of ownership in a simple, scalable, parallel and self-managing solution. This proven, high-performance decision support engine running on the  Teradata Purpose-Built Platform Family offers a full suite of data access and management tools, plus world-class services. The Teradata Database supports installations from fewer than 10 gigabytes to huge warehouses with hundreds of terabytes and thousands of customers. Features & BenefitsAutomatic Built-In Functionality  | Fast Query Performance  | â€Å"Parallel Everything† design and smart Teradata Optimizer enables fast query execution across platforms| | Quick Time to Value  | Simple set up steps with automatic â€Å"hands off† distribution of data, along with integrated load utilities result in rapid installations| | Simple to Manage  | DBAs never have to set parameters, manage table space, or reorganize data| | Responsive to Business Change  | Fully parallel MPP â€Å"shared nothing† architecture scales linearly across data, us ers, and applications providing consistent and predictable performance and growth| Easy Set & G0† Optimization Options  | Powerful, Embedded Analytics  | In-database data mining, virtual OLAP/cubes, geospatial and temporal analytics, custom and embedded services in an extensible open parallel framework drive efficient and differentiated business insight| | Advanced Workload Management  | Workload management options by user, application, time of day and CPU exceptions| | Intelligent Scan Elimination  | â€Å"Set and Go† options reduce full file scanning (Primary, Secondary, Multi-level Partitioned Primary, Aggregate Join Index, Sync Scan)| Physical Storage Structure of Teradata Teradata offers a true hybrid row and Column database.All database management systems constantly tinker with the internal structure of the files on disk. Each release brings an improvement or two that has been steadily improving analytic workload performance. However, few of the key player s in relational database management systems (RDBMS) have altered the fundamental structure of having all of the columns of the table stored consecutively on disk for each record. The innovations and practical use cases of â€Å"columnar databases† have come from the independent vendor world, where it has proven to be quite effective in the performance of an increasingly important class of analytic query.These columnar databases store data by columns instead of rows. This means that all values of a single column are stored consecutively on disk. The columns are tied together as â€Å"rows† only in a catalog reference. This gives a much finer grain of control to the RDBMS data manager. It can access only the columns required for the query as opposed to being forced to access all columns of the row. It’s optimal for queries that need a small percentage of the columns in the tables they are in but suboptimal when you need most of the columns due to the overhead in a ttaching all of the columns together to form the result sets.Teradata 14 Hybrid Columnar The unique innovation by Teradata, in Teradata 14, is to add columnar structure to a table, effectively mixing row structure, column structures and multi-column structures directly in the DBMS which already powers many of the largest data warehouses in the world. With intelligent exploitation of Teradata Columnar in Teradata 14, there is no longer the need to go outside the data warehouse DBMS for the power of performance that columnar provides, and it is no longer necessary to sacrifice robustness and support in the DBMS that holds the post-operational data.A major component of that robustness is parallelism, a feature that has obviously fueled much of Teradata’s leadership position in large-scale enterprise data warehousing over the years. Teradata’s parallelism, working with the columnar elements, are creating an entirely new paradigm in analytic computing – the pinpoint accuracy of I/O with column and row partition elimination. With columnar and parallelism, the I/O executes very precisely on data interesting to the query. This is finally a strong, and appropriate, architectural response to the I/O bottleneck issue that analytic queries have been living with for a decade.It also may be Teradata Database’s most significant enhancement in that time. The physical structure of each container can also be in row (extensive page metadata including a map to offsets) which is referred to as â€Å"row storage format,† or columnar (the row â€Å"number† is implied by the value’s relative position). Partition Elimination and Columnar The idea of data division to create smaller units of work as well as to make those units of work relevant to the query is nothing new to Teradata Database, and most DBMSs for that matter.While the concept is being applied now to the columns of a table, it has long been applied to its rows in the form of partitioning and parallelism. One of the hallmarks of Teradata’s unique approach is that all database functions (table scan, index scan, joins, sorts, insert, delete, update, load and all utilities) are done in parallel all of the time. There is no conditional parallelism. All units of parallelism participate in each database action. Teradata eliminates partitions from needing I/O by reading its metadata to understand the range of data placed into the partitions and eliminating those that are washed out by the predicates.See Figure There is no change to partition elimination in Teradata 14 except that the approach also works with columnar data, creating a combination row and column elimination possibility. In a partitioned, multi-container table, the unneeded containers will be virtually eliminated from consideration based on the selection and projection conditions of the query. See Figure Following the column elimination, unneeded partitions will be virtually eliminated fro m consideration based on the projection conditions.For the price of a few metadata reads to facilitate the eliminations, the I/O can now specifically retrieve a much focused set of data. The addition of columnar elimination reduces the expensive I/O operation, and hence the query execution time, by orders of magnitude for column-selective queries. The combination of row and column elimination is a unique characteristic of Teradata’s implementation of columnar. Compression in Teradata Columnar Storage costs, while decreasing on a per-capita basis over time, are still consuming increasing budget due to the massive increase in the volume of data to store.While the data is required to be under management, it is equally required that the data be compressed. In addition to saving on storage costs, compression also greatly aids the I/O problem, effectively offering up more relevant information in each I/O. Columnar storage provides a unique opportunity to take advantage of a series of compression routines that make more sense when dealing with well-defined data that has limited variance like a column (versus a row with high variability. ) Teradata Columnar utilizes several compression methods that take advantage of the olumnar orientation of the data. A few methods are highlighted below. Run-Length Encoding When there are repeating values (e. g. , many successive rows with the value of ‘12/25/11’ in the date container), these are easily compressed in columnar systems like Teradata Columnar, which uses â€Å"run length encoding† to simply indicate the range of rows for which the value applies. Dictionary Encoding Even when the values are not repeating successively, as in the date example, if they are repeating in the container, there is opportunity to do a dictionary representation of the data to further save space.Dictionary encoding is done in Teradata Columnar by storing compressed forms of the complete value. The dictionary representatio ns are fixed length which allows the data pages to remain void of internal maps to where records begin. The records begin at fixed offsets from the beginning of the container and no â€Å"value-level† metadata is required. This small fact saves calculations at run-time for page navigation, another benefit of columnar. For example, 1=Texas, 2=Georgia and 3=Florida could be in the dictionary, and when those are the column values, the 1, 2 and 3 are used in lieu of Texas, Georgia and Florida.If there are 1,000,000 customers with only 50 possible values for state, the entire vector could be stored with 1,000,000 bytes (one byte minimum per value). In addition to dictionary compression, including the â€Å"trimming†8 of character fields, traditional compression (with algorithm UTF8) is made available to Teradata Columnar data. Delta Compression Fields in a tight range of values can also benefit from only storing the offset (â€Å"delta†) from a set value. Teradata Co lumnar calculates an average for a container and can store only the offsets from that value in place of the field.Whereas the value itself might be an integer, the offsets can be small integers, which double the space utilization. Compression methods like this lose their effectiveness when a variety of field types, such as found in a typical row, need to be stored consecutively. The compression methods are applied automatically (if desired) to each container, and can vary across all the columns of a table or even from container to container within a column9 based on the characteristics of the data in the container.Multiple methods can be used with each column, which is a strong feature of Teradata Columnar. The compounding effect of the compression in columnar databases is a tremendous improvement over the standard compression that would be available for a strict row-based DBMS. Teradata Indexes Teradata provides several indexing options for optimizing the performance of your relati onal databases. i. Primary Indexes ii. Secondary Indexes iii. Join Indexes iv. Hash Indexes v. Reference Indexes Primary Index Primary index determines the distribution of table rows on the disks controlled by AMPs.In Teradata RDBMS, a primary index is required for row distribution and storage. When a new row is inserted, its hash code is derived by applying a hashing algorithm to the value in the column(s) of the primary code (as show in the following figure). Rows having the same primary index value are stored on the same AMP. Rules for defining primary indexes The primary indexes for a table should represent the data values most used by the SQL to access the data for the table. Careful selection of the primary index is one of the most important steps in creating a table.Defining primary indexes should follow the following rules: * A primary index should be defined to provide a nearly uniform distribution of rows among the AMPs, the more unique the index, the more even the distrib ution of rows and the better space utilization. * The index should be defined on as few columns as possible. * Primary index can be either Unique or non-unique. A unique index must have a unique value in the corresponding fields of every row;   a non-unique index permits the insertion of duplicate field values. The unique primary index is more efficient. Once created, the primary index cannot be dropped or modified, the index must be changed by recreating the table. If a primary index is not defined in the CREATE TABLE statement through an explicit declaration of a PRIMARY INDEX, the default is to use one of the following: * PRIMARY key * First UNIQUE constraint * First column The primary index values are stored in an integral part of the primary table. It should be based on the set selection most frequently used to access rows from a table and on the uniqueness of the value.Secondary Index In addition to a primary index, up to 32 unique and non-unique secondary indexes can be def ined for a table. Comparing to primary indexes, Secondary indexes allow access to information in a table by alternate, less frequently used paths. A secondary index is a subtable that is stored in all AMPs, but separately from the primary table. The subtables, which are built and maintained by the system, contain the following; * RowIDs of the subtable rows * Base table index column values * RowIDs of the base table rows (points)As shown in the following figure, the secondary index subtable on each AMP is associated with the base table by the rowID . Defining and creating secondary index Secondary index are optional. Unlike the primary index, a secondary index can be added or dropped without recreating the table. There can be one or more secondary indexes in the CREATE TABLE statement, or add them to an existing table using the CREATE INDEX statement or ALTER TABLE statement. DROP INDEX can be used to dropping a named or unnamed secondary index.Since secondary indexes require subtab les, these subtables require additional disk space and, therefore, may require additional I/Os for INSERTs, DELETEs, and UPDATEs. Generally, secondary index are defined on column values frequently used in WHERE constraints. Join Index A join index is an indexing structure containing columns from multiple tables, specifically the resulting columns form one or more tables. Rather than having to join individual tables each time the join operation is needed, the query can be resolved via a join index and, in most cases, dramatically improve performance.Effects of Join index Depending on the complexity of the joins, the Join Index helps improve the performance of certain types of work. The following need to be considered when manipulating join indexes: * Load Utilities  Ã‚  Ã‚   The join indexes are not supported by MultiLoad and FastLoad utilities, they must be dropped and   recreated after the table has been loaded. * Archive and Restore  Ã‚  Ã‚   Archive and Restore cannot be us ed on join index itself. During a restore of   a base table or database, the join index is marked as invalid.The join index must be dropped and recreated before it can be used again in the execution of queries. * Fallback Protection  Ã‚  Ã‚   Join index subtables cannot be Fallback-protected. * Permanent Journal Recovery  Ã‚  Ã‚   The join index is not automatically rebuilt during the recovery process. Instead, the join index is marked as invalid and the join index must be dropped and recreated before it can be used again in the execution of queries. * Triggers  Ã‚  Ã‚   A join index cannot be defined on a table with triggers. Collecting Statistics  Ã‚  Ã‚   In general, there is no benefit in collecting statistics on a join index for joining columns specified in the join index definition itself. Statistics related to these columns should be collected on the underlying base table rather than on the join index. Defining and creating secondary index Join indexes can be create d and dropped by using CREATE JOIN INDEX and DROP JOIN INDEX statements. Join indexes are automatically maintained by the system when updates (UPDATE, DELETE, and INSERT) are performed on the underlying base tables.Additional steps are included in the execution plan to regenerate the affected portion of the stored join result. Hash Indexes Hash indexes are used for the same purposes as single-table join indexes. The principal difference between hash and single-table join indexes are listed in the following table. Hash indexes create a full or partial replication of a base table with a primary index on a foreign key column table to facilitate joins of very large tables by hashing them to the same AMP. You can define a hash index on one table only.The functionality of hash indexes is a superset to that of single-table join indexes. Hash indexes are not indexes in the usual sense of the word. They are base tables that cannot be accessed directly by a query. The Optimizer includes a has h index in a query plan in the following situations. * The index covers all or part of a join query, thus eliminating the need to redistribute rows to make the join. In the case of partial query covers, the Optimizer uses certain implicitly defined elements in the hash index to join it with its underlying base table to pick up the base table columns necessary to complete the cover. A query requests that one or more columns be aggregated, thus eliminating the need to perform the aggregate computation For the most part, hash index storage is identical to standard base table storage except that hash indexes can be compressed. Hash index rows are hashed and partitioned on their primary index (which is always defined as non-unique). Hash index tables can be indexed explicitly, and their indexes are stored just like non-unique primary indexes for any other base table.Unlike join indexes, hash index definitions do not permit you to specify secondary indexes. The major difference in storage between hash indexes and standard base tables is the manner in which the repeated field values of a hash index are stored. Reference Indexes A reference index is an internal structure that the system creates whenever a referential integrity constraint is defined between tables using a PRIMARY KEY or UNIQUE constraint on the parent table in the relationship and a REFERENCES constraint on a foreign key in the child table.The index row contains a count of the number of references in the child, or foreign key, table to the PRIMARY KEY or UNIQUE constraint in the parent table. Apart from capacity planning issues, reference indexes have no user visibility. References for Teradata http://www. teradata. com/products-and-services/database/ http://teradata. uark. edu/research/wang/indexes. html http://www. teradata. com/products-and-services/database/teradata-13/ http://www. odbms. org/download/illuminate%20Comparison. pdf