Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "database terms"

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 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
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
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 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
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 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
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 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 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
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
How many DSS related pages are on the Web in Fall 2020? by Daniel Power For many years, I have been tracking search engine results for the phrases "decision support systems", "decision support", and "DSS...	DSS Foundations	Oct 24, 2020
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 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 do I need to know about Data Warehousing/OLAP? by Daniel J. Power Editor, DSSResources.COM A data warehouse is a central, integrated repository for historical, enterprise data from multiple bus...	Data-driven DSS	Oct 12, 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 MDM impact data-driven DSS? by Dan Power Editor, DSSResources.com Master data management (MDM) is a complex process made up of a number of interrelated tasks. In general, MD...	DSS Foundations	Aug 05, 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
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 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 factors impact decision support project implementation risk? by Dan Power Editor, DSSResources.com Managers should contemplate a wide range of decision support projects. Perhaps an enterprise-wide, data wa...	Evaluating DSS Projects	Aug 15, 2008
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
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
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 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 was the DSS News in October 2000? by Daniel Power Volume 1, issue number 12 of DSS News was published October 9, 2000. Then as now DSS News was a bi-weekly publication of DSSResourc...	DSS Foundations	Oct 11, 2020
What are philosophical foundations of DSS practice? by Dan Power Editor, DSSResources.com Decision support systems as a practical discipline has multiple "philosophical foundations". DSS practice h...	DSS Foundations	Apr 27, 2010
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
How many DSS related pages are on the Web? One means of finding Web sites relevant to DSS is to use a search engine. Another way is to use a Web index. AltaVista (URL http://www.altavista...	DSSResources.com	Aug 25, 2005
How does business analytics differ from data analytics? by Daniel J. Power Editor, DSSResources.COM Both business analytics and data analytics are relatively new terms in the business lexicon. Students...	DSS Foundations	Jun 24, 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
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 vendors dominate the DSS product space? In terms of Ask Dan! email, questions about DSS software and DSS vendors ranks near the top. What DSS product is best? What is the largest DSS softwar...	Evaluating DSS Projects	Aug 07, 2005
What is data mining and how is it related to DSS? by Daniel Power Editor, DSSResources.com Data mining is a data analysis innovation first discussed in the 1990s. "Big data" and analytics has led...	Knowledge-driven DSS	Nov 30, 2015
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 software tools should be used to build Web-based DSS? by Dan Power Editor, DSSResources.com Many Information Systems people, including students and managers, want to do more that try a Web-based DSS...	Building DSS	Mar 18, 2009
What is a data warehouse appliance? by Dan Power Editor, DSSResources.com In general, a data warehouse (DW) appliance is an integrated hardware and software bundled application. A...	Data-driven DSS	Feb 19, 2012
What should managers know about business intelligence and data-driven decision support? by Dan Power Editor, DSSResources.COM Most managers want to make fact-based decisions. Many large organizations have implemented database syste...	DSS Foundations	Aug 13, 2012
What are benefits of using decision support? by Daniel J. Power Editor, DSSResources.COM Organizational benefits of using computerized decision support include: Help Team Members Function ...	DSS Foundations	Dec 02, 2016
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 are the skills of a data scientist? by Ciara Heavin Managing Editor, Journal of Decision Systems and Daniel J. Power Editor, DSSResources.COM Like many of the IT professional ...	DSS Foundations	Nov 25, 2016
What is a decision support model? by Dan Power Editor, DSSResources.com In the realm of decision support, a model is a quantitative description of a phenomenon. A model replicates...	DSS Foundations	Jan 13, 2013
How is data management linked to analytics and decision support? by Daniel Power Editor, DSSResources.com Data management or data resource management refers to activities and tasks associated with capturing, or...	DSS Foundations	Aug 30, 2016
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
What are advantages and disadvantages of data warehouses? by Dan Power Editor, DSSResources.com The concept of a data warehouse for decision support traces back to about 1990 and the works of Bill Inmon...	Data-driven DSS	Dec 03, 2008
What criteria should be used for evaluating proposed plans? In the process of developing plans and alternative courses of action (COA), multiple criteria or factors should be used to determine the validity of e...	DSS Theory	Aug 16, 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.