"Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features" is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, "SQL:1999 - Understanding Relational Language Components," which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.

This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, "Advanced SQL:1999" will complete your knowledge and support your skills like no other book can.
* Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
* Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
* Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
* Covers the ongoing development of XML support.
* Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.

From seasoned developer and trainer Rob Macdonald comes "Serious ADO: Universal Data Access with Visual Basic," which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. "Serious ADO" covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers real-world code examples along with complete explanations of exactly what is occurring at each stage of the development process. This part also covers some of the key concepts upon which ADO programming is based, such as locking and transactions, connection pooling, marshalling, and Inter Process Communication, among others.

The second part of the book addresses the use of ADO in real-world development scenarios. Here, Macdonald demonstrates advanced user interface creation, including new ways to control the binding process. You'll also learn how to use Microsoft Transaction Server of COM+ applications to create transactional component-based systems.

Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.

SQL: A Beginner's Guide teaches you how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. The examples throughout the book walk you through real-world database tasks. If you want to get started programming in SQL right away, this is the ideal self-paced learning tool for you.

This Beginner's Guide is Designed for Easy Learning: Modules - Each programming concept is divided into logical modules (chapters), ideal for individualized learningGoals - Each module opens with the specific programming skills you'll have by the end of the moduleAsk the Experts - Q&A sections throughout are filled with extra information and interesting commentary1-Minute Drills - Quick self-assessment sections to check your progressAnnotated Syntax - Example code annotated with commentary that points to the particular technique illustratedProjects - Coding exercises contained in each module show how to apply what you are learningMastery Checks - End-of-module reviews that test your knowledge using short-answer, multiple-choice, fill-in-the-blank, and simple coding questions

This book constitutes the thoroughly refereed post-proceedings of the 9th International Workshop on Persistent Object Systems, POS-9, held in Lillehammer, Norway, in September 2001.The 19 revised full papers presented together with seven session overviews and an epilogue were selected during two rounds of reviewing and revision for inclusion in the proceedings. Among the topics addressed are persistence-enabled optimization, Java applications, JVM, systems architecture, persistent GIS, data sharing middleware, polylingual persistence, transactions, distributed object systems, object stores, garbage collectors, WWW and persistence, persistent computation implementation, orthogonally persistent Java, and personal information devices.

