CN111538774B - Data storage and display method, system, equipment and storage medium - Google Patents

Data storage and display method, system, equipment and storage medium Download PDF

Info

Publication number
CN111538774B
CN111538774B CN202010326917.6A CN202010326917A CN111538774B CN 111538774 B CN111538774 B CN 111538774B CN 202010326917 A CN202010326917 A CN 202010326917A CN 111538774 B CN111538774 B CN 111538774B
Authority
CN
China
Prior art keywords
data
service
subdata
field
sub
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.)
Active
Application number
CN202010326917.6A
Other languages
Chinese (zh)
Other versions
CN111538774A (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.)
Shanghai Ctrip Business Co Ltd
Original Assignee
Shanghai Ctrip Business 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 Shanghai Ctrip Business Co Ltd filed Critical Shanghai Ctrip Business Co Ltd
Priority to CN202010326917.6A priority Critical patent/CN111538774B/en
Publication of CN111538774A publication Critical patent/CN111538774A/en
Application granted granted Critical
Publication of CN111538774B publication Critical patent/CN111538774B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29—Geographical information databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201—Market modelling; Market analysis; Collecting market data
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Business, Economics & Management (AREA)
  • Finance (AREA)
  • General Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Development Economics (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Engineering & Computer Science (AREA)
  • Game Theory and Decision Science (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Remote Sensing (AREA)
  • Economics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a data storage and display method, a system, equipment and a storage medium, wherein the method comprises the following steps: providing a plurality of pieces of service data; acquiring a service type corresponding to each piece of service data, and extracting a plurality of sub-data respectively belonging to different data fields from each piece of service data; establishing a mapping relation between the subdata and the data domain, and establishing an association relation between a plurality of subdata belonging to the same service data, wherein the association relation records a corresponding relation between the service data and the service type; creating a base table in a database according to the mapping relation and the association relation, storing the service data and the subdata into the base table, and creating a display map on an interactive page; the invention improves the storage efficiency of the service data, enhances the readability of data display and is beneficial to quickly constructing a service platform.

Description

Data storage and display method, system, equipment and storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, a system, a device, and a storage medium for storing and displaying data.
Background
A business system inside a large company generally has a plurality of applications including a system application, a business platform, an underlying data layer, and the like, and the plurality of applications may be called each other. On the other hand, in the prior art, when storing data corresponding to the above-mentioned multiple applications, since the data is large data at the TPB level, a database is generally constructed based on a data warehouse model to store the data. The current data warehouse uses most of the 3NF paradigm modeling methodology or near 3NF paradigm modeling methods such as the IBMFSDM/Teradate silver row bin model.
Using the above method, the non-key information for reduced redundancy in the 3 NF/near 3NF model usually results in data being stored in multiple tables in a scattered manner. When the service uses data, complex JOIN operation (connection operation) is carried out, so that the threshold of using the data by the service is improved invisibly, and the calculation complexity is increased; the star model used by the dimension model cannot ensure the uniqueness of the data, and the data is unavailable, which results in complex processing and low processing efficiency of the processor in the data storage process.
On the other hand, in the prior art, when displaying the call relationship among the plurality of applications, a mesh structure display is generally adopted. However, the above-mentioned method for displaying a mesh structure is not readable at first, and as the business grows, the relationship network becomes more and more complex. Secondly, the mesh structure is not conducive to repeatedly constructing service platforms or system applications, and technical precipitation cannot be achieved. When a system front-end application or a service platform needs to be supported quickly, applications which need to be relied on at the bottom layer cannot be screened out quickly.
Disclosure of Invention
The invention aims to provide a data storage and display method, a system, equipment and a storage medium, aiming at solving the problems that the data storage efficiency is low and the calling relation among applications is displayed by adopting a mesh structure in the prior art aiming at a plurality of applications called mutually in a business system.
In order to achieve the above object, the present invention provides a data storage and display method, comprising the steps of:
providing a plurality of pieces of service data;
acquiring a service type corresponding to each piece of service data, and extracting a plurality of sub-data respectively belonging to different data fields from each piece of service data;
establishing a mapping relation between the subdata and the data domain, and establishing an association relation between a plurality of subdata belonging to the same service data, wherein the association relation records a corresponding relation between the service data and the service type;
and according to the mapping relation and the incidence relation, creating a base table in a database, storing the service data and the subdata into the base table, and creating a display map on an interactive page.
Preferably, each of the data fields corresponds to a plurality of different scene attributes, each of the sub-data corresponds to a scene attribute, and the mapping relationship records a corresponding relationship between the sub-data and the scene attribute.
Preferably, the data field comprises a first data field, and the method further comprises the steps of:
acquiring service data to be inquired, wherein the service data to be inquired belongs to the first data domain;
acquiring a service type corresponding to the service data to be inquired as a second service type, and a corresponding scene attribute as a second scene attribute;
querying second subdata which belongs to the second service type and belongs to the second scene attribute from the library table;
according to the incidence relation, inquiring the other subdata related to the second subdata from the library table;
and processing the rest subdata according to a preset format, and then displaying the subdata in the display map.
Preferably, the data field includes a second data field, a third data field and a fourth data field; the extracting a plurality of subdata respectively belonging to different data domains from each piece of service data includes:
and extracting first subdata belonging to a second data domain, second subdata belonging to a third data domain and third subdata belonging to a fourth data domain from each piece of service data.
Preferably, the scene attributes corresponding to the subdata in at least two of the data domains are determined by a plurality of different sub-scene attributes, the sub-scene attributes include data service attributes or team attributes, and the data service attributes are a commodity domain, a transaction domain, a marketing domain, a user domain, a merchant domain, a content domain or a fund domain; the team attributes are basic middleboxes, platform users, or platform services.
Preferably, the display map is used for respectively displaying the sub data, the service type, the data field and the scene attribute in the interactive page according to different page display formats.
Preferably, the displaying the remaining sub-data in the display map after being processed according to a preset format includes:
and highlighting the rest subdata as background colors according to preset colors, and displaying the background colors in the display map.
The invention also provides a data storage and display system, which is used for realizing the data storage and display method and comprises the following steps:
the service data providing module is used for providing a plurality of pieces of service data;
the subdata extraction module is used for acquiring the service type corresponding to each piece of service data and extracting a plurality of subdata respectively belonging to different data fields from each piece of service data;
a mapping and association relationship establishing module, configured to establish a mapping relationship between the sub-data and the data domain, and establish an association relationship between multiple sub-data belonging to the same service data, where the association relationship records a corresponding relationship between the service data and the service type;
and the data storage and display module is used for creating a base table in a database according to the mapping relation and the incidence relation, storing the service data and the subdata into the base table, and creating a display map on the interactive page.
The invention also provides a data storage and display device, comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of any of the above data storage and presentation methods via execution of the executable instructions.
The present invention also provides a computer-readable storage medium for storing a program which, when executed, implements the steps of any of the above data storage and presentation methods.
Compared with the prior art, the invention has the following advantages and prominent effects:
the data storage and display method, the system, the equipment and the storage medium provided by the invention determine a plurality of subdata belonging to different data fields, the incidence relation among the subdata and the mapping relation between the subdata and the data fields based on the service data, and store the subdata into the base table based on the incidence relation and the mapping relation, thereby reducing the calculation complexity of the service data and improving the data storage efficiency. On the other hand, the display of the internal calling relation of the service data in the form of a display map is realized, the readability is enhanced, the repeated construction of a service platform is facilitated, and the development efficiency of the service platform is improved.
Drawings
Other features, objects and advantages of the present invention will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, with reference to the accompanying drawings.
FIG. 1 is a schematic flow chart of a data storage and display method according to an embodiment of the present invention;
FIG. 2 is a schematic illustration of a display map generated in an embodiment of the present invention;
FIG. 3 is a schematic structural diagram of a data storage and display system according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a data storage and display apparatus according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a computer-readable storage medium according to an embodiment of the disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The same reference numerals in the drawings denote the same or similar structures, and thus their repetitive description will be omitted.
As shown in fig. 1, an embodiment of the present invention discloses a data storage and display method, which includes the following steps:
and S10, providing a plurality of pieces of service data. In particular, the business data is data obtained from technical products. The technical product can realize a certain service closed loop (without an operation interface), complete service abstraction, provide service for similar services and access through the middle station. The middle platform product can be expanded and customized according to the requirement, the output of different service objects (different identities) can be controlled, and the mutual influence is kept.
S20, obtaining the service type corresponding to each piece of service data, and extracting a plurality of subdata respectively belonging to different data domains from each piece of service data. Subdata of different data fields follows a dependency principle to define the dependency relationship between products. The dependency of the upper layer is only directed to the lower layer, which may not know anything about the upper layer. A high cohesion, low coupling product relationship is formed.
Specifically, the service type may be at least one of a business travel fare control online system, a hotel operation system set, a content operation system set, a communication operation system set, a picture content management system set, and an air ticket operation system.
The data field is plural. Each subdata corresponds to a data field. Specifically, for example, a plurality of sub-data such as an instant messaging service desk, a messaging management, a user information service, etc. are extracted from one service data. Each subdata under one service data belongs to one data field.
Referring to fig. 2, as a preferred embodiment of the present application, the data fields include a second data field 22, a third data field 23, and a fourth data field 24, where 22 in fig. 2 represents the second data field, 23 represents the third data field, and 24 represents the fourth data field. The extracting a plurality of subdata respectively belonging to different data domains from each piece of service data includes:
from each of the service data, first sub-data belonging to the second data field 22, second sub-data belonging to the third data field 23, and third sub-data belonging to the fourth data field 24 are extracted.
The sub-data of the second data field 22 depends on the sub-data of the third data field 23 and the sub-data of the fourth data field 24. The sub-data of the third data field 23 depends on the sub-data of the fourth data field 24.
The service types in this embodiment include a communication operation system and an airline ticket operation system.
The subdata of the second data field 22 is a product set of a presentation layer, is mainly responsible for processing interaction of a user interface or other systems, and communicates with subdata of a service layer, namely the third data field 23, so that a served scene and a served end can be determined. The subdata of the third data field 23 performs service logic processing according to the requirements of front-end application, grasps relevant service rules, realizes certain service closed loop, and completes the dependent work on the data layer. The sub data of the fourth data field 24. The management of data (database) in a certain field is completed, the attribution of the data is determined, the read-write logic is unified, and the read-write rules of different service capabilities can be set. The second data field 22 may be a front-end application layer, the third data field 23 may be a service platform layer, and the fourth data field 24 may be a data layer.
S30, establishing a mapping relation between the subdata and the data domain, and establishing an association relation between a plurality of subdata belonging to the same service data, wherein the association relation records a corresponding relation between the service data and the service type.
Specifically, for example, as can be seen from the step S20, each piece of sub-data corresponds to a data field one to one, and then a mapping relationship between the piece of sub-data and the data field is established.
Since a plurality of subdata can be extracted from one service data, an association relationship can be established between the plurality of subdata belonging to the same service data. For example, referring to fig. 2, three sub-data of the instant messaging service desk, the messaging management and the user information service can establish an association relationship of the instant messaging service desk, the messaging management and the user information service.
The service type corresponding to the service data to which the three subdata belong is a communication operation system set. Then the association relation records the corresponding relation between the service data and the communication operation system set.
S40, according to the mapping relation and the incidence relation, creating a base table in a database, storing the subdata into the base table, and creating a display map on an interactive page. Moreover, the mapping relationship and the association relationship need to be stored in a library table. The presentation map created on the interactive page is shown in fig. 2.
Through the display map, the upstream and downstream dependency relationship of the technical products corresponding to the data domains of different levels can be seen, and multi-dimensional screening including the data domains, the scene attributes and the team attributes can be provided at the same time. Second, when a new service needs to be supported quickly, reusable technical products and their lower layer dependencies can be found from the existing service scenarios and data fields. Thirdly, a measurement standard for measuring the reusability of the technical product is provided, that is, the more comprehensive the supported service types and scene attributes are, the higher the reusability of the technical product corresponding to the data field is.
As a preferred implementation manner of the present application, with reference to fig. 2, on the basis of the foregoing embodiment, each data field corresponds to a plurality of different scene attributes, each sub-data corresponds to a scene attribute, and the mapping relationship records a corresponding relationship between the sub-data and the scene attribute.
Specifically, for example, in fig. 2, the second data field 22 includes a plurality of scenario attributes such as user pre-transaction-order-placement, merchant-large client-rule, platform operation-end operation-air ticket, and the like. The third data field 23 includes a plurality of scene attributes such as a basic middle stage, a platform virtual team, a platform service, and artificial intelligence. The fourth data field 24 includes a plurality of scene attributes, such as transaction field-platform user, user field-platform service, communication field-platform service, etc.
As a preferred embodiment of the present application, the data field comprises a first data field. The first data field in this embodiment may be a front-end application. The first data field is substantially the same data field as the second data field 22. The data storage and display method disclosed in this embodiment further includes the steps of:
s50, acquiring service data to be inquired, wherein the service data to be inquired belongs to the first data domain. Specifically, the service data to be queried is a new service that the user needs to develop and support. By acquiring the first data domain to which the business data to be queried belongs, the method and the device are convenient for finding out and constructing the business platform on which the business data to be queried needs to depend at the bottom layer and the technical products corresponding to the data layers from the database after the business type corresponding to the business data to be queried is acquired subsequently.
S60, acquiring a service type corresponding to the service data to be inquired as a second service type, and acquiring a corresponding scene attribute as a second scene attribute. Specifically, a plurality of scene attributes exist in the first data field to which the service data to be queried belongs, and only when the scene attribute corresponding to the service data to be queried is obtained, sub-data belonging to the same data field and the same service type as the service data to be queried in the database table of the database can be uniquely determined with the second service type, and then other sub-data associated with the sub-data are queried to serve as a repeatable technical product.
S70, second subdata which belongs to the second service type and belongs to the second scene attribute is inquired from the base table.
S80, according to the association relation, inquiring the rest subdata related to the second subdata from the library table. Specifically, as can be seen from step S30, a plurality of sub-data belonging to the same service data are associated with each other to form an association relationship. The association relationship indicates that a dependency relationship is formed between the sub data located at the upper layer and the sub data located at the lower layer. And querying the rest subdata related to the second subdata, namely querying the rest subdata depended by the second subdata. The bottom layer technology corresponding to the sub data can be used as the bottom layer technology for multiplexing the service data to be inquired.
And S90, processing the rest subdata according to a preset format, and displaying the subdata in the display map. The display map is used for respectively displaying the subdata, the service type, the data field and the scene attribute in the interactive page according to different page display formats. Different page display formats are different background colors.
After the processing of the rest of the subdata according to a preset format, displaying the subdata in the display map, wherein the displaying comprises:
and highlighting the rest subdata as background colors according to preset colors and displaying the background colors in the display map.
In another embodiment, the scene attributes corresponding to the subdata in at least two of the data fields are determined by a plurality of different sub-scene attributes, the sub-scene attributes include data service attributes or team attributes, and the data service attributes are a commodity domain, a transaction domain, a marketing domain, a user domain, a merchant domain, a content domain or a fund domain; the team attributes are basic middleboxes, platform users, platform services or vacation artificial intelligence.
It should be noted that the above embodiments disclosed in the present invention can be implemented individually or in combination, and all of them are within the scope of the present invention.
As shown in fig. 3, the embodiment of the present invention further discloses a data storage and display system 3, which includes:
a service data providing module 31 for providing a plurality of pieces of service data;
a subdata extraction module 32, configured to obtain a service type corresponding to each piece of service data, and extract a plurality of subdata belonging to different data domains from each piece of service data;
a mapping and association relationship establishing module 33, configured to establish a mapping relationship between the subdata and the data field, and establish an association relationship between multiple subdata belonging to the same service data, where the association relationship records a corresponding relationship between the service data and the service type;
and the data storage and display module 34 is configured to create a library table in a database according to the mapping relationship and the association relationship, store the sub-data in the library table, and create a display map on an interactive page.
It will be appreciated that the data storage and display system of the present invention may also include other existing functional modules that support the operation of the data storage and display system. The data storage and presentation system shown in FIG. 3 is only an example and should not impose any limitations on the functionality or scope of use of embodiments of the present invention.
The data storage and display system in this embodiment is used to implement the data storage and display method, so for the specific implementation steps of the data storage and display system, reference may be made to the description of the data storage and display method, and details are not described here.
The embodiment of the invention also discloses data storage and display equipment, which comprises a processor and a memory, wherein the memory stores the executable instruction of the processor; the processor is configured to perform the steps of the data storage and presentation method described above by executing the executable instructions. Fig. 4 is a schematic structural diagram of the data storage and display device disclosed in the present invention. An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 4. The electronic device 600 shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 4, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different platform components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program code, which can be executed by the processing unit 610, so that the processing unit 610 performs the steps according to various exemplary embodiments of the present invention described in the above-mentioned data storage and presentation method section of this specification. For example, processing unit 610 may perform the steps as shown in fig. 1.
The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM) 6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.
The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
Bus 630 can be any bus representing one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. The network adapter 660 may communicate with the other modules of the electronic device 600 via the bus 630. It should be understood that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage platforms, to name a few.
The invention also discloses a computer readable storage medium for storing a program, and the program realizes the steps in the data storage and display method when executed. In some possible embodiments, the various aspects of the present invention may also be implemented in the form of a program product comprising program code means for causing a terminal device to carry out the steps according to various exemplary embodiments of the present invention described in the above-mentioned data storage and presentation method of the present description, when said program product is run on the terminal device.
As shown above, when the program of the computer-readable storage medium of this embodiment is executed, the multiple pieces of sub data belonging to different data fields, the association relationship between the sub data, and the mapping relationship between the sub data and the data fields are determined based on the service data, and the sub data is stored in the library table based on the association relationship and the mapping relationship, so that the calculation complexity of the service data is reduced, and the data storage efficiency is improved. On the other hand, the display of the internal calling relation of the service data in the form of a display map is realized, the readability is enhanced, the repeated construction of the service platform is facilitated, and the development efficiency of the service platform is improved.
Fig. 5 is a schematic structural diagram of a computer-readable storage medium of the present invention. Referring to fig. 5, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In situations involving remote computing devices, the remote computing devices may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to external computing devices (e.g., through the internet using an internet service provider).
The data storage and display method, system, device and storage medium provided by the embodiment of the invention determine a plurality of sub-data belonging to different data fields, the incidence relation between the sub-data and the mapping relation between the sub-data and the data fields based on the service data, and store the sub-data in the base table based on the incidence relation and the mapping relation, thereby reducing the calculation complexity of the service data and improving the data storage efficiency. On the other hand, the display of the internal calling relation of the service data in the form of a display map is realized, the readability is enhanced, the repeated construction of a service platform is facilitated, and the development efficiency of the service platform is improved.
The foregoing is a further detailed description of the invention in connection with specific preferred embodiments and it is not intended to limit the invention to the specific embodiments described. For those skilled in the art to which the invention pertains, numerous simple deductions or substitutions may be made without departing from the spirit of the invention, which shall be deemed to belong to the scope of the invention.

Claims (10)

1. A method for storing and displaying data, the method comprising the steps of:
providing a plurality of pieces of service data;
acquiring a service type corresponding to each piece of service data, and extracting a plurality of sub-data respectively belonging to different data fields from each piece of service data;
establishing a mapping relation between the subdata and the data domain, and establishing an association relation between a plurality of subdata belonging to the same service data, wherein the association relation records a corresponding relation between the service data and the service type;
and according to the mapping relation and the association relation, creating a base table in a database, storing the subdata into the base table, and creating a display map on an interactive page.
2. The data storage and display method of claim 1, wherein each of the data fields corresponds to a plurality of different scene attributes, each of the sub-data corresponds to a scene attribute, and the mapping relationship records a correspondence between the sub-data and the scene attributes.
3. The data storage and presentation method of claim 2, wherein said data fields comprise a first data field, said method further comprising the steps of:
acquiring service data to be inquired, wherein the service data to be inquired belongs to the first data domain;
acquiring a service type corresponding to the service data to be inquired as a second service type, and a corresponding scene attribute as a second scene attribute;
querying second subdata which belongs to the second service type and belongs to the second scene attribute from the library table;
according to the incidence relation, inquiring the rest subdata related to the second subdata from the base table;
and processing the rest subdata according to a preset format, and then displaying the subdata in the display map.
4. The data storage and presentation method of claim 2, wherein said data fields comprise a second data field, a third data field, and a fourth data field; the extracting a plurality of subdata respectively belonging to different data domains from each piece of service data includes:
and extracting first subdata belonging to a second data domain, second subdata belonging to a third data domain and third subdata belonging to a fourth data domain from each piece of service data.
5. The data storage and display method of claim 4, wherein the scene attributes corresponding to the subdata in at least two of the data fields are determined by a plurality of different sub-scene attributes, the sub-scene attributes include data service attributes or team attributes, and the data service attributes are a goods field, a transaction field, a marketing field, a user field, a merchant field, a content field, or a fund field; the team attributes are basic middleboxes, platform users, or platform services.
6. The data storage and presentation method of claim 2, wherein the presentation map is used to present the sub data, the service type, the data field, and the scene attribute in the interactive page according to different page display formats, respectively.
7. The data storage and display method of claim 3, wherein the displaying of the remaining sub-data in the display map after processing the remaining sub-data according to a preset format comprises:
and highlighting the rest subdata as background colors according to preset colors, and displaying the background colors in the display map.
8. A data storage and presentation system for implementing the data storage and presentation method of claim 1, the system comprising:
the service data providing module is used for providing a plurality of pieces of service data;
the subdata extraction module is used for acquiring the service type corresponding to each piece of service data and extracting a plurality of subdata respectively belonging to different data fields from each piece of service data;
a mapping and association relationship establishing module, configured to establish a mapping relationship between the subdata and the data field, and establish an association relationship between multiple subdata belonging to the same service data, where the association relationship records a corresponding relationship between the service data and the service type;
and the data storage and display module is used for creating a base table in a database according to the mapping relation and the association relation, storing the subdata into the base table and creating a display map on the interactive page.
9. A data storage and display device, comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the data storage and presentation method of any one of claims 1 to 7 via execution of the executable instructions.
10. A computer-readable storage medium storing a program which, when executed, performs the steps of the data storage and presentation method of any one of claims 1 to 7.
CN202010326917.6A 2020-04-23 2020-04-23 Data storage and display method, system, equipment and storage medium Active CN111538774B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010326917.6A CN111538774B (en) 2020-04-23 2020-04-23 Data storage and display method, system, equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010326917.6A CN111538774B (en) 2020-04-23 2020-04-23 Data storage and display method, system, equipment and storage medium

Publications (2)

Publication Number Publication Date
CN111538774A CN111538774A (en) 2020-08-14
CN111538774B true CN111538774B (en) 2023-04-18

Family

ID=71978946

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010326917.6A Active CN111538774B (en) 2020-04-23 2020-04-23 Data storage and display method, system, equipment and storage medium

Country Status (1)

Country Link
CN (1) CN111538774B (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112579833B (en) * 2020-12-14 2024-02-23 北京宝兰德软件股份有限公司 Service association relation acquisition method and device based on user operation data
CN113806416B (en) * 2021-03-12 2023-11-03 京东科技控股股份有限公司 Method and device for realizing real-time data service and electronic equipment
CN113191879A (en) * 2021-05-21 2021-07-30 中国工商银行股份有限公司 Data transmission method, device, system and medium based on complex network
CN113434524A (en) * 2021-06-24 2021-09-24 江苏创源电子有限公司 Data integration method and device, electronic equipment and storage medium
CN113849531B (en) * 2021-09-23 2024-03-22 北京百度网讯科技有限公司 Query method and device
CN114722109B (en) * 2022-04-13 2024-02-06 中国电信股份有限公司 Data importing method, system, equipment and storage medium

Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1998041934A1 (en) * 1997-03-17 1998-09-24 British Telecommunications Public Limited Company Re-usable database system
CN105653732A (en) * 2016-02-02 2016-06-08 优品财富管理有限公司 Automatic table establishment method and system based on metadata
CN106844605A (en) * 2017-01-17 2017-06-13 深圳市金证科技股份有限公司 Batch data logical process method and device
CN108647339A (en) * 2018-05-14 2018-10-12 五八有限公司 A kind of dimensionality analysis method, apparatus, equipment and storage medium
CN109800265A (en) * 2018-12-28 2019-05-24 平安科技（深圳）有限公司 Data load method, device, equipment and computer readable storage medium
CN109800234A (en) * 2019-01-25 2019-05-24 苏州科达科技股份有限公司 Service platform database system, upgrade method, equipment and storage medium
CN109815228A (en) * 2018-12-14 2019-05-28 深圳壹账通智能科技有限公司 Creation method, device, computer equipment and the readable storage medium storing program for executing of database table

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1998041934A1 (en) * 1997-03-17 1998-09-24 British Telecommunications Public Limited Company Re-usable database system
CN105653732A (en) * 2016-02-02 2016-06-08 优品财富管理有限公司 Automatic table establishment method and system based on metadata
CN106844605A (en) * 2017-01-17 2017-06-13 深圳市金证科技股份有限公司 Batch data logical process method and device
CN108647339A (en) * 2018-05-14 2018-10-12 五八有限公司 A kind of dimensionality analysis method, apparatus, equipment and storage medium
CN109815228A (en) * 2018-12-14 2019-05-28 深圳壹账通智能科技有限公司 Creation method, device, computer equipment and the readable storage medium storing program for executing of database table
CN109800265A (en) * 2018-12-28 2019-05-24 平安科技（深圳）有限公司 Data load method, device, equipment and computer readable storage medium
CN109800234A (en) * 2019-01-25 2019-05-24 苏州科达科技股份有限公司 Service platform database system, upgrade method, equipment and storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"基于大数据的全业务统一数据中心数据分析域建设研究";朱碧钦 等;《电力信息化》;全文 *

Also Published As

Publication number Publication date
CN111538774A (en) 2020-08-14

Similar Documents

Publication Publication Date Title
CN111538774B (en) Data storage and display method, system, equipment and storage medium
CN110472207A (en) List generation method and device
US20130166602A1 (en) Cloud-enabled business object modeling
CN109522357A (en) A kind of data processing method, device, server and storage medium
US20090244059A1 (en) System and method for automatically generating virtual world environments based upon existing physical environments
CN112528179B (en) Two-dimensional code processing method, system, electronic equipment and storage medium
CN110674227A (en) Method, system, medium and terminal for generating data visualization chart and page
US20130254736A1 (en) Generating a semantic graph that allows a user to intelligently and efficiently connect with people and assets involved in projects
CN110689268B (en) Method and device for extracting indexes
CN112258244B (en) Method, device, equipment and storage medium for determining task to which target object belongs
CN113962597A (en) Data analysis method and device, electronic equipment and storage medium
CN109885610A (en) A kind of abstracting method of structural data, device, electronic equipment and storage medium
CN111435367A (en) Knowledge graph construction method, system, equipment and storage medium
CN116360735A (en) Form generation method, device, equipment and medium
CN113849506A (en) Data import method, device, equipment and medium
CN108536715B (en) Preview page generation method, device, equipment and storage medium
CN110807095A (en) Article matching method and device
CN112784588A (en) Method, device, equipment and storage medium for marking text
WO2023078078A1 (en) Unified data security labeling framework
US9230022B1 (en) Customizable result sets for application program interfaces
US10168999B2 (en) Software object definition and integration
US11640414B2 (en) Generating workflow, report, interface, conversion, enhancement, and forms (WRICEF) objects for enterprise software
CN112887803B (en) Session processing method, device, storage medium and electronic equipment
US20110022440A1 (en) System and method for allocating suppliers using geographical information system and supplier capability
US9424243B1 (en) Mechanism to support composite data models in HTML form

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