Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • Safari Tech Books Online  (45)
  • Relational databases  (45)
Datasource
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    Microsoft SQL Server 2005 : changing the paradigm (2006)
    [Indianapolis, Ind.] : Sams Pub. | Boston, MA :Safari,
    Details
    Language: English
    Pages: xi, 487 p. , ill. ; , 24 cm
    Edition: SQL Server 2005 Public Beta ed.
    DDC: 005.7585
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) will prepare database administrators for upcoming changes in SQL Server 2005. Obtain the skills necessary to run SQL Server 2005 from the experts at Microsoft Gold Partner. Get a head-start to understanding the new concepts and features of SQL Server 2005 from the database administrator's perspective, including: SQL Server 2005 Architecture Tool Sets Scalability, Reliability and High Availability Chapter Performance Tuning Replication .NET CLR Integration DTS and Business Intelligence Minimize the surprises in SQL Server 2005 with the help of Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition) .
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672327783/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    Oracle database 10g insider solutions (2006)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xv, 467, [37] p. , ill. ; , 24 cm
    DDC: 005.7585
    Keywords: Oracle (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tuning. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.
    Note: "Covers release 2"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/0672327910/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    Microsoft SQL Server high availability (2005)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xi, 431 p. , ill. ; , 24 cm
    Keywords: Microsoft SQL Server. (Computer file) ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Offers example-based coverage for various high availability solutions. High availability is becoming an increasingly important topic for database administrators, data architects and system architects. Covers choosing, planning, implementing and administering a high availability solution along with the business justifications. Paul Bertucci has over 20 years of database experience including consulting for numerous Fortune 500 companies.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672326256/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Database in depth : relational theory for practitioners (2005)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xviii, 208 p. , ill. ; , 24 cm
    Keywords: Database management ; Relational databases ; Electronic books ; local
    Abstract: This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you: understand why and how the relational model is still directly relevant to modern database technology (and will remain so for the foreseeable future) see why and how the SQL standard is seriously deficient use the best current theoretical knowledge in the design of their databases and database applications make informed decisions in their daily database professional activities Database in Depth will appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models.Author C.J. Date has been involved with the relational model from its earliest days. An exceptionally clear-thinking writer, Date lays out principle and theory in a manner that is easily understood. Few others can speak as authoritatively the topic of relational databases as Date can.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0596100124/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    SQLite (2005)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvi, 313 p. , ill. ; , 23 cm
    DDC: 005.13/3
    Keywords: Database management ; PHP (Computer program language) ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: SQLite is a small, fast, embeddable database. What makes it popular is the combination of the database engine and interface into a single library as well as the ability to store all the data in a single file. Its functionality lies between MySQL and PostgreSQL, however it is faster than both databases. In SQLite , author Chris Newman provides a thorough, practical guide to using, administering and programming this up-and-coming database. If you want to learn about SQLite or about its use in conjunction with PHP this is the book for you.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/067232685X/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Understanding DB2 : learning visually with examples (2005)
    Upper Saddle River, NJ : IBM Press | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxx, 895 p. , ill. ; , 24 cm. +
    DDC: 005.75/65
    Keywords: IBM Database 2 ; Relational databases ; Electronic books ; local
    Abstract: The Easy, Visual Guide to IBM DB2 V8.2 IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. Understanding DB2 teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM. Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more. For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations. Coverage includes Understanding the DB2 product family, DB2 commands, and the DB2 environment Configuring client and server connectivity: walkthroughs of four typical scenarios Managing DB2 storage: partitions, tablespaces, buffer pools, and more Leveraging the power of SQL: queries, inserts, deletes, and updates Implementing security: encryption, authentication, and authorization Administering and maintaining data, from LOAD and EXPORT to backup/recovery Providing high availability with online split mirroring and suspended I/O DB2 architecture: process and memory models Managing database performance and troubleshooting
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0131859161/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Oracle DBA automation quick reference (2004)
    Upper Saddle River, NJ : Prentice Hall Professional Technical Reference | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 291 p. , ill. ; , 23 cm
    DDC: 005.75/6
    Keywords: Oracle (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: Fast, easy automation for every Oracle 9 i and 10 g DBA! Quick access to real-world examples Installation, database creation, management, monitoring, tuning, and backup/recovery Oracle Universal Installer (OUI), Oracle Net Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA) The fast, practical Oracle 9 i /10 g automation reference for every DBA! Automate Oracle-and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs... concise, straightforward, and incredibly easy to use . Discover proven solutions for automating installation, database creation, management, monitoring, tuning, backup/recovery, and more. Keep this book by your desk, near your server...wherever you need fast, reliable automation solutions right now ! Master scripting for both Oracle 9 i and Oracle 10 g ! Use Oracle Universal Installer to create response files for automating any installation Use Oracle Network Configuration Assistant (NetCA) to configure network components during installation Use Oracle Database Configuration Assistant (DBCA) to create and clone databases, and to reverse engineer them into templates and scripts Manage files and tablespaces, tune memory, perform backup/recovery, schedule automated administration tasks, and more Extend and customize any script to your own needs Includes concise reference to Perl DBI and its Oracle-specific components-with real-world examples and syntax
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    Sams teach yourself DB2 Universal Database in 21 days (2004)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 601 p. , ill. ; , 24 cm. +
    Edition: 2nd ed.
    DDC: 005.75/65
    Keywords: IBM Database 2 ; Relational databases ; Electronic books ; local
    Abstract: Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0672325829/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    High performance MySQL : optimization, backups, replication, and load balancing (2004)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvi, 276 p. , ill. ; , 23 cm
    Edition: 1st ed.
    DDC: 005.75/65
    Keywords: Database management ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include: A review of configuration and setup options Storage engines and table types Benchmarking Indexes Query Optimization Application Design Server Performance Replication Load-balancing Backup and Recovery Security
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596003064/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    Hibernate : a developer's notebook (2004)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xi, 176 p. , ill. ; , 24 cm
    DDC: 005.75/6
    Keywords: Relational databases ; Electronic books ; local
    Abstract: Do you enjoy writing software, except for the database code? Hibernate:A Developer's Notebook is for you. Database experts may enjoy fiddling with SQL, but you don't have to--the rest of the application is the fun part. And even database experts dread the tedious plumbing and typographical spaghetti needed to put their SQL into a Java program. Hibernate: A Developers Notebook shows you how to use Hibernate to automate persistence: you write natural Java objects and some simple configuration files, and Hibernate automates all the interaction between your objects and the database. You don't even need to know the database is there, and you can change from one database to another simply by changing a few statements in a configuration file. Hibernate: A Developer's Notebook walks you through the ins and outs of using Hibernate, from installation and configuration, to complex associations and composite types. Two chapters explore ways to write sophisticated queries, which you can express either through a pure Java API, or with an SQL-inspired, but object-oriented, query language. Don't let that intimidate you though: one of the biggest surprises in working with Hibernate is that for many of the common real-world application scenarios, you don't need an explicit query at all. If you've needed to add a database backend to your application, don't put it off. It's much more fun than it used to be, and Hibernate: A Developer's Notebook shows you why. Here's what a few reviewers had to say: "I'm sitting on an airplane after finishing Hibernate: A Developer's Notebook . It's rare to find a book on a new Java technology that you can get through on a domestic flight. That this notebook effectively and succinctly tackles object-relational mapping makes it, and Hibernate, even more impressive. Many books in this category would need to be checked luggage. With this book, you travel first class." --Mike Clark "A simple persistence framework deserves a simple book, and this one delivers. The examples are well described and easy to understand, yet sophisticated enough to demonstrate Hibernate in a real-world context. Jim, I'm a new fan." --Bruce Tate About the new Developer's Notebook Series from O'Reilly: Developer's Notebooks are a new book series covering important new tools for software developers. Developer's Notebooks stress example over explanation and practice over theory. They are about learning by doing; by experimenting with tools and discovering what w...
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596006969/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 11
    Online Resource
    Online Resource
    Oracle essentials : Oracle database 10g (2004)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 374 p. , ill. ; , 24 cm
    Edition: 3rd ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.The new edition of this classic book, Oracle Essentials, 3rd Edition: Oracle Database 10 g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more.Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle's Database 10 g --the industry's first database to support grid computing. Recent releases such as Oracle 9 i and 8 i are also covered. The book contains chapters on: Oracle products, options, and overall architecture for Oracle 10 g and prior recent releases Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes) Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery Oracle performance: characteristics of disk, memory, and CPU tuning Multi-user concurrency, online transaction processing (OLTP), and high availability Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing and distributed databases Network deployment: using Oracle as an Internet computing platform and for grid computing What's new in Oracle 10 g : a summary of the database changes described in the book Oracle Essentials, 3rd Edition: Oracle Database 10 g was written for anyone whose job involves managing or building systems using Oracle DBMS technology or working with staff that uses Oracle technology. This book is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.
    Note: "What you need to know about oracle database architecture and features"--Cover. - Includes bibliographical references (p. 347-355) and index
    URL: https://learning.oreilly.com/library/view/-/0596005857/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 12
    Online Resource
    Online Resource
    Oracle application server 10g essentials (2004)
    Beijing ; : O'Reilly Media, Inc. | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 262 p. , ill. ; , 23 cm
    Edition: 1st ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Application software ; Development ; Client/server computing ; Computer software ; Development ; Database management ; Computer programs ; Relational databases ; Web servers ; Electronic books ; local
    Abstract: The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server. This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server. More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.
    Note: "Architecture and components"--Cover. - Includes bibliographical references (p. 233-240) and index
    URL: https://learning.oreilly.com/library/view/-/0596006217/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 13
    Online Resource
    Online Resource
    SQL in a nutshell : [a desktop quick reference] (2004)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xv, 691 s
    Edition: 2. ed.
    Keywords: Database management ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell , Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.
    URL: https://learning.oreilly.com/library/view/-/0596004818/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 14
    Online Resource
    Online Resource
    Programming Oracle triggers and stored procedures (2004)
    Upper Saddle River, NJ : Prentice Hall Professional Technical Reference | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvi, 411 p. , ill. ; , 23 cm
    Edition: 3rd ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Computer software ; Development ; Relational databases ; Electronic books ; local
    Abstract: Complete tutorial for database developers! Thorough coverage of PL/SQL Practical "cookbook" techniques Effectively create and manage complex databases with Oracle! Systems and database expert Kevin Owens explores PL/SQL, Oracle's answer to the Structured Query Language (SQL), and teaches you what you need to know to build robust and complex databases for your business. Using easy-to-follow instructions and examples, this book presents techniques to take advantage of Oracle features such as triggers and stored procedures-features that allow your databases to incorporate business rules which are easy to manage and modify as the business evolves. Topics covered include: Viewing constraints in the data dictionary Complex rule enforcement PL/SQL program units and language features Data types and composite structure Error handling and exceptions Inter-process communications Declarative constraints, including primary key, unique, foreign key, check, and much more Programming Oracle Triggers and Stored Procedures, Third Edition, is an invaluable resource for database developers, designers, and project leaders looking to build and maintain truly intelligent, complex databases
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 15
    Online Resource
    Online Resource
    Microsoft SQL Server 2000 DBA survival guide (2003)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxvii, 1001 p. , ill. ; , 23 cm
    Edition: 2nd ed.
    DDC: 005.75/85
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0672324687/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 16
    Online Resource
    Online Resource
    Oracle PL/SQL language : pocket reference (2003)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: vi, 121 p. ; , 18 cm
    Edition: 2nd ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: Like most PL/SQL programmers, you've found Oracle PL/SQL Programming to be a reference book you can't do without. Packed with examples and recommendations, it's a book that has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. But you can't always carry it with you, and even at your desk there are times when you just need a reminder, a quick answer to a problem you're up against. For times like those, PL/SQL experts Stephen Feuerstein, Bill Pribyl, and Chip Dawes have written a new edition of Oracle PL/SQL Language Pocket Reference . Updated for Oracle9i, this little book is easy to take with you and use anywhere for quick problem solving. The second edition of the Oracle PL/SQL Language Pocket Reference boils down the most vital information from Oracle PL/SQL Programming into a convenient quick reference to PL/SQL basics. This compact book will be indispensable for new and seasoned Oracle database developers alike. It summarizes features available in Oracle9i and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have.
    URL: https://learning.oreilly.com/library/view/-/0596004729/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 17
    Online Resource
    Online Resource
    Database design for mere mortals : a hands-on guide to relational database design (2003)
    Boston : Addison-Wesley | Boston, MA :Safari,
    Details
    Language: English
    Pages: lii, 611 p. , ill. ; , 24 cm. +
    Edition: 2nd ed.
    DDC: 005.75/6
    Keywords: Database design ; Relational databases ; Electronic books ; local
    Abstract: "This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike's approach whilst simple is completely professional, and I can recommend this book to any novice database designer." - Sandra Barker , Lecturer, University of South Australia, Australia "Databases are a critical infrastructure technology for information systems and today's business. Mike Hernandez has written a literate explanation of database technology-a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better." - Michael Blaha , consultant and trainer, author of A Manager's Guide to Database Technology "If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn't have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!" - Matt Greer , Process Control Development, The Dow Chemical Company "Mike's approach to database design is totally common-sense based, yet he's adhered to all the rules of good relational database design. I use Mike's books in my starter database-design class, and I recommend his books to anyone who's interested in learning how to design databases or how to write SQL queries." - Michelle Poolet , President, MVDS, Inc. "Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you're just getting started developing with data or are a seasoned pro; whether you've read Mike's previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself-this is the book for you. Mike's ability to explain these concepts in a way that's not only clear, but fun, continues to amaze me." -From the Foreword by Ken Getz , MCW ...
    Note: Includes bibliographical references (p. 599-600) and index
    URL: https://learning.oreilly.com/library/view/-/0201752840/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 18
    Online Resource
    Online Resource
    Optimizing Oracle performance (2003)
    Sebastopol, CA ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxv, 388 p. , ill. ; , 23 cm
    Edition: 1st ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old. Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.The price of this essential book will be paid back in hours saved the first time its methods are used.
    Note: "A practitioner's guide to optimizing response time"--Cover. - Includes bibliographical references (p. 374-380) and index
    URL: https://learning.oreilly.com/library/view/-/059600527X/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 19
    Online Resource
    Online Resource
    Oracle PL/SQL : interactive workbook (2003)
    Upper Saddle River, N.J. : Prentice Hall PTR | Boston, MA :Safari,
    Details
    Language: English
    Pages: xviii, 662 p. , ill. ; , 24 cm
    Edition: 2nd ed.
    DDC: 005.75/65
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: Build Oracle PL/SQL applications-now. Fully updated for Oracle 9i No Oracle PL/SQL experience necessary. Real-life labs and "Test Your Thinking" Q&As Start developing applications with Oracle PL/SQL-fast. This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, exercises, projects, and a complete Web-based training site. Completely updated for Oracle 9i, it covers all the fundamentals-and a whole lot more. Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, and packaging-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates. Totally integrated with a FREE, state-of-the-art Oracle 9i learning Web site. Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more: "Test Your Thinking" project solutions and detailed explanations Additional self-review exercises with instant feedback and explanations An exclusive Virtual Study Lounge where you can interact with other students. Just the facts. No endless, boring discussions here. You'll learn hands on through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject. It's an integrated learning system that's proven to work. Dozens of exercises cover the real-world tasks that matter most. Hundreds of self-review questions and answers make sure you understand.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 20
    Online Resource
    Online Resource
    Java database best practices (2003)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvi, 267 p. , ill. ; , 23 cm
    Edition: 1st ed.
    Parallel Title: Erscheint auch als
    DDC: 005.13/3
    Keywords: Database design ; Java (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: When creating complex Java enterprise applications, do you spend a lot of time thumbing through a myriad of books and other resources searching for what you hope will be the API that's right for the project at hand? Java Database Best Practices rescues you from having to wade through books on each of the various APIs before figuring out which method to use! This comprehensive guide introduces each of the dominant APIs (Enterprise JavaBeans, Java Data Objects, the Java Database Connectivity API (JDBC) as well as other, lesser-known options), explores the methodology and design components that use those APIs, and then offers practices most appropriate for different types and makes of databases, as well as different types of applications. Java Database Practices also examines database design, from table and database architecture to normalization, and offers a number of best practices for handling these tasks as well. Learn how to move through the various forms of normalization, understand when to denormalize, and even get detailed instructions on optimizing your SQL queries to make the best use of your database structure. Through it all, this book focuses on practical application of these techniques, giving you information that can immediately be applied to your own enterprise projects.Enterprise applications in today's world are about data-- whether it be information about a product to buy, a user's credit card information, or the color that a customer prefers for their auto purchases. And just as data has grown in importance, the task of accessing that data has grown in complexity. Until now, you have been left on your own to determine which model best suits your application, and how best to use your chosen API. Java Database Practices is the one stop reference book to help you determine what's appropriate for your specific project at hand. Whether it's choosing between an alphabet soup of APIs and technologies--EJB, JDO, JDBC, SQL, RDBMS, OODBMS, and more on the horizon, this book is an indispensable resource you can't do without.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0596005229/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 21
    Online Resource
    Online Resource
    SQL performance tuning (2003)
    Boston, MA : Addison-Wesley | Boston, MA :Safari,
    Details
    Language: English
    Pages: xix, 495 p. , ill. ; , 24 cm
    DDC: 005.75/6
    Keywords: Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms. Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization-and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations. Topics covered include: General and specific tuning General sort considerations and options Joins and subqueries Columns and tables Indexes, including B-trees and bitmaps Constraints and stored procedures ODBC and JDBC Data changes and concurrency control (locking) Clients, servers, and middleware Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today's popular database environments. Throughout SQL Performance Tuning , ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical examples are written in ANSI/ISO Standard SQL: 1999. 0201791692B08082002
    Note: Includes bibliographical references (p. 453-454) and index
    URL: https://learning.oreilly.com/library/view/-/0201791692/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 22
    Online Resource
    Online Resource
    Oracle DBA SQL quick reference (2003)
    Upper Saddle River, NJ : Prentice Hall PTR | Boston, MA :Safari,
    Details
    Language: English
    Pages: xiv, 529 p. , ill. ; , 23 cm
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Database management ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: The Oracle SQL every DBA needs-fast and easy! Covers all the core day-to-day tasks DBAs are responsible for Quick access to SQL commands, operators, functions, data dictionary views, and more Includes dozens of easy-to-understand syntax diagrams The fast, practical Oracle SQL reference for every Oracle DBA! If you're a working Oracle DBA, here's the Oracle SQL reference you've been searching for-simple, straightforward, and incredibly easy to use! There's no faster way to discover the exact syntax you need...refresh your memory about that option you haven't used lately...find the name of that view you know exists...start using that new Oracle 9 i feature you haven't tried yet. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute! Covers Oracle SQL through Oracle9 i Release 2 Clear, well-organized tables of operators, functions, format models, privileges, and reserved words Complete command reference: syntax and options for every Oracle SQL command Standard "railroad" syntax diagrams make it easy to write correct syntax Handy listings of data dictionary views and dynamic performance tables
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 23
    Online Resource
    Online Resource
    Transact-SQL cookbook (2002)
    Sebastopol, CA ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xviii, 282 p. , ill. ; , 24 cm
    Edition: 1st ed.
    DDC: 005.756
    Keywords: Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: This unique cookbook contains a wealth of solutions to problems that SQL programmers face all the time. The recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Authors Ales Spetic and Jonathan Gennick, two authorities with extensive database and SQL programming experience, include a discussion with each recipe to explain the logic and concepts underlying the solution.SQL (Structured Query Language) is the closest thing to a standard query language that currently exists, and Transact-SQL -- a full-featured programming language that dramatically extends the power of SQL -- is the procedural language of choice for both Microsoft SQL Server and Sybase SQL Server systems. The Transact-SQL Cookbook is designed so you can use the recipes directly, as a source of ideas, or as a way to learn a little more about SQL and what you can do with it. Topics covered include: Audit logging. In addition to recipes for implementing an audit log, this chapter also includes recipes for: improving performance where large log tables are involved; supporting multiple-languages; and simulating server push. Hierarchies. Recipes show you how to manipulate hierarchical data using Transact-SQL. Importing data. This chapter introduces concepts like normalization and recipes useful for working with imported data tables. Sets. Recipes demonstrate different operations, such as how to find common elements, summarize the data in a set, and find the element in a set that represents an extreme. Statistics. This chapter?s recipes show you how to effectively use SQL for common statistical operations from means and standard deviations to weighted moving averages. Temporal data. Recipes demonstrate how to construct queries against time-based data. Data Structures. This chapter shows how to manipulate data structures like stacks, queues, matrices, and arrays. With an abundance of recipes to help you get your job done more efficiently, the Transact-SQL Cookbook is sure to become an essential part of your library.
    Note: "Help for database programmers"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/1565927567/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 24
    Online Resource
    Online Resource
    Oracle SQL*Plus : pocket reference (2002)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: vi, 113 p. ; , 18 cm
    Edition: 2nd ed.
    Keywords: Oracle (Computer file) ; Database management ; Query languages (Computer science) ; Relational databases ; SQL*PLUS (Computer program language) ; Electronic books ; local
    Abstract: SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, "Oracle SQL8Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQL*Plus Pocket Reference includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQL*Plus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.
    Note: "A guide to SQL*Plus syntax"--Cover. - "Covers Oracle9i"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/0596004419/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 25
    Online Resource
    Online Resource
    Oracle PL/SQL programming (2002)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxiii, 989 p. , ill. ; , 24 cm
    Edition: 3rd ed.
    DDC: 005.7585
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. This new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter--designed especially for experienced PL/SQL developers--describes PL/SQL's runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL. The book contains information about the latest Oracle9i PL/SQL features, including: Record-based DML: You can now use records in INSERT and DELETE statements. Table functions: These are functions that return a result set (in the form of a PL/SQL collection). Such functions existed in Oracle8i but they are now much expanded. New and improved datatypes: Oracle now offers dramatically improved support for timestamps, time zone management, and interval calculations. In addition, the XMLType datatype has now been implemented. Inheritance for object types: You can now define a hierarchy of object types (which were first introduced in Oracle8). Enhancements to PL/SQL collections. PL/SQL now supports multiple-level collections (nesting collections within collections), as well as associative arrays (previously called index-by tables), which allow you to index by PLS_INTEGER and VARCHAR2. Native compilation of PL/SQL code: PL/SQL source code can now optionally be compiled into native object code that is linked into Oracle. Part I, Programming in PL/SQL Part II, PL/SQL Program Structure Part III, PL/SQL Program Data Part IV, SQL in PL/SQL Part V, PL/SQL Application Construction Part VI, Advanced PL/SQL Topics The book is divided into six parts: Even if you've been a PL/SQL developer for years, you'll find an enormous amount of new and revised information in this third edition and on its companion web site. If you're new to PL/SQL, you'll find Oracle PL/SQL Programming an invaluable companion on the road to mastery.
    Note: Previous ed.: 1997. - Includes index
    URL: https://learning.oreilly.com/library/view/-/0596003811/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 26
    Online Resource
    Online Resource
    Oracle RMAN : pocket reference (2002)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: viii, 111 p. ; , 18 cm
    Edition: 1st ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Data recovery (Computer science) ; Electronic data processing ; Backup processing alternatives ; Relational databases ; Electronic books ; local
    Abstract: Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital. The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.
    Note: "Covers Oracle9i"--Cover
    URL: https://learning.oreilly.com/library/view/-/0596002335/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 27
    Online Resource
    Online Resource
    Perl for Oracle DBAs (2002)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvi, 602 p. , ill. ; , 24 cm
    Edition: 1st ed.
    DDC: 005.13/3
    Keywords: Oracle (Computer file) ; Perl (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal.You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities. The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate with Oracle databases. Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason. The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tasks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more. The book also explains how Oracle DBAs and developers can extend the toolkit and solve their own database administration problems using Perl.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596002106/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 28
    Online Resource
    Online Resource
    Oracle9i development by example (2002)
    Indianapolis, Ind. : Que | Boston, MA :Safari,
    Details
    Language: English
    Pages: xviii, 620 p. , ill. ; , 23 cm
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Computer software ; Development ; Relational databases ; Electronic books ; local
    Abstract: Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0789726718/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 29
    Online Resource
    Online Resource
    Managing and using MySQL (2002)
    Sebastopol, CA ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xiii, 425 p. , ill. ; , 24 cm
    Edition: 2nd ed.
    DDC: 005.756
    Keywords: Database management ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0596002114/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 30
    Online Resource
    Online Resource
    Oracle SQL*Loader : the definitive guide (2001)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 251 p. , ill. ; , 24 cm
    Keywords: Oracle (Computer file) ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: SQL Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8 i. The job of SQL Loader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.Almost every Oracle user has to use SQL Loader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQL Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL Loader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQL Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL Loader tasks you'd want to perform--and maybe some you didn't realize you COULD perform.You'll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You'll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQL Loader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQL Loader features--the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables). Oracle SQL Loader: The Definitive Guide is an indispensable resource for anyone who is new to SQLLoader; a task-oriented learning tool for those who are already using it; and a quick reference for every user. If you want to take best advantage of an essential Oracle tool, you need this book.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/1565929489/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 31
    Online Resource
    Online Resource
    Oracle PL/SQL best practices (2001)
    [Sebastopol, CA] : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xix, 182 p. , ill. ; , 23 cm
    Edition: 1st ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Database management ; Computer programs ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time. Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: How should I format my code? What naming conventions, if any, should I use? How can I write my packages so they can be more easily maintained? What is the most efficient way to query information from the database? How can I get all the developers on my team to handle errors the same way? The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site. Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.
    Note: "Optimizing Oracle code"--Cover. - Cover title. - Includes bibliographical references (p. xvi-xvii)
    URL: https://learning.oreilly.com/library/view/-/0596001215/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 32
    Online Resource
    Online Resource
    Unix for Oracle DBAs : pocket reference (2001)
    Beijing ; : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: v, 104 p. ; , 18 cm
    Edition: 1st ed.
    Keywords: Oracle (Computer file) ; UNIX (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: The Unix for Oracle DBAs Pocket Reference puts within easyreach the commands that Oracle database administrators need mostwhen operating in a Unix environment. If you are an Oracle DBAmoving to Unix from another environment such as Windows NT or IBMMainframe, you know that these commands are far different fromthose covered in most beginning Unix books. To jump start yourlearning process, Don Burleson has gathered together in thissuccinct book the Unix commands he most often uses when managingOracle databases. You'll be able to reach into your pocket for theanswer when you need to know how to: Display all Unix components related to Oracle,identify the top CPU consumers on your server, and even killprocesses when necessary Stack Unix commands into powerful scripts that canperform vital DBA functions Monitor Unix filesystems, and automatically manageyour trace files, dump files, and archived redo log files Use essential server monitoring commands such astop, sar, and vmstat And there's much more between these covers. If you need to get upto speed with Oracle on Unix, and quickly, this book is for you.
    Note: "Command syntax and scripts"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/0596000669/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 33
    Online Resource
    Online Resource
    Microsoft SQL Server 2000 programming by example (2001)
    Indianapolis, Ind. : Que | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 771 p. , ill. ; , 24 cm. +
    DDC: 005.75/85
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/0789724499/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 34
    Online Resource
    Online Resource
    Oracle essentials : Oracle9i, Oracle8i, and Oracle8 (2001)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 364 p. , ill. ; , 24 cm
    Edition: 2nd ed.
    DDC: 005.75/85
    Keywords: Oracle (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: The second edition of O'Reilly's bestselling Oracle Essentials has been updated to include the latest Oracle release, Oracle9 i. Oracle Essentials distills an enormous amount of information about Oracle's myriad technologies and releases into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. Oracle9 i promises to be an even more significant upgrade than Oracle8 i, offering such major features as Real Application Clusters, flashback queries, Oracle personalization, clickstream intelligence, and Oracle Database Cache and Web Cache; it also promises significant improvements in Oracle's business intelligence, XML integration, high availability, and management capabilities. The book includes overviews of these features, as well as the new Oracle9 I Application Server (Oracle9 i AS) and Oracle9 i Portal. The book contains chapters on: Oracle products, options, and overall architecture for Oracle9 i and other recent releases Installing and running Oracle: creating databases, configuring Net8 (known as Oracle Net in Oracle9 i ), starting up and shutting down Oracle Oracle data structures, datatypes, and ways of extending datatypes Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery Oracle networking, monitoring, and tuning Multi-user concurrency, online transaction processing (OLTP), and high availability Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing and distributed databases Oracle9 i , Oracle8 i , and the Web, including the latest Java, web, and XML technologies, interMedia, Oracle9 i Application Server, and Oracle9 i Portal For new Oracle users, DBAs, developers, and managers, Oracle Essentials is an all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle9 i features. But even if you already have a library full of Oracle documentation, this compact book is the one you'll turn to, again and again, as your one-stop, truly essential reference.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0596001797/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 35
    Online Resource
    Online Resource
    The practical SQL handbook : using SQL variants (2001)
    Boston : Addison-Wesley | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxxvi, 469 p. , ill. ; , 23 cm. +
    Edition: 4th ed.
    DDC: 005.75/6
    Keywords: Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: This latest edition of the best-selling implementation guide to the Structured Query Language teaches SQL fundamentals while providing practical solutions for critical business applications. The Practical SQL Handbook, Fourth Edition now includes expanded platform SQL coverage and extensive real-world examples based on feedback from actual SQL users. The Practical SQL Handbook begins with a step-by-step introduction to SQL basics and examines the issues involved in designing SQL-based database applications. It fully explores SQL's most popular implementations from industry leaders, Oracle, Microsoft, Sybase, and Informix. Highlights include: Detailed coverage of SQL commands for creating databases, tables, and indexes, and for adding, changing, and deleting data Using the SELECT command to retrieve specific data Handling NULL values (missing information) in a relational database Joining tables, including self joins and outer joins (ANSI and WHERE-clause syntax) Working with nested queries (subqueries) to get data from multiple tables Creating views (virtual tables) to provide customized access to data Using SQL functions A bonus CD-ROM contains a time-limited, full-feature version of the Sybase® Adaptive Server Anywhere™ software as well as the sample database, scripts, and examples included in the book. The Practical SQL Handbook is the most complete reference available for day-to-day SQL implementations. 0201703092B05222001
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0201703092/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 36
    Online Resource
    Online Resource
    e-Commerce applications using Oracle8i and Java from scratch (2000)
    Indianapolis, Ind. : Que | Boston, MA :Safari,
    Details
    Language: English
    Pages: ix, 384 p. , ill. ; , 23 cm
    Keywords: Oracle (Computer file) ; Electronic commerce ; Java (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: In Building e-Commerce Database Applications Using Oracle8i and Java from scratch, Meghraj Thakkar takes novice web programmers through the process of creating a web-enabled database application. You will look at the requirements, analysis, design, implementation, testing and deployment of an "Online Coffee Shop" from scratch. You will also learn to create database objects (tables and indexes), populate the database, and use SQL, PL/SQL and Java to manipulate the data. Additional topics include using Oracle tools such as SQL*Loader and Export/Import to populate Oracle databases, use of JDBC to connect and interact with the database, how to process the results coming back from the database, use of SQLJ to write efficient Java code, JDBC error messages & exceptional handling in the project, how to store Java code in the database using Java Stored Procedures, techniques for debugging & stress testing your applications, and more.
    Note: Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0789723387/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 37
    Online Resource
    Online Resource
    Oracle developer forms techniques (2000)
    Indianapolis, Ind. : Sams | Boston, MA :Safari,
    Details
    Language: English
    Pages: xii, 248 p. , ill. ; , 23 cm
    DDC: 005.75/65
    Keywords: Oracle (Computer file) ; Application software ; Development ; Relational databases ; Electronic books ; local
    Abstract: Oracle Developer Forms Techniques describes the concepts and techniques needed to build Web-enabled applications with Forms. The book covers advanced topics in great detail, including understanding and overcoming error handling limitations in Forms, such as errors which cannot be tracked through normal FORM_SUCCESS or FORM_FAILURE, ordering by items based on FK look-ups, obtaining Query Count without actually executing a query, and performing an exclusive server-side commit from Forms. The book also covers object-oriented methods in Forms, and Intelligence in Forms. Code segments are provided to help developers implement these techniques, thus easing application development time and effort.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 38
    Online Resource
    Online Resource
    Oracle SQL*Plus : pocket reference (2000)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: iv, 90 p. ; , 18 cm
    Edition: 1st ed.
    Keywords: Oracle (Computer file) ; Query languages (Computer science) ; Relational databases ; SQL*Plus (Computer program language) ; Electronic books ; local
    Abstract: This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8 i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide , into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. This book is an indispensable companion to O'Reilly bestselling book, Oracle SQL*Plus: The Definitive Guide , but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQL*Plus can perform, and provides a tutorial on many SQL*Plus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQL*Plus capabilities and a reminder of how to issue specific commands and formatting options for SQL*Plus. Table of Contents: Interacting with SQL*Plus Selecting Data Formatting Reports Tuning SQL SQL*Plus Format Elements SQL*Plus Command Reference
    Note: "Covers Oracle8i"--cover. - "Guide to SQL*Plus syntax"--cover
    URL: https://learning.oreilly.com/library/view/-/1565929411/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 39
    Online Resource
    Online Resource
    Oracle database administration : the essential reference (1999)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xvii, 560 p. , ill. ; , 24 cm
    Edition: 1st ed.
    DDC: 005.75/65
    Keywords: Oracle (Computer file) ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book. Visit the catalog page for Oracle Database Administration: The Essential RefeVisit the errata page for Oracle Database Administration: The Essential RefeDownload the supplemental electronic content for Oracle Database Administration: The Essential Refe
    Note: "A quick reference for the Oracle DBA"--Cover. - "Covers Oracle7 and Oracle 8"--Cover. - Includes bibliographical references (p. 523-526)
    URL: https://learning.oreilly.com/library/view/-/1565925165/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 40
    Online Resource
    Online Resource
    MySQL and mSQL (1999)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xv, 487 p. , ill. ; , 24 cm
    Edition: 1st ed.
    DDC: 005.75/85
    Keywords: Database management ; Relational databases ; SQL (Computer program language) ; Electronic books ; local
    Abstract: MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use. Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results. Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database. This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material. Topics include: Introductions to simple database design and SQL Building, installation, and configuration Basic programming APIs for C, C++, Java (JDBC), Perl, and Python CGI programming with databases in C and Perl Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl
    Note: "Databases for moderate-sized organizations & web sites"--Cover. - Includes index
    URL: https://learning.oreilly.com/library/view/-/1565924347/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 41
    Online Resource
    Online Resource
    Informix DBA survival guide (1999)
    Upper Saddle River, N.J. : Prentice Hall PTR ; | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxv, 501 p. , ill. ; , 23 cm. +
    Edition: 2nd ed.
    DDC: 005.75/65
    Keywords: Informix-SQL ; Relational databases ; Electronic books ; local
    Abstract: 7962C-5 If Informix is your database engine, this is your engine manual! There's practically no Informix problem you can't solve if you're willing to get "under the hood" and get dirty! That's the philosophy behind Informix Database Administrator's Survival Guide-and it's why the first edition became a worldwide Informix best-seller! Now, there's an all-new Second Edition, completely updated to reflect the new Informix 7 database engine. Better than ever, it contains over 150 pages of totally new debugging help-covering the Informix-Dynamic Server and Informix-Online database engines, utilities, SQL, ESQL/C code, and Informix's Windows NT products. With the guidance of expert Informix DBA Joe Lumbley, you'll master all this and more: How to perform Informix database tune-ups-step-by-step Making the most of logging, archiving, and client utilities Practical answers to dozens of the questions Informix DBAs ask most Leveraging the information stored in SMI tables Comprehensive coverage of the onstat-g commands Fundamental principles of Informix debugging Informix Database Administrator's Survival Guide, Second Edition brings together crucial information from thousands of pages of manuals-and make-or-break techniques that aren't in any manual. You'll discover all you need to know to successfully manage Informix-Dynamic Server on Windows NT and UNIX. You'll find exclusive coverage of Informix DBA tools and resources. You'll even learn how to manage the tough political and organizational issues that go with today's enterprise environments-all the "soft" skills you need to stay sane. Ask thousands of Informix DBAs: this is the one Informix book you simply don't want to be without! CD-Rom Included Bonus! Included free on the CD-ROM is a computer-based training course chosen especially for this book! CBT Systems is the leading provider of interactive training sotfware for IT professionals.
    Note: Rev. ed. of: Informix database administrator's survival guide. c1995
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 42
    Online Resource
    Online Resource
    Oracle PL/SQL language : pocket reference (1999)
    Sebastopol, CA : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: v, 94 p. , ill. ; , 18 cm
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: This pocket reference provides quick-reference information that will help you use Oracle's PL/SQL language. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling book, Oracle PL/SQL Programming , and includes coverage of the latest version of Oracle, Oracle8i. Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL provides procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. It offers a myriad of data types, and such features as cursors, loops, conditional and sequential control statements, exception handlers, records, tables, and constructs for developing modular code (functions, procedures, and packages). Originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. Now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. The book on which this pocket reference is based, Oracle PL/SQL Programming , filled a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL -- and building them the right way. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. The book is packed with strategies, code architectures, tips, techniques, and fully realized code. The second edition of the book updated the text with the new Oracle8 PL/SQL features, including object types, collections, external procedures, and large object data types and functions. The pocket reference boils down the most vital information from the large (nearly 1000 pages) book into an accessible quick reference that summarizes the basics of PL/SQL -- its block structure, fundamental language elements (e.g., identifiers, declarations, defaults), data structures (including Oracle8 objects), and statements for program control, loops, exception handling, and database access. It also covers the the basics of using Oracle's procedures, functions, and packages, and the latest features for Oracle8i.
    Note: Includes Oracle8
    URL: https://learning.oreilly.com/library/view/-/1565924576/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 43
    Online Resource
    Online Resource
    Oracle built-in packages (1998)
    Sebastopol : O'Reilly | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxi, 931 p. , ill. ; , 24 cm. +
    DDC: 005.75/65
    Keywords: Oracle (Computer file) ; Relational databases ; Electronic books ; local
    Abstract: Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, PL/SQL has taken the next step towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packages is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. for example: DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code. DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory. DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. 1. Introduction Executing Dynamic SQL and PL/SQL Intersession Communication User Lock and Transaction Management Oracle Advanced Queuing Generating Output from PL/SQL Programs Defining an Application Profile Managing Large Objects Datatype Packages Miscellaneous Packages Managing Session Information Managing Server Resources Job Scheduling in the Database Snapshots Advanced Replication Conflict Resolution Deferred Transactions and Remote Procedure Calls The first edition of Oracle PL/SQL Programming contained a chapter on Oracle's built-in packages. but there is much more to say about the basic PL/SQL packages than Feuerstein could fit in his first book. In addition, now that Oracle8 has been released, there are many new Oracle8 built-in packages not described in the PL/SQL...
    URL: https://learning.oreilly.com/library/view/-/1565923758/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 44
    Online Resource
    Online Resource
    Database design for mere mortals : a hands-on guide to relational database design (1997)
    Reading, Mass. : Addison-Wesley Developers Press | Boston, MA :Safari,
    Details
    Language: English
    Pages: xl, 440 p. , ill. ; , 23 cm
    DDC: 005.75/6
    Keywords: Database design ; Relational databases ; Electronic books ; local
    Abstract: Sound design can save you hours of development time before you write a single line of code. Based on the author's years of experience teaching this material, Database Design for Mere Mortals is a straightforward, platform-independent tutorial on the basic principles of relational database design. Database design expert Michael J. Hernandez introduces the core concepts of design theory and method without the technical jargon. Database Design for Mere Mortals will provide any developer with a common-sense design methodology for developing databases that work. 0201694719B04062001
    Note: Includes bibliographical references (p. 433) and index
    URL: https://learning.oreilly.com/library/view/-/0201694719/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 45
    Online Resource
    Online Resource
    Advanced Oracle PL/SQL : programming with packages (1996)
    Sebastopol, CA : O'Reilly & Associates | Boston, MA :Safari,
    Details
    Language: English
    Pages: xxvi, 661 p. ; , 24 cm. +
    Edition: 1st ed.
    Keywords: Oracle (Computer file) ; PL/SQL (Computer program language) ; Relational databases ; Electronic books ; local
    Abstract: Steven Feuerstein's first book, Oracle PL/SQL Programming , has become the classic reference to PL/SQL, Oracle's procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages -- and how to build them the right way. His "best practices" for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language. Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet's PL/Vision Lite is the first of its kind for PL/SQL developers: a library of thirty-plus PL/SQL packages. The packages solve a myriad of common programming problems and vastly accelerate the development of modular and maintainable applications. The packages provided in PL/Vision Lite fall into three categories: Building block packages: low-level development enhancers, including string parsers, a list manager, and an interface to PL/SQL tables. Developer utilities: programs that improve your PL/SQL development environment, including a code generator, a powerful substitute for SHOW ERRORS, and an online help delivery mechanism. Plug-and-play components: pieces of code that can be used as is in your own applications, including a high-level exception handler mechanism and a generic, reusable logging mechanism. In addition to describing the details of these packages, this book explores why and how they were built the way they were. You'll come away with an increased appreciation of the PL/SQL language and the power of packages. Most importantly, you'll be ready and eager to put that power to use immediately in your own applications.
    Note: "Oracle development language"--Cover. - Includes index. - Title on diskette: PL/Vision Lite : a companion reference for Advanced Oracle PL/SQL : programming with packages
    URL: https://learning.oreilly.com/library/view/-/1565922387/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...