tag:open.umn.edu,2005:/opentextbooks/subjects/databasesOpen Textbook Library - Databases Textbooks2022-01-08T00:50:22Zhttps://open.umn.edu/assets/common/favicon/favicon-1594c2156c95ca22b1a0d803d547e5892bb0e351f682be842d64927ecda092e7.icohttps://open.umn.edu/assets/library/otl_logo-f9161d5c999f5852b38260727d49b4e7d7142fc707ec9596a5256a778f957ffc.png11212022-01-08T00:50:22Z2024-01-22T14:52:38ZEvidence-based Software Engineering<img alt="Read more about Evidence-based Software Engineering" title="Evidence-based Software Engineering cover image" class="cover " width="446" height="630" data-controller="cover" data-placeholder="/assets/common/placeholder-0e0607cbc50663ddb9e8fd188058bcd2630c730ef6ee322801278607b7d5af8e.png" src="/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzI4MywicHVyIjoiYmxvYl9pZCJ9fQ==--cd1f340cfd8195698a5bccbf4417c2a2445a6003/ESEUR-Cover_630-446.jpg" />This book discusses what is currently known about software engineering, based on an analysis of all the publicly available data. This aim is not as ambitious as it sounds, because there is not a great deal of data publicly available. The intent is to provide material that is useful to professional developers working in industry; until recently researchers in software engineering have been more interested in vanity work, promoted by ego and bluster. The material is organized in two parts, the first covering software engineering and the second the statistics likely to be needed for the analysis of software engineering data.9152020-09-29T01:32:50Z2024-01-22T14:52:12ZThe Crystal Ball Instruction Manual - version 1.1 Volume One: Introduction to Data Science<img alt="Read more about The Crystal Ball Instruction Manual - version 1.1 Volume One: Introduction to Data Science" title="The Crystal Ball Instruction Manual - version 1.1 Volume One: Introduction to Data Science cover image" class="cover " width="432" height="648" data-controller="cover" data-placeholder="/assets/common/placeholder-0e0607cbc50663ddb9e8fd188058bcd2630c730ef6ee322801278607b7d5af8e.png" src="/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MjE4OCwicHVyIjoiYmxvYl9pZCJ9fQ==--d726493174b50f2f954ef9182a5ea3bac512ea0f/cover-trim-no-fold-front_cover-62fb6749-f75d-4235-a460-e936fec93c10.jpg" />A perfect introduction to the exploding field of Data Science for the curious, first-time student. The author brings his trademark conversational tone to the important pillars of the discipline: exploratory data analysis, choices for structuring data, causality, machine learning principles, and introductory Python programming using open-source Jupyter Notebooks. This engaging read will allow any dedicated learner to build the skills necessary to contribute to the Data Science revolution, regardless of background.9132020-09-24T04:27:36Z2024-01-22T14:52:12ZThe Discipline of Organizing: 4th Professional Edition<img alt="Read more about The Discipline of Organizing: 4th Professional Edition" title="The Discipline of Organizing: 4th Professional Edition cover image" class="cover " width="350" height="478" data-controller="cover" data-placeholder="/assets/common/placeholder-0e0607cbc50663ddb9e8fd188058bcd2630c730ef6ee322801278607b7d5af8e.png" src="/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MTU3MCwicHVyIjoiYmxvYl9pZCJ9fQ==--d194a2f8a221da079e6bd5cdab0c423e48c10edb/organize.jpg" />We organize things, we organize information, we organize information about things, and we organize information about information. But even though “organizing” is a fundamental and ubiquitous challenge, when we compare these activities their contrasts are more apparent than their commonalities. We propose to unify many perspectives about organizing with the concept of an Organizing System, defined as an intentionally arranged collection of resources and the interactions they support. Every Organizing System involves a collection of resources, a choice of properties or principles used to describe and arrange resources, and ways of supporting interactions with resources. By comparing and contrasting how these activities take place in different contexts and domains, we can identify patterns of organizing. We can create a discipline of organizing in a disciplined way. The 4th edition builds a bridge between organizing and data science. It reframes descriptive statistics as organizing techniques, expands the treatment of classification to include computational methods, and incorporates many new examples of data-driven resource selection, organization, maintenance, and personalization. It introduces a new “data science” category of discipline-specific content, both in the chapter text and in endnotes, marked with [DS] in editions that contain endnotes.4422018-09-07T17:22:02Z2024-01-22T14:51:55ZRelational Databases and Microsoft Access<img alt="Read more about Relational Databases and Microsoft Access" title="Relational Databases and Microsoft Access cover image" class="cover " width="1167" height="1390" data-controller="cover" data-placeholder="/assets/common/placeholder-0e0607cbc50663ddb9e8fd188058bcd2630c730ef6ee322801278607b7d5af8e.png" src="/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MzcxLCJwdXIiOiJibG9iX2lkIn19--37d21996297b000ba70d1e8737006674f65029fe/0000RelDatMic.png" />This text is a free introductory text that introduces MS Access and relational database design. The motivation is to support a second-year course on database systems which, to the student, is either a service course providing an introduction to database concepts, or, as a prerequisite for more advanced study in the field.3542018-09-07T17:21:57Z2024-03-06T23:56:39ZDatabase Design - 2nd Edition<img alt="Read more about Database Design - 2nd Edition" title="Database Design - 2nd Edition cover image" class="cover " width="350" height="453" data-controller="cover" data-placeholder="/assets/common/placeholder-0e0607cbc50663ddb9e8fd188058bcd2630c730ef6ee322801278607b7d5af8e.png" src="/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsiZGF0YSI6MTQyNCwicHVyIjoiYmxvYl9pZCJ9fQ==--5ae3bf9271b5d6a9ec9975fbbd7d3a334cac473c/datbase.jpg" />This second edition of Database Design book covers the concepts used in database systems and the database design process. Topics include: The history of databases Characteristics and benefits of databases Data models Data modelling Classification of database management systems Integrity rules and constraints Functional dependencies Normalization Database development process New to this edition are more examples, highlighted and defined key terms, both throughout and at the end of each chapter, and end-of-chapter review exercises. Two new chapters have been added on SQL, along with appendices that include a data model example, sample ERD exercises and SQL lab with solutions.