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.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Step-by-Step, Full-Color Graphics!Get started using Access 2007 right away--the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features. Follow along and learn to work with the new Office interface and ribbon, create databases and tables, and enter and edit data. You'll also find out how to retrieve information, create forms, and generate reports. Plus, you can flip straight to the information you need easily using the color-coded tabs. Get the book that gets you started using Access 2007 in no time. In each chapter: Shortcuts for accomplishing common tasks Need-to-know facts in concise narrative Helpful reminders or alternate ways of doing things Bonus information related to the topic being covered Errors and pitfalls to avoid

If you are new to Access 2000 or already use an alternative database application and you want to switch to Access 2000 this book gives you all the essential information you need using lots of examples.Topics covered in this book include:- How to use the Access interface- How to use Access objects to create a simple database- How to use built in functions- How to create tables- How to create forms- How to create queries to select and update data- How to create reports- How to create macros- How to use object events and create proceduresEssential Access 2000 fast is designed for professionals or students who need to learn the maximum in the minimum time and to develop databases fast.

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.

Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server. This book is designed as a guide for Access programmers looking to make this transition, but who have little or no prior experience with SQL Server.

Veteran author Russell Sinclair begins by discussing SQL Server, its architecture and application environment, and its differences from Access. He provides coverage of key topics including security, data storage, system databases, database objects, and queries.Illustrates best practices for migrating Access databases to SQL ServerCarefully explains the differences between these two systems and the changes needed for a smooth migrationAssumes no prior knowledge of SQL Server

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.

"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.

Die ausfuhrliche Erklarung aller Funktionen, die dem Benutzer im TSO und seinem Umfeld zur Verfugung stehen, unter Berucksichtigung der ganzen Vielfalt der Datenverarbeitung, der Datenverwaltung und des Datenschutzes."

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.

This book constitutes the thoroughly refereed and revised post-workshop proceedings of two international meetings devoted to deductive databases and logic programming.
The technical papers presenting original research results were carefully reviewed and selected for inclusion in the present book, together with several survey articles summarizing the state of the art in the area. Thus, the book is the ultimate reference for anybody interested in the theory and application of deductive databases and logic programming.

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.

Access is the most complex and intimidating application in Microsoft Office, but you'll tame it quickly with this book. You'll learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry in no time. With "Microsoft Access 2010: The Missing Manual", you'll even delve into the black art of Access programming by learning valuable tricks and techniques to automate common tasks - even if you've never touched a line of code before. Discover new pre-built databases you can customize to fit your needs, and learn how Access' new complex data feature will simplify your life. With plenty of downloadable examples, this objective and engaging book will turn any Access neophyte into a true master. Follow step-by-step instructions for creating and perfecting an Access database, and learn methods for using and maintaining it. Understand Access' interface, and focus on new time-saving features. Learn basic Access programming quickly and easily. Get good database design practices and tips from the pros.

The expert guidance you need to get the most out of Access 2010

Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office appsCovers how to create tables, manipulate datasheets, and work with multiple tablesExplains the seven database objects and how to use a seven-step design method to build a database tailored to your needsShows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and moreIncludes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office

You'll want to keep this soup-to-nuts Access reference close at hand

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

