Large scale business application - Azure cloud database & storage issues -

-

We are making massive, database oriented business applications. This business application is the majority and we want to provide it as a SOA (software as a service) in AZUR Cloud. The blue SQL database limit is only 150 GB which is not enough for us. There is a huge amount of data in our customers, which is likely to increase every year. Our application database is relational and complex and uses complex questions (group, connects, total work), stored procedures to obtain / save data, so we are reluctant to use the Big Table directly. There is a suggestion to break the database in the database and file groups, but we are not going to do this. There is only one possibility that only the current year's data should be restored in the app and in other partitions / backup databases, but it is not in line with our application because previous data is often used. If we use the blue table, then our complex operation will be carried out in memory, which is not possible due to limited memory resources. We are thinking of mixing Azure SQL Database and Azure Table. But we are unable to find any suitable examples that use the mixture of both of us.

We are also looking for answers to the following questions?

  1. On the large scale of relational data (TB) or should we have our own database server to support it?
  2. Should we just use the blue tab and not blue SQL?
  3. Blue SQL and blue table storage? Is there any sample architecture / example that guides about it?

    4. New Standard and Premium Ezur SQL Database SKU now supports 250 GB and 500 GB Are there. Regardless, the Ezur SQL Database is a very large scale model for large amounts of data. There is a preview of an elastic scale facility for the Ezur SQL Database.

    There are good reasons to store the data in the most appropriate location - Azure Tables offers more cost-effective, higher-level storage Blue SQL database does have high-level, semi-structured data in Azure Tables And relational data in the Azure SQL database - of course there are definitely reasons to use each for data.

    1) If you are creating a new application, you should consider the AZUR SQL database for your relational data and only need to go to the SQL Server in the Ezur Virtual Machine if that will not work. While SQL Server is easy to find in a VM, once you start deployment, then things are starting after adding traditional DBA activities. If you have high-level relational requirements then you should consider making comb.

    2) Your preference should not be one or the other, but where appropriate, both of them should be used.

    3) Microsoft Pattern & amp; To help with your architecture, you should see a lot of practices in practice.


Comments

Post a Comment

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr
Read more

javascript - data.match(var) not working it seems -

-
OK, I have this small block code, which is to scanned a number on the website, but for some reason There is a hip that it is not scanning at all. var regenges = / \ & lt; Span class = "currency-robux" data-to-"item-private-value-price" & gt; ([\ D,]) \ & LT; \ / Span \ & gt; /; Var ValueCiling = Data. Match (reggae); Value-song = number (value slicing location (",", "")); Is there anything wrong with that? This is related to the if statement if (value sling and lieutenant; = price watching) { < P> A function calls to move from there, but for some reason it does not seem to run at all. So I think the Regex is wrong but I'm not sure how. (There is a variable in PriceWinking , this is a snippet from the code.) On the website, I'm trying to remove it. & lt; Span class = "robux" data-plus = "item-privatesale-price" & gt; 115 & lt; / Span & gt; Keep in mind
Read more

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -

-
Before I continue to get a jQuery .each loop to wait for user input There is a problem in repeatedly repeating This is my code (I have commented on what I would like to do): & lt; Html xmlns = "http://www.w3.org/1999/xhtml" & gt; & Lt; Top & gt; & Lt; Link rel = "stylesheet" type = "text / css" href = "common_components.css" /> & Lt; Meta http-equiv = "content-type" content = "text / html; charset = UTF-8" /> & Lt; Link rel = "stylesheet" href = "slider.css" & gt; & Lt ;? Php include_once 'common_components.php'; $ Query = $ dbh- & gt; Queries ("SELECT movies_dir FROM settings"); $ Line = $ query- & gt; Obtain (PDO :: FETCH_ASSOC); Date_default_timezone_set ('UTC'); Echo "& lt; title & gt; movie scanner & lt; / title & gt;"; ? & Gt; & Lt; Script src = "jquery.min.js" & gt; &am
Read more