You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Deepak Dixit <de...@hotwaxsystems.com> on 2018/03/21 05:55:42 UTC
[MODERATE EMAIL] Re: Separation database for inventory module
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: "jayachandra02@gmail.com" <ja...@gmail.com>
To: <de...@ofbiz.apache.org>
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 <ma...@gmail.com> 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, jayachandra02@gmail.com <
> jayachandra02@gmail.com> wrote:
>
> >
> >
> > On 2018/03/19 15:23:07, Rajesh Mallah <ma...@gmail.com> 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, jayachandra02@gmail.com <
> > > jayachandra02@gmail.com> 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.