Mixed media Databases .

Uploaded on:
Points Covered. Why interactive media is an issue for databasesSupport for searchingTypes of DatabasesRelational Databases and MultimediaExample - AccessObject Relational Databases and MultimediaExample - OracleObject Oriented Databases and MultimediaExample - Jasmine. The issue - recap. Information progressively means numbers and little strings as well as interactive media information too
Slide 1

Interactive media Databases Possible answers for the R impediments

Slide 2

Topics Covered Why sight and sound is an issue for databases Support for seeking Types of Databases Relational Databases and Multimedia Example - Access Object Relational Databases and Multimedia Example - Oracle Object Oriented Databases and Multimedia Example - Jasmine

Slide 3

The issue - recap Data progressively implies not simply numbers and little strings but rather mixed media information also – organized (content, pictures, video, sound, VR, and so on.) Databases guarantee: very much organized information association proficient capacity of a lot of information questioning value-based support for simultaneous clients If you incorporate mixed media information mixed media is vast and may overwhelm other information mixed media information structures are totally not the same as standard database structures mixed media information structures don\'t effortlessly loan themselves to content-based looking

Slide 4

Data combination Databases as of now coordinate different sorts of information, numbers, dates, little content strings. They do this by the utilization of areas i.e. each nuclear esteem in the database has a place with one of a little number of sorts every sort has two perspectives: a scope of qualities which are worthy a few operations which are accessible

Slide 5

Cont … . the composition demonstrates an area for every part of the database and the DBMS authorizes the space limitation e.g. in a Relational Database, every segment is doled out an area Therefore a DBMS must give space sorts to any sort of information that they wish to house and theoverall structure will manage the combination

Slide 6

Domain sorts of MM information DBMS normally give three various types of space for sight and sound information: substantial protest areas, groupings of information frequently of two sorts Binary Large Objects – BLOBs – which are an unstructured arrangement of bytes Character Large Objects – CLOBs – which are an unstructured succession of characters document references – as opposed to holding the information, a record reference contains a connection to the information (OLE in Access) honest to goodness mixed media information sorts – (Oracle and Jasmine)

Slide 7

Cont … There is a critical distinction between the remainder of these and the initial two: interactive media information sorts display the likelihood of abusing the structure of the information for questioning and control expansive protests, best case scenario permit you to concentrate segments or to link them document references imply that the DBMS has no get to the information by any means

Slide 8

Querying MM information A DBMS allows a client to seek the database by substance e.g. give the name of the understudy with registration number 0123456 We might want to do likewise with mixed media information e.g. give the photos painted by Picasso or sound records with female vocalist hitting top C With standard information this is simple – numeric and string administrators are surely knew With interactive media information this is more troublesome and requires some technique for distinguishing substance of which there are two sorts:

Slide 9

Cont … programmed ID a calculation takes the information and returns a measure which can be analyzed – e.g. of darkness manual ID a man looks at the information and indexes it – e.g. in a table of pictures, there is a section for the photo and another for the painter

Slide 10

Types of Database There are three sorts of DBMS that may be utilized for lodging sight and sound information. Social DBMS store everything as First Normal Form tables all information things are nuclear and are held in rectangular tables information must be connected in the event that they are in one or in two records associated by a typical esteem (outside key) records are recognized just by substance it is troublesome (if not outlandish) to broaden the arrangement of spaces

Slide 11

Cont … Object-situated DBMS store everything as classes of items all information is held as segments of articles (like Java factors) information is connected by protest reference (i.e. one class variable has a sort which is another class and the estimations of that variable are cases of that class) the arrangement of classes is extensible thus you can openly make spaces

Slide 12

Cont … Object-social DBMS are in a general sense relations however are not First Normal Form the qualities in cells can be protest references and also nuclear values new sorts can be characterized

Slide 13

How would we be able to utilize these diverse sorts? In a social database, you can have: space sorts for huge articles utilizing a string sort for document names additional record sorts as in OLE in Access In a question situated database, you can have: uncommonly composed classes for interactive media In a protest social database, you can have: exceptionally outlined sorts for sight and sound

Slide 14