This volume contains the papers presented at the Third International Conference on Object Oriented Information Systems (00lS'96) which was held at South Bank University, London. The keynote addresses, by Professor Colette Roland and Mr Ian Graham, are also included. The acceptance rate for papers was around 47%. The papers for the Industry Day were invited papers. The keynote paper by Professor Roland analyses the challenges in object modelling, particularly the impact of requirements engineering for conceptual modelling. She suggests innovative research perspectives to enhance and extend object oriented approaches in order to deal with the emerging area of requirements engineering. The keynote paper presented by Mr. Graham focuses on the problems and solutions for adopting use cases. In his paper, Graham illustrates the theoretical issues and practical problems of use cases, and highlights them using examples. The papers included in this volume cover different aspects of object modelling, object oriented software development, object databases, and interoperability. In the modelling session, Ram, et al. outline an extended object model to tackle the problems of capturing complex requirements of office information systems. Simons' paper concentrates on core object modelling concepts and presents a mathematical theory of class.

This book constitutes the strictly refereed post-workshop proceedings of the International Workshop on Logic in Databases, LID'96, held in San Miniato, Italy, in July 1996, as the final meeting of an EC-US cooperative activity.
The volume presents 21 revised full papers selected from 49 submissions as well as 3 invited contributions and a summary of a panel discussion on deductive databases: challenges, opportunities and future directions. The retrospective survey on logic and databases by Jack Minker deserves a special mention: it is a 56-page overview and lists 357 references. The papers are organized in sections on uncertainty, temporal and spatial reasoning, updates, active databases, semantics, advanced applications, query evaluation, language extensions, and logic constructs and expressive power.

Parallel execution of SQL queries against large databases offers a solution to the problem of reducing query response. This book addresses the related optimization problem: Given an SQL query, find the plan that delivers the result in minimal time. The author presents and analyzes new theoretical findings and efficient algorithms pertaining to parallel operation at a practical level of granularity relevant to database system operations. The optimization results balance the advantages and costs of parallel execution of SQL queries. The techniques presented are applicable to modern system configurations, where computation is performed on pipelining-capable workstations operating in parallel, and can be used to construct SQL compilers able to exploit parallel machines effectively.

This book is based on the author's PhD thesis which was selected during the 1993 ACM Doctoral Dissertation Competition as one of the three best submissions.
The focus of this work is on the issue of availability in distributed file systems. It presents the important new technique called disconnected operation, in which clients mask failures and voluntary network detachments by emulating the functionality of servers where actual server-oriented solutions are inadequate. This permits client operation even under complete isolation from the server; the clean integration of mobile computers into the system is an important side-effect of the new technique. The design and implementation of disconnected file service in a working system, the Coda file system, is described in detail.

The areas of active and real-time databases have seen a tremendous growth of interest in the past few years, particularly with regard to their support of time-critical and embedded applications. ARTDB-95 provided, therefore, an important forum for researchers from both communities to discuss research results, and also to chart new directions for the future. As well as the 11 submitted papers presented at the workshop, this volume also contains 4 invited papers on the following topics: the impact of active databases on commercial practice; the optimization of active database transactions; the need for better language, compiler and tool support for real-time databases; and the origin of time constraints associated with data, events and actions. Together the papers give a comprehensive overview of current research, and will provide invaluable reading for academic and industrial researchers and students at both undergraduate and postgraduate level.

Learn how to analyze and successfully solve today's real business problems using the latest Microsoft (R) Office Access database management system and the most recent version of Excel spreadsheet tools. Packed with hands-on learning opportunities, Monk/Brady/Mendelsohn's PROBLEM-SOLVING CASES IN MICROSOFT (R) ACCESS AND EXCEL, 16E features five individual tutorials designed to build your practical knowledge as you walk step-by-step through the capabilities of each software application. Twelve all-new case studies challenge you to use the software applications to resolve scenarios and problems you are likely to encounter on the job. In addition, a unique emphasis on skill-building integration demonstrates how to use Access and Excel together to resolve challenges within each case. Trust today's most up-to-date, practical guide for mastering critical Access and Excel skills in a business context.

This book constitutes the refereed proceedings of the 4th International Conference on Deductive and Object-Oriented Databases, DOOD '95, held in Singapore in December 1995.
Besides two keynote papers by Stefano Ceri and Michael Kifer, the book contains revised full versions of 28 papers selected from a total of 88 submissions. The volume gives a highly competent state-of-the-art report on DOOD research and advanced applications. The papers are organized in sections on active databases, query processing, semantic query optimization, transaction management, authorization, implementation, and applications.

This volume constitutes the proceedings of the 13th International Conference on the Entity-Relationship Approach, ER '94, held in Manchester, UK in December 1994.
The ER '94 book is devoted to business modelling and re-engineering and provides a balanced view between research and practical experience. The 34 full revised papers presented are organized in sections on business process modelling, enterprise modelling, systems evolution, modelling integrity constraints, object-oriented databases, active databases, CASE, reverse engineering, information system modelling, schema coordination, and re-engineering.

Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL

This volume contains the proceedings of the 12th International Conference of the Entity-Relationship Approach, held in Arlington, Texas in December 1993; it contains the revised versions of 42 papers selected for presentation at the conference from a total of 87 submissions.
The volume presents many of the most important results on the ERA published since the predecessor conference ER '92. It is organized in sections on object-oriented models, query languages, applications of the ER model, knowledge-based modeling, data modeling, schema integration, reuse and reengineering, integrating ER and object-orientation, conceptual clustering, modeling time and data semantics.

Since the initial publication of Practical SGML the computer industry has seen a dramatic increase in the use and acceptance of SGML and many of the concepts derived from it. The existence of Practical SGML has helped to foster this growth as it provides a practical and vital introduction to the many facets of SGML and how its fits into an organization, whether it be business or government. Practical SGML, Second Edition is an extensive revision and update that puts greater emphasis and focus on helping the novice work his or her way through the vast amounts of information required to become proficient in SGML. Practical SGML, Second Edition provides the reader with an understanding of: the tools currently on the market that enable the easy creation of SGML data and the use and distribution of that data in a variety of forms; the minimum amount of information needed by people who wish to understand and use ISO 8879; aids and information on how to stay current with the volumes of material written on SGML in publications throughout the world; practical examples of the many SGML constructs and guidelines on their appropriate uses; other helpful hints and insights based on years of working with the standard and integrating it into a complex and challenging computer environment. Exercises throughout the text allow the readers to test their understanding. Answers are given in Appendix A. Practical SGML, Second Edition is an invaluable reference manual for anyone interested in understanding and using SGML.

T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL's optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics