Database Systems

Introduction to Databases and Data Warehouses

Author: Nenad Jukic,Susan Vrbsky,Svetlozar Nestorov

Publisher: Prentice Hall

ISBN: 9780132575676

Category: Business & Economics

Page: 373

View: 1501

An introductory, yet comprehensive, database textbook intended for use in undergraduate and graduate information systems database courses. This text also provides practical content to current and aspiring information systems, business data analysis, and decision support industry professionals. Database Systems: Introduction to Databases and Data Warehouses covers both analytical and operations database as knowledge of both is integral to being successful in today's business environment. It also provides a solid theoretical foundation and hands-on practice using an integrated web-based data-modeling suite.
Release

Einführung in SQL

Author: Alan Beaulieu

Publisher: O'Reilly Germany

ISBN: 3897219387

Category: Computers

Page: 353

View: 5883

SQL kann Spaß machen! Es ist ein erhebendes Gefühl, eine verworrene Datenmanipulation oder einen komplizierten Report mit einer einzigen Anweisung zu bewältigen und so einen Haufen Arbeit vom Tisch zu bekommen. Einführung in SQL bietet einen frischen Blick auf die Sprache, deren Grundlagen jeder Entwickler beherrschen muss. Die aktualisierte 2. Auflage deckt die Versionen MySQL 6.0, Oracle 11g und Microsoft SQL Server 2008 ab. Außerdem enthält sie neue Kapitel zu Views und Metadaten. SQL-Basics - in null Komma nichts durchstarten: Mit diesem leicht verständlichen Tutorial können Sie SQL systematisch und gründlich lernen, ohne sich zu langweilen. Es führt Sie rasch durch die Basics der Sprache und vermittelt darüber hinaus eine Reihe von häufig genutzten fortgeschrittenen Features. Mehr aus SQL-Befehlen herausholen: Alan Beaulieu will mehr vermitteln als die simple Anwendung von SQL-Befehlen: Er legt Wert auf ein tiefes Verständnis der SQL-Features und behandelt daher auch den Umgang mit Mengen, Abfragen innerhalb von Abfragen oder die überaus nützlichen eingebauten Funktionen von SQL. Die MySQL-Beispieldatenbank: Es gibt zwar viele Datenbankprodukte auf dem Markt, aber welches wäre zum Erlernen von SQL besser geeignet als MySQL, das weit verbreitete relationale Datenbanksystem? Der Autor hilft Ihnen, eine MySQL-Datenbank anzulegen, und nutzt diese für die Beispiele in diesem Buch. Übungen mit Lösungen: Zu jedem Thema finden Sie im Buch gut durchdachte Übungen mit Lösungen. So ist sichergestellt, dass Sie schnell Erfolgserlebnisse haben und das Gelernte auch praktisch umsetzen können.
Release

Database Management Systems

Author: Patricia Ward,George Dafoulas

Publisher: Cengage Learning EMEA

ISBN: 9781844804528

Category: Computers

Page: 334

View: 4401

This is a modern, concise and accessible introduction to database systems for computing students. Designed to cover a one semester course, core topic coverage is motivated by plenty of examples (using Oracle 10g) and practical guidelines. The material is up-to-date and grounded in today?s modern enterprise infrastructure where databases need to link to a Web front end. Providing concise yet full coverage for a one semester course, the examples and activities are efficient exam preparation tools for computing students on a database course. Developed with support from Middlesex University Press and Global Campus. This is a modern, concise and accessible introduction to database systems for computing students. Designed to cover a one semester course, core topic coverage is motivated by plenty of examples (using Oracle 10g) and practical guidelines. The material is up-to-date and grounded in today?s modern enterprise infrastructure where databases need to link to a Web front end. Providing concise yet full coverage for a one semester course, the examples and activities are efficient exam preparation tools for computing students on a database course. Developed with support from Middlesex University Press and Global Campus.
Release

Datenbanksysteme

Konzepte und Techniken der Implementierung

Author: Theo Härder,Erhard Rahm

Publisher: Springer-Verlag

ISBN: 3642980163

Category: Computers

Page: 582

View: 1164

Release

Introduction to Data Mining and Its Applications

Author: S. Sumathi,S.N. Sivanandam

Publisher: Springer Science & Business Media

ISBN: 3540343504

Category: Computers

Page: 828

View: 6257

This book explores the concepts of data mining and data warehousing, a promising and flourishing frontier in data base systems and new data base applications and is also designed to give a broad, yet in-depth overview of the field of data mining. Data mining is a multidisciplinary field, drawing work from areas including database technology, AI, machine learning, NN, statistics, pattern recognition, knowledge based systems, knowledge acquisition, information retrieval, high performance computing and data visualization. This book is intended for a wide audience of readers who are not necessarily experts in data warehousing and data mining, but are interested in receiving a general introduction to these areas and their many practical applications. Since data mining technology has become a hot topic not only among academic students but also for decision makers, it provides valuable hidden business and scientific intelligence from a large amount of historical data. It is also written for technical managers and executives as well as for technologists interested in learning about data mining.
Release

Advanced Data Warehouse Design

From Conventional to Spatial and Temporal Applications

Author: Elzbieta Malinowski,Esteban Zimányi

Publisher: Springer Science & Business Media

ISBN: 9783540744054

Category: Computers

Page: 435

View: 1254

This exceptional work provides readers with an introduction to the state-of-the-art research on data warehouse design, with many references to more detailed sources. It offers a clear and a concise presentation of the major concepts and results in the subject area. Malinowski and Zimányi explain conventional data warehouse design in detail, and additionally address two innovative domains recently introduced to extend the capabilities of data warehouse systems: namely, the management of spatial and temporal information.
Release

Database Systems

A Practical Approach to Design, Implementation, and Management

Author: Thomas M. Connolly,Carolyn E. Begg

Publisher: Pearson Education

ISBN: 9780321210258

Category: Computers

Page: 1374

View: 7740

This book places a strong emphasis on good design practice, allowing readers to master design methodology in an accessible, step-by-step fashion. In this book, database design methodology is explicitly divided into three phases: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice. Extensive treatment of the Web as an emerging platform for database applications is covered alongside many code samples for accessing databases from the Web including JDBC, SQLJ, ASP, ISP, and Oracle's PSP. A thorough update of later chapters covering object-oriented databases, Web databases, XML, data warehousing, data mining is included in this new edition. A clear introduction to design implementation and management issues, as well as an extensive treatment of database languages and standards, make this book an indispensable, complete reference for database professionals.
Release

Distributed Database Systems

Author: Ray, Chhanda

Publisher: Pearson Education India

ISBN: 813174308X

Category: Data warehousing

Page: 324

View: 664

Distributed Database Systems discusses the recent and emerging technologies in the field of distributed database technology. The mainstream areas of distributed database technology, such as distributed database design, distributed DBMS architecture
Release

Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications

Concepts, Methodologies, Tools, and Applications

Author: Wang, John

Publisher: IGI Global

ISBN: 159904952X

Category: Technology & Engineering

Page: 4092

View: 7873

In recent years, the science of managing and analyzing large datasets has emerged as a critical area of research. In the race to answer vital questions and make knowledgeable decisions, impressive amounts of data are now being generated at a rapid pace, increasing the opportunities and challenges associated with the ability to effectively analyze this data.
Release

Mobile Database Systems

Author: Vijay Kumar

Publisher: John Wiley & Sons

ISBN: 047004828X

Category: Computers

Page: 320

View: 9854

A breakthrough sourcebook to the challenges and solutions for mobile database systems This text enables readers to effectively manage mobile database systems (MDS) and data dissemination via wireless channels. The author explores the mobile communication platform and analyzes its use in the development of a distributed database management system. Workable solutions for key challenges in wireless information management are presented throughout the text. Following an introductory chapter that includes important milestones in the history and development of mobile data processing, the text provides the information, tools, and resources needed for MDS management, including: * Fundamentals of wireless communication * Location and handoff management * Fundamentals of conventional database management systems and why existing approaches are not adequate for mobile databases * Concurrency control mechanism schemes * Data processing and mobility * Management of transactions * Mobile database recovery schemes * Data dissemination via wireless channels Case studies and examples are used liberally to aid in the understanding and visualization of complex concepts. Various exercises enable readers to test their grasp of each topic before advancing in the text. Each chapter also concludes with a summary of key concepts as well as references for further study. Professionals in the mobile computing industry, particularly e-commerce, will find this text indispensable. With its extensive use of case studies, examples, and exercises, it is also highly recommended as a graduate-level textbook.
Release

Advances in Databases and Information Systems

9th East European Conference, ADBIS 2005, Tallinn, Estonia, September 12-15, 2005, Proceedings

Author: Johann Eder,Hele-Mai Haav,Ahto Kalja,Jaan Penjam

Publisher: Springer Science & Business Media

ISBN: 3540285857

Category: Business & Economics

Page: 391

View: 1746

This book constitutes the refereed proceedings of the 9th East European Conference on Advances in Databases and Information Systems, ADBIS 2005, held in Tallinn, Estonia, in September 2005. The 27 revised full papers presented together with an invited paper were carefully reviewed and selected from 144 submissions. The papers are organized in topical sections on database theory, database modelling and physical database design, query processing, heterogeneous databases and interoperability, XML and databases, data mining and knowledge discovery, information systems and software engineering, and information systems development.
Release

Managing Information in the Public Sector

Author: Jay D. White

Publisher: M.E. Sharpe

ISBN: 9780765630216

Category: Political Science

Page: 336

View: 6049

This first-of-its-kind survey covers both the basics of information technology and the managerial and political issues surrounding the use of these technologies. Unlike other works on information systems, this book is written specifically for the public sector and addresses unique public sector issues and concerns. The technical basics are explained in clear English with as little technical jargon as possible so that readers can move on to informed analysis of the public policy issues surrounding government's use of MIS. This practical tool includes end of chapter summaries with bridges to upcoming chapters, numerous boxed exhibits, thorough end-of-chapter notes and a bibliography for further reading.
Release

Planning and Designing the Data Warehouse

Author: Ramón C. Barquín,Herb Edelstein

Publisher: Prentice Hall

ISBN: N.A

Category: Computers

Page: 311

View: 9020

Intended for IS professionals and managers who are considering creating a data warehouse for their organization, this book focuses on expanding the effective use of data warehousing technology and networking opportunities in industry.
Release

Fundamentals of Data Warehouses

Author: Matthias Jarke,Maurizio Lenzerini,Yannis Vassiliou,Panos Vassiliadis

Publisher: Springer Science & Business Media

ISBN: 3662041383

Category: Computers

Page: 195

View: 1569

The first comparative review of the state of the art and best current practice in data warehousing. It covers source and data integration, multidimensional aggregation, query optimisation, update propagation, metadata management, quality assessment, and design optimisation. Also, based on results of the European DWQ project, it offers a conceptual framework by which the architecture and quality of data warehousing efforts can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modelling, and artificial intelligence. An excellent introduction to the issues of quality and metadata usage for researchers and database professionals in academia and industry. XXXXXXX Neuer Text This book presents the first comparative review of the state-of-the-art and the best current practices of data warehouses. It covers source and data integration, multidimensional aggregation, query optimization, metadata management, quality assessment, and design optimization. A conceptual framework is presented by which the architecture and quality of a data warehouse can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modeling, and artificial intelligence.
Release

Datenqualität in Datenbanken

Author: Sönke Cordts

Publisher: mana-Buch

ISBN: 3944330137

Category:

Page: N.A

View: 4195

Entwickelt man Anwendungssysteme, so wird man immer wieder mit der Integration, Zusammen­führung oder dem Austausch von Daten konfrontiert. Jeder, der das kennt, weiß, wie mühselig es ist, Datenprobleme zunächst zu erkennen und dann zu beheben. Vor allem bei der Entwicklung von Data Warehouse Systemen, bei denen unterschiedliche Daten­bestände zu einem gemeinsamen Datenbestand integriert werden sollen, ist das Erkennen von Problemen ohne entsprechende Softwarewerkzeuge häufig eine wahre „Sisyphos“-Arbeit. Ist man hier nur auf herkömmliche SQL-Anweisungen angewiesen, so bleiben die Erkenntnisse über Probleme eben doch nur oberflächlich. Ein Anspruch dieses Buches ist es daher, Ansätze aufzuzeigen, wie man relationale Datenbankmanagementsysteme um Datenqualitätsverfahren erweitern kann.
Release

Data Warehousing and Mining:

Author: ITLESL

Publisher: Pearson Education India

ISBN: 8131799050

Category:

Page: 272

View: 4119

Data Warehousing and Data Mining is presented in a question-and-answer format following the examination pattern and covers all key topics in the syllabus. The book is designed to make learning fast and effective and is precise, up-to-date and will help students excel in their examinations. The book is part of the Express Learning is a series of books designed as quick reference guides to important undergraduate courses. The organized and accessible format of these books allows students to learn important concepts in an easy-to-understand, question-and-answer format. These portable learning tools have been designed as one-stop references for students to understand and master the subjects by themselves.
Release