Chapter 5 set 1

What are some other creative applications addressing city problems that could be developed using NYC's open data policy?

Encouraging creative projects with the purpose of defining public policy. Citizens are allowed to give input on documents that are being created.

What are some difficulties in managing data?

Data is always rapidly changing, accumulating, and sometimes it's necessary to store it for long periods of time. Data storage can also be disorganized and stored in multiple places, making it hard to find. New sources of data that is generated by the pub

Data governance

an approach to managing information across an entire organization. Policies and processes are specially designed for creating, handling, collecting, and protecting company information. Purpose is to make information clear and available to those with grant

Master data

core data that spans across enterprise information systems. It is applied to multiple transactions and used to categorize valuate transaction data

Transaction data

data which is generated and captured by operational systems and describe the business' activities.

Big data

used for predictions by applying mathematics to data and generating probabilities. Diverse, high volume and high velocity information assets that require new forms of processing to enable enhanced decision making, insight discovery, and process optimizati

characteristics of Big Data.

The data that it holds a large variety of data, the data is structured, unstructured and even partially structured. The data can also be generated at a high velocity. It can be processed, analyzed and transformed in a very reasonable amount of time. The l

Describe how companies can use Big Data to gain competitive advantage.

Some companies have used it to be able to support large quantities of users on their website. Making Big Data readily accessible for stakeholders in order to make improvements and faster. Data can also be processed as a whole for a company, and therefore

data model

diagram the represents the information and relationships about a person, place, thing, or event.

primary key

The identifier field that unique to a record so that it can be retrieved, updated, and sorted.

secondary key

field with some identifying information but does not identify the record with complete accuracy.

main functions of the DRL database system?

They maintain research operations (known as the DFD) that monitor the earth atmospherically for environmental studies or security. They also monitor match ups of satellite images that cannot be sent to certain locations based on security regulations.

advantages and disadvantages of relational databases?

a. Advantages: related tables of data can be joined based on related primary keys of other data tables.
b. Disadvantages: Due to the large amounts of tables that can be conjoined, it can make the design very complex, which leads to slow searching and acce

benefits of data dictionaries?

provide information on each attribute and their reason for being in the database - it tells how the attribute is used business functions, reports and applications, and when the attribute needs updating.

benefits of the hospital's data warehouse.

data warehouse has storage systems for each hospital's medical records and paCS data. There is also a backup storage systems in order to maintain and protect patient records. This data warehouse can also be access through a web browser.

Differentiate between data warehouses and data marts.

Data warehouse is the storage of historical data that is organized by subject in order to support decision makers within the organization. Datamart is a low scaled version designed for individual department etc.

Describe the characteristic of a data warehouse.

a. Organized by business dimension or subject - data is organized by entities or attributes.
b. Use online analytical processing - quick and efficient transactions can be made online
c. Integrated - data are collected from multiple systems and then integr

three possible architectures for data warehouses and data marts in an organization?

Source systems, data integration, storing data

knowledge management?

Process that helps organizations manipulates important knowledge. The knowledge exists in a format, which can be exchanged among users.

explicit knowledge?

deals with more objective, rational and technical knowledge. In a company, it is the policies, procedures, reports, products and goals.

tacit knowledge

cumulative store of subjective or experiential learning. Organizations experiences, insights, expertise, trade skills and values.

knowledge management system cycle.

Create knowledge, capture knowledge, refine knowledge, store knowledge, manage knowledge, and disseminate knowledge.