[MODERATE EMAIL] Re: Separation database for inventory module

[Deepak Dixit-3]

Hi Jayachandra02,

your email has been moderated, Please subscribe mailing list
http://ofbiz.apache.org/mailing-lists.html


Thanks & Regards
--
Deepak Dixit
www.hotwaxsystems.com
www.hotwax.co

---------- Forwarded message ----------
From: "[hidden email]" <[hidden email]>
To: <[hidden email]>
Cc:
Bcc:
Date: Wed, 21 Mar 2018 05:18:10 -0000
Subject: Re: Separation database for inventory module


On 2018/03/20 10:15:41, Rajesh Mallah <[hidden email]> wrote:

> Hi Jaya ,
>
> thanks for sharing the interesting details .  Pls allow some time for
> detailed reply
> which database do you use btw?
>
> regds
> Mallah.
>
> On Tue, Mar 20, 2018 at 2:40 PM, [hidden email] <
> [hidden email]> wrote:
>
> >
> >
> > On 2018/03/19 15:23:07, Rajesh Mallah <[hidden email]> wrote:
> > > Hello Jaya ,
> > >
> > > Could you consider hinting why you would want certain entities in a
> > > separate database?
> > > What are you trying to achieve?
> > >
> > > regds
> > > mallah.
> > >
> > >
> > > On Mon, Mar 19, 2018 at 8:23 PM, [hidden email] <
> > > [hidden email]> wrote:
> > >
> > > > Hi All,
> > > >
> > > > In Ofbiz I  want to  create separate database for inventory module

with
> > > > dependency tables like InentoryItem & so on. I don't see any issue
> > foreign
> > > > key relations between dependency tables(like product, order related)
> > but i
> > > > see the view entities are using many places in application hence
some

> > of
> > > > the inventory process may breaks.
> > > >
> > > > Appreciate the response/solution for this. Thanks for advance.
> > > >
> > > > Below are the tables list and view entity list.
> > > >
> > > > Inventory Entities
> > > > ---------------------------
> > > >
> > > > InventoryItem
> > > > InventoryItemDetail
> > > > InventoryItemAttribute
> > > > InventoryItemStatus
> > > > InventoryItemTempRes
> > > > InventoryItemType
> > > > InventoryItemTypeAttr
> > > > InventoryItemVariance
> > > > InventoryTransfer
> > > > OldOrderItemInventoryRes
> > > > PhysicalInventory
> > > > InventoryItemLabel
> > > > InventoryItemLabelAppl
> > > > InventoryItemLabelType
> > > > OrderItemShipGrpInvRes
> > > >
> > > >
> > > > View Entity with depenndencies
> > > > --------------------------------
> > > >
> > > > OrderHeaderItemAndInv(Not in use)
> > > >         MemberEntity
> > > >         -------------
> > > >         OrderHeader
> > > >         OrderItem
> > > >         OrderItemShipGrpInvRes
> > > > OrderHeaderItemAndInvRoles(Not in use)
> > > >         MemberEntity
> > > >         -------------
> > > >         OrderHeader
> > > >         OrderItem
> > > >         OrderRole
> > > >         OrderItemShipGrpInvRes
> > > >
> > > > OrderItemAndShipGrpInvResAndItem - Using to calculation  time of
> > inventory
> > > >         MemberEntity
> > > >         ------------
> > > >         OrderItem
> > > >         OrderItemShipGrpInvRes
> > > >         InventoryItem
> > > >
> > > > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > > >         MemberEntity
> > > >         ------------
> > > >         OrderItem
> > > >         OrderItemShipGrpInvRes
> > > >         InventoryItem
> > > >
> > > > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > > >         MemberEntity
> > > >         ------------
> > > >         InventoryItem
> > > >         OrderItemShipGrpInvRes
> > > >
> > > > ProductInventoryItem - Prouction usage
> > > >         MemberEntity
> > > >         ------------
> > > >         Product
> > > >         InventoryItem
> > > >
> > > > ProductInventoryItemAndItemIssuance
> > > >         MemberEntity
> > > >         ------------
> > > >         Product
> > > >         InventoryItem
> > > >         ItemIssuance
> > > >
> > > > ItemIssuanceAndInventoryItem
> > > >         MemberEntity
> > > >         ------------
> > > >         ItemIssuance
> > > >         InventoryItem
> > > > ItemIssuanceInventoryItemAndProduct
> > > >         MemberEntity
> > > >         ------------
> > > >         ItemIssuance
> > > >         InventoryItem
> > > >         Product
> > > >
> > > > ProductInventoryItemAndItemIssuance
> > > >         MemberEntity
> > > >         ------------
> > > >         Product
> > > >         InventoryItem
> > > >         ItemIssuance
> > > >
> > > > InventoryItemAndDetail
> > > >         MemberEntity
> > > >         ------------
> > > >         InventoryItem
> > > >         InventoryItemDetail`
> > > >
> > > > WorkEffortAndInventoryAssign
> > > >         MemberEntity
> > > >         ------------
> > > >         InventoryItem
> > > >         WorkEffortInventoryAssign
> > > > WorkEffortAndInventoryProduced`
> > > >         MemberEntity
> > > >         ------------
> > > >         WorkEffortInventoryProduced
> > > >         InventoryItem
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Facility Related Entities
> > > > -------------------------
> > > >
> > > > Facility
> > > > FacilityAttribute
> > > > FacilityContactMechPurpose
> > > > FacilityContent
> > > > FacilityGroup
> > > > FacilityGroupMember
> > > > FacilityGroupRole
> > > > FacilityGroupRollup
> > > > FacilityGroupType
> > > > FacilityLocation
> > > > FacilityLocationGeoPoint
> > > > FacilityParty
> > > > FacilityType
> > > > FacilityTypeAttr
> > > > ProdCatalogInvFacility
> > > > OldFacilityRole
> > > > ProductFacility
> > > > ProductFacilityLocation
> > > > ProductStoreFacility
> > > >
> > > >
> > > > View Entity depenndency
> > > > ---------------------------
> > > >
> > > > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > > >         MemberEntity
> > > >         ------------
> > > >         OrderHeader
> > > >         ProductStoreFacility
> > > >         ProductStore
> > > >         Facility
> > > >
> > > > FacilityAndContactMech(Use in OrderView.groovy)
> > > >         MemberEntity
> > > >         ------------
> > > >         Facility
> > > >         FacilityContactMech
> > > >         ContactMech
> > > >
> > > > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.

groovy

> > and
> > > > EditFacilityLocation.ftl)
> > > >         MemberEntity
> > > >         ------------
> > > >         FacilityLocation
> > > >         FacilityLocationGeoPoint
> > > >         GeoPoint
> > > > ProductFacilityAndPostalAddress(Not in Use)
> > > >         MemberEntity
> > > >         ------------
> > > >         ProductFacility
> > > >         FacilityContactMech
> > > >         ContactMech
> > > >         PostalAddress
> > > >
> > > > Thanks & Regards
> > > > Jayachandra
> > > >
> > > >
> > > Hi Rajesh,
> >
> > I am going to create facility for each supplier(In my case which is

approx
> > 300) and each facility has all products info(In my case 7000 products)
> > which means i am going to nearly 21 lac records in the entities.
> >
> > So performing inventory CURD operation on inventory
> > tables(reserve/receive) is going to be high. And which may also cause
the

> > actual performance issue with transactional data (order, product).
> >
> > To remove dependency with order/product info i am planning to do this.
> >
> > Thanks & Regards
> > Jaya
> >
> >
> >
>

Hey rajesh,

I use mysql 5.6 database.