Website design process and steps.

Hello guys please, can you give some advice for my website design process? I'll be very grateful.

Fist I will describe the steps I take for the design process , then I'll try to explain it and give more details about it.

      1. First contact
      2. Determine the project size, direction and scope.
      3. Site map and wire-framing in XD or Figma sometimes I use Edraw Mind Map
      4. Content gather and categorize and if it is necessary(in the most cases) generate it…

Website design process and steps.

How to Design a Table for scoring system in Cassandra?

I have a table for my products in Cassandra. In this table I store the product name and seller name (there may be thousands of sellers) and score (Product score of the seller) so as following

CREATE TABLE products (     product_name varchar,     seller_name varchar,     score    int,     primary key (product_name, seller_name) ); 

I need to update score in my code

UPDATE products SET score = 2 WHERE product_name = "iphone-7" AND seller_name = "jack" ; 

Everything is fine, except for Select Query:

SELECT * FROM products WHERE product_name = "iphone-7" ORDER BY SCORE DESC; 

I need to get products by score order But as you know, it is not possible to sort without score being the primary key But if I put the score in the primary key, it will be not possible to update it what’s the solution?

DW design and storage

I am working on new DW design. I have read through many blog posts and training videos regarding DW layers/areas/zones. It seems there are terms that are used or defined differently.

Below I have listed the areas that make sense to me. But I am kind of new and I haven’t built many real-life solutions from scratch.

Would you describe DW zones differently? (image/notes are below)

At my corporation, we have general DW which is conglomerate of tables for old/new system primary capturing history data for loading into SSAS cubes for a small portion of business reporting need (Sales/ Production/ Purchasing). All related to historical transactions aggregation. And it runs nightly to re-load everything anew.

There is a new DW project (or rather an update to an existing solution), that is concerned with future data for Sales/Inventory for projecting demand balance levels and reviewing sales order data. This database is small in size regarding tables/ rowcounts. The current Database size is small as well (RowSizeGB 0.00011, LogSizeGB 0.00030).

What kind of DW solution would this be described as? What kind of storage areas/ process would you recommend for capturing the datasets?

Currently, this planning database refreshes with TSQL scripts on SQL box. We’re looking at plans to update the DW/ETL design.

Any thoughts or recommendations on such a solution?

We are a Microsoft shop. We’re looking to possibly move to cloud (ADF, AAS, ASQL). But that’s a slow transition and this redesign will likely be done for free cost options (SSIS/ TSQL/ TimeXteneder DWA tool we currently used). Unless there is convincing reason to do this in Azure cloud. The corp wants to stop using TXDWA, and possibly moving to Informatica next year. So this whole thing will be scrapped & redone in a year (possibly).

This DW update was requested by my manager. I think he wants to see how I work the project.

Any thoughts or advice?

DW stages/areas/zones

Source. Sources contain the data of interest. Direct connections to OLTP source system is typically scowled upon due to concerns of performance impact, and data sprawl caused be creating too many views.

Operational data store (ODS). A replica of OLTP tables raw system data without transformation. Used while fetching data for loading staging targets. Provides a snapshot of the latest data. Fast load time. (AKA- Operational data exchange, Mirror OLTP).

Configuration (DWConfig). An area for storing data not kept in source system for use in staging. (e.g. AOP, Historical data snapshots, Business cross reference)

Stage (DSA). The data staging area. Data cleansing, scrubbing, merging, and business rules happen here. ETL Transformations. Sourced from the ODX. Referred to as “Integration”.

Data warehouse (DW). A clean, organized, single representation of your data. Data comes from a variety of sources to support strategic and tactical decision making. It’s structured as a schema of views on top of an existing Stage.

Semantic/ OLAP. Category of technology that enables users to their data in a fast, interactive, easy to use manner.

Data Mart. Data mart is usually subject-specific for a specific group. An autonomous subset of the complete data warehouse that is functionally defined by facts and dimensions. The data mart is composed of fact and dimensions that will be derived from the data warehouse but might be slightly different from the original ones.

enter image description here

WotC Product Identity and Design

I have a simple question, at least simple for people who understand legalities better than me. The way I understand the OGL and SRD, is that you can use anything from within and sell it without restrictions. That is, without using anything listed under product identity. And this is as simplified as it gets in my head.

For example, a Lizardfolk can be used since the monster is in the SRD, but a Lizardfolk Shaman cannot, since he isn’t. That much is clear. The question comes now for the design.

I am glad that things like 5e LaTeX and GM Binder exist. But can one really make his documents look exactly like the WotC ones? Like the red splatter on the cover or the fonts inside? Are these things not product identity?

Another question is about copying material from the SRD. Can one, let’s say, write a campaign setting that complies with the SRD, and include inside this campaign setting some magic items or monsters from the SRD? And by include I mean full text, one to one matching. The artwork can be different.

Thanks in advance for any possible answers.