Free Essay


In: Computers and Technology

Submitted By jmc017
Words 1301
Pages 6
Roll No: 13031756-016

Vertical Partitioning Algorithm for database Design
Vertical Partitioning Algorithms for Database
Stanford University
This paper define the vertical partitioning in which spread or break the logical relation into group of attributes according to transaction that access the attribute are group of attribute. The vertical partition is defined in three context memory level a centralized database and the most important is distributed database like placed data in different sites. In this paper we focus on distributed database. in which local transaction should be minimize.
In this paper we use two phases the first approach is that we have no first knowledge and second is cost optimization. Fragmented may be no overlapping or overlapping.
Partitioning in database design is the process of assign object from the logical schema to the physical several objects. Vertical partition is the process of divide attribute into group (fragments) and assign to physical object. In vertical fragmentation we make maximum and all minimum possible fragments it mean that fragment may be overlap or non-overlap.
So we make cluster of fragments that one overlap or no overlap but we use the both disjoint and no disjoint cases in partitioning. We use fragmentation to improve the performance of query optimization .according to distribution point of view the different approach is like hierarchy of memory partition. In this approach we used vertical partitioning in that way the attribute that are mostly accessed are placed inthat way the attributes that are highly access are placed in the fastest memory the distribution environment we also use normally fragmentation but replica is also used . in the vertical fragmentation we use physical file structure to the improve the performance of the fragment must be closely match according to the requirement of the transaction . the ideal case is where all the fragments according to the truncation queries. The trival design process is when the set of attributes where B(m) is the mth Bell number; for large m, B(m) approaches m"; for m =
15, it is ElO’, for m = 30, it is =1023
The main contribute of this paper in following areas:
We extend the work of Hoffer and Severance that defined attribute In such way that attribute of a object that are highly accessed means that attribute that have high affinity are grouped together . The main concept is overlapping and no overlapping. * We consider the application of partitioning to databases that use one level of memory or a memory hierarchy. We also consider the application of vertical
Partitioning to distributed databases by determining the allocation of fragments to different sites, allowing no replicated or replicated fragments. Thus we apply vertical partitioning is more general environment. * A unique feature of this paper is the two step design of fragments. in the first step the vertical partitioned is governed by an empirical notion of partitioning. Where one expects that the need for transaction to visit multiple fragments should be this approach does not require detailed cost factors. The second step is the refining the design of fragments according to estimated cost factors which reflect the physical environment. * Problem description * An object can be vertical partitioned by considering its projection onto different set of attributes as creating new object is called fragment. If intersection of two fragments is empty then approach is no overlapping otherwise is overlapping.
The transaction specification relevant to the vertical partitioning of an object consists of the following information: * the frequency (per unit time period) of occurrence of the transaction; * when the same transaction can be issued at multiple sites in a distributed * database, the frequency at each site is specified; * the subset of the attributes used for retrieval or update by the transaction; * the total number of instances of the object selected on the average by one occurrence of the transaction.
Approach to place the vertical partitioning problem in this paper
Three kinds of decision can be refined to place the vertical partitioning problem * logic decision concerning the structure and the composition of the fragment * Distribution and allocation decision * Physical decision concerning the storage structure and access method for each fragment The use of the terms logical and physical above is only for convenience: it is difficult to argue where the exact boundary lies between these two types of decisions. This paper concentrates on the logical and distribution decisions, Database and transaction specification the transaction specification relevant to vertical partitioning assumption of knowing important transaction common practice of distributed application information.
Vertical partitioning will be addressed in two phases:
(1) Empirical design of fragments based on the specified logical access frequencies of the transactions.
(2) Design based on cost factors related to the physical environment; this produces a refinement of fragmentation and, if applicable, the allocation of fragments to multiple levels of a memory hierarchy or to multiple sites of a distributed database. In an environment in single object is fragmented and allocated into different sites Identification is required to identify each fragment this is done by replicating the primary key are using unique tuple identification
Previous work done in this field and solution of this problem:
The previous is grouped into two major categories. In the first approach is the optimal solution of the problem under restrictive assumption and the second approach is heuristic. Hoffer developed an nonlinear zero one program for the solution of the petitioning problem which minimize linear combination of the problem retrieval and update cost.Babed formulated the less restricted vertical problem in this model one sub record is created as a primary record all requested addressed to this sub record. This problem is un manageable when large attributes.
Papers of the second category describe heuristic approaches to the attribute partitioning problem. We agree with Hammer and Niamir that the general vertical partitioning problem is “heuristic in nature,” and that optimal methods cannot deal with it adequately. Hoffer and severance measure the affinity between attribute and used bond energy algorithm. Their attribute similarity function uses the notion of an attribute being “required for processing,” or “required only if the record is selected,” or finally “not required.” We feel that in database systems the first and the second cases cannot be distinguished because all attributes of the same record are accessed together; therefore, we prefer the notion of logical accesses. In the Hoffer length approach that update a fragment of long length attribute or small length attribute. But in this paper we not use length factor to measure affinity. Hammer and niamer try to summarize unsolved problem
BEB try to ordering the attribute but is left unsolved to clump the attributes together to form fragments. Similarity of pairs of attributes can be inadequate if the similarity among larger groups of attributes is not taken into account Our present paper extends the results of by giving algorithms for the design of fragments that perform the activity for automatically and by taking into account in our algorithms “blocks” of attributes with similar properties,

