StudentShare solutions
Triangle menu

Database Management System - Assignment Example

Not dowloaded yet

Extract of sample
Database Management System

This thesis provides a benchmark to assess the performance of storing binary large objects in a relational database management system.A benchmark framework that reduces development and integration costs of benchmarking the database performance of a specific application is included.A randomly generated test script is utilized to provide variation among test cases and consistency between different runs of the benchmark.The benchmark is platform independent and can be extended to support any database vendor providing a Java data source for connectivity.The benchmark framework requires the implementation of one simulation class for each application benchmark.This significantly reduces the cost of benchmark development. Deciding which database system, operating system, or hardware configuration is best suited for the application is now feasible. Existing benchmarks do not provide any analysis of storing BLOBs within the database and are generally completed by the database or hardware vendor rather than the consumer.With the passage of the Utah Digital Signature Act of 1995 and the Federal Electronic Signature Act of 2000,more and more paper documents are being stored electronically. These digitized documents have "electronic signatures" attached to them that serve not only as unique identifiers but make them legally binding and enforceable as well.One obvious medium that is used to quickly access and store these electronic documents is the database. Many online and distributed systems require the efficient access of thousands of binary files such as music (the sample files streamed to potential customers), digital signatures, and other documents and videos that generally range in size from 10KB to SMB. The storage and retrieval of these items can be accomplished through a database system using a column type capable of storing binary data (commonly referred to as a "binary large object" or a BLOB). There are many existing database systems capable of storing BLOBs. Such systems' functionality, performance and cost vary greatly among vendors (with some costing as much as $25,000 for a single CPU license). The prohibitive cost often keeps some organizations from conducting full assessments of database systems for possible use in their operations, potentially causing a loss or revenue. Entities with limited resources need an affordable means of assessing or benchmarking their own database utilization. This thesis, first and foremost, provides a database benchmark for storing BLOBs in a database. Secondly, a database benchmark framework is provided with the example implementation being the BLOB database benchmark. By so doing:

Developers will finally have a database benchmark for the storage of small, medium and large BLOBs in a database.
Users will have a reliable and affordable means to benchmark their applications' database utilization on multiple database systems.
Users will be able to determine the performance of different accessible system configurations (hardware, database and operating systems).
Users will be able to get results reflecting the configuration capability of their organization. Running the benchmark locally will allow reliable replication of the benchmark without reading large disclosure documents provided with results from commercial benchmarks.
The software development community will now have a benchmark for storing BLOBs in a database. This benchmark will fill a void as most database benchmarks focus on OLTP (online transaction processing) that consist of very small records and none focus on the general storage of BLOBs.

CHAPTER 2 REVIEW OF LITERATURE-EXISTING DATABASE BENCHMARKS
My research indicates that no research has been done comparing the performance of database systems' ability to store BLOBs. Similar research regarding database performance (for datasets not including binary data) does exist and come from the following sources: the Transaction Processing Counsel (TPC) [3], Storage Performance Council ...Show more

Summary

This thesis provides a benchmark to assess the performance of storing binary large objects (BLOB) in a relational database management system.A benchmark framework that reduces development and integration costs of benchmarking the database performance of a specific application is included…
Author : marcus08
Database Management System Assignment essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Database Management System Assignment"
with a personal 20% discount.
Grab the best paper

Related Essays

Questions on Information Technology Assignment
It is also important to remember to reference your work - including images taken from somewhere else. ALL answers you provide must be composed in a majority of your own words and interpretation of ideas (for more details please re-read carefully your Academic Honesty Declaration).
3 pages (750 words) Assignment
Relational Database Assignment
The four prime factors that control the integrity of a database include relationship-level integrity, attribute-level integrity, business rules, and entity-level integrity (Lathem, 2008). Using these relationships, one can divide the data in separate tables.
3 pages (750 words) Assignment
Project Evaluation Assignment
The databases are evaluated against set criteria in order to assess the accessibility, phrase searching, performance, scalability, accuracy, reliability, completeness, consistency, and timeliness. The document pertains to the evaluation of the database that was developed in response to the request of a local recruiting agency.
6 pages (1500 words) Assignment
Database assignment
The concerned techniques used for data modeling and the accompanying tools allows for input, translation and conversion of various system designs (both complex and simple) into processes and data flow representations which are easily read and understood .
10 pages (2500 words) Assignment
Database assignment 2
The final stage is the mapping of the Global Model to the other applications. The mapping will be able to show the relationship that exists between different entities within the organization. Company Selection The company selected for this project is Budget Transportation firm.
10 pages (2500 words) Assignment
Week 7 Hand-In Assignment
Answer: A database management which helps to isolate the softwares or programs from the data used by the program is known as data independence. This kind of data independence can be achieved by restricting the applications to
3 pages (750 words) Assignment
The Database Approach is more beneficial to businesses compared to traditional file-based systems... Discuss, making references to specific business examples, the extent to which you agree and/or disagree with this widely held view
It has been designed in a way that it gives access to an individual to different queries, whereas the file processing system only allows the individual to access the pre-determined information.
3 pages (750 words) Assignment
Database Management
The growth rate of the following town has seen the apartments booked and the contract is agreed upon with the tenant. The apartments are well furnished with the best quality products and latest fittings
6 pages (1500 words) Assignment
Database Management system project (MIS)
f the report will document the analysis of the business case to identify data management and processing issues and challenges facing the organization. The second part documents the design of a solution that includes the database strategy to define the business rules that govern
10 pages (2500 words) Assignment
Quantitative Methods database assignment
at group, to identify the pricing characteristics of the hotel rooms according to locality, star ratings, and amenities, review score from customers and value added services like swimming pool or Wi-Fi connectivity (Maliene, 2011). This analysis will help to rent of the rooms of
9 pages (2250 words) Assignment
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation