Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you. In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website! Detailed information on how to… Master web publishing Read and write basic HTML Read and write basic PHP Build a FileMaker database Install and configure FileMaker Server Publish your FileMaker data to the web Work with portals and container fields Repurpose your FileMaker layouts on the web Introduction 1

Many customer sites need to access data from both Windows and UNIX clients. For these environments, Data ONTAP has native multiprotocol support. After the user is authenticated on the network, if the user has both appropriate share or export permissions and the necessary file permissions, the user can access all data from UNIX hosts using NFS or from Windows hosts using CIFS. IBM System Storage N series allows users to access data from both types of clients by supporting multiple security models. This IBM Redbooks publication discusses those models in detail. It can help storage administrators in determining what type of data access configuration is appropriate for their environment.

This IBM Redbooks publication provides an overview of the IBM Tivoli Asset Management for IT portfolio. The portfolio is made up of the three primary products, IBM Tivoli Asset Management for IT, IBM Tivoli License Compliance Manager for z/OS, and IBM Tivoli License Compliance Manager. By using these products together, you can implement a comprehensive IT asset management solution. This book provides a functional overview of each of the products in the portfolio and also provides example scenarios of how they can be used to address IT asset management disciplines. The IBM Tivoli Asset Management for IT product is a relatively new acquisition. It has its roots in enterprise asset management and has very rich function. This product will be enhanced and adapted to provide functions specific to IT asset management, such as facilities to handle contract management, full asset life-cycle management, integration with Enterprise Resource Planning (ERP) solutions and much more. This book introduces the portfolio and describes its current capabilities. Our intention for the future is to provide additional materials for a deeper understanding of best practices for using the portfolio to implement a complete IT asset management solution.

In this IBM Redbooks publication, we provide an overview of Informix Dynamic Server (IDS) 11. IDS is designed to help businesses leverage their existing information assets as they move into an on demand business environment. Requirements here call for a flexible data server that can accommodate growth, in applications, data volume, and numbers of users. And it offers the capability to minimize downtime and to provide the high availability required today. A new suite of business availability functionality provides greater flexibility and performance, automated statistical and performance metric gathering, improvements in administration, and reductions in operating costs. The IDS technology enables efficient use of existing hardware and software, including single and multiprocessor architectures. And it helps you keep up with technological growth, including such things as the use of nontraditional data types. Built on the IBM Informix Dynamic Scalable Architecture™ (DSA), IDS provides a next-generation parallel data server architecture that delivers mainframe-caliber scalability; manageability and performance; minimal operating system overhead; and automatic workload distribution. IDS delivers a lower total cost of ownership (TCO) by leveraging its well-regarded general ease of use and systems administration. It enables customers to use information in new and more efficient ways to create business advantage.

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database. There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: Lose that data and your company could fail. Lose that data and you could be out of a job. Scared? You should be. But there's help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracle's backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide: Demystifies the steps required to protect your business data Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems Respects your time by providing example-based solutions, not endless reading material When the pressure's on, you don't have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence. What you'll learn Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to Reliably back up and recover your database using Oracle's Recovery Manager Utilize new Oracle Database 11g features such as the Data Recovery Advisor Let Oracle Database manage your backup files via the Flash Recovery Area Automate backup and recovery tasks by writing scripts Troubleshoot RMAN problems and optimize RMAN performance Interface with a Media Management Layer to manage your backup tape library Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations Who this book is for Oracle database administrators responsible for database backup and recovery operations.

Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL, without wasting time with obscure and obsolete features. Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule: cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL. Discover the 20% of PL/SQL that gives you 80% of the bang! Key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more. Learn how to write production-level, object-oriented PL/SQL. You'll explore relational PL/SQL, but unlike most other books on the subject, this one emphasizes the use of PL/SQLs object-oriented features as well. Work through real examples of using of PL/SQL. You'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.

