Separation database for inventory module

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Separation database for inventory module

jayachandra02@gmail.com
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

Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Rajesh Mallah
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
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Paul Foxworthy
Hi Jaya,

As you've just shown, inventory data is interconnected with many other
things. If you were to proceed with this, I doubt it could be contributed
to the OFBiz project.

If you want to integrate OFBiz with other data in other databases, have you
considered database replication to synchronise OFBiz inventory data with an
external database?

If the problem is that inventory data could get very large and you want to
manage separate storage for it, have you considered using a DBMS that
provides partitioned tables?

Cheers

Paul Foxworthy


On 20 March 2018 at 02:23, 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
> >
> >
>



--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

jayachandra02@gmail.com
In reply to this post by Rajesh Mallah


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


Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

jayachandra02@gmail.com
In reply to this post by Paul Foxworthy


On 2018/03/20 02:43:26, Paul Foxworthy <[hidden email]> wrote:

> Hi Jaya,
>
> As you've just shown, inventory data is interconnected with many other
> things. If you were to proceed with this, I doubt it could be contributed
> to the OFBiz project.
>
> If you want to integrate OFBiz with other data in other databases, have you
> considered database replication to synchronise OFBiz inventory data with an
> external database?
>
> If the problem is that inventory data could get very large and you want to
> manage separate storage for it, have you considered using a DBMS that
> provides partitioned tables?
>
> Cheers
>
> Paul Foxworthy
>
>
> On 20 March 2018 at 02:23, 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
> > >
> > >
> >
>
>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: [hidden email]
> Hey paul,

This is not outside data into ofbiz. We want to manage inventory data as seperate database so that we can have  differentiate databases for both transactional(order/product) and inventory process.

Which will help us improving performance in the ofbiz  application. Earlier it worked for us with Communication tables which has no dependency for  partition to different DB.

Thanks & Regards
Jaya
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Rajesh Mallah
In reply to this post by jayachandra02@gmail.com
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
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Rishi Solanki
Hi Jayachandra,

Register new group in entityengine.xml with new name and data resource;

<group-map group-name="your.group.name"
datasource-name="yourDataResourceName"/>

Add new data resource entry in the entityengine.xml like we have many. In
your case entityengine will contains two entry as localmysql and
localmysql2 (or any name you prefer).
Now register all the entities with "your.group.name" in entity-group.xml.

Refer <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localderbytenant"/> and related entries for more details.


HTH!




Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Tue, Mar 20, 2018 at 3:45 PM, 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
> >
> >
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Paul Foxworthy
On 25 March 2018 at 01:58, Rishi Solanki <[hidden email]> wrote:


> Register new group in entityengine.xml with new name and data resource;
>
> <group-map group-name="your.group.name"
> datasource-name="yourDataResourceName"/>
>
> Add new data resource entry in the entityengine.xml like we have many. In
> your case entityengine will contains two entry as localmysql and
> localmysql2 (or any name you prefer).
> Now register all the entities with "your.group.name" in entity-group.xml.
>
> Refer <group-map group-name="org.apache.ofbiz.tenant"
> datasource-name="localderbytenant"/> and related entries for more details.
>

Thanks Rishi.

If you do define a new group, does that mean:

- any transaction that modifies entities in two different groups will be
slower as the transaction must be a distributed transaction with two-phase
commit? To put it another way, with good design decisions, entity groups
may well give you  faster reads, but writes very likely won't be?
- Foreign key constraints and thus guaranteed referential integrity might
not be possible between groups because not all DBMSes support FKs that
refer to another database?

Thanks

Paul Foxworthy

--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]
--
Coherent Software Australia Pty Ltd
http://www.coherentsoftware.com.au/

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Rishi Solanki
Paul,

Thank you for your reply and more insights. I was just trying to tell the
group OFBiz capabilities that how quickly entities can be separated among
databases if required (not to everyone but to those who are newer). And yes
in that case CRUD would be slower and only gains is in reads.

If we talk about FKs, I did this in past and in case of mysql it maintain
the FKs the referential integrity among different db. I do agree with you
on the fact that, this is not good idea to have more database, instead
OFBiz supports many ways to retrieve the data way faster rather separating
the database.

So rather that using the separate database, considering the flat
information storage would be better idea IMO for faster read.

Best Regards,


Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <[hidden email]> wrote:

> On 25 March 2018 at 01:58, Rishi Solanki <[hidden email]> wrote:
>
>
> > Register new group in entityengine.xml with new name and data resource;
> >
> > <group-map group-name="your.group.name"
> > datasource-name="yourDataResourceName"/>
> >
> > Add new data resource entry in the entityengine.xml like we have many. In
> > your case entityengine will contains two entry as localmysql and
> > localmysql2 (or any name you prefer).
> > Now register all the entities with "your.group.name" in
> entity-group.xml.
> >
> > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > datasource-name="localderbytenant"/> and related entries for more
> details.
> >
>
> Thanks Rishi.
>
> If you do define a new group, does that mean:
>
> - any transaction that modifies entities in two different groups will be
> slower as the transaction must be a distributed transaction with two-phase
> commit? To put it another way, with good design decisions, entity groups
> may well give you  faster reads, but writes very likely won't be?
> - Foreign key constraints and thus guaranteed referential integrity might
> not be possible between groups because not all DBMSes support FKs that
> refer to another database?
>
> Thanks
>
> Paul Foxworthy
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: [hidden email]
>
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

jayachandra02@gmail.com


On 2018/03/26 05:00:58, Rishi Solanki <[hidden email]> wrote:

> Paul,
>
> Thank you for your reply and more insights. I was just trying to tell the
> group OFBiz capabilities that how quickly entities can be separated among
> databases if required (not to everyone but to those who are newer). And yes
> in that case CRUD would be slower and only gains is in reads.
>
> If we talk about FKs, I did this in past and in case of mysql it maintain
> the FKs the referential integrity among different db. I do agree with you
> on the fact that, this is not good idea to have more database, instead
> OFBiz supports many ways to retrieve the data way faster rather separating
> the database.
>
> So rather that using the separate database, considering the flat
> information storage would be better idea IMO for faster read.
>
> Best Regards,
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <[hidden email]> wrote:
>
> > On 25 March 2018 at 01:58, Rishi Solanki <[hidden email]> wrote:
> >
> >
> > > Register new group in entityengine.xml with new name and data resource;
> > >
> > > <group-map group-name="your.group.name"
> > > datasource-name="yourDataResourceName"/>
> > >
> > > Add new data resource entry in the entityengine.xml like we have many. In
> > > your case entityengine will contains two entry as localmysql and
> > > localmysql2 (or any name you prefer).
> > > Now register all the entities with "your.group.name" in
> > entity-group.xml.
> > >
> > > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > > datasource-name="localderbytenant"/> and related entries for more
> > details.
> > >
> >
> > Thanks Rishi.
> >
> > If you do define a new group, does that mean:
> >
> > - any transaction that modifies entities in two different groups will be
> > slower as the transaction must be a distributed transaction with two-phase
> > commit? To put it another way, with good design decisions, entity groups
> > may well give you  faster reads, but writes very likely won't be?
> > - Foreign key constraints and thus guaranteed referential integrity might
> > not be possible between groups because not all DBMSes support FKs that
> > refer to another database?
> >
> > Thanks
> >
> > Paul Foxworthy
> >
> > --
> > Coherent Software Australia Pty Ltd
> > PO Box 2773
> > Cheltenham Vic 3192
> > Australia
> >
> > Phone: +61 3 9585 6788
> > Web: http://www.coherentsoftware.com.au/
> > Email: [hidden email]
> >
>


Hi Rishi,

Thanks for your reply on this.

As i said different entity groups allow us  to make different database with set of entities. And we have done successfully for communication event related tables.

As you said about FKs thats absolutely right about referential integrity among different db in mysql.

Coming to the CRUD operations with different groups : ofbiz will create DB datasource for each group and maintain the connection pool and perform the CRUD operations. While performing ofbiz delegator  uses the group related datasource connection perform the actions and its depend on the  DB how quickly respond.

With CommunicationEvent related group in our case was performing good and not have the issue with writing how ever it's totally different process from order/product info.

