Learning MySQL and MariaDB

Sample

Michael Lee, Mike Mansfield

"Perfect companion to any SQL Server 2008 book, providing fast, accurate answers on the spot for millions of IT professionals System and database administrators, IT consultants, and database application developers often need quick answers and practical solutions for SQL Server issues. This convenient guide offers you quick referencing for the product and database topics you need most. If you're an IT administrator looking for the essentials in the day-to-day tasks of administering SQL Server 2008, you'll appreciate this book's design for providing quick and easy look up of solutions and tables, lists, and step-by-step instructions for answers on the spot. SQL Server 2008 Instant Administration Reference is a guide that you want to keep within reach. SQL Server is Microsoft's bestselling database manager; the 2008 version offers enhanced security and high availability, encouraging users to upgrade Features thumb tabs, secondary and tertiary tables of contents, and special heading treatments to provide quick and easy lookup, as well as quick-reference tables and lists to provide answers on the spot Covers installing, configuring, managing, and maintaining SQL Server; optimizing server performance; and troubleshooting SQL Server 2008 Administration Instant Reference answers the questions you encounter most often in your daily work"--Provided by publisher.

Sample

Michael Stonebraker with Dorothy Moore

Discover why object-relational technology is ideal for supporting a broad spectrum of data types and application areas, from financial services to multimedia data. In this completely revised and updated edition, database experts Michael Stonebraker and Paul Brown explore the object-relational paradigm and examine the most recent developments in the field. Specially written for database application programmers, database analysts, and IT managers, this book includes detailed information on how to classify DBMS applications, where object-relational DBMSs fit in the database world, and what mechanisms are required to support such an engine.

Sample

Jeffrey D. Ullman

1. The material on optimization has been expanded, by including a discussion of the System R approach to optimization, tableau-based methods, and optimization in the distributed environment. 2. There is a discussion of universal relation systems, which are relational database systems that support a user view that looks like a single relation. 3. Concurrency control by "optimistic," or timestamp-based methods has been introduced. 4. Distributed systems are covered, both for optimization issues and concurrency control. 5. A discussion of data structures for range queries appears. 6. There is an introduction to generalized dependencies and their inference. The second edition was prepared using Don Knuth's TEX typesetting system.

Sample

Dieter Fensel

Ontologies have been developed and investigated for some time in artificial intelligence to facilitate knowledge sharing and reuse. More recently, the notion of ontologies has attracted attention from fields such as databases, intelligent information integration, cooperative information systems, information retrieval, electronic commerce, enterprise application integration, and knowledge management. This broadened interest in ontologies is based on the feature that they provide a machine-processable semantics of information sources that can be communicated among agents as well as between software artifacts and humans. This feature makes ontologies the backbone technology of the next web generation, i.e., the Semantic Web. Ontologies are currently applied in areas such as knowledge management in large company-wide networks and call centers, and in B2C, B2G, and B2B electronic commerce. In a nutshell, ontologies enable effective and efficient access to heterogeneous and distributed information sources. Given the increasing amount of information available online, this kind of support is becoming more important day by day. The author systematically introduces the notion of ontologies to the non-expert reader and demonstrates in detail how to apply this conceptual framework for improved intranet retrieval of corporate information and knowledge and for enhanced Internet-based electronic commerce. He also describes ontology languages (XML, RDF, and OWL) and ontology tools, and the application of ontologies. In addition to structural improvements, the second edition covers recent developments relating to the Semantic Web, and emerging web-based standard languages.