Nobody downloaded yet

Storing and Retrieving Images in Oracle - Essay Example

Comments (0) Cite this document
Storing images in database is not recommended. The drawbacks to this approach could be that the server to process huge amounts of data. The images stored in database can not be viewed by any standard viewers; they can be only viewed through application. ("datanamic") This approach is certainly safe since it utilizes the security features of the DBMS…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.6% of users find it useful
Storing and Retrieving Images in Oracle
Read TextPreview

Extract of sample
"Storing and Retrieving Images in Oracle"

Download file to see previous pages ("oracle_why_image_indatabase", 2005) Oracle database provides a feature known as oracle Intermedia which enables easy and efficient management of images, audio and video data. ("Oracle", 2005) This helps programmers in multimedia application development. Oracle 10g also addresses issues such as security, backup/recovery, extensibility and flexibility. ("oracle_why_image_indatabase", 2005) It reduces the response time and hence reduces the operation cost as well.
Storing images in file system allows does not allow selective access to images in the directory. Individual users can access all or none of the images in the file system, which is not desired and this proves a threat to the database. ("oracle_why_image_indatabase",2005) In traditional file systems the images have to be backed up on regular basis, which is not so in database storage. One single backup program is required for day to day backup and also only one program is required for recovery. Conversion of images form one format to another is also made possible in this storage procedure.
Oracle, as we all know is a database management system that is Object Relational in nature. This allows oracle to store images in addition to normal data in the database. With the support provided for Binary Large Object's, it is possible to store complex objects in the database. ("", 1997) "BLOB stored images have an object relational type known as ORDImgB, while BFILE stored images have an object relational type known as ORDImgF."("", 1997) A locator is stored in the row and the actual image is stored in other table space. To store a binary image in the database define a column in the table with BLOB data type. All movie files, images form scanners; large mpeg files can be stored in BLOB column. A table containing BLOB data type is as follows
CREATE TABLE test_table (
Image BLOB); ("expertanswercenter", 2005)
The images stored in database are linked with metadata. "Metadata in Greek literally means data about data." ("Wikipedia", 2005) It is information that describes another set of data and stored in a central location to help organizations standardize their data. The images are stored in a row in the table which contains alphanumeric columns.
Storage space required for image data depends on how the image was captured. Database applications such as geographic information systems, imaging, workflow etc require the storing and retrieval of these images which is facilitated by data cartridges. "A data cartridge is the mechanism by which clients, application-specific servers, and database servers can be easily and reliably extended."("",1997) Storing, retrieval, compressing, decompressing, reformatting and a few data manipulation services such as scaling and cropping are achieved through data cartridge mechanism. ("",1997)
Accessing the attributes within a complex object is possible through the dot notation. Accessing images to perform various functions such as select, update or delete can be performed with the following syntax statement.
"SELECT table_alias.variable.data_attribute FROM table_name table_alias" ("", 1997) It is also possible to extract other properties such as the file format, content format, height and width in pixels, compression format and ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Storing and Retrieving Images in Oracle Essay Example | Topics and Well Written Essays - 750 words”, n.d.)
Storing and Retrieving Images in Oracle Essay Example | Topics and Well Written Essays - 750 words. Retrieved from
(Storing and Retrieving Images in Oracle Essay Example | Topics and Well Written Essays - 750 Words)
Storing and Retrieving Images in Oracle Essay Example | Topics and Well Written Essays - 750 Words.
“Storing and Retrieving Images in Oracle Essay Example | Topics and Well Written Essays - 750 Words”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document
SAP and Oracle difference
...? 30 January, Differences between Oracle and SAP: Introduction: SAP and Oracle are commonly employed in businesses in the modern age for software solutions. SAP is meant for worldwide operations, and its solutions optimize the core processes in business when used with a fair licensing model (“SAP solutions”). SAP software solutions are suitable for use in relatively small businesses. As compared to SAP, Oracle can accommodate larger businesses and big sized companies. Both Oracle and SAP are extremely compatible with the growing business needs of the present age, and have their own strengths and weaknesses, that make them suitable for use in different kinds of companies....
2 Pages(500 words)Essay
Oracle database Recovery
...mounting (Preston, 1999): SVRMGR > startup mount; ORACLE instance started. Total System Global Area 5130648 bytes Fixed Size 44924 bytes Variable Size 4151836 bytes Database Buffers 409600 bytes Redo Buffers 524288 bytes Database mounted. It emerges that control2.ctl was a high-quality control file replica. If the mounting of database is performed successfully than Step 10 should be performed. Step 4: Health status of all Data Files and Redo Logs is good? Before performing Step 6, the Steps 4 and 5 should be performed successfully. However, in Step 7 the “create control files” script that is mentioned only works if all the data files and online reconstruct a log that is in working condition. The data files that are...
7 Pages(1750 words)Research Paper
Oracle 11i features
...communicates with discoverer server or reports server. A repository has to be created in the database to store the discoverer workbooks and other metadata. (Foster 2001). Personal Home Page Personal home page is an addition in the Apps 11i version. It provides a customizable interface between user and the application. This allows one central page which links to all of the application responsibilities, access forms and BIS products. Through personal home page, the user can navigate to anywhere in the system where he is permitted to work using a single log on. It allows the user to have the freedom of changing the password, accessing the work area, submit concurrent requests and reports. Product Global...
11 Pages(2750 words)Essay
... Review. Retrieved from Gregory, J. (1999). Marketing corporate image. New York: McGraw-Hill. Kennedy, D. (2006). The ultimate marketing plan: Find your hook. Communicate your message. Make your mark. Cincinnati: Adams Media. Marconi, J. (1996). Image marketing: using public perceptions to attain business objectives. New York: McGraw-Hill.... Images Images In accordance with the global marketing theory, the channel performance of an exporting company is as a result of its style of channel management. In fact, what is essential in every company is the relationship between the distributors and the company (Kennedy, 2006). When it comes to...
2 Pages(500 words)Essay
PeopleSoft vs. Oracle
...included mass firing of employees due to downsizing and a deterioration of customer relations. PeopleSoft had in its bylaws a poison pill to protect itself against hostile takeovers. The poison pill was a bylaw that stated that the company had the ability to release more shares in order to dilute the shares of the company taking over once that company controlled more than 20% of the shares of PeopleSoft. The only way to eliminate the poison pill was if the board of directors approved its elimination. Another factor that negatively impacted Oracle was the legal actions that J.D Edwards took against Oracle in the form of a lawsuit. In the end Oracle was able to take over PeopleSoft, but...
2 Pages(500 words)Research Paper
Recieving and storing (report)
...Report on Receiving and Storing Hotel and restaurant business forms a major source of income to most private as well as private investors. It is a lucrative business which has the ability to develop and grow from a small scale business to an international business. The business varies in terms of complexity depending on the size of the firm and also the capital invested. It is because of its complexity that it is important to try and understand how it operates in its key departments especially the receiving as well as the storage department since these two are the major departments that handle the inventory of the business (Bragg, 2013). In understanding these areas, the study selected a small restaurant which is located...
3 Pages(750 words)Assignment
Storing Information
...Information Storage System for Computer Lab Information Storage System for ComputerLab Five things that might be included in the model to store information about computers in a computer lab are department, location, lab, type of lab, and computer. Each department have separate computer lab. Each lab consists of different types of computers. Lab facilities for students and faculties can be at different location. Entity relationship defines model for defining processes between each entity and how they relate to each other (Rob and Coronel, 2009) Entity computer includes reference number for machine identification, operating system, position of the computer system, hard disk memory, CPU, and RAM. Department includes type...
1 Pages(250 words)Essay
...Essay, Visual Arts and Film Studies 1. The image below of is of a cloud called the altocumulus. They are grey clouds with bundles, sheds or rollers. The hue of the image is a medium too as the artist has used neither much of the black color nor usage of strong light in its background. The artist has presented the image in a two dimensional point of view since only presented the image with only its base and height while ignoring its breath. The decision to use only one of the primary colors, that is black, the author somehow minimized the costs, as when people look at the body of the image. He used minimal black color in his paintings and light...
5 Pages(1250 words)Essay
Oracle Corporation
...The company that I would like to work at is Oracle Corporation. Oracle is a multi-national company that is based in United States, and its main interest of operation is on computer technology. The company specializes in the marketing and development of computer hardware applications, and software enterprise products. Oracle Company is the second largest software technological company, after Microsoft (Zheng and Zhang, 2014). This is in terms of revenues that the company makes. The main reason as to why I have an interest in working with Oracle is based on the fact that it is one of the largest developers of computer software’s, and it has a stable source of revenue....
2 Pages(500 words)Essay
Oracle Database 11g
.... What are some of the reasons why database creates and uses memory structures? Give examples. The Oracle database develops databases for different purposes. For example, when running a memory stores program code, the private and shared data among the users for every connected user. 6. How does a cache hit and a cache miss affect a first time Database use? Whenever an Oracle Database user runs the process for the first time, it calls for a specific piece of data. The Oracle searches for the data from the database buffer cache. The search process can either find the data or not find it. If the data is found, it is referred to as a cache hit, and when it misses the data it...
16 Pages(4000 words)Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Let us find you another Essay on topic Storing and Retrieving Images in Oracle for FREE!
logo footer
Contact us:
Contact Us Now
FREE Mobile Apps:
  • StudentShare App Store
  • StudentShare Google play
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • Miscellaneous
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us