mdm database architecture and design

while, the boss has some new products that need to be added with the "height" attribute. Do you feel that the database you designed is growing in this way, will it soon become a maze? So, is there any way to curb this unpredictability, but it is similar to repeated database expansion? I have read Agile Software Development: Principles, models, and practices and I have found a similar example: 7.3 "Copy" pr

,Gmetad,webfrontend. 5,CentreonCentreon is a powerful, distributed it monitoring system that enables monitoring of networks, operating systems, and applications through third-party components: First, it is open source, we can use it for free, and second, its bottom-level uses Nagios as a monitoring software, Nagios writes the monitored data to the database periodically through the Ndoutil module, while Centreon reads the data from the

[Article banquet this article version: V1.0 last modified: 2008.12.09 reprinted please indicate the original article link: http://blog.zyan.cc/post/#/]In July, I wrote an article titled Architecture Design for full-text retrieval (search engine) of tens of millions of data records based on sphsf-+ mysql. The former company's classification information search was based on this

Ajax| Program | architecture | design The 1 browser-side framework is divided into two broad categories : • Application framework: Provides browser functionality, but is often known to include widget abstractions and other parts, and functions primarily around the desktop GUI framework. • Infrastructure Framework: Provides basic plumbing and portable browser abstraction for developers to create content. Typ

In software architecture design, layered structure is the most common and most important structure. Microsoft's recommended layered structure is generally divided into three layers, from the bottom to the following: Data access layer, business logic layer (or to become a domain layer), the presentation layer, as shown in the figure: Fig. 1:3 Layered Structure Data access layer: sometimes called the persis

Internet web site and most enterprise management software is the same as the use of B/s architecture model, but the large public website b/s architecture will be more complex, the requirements of the architects more high, today I would like to chat on my blog on the website I designed b/s technical structure.Whether it is the B/s architecture of enterprise manage

The Design of game servers is quite challenging. The development of game servers has also changed from the previous single-server structure to multi-server architecture, and even the bigworld engine distributed solution has emerged, I recently learned that the Unreal server solution atlas is also a cluster-based approach. Server Load balancer is a complicated issue. We will not talk about bigworld and atl a

The Design of game servers is quite challenging. The development of game servers has also changed from the previous single-server structure to multi-server architecture, and even the bigworld engine distributed solution has emerged, I recently learned that the unreal server solution Atlas is also a cluster-based approach. Server Load balancer is a very complicated issue. We will not talk about the

Access I plan to use the database as the primary data storage, and configure the cache server with the prefix, and write a DB proxy in the program, for MySQL Master read/write splitting and later sharding processing. If you have experience processing MySQL sharding, Please give some suggestions or open-source product recommendations. Ii. single point of failure From the above architecture table, the maste

' buyer ID ', ' coupon_receive_id ' bigint (DEFAULT NULL COMMENT ' coupon ID ', ' order_number ' varchar () DEFAULT NULL COMMENT ' order number ', ' Order_original_amount ' Decimal (12,2) DEFAULT NULL COMMENT ' original Order Amount ', ' Coupon_amount ' Decimal (11,2) DEFAULT NULL COMMENT ' coupon amount ', ' Order_final_amount ' Decimal (12,2) DEFAULT NULL COMMENT ' The order amount after the coupon is deducted ', ' create_time ' datetime DEFAULT NULL COMMENT' Pick up Time ', ' status 'int(2)

[pass]checking server_uuid values [pass]is slave connected to master? [Pass] Check Master information file [pass]checking InnoDB compatibility [pass]checking storage engines compatibility [PASS]CHEC King lower_case_table_names Settings [pass]checking slave delay (seconds behind master) [pass]# ... done.Set the VIP back to Server1 and execute on the Server2 machine:/etc/init.d/keepalived RestartThen perform IP addr on both machines to view the IP binding status.Set up Server2 Atlas backend on-li

[PHP] MVC architecture pattern analysis and design: This article will introduce how to build a micro-framework of MVC to understand the three-layer architecture and relationship of MVC (model-view-control ).Introduction to Model-View-Control (MVC) In order to better differentiate the development of different functional layers so that people with different experti

Big Data Architecture Design Principles The functional modules can be divided: Data Standards (Data Standard Dictionary and data process specifications ); Data Model (Data topic domain, conceptual model, primary data system, Model Selection ); Data Management System (management specifications and processes, quality control, metadata management, scheduling management, log monitoring) From business nee

achieve a certain degree of scaling, but as the number of site visits gradually increased,Even with separate deployments with minimal granularity, a single server cannot meet the requirements of business size.Therefore, the server cluster must be used to deploy the same service on multiple servers to form a single cluster for the overall external service.Take the search server, for example, if a server can provide 1000 requests per second, that is, QPS (Query Per Second) is 1000.Then if the sit

Because of the working relationship, need to work, need to read the DBF file, find some dbf read open source software, either is too large, still tens of thousands of lines, or functional problems, coding, length, in short, there is no very cool to find. Under the helpless, my old man's anger from the heart, evil to the side of life, decided to write their own. Results only with less than 300 lines of code to take care of, of course, not the only goal, but also elegant and concise to do, the par

We will discuss the implementation of the Short MMS module in the following aspects: [Short MMS] C # Short MMS module development and design (1) -- Architecture (http://www.cnblogs.com/CopyPaster/archive/2012/12/07/2806776.html)[Short MMS] C # Short MMS module development and design (2) -- configuration (http://www.cnblogs.com/CopyPaster/archive/2012/12/10/2811

Note: This document does not provide any suggestions or solutions, but only records my experiences in the architecture design process. Objective: To provide reference for future system architecture design and record the architecture