Service-oriented architecture (SOA) is one of the most important topics on the agenda of any IT person. SOA involves a new vision of how to design, develop, and manage applications. It also has new requirements when building an architecture for the underlying infrastructure. This IBM Redbooks publication is the result of a project managed in the IBM European Design Center, based in Montpellier, France. The scope of the project involved helping a major worldwide customer in the automotive industry to validate and justify an SOA implementation. In particular, the customer wanted to add new business values to work with its partners, by adding new data models. It also wanted to modernize an infrastructure, by adding new Internet interfaces. The customer faced the need to eradicate an obsolete programming language. Furthermore, it wanted to build a smooth migration path, with as few risks and costs as possible. The thought, planning, and architecture of the new system, which included integration of the SOA concepts, was built by the customer with the participation of Atos Origin, a leading international IT services provider. The existing customer IT infrastructure was already built around UNIX systems, IBM System z, non-IBM clusters, SAP solutions, 3270 screens, IMS-DL/I databases, and specific code. SOA was the right solution to connect this existing environment to new components using Java, Web services, and DB2 in particular. This book explores the business needs and the architectural choices that were faced by the customer. It describes the mock-ups and prototypes, provides performance numbers that were used to validate the decisions, and explains how they were implemented. It also suggests a generic and riskless solution to eradicate the obsolete programming language.

Tivoli Continuous Data Protection for Files is specifically targeted at user computers, such as mobile computers and workstations, as well as file servers. It provides continuous data protection of files, providing the highest level of protection possible, yet is simple to use and administer. This IBM Redbooks® publication presents a deployment guide for Tivoli Continuous Data Protection for Files Version 3.1. We cover planning, installing, and troubleshooting of Tivoli Continuous Data Protection for Files for several use case scenarios. In addition, we provide some case studies, including integration with IBM Tivoli Storage Manager, that can be used as a proof of concept or demonstration of the product at a client environment. The target audience for this documentation is IT Specialists who will be working on Tivoli Continuous Data Protection for Files installations and proof of concepts.

This IBM® Redbooks® publication discusses how to optimize the IBM System Storage™ N series products with some of the major commercially available databases available to customers today. Topics include installation, performance, monitoring, and management when using the IBM System Storage N series with IBM DB2® , Microsoft® SQL, and Oracle® . We also cover best practices and tips for using the IBM System Storage N series with these major database applications.

PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. This book is perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books. With concepts explained in plain English, the new edition starts with the basics of the PHP language, and explains how to work with MySQL, the popular open source database. You then learn how to put the two together to generate dynamic content. If you come from a web design or graphics design background and know your way around HTML, Learning PHP & MySQL is the book you've been looking for. The content includes: PHP basics such as strings and arrays, and pattern matching A detailed discussion of the variances in different PHP versions MySQL data fundamentals like tables and statements Information on SQL data access for language A new chapter on XHTML Error handling, security, HTTP authentication, and more Learning PHP & MySQL explains everything from fundamental concepts to the nuts and bolts of performing specific tasks. As part of O'Reilly's bestselling Learning series, the book is an easy-to-use resource designed specifically for beginners. It's a launching pad for future learning, providing you with a solid foundation for more advanced development.

In a corporate environment, documents are usually created or captured in a decentralized environment with no overall surveillance. Many corporations have no formal process of retaining these documents as records, which can increase storage costs. In addition, when litigation requests occur, companies can spend a huge amount of money and resources to locate records. In the case when a company is not able to locate records or to locate them on a timely manner, the company is subjected to a financial penalty or, more importantly, damage to the company's reputation. IBM Records Manager is an application and an engine that provides records management capabilities to existing business applications. It provides a single and consistent records management platform to help companies meet government and industry requirements for formal records management. This IBM Redbooks publication provides an introduction to records management and IBM Records Manager. Solution architects, designers, and implementers who plan to implement IBM Records Manager will find this book useful. It also serves as a guide for system administrators or records administrators in performing common records management administration tasks in IBM Records Manager. Lastly, the first part of this book serves as a good starting point for anyone who is interested in exploring the world of records management.

