Part Two: Data Model - From SQL Server to Wide Column No-SQL

---

Hello Guys,

This blog is part two of eight part series of porting your RDBMS database to a NO-SQL wide column key value pair database. For introduction or part zero you can click here.

We already have a data model designed for the series. For the sake of continuity I will republish the data model. The stored procedures outlined in Part One Sample Use Cases do follow the same data model.

Customer: CustomerID FirstName LastName BusinessName Designation EmailAddress JoinDateTime AvatarImageURL	Item: ItemID ItemName Manufacturer Unit UnitCost Discount Quantity	Address: AddressID CustomerID AddressType Address1 Address2 City State Zip
	Order: OrderID OrderNo CustomerID OrderDateTime ShippingAddressID GrossAmount DiscountCode TotalAmount OrderStatus
	Order Details: OrderDetailsID OrderID ItemID UnitCost Quantity Amount NetAmount Status
Payments: PaymentsID CustomerID OrderID BillingAddressID PaymentDateTime		PaymentDetails: PaymentDetailsID PaymentsID PaymentMode Name Number Amount ExpiryDate AuthDetails Status

Expect part three soon as the data model was ready at the beginning of the series.

Thanks for reading!

Ashfaq Chougle

Previous: Part One: Sample Use Cases - From SQL Server to Wide Column No-SQL
Next: Part Three: Wide Column Data Model - From SQL Server to Wide Column No-SQL