Database Technology
Data Warehouse and Data Mart
Data and Text Mining
Business Intelligence (BI) and Analytics
Digital and Physical Document Management
100
stores data generated by business apps, sensors and transaction processing systems (TPS).
What is ......Database
100
data warehouse
What is ....... is a specialized database containing data that are summarized in various ways so that they are ready for quick responses to inquiries.
100
the process of analyzing data from different perspectives and summarizing it into information that can be used to increase revenues, decrease costs or both.
What is ..... Data mining (data discovery)
100
Allows companies to know what questions to ask and find answers to them.
What is ..... Business Intelligence
100
Volume of physical documents in growing up to what percentage a year
What is .... 30% per year
200
2 types of databases:
What is........ Centralized database Distributed database
200
a data mart
What is .... is smaller and serves a specific department or function, such as finance, marketing, or operations.
200
the process of deriving high- quality information from text.
What is .... Text mining
200
what are three kinds of example questions that a BI group might be asking to collect data
What is ... What products were bought in the last six months? Who purchased them? Which sales agents were involved? What type of cross-selling potential is there? How does the sales trend break down by product group over the last five years? What do daily sales look like in each of my sales regions?
200
which are documents that record business dealings such as contracts, research and development, accounting source documents, memos, customer/client communications, and meeting minutes
What is .... Business records
300
Data Management Systems (DBMS) Functions
What is .... Data -filtering and profiling - integrity - synchronization - enrichment - maintenance
300
Benefits of a Data Warehouse
What is ..... -warehouse data are not volatile -data can be queried and analyzed much more efficiently than OLTP application databases.
300
75% of an organization’s data are non- structured, they consist of what
What is ...word processing documents social media text messages audio/video images
300
The automated control of imaged and electronic documents, page images, spreadsheets, voice and e-mail messages, word processing documents, and other documents through their life cycle within an organization, from initial creation to final archiving or destruction.
What is .... Document management
400
3 principles that help to guide IT investment decisions:
What is .... Principle of Diminishing Data Value. Principle of 90/90 data use. Principle of data in context.
400
Databases vs Data Warehouses
What is .... Databases -Store data Volatile data – data analysis is too difficult Data Warehouses -Respond to analysis questions critical to business Non-volatile data Data can be queried and analyzed more efficiently
400
explain two benefits of Data and Text Mining
What is .. - tool in helping understand and meet the needs of customers. - Helps not just analyze the past but predict the future.
400
Consist of hardware and software that manage and archive electronic documents and also convert paper documents into e-documents and then index and store them according to company policy.
What is ... Document management systems (DMS)
500
Master data management (MDM)
What is ...... a set of processes to integrate data from various sources or enterprise applications to create and maintain a more unified view of a customer, product, or other core data entity that is shared across systems.
500
better for a strategic business unit (SBU) or a single department. Data Mart or Data Warehouse
What is .... Data marts
500
Two Text Analytic Procedures include
What is ..... - Documents are explored. - Challenge of the exploration effort (misspelled or abbreviated words, acronyms, or slang)
500
Who is the best CIS 190 Prof at Messiah
What is ... Professor Jennifer Engle
500
A DMS can help a business to become more efficient and productive by: (just get one)
What is ... • Enabling the company to access and use the content contained in the documents • Cutting labor costs by automating business processes • Reducing the time and effort required to locate information the business needs to support decision making • Improving the security of the content, thereby reducing the risk of intellectual property theft • Minimizing the costs associated with printing, storing, and searching for content.
M
e
n
u