Pro XML Development with Java Technology has been written to help you, the professional Java developer who needs a practical hands-on guide to marrying these technologies together effectively.Показать полностьюPro XML Development with Java Technology has been written to help you, the professional Java developer who needs a practical hands-on guide to marrying these technologies together effectively. There are a lot of books out there, but none really explore the combination deeply, and they are largely theoretical. The main objective here was to consolidate the theory and practice of XML and Java technologies in a single, up-to-date source, that is firmly grounded in underlying XML concepts, and can be consulted time and again to rapidly speed up enterprise application development! It covers all the essential XML topics, including XML Schemas, addressing of XML documents through XPath, transformation of XML documents using XSLT stylesheets, storage and retrieval of XML content in native XML and relational databases, web applications based on Ajax, and SOAP/HTTP and WSDL based Web Services. These XML topics are covered in he applied context of up-to-date Java technologies, including JAXP, JAXB, XMLBeans, and JAX-WS. You will find this book useful in building contemporary, service-oriented enterprise applications.

Everyone seems to be talking about Extensible Markup Language (XML) these days. You know how mothers are—I can’t even visit my relatives over the holidays without my mom broaching the topic of XML at Thanksgiving dinner.Показать полностьюEveryone seems to be talking about Extensible Markup Language (XML) these days. You know how mothers are—I can’t even visit my relatives over the holidays without my mom broaching the topic of XML at Thanksgiving dinner. Yes, XML has become quite a buzzword, but Extensible Stylesheet Language Transformations (XSLT) is the power that takes all this XML and turns it into something useful and flexible. XSLT is a language used to transform XML documents into something new. It can take one XML document and output that document’s information into a completely different structure or turn XML into an HTML document for viewing on the Web. XSLT isn’t a general-purpose programming language, such as Java or Visual Basic; its focus is solely on transforming XML. Before I get any farther along, I have to point out the “elephant in the room”—XSLT’s long-winded name. Who came up with that name anyway? I think the people responsible should be forced to say, “Extensible Stylesheet Language Transformations,” aloud ten times and hope their tongues don’t fall off! XSLT’s full name may be a mouthful, but this book carves up each piece of XSLT into manageable, chewable morsels.

Specific to using XML on Microsoft platforms thereby narrowing its focus and making it easier to become instantly productive. Focuses on using tools to create, edit, and transform the language and shows you how to use XML for Web site design and other real-world applications.

In addition to being a tutorial for learning how to use XML as an effective way to represent and transmit data across the Web, Professional XML Databases also covers how to work with XML in the current generation of Microsoft tools, like Internet Explorer and SQL Server 2000.Показать полностьюIn addition to being a tutorial for learning how to use XML as an effective way to represent and transmit data across the Web, Professional XML Databases also covers how to work with XML in the current generation of Microsoft tools, like Internet Explorer and SQL Server 2000. For any developer or manager who works with databases on the Windows platform, this book shows how you can delve into XML today for real projects. With endorsements from virtually every major vendor (including Microsoft), XML looks to be a compelling standard for sharing corporate data between organizations. Professional XML Databases examines how to integrate XML into your organization’s database infrastructure. Early sections concentrate on the rules and strategies for designing effective XML documents (DTDs) that mimic traditional tables (including links between tables). By providing almost a dozen rules on how to do this correctly, the book assures that you'll learn not only the basics of XML syntax but also the correct way to create DTDs that are efficient, easy to maintain, and readable across your business. (Further sections reverse this process and show you how to create database tables based on XML.) Subsequent sections cover many of the standards and APIs in today’s XML, from XML Schemas, the XML W3C Document Object Model (DOM), and the Simple API for XML (SAX), to related standards like XSLT, XPath, and XPointer. A number of books cover these APIs, but this one provides a unique focus by examining Microsoft tools and their support for XML. This means there is coverage of Microsoft ADO (and ADO+, now called ADO.NET) for querying databases and packaging the results as XML. Sections on SQL Server 2000 highlight ways to use XML in this product, both as results and through XML views. Closing sections explore options for working with XML for data warehousing and transmitting data efficiently across organizations. Sections on Java and the DB Prism (an open-source XML framework) help give this book a perspective that extends beyond the Microsoft platform. For any database developer or designer who needs to architect XML documents in order to share data in real projects, this advanced treatise on the right way to define and use XML will prove highly valuable. For anyone who uses SQL Server 2000, this book also points the way toward using XML standards in actual shipping products on the Microsoft platform.

