Chimera: data sharing flexibility, shared nothing simplicity
Proceedings of the 15th Symposium on International Database Engineering & Applications
ADBIS'09 Proceedings of the 13th East European conference on Advances in Databases and Information Systems
Efficient data management in a large-scale epidemiology research project
Computer Methods and Programs in Biomedicine
| Hi-index | 0.00 |
The Definitive Guide to Oracle Database 11gGet full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.Install Oracle Database 11g or upgrade from an earlier versionCreate database tables, sequences, indexes, views, and user accountsConstruct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryptionImport and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result cachingAvoid human errors using flashback and automatic undo managementBuild and tune PL/SQL triggers, functions, and packagesDevelop database applications using Java, JDBC, and XMLOptimize availability and scalability with Oracle Real Application ClustersTable of contentsPART I: Critical Database ConceptsCh 1: Oracle Database 11g Architecture Options Ch 2: Installing Oracle Database 11g and Creating a DatabaseCh 3: Upgrading to Oracle Database 11gCh 4: Planning Oracle Applications—Approaches, Risks, and Standards PART II: SQL and SQL*PlusCh 5: The Basic Parts of Speech in SQLCh 6: Basic SQL*Plus Reports and Commands Ch 7: Getting Text Information and Changing It Ch 8: Searching for Regular Expressions Ch 9: Playing the NumbersCh 10: Dates: Then, Now, and the Difference Ch 11: Conversion and Transformation Functions Ch 12: Grouping Things TogetherCh 13: When One Query Depends upon Another Ch 14: Some Complex PossibilitiesCh 15: Changing Data: insert, update, merge, and deleteCh 16: DECODE and CASE: if, then, and else in SQLCh 17: Creating and Managing Tables, Views, Indexes, Clusters, and SequencesCh 18: Partitioning Ch 19: Basic Oracle Security PART III: Beyond the BasicsCh 20: Advanced Security—Virtual Private Databases Ch 21: Advanced Security: Transparent Data EncryptionCh 22: Working with TablespacesCh 23: Using SQL*Loader to Load Data Ch 24: Using Data Pump Export and Import Ch 25: Accessing Remote Data Ch 26: Using Materialized Views Ch 27: Using Oracle Text for Text Searches Ch 28: Using External TablesCh 29: Using Flashback Queries Ch 30: Flashback—Tables and Databases Ch 31: SQL ReplayPART IV: PL/SQLCh 32: An Introduction to PL/SQLCh 33: Online Application Upgrades Ch 34: TriggersCh 35: Procedures, Functions, and Packages Ch 36: Using Native Dynamic SQL and DBMS_SQL Ch 37: PL/SQL TuningPART V: Object-Relational DatabasesCh 38: Implementing Types, Object Views, and MethodsCh 39: Collectors (Nested Tables and Varying Arrays)Ch 40: Using Large ObjectsCh 41: Advanced Object-Oriented Concepts PART VI: Java in OracleCh 42: An Introduction to JavaCh 43: JDBC ProgrammingCh 44: Java Stored Procedures PART VII: Hitchhiker's GuidesCh 45: The Hitchhiker's Guide to Oracle Data DictionaryCh 46: The Hitchhiker's Guide to Tuning Applications and SQL Ch 47: SQL Result Cache and Client-Side Query Cache Ch 48: Case Studies in TuningCh 49: Advanced Architecture Options--DB Vault, Content DB, and Records DB Ch 50: Oracle Real Application ClustersCh 51: The Hitchhiker’s Guide to Database AdministrationCh 52: The Hitchhiker’s Guide to XML in OraclePart VIII Alphabetical ReferenceIndex