Xem 1-20 trên 1691 kết quả Use databases
  • [ Team LiB ] Recipe 6.13 Implementing Pessimistic Concurrency Without Using Database Locks Problem You need the safety of pessimistic locking without the overhead of database locks. Solution Use extra columns and stored procedures as shown in the following examples.

    pdf14p luvpro 04-08-2010 65 6   Download

  • Systems Analysis and Design: Chapter 13 - Designing Databases's Objectives is Understand database concepts; Use normalization to efficiently store data in a database; Use databases for presenting data; Understand the concept of data warehouses.

    ppt64p cocacola_17 11-12-2015 7 1   Download

  • Chapter 1 of lecture Fundamentals of database systems include content: Types of databases and database applications, basic definitions, typical DBMS functionality, example of a database, main characteristics of the database approach, database users, advantages of using the database approach, when not to use databases.

    pdf5p kiepnaybinhyen_02 29-12-2015 5 1   Download

  • Chapter 8 - The era of big data: The topics discussed in this chapter are: databases, information systems, & artificial intelligence. managing files: basic concepts; database management systems; database models; data mining; the evolving world of big data; information systems in organizations: using databases to help make decisions; artificial intelligence; artificial life, the turing test, & the singularity.

    ppt63p tangtuy11 20-05-2016 2 1   Download

  • Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL....

    pdf690p thachnq 27-11-2009 1032 450   Download

  • This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle.......

    pdf284p nghianguyenluong 13-04-2009 775 278   Download

  • Oracle Database 11g contains several major innovations in the areas of change management, fault diagnosability, performance management, Data Guard administration, storage management, and data warehousing, among other areas. Besides the database administration changes, there are significant improvements in application development–related features, including natively compiled PL/SQL code, PL/SQL inlining, and enhanced triggers.

    pdf632p nghianguyenluong 30-06-2009 263 132   Download

  • SERVER-SIDE PROCESSING, which is when you let a server process your queries and the like, is probably a concept you have heard of and it’s the very topic of this chapter. Well, to some extent anyway. I discuss three specific ways of doing server-side processing: stored procedures, triggers, and views. The good thing about server-side processing is that you can use the power and resources of your server for doing purely data-related processing and thus leave your client free to do other stuff, and your network clearer of data that the client doesn’t want.

    pdf48p vutrung 03-09-2009 352 119   Download

  • This manual is intended for database administrators who perform backup and recovery of an Oracle database server. To use this document, you need to know the following:  Relational database concepts and basic database administration as described in Oracle Database Concepts and Oracle Database Administrator's Guide  The operating system environment under which you are running the Oracle database

    pdf216p vitconxinhdep 30-07-2009 332 115   Download

  • Many books in the documentation set use the sample schemas of the seed database, which is installed by default when you install Oracle. Refer to Oracle Database Sample Schemas for information on how these schemas were created and how you can use them yourself. Oracle error message documentation is only available in HTML. If you only have access to the Oracle Documentation CD, you can browse the error messages by range. Once you find the specific range, use your browser's "find in page" feature to locate the specific message.

    pdf586p vitconxinhdep 30-07-2009 291 98   Download

  • Database Design Using Entity-Diagram of Sikha relationships and Richard Earp Auerbach Publications Bagui © 2003 (242 pages) With this comprehensive guide, database designers and developers can quickly find understand all the ins and outs of ER diagrams to become expert database designers.

    pdf321p kyusuke 21-02-2010 281 82   Download

  • In Oracle Database, the OracleJVM has a new memory model for sessions that connect to the database through a dedicated server. Since a session using a dedicated server is guaranteed to use the same process for every database call, the Process Global Area is used for session specific memory and object allocations. This means that some of the objects and resources that used to be reclaimed at the end of each call can now live across calls.

    pdf218p thuxuan 03-08-2009 125 57   Download

  • Oracle Database Advanced Replication Management API Reference contains information that describes the features and functionality of the replication management API. Specifically, the Oracle Database Advanced Replication Management API Reference contains reference information for the packages in the replication management API, as well as examples of their use. In addition, Oracle Database Advanced Replication Management API Reference contains reference information about the replication catalog and other data dictionary views that are important for replication...

    pdf708p vitconxinhdep 30-07-2009 187 56   Download

  • Oracle Database Application Developer's Guide - Object-Relational Features describes how to use the object-relational features of the Oracle Server, 10g Release 1 (10.1). Information in this guide applies to versions of the Oracle Server that run on all platforms, and does not include system-specific information. Oracle Database Application Developer's Guide - Object-Relational Features is intended for programmers developing new applications or converting existing applications to run in the Oracle environment.

    pdf252p vitconxinhdep 30-07-2009 148 56   Download

  • The OPN System supports McKoi, Microsoft SQL Server, MySQL and Oracle databases. You select the database during the installation the OPN Systemô XT Server: either the embedded database (McKoi), or an external database. If you chose the embedded database, you can change to a different one by creating a new database and configuring it to be used with the OPN Systemô XT Server.

    pdf10p bichhuyen 19-06-2009 285 55   Download

  • For the purposes of this book, you also must install the AdventureWorks database for SQL Server 2005. This database, which contains data for a fictitious cycling company, is a totally new one specially designed and developed for SQL Server 2005 only. To start, you first install the AdventureWorks creation script, and then you create the database.

    pdf439p gmmiso88 26-07-2010 170 53   Download

  • After completing this lesson, you should be able to do the following: Explain the advantages of SQL Apply Explain when to use a logical standby database Create a logical standby database by using Enterprise Manager

    ppt30p nghianguyenluong 30-06-2009 193 52   Download

  • Oracle Database Application Developer’s Guide - Expression Filter provides usage and reference information about Expression Filter, a feature of Oracle Database that stores, indexes, and evaluates conditional expressions in relational tables. Application developers and DBAs can save time and labor by using Oracle Expression Filter to store and evaluate large sets of conditional expressions in the database.

    pdf134p vitconxinhdep 30-07-2009 136 47   Download

  • SQL*Plus is an environment in which you can  Execute SQL statements to retrieve, modify, add, and remove data from database tables.  Format, perform calculations on, store, and print query results in the form of reports.  Issue SQL statements to create, alter, and remove database tables.  Create anonymous blocks, subprograms, database triggers using procedural language extension, PL/SQL. SQL*Plus has a variety of commands you need to use to execute subprograms, pass values in and out of PL/SQL blocks, and debug your code.

    pdf50p duypha 12-08-2009 188 45   Download

  • Oracle Database Performance Tuning Guide is an aid for people responsible for the operation, maintenance, and performance of Oracle. This book describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.

    pdf572p rosesdalat2803 04-08-2009 111 40   Download

Đồng bộ tài khoản