• Expert Indexing in Oracle Database 11g maximum performance for your Database

    Expert Indexing in Oracle Database 11g maximum performance for your Database

    An index is an optionally created database object used primarily to increase query performance. The purpose of a database index is similar to an index in the back of a book. A book index associates a topic with a page number. When you’re locating information in a book, it’s usually much faster to examine the index first, find the topic of interest, and identify associated page numbers. With this information, you can navigate directly to...

     265 p cit 07/05/2013 125 1

  • Essential SQLAlchemy

    Essential SQLAlchemy

    If you’re an application programmer you’ve probably run into a relational database at some point in your professional career. Whether you’re writing enterprise client-server applications or building the next Web 2.0 killer application, you need someplace to put the persistent data for your application, and relational databases, accessed via SQL, are some of the most common places to put that data.

     230 p cit 07/05/2013 103 1

  • Beginning Database Design Solutions

    Beginning Database Design Solutions

    It has been estimated that more than 80 percent of all computer programming is database-related. This is certainly easy to believe. After all, a database can be a powerful tool for doing exactly what computer programs do best: store, manipulate, and display data. Even many programs that seem at first glance to have little to do with traditional business-oriented data use databases to make processing easier. In fact, looking back on more than...

     552 p cit 07/05/2013 105 1

  • A Developer’s Guide to Data Modeling for SQL Server COVERING SQL SERVER 2005 AND 2008

    A Developer’s Guide to Data Modeling for SQL Server COVERING SQL SERVER 2005 AND 2008

    As database professionals, we are frequently asked to come into existing environments and “fix” existing databases. This is usually because of performance problems that application developers and users have uncovered over the lifetime of a given application. Inevitably, the expectation is that we can work some magic database voodoo and the performance problems will go away. Unfortunately, as most of you already know, the problem often lies...

     299 p cit 07/05/2013 111 1

  • 50 Tip & Tricks for MongoDB Developers

    50 Tip & Tricks for MongoDB Developers

    Getting started with MongoDB is easy, but once you’re building applications with it more complex questions emerge. Is it better to store data using this schema or that one? Should I break this into two documents or store it all as one? How can I make this faster? The advice in this book should help you answer these questions.

     66 p cit 07/05/2013 94 1

  • Refactoring SQL Applications

    Refactoring SQL Applications

    THERE IS A STORY BEHIND THIS BOOK. I HAD HARDLY FINISHED THE ART OF SQL, WHICH WASN’T ON sale yet, when my then editor, Jonathan Gennick, raised the idea of writing a book about SQL refactoring. SQL, I knew. But I had never heard about refactoring. I Googled the word. In a famous play by Molière, a wealthy but little-educated man who takes lessons in his mature years marvels when he discovers that he has been speaking “prose” for all...

     297 p cit 06/05/2013 125 1

  • PostgreSQL 9 Administration Cookbook

    PostgreSQL 9 Administration Cookbook

    PostgreSQL is an advanced SQL database server, available on a wide range of platforms and is fast becoming one of the world's most popular server databases with an enviable reputation for performance, stability, and an enormous range of advanced features. PostgreSQL is one of the oldest open source projects, completely free to use, and developed by a very diverse worldwide community. Most of all, it just works!

     360 p cit 06/05/2013 117 1

  • PostgreSQL 9.0 High Performance

    PostgreSQL 9.0 High Performance

    PostgreSQL has become an increasingly viable database platform to serve as storage for applications, from classic corporate database use to the latest web apps. But getting the best performance from it has not been an easy subject to learn. You need just the right combination of rules of thumb to get started, solid monitoring, and maintenance to keep your system running well, suggestions for troubleshooting, and hints for add-on tools to add...

     468 p cit 06/05/2013 128 1

  • Oracle Primavera P6 Version 8: Project and Portfolio Management

    Oracle Primavera P6 Version 8: Project and Portfolio Management

    Oracle Primavera P6 is the most sophisticated and widely-used project portfolio management software in the world today. Some people think of P6 as simply a tool for scheduling projects, such as Microsoft Project, but on steroids. But while P6 can be used to plan a project a simple as writing one book, it can also be used to plan and manage a multi-year, globally-distributed set of engineering projects involving tens of thousands of workers,...

     348 p cit 06/05/2013 117 1

  • Oracle Primavera Contract Management, Business Intelligence Publisher Edition v14

    Oracle Primavera Contract Management, Business Intelligence Publisher Edition v14

    For years there has been a call to have a third-party book available for Oracle Primavera Contract Management (PCM). There are many "how-to" books written for Primavera P3-P6, why not for PCM? The problem with writing a "how-to" book for PCM is that the application can be configured in many different ways to accommodate the organization. Scheduling is scheduling; everyone performs that task pretty much the same way. However, there is no one...

     208 p cit 06/05/2013 99 1

  • Oracle Enterprise Manager Grid Control 11gR1: Business Service Management

    Oracle Enterprise Manager Grid Control 11gR1: Business Service Management

    Oracle Enterprise Manager Grid Control is a release of Oracle Enterprise Manager that's used to model and manage the entire Oracle Grid and beyond. It has capabilities to manage a number of databases and application servers, and can manage multiple instances of Oracle deployment platforms. Business Service Management (BSM) is a methodology for monitoring and measuring Information Technology (IT) services from a business perspective. The...

     360 p cit 06/05/2013 126 1

  • Instant Oracle Database and PowerShell How-to

    Instant Oracle Database and PowerShell How-to

    So why use Oracle and PowerShell together in the first place? Often there is a need to automate some work with Oracle that would be tedious to do manually in a large, graphical application such as Toad or SQL Developer. Command-line tools such as SQL*Plus exist, but do not provide the richness that PowerShell offers with its object-oriented pipeline that leverages the .NET framework and core Windows components.

     81 p cit 06/05/2013 123 1

Hướng dẫn khai thác thư viện số