Now issue is when we want read data from view entity(tables are in differents groups(databases)) then ofbiz only uses primary db connection and throwing another table not available error.


Like communication event to different for inventory we have so many dependent view entities in ofbiz.

So looking for solution to maintain this facility data as separtion from the actual process.


Thanks & Regards
Jaya



 
Reply | Threaded
Open this post in threaded view
|

Re: Separation database for inventory module

Rishi Solanki
Jaya,

How do you register the group under delegator?

If it is under same delegator then it shouldn't be problem ideally. And if
it is different then you should try to register all groups under the same
delegator then it should work.



Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co

On Mon, Mar 26, 2018 at 12:29 PM, [hidden email] <
[hidden email]> wrote:

>
>
> On 2018/03/26 05:00:58, Rishi Solanki <[hidden email]> wrote:
> > Paul,
> >
> > Thank you for your reply and more insights. I was just trying to tell the
> > group OFBiz capabilities that how quickly entities can be separated among
> > databases if required (not to everyone but to those who are newer). And
> yes
> > in that case CRUD would be slower and only gains is in reads.
> >
> > If we talk about FKs, I did this in past and in case of mysql it maintain
> > the FKs the referential integrity among different db. I do agree with you
> > on the fact that, this is not good idea to have more database, instead
> > OFBiz supports many ways to retrieve the data way faster rather
> separating
> > the database.
> >
> > So rather that using the separate database, considering the flat
> > information storage would be better idea IMO for faster read.
> >
> > Best Regards,
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <[hidden email]>
> wrote:
> >
> > > On 25 March 2018 at 01:58, Rishi Solanki <[hidden email]>
> wrote:
> > >
> > >
> > > > Register new group in entityengine.xml with new name and data
> resource;
> > > >
> > > > <group-map group-name="your.group.name"
> > > > datasource-name="yourDataResourceName"/>
> > > >
> > > > Add new data resource entry in the entityengine.xml like we have
> many. In
> > > > your case entityengine will contains two entry as localmysql and
> > > > localmysql2 (or any name you prefer).
> > > > Now register all the entities with "your.group.name" in
> > > entity-group.xml.
> > > >
> > > > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > > > datasource-name="localderbytenant"/> and related entries for more
> > > details.
> > > >
> > >
> > > Thanks Rishi.
> > >
> > > If you do define a new group, does that mean:
> > >
> > > - any transaction that modifies entities in two different groups will
> be
> > > slower as the transaction must be a distributed transaction with
> two-phase
> > > commit? To put it another way, with good design decisions, entity
> groups
> > > may well give you  faster reads, but writes very likely won't be?
> > > - Foreign key constraints and thus guaranteed referential integrity
> might
> > > not be possible between groups because not all DBMSes support FKs that
> > > refer to another database?
> > >
> > > Thanks
> > >
> > > Paul Foxworthy
> > >
> > > --
> > > Coherent Software Australia Pty Ltd
> > > PO Box 2773
> > > Cheltenham Vic 3192
> > > Australia
> > >
> > > Phone: +61 3 9585 6788
> > > Web: http://www.coherentsoftware.com.au/
> > > Email: [hidden email]
> > >
> >
>
>
> Hi Rishi,
>
> Thanks for your reply on this.
>
> As i said different entity groups allow us  to make different database
> with set of entities. And we have done successfully for communication event
> related tables.
>
> As you said about FKs thats absolutely right about referential integrity
> among different db in mysql.
>
> Coming to the CRUD operations with different groups : ofbiz will create DB
> datasource for each group and maintain the connection pool and perform the
> CRUD operations. While performing ofbiz delegator  uses the group related
> datasource connection perform the actions and its depend on the  DB how
> quickly respond.
>
> With CommunicationEvent related group in our case was performing good and
> not have the issue with writing how ever it's totally different process
> from order/product info.
>
> Now issue is when we want read data from view entity(tables are in
> differents groups(databases)) then ofbiz only uses primary db connection
> and throwing another table not available error.
>
>
> Like communication event to different for inventory we have so many
> dependent view entities in ofbiz.
>
> So looking for solution to maintain this facility data as separtion from
> the actual process.
>
>
> Thanks & Regards
> Jaya
>
>
>
>
>