Tuesday, 27 June 2017

How to cancel sent request in LinkedIn?

Follow this steps to cancel send request on LinkedIn
  • Login to your LinkedIn account
  • Now one by one click on following links
    1. My Network
    2. Manage All
    3. In Manage Invitation > Sent
    4. Withdraw  to cancel request for appropriate user, which whom you have sent request.



  • In Manage InvitationSent
  • Withdraw  to cancel request for appropriate user, which whom you have sent request.



Watch this video for more detail


Thursday, 22 June 2017

Multimedia Database Management System (MMDB)


  1. Multimedia Database Management System (MMDBMS)



MMDB

  1. What is Multimedia Database(MMDB)?

  2. • Multimedia database is a collection of related multimedia data such as TEXT, GRAPHIC, VIDEO, ANIMATION.
  3. • MMDB stores data in the form of, text, images, graphic, animation, audio and video.
  4. • A multimedia database is a database that include one or more primary media file types such as .txt (documents), .jpg (images), .swf (videos), .mp3 (audio), etc
  1. Evolution of MMDB
  2. Since existing relational and OO databases comprise(satisfy) the basic requirements of any database, but to store multimedia data -MMDB’s were evolved, that includes

  3. • Long bit, byte strings 
  4. • BLOBS 
  5. • paths or references of images where the actual image stored elsewhere, such as on an optical storage subsystem. 
  6. • Content retrieval capabilities.

  1. What Is Multimedia Database Management System (MMDBMS) ?
  2. It is a framework that manages different types of data potentially represented in a wide diversity of format on a wide array of media sources.
  3. It provides support for multimedia data types

  4. Provide facilitate for
  5.  1) Creation
  6.  2) Storage
  7.  3) Access
  8.  4) Query
  9.  5) Control of a multimedia database

  1. Contents of MMDB
  2. • Media data - actual data representing images, audio, video that are captured, digitized, processes, compressed and stored.
  3. • Media format data - contains format information of the media data after it goes through the acquisition, processing, and encoding phases.For instance, this consists of information such as the sampling rate, resolution, frame rate, encoding scheme etc.
  4. • Media keyword data - contains the keyword descriptions, For example, for a video, this might include the date, time, and place of recording , the person who recorded, the scene that is recorded, etc .This is also called as content descriptive data.

  5. • Media feature data - contains the features derived from the media data. For example, contain information about the distribution of colors, the kinds of textures and the different shapes present in an image. This is also referred to as content dependent data.

  6. The last three types are called meta data as they describe several different aspects of the media data.
  7. The media keyword data and media feature data are used as indices for searching purpose.
  8. The media format data is used to present the retrieved information.

          1. Types of multimedia data 
          2. • Text: using a standard language (HTML) 
          3. • Graphics: encoded in CGM, postscript • Images: bitmap, JPEG, MPEG 
          4. • Video: sequenced image data at specified rates 
          5. • Audio: aural recordings in a string of bits in digitized form

          6. Data types are categorized into 3 classes 
          7. • Static media 
          8.    time-independent 
          9.    image and graphic object 
          10. • Dynamic media 
          11.    time-dependent 
          12.    Audio, video and animation 
          13. • Dimensional media 
          14.     3D game and Computer Aided Drafting (CAD) programs.

          15. Characteristics of MMDM 
          16. • Corresponding Storage Media, Data must be stored & managed according to their specific      characteristics of the storage media
          17. • Descriptive Search Methods 
          18.    Query must be descriptive & content oriented 
          19. • View Specific & Simultaneous Data Access
          20.    Same data can be accessed through different queries by different applications 
          21. • Management of Large Amounts of data 
          22. • Data transfer of real time activity gets higher priority than other database activities 
          23. • Large transactions must be done in a reliable fashion, since it take long time.

          24. Requirements of Multimedia databases 
          25. • Integration 
          26.    Data items do not need to be duplicated for different programs invocations 
          27. • Data independence 
          28.    Separate the database and the management from the application programs
          29. • Concurrency control 
          30.    Allows concurrent transactions 
          31. • Persistence
          32.    Data objects can be saved and re-used by different transactions and program invocations 
          33. • Privacy 
          34.   Access and authorization control
          35. • Integrity control
          36.   Ensures database consistency between transactions 
          37. • Recovery 
          38.    Failures of transactions should not affect the persistent data storage 
          39. • Query support 
          40.    Allows easy querying of multimedia data

          41. Design goal of MMDB 
          42. • Manage different types of input, output, and storage devices
          43. • Handle a variety of data compression and storage formats 
          44. • Support different computing platforms and operating systems 
          45. • Integrate different data model.-(R database , OO database) 
          46. • Offer a variety of user-friendly query systems suited to different kinds of media. 
          47. • Handle different kinds of indices • Provide transparent view of geographically distributed data 
          48. • Synchronize different media types while presenting to user

          49. Data Structures 
          50. • Raw Data - Uncompressed Image 
          51. • Registering Data - Size & coding details of raw data 
          52. • Descriptive Data - Textual numerical annotations Media Raw Registering Descriptive Text 

          53. Characters Coding scheme (ASCII), length / end symbol Key words, information for structuring Images Pixels Height/ Width of picture, Mode of Compression, if JPEG, tables for quantization purpose Pic.Date = 21/04/07 Pic.Reason = Birthday Etc Video Pixels Frames/second, coding details, frame types… Scene description Audio Sample sequence Audio coding (PCM,…) , resolution of samples Content of audio passages in short form

          54. MM Database Architecture
          55. Querying MM data 
          56. • A DBMS permits a user to search the database by content e.g. give the name of the student with roll number 123456 We would like to do the same with multimedia data
          57. • e.g. Consider a police investigation of a murder case. give the picture of a this person or audio files to multimedia data library( contain CCTV footage, authorized telephone wiretaps, document data ,bank transition.) 
          58. • With standard data this is easy – numeric and string operators are well understood With multimedia data this is more difficult and requires some method of identifying contents of which there are two kinds:
          59.   1) Automatic identification an algorithm takes the data and returns a measure which can be compared – e.g. of blackness 
          60.   2) manual identification a person examines the data and catalogues it – e.g. in a table of pictures, there is a column for the picture and another for the painter

          61. Housing Multimedia Data 
          62. There are three kinds of DBMS that might be used for housing multimedia data. 
          63.  1) Relational DBMS store everything as First Normal Form tables 
          64.  2) Object-oriented DBMS store everything as classes of objects
          65.  3) Object-relational DBMS are fundamentally relations but are not First Normal Form

          66. Relational DBMS 
          67. Oracle support three large object types: 
          68.  • BLOB(Binary Large Objects – BLOB)
          69.     The BLOB domain type stores unstructured binary data in the database. BLOBs can store up to four gigabytes of binary data. 
          70.  • CLOB(Character Large Object)
          71.    CLOB data type stores large amounts of character data, up to 4 GB in size. The CLOB data type is similar to a BLOB, but includes character encoding, which defines a character set and the way each character is represented. BLOB data, on the other hand, consists of unformatted binary data.   
          72.  • NCLOB(National Character Large Object)
          73.     It is an Oracle data type that can hold up to 4 GB of fixed-width and varying width multi-byte national character set data . It's similar to a CLOB, but characters are from the national character set.

          74. Note :  Relational databases efficient for numeric and textual data store, but do not conveniently support content- based searches for multimedia content.

          75. Storing in Database 
          76.  Oracle InterMedia 
          77. Example: 
          78.      create table image_blob_table 
          79.      (
          80.          id number primary key,
          81.          image_blob BLOB
          82.      ); 

          83.      insert into image_blob_table 
          84.      (id,image_blob) 
          85.      values (1, “Path of image”) ;

          86. Object-oriented DBMS 
          87. • Jasmine is an Object-Oriented database that stores the data in form of classes and objects
          88. • It comes with a number of built in classes include four multimedia classes: 
          89.    - Picture
          90.    - Image
          91.    -  Video 
          92.    - Audio 
          93. • These come with manipulation and compression facilities. 
          94. • They also have been made to fit well with Java Media Framework

          95. Object-relational DBMS 
          96. • The BFILE data type in Oracle provides access to BLOB files of up to 4 GB that are stored in file systems outside an Oracle database. 
          97. • A BFILE is a data type used to store a locator (link) to an external binary file (file stored outside of the database)
          98. • The BFILE data type allows read-only support of large binary files; you cannot modify a file through Oracle. Oracle provides APIs to access file data.

          99. Example: 
          100. Create or Replace procedure
          101.  insert_image_file 
          102.  (
          103.    p_id NUMBER, 
          104.    p_image_name IN VARCHAR2
          105.  ) IS 
          106.  src_file BFILE; dst_file BLOB;
          107.  BEGIN src_file := BFILENAME ('image_DIR', p_image_name); 
          108.  INSERT INTO temp_image (ID, image_name, image )
          109.  VALUES (p_id, p_image_name, EMPTY_BLOB () )
          110.  RETURNING image INTO dst_file; 
          111.  END insert_image_file;

          112. Execute: 
          113.    EXECUTE insert_image_file(1,'test_image.jpg');

          114. Performance Issues MMDBMSs
          115. provides good performance for real-time querying and updating. Some of the features that influence this are: 
          116. Indexing - most DBs use single key access (B-trees) whereas, MM have multidimensional indexes with two dimensional objects have X and Y co-ordinates (R-trees)
          117. Content-Retrieval Indexing - special indexes are required for this. For example, the index for a video could contain the frame number of the start of each clip or scene.
          118. Query Optimization - MMDBs are large and manage many complex object providing query optimization

          119. Databases requires 
          120. • well structured data organisation 
          121. • efficient storage of large amounts of data 
          122. • Querying • Fast retrieval of request 
          123. • transactional support for concurrent users

          124. Issues and challenges
          125. • Multimedia data consists of a variety of media formats or file representations including TIFF, BMP, PPT, FPX, MPEG, AVI, MID, WAV, DOC, GIF,PNG,TEC 
          126. • Because of restrictions on the conversion from one format to the other, the use of the data in a specific format has been limited as well.
          127. • Usually, the data size of multimedia is large such as video; therefore, multimedia data often require a large storage.
          128. • Multimedia database consume a lot of processing time, as well as bandwidth.
          129. • multimedia data structures takes much time in retrieval than standard database structures 
          130. • multimedia data structures do not easily lend themselves to content-based searching

          131. Application
          132. • Digital Libraries 
          133.     Documentation and keeping Records 
          134.     Knowledge distribution 
          135.     Education and Training 
          136. • News-on-Demand 
          137.     Advertisement
          138.  • Video-on-Demand 
          139.     Entertainment 
          140. • Music database 
          141. • Geographic Information System 
          142. • Marketing