Ask Dan! about DSS

Frequently Asked Questions about Decision Support Systems by Dan Power

Search

50 results for "database administration"

Question	Category	Date
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 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
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 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
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 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 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 the status of Clinical and Hospital Administration DSS? by Dan Power Editor, DSSResources.COM Both clinical and hospital administration decision support are evolving rapidly. HealthIT.gov is an excelle...	Knowledge-driven DSS	May 13, 2016
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 is the process for designing decision support software? by Dan Power Editor, DSSResources.COM Recently, I received an email from Michael Brito asking if I "could explain the process for designing deci...	Building DSS	Oct 22, 2006
Is security important for decision support applications? by Daniel J. Power Editor, DSSResources.COM Decision support applications often contain sensitive data that should be secured. Also, a common sou...	DSS Foundations	Apr 14, 2013
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 are the origins of SIG DSS? by Dan Power Editor, DSSResources.com SIG DSS is the Special Interest Group about Decision Support and Analytical Information Systems affiliated ...	AIS SIG DSS	Feb 13, 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 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
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 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 can organizations keep data-driven DSS and data warehouses current with changes in source systems? by Daniel J. Power Editor, DSSResources.COM In my Ask Dan column of October 22, 2006 (Vol. 7, No. 22), I answered some of the challenging questi...	Data-driven DSS	Mar 02, 2007
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 history of DSSResources.com? by Daniel J. Power Editor, DSSResources.com Since October 2, 1995, DSSResources.com has been the premier resource about computerized Decision Supp...	DSSResources.com	Jan 09, 2016
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 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 is the theory of decision support systems? by Dan Power Editor, DSSResources.com Past practice and experience usually guide computerized decision support development more than theory and g...	DSS Theory	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 important DSS articles from MIS Quarterly? by Dan Power Editor, DSSResources.com A number of terms have been used for information systems supporting management decision making including m...	DSS Foundations	Jul 27, 2016
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 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 universities offer masters degrees in analytics and data science? by Daniel J. Power Editor, DSSResources.COM Faculty entrepreneurs continue to respond to new business needs and trends in decision support tech...	DSS Foundations	May 31, 2018
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 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 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 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
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

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.