The hammer and nimear used grouping technique heuristic starts by assigning each attribute to a different partition; The major criticism of this approach is regarding the direction in which to explore the lattice-while Hammer and Niamir proceed “up” by grouping, we proceed “down” by splitting. The rationale behind this approach is that the “optimal” solution, in our opinion, is much closer to the group composed of all attributes, assumed to be our starting point, than to groups that are single attribute partitions.
Further extensions of this work will be in the direction of developing site-specific affinity measures for distributed databases, of incorporating different transaction processing strategies, and of considering new applications of vertical partitioning, such as parallel processing of transactions.

Similar Documents

Free Essay

System Performance

...When a file is stored in clusters that are not physically located next to each other on the platter, it is fragmented. Fragment can occur for various reasons, but most common cause is the modification of deletion of a file. To explain it generally is that there are three files. First one takes three spaces and the second and third takes two spaces. We remove the second one and replace with a five space file. Since all five can’t fit within the two spaces, we put two into the space and put the rest at the end. This is called fragmentation. Fragmentation can affect all files, including system files. As a result fragmentation will affect all window system. As a normal user, the hard drives will fragment over time and activities such as updates or installation and deletion of programs can cause major fragmentation. It will cause the performance to degrade over time. The different processes running in the background i.e. window explorer, all take an allotted amount of RAM to perform at optimum levels. More free RAM means that the essential processes that are running have more priority of the space and the CPU. When you begin to run your RAM to its limits, the essential processes and even the non-essential processes begin to lag due to the overtaxing of the CPU and RAM. Technically RAM does not have any influence on the processor performance, but it does have an influence on how much processes or technically instructions that processor can read. So a greater amount of RAM memory...

Words: 424 - Pages: 2

Free Essay

On Paper Wings

...On Paper Wings In Oregon in the year of 1945 a pregnant woman and five kids were killed by a balloon bomb they found in a forest. This balloon bomb was made in a factory in Japan by Japanese girls and women. The women were unaware of what happened once the paper they were making left the factories. Forty years after they began working in the factories a few of the women found out information regarding one balloon bombing and their reactions surprised me. These women were compassionate, courageous, and forgiving. The Japanese women had found out that their forty years of effort had on only killed six people. They were shocked that that's all they had killed, but what surprised me were their reactions once they figured out the information on those six people. Forty years after they had started working in the factories the women were finally getting information back from the United States. John Takeshita had written them a letter revealing the profiles of these six people. It came to my surprise that despite the fact that the United States had killed and wounded over one hundred fifty thousand Japanese people in Hiroshima these women were able to put that aside and feel bad for the six Americans that were killed. I was surprised to find out that the women who were contacted by Takeshita had the courage to visit Bly not knowing if the town resented them or if the people would welcome them or even be welcome at all. Though these women didn't create the bombs alone and weren't...

Words: 409 - Pages: 2

Premium Essay

Fragmentation of Liquidity

...September 2011 Issue Fragmentation of Liquidity Fragmentation of Liquidity ATMonitor Commentary Foreword This is not an academic paper on theoretical discussions but rather a series of practical questions and answers that members of MyATMonitor have asked and industry experts answered. Our primary goal is to bring knowledge that will be useful to traders on the buy side. In fact, this philosophy is well reflected in the very heart of MyATMonitor, a reliable, independent and trusted peer-group network of and for buy-side only institutional traders. This publication has been compiled from ongoing Q&A activity on the MyATMonitor Expert Panels. At the time of publication, the Expert Panels on MyATMonitor are Dark Pools, Commission Sharing Arrangements, EMS/OMS Relationships, Fragmentation of Liquidity, MiFID II and Transaction Cost Analysis and Best Execution. The ATMonitor team would like to thank all members and experts that have generously contributed to the success of MyATMonitor. ATMonitor Team. 2 Fragmentation of Liquidity ATMonitor Commentary Experts Panellists (in the order of appearance): Steve Grob Director of Group Strategy, Fidessa Steve is responsible for Fidessa’s strategic development.This includes the development of new geographic markets and strategic partnerships and driving new industry initiatives. As part of this Steve heads up the firm’s strategy in response to the fragmentation of the......