This book discusses the administration of the disks and software components, and creation, administration, and security of the relational objects such as databases, tables, views, macros, triggers, indexes, and stored procedures, that make up your Teradata Relational Database Management System (RDBMS).Показать полностьюThis book discusses the administration of the disks and software components, and creation, administration, and security of the relational objects such as databases, tables, views, macros, triggers, indexes, and stored procedures, that make up your Teradata Relational Database Management System (RDBMS). Teradata RDBMS Database Administration is not a tutorial. The NCR Customer Education department provides courses on Teradata database administration among its offerings. You can visit the NCR Customer Education home page at http://www.ncr.com/services/svs_CustEd.htm to review or enroll in courses.

At present, a machine learning application is accomplished by carefully crafting a single table from an often complex, multi-table database. The metadata necessary to create this table is rarely formally recorded, and is sometimes implicit in the structure of the database or the typing of the attributes.Показать полностьюAt present, a machine learning application is accomplished by carefully crafting a single table from an often complex, multi-table database. The metadata necessary to create this table is rarely formally recorded, and is sometimes implicit in the structure of the database or the typing of the attributes. We categorize the types of metadata that we have encountered in our work with machine learning applications in agriculture, and describe a first generation tool that we have built to aid in the recording and use of metadata in database mining.

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.

The purpose of this manual is to give guidance on how to use the eighth edition of the book An Introduction to Database Systems — referred to throughout the manual as simply "the book," or "this book," or "the present book," or just “the eighth edition” — as a basis for teaching a database course.Показать полностьюThe purpose of this manual is to give guidance on how to use the eighth edition of the book An Introduction to Database Systems — referred to throughout the manual as simply "the book," or "this book," or "the present book," or just “the eighth edition” — as a basis for teaching a database course. The book is suitable for a primary (one- or two-semester) course at the junior or senior undergraduate or first-year graduate level; it also contains some more forward-looking and research-oriented material that would be relevant to a more advanced course. Students are expected to have a basic understanding of (a) the storage and file management capabilities (indexing, hashing, etc.) of a modern computer system, and (b) the features of a typical high-level programming language (Java, Pascal, C, PL/I, etc.).

The definitive guide to working with the powerful PostgreSQL open source database system. PostgreSQL leads the reader through the internals of the powerful PostgreSQL open source database.Показать полностьюThe definitive guide to working with the powerful PostgreSQL open source database system. PostgreSQL leads the reader through the internals of the powerful PostgreSQL open source database. Throughout the book, readers will find explanations of data structures and algorithms, each backed by a concrete example from the actual source code. Each section contains information about performance implications, debugging techniques, and pointers to more information (on Web and in book form). The reader will find an easy to read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to squeeze more performance from database applications.

Partial periodicity search, i.e., search for partial periodic patterns in time-series databases, is an interesting data mining problem. Previous studies on periodicity search mainly consider finding full periodic patterns, where every point in time contributes (precisely or approximately) to the periodicity.Показать полностьюPartial periodicity search, i.e., search for partial periodic patterns in time-series databases, is an interesting data mining problem. Previous studies on periodicity search mainly consider finding full periodic patterns, where every point in time contributes (precisely or approximately) to the periodicity. However, partial periodicity is very common in practice since it is more likely that only some of the time episodes may exhibit periodic patterns. We present several algorithms for efficient mining of partial periodic patterns, by exploring some interesting properties related to partial periodicity, such as the Apriori property and the max-subpattern hit set property, and by shared mining of multiple periods. The max-subpattern hit set property is a vital new property which allows us to derive the counts of all frequent patterns from a relatively small subset of patterns existing in the time series. We show that mining partial periodicity needs only two scans over the time series database, even for mining multiple periods. The performance study shows our proposed methods are very efficient in mining long periodic patterns.

"Building Database Driven Flash Applications"demonstrates how the capabilities of Flash programming can be combined with web back-end databases directly, without an intermediate layer of programming.Показать полностью"Building Database Driven Flash Applications"demonstrates how the capabilities of Flash programming can be combined with web back-end databases directly, without an intermediate layer of programming. Techniques for utilizing Flash presentation capabilities with the power of back end databases are covered in step-by-step detailed techniques are presented as well as complete "out-of-the-box" solutions that are ready to be utilized immediately.The purpose of “Building Database Driven Flash Applications” is to demonstrate techniques for controlling flash web front ends with data from database repositories. The treatment consists of several chapters of introduction that shows how to combine Flash and database technology. Then several chapters are provided of real world examples that utilize the techniques.

