Questions tagged [middle-tier]

Middle-tier refers to the processing that takes place in an application server that sits between the user's machine and the database server.

Middle-tier refers to the processing that takes place in an application server that sits between the user's machine and the database server. The middle tier server performs the business logic. See application server and client/server.

Middle-Tier Architecture

This middle-tier architecture allows the existing database to be the "database of record." At the same time, it also protects the existing database from direct Internet traffic and provides a high performance engine to interact with the Internet traffic. enter image description here

What is Middle-Tier Architecture?

During the client/server days, it was common for a client GUI program to talk directly to a database server. Web applications introduced the three-tier model by default: the browser is the client tier, the database the back-end tier, and the web server and its extensions became the middle tier.

This middle tier offered better scalability options, in terms of connection pooling and stateless high transactional volumes. The architecture that goes into this tier is usually called the middle-tier architecture. The software solutions in the middle tier are called the middleware. There are a lot of good examples of middleware: ColdFusion, PHP, J2EE, .NET, and so on and so forth.

When a typed language like Java or C# is chosen to implement this middle tier, developers tend to create fairly extensive architectures to support their applications.

What Happens in the Middle Tier (Responsibilities)?

The two primary activities in a middle tier are reading and writing data. Reading data involves retrieving the raw data based on input parameters, massaging the data, and delivering the data in the requested format. Writing data involves manipulating the data stored, using certain business rules and processes. In a sense, the write operation changes the state of the database server.

13 questions
3
votes
1 answer

WCF hosting for middle tier

We're developing a new middle tier for our application suite. We're looking to rewrite our business logic and data access layers in C#, as they are currently in VB6 and published via COM+. What we're trying to decide is how exactly to make this…
Zann Anderson
  • 4,767
  • 9
  • 35
  • 56
3
votes
1 answer

Architecture for multitenant middle-tier

We're developing a "middle-tier" to replace an existing business logic/data access layer. One of the design concerns we're under is that we need to design it in a way that allows for multiple customers' databases and/or middle-tier pieces to live…
Zann Anderson
  • 4,767
  • 9
  • 35
  • 56
2
votes
1 answer

Classic ASP app has COM 'middle layer' for light business logic. Is this needed in ASP.NET?

I am trying to estimate how long it will take to migrate a Classic ASP application to .NET and came across hundreds of COM functions written in VB 6. A majority of these functions only do parameter validation and actually calls the SQL server. Is…
makerofthings7
  • 60,103
  • 53
  • 215
  • 448
2
votes
3 answers

Validation in the middle tier

I want to do validation on my business code. I'm thinking of 2 ways to do this. One, do the validation on my class property setters in the following fashion class Student{ public string Name{ get { return _name; } set { …
Ray
  • 12,101
  • 27
  • 95
  • 137
2
votes
1 answer

Data structure/Java Technique for managing a list of sequential commands

I'm not sure if something special exists for this use case - but it felt like a case where someone was likely to have made some sort of useful structure/technique/design-pattern. My Situation I have a set of SQL commands executed from middle tier…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
1
vote
1 answer

Writing middle tier tests for website built using Struts

I have never done any middle tier testing before and I am brand new to Struts. I was assigned the task to find out if it is possible to do middle tier testing of a Struts website and how to do it if it is. I wonder if anyone has experience writing…
user1739658
  • 253
  • 1
  • 3
  • 10
0
votes
1 answer

How to log messages (raw XML) in middle-tier WCF scenario?

I have a client (C) which consume WCF service (S) which is middle-tier service consuming external web service (ES). I have control over the WCF service (S) which I have developed. The test department would like to test the whole scenario: C <-> S…
DevUser
  • 751
  • 2
  • 8
  • 26
0
votes
7 answers

Three tier architecture

I have some questions about three tier architecture. how to implement an application in three tier architecture correctly? how to communicate between these tiers ? Is data tier completely equals to DBMS? (how about in a case if we use stored…
Sency
  • 2,818
  • 8
  • 42
  • 59
0
votes
1 answer

Is it advisable to make a web program to interface to a database-agnostic layer?

I'm a Winforms programmer before; I always partition programs I write in two parts, the front-end(Winforms) and middle-tier(facilitated by Remoting/WCF) On that approach, the front-end code cannot access the Linq or System.Data.SqlClient. But that…
Hao
  • 8,047
  • 18
  • 63
  • 92
0
votes
1 answer

How to send a secure request to a data tier over a firewall

I've been asked to populate a flash file with some data from a database. I said, "Great, I will write some PHP that talks to the database and outputs xml. The swf can call that file." My boss then told me that that solution wouldn't make the cut…
Adam
  • 12,236
  • 9
  • 39
  • 44
0
votes
1 answer

How to create an XPS document in a WCF service to store and return?

I've got a WCF service as middle tier, and on some occasions I need to create a printable document, store it for future reference in the database, and return it to the client. My first choice as file format was XPS, so I'd like to create an XPS…
Sam
  • 28,421
  • 49
  • 167
  • 247
0
votes
1 answer

Moving from a direct db connection per user to using a web-service with pooled connections

I'm working on moving a V.Rich Client from talking direct to the DB with one login per user to talking direct with a WCF service layer. In the new model I'm like the users to authenticate with the middle tier and for the middle tier to us just one…
chillitom
  • 24,888
  • 17
  • 83
  • 118
0
votes
4 answers

Using Postgresql as middle layer. Need opinion

I need some opinions. I'm going to develop a POS and inventory software for a friend. This is a one man small scale project so I want to make the architecture as simple as possible. I'm using Winform to develop the GUI (web interface doesn't make…