Oracle Database 11g The Complete Reference
- Kevin Loney
- 2008-10-15
Author: Kevin Loney
Publisher: McGraw Hill Professional
ISBN: 9780071598767
Category: Computers
Page: 1656
View: 122
The Definitive Guide to Oracle Database 11g Get 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 version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application ClustersAdvances in Databases and Information Systems
- Janis Grundspenkis
- 2010-03-25
Author: Janis Grundspenkis
Publisher: Springer Science & Business Media
ISBN: 9783642120817
Category: Business & Economics
Page: 271
View: 897
This book constitutes the thoroughly refereed past-workshop proceedings of the Associated Workshops and the Doctoral Consortium held as satellite events of ADBIS 2009, the 13th East European Conference on Advances in Databases and Information Systems in Riga, Latvia, in September 2009.Database Administration
- Craig S. Mullins
- 2012-10-11
Author: Craig S. Mullins
Publisher: Addison-Wesley
ISBN: 9780133012729
Category: Business & Economics
Page: 928
View: 605
Database Administration, Second Edition , is the definitive, technology-independent guide to the modern discipline of database administration. Packed with best practices and proven solutions for any database platform or environment, this text fully reflects the field’s latest realities and challenges. Drawing on more than thirty years of database experience, Mullins focuses on problems that today’s DBAs actually face, and skills and knowledge they simply must have. Mullins presents realistic, thorough, and up-to-date coverage of every DBA task, including creating database environments, data modeling, normalization, design, performance, data integrity, compliance, governance, security, backup/recovery, disaster planning, data and storage management, data movement/distribution, data warehousing, connectivity, metadata, tools, and more. This edition adds new coverage of “Big Data,” database appliances, cloud computing, and NoSQL. Mullins includes an entirely new chapter on the DBA’s role in regulatory compliance, with substantial new material on data breaches, auditing, encryption, retention, and metadata management. You’ll also find an all-new glossary, plus up-to-the-minute DBA rules of thumb.Oracle Essentials
- Rick Greenwald
- 2013-09-06
Author: Rick Greenwald
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449343170
Category: Computers
Page: 432
View: 714
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutionsLearn Database Systems with Implementation and Examples
- Imed Bouchrika
- 2014
Author: Imed Bouchrika
Publisher: Lulu.com
ISBN: 9781291688894
Category: Computers
Page: 181
View: 238
The main motivation behind writing this book is to teach the basic concepts of database systems through concrete and practical knowledge and examples without too many wordy and useless pages. The book is made deliberately concise and short covering the main aspects of databases that you have to master and gain either for industrial or academic purposes. The main chapters includes within this book are: Introduction to Databases, Database Design, SQL: Structured Query Language, SQL: Structured Query Language, SQL Transactions, Procedures & Triggers, Object Relational Databases, Databases & Java Programming, Solutions & Answers. The book website can be accessed at: http: //www.LearnDB.comOracle Database Performance and Scalability
- Henry H. Liu
- 2011-10-24
Author: Henry H. Liu
Publisher: John Wiley & Sons
ISBN: 9781118135518
Category: Computers
Page: 500
View: 404
The innovative performance and scalability features with each newer edition of the Oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal with Oracle performance and scalability issues throughout the entire life cycle of developing Oracle-based applications. Using real-world case studies to deliver key theories and concepts, the book introduces highly dependable and ready-to-apply performance and scalability optimization techniques, augmented with Top 10 Oracle Performance and Scalability Features as well as a supplementary support website.Oracle Database 12c The Complete Reference
- Bob Bryla
- 2013-10-02
Author: Bob Bryla
Publisher: McGraw Hill Professional
ISBN: 9780071801751
Category: Computers
Page: 1474
View: 443
"Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions"--Pro Oracle Spatial for Oracle Database 11g
- Ravikanth Kothuri
- 2012-01-03
Author: Ravikanth Kothuri
Publisher: Apress
ISBN: 9781430242888
Category: Computers
Page: 825
View: 366
Now available in paperback— Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address: The special nature of spatial data and its role in professional and consumer applications Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data The Oracle Spatial solution and the integration of spatial data into enterprise databases How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users When you read Pro Oracle Spatial for Oracle Database 11g, you’re learning from the very best. Ravi Kothuri is a key member of Oracle’s Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.Beginning Oracle Database 11g Administration
- Ignatius Fernandez
- 2009-03-25
Author: Ignatius Fernandez
Publisher: Apress
ISBN: 9781430206286
Category: Computers
Page: 448
View: 360
This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.Pro Oracle Database 11g Administration
- Darl Kuhn
- 2011-09-15
Author: Darl Kuhn
Publisher: Apress
ISBN: 9781430229711
Category: Computers
Page: 705
View: 199
Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won’t leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn’t about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. Condenses and organizes the core job of a database administrator into one volume. Takes a results-oriented approach to getting things done. Lays a foundation upon which to build a senior level of expertiseOracle Essentials
- Rick Greenwald
- 2007-11-01
Author: Rick Greenwald
Publisher: "O'Reilly Media, Inc."
ISBN: 0596555334
Category: Computers
Page: 409
View: 286
Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle CorporationOracle Business Intelligence Discoverer 11g Handbook
- Michael Armstrong-Smith
- 2013-11-05
Author: Michael Armstrong-Smith
Publisher: McGraw Hill Professional
ISBN: 9780071804318
Category: Computers
Page: 1152
View: 725
Master Oracle Business Intelligence Discoverer 11g Provide secure, immediate access to critical business information from relational and multidimensional data sources across your organization. Oracle Business Intelligence Discoverer 11g Handbook shows you how to optimize this intuitive ad hoc query, reporting, analysis, and web publishing tool for maximum performance. Real-world examples illustrate the powerful analysis, security, and reporting capabilities. Enable business users at all levels to make faster, more-informed decisions with help from this Oracle Press guide. Configure and manage Oracle Business Intelligence Discoverer 11g Run functional queries using the Workbook Wizard Add sorts, calculations, percentages, totals, and parameters using Oracle Business Intelligence Discoverer Plus Format queries into well-organized reports with graphs, tables, titles, headers, and footers Perform data analysis--statistical, classification, deviation, trend, and aging Use Oracle Business Intelligence Discoverer Viewer 11g to analyze, format, export, e-mail, and print reports Manage integration with Oracle WebLogic Server Refine existing queries using interactive pivoting, drilling, and hyper-drilling Build effective conditions and refine parameters, calculations, sorting, and percentages Manage access and sharing rights, scheduling privileges, and user preferences Build an end user layer and a business area using Oracle Business Intelligence Discoverer Administrator Use Oracle Enterprise Manager's Fusion Middleware Control feature to manage Oracle Business Intelligence Discoverer settings and preferences Implement powerful analytic functions using templates