Words: 1560 - Pages: 7

Free Essay


... vi. Defenses: 1. Consolidation is realistic in a FRAGMENTED world 2. Economies of Scale: bigger operations have a lower relative cost vii. Criticisms: 3. Focus on the bottom line over quality 4. Conflicts of interest viii. News consequences: less coverage of congress, Washington, pentagon, world II. Media Behavior is Changing e. Day-and-date release: Many movies are released to multiple formats (theater, DVD, on-demand and download) on the same day f. Multiple platforms g. Theater attendance has fallen since 2002 h. Music sales are down by half since 1999 i. Newspapers are declining; DVD sales are flat III. Audience Fragmentation j. While media consolidates, its audiences are becoming more narrowly defined (fragmenting) k. Once, you ix. Read a newspaper x. Bought an album xi. Went to a movie l. Now you… xii. Read online IV. Media Convergence m. The erosion of traditional distinctions between media n. Media multitasking: Simultaneously consuming many different kinds of media xiii. 1980: /Americans received 7 hours of info a day xiv. Today: About 11.8 hours...

Words: 298 - Pages: 2

Free Essay

Unit 8

...Zakkary 11/11/14 Brandon Walker In computing, file system fragmentation, sometimes called file system aging, is the inability of a file system to lay out related data sequentially (contiguously), an inherent phenomenon in storage-backed file systems that allow in-place modification of their contents. It is a special case of data fragmentation. File system fragmentation increases disk head movement or seeks, which are known to hinder throughput. The correction to existing fragmentation is to reorganize files and free space back into contiguous areas, a process called defragmentation. File system fragmentation is projected to become more problematic with newer hardware due to the increasing disparity between sequential access speed and rotational latency (and to a lesser extent seek time), of consumer-grade hard disks,[3] on which file systems are usually placed. Thus, fragmentation is an important problem in recent file system research and design. The containment of fragmentation not only depends on the on-disk format of the file system, but also heavily on its implementation.[4] In simple file system benchmarks, the fragmentation factor is often omitted, as realistic aging and fragmentation is difficult to model. Rather, for simplicity of comparison, file system benchmarks are often run on empty file systems, and unsurprisingly, the results may vary heavily from real-life access patterns.[5] File system fragmentation has less impact upon the performance of solid-state......

Words: 473 - Pages: 2

Premium Essay

Sql Server and Fragmentation

...SQL Server and fragmentation Just wanted to share a quick tip on querying on sql server fragmentation and fixing things if needed. On our production server, which was setup by our sysadmin with all defaults as per configuration. I was also told that there is a weekly job setup for rebuilding indexes if there is a fragmentation. I did accepted everything told at a face value. But now its time for some treasure hunting. I had to do some sql BOL searching as it was not clear to me how/where I could find such stats. Finally came across sys.db_dm_index_physical_stats function which needs several arguments and based on it it will return details about an object's fragmentation. Lets look at this function first. sys.dm_db_index_physical_stats ( DB_ID, OBJECT_ID, INDEX_ID, PARTITION_NO, MODE); Here db_id, and object_id can take  [ null | 0 | default ] as a value and all mean same. To narrow down the results, you need to supply actual value. Index_id could be [ null | -1 |  default ],  and all mean same, alternatively you can provide 0 if object is a heap, or actual id of an index if object is an index. Partition_no is the partition id of index or heap. Alternatively it can be one of [ null | 0 | default ] as a value and all mean same. Mode is a scan level used to gather the information. It can be any of [ default | null | limited | sampled | detailed ], where default (null ) is limited. So to begin with I took one of our biggest table and made the query...

Words: 409 - Pages: 2

Premium Essay

Bio-Diversity and Wildlife Threatened