Maybe you know FileMaker, and you have used it for years, but need a quick reference, immediately accessible while not interrupting your work on screen. This is the only book on the market expressly focused on describing each calculation formula and how and when to use each! Filled with real-world, concrete examples, this book is an invaluable companion to readers working to develop solutions to their every day software problems. Contains hundreds of calculation functions, script steps, and operations that will appeal to every FileMaker user, new and old.

FileMaker Pro 9: The Missing Manual is the clear, thorough and accessible guide to the latest version of this popular desktop database program. FileMaker Pro lets you do almost anything with the information you give it. You can print corporate reports, plan your retirement, or run a small country -- if you know what you're doing. This book helps non-technical folks like you get in, get your database built, and get the results you need. Pronto. The new edition gives novices and experienced users the scoop on versions 8.5 and 9. It offers complete coverage of timesaving new features such as the Quick Start screen that lets you open or a create a database in a snap, the handy "save to" buttons for making Excel documents or PDFs, the multiple level Undo and Redo commands let you step backwards through your typing tasks, and much more. With FileMaker Pro 9: The Missing Manual, you can: Each chapter in the book contains "living examples" -- downloadable tutorials that help you learn how to build a database by actually doing it. You also get plenty of sound, objective advice that lets you know which features are really useful, and which ones you'll barely touch. To make the most of FileMaker Pro 9, you need the book that should have been in the box. Get your first database running in minutes and perform basic tasks right away. Catalog people, processes and things with streamlined data entry and sorting tools. Learn to use layout tools to organize the appearance of your database. Use your data to generate reports, correspondence and other documents with ease. Create, connect, and manage multiple tables and set up complex relationships that show you just the data you need. Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas. Automate repetitive tasks with FileMaker Pro 9's easy-to-learn scripting language. Protect your database with passwords and set up privileges to determine what others can do once they gain entry. Outfit your database for the Web and import and export data to other formats.

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you’ll learn everything you need to know to take advantage of Microsoft SQL Server’s T-SQL language. This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more. You’ll learn what you need to know methodically, systematically, and simply–in highly focused lessons designed to make you immediately and effortlessly productive. Tips point out shortcuts and solutions Cautions help you avoid common pitfalls Notes explain additional concepts, and provide additional information 10 minutes is all you need to learn how to… Use T-SQL in the Microsoft SQL Server environment Construct complex T-SQL statements using multiple clauses and operators Filter data so you get the information you need quickly Retrieve, sort, and format database contents Join two or more related tables Make SQL Server work for you with globalization and localization Create subqueries to pinpoint your data Automate your workload with triggers Create and alter database tables Work with views, stored procedures, and more Register your book at www.samspublishing.com/register to download examples and source code from this book.

FileMaker Web Publishing offers an unparalleled development strategy for database managers, web designers, and programmers who are interested in getting the most out of FileMaker databases on the web. The book introduces the basics of HTML, cascading style sheets, and PHP, then moves on to specific concepts such as database portals, value lists, and complex navigation systems. Advanced topics include uploading and referencing files within the database and sending dynamically formatted emails.

