Kategorien
E-Books
-
Wirtschaft
- Bitcoin
- Geschäftsfrau
- Coaching
- Controlling
- E-Business
- Ökonomie
- Finanzen
- Börse und Investitionen
- Persönliche Kompetenzen
- Computer im Büro
- Kommunikation und Verhandlungen
- Kleines Unternehmen
- Marketing
- Motivation
- Multimedia-Training
- Immobilien
- Überzeugung und NLP
- Steuern
- Sozialpolitik
- Handbȕcher
- Präsentationen
- Führung
- Public Relation
- Berichte, Analysen
- Geheimnis
- Social Media
- Verkauf
- Start-up
- Ihre Karriere
- Management
- Projektmanagement
- Personal (HR)
-
Für Kinder
-
Für Jugendliche
-
Bildung
-
Enzyklopädien, Wörterbücher
-
E-Presse
- Architektura i wnętrza
- Biznes i Ekonomia
- Haus und Garten
- E-Business
- Finanzen
- Persönliche Finanzen
- Unternehmen
- Fotografie
- Informatik
- HR und Gehaltsabrechnung
- Computer, Excel
- Buchhaltung
- Kultur und Literatur
- Wissenschaftlich und akademisch
- Umweltschutz
- meinungsbildend
- Bildung
- Steuern
- Reisen
- Psychologie
- Religion
- Landwirtschaft
- Buch- und Pressemarkt
- Transport und Spedition
- Gesundheit und Schönheit
-
Geschichte
-
Informatik
- Office-Programme
- Datenbank
- Bioinformatik
- IT Branche
- CAD/CAM
- Digital Lifestyle
- DTP
- Elektronik
- Digitale Fotografie
- Computergrafik
- Spiele
- Hacking
- Hardware
- IT w ekonomii
- Wissenschaftliche Pakete
- Schulbücher
- Computergrundlagen
- Programmierung
- Mobile-Programmierung
- Internet-Server
- Computernetzwerke
- Start-up
- Betriebssysteme
- Künstliche Inteligenz
- Technik für Kinder
- Webmaster
-
Andere
-
Fremdsprachen lernen
-
Kultur und Kunst
-
Lektüre
-
Literatur
- Anthologien
- Ballade
- Biografien und Autobiografien
- Für Erwachsene
- Drama
- Tagebücher, Memoiren, Briefe
- Epos
- Essay
- Science Fiction
- Felietonys
- Fiktion
- Humor, Satire
- Andere
- Klassisch
- Krimi
- Sachbücher
- Belletristik
- Mity i legendy
- Nobelpreisträger
- Kurzgeschichten
- Gesellschaftlich
- Okultyzm i magia
- Erzählung
- Erinnerungen
- Reisen
- Gedicht
- Poesie
- Politik
- Populärwissenschaftlich
- Roman
- Historischer Roman
- Prosa
- Abenteuer
- Journalismus
- Reportage
- Romans i literatura obyczajowa
- Sensation
- Thriller, Horror
- Interviews und Erinnerungen
-
Naturwissenschaften
-
Sozialwissenschaften
-
Schulbücher
-
Populärwissenschaft und akademisch
- Archäologie
- Bibliotekoznawstwo
- Filmwissenschaft
- Philologie
- Polnische Philologie
- Philosophie
- Finanse i bankowość
- Erdkunde
- Wirtschaft
- Handel. Weltwirtschaft
- Geschichte und Archäologie
- Kunst- und Architekturgeschichte
- Kulturwissenschaft
- Linguistik
- Literaturwissenschaft
- Logistik
- Mathematik
- Medizin
- Geisteswissenschaften
- Pädagogik
- Lehrmittel
- Populärwissenschaftlich
- Andere
- Psychologie
- Soziologie
- Theatrologie
- Teologie
- Theorien und Wirtschaftswissenschaften
- Transport i spedycja
- Sportunterricht
- Zarządzanie i marketing
-
Handbȕcher
-
Spielanleitungen
-
Professioneller und fachkundige Leitfaden
-
Jura
- Sicherheit und Gesundheit am Arbeitsplatz
- Geschichte
- Verkehrsregeln. Führerschein
- Rechtswissenschaften
- Gesundheitswesen
- Allgemeines. Wissenskompendium
- akademische Bücher
- Andere
- Bau- und Wohnungsrecht
- Zivilrecht
- Finanzrecht
- Wirtschaftsrecht
- Wirtschafts- und Handelsrecht
- Strafrecht
- Strafrecht. Kriminelle Taten. Kriminologie
- Internationales Recht
- Internationales und ausländisches Recht
- Gesundheitsschutzgesetz
- Bildungsrecht
- Steuerrecht
- Arbeits- und Sozialversicherungsrecht
- Öffentliches, Verfassungs- und Verwaltungsrecht
- Familien- und Vormundschaftsrecht
- Agrarrecht
- Sozialrecht, Arbeitsrecht
- EU-Recht
- Industrie
- Agrar- und Umweltschutz
- Wörterbücher und Enzyklopädien
- Öffentliche Auftragsvergabe
- Management
-
Führer und Reisen
- Afrika
- Alben
- Südamerika
- Mittel- und Nordamerika
- Australien, Neuseeland, Ozeanien
- Österreich
- Asien
- Balkan
- Naher Osten
- Bulgarien
- China
- Kroatien
- Tschechische Republik
- Dänemark
- Ägypten
- Estland
- Europa
- Frankreich
- Berge
- Griechenland
- Spanien
- Niederlande
- Island
- Litauen
- Lettland
- Mapy, Plany miast, Atlasy
- Miniführer
- Deutschland
- Norwegen
- Aktive Reisen
- Polen
- Portugal
- Andere
- Russland
- Rumänien
- Slowakei
- Slowenien
- Schweiz
- Schweden
- Welt
- Türkei
- Ukraine
- Ungarn
- Großbritannien
- Italien
-
Psychologie
- Lebensphilosophien
- Kompetencje psychospołeczne
- zwischenmenschliche Kommunikation
- Mindfulness
- Allgemeines
- Überzeugung und NLP
- Akademische Psychologie
- Psychologie von Seele und Geist
- Arbeitspsychologie
- Relacje i związki
- Elternschafts- und Kinderpsychologie
- Problemlösung
- Intellektuelle Entwicklung
- Geheimnis
- Sexualität
- Verführung
- Aussehen ind Image
- Lebensphilosophien
-
Religion
-
Sport, Fitness, Diäten
-
Technik und Mechanik
Hörbücher
-
Wirtschaft
- Bitcoin
- Geschäftsfrau
- Coaching
- Controlling
- E-Business
- Ökonomie
- Finanzen
- Börse und Investitionen
- Persönliche Kompetenzen
- Kommunikation und Verhandlungen
- Kleines Unternehmen
- Marketing
- Motivation
- Immobilien
- Überzeugung und NLP
- Steuern
- Handbȕcher
- Präsentationen
- Führung
- Public Relation
- Geheimnis
- Social Media
- Verkauf
- Start-up
- Ihre Karriere
- Management
- Projektmanagement
- Personal (HR)
-
Für Kinder
-
Für Jugendliche
-
Bildung
-
Enzyklopädien, Wörterbücher
-
Geschichte
-
Informatik
-
Andere
-
Fremdsprachen lernen
-
Kultur und Kunst
-
Lektüre
-
Literatur
- Anthologien
- Ballade
- Biografien und Autobiografien
- Für Erwachsene
- Drama
- Tagebücher, Memoiren, Briefe
- Epos
- Essay
- Science Fiction
- Felietonys
- Fiktion
- Humor, Satire
- Andere
- Klassisch
- Krimi
- Sachbücher
- Belletristik
- Mity i legendy
- Nobelpreisträger
- Kurzgeschichten
- Gesellschaftlich
- Okultyzm i magia
- Erzählung
- Erinnerungen
- Reisen
- Poesie
- Politik
- Populärwissenschaftlich
- Roman
- Historischer Roman
- Prosa
- Abenteuer
- Journalismus
- Reportage
- Romans i literatura obyczajowa
- Sensation
- Thriller, Horror
- Interviews und Erinnerungen
-
Naturwissenschaften
-
Sozialwissenschaften
-
Populärwissenschaft und akademisch
- Archäologie
- Philosophie
- Wirtschaft
- Handel. Weltwirtschaft
- Geschichte und Archäologie
- Kunst- und Architekturgeschichte
- Kulturwissenschaft
- Literaturwissenschaft
- Mathematik
- Medizin
- Geisteswissenschaften
- Pädagogik
- Lehrmittel
- Populärwissenschaftlich
- Andere
- Psychologie
- Soziologie
- Teologie
- Zarządzanie i marketing
-
Handbȕcher
-
Professioneller und fachkundige Leitfaden
-
Jura
-
Führer und Reisen
-
Psychologie
- Lebensphilosophien
- zwischenmenschliche Kommunikation
- Mindfulness
- Allgemeines
- Überzeugung und NLP
- Akademische Psychologie
- Psychologie von Seele und Geist
- Arbeitspsychologie
- Relacje i związki
- Elternschafts- und Kinderpsychologie
- Problemlösung
- Intellektuelle Entwicklung
- Geheimnis
- Sexualität
- Verführung
- Aussehen ind Image
- Lebensphilosophien
-
Religion
-
Sport, Fitness, Diäten
-
Technik und Mechanik
Videokurse
-
Datenbank
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersicherheit
-
Data Science
-
DevOps
-
Für Kinder
-
Elektronik
-
Grafik / Video / CAX
-
Spiele
-
Microsoft Office
-
Entwicklungstools
-
Programmierung
-
Persönliche Entwicklung
-
Computernetzwerke
-
Betriebssysteme
-
Softwaretest
-
Mobile Geräte
-
UX/UI
-
Web development
-
Management
Podcasts
- E-Books
- Informatik
- Datenbank
- Managing Multimedia and Unstructured Data in the Oracle Database. A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data
Details zum E-Book
Einloggen, wenn Sie am Inhalt des Artikels interessiert sind.
Managing Multimedia and Unstructured Data in the Oracle Database. A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data
E-book
Multimedia is the new digital frontier. Managers, software architects, administrators and developers need to fully comprehend this exciting new technology as its widespread use and acceptance cannot be ignored any longer.Managing Multimedia and Unstructured Data in the Oracle Database will give you a complete understanding of how to manage all data, especially multimedia. You will learn all the latest terminology, how to set up a database, load digital objects, search on them and even how to sell them. Whether you are a manager or database administrator, this book will give you the knowledge you need to take control of this rapidly growing and industry- changing technology. Technology which is transforming our lives.Starting with the basic principles of unstructured data and detailing the concepts behind multimedia warehouses and digital asset management systems, this book will describe how to load this data, search against it, display it intelligently, and deliver it to customers and users. Learn how all these concepts work within the Oracle 11g R2 database environment and how to tune the database effectively to manage it.Begin to learn about this new and exciting field and use it to give your business a competitive edge or give yourself the ability to take a leadership role in this exciting new computing genre.
- Managing Multimedia and Unstructured Data in the Oracle Database
- Table of Contents
- Managing Multimedia and Unstructured Data in the Oracle Database
- Credits
- About the Author
- Acknowledgement
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- Who this book is for
- Conventions
- Chapter References
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 1. What is Unstructured Data?
- Digital data
- Metadata
- Defining unstructured data
- Terminology
- Image
- Digital file
- Digital image
- Digital object
- Digital content
- Digital asset
- Digital material
- Digital library
- Analyzing the digital object
- Digital object types
- Core types
- Subtypes
- Picture
- Audio
- Model
- Creating new base types
- Document
- Video
- Multimedia (Rich Media)
- Data
- Simulation
- Genealogy
- Virtual digital object
- Digital object delivery
- Manipulating digital objects
- Conversion
- Transformation
- Extraction
- Compression
- Image comparison
- Badly compressed
- Thumbnail
- Transposition
- Searching
- Product group
- Location
- Terminology
- Defining multimedia in the Oracle database
- Photograph
- Video
- Audio
- Document
- Text
- Artifact
- Additional multimedia types
- Composite types
- Container
- ZIP files
- Metadata
- The NULL case
- Why store unstructured data in a database?
- Manageability
- Security
- Backup/recovery
- Integration
- Extensibility
- Flexibility
- Features
- Why not store the multimedia in the filesystem?
- Why use Oracle multimedia and not a blob?
- Addressing the concerns
- Performance
- Database size
- Complexity
- Summary
- Exercises
- Unstructured data conversion table
- Digital data
- 2. Understanding Digital Objects
- Definitions
- Raw format
- Compression
- Lossy data compression
- Lossless data compression
- Codec
- Container
- Understanding each image type
- Photo
- Icon
- Color space
- Color calibration
- The RGB color model family
- Viewing colors
- Printing using the CMYK colorspace
- Other color spaces
- Little endian and big endian
- Digital image storage formats
- Raster graphics formats
- Raw
- Vector graphics
- Audio
- Bit rate
- Encoding
- Channels
- Video
- Frame
- Frame resolution
- Frame aspect ratio
- Frame rate
- Progressive scan versus interlaced
- Codecs/containers
- Issues when converting
- Documents
- Terminology
- DOC/DOCX
- ODT
- TXT
- Transformation
- Terminology
- Photo
- Digital object composition
- The starting base NULL object
- The original image
- Indexed digital object
- Pyramid index
- Derivatives
- Masters
- Components
- Version hierarchies
- Relationships
- Unstructured data business cases
- Sporting club
- Charity
- Neighborhood watch
- News
- Food
- Government
- Summary
- Exercises
- Definitions
- 3. The Multimedia Warehouse
- Comparing
- The data warehouse
- Data consistency
- Logical Data Consistency
- Dilapidated warehouse
- Security
- Performance
- Information overload
- Data consistency
- Types of multimedia warehouses
- Traditional
- Image bank
- Data mart
- Public
- eSales
- Intelligence (security/defence)
- The data warehouse
- Structures
- Collections
- Groups
- Categories
- Lightbox
- Relationships
- Thesaurus
- Taxonomy
- Metadata standards
- Digital images
- IPTC
- EXIF
- XMP
- Audio
- ID3
- Relational
- CDWA Lite
- The Dublin Core metadata Initiative
- Darwin Core
- Media Art Notation System
- Digital images
- Image tagging
- Crowdsourcing
- Gaming techniques
- Data types
- Text
- Date
- Interval
- Time
- Season
- Circa
- Boolean
- Number
- Metric and imperial
- Accession number
- Name
- Address
- Filename
- Spatial co-ordinate
- Summary
- Exercises
- Comparing
- 4. Searching the Multimedia Warehouse
- Multilingual data
- Storing
- Diacritic
- Multiple languages
- Translating
- Security
- Searching
- Indexing performance
- Metadata based
- Image structure
- Electronic commerce
- False positives
- Stop words
- The living search
- Data mining
- Big O notation
- Representing the results
- Interface
- Visualize the results
- Tag cloud
- Infinite zoom
- Complex social network
- Tree map
- Lightbox
- VRML and SVG
- Synchronized Multimedia Integration Language (SMIL)
- HTML 5
- Adobe Flash
- Voice XML
- Other devices
- Braille devices
- Audio
- Search features
- Summary groups
- Workarea
- Non discriminatory search
- Result notification
- Restrict the results
- Control the output
- Audit search
- Designing a search language
- Search context
- Set theory primer
- Order of precedence
- Specialized query terms
- Spelling mistakes
- Sounds like
- Stem search
- Ranking
- Mandatory and other terms
- Word frequency
- The trouble with documents
- Autosuggest
- Search engine scalability
- Federated search
- Fuzzy searching
- Collaboration search
- Summary
- Exercises
- Multilingual data
- 5. Loading Techniques
- Loading methods
- Finding the images
- Pull method
- Vertical parallelism
- Horizontal parallelism
- Push method
- Cartridge method
- Pull method
- Loading method
- Metadata matches to digital object
- Digital object matches to metadata
- Mixed digital object and metadata
- Digital object no metadata
- Many masters
- Derivatives
- Matching existing data to images
- Filename encoding
- Data cleansing
- Loading decisions
- Types of loading
- Batch
- Hot folder
- Integration API
- Manual
- Types of loading
- Loading step-by-step
- Error handling
- Logical errors
- Loading via a workflow
- Error handling
- Summary
- Exercises
- 6. Delivery Techniques
- Securing an image
- Protection from theft
- Is it really theft?
- Modification
- Disruption
- Copying
- Theft
- Forgery
- Destruction
- Plagiarism
- Illegal access
- Replace
- Accidental
- Harvesting
- Other
- Protection methods
- Visible
- Preventive
- Bookmarking
- Reactive
- Auditable
- Self destruction
- Accept
- Legal proof
- A look at different business situations
- Copyright
- Greeting card
- Music
- Protection from theft
- Electronic commerce
- Not all browsers are the same
- IP address country tracking
- Order lifecycle
- Payment methods
- A comprehensive audit trail
- Locking down the price
- Post processing issue
- What are you buying?
- Price books
- Pricing options
- Price books
- Understanding the business rules
- Tax rule
- Download rule
- Pricing rule
- User fees rule (pricing calculator)
- Postage rule
- Mixed orders
- Split orders
- Combining items
- Free postage
- Pick up
- Negotiated
- Delayed
- Monitoring
- Payment rule
- Customer information rule
- Customer trigger rule
- Discount rule
- Refund rule
- Ticketing rule
- Integrated stock management
- Post-purchase workflow
- Summary
- Exercises
- Securing an image
- 7. Techniques for Creating a Multimedia Database
- Tier architecture
- Traditional no tier
- Two tier
- Three tier
- Virtualized architecture
- Mobile applications architecture
- Basic database configuration concepts
- ASMAutomated Storage Management
- Block size
- UNIFORM extent size and AUTOALLOCATE
- Locally managed tablespace UNIFORM extent size
- Temporary tablespace
- UNDO tablespace
- SYSTEM tablespace
- Redo logs
- Analysis
- Oracle Securefile architecture
- Enabling storage in row
- CHUNK
- Logging
- Cache
- Managing duplicate images
- Retention
- Lob compression
- Encryption
- Read-only tablespace
- Where does Oracle Multimedia fit in?
- Understanding the ORDSYS data types
- Creating a table
- How to query?
- Multimedia methods
- Creating a schema
- Oracle HTTP servers
- Configuring the Oracle embedded gateway
- Configuring Apache
- Basic diagnostics
- Windows
- Unix
- Basic diagnostics
- HTTPD.CONF file
- Virtual hosts
- Apache rewrites
- External locations and security
- Oracle directory
- Granting access to a directory
- UTL_FILE
- UTL_TCP
- Java
- Discussing Raid, SSD, SANs, and NAS
- Solid State Disk
- Raid 0: stripe across both disks
- Raid 1: mirror
- Raid 0+1: stripe then mirror
- Raid 1+0: mirrors then stripe
- Raid 5: parity check
- Raid 6: double parity check
- NAS
- SAN
- Solid State Disk
- Setting up Oracle XE to run Oracle Multimedia
- Summary
- Exercises
- Tier architecture
- 8. Tuning
- Introduction to tuning
- Tuning methodologies
- Reactive versus proactive (for the novice administrator)
- What is the role of the DBA?
- History
- Tuning trend
- Scalability
- Scalability is bidirectional
- Database breakpoints
- Locking
- CPU limits
- Memory limits
- Hardware limits
- Database limits
- Database management
- Backup/recovery
- Multimedia scalability
- Dimension 1 loading a large number of multimedia files
- Dimension 2 storing a large number of multimedia files
- Dimension 3 loading a very large multimedia file
- Dimension 4 retrieving a large number of multimedia files
- Dimension 5 database management
- General considerations
- Loading in parallel
- Insert/delete performance
- Extreme scalability
- Object-oriented development
- PC mentality
- The three tier ignore the database mentality
- Our application should be able to run against any database
- Basic tuning operations
- Network
- HTTPS
- VPN
- Efficiency in sending
- XML and web services
- Back to three tier and scalability
- Memory
- CPU
- I/O
- Parallelism
- Image loading
- Horizontal versus vertical parallelism
- Locking
- Database parameters
- plsql_code_type
- optimizer_mode
- Hints
- Backups
- Oracle partitioning
- Manual partitioning
- Indexing
- Photo
- Video
- Audio
- Documents
- Scalability using Oracle XE
- Breaking the rules with XE
- VM vSphere
- Scenario 1 - Separate install
- Scenario 2 - Replicated, high throughput
- Scenario 3 - Image server
- Network
- Summary
- Exercises
- 9. Understanding the Limitations of Oracle Products
- The basic requirements
- Acting as more than a filesystem
- Full backup/recovery
- Long term archival
- Data distribution and network balancing
- High speed and scalable image loading and processing
- Storage scalability to petabytes of data
- Flexible image delivery
- Security, auditing, and protection from user error (versioning)
- Supporting for most image types
- Litmus test
- Acting as more than a filesystem
- A comparison
- Oracle products
- Development
- SQL Developer (v3.1)
- SQL*Plus
- PL/SQL
- Supplied packages
- PL/SQL Web Toolkit
- SQL
- Java
- XML
- Edition-Based Redefinition
- Apex (Oracle Application Express)
- Storage
- Tablespaces and datafiles
- Storage parameters
- Partitioning
- ASM
- DBFS Filesystem
- Monitoring
- Enterprise Manager
- Resource management
- Database
- Data types
- Advanced compression
- OLAP
- Indexes
- Embedded gateway
- Data dictionary
- Heterogeneous gateway
- Tuning
- Automatic memory management
- Optimizer
- Networking
- Backup/Recovery
- Total recall (flashback)
- Redo logs and archives
- Data guard
- RMAN
- Utilities
- Streams
- Advanced replication
- Options
- Multimedia
- Spatial
- Text
- Semantics
- Warehouse
- Data Mining
- Security
- Encryption
- Data vault
- Oracle label security
- High availability
- RAC
- Exadata
- ZFS
- Development
- Summary
- The basic requirements
- 10. Working with the Operating System
- Why shell out?
- Unload and load digital objects
- How to shell out
- Java
- Scheduler
- Advanced queueing or pipes
- UTL_TCP
- Challenges when shelling out
- Synchronous or asynchronous?
- Hidden Ctrl + M characters on Unix
- Capturing output
- Parameters
- Dynamic shell scripts
- Windows program on processing, calls an actual window?
- Filesystem limitations
- Windows
- Powershell versus DOS
- LUN
- The variety of versions
- The Windows Services interface
- Windows 2012 and Windows 8
- Windows 2008 R2 and Windows 7
- Windows 2008 and Windows Vista
- Windows 2003
- Windows XP
- Windows 2000
- Unix
- How Unix differs from Windows
- The variety of versions
- Linux
- Ubuntu Linux
- Solaris
- IBM AIX
- HP-UX
- Summary
- Exercises
- A. The Circa Data Type
- Railroad diagram
- EBNF Syntax
- B. Multimedia Case Studies
- Museum A
- Department B
- Museum C
- Museum D
- Whole of government E
- Department F
- Museum H
- Photo laboratory G
- C. Proactive Database Tuning
- The environment and the DBA
- Ensuring optimal performance
- Cyclic maintenance
- Database review
- Forecasting
- Securing the database
- Data recovery
- The environment and the DBA
- D. Chapter References
- Chapter 1
- Chapter 2
- Chapter 3
- Chapter 4
- Chapter 8
- Chapter 9
- Chapter 10
- Index
- Titel: Managing Multimedia and Unstructured Data in the Oracle Database. A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data
- Autor: MARCEL KRATOCHVIL
- Originaler Titel: Managing Multimedia and Unstructured Data in the Oracle Database. A revolutionary approach to understanding, managing, and delivering digital objects, assets, and all types of data
- ISBN: 9781849686938, 9781849686938
- Veröffentlichungsdatum: 2013-03-21
- Format: E-book
- Artikelkennung: e_3ckl
- Verleger: Packt Publishing