OrientDB classes / clusters design -

-

i design following using classes , clusters looking logical , efficient solution.

i, have 3 types of users (very different) designed them classes extends user abstract class.

my app based on geoloc. in order give best user experience in matter of response time speed (when performing scans etc..) i'm hesitating between 2 methods :

  1. having each usertype many clusters number of countries, select targetting concerned cluster.

                               _______________________                           | user (abstract class) |                           |_______________________|                                       ^                                       |                                       |  ___________________         ___________________         ___________________ | usertype1 (class) |       | usertype2 (class) |       | usertype3 (class) | |___________________|       |___________________|       |___________________|           |                           |                           |           |                           |                           |     us-cluster_1                us-cluster_2                us-cluster_3     fr-cluster_1                fr-cluster_2                fr-cluster_3     uk-cluster_1                uk-cluster_2                uk-cluster_3

  2. having countryfield each usertype select users filtering it.

                               _______________________                           | user (abstract class) |                           |_______________________|                                       ^                                       |                                       |  ___________________         ___________________         ___________________ | usertype1 (class) |       | usertype2 (class) |       | usertype3 (class) | |                   |       |                   |       |                   | | - countryfield    |       | - countryfield    |       | - countryfield    | |___________________|       |___________________|       |___________________|

    and select * usertype1 countryfield = "us"

what efficient , logical way ?

thank you.

partly depends on record counts , desired response time. in our experience separating data clusters improves query times @ expense of more complexity (managing clusters, different queries, etc.). put couple million records in each cluster , add home-made indexes make query times quick.

you should generate test data , store both ways test query performance vs. requirements. no 2 use-cases ever same.


Comments

Post a Comment

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

-
i need in configuring java on machine because, when try loading forms, loader goes in circles , gives error: java.lang.classnotfoundexception: oracle.apps.fnd.formsclient.formslauncher.class @ sun.plugin2.applet.applet2classloader.findclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass0(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadclass(unknown source) @ java.lang.classloader.loadclass(unknown source) @ sun.plugin2.applet.plugin2classloader.loadcode(unknown source) @ sun.plugin2.applet.plugin2manager.createapplet(unknown source) @ sun.plugin2.applet.plugin2manager$appletexecutionrunnable.run (unknown source) @ java.lang.thread.run(unknown source) i have tried re-installing firefox, older versions of java runtime environments, disabling proxy. what missing? application working on other machines. i spent around 100 hours finding s
Read more

c# - how to use buttonedit in devexpress gridcontrol -

-
Image
i trying create gridcontrol buttonedit in 1 of columns. when user clicks button edit, popups form select product. when selection done on popup, returns datarow selection main grid below. but when column loses focus, value wrote column disappear. here code creates gridcontrol's data , buttonedit's click event. private void frmsiparisnew_load(object sender, eventargs e) { dt = new datatable(); dt.columns.add("malzeme_kodu",typeof(string)); dt.columns.add("malzeme_aciklama", typeof(string)); dt.columns.add("adet", typeof(decimal)); dt.columns.add("birim", typeof(string)); dt.columns.add("fiyat", typeof(decimal)); dt.columns.add("kur", typeof(string)); dt.columns.add("tutar", typeof(decimal)); datarow dr = dt.newrow(); dt.rows.add(dr); gc.datasource = dt; } private void repositoryitembuttoneditmal
Read more

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -

-
good morning i using angularjs-nvd3-directives, great, having difficulties when setting color of multi bar chart ( http://cmaurer.github.io/angularjs-nvd3-directives/multi.bar.chart.html ). the show legend works well: <div ng-controller="examplectrl"> <nvd3-multi-bar-chart data="exampledata" id="showlegendexample" width="550" height="300" showxaxis="true" showyaxis="true" xaxistickformat="xaxistickformatfunction()" showlegend="true"> <svg></svg> </nvd3-multi-bar-chart> </div> but when add option in conjunction color="colorfunction()" where, var colorarray = ['#ff0000', '#0000ff', '#ffff00', '#00ffff']; $scope.colorfunction = function() { return function(d, i) { return colorarray[i]; }; } the color of cha
Read more