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.
Nobody downloaded yet

Storing and Retrieving Images in Oracle - Essay Example

Comments (0)
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 paper
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. ("sdsu.edu", 1997) "BLOB stored images have an object relational type known as ORDImgB, while BFILE stored images have an object relational type known as ORDImgF."("sdsu.edu", 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."("sdsu.edu",1997) Storing, retrieval, compressing, decompressing, reformatting and a few data manipulation services such as scaling and cropping are achieved through data cartridge mechanism. ("sdsu.edu",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" ("sdsu.edu", 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
Comments (0)
Click to create a comment
SAP and Oracle difference
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
IT - Attacking Cryptography
In this rapidly changing digital world of advanced hackers, new prevention techniques are invented for maximum prevention along with minimizing risks. One cannot predict that the blowfish encryption algorithm will also be replaced by the new and more secure algorithm known as (Anonymous2007, 500-500) two fish that will also be replaced at some period of this information age.
5 Pages(1250 words)Essay
Please read the attachments carefully you'r able to know what I want
There are currently one hundred and fifty (150) databases developed using the approach of the NoSQL. The NoSQL databases are extents horizontally and used for the organization having significant emphasis on the performance and / or deals with real-time transactions while compromising the consistency of the data.
7 Pages(1750 words)Essay
Oracle 11i features
It provides immediate control over the procedure and eliminates the versioning issues. Oracle 11i is the most complete, integrated, business intelligence portfolio. It is based on customer focused applications strategy. Oracle 11i drives the performance with consistent financial and operational information.
11 Pages(2750 words)Essay
Images and Database Technology
Graphical abilities of today's media and computers impress: digital imaging allows not only to store and process digital images but also to develop and design new graphical objects and solve different graphical modeling tasks. Digital images are widely used instead of traditional pictures, photographs, movies, etc.
11 Pages(2750 words)Essay
L’Oreal, the French world leader in cosmetics, is one of the best cases of the channel and brand image consistency. This has led to
2 Pages(500 words)Essay
Storing Information
Entity computer includes reference number for machine identification, operating system, position of the computer system, hard disk memory, CPU, and RAM. Department includes type of department and reference number for lab in those departments. Lab includes
1 Pages(250 words)Essay
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 intensity too which was also equally low. In this way,
5 Pages(1250 words)Essay
Oracle Corporation
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
2 Pages(500 words)Essay
Oracle and Machiavellian Philosophy
According to the scientist's, he emphasized on sovereignty and power. In his entire career, Machiavelli has been focusing on the finish line and with less attention to ethics, religion or morals. In his literature, he shows that how the prince is governing is distinct dramatically from how society expects the prince to govern.
8 Pages(2000 words)Essay
Let us find you another Essay on topic Storing and Retrieving Images in Oracle for FREE!
Contact us:
Contact Us Now
FREE Mobile Apps:
  • About StudentShare
  • Testimonials
  • FAQ
  • Blog
  • Free Essays
  • New Essays
  • Essays
  • The Newest Essay Topics
  • Index samples by all dates
Join us:
Contact Us