SQL Server Compact Edition is a slimmed down version of SQL Server that you can use on Pocket PCs, Smart phones, Tablet PCs, and Desktops. With this book, you will learn how to build applications for resource constrained devices. You’ll discover how the SQL Server Compact Edition database can also be used as an embedded in-proc database for desktop-based applications. You’ll learn how to manage the SQL Server Compact Edition database using SQL Server Management Studio, Visual Studio, and Query Analyzer. Laptops, Tablet PCs, and mobile devices enable information workers to access enterprise data from remote locations. With the step-by-step exercises provided in this book, you’ll learn how to synchronize data between SQL Server and SQL Server Compact Edition. You’ll also learn Remote Data Access–a lightweight method to exchange data between SQL Server and SQL Server Compact Edition. Also in this book are code samples to help you write database applications for mobile devices and for desktop PCs. Throughout the book you’ll find expert tips for building and deploying enterprise applications. Understand how to… Build mobile and desktop applications using SQL Server Compact Edition Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition Optimize performance and plan for security Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access Introduction 1 1 Getting Started with SQL Server 2005 Compact Edition 7 2 Platform Support and Installation35 3 Getting to Know the Tools 63 4 Managing the SQL Server 2005 Compact Edition Database 109 5 Defining Database Structure 131 6 Manipulating the Database 175 7 Programming SQL Server 2005 Compact Edition with ADO.NET 205 8 Introducing Native Access 247 9 Using Operators in SQL Server 2005 Compact Edition 279 10 Using the Built-In Functions 295 11 Upgrading from a Previous Version 327 12 Synchronizing Data with Merge Replication 345 13 Synchronizing Data with Remote Data Access 411 14 Securing the SQL Server 2005 Compact Edition Database 459 15 SQL Server 2005 Compact Edition Performance Tuning 505 Index 551

This IBM Redbooks publication is intended for use by those generally familiar with most of the iSeries IBM-provided performance tools available through the i5/OS operating system’s commands and the additional cost Performance Tools for iSeries, 5722-PT1, licensed program. i5/OS comes with a detailed program level performance data collection capability called the Performance Explorer (PEX). i5/OS commands supporting the collection include Add PEX Definition, Start Performance Explorer, and End Performance Explorer. One of the Performance Explorer (PEX) collection options is called Statistics (STATS), which collects the program level performance statistics, including CPU usage, disk I/O activity, and the occurrence of certain i5/OS and System i microcode level events. The Print PEX Report function of 5722-PT1 provides a basic view of this STATS data. PEX Statistics provides a richer interface for collection and analysis of the *STATS performance data than is available through the i5/OS PEX command and the Print PEX Report output.

IBM Tivoli Dynamic Workload Broker is a key element in a comprehensive, on demand, Tivoli workload automation portfolio. It can use dynamic resource information as well as recommendations from other products to determine the best systems to which new jobs will be dispatched. This IBM Redbooks publication documents the architecture, installation and customization, operation best practices, performance optimization, high availability considerations, Web Services interface, and troubleshooting of Tivoli Dynamic Workload Broker V1.1. In addition, we cover integration scenarios with other IBM products, such as IBM Tivoli Workload Scheduler, IBM Tivoli Provisioning Manager, IBM Tivoli Change and Configuration Management Database, IBM Tivoli Monitoring, Tivoli Enterprise Portal, and IBM Enterprise Workload Manager. Finally, we discuss Tivoli Dynamic Workload Broker operation in a IBM Tivoli Workload Scheduler for a z/OS end-to-end environment. Clients and Tivoli professionals who are responsible for installing, administering, maintaining, or using IBM Tivoli Dynamic Workload Broker will find this book a major reference. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication provides an overview of IBM Information Server, its architecture, and processing flow. It describes the development and implementation of a financial services business scenario that showcases the Service Oriented Architecture (SOA) capabilities of the IBM Information Server product and WebSphere Integration Developer. It includes details on how a DataStage job, QualityStage job, Federated queries, and DB2 Stored Procedures can be surfaced as an SOA service. It describes the development of applications that consume the services generated by IBM Information Server and WebSphere Integration Developer using Rational Application Developer and Microsoft Visual Studio .NET Professional Edition. It is aimed at an audience of IT architects, Information Management specialists, and Information Integration specialists.

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the How to configure MySQL, such as setting the root password MySQL data types, including numerics, strings, dates, and complex types SQL syntax, commands, data types, operators, and functions Arithmetic, comparison and logical operators Aggregate and general functions Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers MySQL Pocket Reference is the book you want to have.