CN112527773A - Data model and view standardization method and system based on DBVC (database-based virtual machine) framework - Google Patents

Data model and view standardization method and system based on DBVC (database-based virtual machine) framework Download PDF

Info

Publication number
CN112527773A
CN112527773A CN202011464847.7A CN202011464847A CN112527773A CN 112527773 A CN112527773 A CN 112527773A CN 202011464847 A CN202011464847 A CN 202011464847A CN 112527773 A CN112527773 A CN 112527773A
Authority
CN
China
Prior art keywords
view
data model
data
node
instance
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202011464847.7A
Other languages
Chinese (zh)
Other versions
CN112527773B (en
Inventor
罗利明
杨中华
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chengdu Chiyu Interactive Technology Co ltd
Original Assignee
Chengdu Chiyu Interactive Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Chengdu Chiyu Interactive Technology Co ltd filed Critical Chengdu Chiyu Interactive Technology Co ltd
Priority to CN202011464847.7A priority Critical patent/CN112527773B/en
Publication of CN112527773A publication Critical patent/CN112527773A/en
Application granted granted Critical
Publication of CN112527773B publication Critical patent/CN112527773B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • G06F16/212Schema design and management with details for data modelling support
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2393Updating materialised views
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2457Query processing with adaptation to user needs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/30Creation or generation of source code
    • G06F8/36Software reuse

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Computational Linguistics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Fuzzy Systems (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data model and view standardization method and system based on a DBVC (digital video coding) framework, which comprises the following steps of: s1, storing a data model instance to a database node through a memory database, and adding the attribute of the instance to a child node of the instance node; s2, establishing a data model agent through a data model instance node, and performing attribute addition, deletion, modification and query operations on the instance; s3, associating the view with the data model by configuring view information; and S4, assembling through multiple views, and displaying the data model. By the method, the data model is standardized, the definition and storage of the data model are independent of a platform and a language, and the analysis and communication of business requirements are facilitated; and the views are modularized and standardized, the views are assembled through the view components, and each platform can be used for displaying all data models only by realizing the basic view components, so that the repeated coding of the view layers is reduced.

Description

Data model and view standardization method and system based on DBVC (database-based virtual machine) framework
Technical Field
The invention relates to the field of data storage, in particular to a data model and view standardization method and system based on a DBVC (database virtual machine) framework.
Background
In our daily life, work and study, various kinds of information are generated all the time, and the information needs a certain carrier to be stored after being generated, and the database plays an important role in the information. The database is a warehouse for storing data, and the warehouse organizes, stores and manages the data according to a data structure set by people, so that the data can be more conveniently reserved and used. In the current era of and with computing and big data, more and more non-relational databases are emerging. According to different data storage positions, the database is divided into a disk database and an in-memory database from a large direction. Compared with the disk database, the memory database mainly has the advantages of easy expansion, low cost and higher advantages than a relational database in the fields of high performance, high concurrency and rapid service development.
The MVC (Model: service data and service logic at the same time; View: Model visualization through UI component of platform; Controller: receiving user operation, modifying Model and refreshing View) framework is a software design Model, codes are organized by a method of separating service logic, data and interface display, the service logic is gathered into a component, and the service logic does not need to be rewritten while the interface is improved and customized and the user interaction is carried out.
With the rapid development of Internet technology, the software development based on the MVC design pattern is widely applied in the design and implementation processes of application systems, and the MVC design concept has many advantages, but also has the following disadvantages:
(1) MVC and the improved framework thereof do not have a unified standard for establishing a data model, and only separate business logic from views in different modes, but have larger workload for coding the data model and the views, thereby having higher requirements on developers;
(2) MVC is developed in a desktop application era, a data model is mainly subjected to data synchronization with a local file or a relational database, the structuralization of the data model is emphasized, and the requirements of unstructured and unpredictable data are difficult to process;
(3) although the view can be independent of data and service changes, the view layer is difficult to standardize due to the fact that a data model is not standard, and only the data and the service are not influenced but are influenced by the data and the service.
Disclosure of Invention
The invention aims to provide a data model based on a DBVC (database video coding) framework, a view standardization method and a view standardization system, aiming at solving the problems that the view layer cannot be standardized due to the fact that the data model of the conventional MVC framework has no unified standard and the like.
The invention is realized by the following technical scheme:
a data model and view standardization method based on a DBVC framework comprises the following steps:
s1, storing the data model instance to the database node through the memory database, and adding the attribute of the instance to the child node of the instance node;
s2, establishing a data model agent through data model instance nodes, and performing addition, deletion, modification and query operations on the attributes of the instance;
s3, associating the view with the data model by configuring the view information;
and S4, assembling through multiple views, and displaying the data model.
Further, the step S3 further includes the following sub-steps:
s301, configuring data query information of the view;
s302, configuring data attribute information of the view;
s303, acquiring a data node from a database according to the view data query information in the step S301, and acquiring a child node as a parameter from the data node according to the view data attribute information in the step S302;
and S304, taking the parameters as the interface refreshing parameters of the view.
Further, when the data querier queries the data nodes in the memory database, the data querier searches through the following two non-sequential execution modes:
A. accessing the value through a path formed by keys from the node where the value is located to the root node;
B. and performing query filtering statistical operation through SQL statements.
Further, the step A is used for querying the nodes of the non-array type; the step B is used for inquiring the group type node.
Further, the assembly of the view in step S4 is performed by a visual editor, and editing and generating a configuration are performed, and the assembly is completed at runtime.
A DBVC framework-based data model, view normalization system, comprising:
a data persistence layer: loading and storing the memory database;
a memory database: receiving an operation request sent by a service logic layer, updating a data model instance, sending data change information to the service logic layer, and sending a view updating request to a view layer;
and a service logic layer: establishing a data model agent through a data model instance node, and performing attribute addition, deletion and modification operations on the data model instance by receiving a request sent by a controller;
a controller: receiving a user operation request sent by a view layer, and sending a request to a service logic layer;
viewing the image layer: and displaying the data model through various view assembly.
The invention has the beneficial effects that:
(1) the data model is standardized, so that the definition and storage of the data model are independent of a platform and a language, and the analysis and communication of business requirements are facilitated;
(2) view componentization and standardization, due to the standardization of data models, view componentization is possible, views are assembled through view components without customizing views for each data model, each platform can be used for displaying all data models only by realizing basic view components, and the repeated coding of view layers is reduced;
(3) due to the standardization of the data model and the view, the work related to the platform characteristics can be multiplexed among different projects, the realization of the service requirement can be completed only by coding the data model agent and the controller, and the part of work is closely related to the requirement and is easy to understand. Compared with the traditional scheme, the method reduces the coding amount by more than 30% and saves the project development cycle by more than 30%.
Drawings
FIG. 1 is a block flow diagram of the method of the present invention;
FIG. 2 is a system architecture diagram of the present invention;
FIG. 3 is a diagram illustrating a data model code for a login system according to an embodiment of the present invention;
FIG. 4 is a diagram of logging player data model code in accordance with an embodiment of the present invention;
FIG. 5 is a diagram illustrating an agent code for establishing a data model of a login system according to an embodiment of the present invention
FIG. 6 is a system initialization code diagram according to an embodiment of the present invention;
FIG. 7 is a functional development code diagram according to an embodiment of the present invention;
FIG. 8 is a UI diagram of a login interface according to an embodiment of the invention;
FIG. 9 is a schematic diagram of command development code according to an embodiment of the present invention;
FIG. 10 is a diagram of view component development code in accordance with an embodiment of the present invention;
FIG. 11 is a diagram of a view assembly UI for a logon role according to an embodiment of the present invention;
FIG. 12 is a diagram illustrating data change codes according to an embodiment of the present invention;
FIG. 13 is a UI diagram after data change according to an embodiment of the invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to examples and accompanying drawings, and the exemplary embodiments and descriptions thereof are only used for explaining the present invention and are not meant to limit the present invention.
Example 1
As shown in fig. 1, a data model and view standardization method based on a DBVC framework includes the following steps:
s1, storing the data model instance to the database node through the memory database, and adding the attribute of the instance to the child node of the instance node;
s2, establishing a data model agent through data model instance nodes, and performing addition, deletion, modification and query operations on the attributes of the instance;
s3, associating the view with the data model by configuring the view information;
and S4, assembling through multiple views, and displaying the data model.
Further, the step S3 further includes the following sub-steps:
s301, configuring data query information of the view;
s302, configuring data attribute information of the view;
s303, acquiring a data node from a database according to the view data query information in the step S301, and acquiring a child node as a parameter from the data node according to the view data attribute information in the step S302;
and S304, taking the parameters as the interface refreshing parameters of the view.
Further, when the data querier queries the data nodes in the memory database, the data querier searches through the following two non-sequential execution modes:
A. accessing the value through a path formed by keys from the node where the value is located to the root node;
B. and performing query filtering statistical operation through SQL statements.
Further, the step A is used for querying the nodes of the non-array type; the step B is used for inquiring the group type node.
Further, the assembly of the view in step S4 is performed by a visual editor, and editing and generating a configuration are performed, and the assembly is completed at runtime.
Example 2
Based on the principle of the method of embodiment 1, a data model and view standardization system based on a DBVC framework is provided, as shown in fig. 2, including:
a data persistence layer: loading and storing the memory database;
a memory database: receiving an operation request sent by a service logic layer, updating a data model instance, sending data change information to the service logic layer, and sending a view updating request to a view layer; and a service logic layer: establishing a data model agent through a data model instance node, and performing attribute addition, deletion and modification operations on the data model instance by receiving a request sent by a controller;
a controller: receiving a user operation request sent by a view layer, and sending a request to a service logic layer;
viewing the image layer: and displaying the data model through various view assembly.
Example 3
This embodiment is illustrated with a MemDB memory database:
the MemDB memory database is a NoSQL memory database of a key-value dictionary type, and the value type comprises character strings, numerical values, Boolean values, dictionaries, arrays and null. The database starts with a root node under which all data is stored. And accessing the value through a path formed by keys from the node where the value is located to the root node. For the nodes of the array type, query filtering statistical operation can be carried out through SQL statements.
The method comprises the following specific steps:
1. the data model instance is stored under the database node through the memory database, the attribute of the instance is added to the child node of the instance node, and the node can be dynamically added and deleted in the operation period without predefining, so that the unstructured realization of the data model is realized;
2. establishing a data model agent through a data model instance node, performing operations such as addition, deletion, modification and the like on attributes of the instance, and separating data from service logic;
3. the view component completes the display of the interface through the following steps:
(1) data query information for the configuration view;
(2) data attribute information of the configuration view;
(3) the retriever acquires the data node from the database through (1), and acquires the child node from the data node as a parameter according to (2);
(4) taking the parameters as the interface refreshing parameters of the view;
4. due to view componentization, the display of the data model is completed by assembling various views, the assembly of the views is edited by a visual editor and generates configuration, and the assembly is completed by loading in the runtime.
Example 4
The embodiment takes the development of the login system game product of the MMORPG as an example:
1. establishing a login system data model and a login player data model by using a json text through demand analysis;
as in fig. 3, log in the system data model, logic.json;
in FIG. 4, the player data model, region _ user.
2. As shown in fig. 5, a data model agent of the login system is established, and the agent provides an operation interface for the data model to realize the separation of data and service.
3. Initialization system
The specific implementation code for function development is shown in fig. 6, and includes the following steps:
(1) loading a system entry data model to a memory database;
(2) a data model proxy instance is created.
4. Implementing agents
Fig. 7 shows a specific implementation code of the implementation agent, which includes the following steps:
(1) perfecting an operation interface of the agent according to the requirement;
(2) the data is processed through an interface: and operations such as adding, deleting, modifying and the like are performed to complete the management of the data model.
5. Implementing commands
(1) As shown in fig. 8, after the player clicks the "login" button, the operation request is distributed to the command processor through the controller to respond;
(2) as shown in fig. 9, parameters are parsed in the command handler, and a Login interface of the Login agent is called to respond to the operation request.
6. Implementing view components
The implementation code of the view component is shown in fig. 10, and includes the following steps:
(1) the view component is the encapsulation of the UIWidget of the platform;
(2) the view component realizes the display of data by binding one or more fields of the data model;
(3) the view is not limited to displaying the login system, and different data models can be displayed through different field configurations.
7. View assembly
(1) View presentation of a data model is completed by one or more view components;
(2) as in fig. 11, the view assembly of the login role is shown:
an icon component shows the icon field of the role;
the two text components respectively show the name and the lvl fields.
8. Data- > View
(1) The view binds the data to be displayed through the querier;
(2) when the data is filled or changed, the querier will automatically inform the view display data, the view display is as shown in fig. 12 and 13.
The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.

Claims (8)

1. A data model and view standardization method based on a DBVC framework is characterized by comprising the following steps:
s1, storing the data model instance to the database node through the memory database, and adding the attribute of the instance to the child node of the instance node;
s2, establishing a data model agent through data model instance nodes, and performing addition, deletion and modification operations on the attributes of the instance;
s3, associating the view with the data model by configuring the view information;
and S4, assembling through multiple views, and displaying the data model.
2. The data model and view standardization method based on the DBVC framework as claimed in claim 1, wherein the step S3 specifically includes the following sub-steps:
s301, configuring data query information of the view;
s302, configuring data attribute information of the view;
s303, acquiring data nodes from a memory database through data query according to the view data query information in the step S301, and acquiring child nodes from the data nodes as parameters according to the view data attribute information in the step S302;
and S304, taking the parameters as the interface refreshing parameters of the view.
3. The data model and view standardization method based on the DBVC framework as claimed in claim 2, wherein when the data querier queries a data node in the in-memory database, the value is accessed through a path formed by keys from the node where the value is located to the root node.
4. The data model and view standardization method based on DBVC framework as claimed in claim 2, wherein when the data querier queries data nodes in the in-memory database, query filtering statistical operations are performed through SQL statements.
5. The data model and view standardization method based on DBVC framework as claimed in claim 3, wherein said step A is used for querying nodes of non-array type.
6. The data model and view normalization method based on DBVC framework of claim 4, wherein the step B is used for querying the group type node.
7. The method of claim 1, wherein the assembling of the view in step S4 is performed by a visual editor, and the assembly is completed at runtime by editing and generating the configuration.
8. A data model, view standardization system based on DBVC framework, characterized by comprising:
a data persistence layer: loading and storing the memory database;
a memory database: receiving an operation request sent by a service logic layer, updating a data model instance, sending data change information to the service logic layer, and sending a view updating request to a view layer;
and a service logic layer: establishing a data model agent through a data model instance node, and performing attribute addition, deletion and modification operations on the data model instance by receiving a request sent by a controller;
a controller: receiving a user operation request sent by a view layer, and sending a request to a service logic layer;
viewing the image layer: and displaying the data model through various view assembly.
CN202011464847.7A 2020-12-14 2020-12-14 Data model based on DBVC framework, view standardization method and system Active CN112527773B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011464847.7A CN112527773B (en) 2020-12-14 2020-12-14 Data model based on DBVC framework, view standardization method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011464847.7A CN112527773B (en) 2020-12-14 2020-12-14 Data model based on DBVC framework, view standardization method and system

Publications (2)

Publication Number Publication Date
CN112527773A true CN112527773A (en) 2021-03-19
CN112527773B CN112527773B (en) 2024-09-24

Family

ID=74999353

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011464847.7A Active CN112527773B (en) 2020-12-14 2020-12-14 Data model based on DBVC framework, view standardization method and system

Country Status (1)

Country Link
CN (1) CN112527773B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112988124A (en) * 2021-05-10 2021-06-18 湖南高至科技有限公司 Multi-view platform-independent model system

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002006956A2 (en) * 2000-07-19 2002-01-24 Fourbit Group, Inc. Model-view-controller-client architecture for use in a distributed data software application
CN102254029A (en) * 2011-07-29 2011-11-23 株洲南车时代电气股份有限公司 View-based data access system and method
CN104699742A (en) * 2013-12-03 2015-06-10 商业对象软件有限公司 Extreme visualization enabling extension for large data sets
KR101572509B1 (en) * 2014-05-28 2015-11-30 (주)에이시에스 the operating method of user interface framework for web-based application construction
CN108073393A (en) * 2018-01-18 2018-05-25 山东浪潮通软信息科技有限公司 A kind of storage design method based on EF frames

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002006956A2 (en) * 2000-07-19 2002-01-24 Fourbit Group, Inc. Model-view-controller-client architecture for use in a distributed data software application
CN102254029A (en) * 2011-07-29 2011-11-23 株洲南车时代电气股份有限公司 View-based data access system and method
CN104699742A (en) * 2013-12-03 2015-06-10 商业对象软件有限公司 Extreme visualization enabling extension for large data sets
KR101572509B1 (en) * 2014-05-28 2015-11-30 (주)에이시에스 the operating method of user interface framework for web-based application construction
CN108073393A (en) * 2018-01-18 2018-05-25 山东浪潮通软信息科技有限公司 A kind of storage design method based on EF frames

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112988124A (en) * 2021-05-10 2021-06-18 湖南高至科技有限公司 Multi-view platform-independent model system
CN112988124B (en) * 2021-05-10 2021-07-30 湖南高至科技有限公司 Multi-view platform-independent model system

Also Published As

Publication number Publication date
CN112527773B (en) 2024-09-24

Similar Documents

Publication Publication Date Title
US7853553B2 (en) Engine for converting data from a source format to a destination format using user defined mappings
US5749079A (en) End user query facility including a query connectivity driver
US5937409A (en) Integrating relational databases in an object oriented environment
CN105630472B (en) Client rapid development framework of manufacturing execution system and software development method thereof
US6341289B1 (en) Object identity and partitioning for user defined extents
US8635253B2 (en) Decorated model architecture for efficient model-driven application development
US7165073B2 (en) Dynamic, hierarchical data exchange system
US6279008B1 (en) Integrated graphical user interface method and apparatus for mapping between objects and databases
US20140181154A1 (en) Generating information models in an in-memory database system
CN112328212A (en) Rapid development platform based on separation of front end and rear end of engine mode and use method thereof
US20090077091A1 (en) System for development and hosting of network applications
US10296505B2 (en) Framework for joining datasets
CN110990425B (en) JDBC driving method and device of hardware database
WO2007089350A1 (en) Displaying game asset relationships in a game development environment
CN111078205A (en) Modular programming method and device, storage medium and electronic equipment
US6421661B1 (en) Hierarchical query syntax for inquiring and selecting among database objects
US10509632B2 (en) Model augmentation in a model-driven application development environment
CN108228762B (en) Method and system for configuring master database universal templates
WO2023151239A1 (en) Micro-service creation method and related device
US6820268B2 (en) Method for associating data bearing objects with user interface objects
CN112527773B (en) Data model based on DBVC framework, view standardization method and system
CN113761040A (en) Database and application program bidirectional mapping method, device, medium and program product
US7574329B1 (en) Object model for decision and issue tracking
WO2019144852A1 (en) Novel computer programming language
CN115203162A (en) WYSIWYG graph data construction method

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant