Usage-Driven Database Design

Usage-Driven Database Design
Author: George Tillmann
Publisher: Apress
Total Pages: 379
Release: 2017-04-07
Genre: Computers
ISBN: 1484227220

Design great databases—from logical data modeling through physical schema definition. You will learn a framework that finally cracks the problem of merging data and process models into a meaningful and unified design that accounts for how data is actually used in production systems. Key to the framework is a method for taking the logical data model that is a static look at the definition of the data, and merging that static look with the process models describing how the data will be used in actual practice once a given system is implemented. The approach solves the disconnect between the static definition of data in the logical data model and the dynamic flow of the data in the logical process models. The design framework in this book can be used to create operational databases for transaction processing systems, or for data warehouses in support of decision support systems. The information manager can be a flat file, Oracle Database, IMS, NoSQL, Cassandra, Hadoop, or any other DBMS. Usage-Driven Database Design emphasizes practical aspects of design, and speaks to what works, what doesn’t work, and what to avoid at all costs. Included in the book are lessons learned by the author over his 30+ years in the corporate trenches. Everything in the book is grounded on good theory, yet demonstrates a professional and pragmatic approach to design that can come only from decades of experience. Presents an end-to-end framework from logical data modeling through physical schema definition. Includes lessons learned, techniques, and tricks that can turn a database disaster into a success. Applies to all types of database management systems, including NoSQL such as Cassandra and Hadoop, and mainstream SQL databases such as Oracle and SQL Server What You'll Learn Create logical data models that accurately reflect the real world of the user Create usage scenarios reflecting how applications will use a new database Merge static data models with dynamic process models to create resilient yet flexible database designs Support application requirements by creating responsive database schemas in any database architecture Cope with big data and unstructured data for transaction processing and decision support systems Recognize when relational approaches won’t work, and when to turn toward NoSQL solutions such as Cassandra or Hadoop Who This Book Is For System developers, including business analysts, database designers, database administrators, and application designers and developers who must design or interact with database systems

Data Model Patterns: A Metadata Map

Data Model Patterns: A Metadata Map
Author: David C. Hay
Publisher: Elsevier
Total Pages: 427
Release: 2010-07-20
Genre: Computers
ISBN: 0080477038

Data Model Patterns: A Metadata Map not only presents a conceptual model of a metadata repository but also demonstrates a true enterprise data model of the information technology industry itself. It provides a step-by-step description of the model and is organized so that different readers can benefit from different parts. It offers a view of the world being addressed by all the techniques, methods, and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.) and presents several concepts that need to be addressed by such tools. This book is pertinent, with companies and government agencies realizing that the data they use represent a significant corporate resource recognize the need to integrate data that has traditionally only been available from disparate sources. An important component of this integration is management of the "metadata" that describe, catalogue, and provide access to the various forms of underlying business data. The "metadata repository" is essential to keep track of the various physical components of these systems and their semantics. The book is ideal for data management professionals, data modeling and design professionals, and data warehouse and database repository designers. - A comprehensive work based on the Zachman Framework for information architecture—encompassing the Business Owner's, Architect's, and Designer's views, for all columns (data, activities, locations, people, timing, and motivation) - Provides a step-by-step description of model and is organized so that different readers can benefit from different parts - Provides a view of the world being addressed by all the techniques, methods and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.) - Presents many concepts that are not currently being addressed by such tools — and should be

The Enterprise Data Model

The Enterprise Data Model
Author: Andy Graham
Publisher: Koios Associates Limited
Total Pages: 160
Release: 2012-05
Genre: Computers
ISBN: 9780956582911

Wouldn't it be great to understand all the data in your organisation? Just imagine being able to define, agree and manage information concepts that impact on business strategy? Then image that these information concepts can be linked to the physical database attributes that ultimately are used to create them. That's what this book is about. It focuses on the data model as the foundation for achieving this understanding. This book provides a framework for the enterprise data model, the business reasons behind it and the differences between conceptual, logical and physical data models. The question of how, and why, to use a data model artifact as part of the data governance toolkit for the whole enterprise is also addressed. This publication is not an in-depth manual on how to model data for a new database system or your next design project. It instead focuses at a level above these implementation projects and addresses the issues that organisations typical struggling with such as: * How do we provide a framework within which we can manage our data assets? * How do we develop applications that adhere to a set of data standards; without creating a nightmare of administration and governance that is both unwieldy and unusable? * How can we get business value from our enterprise data? Chapter headings are: * Chapter 1 - Introduction * Chapter 2 - Information and Data * Chapter 3 - Pillars of Value * Chapter 4 - An Overview of Data Modelling * Chapter 5 - Data Architecture * Chapter 6 - The Enterprise Data Model * Chapter 7 - Build the Model one Project at a Time * Chapter 8 - Master Data * Chapter 9 - Data Governance * Chapter 10 - The Enterprise Data Framework This 2nd edition revises the original text to add extra details around key areas such as the enterprise data model framework and the pillars of value. It also improves the quality of the original text.

Enterprise Architecture & Metadata Modeling

Enterprise Architecture & Metadata Modeling
Author: Carl Turco
Publisher: Carl Turco
Total Pages: 164
Release: 2009-05
Genre: Computers
ISBN: 0741453045

After the economic debacle of 2008, corporations must increase control over their I.T. infrastructures. We expound a way of managing the business vision realization and facilitate swift response to change.

The Data Model Resource Book, Volume 1

The Data Model Resource Book, Volume 1
Author: Len Silverston
Publisher: John Wiley & Sons
Total Pages: 572
Release: 2011-08-08
Genre: Computers
ISBN: 111808232X

A quick and reliable way to build proven databases for core business functions Industry experts raved about The Data Model Resource Book when it was first published in March 1997 because it provided a simple, cost-effective way to design databases for core business functions. Len Silverston has now revised and updated the hugely successful 1st Edition, while adding a companion volume to take care of more specific requirements of different businesses. This updated volume provides a common set of data models for specific core functions shared by most businesses like human resources management, accounting, and project management. These models are standardized and are easily replicated by developers looking for ways to make corporate database development more efficient and cost effective. This guide is the perfect complement to The Data Model Resource CD-ROM, which is sold separately and provides the powerful design templates discussed in the book in a ready-to-use electronic format. A free demonstration CD-ROM is available with each copy of the print book to allow you to try before you buy the full CD-ROM.

Fundamentals of Data Warehouses

Fundamentals of Data Warehouses
Author: Matthias Jarke
Publisher: Springer Science & Business Media
Total Pages: 188
Release: 2013-03-09
Genre: Computers
ISBN: 3662041383

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.

Data Architecture

Data Architecture
Author: Charles Tupper
Publisher: Elsevier
Total Pages: 442
Release: 2011-05-09
Genre: Computers
ISBN: 0123851270

Data Architecture: From Zen to Reality explains the principles underlying data architecture, how data evolves with organizations, and the challenges organizations face in structuring and managing their data. Using a holistic approach to the field of data architecture, the book describes proven methods and technologies to solve the complex issues dealing with data. It covers the various applied areas of data, including data modelling and data model management, data quality, data governance, enterprise information management, database design, data warehousing, and warehouse design. This text is a core resource for anyone customizing or aligning data management systems, taking the Zen-like idea of data architecture to an attainable reality. The book presents fundamental concepts of enterprise architecture with definitions and real-world applications and scenarios. It teaches data managers and planners about the challenges of building a data architecture roadmap, structuring the right team, and building a long term set of solutions. It includes the detail needed to illustrate how the fundamental principles are used in current business practice. The book is divided into five sections, one of which addresses the software-application development process, defining tools, techniques, and methods that ensure repeatable results. Data Architecture is intended for people in business management involved with corporate data issues and information technology decisions, ranging from data architects to IT consultants, IT auditors, and data administrators. It is also an ideal reference tool for those in a higher-level education process involved in data or information technology management. - Presents fundamental concepts of enterprise architecture with definitions and real-world applications and scenarios - Teaches data managers and planners about the challenges of building a data architecture roadmap, structuring the right team, and building a long term set of solutions - Includes the detail needed to illustrate how the fundamental principles are used in current business practice

Computer Applications

Computer Applications
Author: Min Zhang
Publisher: Springer Nature
Total Pages: 285
Release: 2023-12-15
Genre: Computers
ISBN: 981998761X

The two-volume set CCIS 1959 and 1960 constitutes the refereed post-conference proceedings of the 38th CCF National Conference on Computer Applications, CCF NCCA 2023, held in Suzhou, China, during July 16–20, 2023. The 39 revised full papers presented in these proceedings were carefully reviewed and selected from 197 submissions. The papers are organized in the following topical sections: Volume I: Artificial intelligence and application. Volume II: Data science and technology; pattern recognition and machine learning; network communication and security; frontier and comprehensive applications.