MySQL Database Usage and Administration: MySQL Database Usage and Administration

Date Added: 7/20/2011 12:08:40 AM | Visits: 32368

Securing SQL Server Protecting Your Database from Attackers: Securing SQL Server Protecting Your Database from Attackers

Date Added: 7/20/2011 12:06:33 AM | Visits: 32274

Database Replication: Database replication is widely used for fault-tolerance, scalability and performance. The failure of one database replica does not stop the system from working as available replicas can take over the tasks of the failed replica. Scalability can be achieved by distributing the load across all replicas, and adding new replicas should the load increase. Finally, database replication can provide fast local access, even if clients are geographically distributed clients, if data copies are located close to clients. Despite its advantages, replication is not a straightforward technique to apply, and there are many hurdles to overcome. At the forefront is replica control: assuring that data copies remain consistent when updates occur.

There exist many alternatives in regard to where updates can occur and when changes are propagated to data copies, how changes are applied, where the replication tool is located, etc. A particular challenge is to combine replica control with transaction management as it requires several operations to be treated as a single logical unit, and it provides atomicity, consistency, isolation and durability across the replicated system. The book provides a categorization of replica control mechanisms, presents several replica and concurrency control mechanisms in detail, and discusses many of the issues that arise when such solutions need to be implemented within or on top of relational database systems.

Date Added: 7/20/2011 12:05:27 AM | Visits: 32486

Database Modeling and Design: Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?

Date Added: 7/20/2011 12:04:19 AM | Visits: 32760

Database Modeling and Design: Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?

In the extensively revised fifth edition, you�ll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on�with design rules that are applicable to any SQL-based system. But you�ll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized

Date Added: 7/20/2011 12:02:27 AM | Visits: 31567

A Database Perspective: Modern applications are both data and computationally intensive and require the storage and manipulation of voluminous traditional (alphanumeric) and nontraditional data sets (images, text, geometric objects, time-series). Examples of such emerging application domains are: Geographical Information Systems (GIS), Multimedia Information Systems, CAD/CAM, Time-Series Analysis, Medical Information Sstems, On-Line Analytical Processing (OLAP), and Data Mining. These applications pose diverse requirements with respect to the information and the operations that need to be supported. From the database perspective, new techniques and tools therefore need to be developed towards increased processing efficiency.This monograph explores the way spatial database management systems aim at supporting queries that involve the space characteristics of the underlying data, and discusses query processing techniques for nearest neighbor queries. It provides both basic concepts and state-of-the-art results in spatial databases and parallel processing research, and studies numerous applications of nearest neighbor queries.

Date Added: 7/19/2011 11:26:26 PM | Visits: 33750

Conceptual Database Design: An Entity-Relationship: This comprehensive book is written to meet the needs of database designers, programmers, and end-users interested in maximizing the power of conceptual and logical design using the entity-relationship approach. The authors, internationally know experts in the field, thoroughly examine conceptual design, functional analysis, and logical design with an emphasis on issues related to the user and the application. The text presents a unique step-by-step design methodology that incorporates state-of-the art software engineering and database design techniques and includes a large, realistic case study that illustrates key concepts. A capstone chapter, written by Dr. David Reiner, provides a survey of database design tools including basic tools for conceptual and logical design and current commercial database design and CASE Tools.

Date Added: 7/19/2011 11:25:35 PM | Visits: 32807

Database Modeling and Design - Fifth Edition: Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?
In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems.

In-depth detail and plenty of real-world, practical examples throughout

Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system

Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data.

Date Added: 7/19/2011 11:19:01 PM | Visits: 33210

Conceptual Database Design: This comprehensive book is written to meet the needs of database designers, programmers, and end-users interested in maximizing the power of conceptual and logical design using the entity-relationship approach. The authors, internationally know experts in the field, thoroughly examine conceptual design, functional analysis, and logical design with an emphasis on issues related to the user and the application. The text presents a unique step-by-step design methodology that incorporates state-of-the art software engineering and database design techniques and includes a large, realistic case study that illustrates key concepts. A capstone chapter, written by Dr. David Reiner, provides a survey of database design tools including basic tools for conceptual and logical design and current commercial database design and CASE Tools.

Date Added: 7/19/2011 11:18:02 PM | Visits: 31779

Database Modeling and Design: Database systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs?
In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with design rules that are applicable to any SQL-based system. But you'll also get plenty to help you grow from a new database designer to an experienced designer developing industrial-sized systems.

In-depth detail and plenty of real-world, practical examples throughout

Loaded with design rules and illustrative case studies that are applicable to any SQL, UML, or XML-based system

Immediately useful to anyone tasked with the creation of data models for the integration of large-scale enterprise data.

Date Added: 7/19/2011 11:17:03 PM | Visits: 32805