This essential desktop 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).Показать полностьюThis essential desktop 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 includes the command syntax (by vendor, if the syntax differs across implementations), a description, and practical examples. 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.

This remarkably comprehensive new book assembles concepts and results in relational databases theory previously scattered through journals, books, conference proceedings, and technical memoranda in one convenient source, and introduces pertinent new material not found elsewhere.Показать полностьюThis remarkably comprehensive new book assembles concepts and results in relational databases theory previously scattered through journals, books, conference proceedings, and technical memoranda in one convenient source, and introduces pertinent new material not found elsewhere. The book is intended for a second course in databases, but is an excellent reference for researchers in the field.. The material covered includes relational algebra, functional dependencies, multivalued and join dependencies, normal forms, tableaux and the chase computation, representation theory, domain and tuple relational calculus, query modification, database semantics and null values, acyclic database schemes, template dependencies, and computed relations. The final chapter is a brief survey of query languages in existing relational systems. Each chapter contains numerous examples and exercises, along with bibliographic remarks.

Efficient, high-quality data access code is crucial to the performance and usability of virtually any enterprise application-and there’s no better way to improve an existing system than to optimize its data access code.Показать полностьюEfficient, high-quality data access code is crucial to the performance and usability of virtually any enterprise application-and there’s no better way to improve an existing system than to optimize its data access code. Regardless of database engine, platform, language, or application, developers repeatedly encounter the same relational database access challenges. In Data Access Patterns, Clifton Nock identifies 25 proven solutions, presenting each one in the form of a clear, easy-to-use pattern. These patterns solve an exceptionally wide range of problems including creating efficient database-independent applications, hiding obscure database semantics from users, speeding database resource initialization, simplifying development and maintenance, improving support for concurrency and transactions, and eliminating data access bottlenecks.

Database Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field.Показать полностьюDatabase Management Systems provides comprehensive and up-to-date coverage of the fundamentals of database systems. Coherent explanations and practical examples have made this one of the leading texts in the field. The third edition continues in this tradition, enhancing it with more practical material. The new edition has been reorganized to allow more flexibility in the way the course is taught. Now, instructors can easily choose whether they would like to teach a course which emphasizes database application development or a course that emphasizes database systems issues. New overview chapters at the beginning of parts make it possible to skip other chapters in the part if you don't want the detail. More applications and examples have been added throughout the book, including SQL and Oracle examples. The applied flavor is further enhanced by the two new database applications chapters. — This text refers to the Hardcover edition.

World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren't database experts. No matter how messy or complex your business challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it. Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer.Показать полностьюWorld-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren't database experts. No matter how messy or complex your business challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it. Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling: practical insight for designing today’s increasingly important analytical applications. One task at a time, Riordan illuminates every facet of database analysis and design for both OLAP and OLTP, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability.

Database Systems: Design, Implementation, and Management, Fifth Edition takes you clearly and effectively through the entire process of database development and implementation.Показать полностьюDatabase Systems: Design, Implementation, and Management, Fifth Edition takes you clearly and effectively through the entire process of database development and implementation. The most comprehensive and detailed coverage of database basics is complemented with ample exercises and problems at the end of each chapter to encourage hands-on learning, and a two-chapter step-by-step running case. Because the Internet has become so firmly established as an extension of the everyday business data environment, this revised edition contains two new chapters, “Databases in Electronic Commerce” and "Web Database Development," that stress the need for solid planning and management in order to maximize the resources that the Internet provides.

TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features.Показать полностьюTOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster.Показать полностьюTuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one.

Advanced Topics in Database Research is a series of books on the fields of database, software engineering, and systems analysis and design. They feature the latest research ideas and topics on how to enhance current database systems, improve information storage, refine existing database models, and develop advanced applications.Показать полностьюAdvanced Topics in Database Research is a series of books on the fields of database, software engineering, and systems analysis and design. They feature the latest research ideas and topics on how to enhance current database systems, improve information storage, refine existing database models, and develop advanced applications. Advanced Topics in Database Research, Volume 5 is a part of this series. Advanced Topics in Database Research, Volume 5 presents the latest research ideas and topics on database systems and applications, and provides insights into important developments in the field of database and database management. This book describes the capabilities and features of new technologies and methodologies, and presents state-of-the-art research ideas, with an emphasis on theoretical issues regarding databases and database management.