SYSTEMS DEVELOPMENT AND DECISION MAKING PPP3-6.pptx

There are five rules that pertain to the relational

Info icon This preview shows pages 42–46. Sign up to view the full content.

There are five rules that pertain to the relational database model: The order of tuples (list of elements) and attributes is not important. Every tuple is unique: For every record, there is an attribute that differentiates it from any other tuple. Cells cannot contain more than one value. All attributes must be from the same domain, such as name, date, age, etc. (i.e., if the attribute is name, a date cannot be entered into that cell). Table names and attribute names must be unique—no two tables can have the same name in a database.
Image of page 42

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Big Data A very large depository using powerful computers to distributed data sets that are too complex or large for traditional data processing systems to manage. Helps business gain insight that can lead to new trends, innovation and discovery, and new business strategies. Typical size of big data is a petabyte(1,024 terabytes) Can be structured, semi-structured, or unstructured, and can handle raw data that can be mined or analyze When defining big data, three factors to consider are volume, variety, and velocity. Data warehouse A system used track and collection real-time data from a central warehouse of historical data, external market data, or information and combined current and timely data for analysis, data mining and reporting. Data warehouses is a central libraries of data that are combined from one or more sources and organized by subject to support organizational managers. Data mart Is a subset of data warehouse typically focused on a single departments or strategic business function.
Image of page 43
Transferring Data to Data Warehouses Extraction, transformation, and loading (ETL) A process in which data is extracted, consolidated, scrubed, transforms, and then transferred to the data warehouse. Extract – obtain information from various resources when needed and the extraction process in ETL can be lengthy, so data already extracted can be processed and loaded. Transform – based on user needs, information can be reformatted and updated Load – add the reformatted data to data warehouse ETL runs in parallel and not sequential order Data Warehouse Essentials Data marts and data warehouses are organized by subject or function, they use OLAP, and they are multidimensional, integrated output dependent on time. Data warehouses is used to ensure data quality, data governance, metadata, and the users. Two key elements that make up the data warehouse are the presentation and the staging area. Regardless of the confidentiality or sensitivity of information, an information policy ensures the standardization and accuracy of the data in the data warehouse during and after data warehouse implementation.
Image of page 44

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Data Mining A process used by business to analyze internal factors in which large amount of data is examined in order to generate new data to improve business performance. Information that can be obtained using data mining includes: Associations - data that are linked to a specific event(e.g. customer purchase) Classifications - look for patterns that indicate customer or entity behavior in order to target marketing efforts.
Image of page 45
Image of page 46
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern