Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "physical database design"

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
What is virtualization? by Daniel J. Power Editor, DSSResources.com Actual and virtual are antonyms. An actual disk drive is a physical drive while a virtual drive only ...	DSS Foundations	Sep 29, 2017
What are sensors, actuators and effectors? by Daniel J. Power Editor, DSSResources.COM Sensors provide data on the immediate, surrounding or ambient environment of interest for control or ...	DSS Foundations	Mar 16, 2019
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 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 user characteristics are important when designing decision support applications? by Daniel J. Power Editor, DSSResources.COM Answering the question "Who will use a decision support application?" is critical in interface and ap...	DSS Foundations	Jun 08, 2013
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
How does a data architecture impact decision support capabilities? by Daniel J. Power Editor, DSSResources.COM A data architecture is important, but sometimes the task of creating a formal architecture document se...	DSS Foundations	Mar 31, 2015
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 specific benefits of document-driven DSS? by Dan Power Editor, DSSResources.com Document-driven DSS is a relatively new category of computerized decision support. These systems assist in ...	DSS Foundations	Aug 02, 2010
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
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 is a data flow diagram? by Daniel J. Power Editor, DSSResources.com A data flow diagram (DFD) is a graphical representation of the flow of data from external actors, age...	DSS Foundations	Aug 03, 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
Can we engineer effective decision support systems? Daniel J. Power Editor, DSSResources.com Building effective computerized decision support systems is possible and increasingly common. Understandi...	Building DSS	Dec 30, 2012
Can DSS and Decision Support technologies help reduce the threat of terrorism? by Daniel J. Power Editor, DSSResources.COM Lest we forget. I want to remember those who died, were injured, and were directly impacted by the te...	DSS Applications	Dec 29, 2015
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 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 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 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 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 technical and human factors influence DSS success? by Dan Power Editor, DSSResources.com A decision support system is a success when it is used and when its use actually makes a positive differe...	Building DSS	Jul 23, 2008
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 is the relation between Design Science and building DSS? Daniel Power Editor, DSSResources.com For many years, there has been an interest in transferring the concepts and techniques from the broad fiel...	Building DSS	Apr 03, 2016
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
How does edge computing impact decision support? by Daniel J. Power Editor, DSSResources.COM Edge computing means more data for predictive analytics and model-driven decision support can be proc...	DSS Foundations	Feb 10, 2019
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
How do data storage strategies differ among uses? by Daniel J. Power Editor, DSSResources.COM Everything that happens is being digitized. Customers are data, processes are data, supply chains are...	DSS Foundations	Aug 13, 2018
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 is the best approach for organizing data? by Daniel J. Power Editor, DSSResources.COM In an information technology context, organizing means to arrange data in a coherent form and to syst...	DSS Foundations	Jul 25, 2013
What are the basics of data warehousing? by Daniel J. Power Editor, DSSResources.COM For at least one hundred years, warehousing has referred to the short- or long-term storage of items ...	DSS Foundations	Apr 24, 2014
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 Group Decision Support System (GDSS)? How do GDSS work? Let's start with a definition. A Group Decision Support System (GDSS) is an interactive, computer-based system that helps a team of decision-makers so...	Group DSS	Aug 06, 2005
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 is data warehousing? by Dan Power Editor, DSSResources.com For at least a hundred years, warehousing has referred to the short or long term storage of items in a spec...	DSS Foundations	Feb 18, 2010
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
How can ambient intelligence assist people in decision making? by Daniel J. Power and Ciara Heavin Placing sensors and other computing devices in working and living spaces creates opportunities for real-time c...	DSS Foundations	Aug 06, 2018
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
What is a data lake? by Daniel J. Power Editor, DSSResources.COM Data lake is a metaphor for a data storage structure. In the physical world, a lake is a basin filled...	DSS Foundations	Aug 10, 2018
What is digital data? by Daniel J. Power Editor, DSSResources.COM Blog posts, tweets and high definition movies are all digitized. We live in a digital universe of bit...	DSS Foundations	Jan 04, 2020
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 is evidence? by Daniel J. Power Editor, DSSResources.COM Evidence is an abstract idea that plays a significant role in human thinking and decision making. The...	DSS Foundations	Apr 16, 2018
How can simulation be used for decision support? Questions about using simulation for building a DSS are reasonably frequent in my Ask Dan! email. So this column has been in the works for some time, ...	Model-driven DSS	Aug 06, 2005

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.