Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "database design mistakes"

Question	Category	Date
What are the most common database design mistakes? by Daniel J. Power Editor, DSSResources.COM In a 2008 eWeek slide show, Brian Prince identified "The Most Common Database Design Mistakes." The l...	DSS Foundations	Aug 03, 2013
Why is a person kept in the decision cycle? by Daniel J. Power Editor, DSSResources.COM Decision making using data and algorithms has inherent limitations. Decision automation and decision m...	DSS Foundations	Feb 04, 2018
What if decision support is incorrect? by Dan Power Editor, DSSResources.COM Analytics and decision support are intended to improve decision making. Both types of systems commonly prov...	DSS Foundations	Apr 14, 2015
What are common data mining mistakes? by Dan Power Editor, DSSResources.com Data mining is a broad term for identifying patterns in data, analyzing data and summarizing it into useful...	DSS Foundations	Dec 19, 2010
What is the difference between a DBMS and an RDBMS? by Daniel J. Power Editor, DSSResources.COM DBMS is an umbrella term for different types of database management system (DBMS) technologies. A rela...	DSS Foundations	Jan 02, 2017
What are key database concepts for managers? by Dan Power Editor, DSSResources.com Managers need a basic understanding of computerized databases. Why? Because database systems provide the ke...	DSS Foundations	Jan 01, 2011
What happened at DSSResources 2007-2010? by Dan Power Editor, DSSResources.com The DSS Research Resources home page started during late summer 1995 as a way of organizing the vast amount...	DSS Foundations	Jan 03, 2011
Is ETL software needed to build a model-driven DSS? by Daniel J. Power Editor, DSSResources.COM ETL refers to software used in the process of extracting data from a data source, transforming or alt...	Model-driven DSS	Apr 15, 2017
How can we provide Web access to a Data Warehouse and DSS database? Some database software directly supports Web access, with other database management systems (DBMSs) you will need to use an intermediary application p...	Data-driven DSS	Aug 06, 2005
What is a columnar database? by Daniel J. Power Editor, DSSResources.COM A columnar database stores data tables as sections of columns of data rather than as rows of data. Ch...	DSS Foundations	May 02, 2013
Why do organizations need databases? by Dan Power Editor, DSSResources.com A data base or database is an organized collection of data. Data is stored and it continues and persists. ...	DSS Foundations	Jun 12, 2016
What is ETL software and how is it related to DSS? Data warehousing practitioners have all experienced the frustration of creating a large data store from existing operating data bases built using a va...	Data-driven DSS	Aug 06, 2005
What is the scope of database administration? by Daniel J. Power Editor, DSSResources.COM Databases are central to transaction processing and decision support. Database administration is a com...	DSS Foundations	Nov 12, 2014
What is the job of a datawarehouse administrator? by Daniel J. Power Editor, DSSResources.COM The Data Warehouse Administrator supports the ongoing development and maintenance of data warehousing ...	DSS Foundations	Oct 25, 2018
What is a flat data file? by Daniel J. Power Editor, DSSResources.com Data is stored in a number of formats. In the early years of computing, data was stored and retrieve...	DSS Foundations	Jul 10, 2017
What is a decision-centric organization? by Daniel J. Power Editor, DSSResources.COM Good decisions are important to organization success, but awareness of many important decisions i...	DSS Foundations	Sep 15, 2013
What are the key tasks of a database administrator? by Daniel J. Power Editor, DSSResources.COM Managing data is very important for creating data-driven decision support applications and for specia...	DSS Foundations	Jun 30, 2014
What does it mean to keep a person in the decision loop? by Daniel J. Power In this Age of Automation, machines with appropriate software can make well-understood decisions without involving a person. We ...	DSS Foundations	Aug 29, 2020
What is a data modeler? by Daniel J. Power Editor, DSSResources.COM In the era of rapidly expanding, diverse data, someone needs to identify patterns and regularities in...	DSS Foundations	Sep 21, 2015
What is the theory of relational databases? by Dan Power Editor, DSSResources.com Relational databases organize data elements in clusters that are meaningful to users and useful for perform...	DSS Foundations	Apr 11, 2010
How does decision support processing differ from transaction processing? by Dan Power Editor, DSSResources.com Information systems can be categorized in many ways, but historically business information systems began a...	Building DSS	Jan 04, 2014
What are characteristics of a 'good' data scientist? by Daniel J. Power Editor, DSSResources.COM Understanding the characteristics of a good data scientist helps write a job description and then eva...	DSS Foundations	May 10, 2014
What are examples of routine decision support queries? by Dan Power Editor, DSSResources.com In the mid-1980s, the introduction of powerful relational database management systems (RDBMS) like Oracle ...	DSS Foundations	Jul 22, 2009
Is a Data Warehouse a DSS? What is a star schema? No, a data warehouse is not a Decision Support System. A data warehouse is however usually the "driver" and dominant component for a Data-dr...	Data-driven DSS	Aug 06, 2005
What are the components of a decision support system? by Dan Power Editor, DSSResources.com Traditionally, academics and practitioners have discussed building a decision support system (DSS) in terms...	DSS Theory	Aug 26, 2005
What is an enterprise-class translytical database? by Daniel J. Power and Ciara Heavin Translytical is a portmanteau word, in that parts of the words transaction and analytical are combined to form...	DSS Foundations	Oct 02, 2017
Is Amazon Web Services a 'good fit' for decision support and OLTP? by Daniel J. Power Editor, DSSResources.COM Amazon Web Services (AWS) hosts many popular Web applications including: Instagram, Vine, IFTTT, Netf...	DSS Foundations	Aug 25, 2013
What are physical database design tradeoffs for decision support data? by Dan Power Editor, DSSResources.com Implementing a decision support database involves tradeoffs. A designer needs to transform an ideal, logi...	DSS Foundations	Oct 01, 2008
What decision support is needed for scheduling tasks? by Dan Power Editor, DSSResources.com In many organizations, managing operations involves scheduling resources to perform tasks. Scheduling is t...	DSS Foundations	Jun 24, 2011
What should an Agile practitioner know and do? Daniel J. Power Editor, DSSResources.com Knowing agile principles and developing an agile mindset are the starting point of becoming agile. An agi...	DSS Foundations	Jul 01, 2019
Is parallel database technology needed for data-driven DSS? by Dan Power Editor, DSSResources.COM Few managers have heard of parallel computer processing and parallel databases. Nonetheless the desire of ...	Data-driven DSS	Mar 02, 2007
What is a database? by Dan Power Editor, DSSResources.com Database is a fundamental concept for information technology professionals. While some lay people have an ...	DSS Foundations	Jul 09, 2017
Can DSS impact decision outcomes? by Dan Power Editor, DSSResources.com Building a computerized decision support system does not necessarily improve decision outcomes. Sadly, a p...	DSS Theory	Apr 02, 2008
What is User Experience (UX) design for building DSS? by Ciara Heavin Managing Editor, Journal of Decision Systems and Daniel J. Power Editor, DSSResources.COM People must interact with a compu...	DSS Foundations	Nov 15, 2018
What are post-relational databases? by Daniel Power Editor, DSSResources.com Post-relational or non-relational databases implement a conceptual schema using a non-relational data mo...	DSS Foundations	Aug 20, 2016
What is the evolution of decision support and analytics architectures? by Daniel J. Power Editor, DSSResources.COM During the past 70 years as new computing technologies have been developed, the computing architectur...	DSS Foundations	Dec 05, 2018
What is a document database? by Dan Power Editor, DSSResources.com Increasingly unstructured or semi-structured documents are the drivers of new, novel decision support syst...	DSS Foundations	Nov 26, 2011
What is ACID and BASE in database theory? by Daniel J. Power Editor, DSSResources.COM Data-driven and document-driven decision support systems derive functionality from data stores and da...	DSS Foundations	Oct 12, 2013
Do DSS builders assume their targeted users are rational thinkers? by Dan Power Editor, DSSResources.com Attitudes that we, as DSS builders, have toward potential users of a proposed DSS influences our design cho...	Building DSS	Feb 26, 2011
What are examples of database project failures? by Daniel J. Power Editor, DSSResources.COM Database centered projects for decision support and transaction processing do fail. How often? Acco...	DSS Foundations	Aug 18, 2013
What are examples of bad strategic business decisions? by Daniel J. Power Editor, DSSResources.COM Bad strategic business decisions lead to bad results. The consequences of implementing the decision ma...	DSS Foundations	Jun 22, 2015
How does the Facebook database operate? by Daniel J. Power Editor, DSSResources.COM In March 2013, Facebook, the social networking megaplatform, reported it had 1.11 billion active user...	DSS Foundations	Aug 24, 2013
What is a data warehouse? by Dan Power Editor, DSSResources.com A data warehouse is a database designed to support decision making in organizations. It stores historical o...	DSS Foundations	Nov 28, 2010
How does DSS data differ from operational data? by Daniel J Power Editor, DSSResources.com Decision support data used for analytics and data-driven DSS is related to past actions and intentions...	DSS Foundations	Aug 07, 2016
Does data modeling differ for a data-driven DSS? by Daniel J. Power Editor, DSSResources.COM Creating a data model is usually the beginning of a process to develop an information system linked to...	Data-driven DSS	Aug 29, 2015
What is solution-focused agile? Daniel J. Power Editor, DSSResources.com Managers, project teams, and consultants should focus primarily on the present and future. We examine the...	DSS Foundations	Aug 02, 2019
What criteria should be used to evaluate BI/DW vendor solutions? by Dan Power Editor, DSSResources.com Selecting an enterprise business intelligence (BI)/data warehouse (DW) vendor solution is an important deci...	DSS Foundations	Dec 26, 2013
What Wikipedia resources are useful for a database management course? by Daniel J. Power Editor, DSSResources.COM Managing data is a fundamental need in organizations. More complex data, parallel processing and inex...	DSS Foundations	Aug 13, 2013
What increases success for data-based decision support? by Daniel J. Power Editor, DSSResources.com Data-based decision support development is a company-wide effort and requires many resources, includi...	DSS Foundations	Jul 09, 2017
What are the steps to develop data-based decision support? by Ciara Heavin and Daniel J. Power Encouraging and developing data-based decision support is an organization-wide effort and requires many resou...	DSS Foundations	Mar 18, 2018

DSS Home \| About Us \| Contact Us \| Site Index \| Subscribe \| What's New
	Copyright © 1995-2021 by D. J. Power (see his home page). DSSResources.COM^sm was maintained by Daniel J. Power of PowerEnterprises.net. See disclaimer and privacy statement.