Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "database administrator"

Question	Category	Date
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 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
Who manages decision support capabilities in an organization? by Daniel J. Power Editor, DSSResources.COM The Director of Decision Support or the Chief Information Officer (CIO) or the IT manager or the Data ...	DSS Foundations	Jul 16, 2018
What Data Warehouse software and configurations are used in universities? The best source for finding information on this topic is on the Higher Education Data Warehouse Configurations page at http://www.georgetown.edu/users...	Data-driven DSS	Aug 06, 2005
What is the design concept for PlanningDSS.com? In the Ask Dan! in DSS News of May 22, 2005, I introduced PlanningDSS.com and indicated that in a future column I might explain the overall concept an...	Planning DSS	Aug 07, 2005
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 is an information system? by Daniel J. Power Editor, DSSResources.com Modern information systems combine computing hardware, software, networking and storage infrastructu...	DSS Foundations	Jan 11, 2020
What is the impact of information management on the organization? by Daniel J. Power Editor, DSSResources.COM Thirty years ago, at the start of my career, I addressed this question (cf., Power, 1983). My MIS Qua...	DSS Foundations	Nov 24, 2013
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 staffing is needed for DW/BI/DSS? by Dan Power Editor, DSSResources.com Some Ask Dan! questions are more difficult for me to answer than others. On July 6, 2006, Aileen MacKay se...	Building DSS	Oct 22, 2006
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 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 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 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 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 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
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 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
How can managers improve security for decision support applications? by Daniel J. Power Editor, DSSResources.COM Decision support security is important. Managers and Information Systems staff must understand and ex...	DSS Theory	Apr 14, 2013
What is PlanningDSS.COM? Recently, DSSResources.COM registered a new domain name, PlanningDSS.COM. The name summarizes the purpose of the web site -- it is a planning decisi...	Planning DSS	Sep 13, 2005
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 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 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
How should Decision Support Systems present apparently "Bad News"? On Saturday, January 22, 2005, a special issue of DSS News was sent to all 1066 subscribers. The purpose of the special mailing was to showcase some...	Building DSS	Aug 16, 2005
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
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
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 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 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 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 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
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
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 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 SQL knowledge do managers need for decision support queries? by Dan Power Editor, DSSResources.com Structured Query Language (SQL)is considered difficult for most managers to learn and use. SQL is a complex...	Data-driven DSS	Mar 18, 2011
What is relational algebra? by Daniel J. Power Editor, DSSResources.COM Relational algebra is a formal system, i.e., a well-defined system of abstract thought, for manipulat...	DSS Foundations	Aug 07, 2014
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
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
What is the potential size of the NSEERS database? The U.S. Immigration and Naturalization Services (INS) is creating a number of very large databases to support a variety of operations and processes. ...	DSS Applications	Aug 07, 2005
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
How does a Web-based DSS differ from a Web-enabled DSS? by Dan Power Editor, DSSResources.com In 1998, I noted that “when vendors propose a Web-based DSS they are referring to a computerized system...	DSS Foundations	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.