...Abstract The diversification of human induced disturbances upon natural ecosystems has contributed to wildlife habitat fragmentation which has been a serious threat to the survival of natural populations. Possible factors contributing to this decline include changes in food, loss of genetic variation, cover availability, evolution of predation, microclimatic effect, and lack of recolonization following extinctions. Habitat loss and fragmentation are processes that separate small populations, which have higher extinction rates that may lead to a reduction in biological diversity. Recent dramatic declines in forest management have brought some undesirable consequences for forest health and wildlife (Jack Ward, T. (n.d). Standing back and letting nature take its course has become increasingly prevalent. Unfortunately, while appealing as this sounds, this is not tenable in the long-term as it will not protect forests, retain biodiversity, and provide some wood products over time. We are increasingly depending on places beyond our borders to provide our wood places with far less resources and knowledge about how to manage forests responsibly. By importing wood products, we export not only environmental consequences but jobs and dollars ( Jack Ward, T. (n.d). Conservation biology needs to reach out to a much broader community of academics and practitioners in fields as diverse as anthropology, history, political geography, and environmental psychology......

Words: 3462 - Pages: 14

Free Essay

Forest Fragments

...Forest Fragments – Assignment Questions The ‘Forest Fragments’ Assignment is an individual assignment, completed and submitted individually to the dropbox PART II: Data Interpretation (9 marks) Examine the data you collected and the calculations you made to answer the following questions: 2.1 What extra information is included in the Shannon’s Diversity Index (vs. richness), and how is this information useful? Why would a scientist use Shannon’s Diversity Index in addition to a richness value? (2 marks) Shannon’s Diversity Index accounts for not only the number of species in a habitat (species richness) but also the evenness of the species within that same habitat. A scientist would use Shannon’s Diversity Index in addition to a richness value because the richness value does not depict the evenness of the habitat, whereas Shannon’s Diversity Index shows both the species richness and the evenness. 2.2 Compare the richness value for your plot with the richness value based on the data collected from all the groups in your Seminar section. Now compare the richness value based on the data collected from all the groups in your Seminar section to the richness value for the entire Dairy Bush (found in the spreadsheet). Explain why these three richness values might be different. (2 marks) The richness value for my plot was a lot less than the richness value collected for my seminar section. The richness value for my seminar section was less than the richness value......

Words: 1195 - Pages: 5

Premium Essay

Land Fragmentation In Nigeria

...with land fragmentation, this phenomenon is still wide spread in...

Words: 1202 - Pages: 5

Free Essay

Do Threats to Biodiversity Pose the Greatest Challenge to Humanity for the 21st Century?

...Do threats to biodiversity pose the greatest challenge to humanity for the 21st century? Introduction: The term biodiversity refers to the variety of life on Earth at all its levels, from genes to ecosystems, and the ecological and evolutionary processes that sustain it. Biodiversity includes not only special we consider rare, threatened, or endangered, but every living thing even organisms we still know little about, such as microbes, fungi, and invertebrates. Biodiversity is important everywhere; species and habitats in your area as well as those in distant lands all play a role in maintaining healthy ecosystems. Biodiversity is important because it boosts ecosystem productivity where each species, no matter how small, all have an important role to play. For example, a larger number of plant species means a greater variety of crops. Greater species diversity ensures natural sustainability for all life forms. There are five main threats to biodiversity that I can cover later on in this report are: 1. Invasive alien species 2. Climate change 3. Nutrient loading 4. Water pollution 5. Loss of habitat 6. Overexploitation In this report my goal is to explain what biodiversity is in detail in depth and explain how important it is to the world. Also, to outline if and how these threats pose a threat to humanity in the 21st century. How important is biodiversity? Biodiversity is important for all species' survival. We need a variety of habitats for...

Words: 1062 - Pages: 5

Free Essay

Population and Pollution

...Ecosystem Population and Pollution Rachael BIO/101 September 10, 2013 Ecosystem Population and Pollution Although much of the Everglades is a protected national park, this has not been always the case. Hazards caused by humans in the Everglades are historical as well as an ongoing issue for its varied and fragile ecosystem. Several of the hazards that affect the stability of the Everglades’ ecosystem are environmental pollution, extracted resources, habitat loss and destruction, and the biomagnification of toxins. Because the Everglades is predominantly a marsh, these wetlands are an enormous resource of fresh water. For nearly 200 years, humans have been extracting fresh water from the Everglades for consumption and agriculture. The irrigation of commodities such as oranges and sugar cane can account for pollutants. Habitat destruction and loss can be attributed to the introduction of non-native species as well as the agricultural practices of humans. In addition, biomangnification increases the prevalence of toxins throughout the food chain that can affect the stability of the Everglades’ ecosystem. Fresh water is the foremost extracted resource from the Everglades. South Florida’s human population growth is putting pressure on the Everglades to serve its increasing demands for fresh water. Building dams and digging canals for agriculture and homes are a hazard to the stability of the ecosystem. A great deal canals have been built, so the natural flow of water......

Words: 711 - Pages: 3

Free Essay

Week Five Decisions in Paradise Business Part Three

...Week Five Decisions in Paradise Business Part Three Nicole Halliwill MGT/350 Critical Thinking: Strategies in Decision Making Alvin Richards October 29, 2012 * The determining factors affecting Habitat for Humanity’s decision to establish a greater presence in Kava is controlled by the Kava government along with its willingness to accept assistance, the willingness of organizations to help with construction as well as meeting conservation concerns, and citizens abilities along with its willingness to assist in construction. CEO Jonathan Reckford, the board of directors, and key staff members will have to be in agreement about continual need to remain in Kava. Another consideration is if there are available resources to do the construction, to run the tools to complete the construction, and to operate on a day-to-day basis. Habitat for Humanity needs to consider also if there are enough translators that speak the indigenous languages of the South Pacific tribes, Asian (Chinese primarily), African, French, and Spanish. Habitat for Humanity needs to make sure that economic interests have a way to be shipped and can be transported out. Another huge factor affecting Habitat for Humanity’s decision would be the safety of everyone involved. The medical and safety risks to staff and the community need to be addressed. The natural disasters risk to the community and staff. The last factor is to attract tourists back to Kava. * Not only has Kava’s government been......

Words: 1151 - Pages: 5

Free Essay

Extinction of Mammoth

...Title: the extinction of Mammoth Introduction * Location and life of mammoth * Causes of extinction * Reasons for extinction Body Causes for extinction * activities as cause of mammoth extinction * Climate change in the extinction of mammoth(climate warming) * Loss of habitat * Radiation cause Reasons for extinction * Hunting and poaching * Protection from mega fauna animals. * Habitat loss due to vegetation and other factors * Use of skin for cloths and horn for ivory item. etc. Summary Mammoth is a large and extinct elephant of the Pleistocene epoch; these types of elephants were hairy and had a sloping back and long curved tusks. These big elephant has gone extinct and throughout this paper I’ll be talking about how these mega fauna animals have gone extinct, what caused their extinction, the reason for this extinction etc. Mammoth are thought to be extinct due to the climate change because they used to live in glaciers areas, they are also thought to have gone extinct because of man activities on them like hunting and poaching. The last thing I’ll be talking about in this paper is the reason why these animals have gone extinct. Journal article: * The extinction of the woolly mammoth and the archaeological record in Northeastern Asia Authors: Pitulko and Nikolskiy, march 2012 Pitulko, V. V., & Nikolskiy, P. A. (2012). The extinction of the woolly mammoth and the archaeological record in Northeastern......

Words: 327 - Pages: 2

Premium Essay

Should Zoos Exist?

...Where do you find a variety of different animals from all over the world in one place? A place where almost everyone has been when they were young. A zoo keeps many animals in a confined space, but should zoos exist? No, I don’t think zoos should exist because the animals aren’t there for education purposes, the zoos aren’t actually doing what they’re claiming to and the artificial habitat is really nothing like their original one. Would animals like being in a zoo? I don’t think so. Zoos claim to display or give educational opportunities, but most visitors only spend a few minutes at each enclosure, looking for entertainment rather than awareness. Most zoo enclosures are small, and instead of understanding the animals usual habits, signs often provide no more information than an animal’s species, diet, history and natural habitats. Animals are cramped together, lack privacy, and have small chances for physical exercise. These conditions usually result in abnormal and suicidal behaviour, known as “zoochosis.” How many people who go to the zoo actually take the time to go and read everything on a sign? Most people just go to the zoo to look at animals and if they don’t do anything “interesting” they move along to the next display hoping for “interesting” things to happen. Though the zoos say that they are helping save near extinct species, why aren’t they trying to preserve the animals’ natural habitat? In fact the zoo itself might be the one responsible for the......

Words: 652 - Pages: 3

Free Essay

System Preformance

...System Performance 1. Search the internet for information about the effects of a fragmented file system on disk performance. Individual file fragmentation occurs when a single file has been broken into multiple pieces (called extents on extent-based file systems). While disk file systems attempt to keep individual files contiguous, this is not often possible without significant performance penalties. File system check and defragmentation tools typically only account for file fragmentation in their "fragmentation percentage" statistic. 2. Search the internet for information about how process load and the number of running processes affect system performance. The more things you have running the slower your system goes. 3. Search the internet for information about how adding more motherboard RAM improves virtual memory performance. It's been proven that adding more memory to a computer system increases its performance. If there isn't enough room in memory for all the information the CPU needs, the computer has to set up what's known as a virtual memory file. In so doing, the CPU reserves space on the hard disk to simulate additional RAM. This process, referred to as "swapping", slows the system down. In an average computer, it takes the CPU approximately 200ns (nanoseconds) to access RAM compared to 12,000,000ns to access the hard drive. 4. Provide an explanation of the factors that affect performance in a windows computer system and how to improve its......

Words: 400 - Pages: 2