Categories
Database Development

Why is OLAP preferred more over OLTP while analyzing data in warehouse?

As per my understanding, OLTP is basically based on INSERT, UPDATE, DELETE commands, where as OLAP Based on SELECT command. And processing in OLTP is fast relative to OLAP, because UPDATE is faster than SELECT; JOINS in OLAP make this even slower, because of more memory movement. Keeping above in considerations, Then why is it […]

Categories
Database Development

Why is OLAP preferred more over OLTP while analyzing data in warehouse?

As per my understanding, OLTP is basically based on INSERT, UPDATE, DELETE commands, where as OLAP Based on SELECT command. And processing in OLTP is fast relative to OLAP, because UPDATE is faster than SELECT; JOINS in OLAP make this even slower, because of more memory movement. Keeping above in considerations, Then why is it […]

Categories
Ask Chemistry

Confusion in whether the given process would be Reversible or Irreversible

As per my understanding , if an Ideal gas (At a pressure higher than atmospheric pressure) is released suddenly and allowed to expand , it is an Irreversible Process. But in the solution of the given problem , taken from the Thermodynamics section of "300 Creative Problems by Lazlo Holics" , they have found the […]

Categories
Mastering Development

Azure Kubernetes Service- Get kubeconfig for non-admin AD app identity

As per my understanding, Azure Kubernetes Service(AKS) allows getting credentials for admin and user identities. Can the user identity be an AD app or a managed identity? I’m writing .Net code. Can you provide some sample where we can get the user credentials from AKS cluster by using AD app credentials, assuming I have already […]

Categories
Database Development

Connecting to mysql db server from a remote server to a local machine [closed]

As per my understanding, there are two main things to check before connecting to a remote mysql db server. 1. Bind address. 2. Grant privileges. I was able to connect to a remote mysql db server from my Mac, it was easy (mysql -uroot -h x.x.x.x -p) Imagine a scenario for my own learning, I […]

Categories
Database Development

Connecting to mysql db server from a remote server to a local machine

As per my understanding, there are two main things to check before connecting to a remote mysql db server. 1. Bind address. 2. Grant privileges. I was able to connect to a remote mysql db server from my Mac, it was easy (mysql -uroot -h x.x.x.x -p) Imagine a scenario for my own learning, I […]

Categories
Development

Not getting “Array Out Of Bounds Exception” | Python3

I’m confused. Ideally for the following code, as per my understanding, I should get List index out of Bounds Exception, but for some reason, I’m not getting it. Can someone please help me understand as to why or how is the code avoiding this? s = ‘abc’ idx = 3 s_ = s[idx+1:] print(“.”, str(s_), […]

Categories
Development

How can I add a smart dimension between two points in Solidworks drawing view?

I need to add a dimension between two points in a particular view of Solidworks drawing. Note that this dimension is not defined in the sketch and hence cannot be marked for automatic generation. I started by selecting the entities: boolstatus = Part.Extension.SelectByID2(“Base-Revolve@CL_035_S_0800-8@Vista del disegno23/CL_035_XA_19807-1@CL_035_S_0800/CL_035_PER_19809-2@CL_035_XA_19807”, “BODYFEATURE”, 0, 0, 0, True, 0, Nothing, 0) boolstatus = […]

Categories
Cryptocurrency Development Ethereum

Transaction in hyperledger Fabric?

I want to ask how transactions are validated in hyperledger fabric? To explain this I would like to add, as per my understanding, hyperledger fabric is permission project and even only two participants can make a transaction. So in this case (two person are making any transaction) anyone can make changes on later stage so […]

Categories
Development

Regression problem or Classification Problem?

I chose one dataset from kaggle for my class project. this is the link for the dataset. https://www.kaggle.com/iabhishekofficial/mobile-price-classification In this dataset, there are 20 features and one target variable called “Price_range”. This target variable has four categories. Low Price, Medium Price, High Price, Very High Price. Now, this dataset is already encoded as follows: Low […]