Cooperative Information Systems have emerged as a central concept in a variety of applications, projects, and systems in the new era of e-business. The conference at which the papers in this volume were presented was the ninth international conference on the topic of Cooperative Information Systems (CoopIS 2001), and was held in Trento, Italy on September 5-7, 2001. Like the previous conferences, CoopIS 2001 has been remarkably successful in bringing together representatives of many di?erent ?elds, spanning the entire range of e?ective web-based Cooperative Information Systems, and with interests ranging from industrial experience to original research concepts and results. The 29 papers collected here out of the 79 ones that were submitted, dem- strate well the range of results achieved in several areas such as agent te- nologies, models and architectures, web systems, information integration, m- dleware technologies, federated and multi-database systems. The papers th- selves, however, do not convey the lively excitement of the conference itself, and the continuing spirit of cooperation and communication across disciplines that has been the hallmark of these conferences. We would especially like to thank our keynote speakers: Philip A. Bernstein (Microsoft Research, USA), Edward E. Cobb (BEA Systems, USA), and Ma- izio Lenzerini (Universit'a di Roma "La Sapienza", Italy) for providing a portrait of the best contemporary work in the ?eld. We would also like to thank the many people who made CoopIS 2001 possible.

Welcome to 00lS'01 and Calgary! This is the 7th International Conference on Object-Oriented Information Systems (OOlS) that focus on Object-Oriented and Web-Based Frameworks for Information Systems. In the last few years we've seen significant new development in this field, from one-off design technologies to reusable frameworks, and from web applications to bioinformatic systems. We perceive that information processing is one of the most important activities of human beings. Object-orientation and frameworks have been the main-stream technologies for design and implementation of large-scale and complex information systems. Recent research advances and industrial innovations in information systems modeling and Internet applications have explored the new trends in shifting information system vendors from component and system developers to services providers. Users of information systems are increasingly demanding higher performance, mobility, and personalization in order to realize the dream to access and obtain necessary information anywhere and anytime. The new development requires the investigation of new architectures, frameworks, processes, and inter-connectivity of information systems at society, organization, team, and personal levels. The 00lS'01 Proceedings has put together a program of 53 papers from leading researchers and practitioners in the field of object technology and information systems.

Don't Let the Real Test Be Your First Test!

Practice Makes Perfect--Score Higher With The Most Effective Self-Test & Quick Review Program

More Questions--More ContentBased on Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition Exam (70-228) Coverage features quick review of all technology objectives and realistic exam questions to build your knowledge Exclusive "Exam Watch" features point out the most frequently missed questions--and how to answer them correctly

This book is not just another theoretical text on statistics or data mining. Instead, it's designed for database administrators who want to buttress their understanding of statistics to support data mining and customer relationship management analytics and who want to use Structured Query Language (SQL). Each chapter is independent and self-contained with examples tailored to business applications. Each analysis technique is expressed in a mathematical format that lends itself to coding either as a database query or as a Visual Basic procedure using SQL. Each chapter includes: formulas (how to perform the required analysis, numerical example using data from a database, data visualization and presentation options (graphs, charts, tables), SQL procedures for extracting the desired results, and data mining techniques.

This book covers the basic statistical and analytical techniques of computer intrusion detection. It is aimed at both statisticians looking to become involved in the data analysis aspects of computer security and computer scientists looking to expand their toolbox of techniques for detecting intruders. The book is self-contained, assumng no expertise in either computer security or statistics. It begins with a description of the basics of TCP/IP, followed by chapters dealing with network traffic analysis, network monitoring for intrusion detection, host based intrusion detection, and computer viruses and other malicious code. Each section develops the necessary tools as needed. There is an extensive discussion of visualization as it relates to network data and intrusion detection. The book also contains a large bibliography covering the statistical, machine learning, and pattern recognition literature related to network monitoring and intrusion detection. David Marchette is a scientist at the Naval Surface Warfacre Center in Dalhgren, Virginia. He has worked at Navy labs for 15 years, doing research in pattern recognition, computational statistics, and image analysis. He has been a fellow by courtesy in the mathematical sciences department of the Johns Hopkins University since 2000. He has been working in conputer intrusion detection for several years, focusing on statistical methods for anomaly detection and visualization. Dr. Marchette received a Masters in Mathematics from the University of California, San Diego in 1982 and a Ph.D. in Computational Sciences and Informatics from George Mason University in 1996.

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders.Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands.Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access.Together they make a great team, illuminating a tricky subject with substance and style.Reviews from the first edition of Inside Relational Databases:"Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own."- Neil Fawcett, Group Technical Editor, VNU Business Publications"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials."- Tamsin Todd, Computer & Internet Editor, Amazon.co.uk"Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."- Paul McGowan

Essential ColdFusion fast gives the reader a working knowledge of ColdFusion and how to use it and how it integrates with other web-based technologies. Lots of working examples are included throughout, all of which are also available via a web-site that is powered by ColdFusion, which shows exactly how they work.Matthew Norman has written a 'get started quick' guide to ColdFusion, in the style of the Essential series, describing the setting up of a development system. He talks about how to achieve this on a budget, using techniques that are applicable to large scale operations as well.Anyone with a working knowledge of the internet, and who wants to learn more about what ColdFusion does and how they can start using it quickly, will find this book a real help.

If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, "Code Centric: T-SQL Programming with Stored Procedures and Triggers" is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000such as UDFs (user-defined functions)you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

With the development of the World-Wide Web, data management problems have branched out from the traditional framework in which tabular data is processed under the strict control of an application, and address today the rich variety of information that is found on the Web, considering a variety of ?exible envir- ments under which such data can be searched, classi ed , and processed. Da- base systems are coming forward today in a new role as the primary backend for the information provided on the Web. Most of today's Web accesses trigger some form of content generation from a database, while electronic commerce often triggers intensive DBMS-based applications. The research community has begun to revise data models, query languages, data integration techniques, - dexes, query processing algorithms, and transaction concepts in order to cope with the characteristics and scale of the data on the Web. New problems have been identi ed , among them goal-oriented information gathering, management of semi-structured data, or database-style query languages for Web data, to name just a few. The International Workshop on the Web and Databases (WebDB) is a series of workshops intended to bring together researchers interested in the interaction between databases and the Web. This year's WebDB 2000 was the third in the series, and was held in Dallas, Texas, in conjunction with the ACM SIGMOD International Conference on Management of Data.

Small, special-purpose computing devices and high-end core Internet servers need fast, reliable database management. Berkeley DB is an embedded database that provides high-performance, scalable, transaction-protected and recoverable data management services to applications. Extremely portable, this library runs under almost all UNIX and Windows variants, as well as a number of embedded, real-time operating systems.

Berkeley DB is the ultimate resource for the world's most widely deployed embedded database engine. This book will aid software architects and engineers, product managers, and systems and network administrators without the overhead imposed by other database products.

Designed by programmers for programmers, this classic library style toolkit provides a broad base of functionality to application writers. This book will help you to make intelligent choices about when and how to use Berkeley DB to meet your needs.

You can visit the Sleepycat website to get the latest errata for this book.

NOTE: The first printing of this book contained an error in the table of contents that caused the page numbers to be off. This will be corrected in the second printing. If you have an earlier edition, you can download a pdf of the correct table of contents that you can print out and use with your book. If you have any questions, please feel free to contact the editor of this book at [email protected].

"SQL Server: Common Problems, Tested Solutions" consists of over 500 common and not-so-common questions that users of all versions of SQL Server are likely to ask. Most of these problems and solutions are either undocumented or poorly documented in Microsofts own literature. Answers are as concise and to the point as possible.

Each FAQ article in the book contains helpful information about the applicable SQL Server version, related FAQ articles, related Microsoft Knowledge Base articles, and other reference works. This book's dual indices and cross-references allow the reader to easily find related FAQ articles in other categories.

The book provides a unified presentation of algorithms for association rule and sequential pattern discovery. For both mining problems, the presentation relies on the lattice structure of the search space. All algorithms are built as processes running on this structure. Proving their properties takes advantage of the mathematical properties of the structure. Mining for association rules and sequential patterns is known to be a problem with large computational complexity. The issue of designing efficient parallel algorithms should be considered as critical. Most algorithms in the book are devised for both sequential and parallel execution. Parallel algorithm design takes advantage of the lattice structure of the search space. Partitioning is performed via lattice recursive bisection. Database partitioning is also used as an additional source of parallelism.Part of the motivation for writing this book was postgraduate teaching. Since the book only assumes elementary mathematical knowledge in the domains of lattices, combinatorial optimization, probability calculus, and statistics, it is fit for use by undergraduate students as well. The algorithms are described in a C-like pseudo programming language. The computations are shown in great detail. This makes the book also fit for use by implementers: computer scientists in many domains as well as industry engineers.

Design, deploy, and manage stored procedures in enterprise data applications

SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design, debug, and manage custom stored procedures, functions, and triggers. You'll learn to manage SQL Server resources using new features of Enterprise Manager, Query analyzer, Visual Basic, and Visual Studio, implement robust error handling, and establish the professional habits you need to become an expert SQL Server developer. This guide contains simple explanations for developers who are just starting to work with stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server experts provide concise explanations, design recommendations, many examples, and a real-world case study.Design user-defined, system, temporary, global temporary, extended, remote, and nested stored proceduresAdopt tips and tricks using identity, timestamp, sql_variant, uniqueidentifier, optimistic locking, dynamically constructed queries, temporary tables, and cursorsWrite code to interact with COM, mai, executables, the Registry, jobs, and securityManage application securityLocate and fix semantic errors using TSQL Debugger in Query Analyzer, Visual Basic, or Visual Studio, and using manual debugging techniquesCreate user-defined, table-valued, and in-line functionsDesign instead-of triggers and after triggersManage transactions and locksDevelop dynamic, Web-based applications using SQL Server's XML capabilities

Datamanagementsystemsforlargeapplicationsseekinfrastructuralsupport fromdatabasesystemsanddistributedcomputingsystems. Thesesystems- provewiththechangingrequirementsofapplications. Newresearche?ortsare beingmadetosupportelectroniccommerce(EC)applications,andvoluminous datahandlingapplications. Atthesametime,supporttechniquesarebeingst- iedindataminingandknowledgediscovery,object-relationaldatabasemana- mentsystems,andmobilecomputingsystems. Theinternationalworkshopon DatabasesinNetworkedInformationSystems(DNIS)2000hasbeenorganized toemphasizetheresearchactivityonsupportsystems. DNIS2000isbeingheldon4-6December2000attheUniversityofAizuin Japan. Theworkshopprogramincludesresearchcontributionsandinvitedc- tributions. Aviewofresearchactivityinevolvingdatamanagementsystemsand relatedresearchissueshasbeenprovidedbythesessiononthistopic. Theinvited contributionshavebeencontributedbyDr. QimingChen,Dr. UmeshwarDayal, andDr. MeichunHsu,andbyMasaruKitsuregawa,TakahikoShintani,Takeshi Yoshizawa,andIkoPramudiono. Theworkshopsessionondatabasesystems- cludescontributedpapersbyDr. JayantR. HaritsaandbyProfessorDivyakant AgrawalandDr. AmrElAbbadi. Thesessiononnetworkedinformationsystems includestheinvitedcontributionbyProfessorKrithiRamamritham,Pavan- olasee,AmolKatkar,AnkurPanchbudhe,andPrashantShenoy. Iwouldliketothankthemembersoftheprogramcommitteefortheirs- portandallauthorswhoconsideredDNIS2000inmakingresearchcontributions. Thesponsoringorganizationsandtheorganizingcommitteedeservepraise forthesupporttheyprovided. Anumberofindividualshavecontributedtothe successoftheworkshop. IthankProfessorP. C. P. Bhatt,ProfessorJ. Biskup, Dr. CarlW. Vilbrand,andProfessorM. Kitsuregawa,forprovidingcontinuous supportandencouragement. IhavereceivedinvaluablesupportfromtheUniversityofAizu. Professor ShoichiNoguchi,President,providedencouragementandtookinterestinthe formationoftheplan. IthankProfessorShunjiMori,HeadofDepartmentof ComputerSoftware,formakingthesupportavailable. Iexpressmygratitudeto themembersandchairmanoftheInternationalA?airsCommitteeforsuppo- ingtheworkshopproposal. Ialsothankallmycolleaguesattheuniversityfor theircooperationandsupport. September2000 SubhashBhalla VI Organization Organization DNIS2000internationalworkshopisorganizedbytheDatabaseSystemsLa- ratory,UniversityofAizu,Aizu-WakamatsuCity,Fukushima,Japan. ExecutiveCommittee ProgramChair: S. Bhalla,UniversityofAizu,Japan OrganizingChair: QunJin,UniversityofAizu,Japan ExecutiveChair: N. Bianchi-Berthouze,Universityof Aizu,Japan ProgramCommittee D. Agrawal,UniversityofCalifornia,USA F. Andres,NationalCenterforScienceInformationSystems,Japan A. Basu,VanderbiltUniversity,USA S. Bhalla,UniversityofAizu,Japan P. C. P. Bhatt,KochiTechnicalUniversity,Japan J. Biskup,UniversityofDortmund,Germany U. Dayal,Hewlett-PackardLaboratories,USA S. Grumbach,INRIA,France O. Hammami,UniversityofAizu,Japan J. R. Haritsa,IndianInstituteofScience,India S. Jajodia,GeorgeMasonUniversity,USA Q. Jin,UniversityofAizu,Japan M. Kitsuregawa,UniversityofTokyo,Japan A. Kumar,UniversityofColorado,USA J. Li,UniversityofTsukuba,Japan S. K. Madria,PurdueUniversity,USA G. Mans?eld,TohokuUniversity,Japan P. K. Reddy,UniversityofTokyo,Japan M. V. Sreenivas,SylantroSystems,USA N. Terashima,WasedaUniversity,Japan AdditionalReviewers LawrenceMutenda,InstituteofIndustrialSciences,UniversityofTokyo,Japan TadashiOhmori,UniversityofElectro-Communications,Chofu,Japan SponsoringInstitution InternationalA?airsCommittee,UniversityofAizu, Aizu-WakamatsuCity,FukushimaP. O. 965-8580,Japan TableofContents DataManagementSystems OLAP-BasedDataMiningforBusinessIntelligenceApplications inTelecommunicationsandE-commerce...1 QimingChen,UmeshwarDayal,MeichunHsu WebLogMiningandParallelSQLBasedExecution...20 MasaruKitsuregawa,TakahikoShintani,TakeshiYoshizawa, IkoPramudiono DataProviders-ALanguageExperiment...33 JohnL. Pfaltz JAVAWrappersforAutomatedInteroperability...45 NgomCheng,ValdisBerzins,Luqi,SwapanBhattacharya IssuesinSecuringGISData...65 PramodChandraP. Bhatt SemanticCon?ictsandSolutionsinFuzzyMultidatabaseSystems...80 ZongminM. Ma,WenjunJ. Zhang,WeiyinY. Ma DatabaseSystems:StorageandRetrieval TheWebIstheDatabase...91 JayantR. Haritsa ViewMaintenanceandAnalyticalProcessingatDataWarehouses...107 DivyakantAgrawal,AmrElAbbadi ADesignofParallelR-treeonClusterofWorkstations...119 ShuhuaLai,FenghuaZhu,YongqiangSun GraphicalInterfaceforDesignofGeometricDataStructures...134 TakashiHibi,AlexanderPasko Similarity-BasedQueriesforInformationRetrieval...148 AnaIsabelAguilera,AlbertoRafaelSubero,LeonidJos'eTineo K-DIME:AnAdaptiveSystemtoRetrieveImagesfromtheWEB UsingSubjectiveCriteria...1 57 NadiaBianchi-Berthouze,ToshikazuKato VIII TableofContents NetworkedInformationSystems:Implementation DisseminationofDynamicDataontheInternet...173 KrithiRamamritham,PavanDeolasee,AmolKatkar, AnkurPanchbudhe,PrashantShenoy InformationRetrievalMethod forFrequentlyUpdatedInformationSystem...188 NobuyoshiSato,TakashiYamamoto,YoshihiroNishida, MinoruUehara,HidekiMori BlockingReductioninTwo-PhaseCommitProtocol withMultipleBackupSites...200 P. KrishnaReddy,MasaruKitsuregawa Inter-agentCooperationSupportedbyXMLandCORBA inHeterogeneousInformationSystems...216 NacereddineZarour,MahmoudBoufaida,LionelSeinturier, PascalEstraillier SimulationStudyonLoadBalancedMultipleHomeAgents forMobileIPNetworks...228 AdrianVasilache,JieLi,HisaoKameda AuthorIndex...247 OLAP-Based Data Mining for Business Intelligence Applications in Telecommunications and E-commerce Qiming Chen, Umeshwar Dayal, and Meichun Hsu Hewlett-Packard Laboratories 1501 Page Mill Road, Palo Alto, CA 94304, USA {qchen,dayal,mhsu}@hpl. hp.

The ultimate beginning-to-end guide for SQL developers building Web-enabled database applications. Contains data tools to help make building Web applications easier for developers. Includes coverage of security issues and building N-tier Web solutions, an important topic in web development today.

This book is the first comprehensive survey of the field of constraint databases, written by leading researchers. Constraint databases are a fairly new and active area of database research. The key idea is that constraints, such as linear or polynomial equations, are used to represent large, or even infinite, sets in a compact way. The ability to deal with infinite sets makes constraint databases particularly promising as a technology for integrating spatial and temporal data with standard relational databases. Constraint databases bring techniques from a variety of fields, such as logic and model theory, algebraic and computational geometry, as well as symbolic computation, to the design and analysis of data models and query languages.

This monograph describes an innovative prototyping framework for data and knowledge intensive systems. The proposed approach will prove especially useful for advanced and research-oriented projects that aim to develop a traditional database perspective into fully-fledged advanced database approaches and knowledge engineering technologies. The book is organised in two parts. The first part, comprising chapters 1 to 4, provides an introduction to the concept of prototyping, to database and knowledge-based technologies, and to the main issues involved in the integration of data and knowledge engineering. The second part, comprising chapters 5 to 12, illustrates the proposed approach in technical detail. Audience: This volume will be of interest to researchers in the field of databases and knowledge engineering in general, and for software designers and knowledge engineers who aim to expand their expertise in data and knowledge intensive systems.

Understanding dBASE5 for Windows is a good tutor for anyone interested in the new Windows version.

From this systematic and comprehensive book, you can learn the basics and features of dBASE as well as the advanced techniques that will make you an expert.

The book presents the basic concepts of using a database, and instructs you to build sophisticated database systems step by step. It is full of valuable tips, tricks and timesaving techniques.

The Database and Expert Systems Applications (DEXA) conferences bring together researchers and practitioners from all over the world to exchange ideas, experiences and opinions in a friendly and stimulating environment. The papers are at once a record of what has been achieved and the first steps towards shaping the future of information systems. DEXA covers a broad field, and all aspects of database, knowledge base and related technologies and their applications are represented. Once again there were a good number of submissions: 241 papers were submitted and of these the programme committee selected 103 to be presented. DEXA'99 took place in Florence and was the tenth conference in the series, following events in Vienna, Berlin, Valencia, Prague, Athens, London, Zurich, Toulouse and Vienna. The decade has seen many developments in the areas covered by DEXA, developments in which DEXA has played its part. I would like to express thanks to all the institutions which have actively supported and made possible this conference, namely: * University of Florence, Italy * IDG CNR, Italy * FAW - University of Linz, Austria * Austrian Computer Society * DEXA Association In addition, we must thank all the people who have contributed their time and effort to make the conference possible. Special thanks go to Maria Schweikert (Technical University of Vienna), M. Neubauer and G. Wagner (FAW, University of Linz). We must also thank all the members of the programme committee, whose careful reviews are important to the quality of the conference.

Addressing important extensions of the relational database model, including deductive, temporal, and object-oriented databases, this book provides an overview of database modeling with the Entity-Relationship (ER) model and the relational model. The book focuses on the primary achievements in relational database theory, including query languages, integrity constraints, database design, computable queries, and concurrency control. This reference will shed light on the ideas underlying relational database systems and the problems that confront database designers and researchers.