This book constitutes the refereed proceedings of the Second International Workshop on Databases in Networked Information Systems, DNIS 2002, held in Aizu, Japan in December 2002. The 16 revised full papers presented with five invited papers were carefully reviewed and selected for inclusion in the book. The papers are organized in topical sections on information interchange and management systems, Web data management systems, data management systems, networked information systems applications, and networked information systems implementations.

This book constitutes the thoroughly refereed post-proceedings of the 4th International Workshop on Distributed Communities on the Web, DCW 2002, held in Sydney, Australia in April 2002.The 25 revised full papers presented together with an introductory overview and outline of the field were carefully reviewed and selected from 59 submissions. The papers are organized in topical sections on adaptive networks, collaborative systems, languages for the Web, and adaptive distributed systems.

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer wanting a more powerful, reliable and sophisticated database than MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services. This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more. The Jet database engine, which has traditionally powered Access, is gradually being replaced by the Microsoft Database Engine (MSDE), a limited-client version of the SQL Server engine (but without the front-end tools such as Enterprise Manager). This means that VB developers traditionally used to using a single-file database now have to cope with the client-server architecture of SQL Server. This is a big conceptual leap, and many VB developers struggle to make it. possible, and to show them how to use the full range of SQL Server's powerful tools within their VB applications.

This book constitutes the refereed proceedings of the 4th International Conference on Web-Age Information Management, WAIM 2003, held in Chengdu, China in August 2003. The 30 revised full papers and 16 revised short papers presented together with 2 invited contributions were carefully reviewed and selected from 258 submissions. The papers are organized in topical sections on Web; XML; text management; data mining; bioinformatics; peer-to-peer systems; service networks; time series, similarity, and ontologies; information filtering; queries and optimization; multimedia and views; and systems demonstrations.

Description Phoenix is a modern web framework built for the Elixir programming language. Elegant, fault-tolerant, and performant, Phoenix is as easy to use as Rails and as rock-solid as Elixir's Erlang-based foundation. Phoenix in Action builds on your existing web dev skills, teaching you the unique benefits of Phoenix along with just enough Elixir to get the job done. Phoenix in Action is an example-based tutorial that teaches you how to use the Phoenix framework to build production-quality web apps. Following a running example of an online auction site, you'll design and build everything from the core components that drive the app to the real-time user interactions where Phoenix really shines. You'll handle business logic, database interactions, and app designs that take advantage of functional programming as you discover a better way to develop web applications. Key features * Use channels for real-time communication * Learn database interactions with Ecto * Hands-on examples * Step-by-step instructions * Jargon-free Audience Written for web developers familiar with a framework like Rails or ASP.NET. No experience of Elixir or Phoenix required. About the technology Phoenix is a web framework for the Elixir language. Phoenix applications are blazingly fast, and as a developer you'll appreciate the attention to detail in the framework design that makes you superproductive almost immediately. In particular, Phoenix channels provide an easy way to set up and manage real-time communication.

"Real-World SQL-DMO for SQL Server" delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mitchell and Allison offer advice about when (and when "not") to use the SQL-DMO application programming interface (API).

The code in this book has been tried and tested at sites where database administrators routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.

Whether youre a developer or a database administrator, this book will take you to the next level in SQL Server administration.

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

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.

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.

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.

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.

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.

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

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

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.

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.

Find the right big data solution for your business or organization

Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work.Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionalsAuthors are experts in information management, big data, and a variety of solutionsExplains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much moreProvides essential information in a no-nonsense, easy-to-understand style that is empowering

"Big Data For Dummies" cuts through the confusion and helps you take charge of big data solutions for your organization.

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.

Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.Learn how to maintain localized storage in a single file that requires no configurationBuild your own SQLite library or use a precompiled distribution in your applicationGet a primer on SQL, and learn how to use several language functions and extensionsWork with SQLite using a scripting language or a C-based language such as C# or Objective-CUnderstand the basics of database design, and learn how to transfer what you already know to SQLiteTake advantage of virtual tables and modules

"Complex SQL concepts explained clearly."--D. Richard Hipp, creator of SQLite

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.