This paper examines core concepts in enterprise data management, beginning with a promotional overview of a fictional data repository service that highlights real-world offerings such as cloud hosting, big data consultancy, and analytics advisory services. It then defines the functions of data warehouses, including legacy system integration and query segmentation, before describing the features of data marts as specialized subsets aligned to business unit needs. The paper differentiates supervised from unsupervised data mining, explaining how hypothesis development distinguishes the two approaches. Finally, it provides an overview of Database Management Systems (DBMS), covering relational and object-oriented database types and profiling leading vendors such as Oracle, IBM, Microsoft, SAP/Sybase, and Teradata.
Powered By Excellence — Data Repository Service
Your Data Is Critical to Your Growth!
Powered By Excellence is the only data repository service with globally located data centers across every continent, each equipped with specific security, reliability, and fault redundancy systems. Our staff includes world-class experts on the following platforms: IBM, Microsoft, Oracle, MySQL, Informix, Sybase, Teradata, and SAS — all available in-house as part of our consulting services division.
Services Offered: Analytics Advisory Services; Big Data Consultancy (MapR and Hadoop expertise for gaining insights from very large datasets); Custom Software Development; Database Hosting; SaaS Application Support; Scalable File Storage; Private Cloud Hosting (dedicated storage and unlimited virtual machines).
Customer Benefits: High performance with a world-class platform; 24/7 Administrator Access; Unlimited Virtual Machine Use; Service Level Agreement (SLA) metrics available 24/7.
Three reasons why your business needs to collect and analyze data:
Gain valuable customer intelligence and insight to design better sales and service campaigns, driving up Lifetime Customer Value.
Gain insights into managing suppliers and entire supply chains more effectively.
Know which distributors and dealers are the highest and lowest performing, and why.
Understand how gross margins and profitability change across an entire product lifecycle — and why.
Trusted Provider of Data Repository Services — ISO 16363 and DIN 31644 Certified (2013).
The functions of a data warehouse include integrating the diverse and often disparate legacy database and transactional systems of an enterprise into a single, unified system of record (Benander, Benander, Fadlalla, & Gregory, 2000). Data warehouses also require an intensive amount of integration platform support. Of the many integration technologies now being adopted to unify data warehouses, XML is increasingly being adopted as a standard (Van, 2002). Data warehouses are often designed to support multiple ontologies of data structures essential for running a business, which enforces a logical file and data structure throughout the entire organization (Selma, Ilyas, Ladjel, Eric, Stéphane, & Michael, 2012).
A second function of a data warehouse is to segment out the data used more frequently for queries from the data in the actual warehouse used for reporting and analysis. This second aspect of a data warehouse ensures higher levels of performance on more frequent queries, preventing routine query activity from degrading the performance of deeper analytical workloads.
A data mart is often a smaller subset of a data warehouse or other data platform, typically designed to support the needs of a given business strategy or objective (Benander, Benander, Fadlalla, & Gregory, 2000). The term data mart can apply equally to evaluational data, operational data, metadata, or spatial data. Data marts are designed to align with the strategic information requirements of a given business unit or functional area of an organization (Benander, Benander, Fadlalla, & Gregory, 2000). Examples include dedicated data marts for accounting, finance, marketing, sales, and service.
A data mart is often designed as a one-dimensional model or star schema, composed as a fact table or multi-dimensional table (Benander, Benander, Fadlalla, & Gregory, 2000). This structure allows business users to query their specific domain of data efficiently without accessing the full warehouse, improving both performance and data governance.
"Hypothesis-driven versus exploratory data mining methods"
"DBMS definition, relational and object-oriented database types"
"Oracle, IBM, Teradata, and big data market dominance"
You’re 47% through this paper. Sign up to read the remaining 3 sections.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.