Home > Free Essays > Tech & Engineering > Data > Database Application at Amazon
2 min
Cite This

Database Application at Amazon Essay

StarStarStarStarStar

A database consists of logically related data stored in a single repository, normally within a computer. The components of a database are columns, rows, tables, and keys. They are the building block of any relational database, and understanding their functions helps an organization to manage its data.

Columns are single characteristics or facts about an entity within a database. Employee’s name, department number, customer’s name, and product price are examples of columns. A row contains data of one or more columns according to the design of a database; it describes a single instance of an entity. Columns and rows are contained in a table, making it necessary to group data logically. For instance, you can have a customers table that store customers’ details.

Tables can be linked together by keys. A table can consist of a primary key, a foreign key, or both. A primary key is a field that uniquely identifies each row; and a foreign key is a key in one table that must match a primary key value in another table in order to establish a relationship or a link between two tables (Coronel, 2000).

Amazon has been able to embrace the use of databases in order to manage its organizational records hence meeting its corporate objective. The company offers its customers a wide range of products, including music, toys, electronics, software, books, and clothes. These products are sold through the company’s website (Amazon.com) and managed by relational databases such as Amazon RDS (Vogels, 2009).

Amazon’s database enables it to take online orders, manage supply, and coordinate many e-mails. The company records customer details in a table having columns such as names and phone numbers.

Each row in a table contains individual customer records. Another table containing product details enable the company’s database to link product and customer tables through keys. When a customer selects a product, the product number identifies the item in the product table, thus enabling the company to manage product details with much ease.

There are several data management issues that can be encountered by Amazon. First, the company’s database may run out of space because many people are now registering in e-market places.

The increase in number of products may lead to little or no storage capacity. Second, handling many transactions tends to lower the operation of a database. This may lead to orders taking longer than normal. Third, data stored in the database can be hacked or destroyed by viruses. Besides, private information about users or customers can be leaked, leading to loss of privacy.

References

Coronel, R. (2000). Database Systems: Design, Implementation, and Management. (4th Ed.). Cambridge: Thomson Course Technology.

Vogels, W. (2009). “Expanding the Cloud: The Amazon Realtional Database Service (RDS).” All Things Distributed. Retrieved from

This essay on Database Application at Amazon was written and submitted by your fellow student. You are free to use it for research and reference purposes in order to write your own paper; however, you must cite it accordingly.
Removal Request
If you are the copyright owner of this paper and no longer wish to have your work published on IvyPanda.
Request the removal

Need a custom Essay sample written from scratch by
professional specifically for you?

Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar
Writer online avatar

certified writers online

Cite This paper

Select a citation style:

Reference

IvyPanda. (2019, June 24). Database Application at Amazon. Retrieved from https://ivypanda.com/essays/database-application-at-amazon/

Work Cited

"Database Application at Amazon." IvyPanda, 24 June 2019, ivypanda.com/essays/database-application-at-amazon/.

1. IvyPanda. "Database Application at Amazon." June 24, 2019. https://ivypanda.com/essays/database-application-at-amazon/.


Bibliography


IvyPanda. "Database Application at Amazon." June 24, 2019. https://ivypanda.com/essays/database-application-at-amazon/.

References

IvyPanda. 2019. "Database Application at Amazon." June 24, 2019. https://ivypanda.com/essays/database-application-at-amazon/.

References

IvyPanda. (2019) 'Database Application at Amazon'. 24 June.

More related papers
Psst... Stuck with your
assignment? 😱
Hellen
Online
Psst... Stuck with your assignment? 😱
Do you need an essay to be done?
What type of assignment 📝 do you need?
How many pages (words) do you need? Let's see if we can help you!