Opinion on Architecture approach

I have an MVC3 web app that represents about a dozen different entities, but I have built a common search function so that the user can do a single search and get results from the various entities. It works fine, but as I suspected, the performance is slow because the search is occurring live and there's a lot to search. A cache would be fine even if it was a long one (daily even), but I don't know where and when to actually refresh the cache. If a person uses the search when it's been longer than the cache timeout then it will be really slow for them that one time and that's not acceptable. I'm thinking that I have to have a Windows service in place or something that builds the cache, but perhaps there's a better way that I don't know about. I can't do it entirely in the database because some of the entities don't exist in the database (one entity list is composed by searching through some files on the system for instance). Any help is appreciated.

 Hi,

Is there any tools out there which I can use to produced diagrams like the following

 

http://www.wisedimensions.com/screenshots/intro1.jpg (I am referring to the 3D appearance).  I tried the tool shown in the diagram 3D Visioner, but this does not provide a clear image which I can use on any document.

 

Thanks

Arjuna.

Hi Everybody

  Please let me know which is the best approach for applying business rules from out of

1)windows workflow

2)rule engine without work flow

Please give me the scenarioes where exactly used?

Thanks in advance..my dear friends

 

Hello everyone, I have a question regarding powershell provider architecture. I have a datastore that is both heirarchical and heterogeneous in nature. I.e. there is no single node or leaf type. I would like to navigate and manipulate this data store contextually while providing appropriate actions for each data type encountered. What is the proper way to approach this? Must I create multiple providers that work in concert with each other? Or is the proper approach to have a single provider that checks each type and alters the behavior of each cmdlet override as necessary. I hope I explained this properly. I also hope I placed this in the correct forum :) Thanks for your input.

I need to build a solution (related to sales) that would take an inputed product from a user and then provide alternative products from other manufacturers.  I have a number of predefined product attributes with the values for a given manufacturer. Is this something that is handled thru a data mining algorithm?  My initial thought was to use Association/Market Basket Analysis but I do not need to know what other products were bought by others who purchased a specific product.  My need would be to input a specific product and then get a report(output) that shows similar products from other manufacturers.

Thanks.

I've read several different replication scenarios and technologies native to SQL Server (we are talking about SQL Server 2005) but have some questions.

I have a project to integrate/replicate two network-separated SQL Server 2005 databases.  Each database resides in a physically separate location at different companies.  They will not have a shared network environment and will not allow direct connection between the two databases.

We need to keep each database in sync as far as customer records.  Near real time is preferable.  There is not master.  One could add/delete/modify a customer record in one database and it needs to reflect in the other database. 

 

The closest we could get for connectivity architecture looks like this:

1.  Each database is on the separate internal networks for each company.

2.  Each organization HAS agreed to setup a DMZ on their sides specifically for this exchange.  Each respective DMZ will be able to communicate with their own internal SQL Server and have a fiber connect directly connecting each organization's dmz.

SO.... is there a good way to replicate from InternalSQL_1 - DMZ1 - DMZ2 - InternalSQL_2 near real time?

What would your recommendation be?  Pretty sure I'd setup both internal InternalSQL as Pub/Sub/Dist but I'm soliciting suggestions for transporting across the DMZ's in each direction.

 

Any help would be appreciated

Hi all,

 My requirement is to develop a delpoy a new sharepoint site page with customization to  client.which is best way to give a solution to delploy.

---

Thanks and regards, Anandha Babu M.

Client's current solution is an Access Databases + a number of Excel Reports. We will migrate the database to SQL Server 2008 but what is the most appropriate front end approach for the reporting system?

User wants to run Reports, Dashboards and monitor KPIs, setting target goals for front line staff. Managers to be able to dynamically create new indicators that will auto propogate to the front line people's screens. Reports to be both a set of static pre-defined reports and ability to create own reports (report builder seems obvious option here)

Will be relatively lightweight reporting - no data mining, OLAP cubes, or analytics.

But which tools to use to build the UI? Confused with the number of ways it seems this could be done. Approach it as 1) Sharepoint Business Intelligence project, or 2) use the SQL Server Business Intelligence Development studio, or 3) an ASP.Net project using report builder etc? Any advice on how best to approach this appreciated

Hi everyone, i am curious to know when should be use mvc architecture ?

Thanks,

Hello everyone. I write a new project in Asp.Net Iused Oracle Database. When I used sql server I developed my store procedure call method. And When I write procedure name and parameters store procedure execute than it show me dataTable.This is code

 protected DataTable ExecSp(string procedure)
        {
            if (_connection == null)
                _connection = new SqlConnection(_connStr);

            var cmd = new SqlCommand(procedure) {Connection = _connection, CommandType = CommandType.StoredProcedure};

            var da = new SqlDataAdapter(cmd);
            var dt = new DataTable();
            da.Fill(dt);
            CloseReader();
            return dt;
        }

        protected DataTable ExecSp(string procedure, object parameter)
        {
            if (_connection == null)
                _connection = new SqlConnection(_connStr);

            var cmd = new SqlCommand(procedure) {Connection = _connection, CommandType = CommandType.StoredProcedure};

            if (parameter != null)
            {
                PropertyInfo[] properties = parameter.GetType().GetProperties();
                for (int i = 0; i < properties.Length; i++)
                {
                    PropertyInfo p = properties[i];

                    string name = p.Name;
                    //string value = p.GetValue(parameter, null).ToString();

                    string value = string.Empty;
                    object _value = p.GetValue(parameter, null);
                    if (_value != null) value = _value.ToString();

                    var param = new SqlParameter {ParameterName = name, Value = value};

                    if (p.PropertyType == typeof (int))
                    {
                        param.SqlDbType = SqlDbType.Int;
                    }
                    else if (p.PropertyType == typeof (DateTime))
                    {
                        param.SqlDbType = SqlDbType.DateTime;
                    }

                    cmd.Parameters.Add(param);
                }
            }

            var da = new SqlDataAdapter(cmd);
            var dt = new DataTable();
            da.Fill(dt);
            return dt;
        }

        private void CloseReader()
        {
            if (_connection != null)
                _connection.Close();
        }

And now. How can use this method on oracle? Oracle command and Oracle store Procedures. I try something but when use where condition it give me error for parameter. How can I fix this code for oracle

        private readonly string _connStr =
    WebConfigurationManager.ConnectionStrings["OracleConnectionString"].ConnectionString;

        private OracleConnection _connection;

        public IDataReader ExecuteOracleCommand(string query)
        {
            if (_connection == null)
                _connection = new OracleConnection(_connStr);

            var oracleConnection = new OracleConnection(_connStr);

            var oracleCommand = new OracleCommand(query, oracleConnection) { CommandType = CommandType.Text };
            oracleConnection.Open();
            OracleDataReader reader = oracleCommand.ExecuteReader();

            CloseReader();
            return reader;


        }

Thanks everyone