Jay Allen

Information Systems and Database Architect at Relational Models LLC
Has 10+ Years Of Experience

Badges

User Activity

Almost 5 years ago

Replied to reviewer1389651 Is a data warehouse the best option to consolidate data into one location?

@reviewer1389651 I believe you have misunderstood the meaning of "non-volatile" in the definition of data warehouse. If the ODS of a top-down architecture is temporally modeled, then the data captured is dynamic as data changes in the source systems. Non-volatile means that…

Almost 5 years ago

Answered a question: What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?

Snowflake is a columnar stored database. It is not a “data lake.”

Almost 5 years ago

Answered a question: Is a data warehouse the best option to consolidate data into one location?

Your question is one about architecture, but I see some answers about the technology. Choosing technologies is just as critical, but to your question, @David Rossi has it right. It sounds like a straightforward DW requirement. With the multiple source systems and potential…

Answers

Almost 5 years ago

Cloud Analytics

What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?

Almost 5 years ago

Data Warehouse

Is a data warehouse the best option to consolidate data into one location?

About me

With experience in data architecture for OLTP applications, business intelligence/data warehousing, data governance and master data management for a broad spectrum of industries, I offer unique insight to sound data management and data architecture practices for any business.

* Leader and mentor of database and software engineers.
* Software and database architect of systems focusing on availability, cost of ownership, compatibility, scalability, performance, and security.
* Evangelist promoting the business value of temporal relational data modeling for both OLTP and data warehousing systems, best practices in data governance, master data management and the software development lifecycle.