R sort database e.g. Get to and OLE Object Linking and Embedding was Microsoft\'s first design for incorporating documents of various sorts: Each record sort in Windows is connected with an application It is conceivable to put a document of one write inside another: either by entirely implanting the information in which case it is rendered by a module connected with the program or by setting a connection to the information in which case it is rendered by calling the first program Access works with this framework by giving a space sort to OLE • There\'s very little you can do with OLE fields since the information is in an organization that Access does not comprehend • You can connect the outside information to a report or a shape and little else

Slide 15

R databases e.g. BFILEs in Oracle The BFILE datatype gives access to BLOB documents of up to 4 gigabytes that are put away in record frameworks outside an Oracle database. The BFILE datatype permits read-just support of substantial twofold documents; you can\'t change a record through Oracle. Prophet gives APIs to get to document information.

Slide 16

Large Object Types in Oracle and SQL3 Oracle and SQL3 bolster three vast protest sorts: BLOB - The BLOB space sort stores unstructured parallel information in the database. BLOBs can hide away to four gigabytes of double information. CLOB – The CLOB area sort puts away to four gigabytes of single-byte character set information NCLOB - The NCLOB space sort stockpiles to four gigabytes of settled width and changing width multi-byte national character set information * SQL3 is a critical augmentation to standard SQL which transforms into a full protest based dialect

Slide 17

Cont … These sorts bolster Concatenation – making up one LOB by assembling two of them Substring – extricate a segment of a LOB Overlay – supplant a substring of one LOB with another Trim – evacuating specific characters (e.g. whitespace) from the earliest starting point or end Length – gives back the length of the LOB Position – gives back the position of a substring in a LOB Upper and Lower – transforms a CLOB or NCLOB into upper or lower case LOBs can just show up in a where condition utilizing "=", "<>" or "like" and not in gathering by or arrange by any means

Slide 18

Large Object Types in MySQL has four BLOB and four CLOB (called TEXT in MySQL) area sorts: TINYBLOB and TINYTEXT – amass to 256 bytes BLOB and TEXT – accumulate to 64K bytes MEDIUMBLOB and MEDIUMTEXT – save to 16M bytes LONGBLOB and LONGTEXT – put away to 4G bytes

Slide 19

Oracle interMedia Audio, Image, and Video Oracle interMedia underpins sight and sound stockpiling, recovery, and administration of: BLOBs put away locally in Oracle8i onwards and containing sound, picture, or video information BFILEs, put away locally in working framework particular record frameworks and containing sound, picture or video information URLs containing sound, picture, or video information put away on any HTTP server, for example, Oracle Application Server, Netscape Application Server, Microsoft Internet Information Server, Apache HTTPD server, and Spyglass servers Streaming sound or video information put away on specific media servers, for example, the Oracle Video Server

Slide 20

The Object Relational Multimedia Domain Types in interMedia gives the ORDAudio , ORDImage , and ORDVideo protest sorts and strategies for: updateTime ORDSource trait control controlling mixed media information source property data separating qualities from mixed media information getting and overseeing mixed media information from Oracle interMedia , Web servers, and different servers playing out a negligible arrangement of control operations on interactive media information (pictures just)

Slide 21

Cont … The properties accessible are: ORDImage – the tallness, width, information size of the on-plate picture, document sort, picture type,compression sort, and MIME sort ORDAudio – the organization, encoding, number of channels, inspecting rate, test size,compression sort, and sound term ORDVideo – the configuration, outline estimate, outline determination, outline rate, video span, number of edges, pressure sort, number of hues, and bit rate

Slide 22

Cont … Oracle additionally stores metadata including: source sort, area, and source name MIME sort and designing data attributes, for example, stature and width of a picture, number of sound channels, video outline rate, pay time, and so forth

Slide 23

OO databases – e.g. Jasmine is an Object-Oriented database and has an application known as Studio is its advancement surroundings It accompanies various implicit classes incorporate four sight and sound classes: Picture - Image – Video – Audio - These accompany control and pressure offices They likewise have been made to fit well with Java Media Framework

Slide 24

conclusions At present you can not do much with MM information, there are two explanations behind this: 1. It is expansive ordering on interactive media information is not sensible nor is putting away a default esteem other recovery might be backed off exchanges might be traded off 2. The properties are not surely knew or implementable in sensible time what is saying that one picture is before another all together in this way there are couple of administrators in the where condition that work

Slide 25

Cont .. Right now, there is no purpose behind putting sight and sound information into a

View more...