Want to get a real-world perspective on what a Data Architect does?
Want to get a real-world perspective on what a Data Architect does?
Check some job descriptions and find out
http://www.indeed.com/q-Data-Architect-jobs.html
— -
Check how Data Architecture is defined in Wikipedia
http://en.wikipedia.org/wiki/Data_architecture
— -
You can also check the resources provided on Implementing Data Warehouse at:
http://salearningschool.com/displayArticle.php?table=Articles&articleID=775
How to implement BI/Warehouse
- Crime Detection using BI
- Credit Card fraud detection using BI
- A presentation on Oracle Data Mining
- Oracle by Example — Business Intelligence
- Oracle Data Mining Components
- Business Intelligence with Microsoft SQL Server Reporting Services — Part 1
- SQL Server 2005 Analysis Services Tutorial
- SQL Server 2005 Data Mining
- BI for MySQL
- MySQL in Data Warehousing & Business Intelligence
- Business Intelligence in Mysql
—
You can also check our article on : steps on Data Warehouse Design and Implementation
http://salearningschool.com/displayArticle.php?table=Articles&articleID=777
Some related stuff
- Dynamic Management Views
- How to implement BI/Warehouse
- Overview on SAP CRM
- Random Information on BI
- Steps in Data Warehouse Design and Implementation
- What is Data Warehousing?
— —
Now, how much help does your education provide?
Depending on the school and the degree, you may be taught some or all of the following:
The different DBMS models such as Relational, Object Oriented, Hierarchical, Entity-Attribute-Value (not sure about the term but Magento uses this). Yes, the general database stuff. Data Integrity, Data Consistency stuff, and Data Security stuff. Probably, the ANSI SQL, and may be a DBMS tool such as MS SQL Server.
You will also get the details of database design (usually relational) and the steps required for designing. Normalization, transaction concept will be there. Depending on the school and course you may need to study relational algebra, and the mathematical stuff behind RDBMS (and also Normalization). Now do these mathematical stuff help? depends, if you become a researcher in the DBMS field, it will help.
You probably will be taught, the way the DBMS data are stored in files, and the different concepts used for indexing the data. Now are these useful anyway?. Not much, if you develop enterprise applications or DB based desktop or web or mobile applications. In such cases, only the DBMS design concepts are the most useful lessons including the general concept of Normalization. However, if you work for a company who develops DBMS systems such as MySQL, SQL Server, or you want to create the Next DBMS system, then yes, the lessons are a must.
You will also be taught different concepts such as concurrency control, transaction management, logging strategies for DBMS systems, data locking (cell level, row level, table label, or DB level) and query optimization (not how to write optimized SQL query but how to write code in C for example so that those SQL queries run effectively and efficiently). All these lessons will not be of much help if you want to work in the corporations developing business software or db based mobile or desktop or web-applications. However, all these are must learn if you want to write DBMS systems such as MariaDB, MongoDB, MarkLogic DB, or a DBMS system written by you for mobile, or web, or to address the next Big Data problems.
You may be given concepts behind Data Warehousing. However, you may not be taught the detail design, and implementation of data warehouses in a Basic and/or in the first DBMS course. You may want to learn Data Warehouse design on your own.
If you take a Distributed DBMS course, it will again be theoretical (if you consider writing DB-based applications to be the practical ones) also the practical aspects (if you consider writing Distributed DBMS to be practical stuff) of creating distributed DBMS systems or extending existing DBMS systems such as MSSQL Server for distributed database features. The team behind MS SQL server must be using these concepts. When the database will be distributed in multiple sites (row wise division or column wise division), how to provide the support, you will be taught that. and How to deal with data indexing for such distributed systems will also be taught. Transaction control, logging related protocols will also be taught. For the most part, it will help, if you want to develop such distributed DBMS systems (not to use a DBMS system to develop enterprise, desktop, or web-applications (DB Based))
And Yes, you may also be taught, how to utilize the distributed database related features in DBMSes such as Oracle or MS SQL Server. And also you may be taught, how to utilize those concepts in an application such as Distributed Hotel Reservation System (the DB is distributed across different cities, and/or countries). Yes, this will help to develop large scale distributed enterprise systems.
—
A Data Mining course may be useful to find patterns in data and utilize the patterns. A Data Mining course may also teach you text mining, web-text mining strategies. Though mostly theoretical concepts will be taught; however, may help in practical positions depending on where you work.
